DROP TABLE IF EXISTS `notifications`;
CREATE TABLE `notifications` (
 `id` BIGINT UNSIGNED NOT NULL auto_increment,
 `type` VARCHAR(20) NOT NULL,
 `type_id` BIGINT(11) UNSIGNED NOT NULL,
 `data` TEXT NOT NULL,
 PRIMARY KEY (`id`),
 KEY (`id`, `type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `email_messages` ADD COLUMN `bcc` VARCHAR(255) NOT NULL;
ALTER TABLE `users` ADD COLUMN `parent_id` BIGINT UNSIGNED NOT NULL;
ALTER TABLE `users` ADD COLUMN `permissions` TEXT DEFAULT '';
ALTER TABLE `users` ADD COLUMN `token` varchar(40) default NULL;