35 lines
1.4 KiB
SQL
Executable File
35 lines
1.4 KiB
SQL
Executable File
-- migration of old ideas without languages and research areas makes this necessary
|
|
ALTER TABLE `newidea` CHANGE `language_id` `language_id` BIGINT( 20 ) NULL DEFAULT NULL;
|
|
ALTER TABLE `newidea` CHANGE `researchArea_id` `researchArea_id` BIGINT( 20 ) NULL DEFAULT NULL;
|
|
|
|
CREATE TABLE `newidea_export` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`dateCreated` datetime NOT NULL,
|
|
`lastModified` datetime NOT NULL,
|
|
`version` int(11) NOT NULL,
|
|
`reason` varchar(255) DEFAULT NULL,
|
|
`result` varchar(255) DEFAULT NULL,
|
|
`idea_id` bigint(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `FK68FA705CFCDADF61` (`idea_id`),
|
|
CONSTRAINT `FK68FA705CFCDADF61` FOREIGN KEY (`idea_id`) REFERENCES `newidea` (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
-- New system setting that controls if participations needs to be confirmed on new ideas.
|
|
ALTER TABLE `general_system_settings` ADD `matchPartnerConfirmation` bit(1) NOT NULL;
|
|
|
|
CREATE TABLE `settings_date` (
|
|
`style` varchar(255) NOT NULL,
|
|
`dateCreated` datetime NOT NULL,
|
|
`lastModified` datetime NOT NULL,
|
|
`version` int(11) NOT NULL,
|
|
`format` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`style`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
INSERT INTO `settings_date` (`style`, `format`, `dateCreated`, `lastModified`, `version`)
|
|
VALUES
|
|
("DATE", "yyyy-MM-dd", NOW(), NOW(), 0),
|
|
("DATETIME", "yyyy-MM-dd HH:mm", NOW(), NOW(), 0),
|
|
("TIME", "HH:mm", NOW(), NOW(), 0);
|