blob: 738bca7c25bc700b5e5a3093625aba847dba71f9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
<?php
class Step3574domain extends Migration {
function description() {
return 'modify auto_insert_sem according to Step03574';
}
function up() {
$query = "ALTER TABLE `auto_insert_sem` ADD `domain_id` VARCHAR( 45 ) NOT NULL DEFAULT ''";
DBManager::get()->exec($query);
$query = "ALTER TABLE `auto_insert_sem` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `seminar_id` , `status` , `domain_id` )";
DBManager::get()->exec($query);
$query = "INSERT IGNORE INTO `auto_insert_sem`
SELECT `seminar_id`, `status` , `userdomain_id` FROM `auto_insert_sem` JOIN `userdomains`";
DBManager::get()->exec($query);
}
function down() {
$query = "ALTER TABLE `auto_insert_sem` DROP `domain_id`";
DBManager::get()->exec($query);
}
}
|
