7Ev0V6m9

1/**
2 * FindRetros Structure
3 *
4 * Do Not Execute This Table RAW!
5 *
6 * ${prefix} The Database Prefix
7 */
8
9CREATE TABLE IF NOT EXISTS `${prefix}permissions`(
10  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
11  `permission_key` VARCHAR(30) NOT NULL,
12  `permission_name` VARCHAR(30) NOT NULL,
13  PRIMARY KEY(`id`),
14  UNIQUE KEY `permission_key` (`permission_key`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17CREATE TABLE IF NOT EXISTS `${pefix}roles` (
18  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
19  `role_name` VARCHAR(20) NOT NULL,
20  PRIMARY KEY (`id`),
21  UNIQUE KEY `role_name` (`role_name`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;
23
24CREATE TABLE IF NOT EXISTS `${prefix}role_permission` (
25  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
26  `role_id` INT(12) UNSIGNED NOT NULL,
27  `permission_id` INT(20) UNSIGNED NOT NULL,
28  `value` INT(6) NOT NULL DEFAULT '0',
29  `updated` DATETIME NOT NULL,
30  PRIMARY KEY (`id`),
31  UNIQUE KEY `role_uid` (`role_id`, `permission_id`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=32;
33
34
35CREATE TABLE IF NOT EXISTS `${prefix}accounts` (
36  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
37  `email` VARCHAR(20) NOT NULL,
38  `key` VARCHAR(64) NOT NULL,
39  PRIMARY KEY (`id`),
40  KEY `identification` (`email`)
41) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;
42
43CREATE TABLE IF NOT EXISTS `${prefix}users` (
44  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
45  `firstname` VARCHAR(64) NOT NULL,
46  `lastname` VARCHAR(64) NOT NULL,
47  `username` VARCHAR(64) NOT NULL,
48  `email` VARCHAR(64) NOT NULL,
49  `hash` TEXT NOT NULL, 
50) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;
51
52CREATE TABLE IF NOT EXISTS `${prefix}user_permissions` (
53  `id` INT(12) UNSIGNED NOT NULL AUTO_INCREMENT,
54  `user_id` INT(12) UNSIGNED NOT NULL,
55  `permission_id` INT(12) UNSIGNED NOT NULL,
56  `value` INT(6) NOT NULL DEFAULT '0',
57  `updated` DATETIME NOT NULL,
58  PRIMARY KEY (`id`),
59  UNIQUE KEY `userid` (`user_id`, `permission_id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
61
62CREATE TABLE IF NOT EXISTS `${prefix}user_roles` (
63  `user_id` INT(12) UNSIGNED NOT NULL,
64  `role_id` INT(12) UNSIGNED NOT NULL,
65  `updated` DATETIME NOT NULL,
66  UNIQUE KEY `userid` (`user_id`, `role_id`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8;