Skip to content
This repository
tree: 6d6baf32fe
Fetching contributors…

Cannot retrieve contributors at this time

file 12 lines (11 sloc) 0.472 kb
1 2 3 4 5 6 7 8 9 10 11 12
DROP TABLE IF EXISTS `users_notifications`;
CREATE TABLE `users_notifications` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `user_id` int(11) unsigned NOT NULL,
    `notification_id` int(11) NOT NULL,
    `created` datetime DEFAULT NULL,
    `modified` datetime DEFAULT NULL,
    `enabled` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `users_notifications`
    ADD CONSTRAINT FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
Something went wrong with that request. Please try again.