public function down()
{
$tables = array('bans', 'user_metadata', 'user_security', 'user_groups', 'users', 'group_permissions', 'groups_users');
foreach ($tables as $table) {
\DBUtil::drop_table($table);
}
}
public function down()
{
\DBUtil::drop_table('scripts_forms_products');
\DBUtil::drop_table('scripts_forms_questions_products');
\DBUtil::drop_table('scripts_forms_responses_products');
\DB::query("ALTER TABLE `scripts_forms` DROP `rebuttal_script`")->execute();
}
function down()
{
// get the configured table name
$table = \Config::get('simpleauth.table_name', 'users');
// drop the users table
\DBUtil::drop_table($table);
}
function down()
{
// get the driver used
\Config::load('auth', true);
$drivers = \Config::get('auth.driver', array());
is_array($drivers) or $drivers = array($drivers);
if (in_array('Simpleauth', $drivers)) {
// get the tablename
\Config::load('simpleauth', true);
$table = \Config::get('simpleauth.table_name', 'users') . '_providers';
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('simpleauth.db_connection', null));
} elseif (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$table = \Config::get('ormauth.table_name', 'users') . '_providers';
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('ormauth.db_connection', null));
}
if (isset($table)) {
// drop the users remote table
\DBUtil::drop_table($table);
}
// reset any DBUtil connection set
\DBUtil::set_connection(null);
}
function down()
{
// get the drivers defined
$drivers = normalize_driver_types();
if (in_array('Simpleauth', $drivers)) {
// get the tablename
\Config::load('simpleauth', true);
$basetable = \Config::get('simpleauth.table_name', 'users');
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('simpleauth.db_connection', null));
} elseif (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$basetable = \Config::get('ormauth.table_name', 'users');
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('ormauth.db_connection', null));
} else {
$basetable = 'users';
}
\DBUtil::drop_table($basetable . '_sessionscopes');
\DBUtil::drop_table($basetable . '_sessions');
\DBUtil::drop_table($basetable . '_scopes');
\DBUtil::drop_table($basetable . '_clients');
// reset any DBUtil connection set
\DBUtil::set_connection(null);
}
public function down()
{
\DBUtil::drop_table('scripts_forms');
\DBUtil::drop_table('scripts_forms_questions');
\DBUtil::drop_table('type_scripts_forms_fields');
\DBUtil::drop_table('scripts_forms_answers');
\DBUtil::drop_table('scripts_forms_answers');
}
public function down()
{
\DBUtil::drop_table('location');
\DBUtil::drop_table('events');
\DBUtil::drop_table('agenda');
\DBUtil::drop_table('countries');
\DBUtil::drop_table('users');
}
/**
* Drop tables: users, options, posts, tags, posts_tags
*/
public function down()
{
\DBUtil::drop_table('users');
\DBUtil::drop_table('options');
\DBUtil::drop_table('posts');
\DBUtil::drop_table('tags');
\DBUtil::drop_table('posts_tags');
}
function down()
{
\DBUtil::drop_table('accounts');
\DBUtil::drop_table('accounts_metadata');
\DBUtil::drop_table('apis');
\DBUtil::drop_table('apis_metadata');
\DBUtil::drop_table('api_stats');
\DBUtil::drop_table('data_calls');
}
public function down()
{
\Config::load('sentry', true);
\DBUtil::drop_table(\Config::get('sentry.table.users'));
\DBUtil::drop_table(\Config::get('sentry.table.groups'));
\DBUtil::drop_table(\Config::get('sentry.table.users_metadata'));
\DBUtil::drop_table(\Config::get('sentry.table.users_groups'));
\DBUtil::drop_table(\Config::get('sentry.table.users_suspended'));
}
public function action_uninstall()
{
if (\DBUtil::table_exists('blog')) {
\DBUtil::drop_table('blog');
}
if (\DBUtil::table_exists('blog_comment')) {
\DBUtil::drop_table('blog_comment');
}
echo 'Uninstall db tables for blog module completed.';
}
function down()
{
\DBUtil::drop_table('manifests');
\DBUtil::drop_table('manifest_datas');
\DBUtil::drop_table('aerodromes');
\DBUtil::drop_table('aircraft_arms');
\DBUtil::drop_table('flight_records');
\DBUtil::drop_table('people');
\DBUtil::drop_table('aircrafts');
\DBUtil::drop_table('manifest_people');
}
function down()
{
// get the driver used
\Config::load('auth', true);
$drivers = \Config::get('auth.driver', array());
is_array($drivers) or $drivers = array($drivers);
if (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$table = \Config::get('ormauth.table_name', 'users');
// drop the admin_users_perms table
\DBUtil::drop_table($table . '_permissions');
}
}
function down()
{
// get the drivers defined
$drivers = normalize_driver_types();
if (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$table = \Config::get('ormauth.table_name', 'users');
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('ormauth.db_connection', null));
// drop the admin_users_perms table
\DBUtil::drop_table($table . '_permissions');
}
// reset any DBUtil connection set
\DBUtil::set_connection(null);
}
function down()
{
// get the driver used
\Config::load('auth', true);
$drivers = \Config::get('auth.driver', array());
is_array($drivers) or $drivers = array($drivers);
if (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$table = \Config::get('ormauth.table_name', 'users');
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('ormauth.db_connection', null));
// drop the admin_users_role table
\DBUtil::drop_table($table . '_roles');
// drop the admin_users_role_perms table
\DBUtil::drop_table($table . '_role_permissions');
}
// reset any DBUtil connection set
\DBUtil::set_connection(null);
}
function down()
{
// get the driver used
\Config::load('auth', true);
$drivers = \Config::get('auth.driver', array());
is_array($drivers) or $drivers = array($drivers);
if (in_array('Simpleauth', $drivers)) {
// get the tablename
\Config::load('simpleauth', true);
$table = \Config::get('simpleauth.table_name', 'users') . '_providers';
} elseif (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$table = \Config::get('ormauth.table_name', 'users') . '_providers';
}
if (isset($table)) {
// drop the users remote table
\DBUtil::drop_table($table);
}
}
function down()
{
// get the driver used
\Config::load('auth', true);
$drivers = \Config::get('auth.driver', array());
is_array($drivers) or $drivers = array($drivers);
if (in_array('Simpleauth', $drivers)) {
// get the tablename
\Config::load('simpleauth', true);
$basetable = \Config::get('simpleauth.table_name', 'users');
} elseif (in_array('Ormauth', $drivers)) {
// get the tablename
\Config::load('ormauth', true);
$basetable = \Config::get('ormauth.table_name', 'users');
} else {
$basetable = 'users';
}
\DBUtil::drop_table($basetable . '_sessionscopes');
\DBUtil::drop_table($basetable . '_sessions');
\DBUtil::drop_table($basetable . '_scopes');
\DBUtil::drop_table($basetable . '_clients');
}
public function down()
{
\DBUtil::drop_table('urls');
}
public function down()
{
\DBUtil::drop_table('users_twitters');
}
public function down()
{
\DBUtil::drop_table('forums');
}
public function down()
{
\DBUtil::drop_table('upload_types');
}
public function down()
{
\DBUtil::drop_table('notes');
}
/**
* remove the sessions table
* php oil r session:remove
*/
public static function remove()
{
// load session config
\Config::load('session', true);
// prompt the user to confirm they want to remove the table.
$iamsure = \Cli::prompt('Are you sure you want to delete the sessions table?', array('y', 'n'));
// if they are sure, then let's drop it
if ($iamsure === 'y') {
\DBUtil::drop_table(\Config::get('session.db.table'));
return \Cli::color('Session database table deleted.', 'green');
}
// if we made it to here, than that means the user said no.
return \Cli::color('Session database table was not deleted.', 'red');
}
public function down()
{
\DBUtil::drop_table('staffs');
}
public function down()
{
\DBUtil::drop_table('survey_responses');
}
public function down()
{
\DBUtil::drop_table('useritems');
}
public function down()
{
\DBUtil::drop_table('comments');
}
public function down()
{
\DBUtil::drop_table('matches_events');
}
public function down()
{
\DBUtil::drop_table('crm_type_ppi_claim_status');
}
public function down()
{
\DBUtil::drop_table('clientarea_messages_posts');
}
