blob: 678186be58bc973e085dd4be14efc11f21b8b675 (
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
<?php
/**
* Migration for StEP00301
*
* @author Arne Schröder <schroeder@data-quest.de>
* @license GPL2 or any later version
* @since Stud.IP 3.5
*
* @see https://develop.studip.de/trac/ticket/6574
*/
class Step00301AdmissionConditiongroups extends Migration
{
/**
* short description of this migration
*/
public function description()
{
return 'Adds table admission_conditiongroup.';
}
/**
* perform this migration
*/
public function up()
{
DBManager::get()->exec('CREATE TABLE IF NOT EXISTS `admission_conditiongroup` (
`conditiongroup_id` varchar(32) NOT NULL,
`quota` int(11) NOT NULL,
PRIMARY KEY (`conditiongroup_id`)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC');
DBManager::get()->exec("ALTER TABLE `admission_condition` ADD `conditiongroup_id` VARCHAR( 32 ) NOT NULL DEFAULT '' AFTER `filter_id`");
}
/**
* revert this migration
*/
public function down()
{
DBManager::get()->exec('DROP TABLE `admission_conditiongroup`');
DBManager::get()->exec('ALTER TABLE `admission_condition` DROP `conditiongroup_id`;');
}
}
|
