EJLUEpiT

1DROP TABLE IF EXISTS `notifications`;
2CREATE TABLE `notifications` (
3 `id` BIGINT UNSIGNED NOT NULL auto_increment,
4 `type` VARCHAR(20) NOT NULL,
5 `type_id` BIGINT(11) UNSIGNED NOT NULL,
6 `data` TEXT NOT NULL,
7 PRIMARY KEY (`id`),
8 KEY (`id`, `type_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11ALTER TABLE `email_messages` ADD COLUMN `bcc` VARCHAR(255) NOT NULL;
12ALTER TABLE `users` ADD COLUMN `parent_id` BIGINT UNSIGNED NOT NULL;
13ALTER TABLE `users` ADD COLUMN `permissions` TEXT DEFAULT '';
14ALTER TABLE `users` ADD COLUMN `token` varchar(40) default NULL;