yZpJxKDF

1-- --------------------------------------------------------
2
3--
4-- Table structure for table `security__mvc_resource`
5--
6
7CREATE TABLE IF NOT EXISTS `security__mvc_resource` (
8  `resource_id` smallint(5) unsigned NOT NULL auto_increment,
9  `module` varchar(32) collate utf8_danish_ci NOT NULL COMMENT 'Module name',
10  `controller` varchar(32) collate utf8_danish_ci default NULL COMMENT 'Controller name',
11  PRIMARY KEY  (`resource_id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci COMMENT='MVC Resource' AUTO_INCREMENT=1004 ;
13
14--
15-- Dumping data for table `security__mvc_resource`
16--
17
18INSERT INTO `security__mvc_resource` (`resource_id`, `module`, `controller`) VALUES
19(10, 'admin', NULL),
20(100, 'default', NULL),
21(201, 'user', 'index'),
22(202, 'user', 'login'),
23(203, 'user', 'settings'),
24(1001, 'megalol', 'my-list'),
25(1002, 'megalol', 'list'),
26(1003, 'megalol', 'index');
27
28-- --------------------------------------------------------
29
30--
31-- Table structure for table `security__mvc_rule`
32--
33
34CREATE TABLE IF NOT EXISTS `security__mvc_rule` (
35  `rule_id` smallint(5) unsigned NOT NULL auto_increment,
36  `role_id` varchar(32) collate utf8_danish_ci NOT NULL COMMENT 'Role name',
37  `resource_id` smallint(5) unsigned NOT NULL COMMENT 'MVC Resource',
38  `privilege` varchar(32) collate utf8_danish_ci default NULL COMMENT 'Action',
39  PRIMARY KEY  (`rule_id`),
40  KEY `role_id_idx` (`role_id`),
41  KEY `resource_id_idx` (`resource_id`)
42) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci COMMENT='MVC Rule' AUTO_INCREMENT=11 ;
43
44--
45-- Dumping data for table `security__mvc_rule`
46--
47
48INSERT INTO `security__mvc_rule` (`rule_id`, `role_id`, `resource_id`, `privilege`) VALUES
49(1, 'Guest', 100, NULL),
50(2, 'Administrator', 10, NULL),
51(3, 'Member', 201, NULL),
52(4, 'Guest', 202, NULL),
53(5, 'Member', 203, NULL),
54(6, 'Member', 1001, NULL),
55(7, 'Administrator', 1002, NULL),
56(8, 'Member', 1002, 'index'),
57(9, 'Member', 1002, 'view'),
58(10, 'Member', 1003, NULL);
59
60-- --------------------------------------------------------
61
62--
63-- Table structure for table `security__role`
64--
65
66CREATE TABLE IF NOT EXISTS `security__role` (
67  `role` varchar(32) collate utf8_danish_ci NOT NULL COMMENT 'Role name',
68  `parent` varchar(32) collate utf8_danish_ci default NULL COMMENT 'Parent role',
69  PRIMARY KEY  (`role`),
70  KEY `parent_idx` (`parent`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci COMMENT='Role';
72
73--
74-- Dumping data for table `security__role`
75--
76
77INSERT INTO `security__role` (`role`, `parent`) VALUES
78('Administrator', NULL),
79('Guest', NULL),
80('Member', 'Guest');
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `security__role_user`
86--
87
88CREATE TABLE IF NOT EXISTS `security__role_user` (
89  `role` varchar(32) collate utf8_danish_ci NOT NULL COMMENT 'Roles user has',
90  `username` varchar(16) collate utf8_danish_ci NOT NULL COMMENT 'Users with role',
91  PRIMARY KEY  (`role`,`username`),
92  KEY `username` (`username`)
93) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
94
95--
96-- Dumping data for table `security__role_user`
97--
98
99INSERT INTO `security__role_user` (`role`, `username`) VALUES
100('Member', 'foo'),
101('Guest', 'guest'),
102('Member', 'bar'),
103('Member', 'baz'),
104('Administrator', 'johndoe'),
105('Member', 'johndoe'),
106('Member', 'bat');
107
108--
109-- Constraints for dumped tables
110--
111
112--
113-- Constraints for table `security__mvc_rule`
114--
115ALTER TABLE `security__mvc_rule`
116  ADD CONSTRAINT `security__mvc_rule_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `security__role` (`role`) ON DELETE CASCADE ON UPDATE CASCADE,
117  ADD CONSTRAINT `security__mvc_rule_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `security__mvc_resource` (`resource_id`) ON DELETE CASCADE ON UPDATE CASCADE;
118
119--
120-- Constraints for table `security__role`
121--
122ALTER TABLE `security__role`
123  ADD CONSTRAINT `security__role_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `security__role` (`role`) ON DELETE SET NULL ON UPDATE CASCADE;
124
125--
126-- Constraints for table `security__role_user`
127--
128ALTER TABLE `security__role_user`
129  ADD CONSTRAINT `security__role_user_ibfk_2` FOREIGN KEY (`role`) REFERENCES `security__role` (`role`) ON DELETE CASCADE ON UPDATE CASCADE,
130  ADD CONSTRAINT `security__role_user_ibfk_3` FOREIGN KEY (`username`) REFERENCES `app__user` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;