31 lines
1.1 KiB
SQL
Executable File
31 lines
1.1 KiB
SQL
Executable File
ALTER TABLE `NotificationSettings` DROP `notifyNewIdeaKeyword`;
|
|
|
|
ALTER TABLE notification_receiver_configuration CHANGE COLUMN `group` `type` VARCHAR(255) NOT NULL;
|
|
|
|
CREATE TABLE `notification_delivery_configuration` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`dateCreated` datetime NOT NULL,
|
|
`lastModified` datetime NOT NULL,
|
|
`version` int(11) NOT NULL,
|
|
`enabled` tinyint(1) NOT NULL,
|
|
`event` varchar(32) NOT NULL,
|
|
`method` varchar(255) NOT NULL,
|
|
`type` varchar(255) NOT NULL,
|
|
`user_id` bigint(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `FK7B2EE5BF895349BF` (`user_id`),
|
|
CONSTRAINT `FK7B2EE5BF895349BF` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE `notification_event_configuration` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`dateCreated` datetime NOT NULL,
|
|
`lastModified` datetime NOT NULL,
|
|
`version` int(11) NOT NULL,
|
|
`event` varchar(255) NOT NULL,
|
|
`type` varchar(255) NOT NULL,
|
|
`description` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `type` (`type`,`event`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
|