public function down()
{
// load the sentry config file
\Config::load('sentry', true);
// add group table columns level, is_admin and parent
\DBUtil::add_fields(\Config::get('sentry.table.groups'), array('level' => array('constraint' => 11, 'type' => 'int'), 'is_admin' => array('constraint' => 1, 'type' => 'tinyint'), 'parent' => array('constraint' => 11, 'type' => 'int')));
// remove group table column permission
\DBUtil::drop_fields(\Config::get('sentry.table.groups'), array('permissions'));
// remove user table column permission
\DBUtil::drop_fields(\Config::get('sentry.table.users'), array('permissions'));
\DBUtil::modify_fields(\Config::get('sentry.table.users'), array('password' => array('constraint' => 81, 'type' => 'varchar'), 'temp_password' => array('constraint' => 81, 'type' => 'varchar'), 'password_reset_hash' => array('constraint' => 81, 'type' => 'varchar'), 'remember_me' => array('constraint' => 81, 'type' => 'varchar'), 'activation_hash' => array('constraint' => 81, 'type' => 'varchar')));
}
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');
\DBUtil::drop_fields($table . '_permissions', array('actions'));
\DBUtil::drop_fields($table . '_user_permissions', array('actions'));
\DBUtil::drop_fields($table . '_group_permissions', array('actions'));
\DBUtil::drop_fields($table . '_role_permissions', array('actions'));
}
}
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));
\DBUtil::drop_fields($table . '_permissions', array('actions'));
\DBUtil::drop_fields($table . '_user_permissions', array('actions'));
\DBUtil::drop_fields($table . '_group_permissions', array('actions'));
\DBUtil::drop_fields($table . '_role_permissions', array('actions'));
}
// 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);
$basetable = \Config::get('ormauth.table_name', 'users');
// make sure the configured DB is used
\DBUtil::set_connection(\Config::get('ormauth.db_connection', null));
\DBUtil::drop_fields($basetable . '_user_permissions', array('id'));
\DBUtil::create_index($basetable . '_user_permissions', array('user_id', 'perms_id'), '', 'PRIMARY');
\DBUtil::drop_fields($basetable . '_group_permissions', array('id'));
\DBUtil::create_index($basetable . '_group_permissions', array('group_id', 'perms_id'), '', 'PRIMARY');
\DBUtil::drop_fields($basetable . '_role_permissions', array('id'));
\DBUtil::create_index($basetable . '_role_permissions', array('role_id', 'perms_id'), '', 'PRIMARY');
}
// reset any DBUtil connection set
\DBUtil::set_connection(null);
}
public function down()
{
\DBUtil::drop_fields('tomorrow_list_stats', array('dialler'));
}
public function down()
{
\DBUtil::drop_fields('data_supplier_campaign_lists_duplicates', array('lead_id'));
}
public function down()
{
\DBUtil::drop_fields('users', array('deleted_at'));
}
public function down()
{
\DBUtil::drop_fields('comments', array('forum_id'));
}
public function down()
{
\DBUtil::drop_fields('lessontimes', array('feedback'));
}
public function down()
{
\DBUtil::drop_fields('players', array('is_core_player'));
}
public function down()
{
\DBUtil::drop_fields('users', array('timezone'));
}
public function down()
{
\DBUtil::drop_fields('posts', array('suit_thickness'));
}
public function down()
{
\DBUtil::drop_fields('lessontimes', array('language'));
}
public function down()
{
\DBUtil::drop_fields('articles', array('preview'));
}
public function down()
{
\Config::load('sentry', true);
\DBUtil::drop_fields(\Config::get('sentry.table.groups'), array('parent'));
}
public function down()
{
\DBUtil::drop_fields('call_centers', array('shortcode'));
}
private function _alter_or_return_fields($name, array $fields, $new)
{
if (!$new) {
if (\Cli::option('R', false) || \Cli::option('remove', false)) {
\DBUtil::drop_fields('users', array_keys($fields));
\Cli::write(\Cli::color("{$name} fields removed successfully", 'green'));
} else {
\DBUtil::add_fields('users', $fields);
\Cli::write(\Cli::color("{$name} fields added successfully", 'green'));
}
} else {
return $fields;
}
}
public function down()
{
\DBUtil::drop_fields('contents', array('category'));
}
public function down()
{
\DBUtil::drop_fields('telesales_report_values', array('pack_out_commission'));
}
public function down()
{
\DBUtil::drop_fields('proxies', array('use_count'));
}
public function down()
{
\DBUtil::drop_fields('users', array('status'));
}
public function down()
{
\DBUtil::drop_fields('articles', array('on_main_page'));
}
public function down()
{
\DBUtil::drop_fields('tomorrow_list_stats', array('campaign'));
}
public function down()
{
\DBUtil::drop_fields('call_centers', array('survey'));
}
public function down()
{
\DBUtil::drop_fields('contents', array('number'));
}
public function up()
{
\DBUtil::drop_fields('students', array('status'));
}
public function down()
{
\DBUtil::drop_fields('lessontimes', array('history'));
}
public function down()
{
// drop
\DBUtil::drop_fields('task_queues', 'priority');
}
public function down()
{
\DBUtil::add_fields('authentications', array('token' => array('constraint' => 255, 'type' => 'varchar', 'null' => true)));
\DBUtil::drop_fields('authentications', array('access_token', 'expires', 'refresh_token'));
}
public function down()
{
\DBUtil::drop_fields('users', array('trial'));
}
