Skip to content
This repository
tree: 1099b35424
Fetching contributors…

Cannot retrieve contributors at this time

file 13 lines (11 sloc) 0.667 kb
1 2 3 4 5 6 7 8 9 10 11 12 13
CREATE TABLE `theme_locks` (
    `id` int(11) unsigned AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `theme_id` int(11) unsigned NOT NULL UNIQUE,
    `reviewer_id` int(11) unsigned NOT NULL,
    `expiry` datetime NOT NULL,
    `created` datetime NOT NULL,
    `modified` datetime NOT NULL
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `theme_locks` ADD CONSTRAINT `reviewer_id_refs_id_6928eea4` FOREIGN KEY (`reviewer_id`) REFERENCES `users` (`id`);
ALTER TABLE `theme_locks` ADD CONSTRAINT `theme_id_refs_id_3202bbda` FOREIGN KEY (`theme_id`) REFERENCES `personas` (`id`);

CREATE INDEX `theme_locks_d0f17e2b` ON `theme_locks` (`reviewer_id`);
Something went wrong with that request. Please try again.