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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
<?
class Step00098UserDomains extends Migration
{
function description () {
return 'add database tables for user domains';
}
function up () {
$db = DBManager::get();
$db->exec("CREATE TABLE seminar_userdomains (
seminar_id varchar(32) NOT NULL default '',
userdomain_id varchar(32) NOT NULL default '',
PRIMARY KEY (seminar_id, userdomain_id)) ENGINE=MyISAM");
$db->exec("CREATE TABLE user_userdomains (
user_id varchar(32) NOT NULL default '',
userdomain_id varchar(32) NOT NULL default '',
PRIMARY KEY (user_id, userdomain_id)) ENGINE=MyISAM");
$db->exec("CREATE TABLE userdomains (
userdomain_id varchar(32) NOT NULL default '',
name varchar(255) NOT NULL default '',
PRIMARY KEY (userdomain_id)) ENGINE=MyISAM");
$db->exec("ALTER TABLE auth_user_md5 CHANGE visible
visible enum('global','always','yes','unknown','no','never')
NOT NULL default 'unknown'");
}
function down () {
$db = DBManager::get();
$db->exec("DROP TABLE seminar_userdomains");
$db->exec("DROP TABLE user_userdomains");
$db->exec("DROP TABLE userdomains");
$db->exec("ALTER TABLE auth_user_md5 CHANGE visible
visible enum('always','yes','unknown','no','never')
NOT NULL default 'unknown'");
}
}
?>
|
