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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?
class Step00284HelpEditor extends Migration
{
public function description ()
{
return 'Adds fields for extended help functions and inserts help administrator role.';
}
public function up ()
{
$this->announce("add new fields to table help_content");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `global_content_id` varchar(32) NOT NULL FIRST");
DBManager::get()->exec("UPDATE `help_content` SET `global_content_id` = `content_id`");
DBManager::get()->exec("ALTER TABLE `help_content` DROP PRIMARY KEY , ADD PRIMARY KEY ( `content_id` )");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `author_email` varchar(255) NOT NULL AFTER `author_id`");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `chdate` int(11) NOT NULL AFTER `mkdate`");
DBManager::get()->exec("ALTER TABLE `help_content` DROP COLUMN `author_id`, DROP COLUMN `label`, DROP COLUMN `icon`");
$this->announce("add new fields to table help_tours");
DBManager::get()->exec("ALTER TABLE `help_tours` ADD `global_tour_id` varchar(32) NOT NULL FIRST");
DBManager::get()->exec("UPDATE `help_tours` SET `global_tour_id` = `tour_id`");
DBManager::get()->exec("ALTER TABLE `help_tours` ADD `author_email` varchar(255) NOT NULL AFTER `installation_id`");
DBManager::get()->exec("ALTER TABLE `help_tours` ADD `chdate` int(11) NOT NULL AFTER `mkdate`");
$this->announce("add new fields to table help_tour_steps");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` ADD `chdate` int(11) NOT NULL AFTER `mkdate`");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` ADD `author_email` varchar(255) NOT NULL AFTER `route`");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` DROP COLUMN `author_id`");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` ADD `action_next` varchar(255) NOT NULL AFTER `route`");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` ADD `action_prev` varchar(255) NOT NULL AFTER `route`");
DBManager::get()->exec("INSERT INTO `roles` (`rolename`, `system`) VALUES ('Hilfe-Administrator(in)', 'n')");
$this->announce("done.");
}
public function down ()
{
DBManager::get()->exec("DELETE `roles_user`.*, `roles`.* FROM `roles_user` LEFT JOIN `roles` USING (`roleid`) WHERE `roles`.`rolename` = 'Hilfe-Administrator(in)'");
$this->announce("remove fields from table help_content");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `author_id` varchar(255) NOT NULL AFTER `author_email`");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `label` varchar(255) NOT NULL AFTER `language`");
DBManager::get()->exec("ALTER TABLE `help_content` ADD `icon` varchar(255) NOT NULL AFTER `language`");
DBManager::get()->exec("ALTER TABLE `help_content` DROP COLUMN `author_email`, DROP COLUMN `global_content_id`");
DBManager::get()->exec("ALTER TABLE `help_content` DROP PRIMARY KEY , ADD PRIMARY KEY ( `content_id`, `language`, `studip_version`, `installation_id` )");
$this->announce("remove fields from table help_tours");
DBManager::get()->exec("ALTER TABLE `help_tours` DROP COLUMN `author_email`, DROP COLUMN `chdate`, DROP COLUMN `global_tour_id`");
$this->announce("remove fields from table help_tour_steps");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` ADD `author_id` varchar(255) NOT NULL AFTER `author_email`");
DBManager::get()->exec("ALTER TABLE `help_tour_steps` DROP COLUMN `author_email`, DROP COLUMN `chdate`, DROP COLUMN `action_prev`, DROP COLUMN `action_next`");
$this->announce("done.");
}
}
|
