コード例 #1
0
 function up()
 {
     DBManager::get()->exec("ALTER TABLE `event_data` CHANGE `autor_id` `author_id` VARCHAR(32) NOT NULL");
     DBManager::get()->exec("ALTER TABLE `calendar_event` ADD `mkdate` INT NOT NULL AFTER `group_status`");
     DBManager::get()->exec("UPDATE calendar_event ce LEFT JOIN event_data ed USING(event_id) SET ce.mkdate = ed.mkdate");
     $replace = array('showlist' => 'list', 'showday' => 'day', 'showweek' => 'week', 'showmonth' => 'month', 'showyear' => 'year');
     $res = DBManager::get()->query("SELECT user_id FROM `user_config` WHERE field = 'CALENDAR_SETTINGS'");
     $default_settings = Calendar::getDefaultUserSettings();
     Config::get()->store('CALENDAR_SETTINGS', $default_settings);
     foreach ($res as $row) {
         $config = new UserConfig($row['user_id']);
         $settings = $config->getValue('CALENDAR_SETTINGS');
         if (isset($settings['view'])) {
             $default_settings['view'] = $replace[$settings['view']];
             $config->store('CALENDAR_SETTINGS', $default_settings);
         }
     }
 }