forked from science-ation/science-ation
18 lines
1.2 KiB
MySQL
18 lines
1.2 KiB
MySQL
|
ALTER TABLE `config` CHANGE `type` `type` ENUM( '', 'yesno', 'number', 'text', 'select', 'multisel', 'language', 'theme', 'timezone' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
|
||
|
|
|
||
|
|
INSERT INTO `config` ( `var` , `val` , `category` , `type` , `type_values` , `order` , `description`) VALUES
|
||
|
|
('project_number_format', 'CHN', 'Floorplanning', 'select', 'CHN=CCHHXX (2-digit Category, 2-digit Challenge, 2-digit Number)|X4=XXXX (4-digit sequential numbering)|c_X3_h=c XXX h (Category Shortform, 3-digit sequential, Challenge Shortform)', '', 'Project Numbering Format');
|
||
|
|
|
||
|
|
INSERT INTO `cms` (`id` , `name` , `type` , `text` , `language` , `use`) VALUES
|
||
|
|
(NULL , 's_main', 'pagetext', 'Extra information for the student main page', 'en', '1');
|
||
|
|
|
||
|
|
ALTER TABLE `categories` CHANGE `id` `cat_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
|
||
|
|
ALTER TABLE `categories` DROP PRIMARY KEY;
|
||
|
|
ALTER TABLE `categories` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;
|
||
|
|
|
||
|
|
ALTER TABLE `challenges` CHANGE `id` `chal_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
|
||
|
|
ALTER TABLE `challenges` DROP PRIMARY KEY;
|
||
|
|
ALTER TABLE `challenges` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ;
|
||
|
|
|
||
|
|
|