· 6 years ago · Apr 26, 2019, 04:58 AM
1/*
2SQLyog Ultimate v13.1.1 (64 bit)
3MySQL - 10.1.37-MariaDB : Database - ap_web
4*********************************************************************
5*/
6
7/*!40101 SET NAMES utf8 */;
8
9/*!40101 SET SQL_MODE=''*/;
10
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15/*Table structure for table `rbac_account` */
16
17DROP TABLE IF EXISTS `rbac_account`;
18
19CREATE TABLE `rbac_account` (
20 `id_account` int(11) NOT NULL AUTO_INCREMENT,
21 `username` varchar(40) NOT NULL,
22 `password` text NOT NULL,
23 `email` text,
24 `id_role` int(11) NOT NULL,
25 `account_status` char(1) NOT NULL COMMENT '0 = Pending, 1 = Active, 2 = Banned',
26 PRIMARY KEY (`id_account`),
27 KEY `id_role` (`id_role`),
28 CONSTRAINT `rbac_account_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `rbac_role` (`id_role`)
29) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
30
31/*Data for the table `rbac_account` */
32
33insert into `rbac_account`(`id_account`,`username`,`password`,`email`,`id_role`,`account_status`) values
34(5,'superadmin','$2y$10$haNXmYnrJblLR4K4quO4vO3nPDh21Su0SXsT17wLRckQe8RzLO5PO','superadmin@superadmin.com',1,'1');
35
36/*Table structure for table `rbac_auth_log` */
37
38DROP TABLE IF EXISTS `rbac_auth_log`;
39
40CREATE TABLE `rbac_auth_log` (
41 `id_auth_log` int(11) NOT NULL AUTO_INCREMENT,
42 `id_account` int(11) DEFAULT NULL,
43 `auth_type` char(1) DEFAULT NULL COMMENT '0 = Login, 1 = Logout',
44 `ip_address` text,
45 `auth_dtm` datetime DEFAULT NULL,
46 PRIMARY KEY (`id_auth_log`),
47 KEY `id_account` (`id_account`),
48 CONSTRAINT `rbac_auth_log_ibfk_1` FOREIGN KEY (`id_account`) REFERENCES `rbac_account` (`id_account`)
49) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=latin1;
50
51/*Data for the table `rbac_auth_log` */
52
53insert into `rbac_auth_log`(`id_auth_log`,`id_account`,`auth_type`,`ip_address`,`auth_dtm`) values
54(75,5,'0','::1','2019-04-14 15:39:59'),
55(76,5,'1','::1','2019-04-14 15:52:31'),
56(77,5,'0','::1','2019-04-14 15:52:33'),
57(78,5,'0','::1','2019-04-14 21:38:46'),
58(79,5,'0','::1','2019-04-30 07:16:10'),
59(80,5,'1','::1','2019-04-30 07:48:09'),
60(81,5,'0','::1','2019-04-30 07:48:11'),
61(82,5,'0','127.0.0.1','2019-04-19 06:47:30'),
62(83,5,'1','127.0.0.1','2019-04-19 06:47:45'),
63(84,5,'0','127.0.0.1','2019-04-19 06:47:48'),
64(85,5,'1','127.0.0.1','2019-04-19 06:51:15'),
65(86,5,'0','127.0.0.1','2019-04-19 06:51:21'),
66(87,5,'1','127.0.0.1','2019-04-19 06:51:35'),
67(88,5,'0','127.0.0.1','2019-04-19 06:55:32'),
68(89,5,'1','127.0.0.1','2019-04-19 06:55:35'),
69(90,5,'0','127.0.0.1','2019-04-19 06:59:24'),
70(91,5,'1','127.0.0.1','2019-04-19 06:59:28'),
71(92,5,'0','127.0.0.1','2019-04-19 07:04:05'),
72(93,5,'1','127.0.0.1','2019-04-19 07:04:08'),
73(94,5,'0','127.0.0.1','2019-04-19 07:05:19'),
74(95,5,'1','127.0.0.1','2019-04-19 07:05:40'),
75(96,5,'0','127.0.0.1','2019-04-20 23:56:57'),
76(97,5,'0','127.0.0.1','2019-04-20 23:56:58'),
77(98,5,'0','127.0.0.1','2019-04-20 23:57:04'),
78(99,5,'0','127.0.0.1','2019-04-20 23:57:10'),
79(100,5,'0','127.0.0.1','2019-04-21 08:25:26'),
80(101,5,'0','127.0.0.1','2019-04-21 08:25:31'),
81(102,5,'0','127.0.0.1','2019-04-21 10:22:41'),
82(103,5,'1','127.0.0.1','2019-04-21 11:42:10'),
83(104,5,'0','127.0.0.1','2019-04-21 11:42:13'),
84(105,5,'1','127.0.0.1','2019-04-21 11:42:35'),
85(106,5,'0','127.0.0.1','2019-04-21 11:42:39'),
86(107,5,'0','127.0.0.1','2019-04-26 10:16:06');
87
88/*Table structure for table `rbac_menu` */
89
90DROP TABLE IF EXISTS `rbac_menu`;
91
92CREATE TABLE `rbac_menu` (
93 `id_menu` int(11) NOT NULL AUTO_INCREMENT,
94 `label` text,
95 `parent` int(11) DEFAULT NULL,
96 `references` text,
97 `type` char(1) DEFAULT NULL COMMENT '0 = Menu , 1 = Post Menu',
98 `icon` text,
99 PRIMARY KEY (`id_menu`),
100 KEY `parent` (`parent`),
101 CONSTRAINT `rbac_menu_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `rbac_menu` (`id_menu`) ON DELETE CASCADE ON UPDATE CASCADE
102) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
103
104/*Data for the table `rbac_menu` */
105
106insert into `rbac_menu`(`id_menu`,`label`,`parent`,`references`,`type`,`icon`) values
107(6,'Access Control',NULL,'#','0','fa fa-gear'),
108(7,'Roles',6,'rbac/form/roles','0','fa fa-address-card'),
109(8,'Account',6,'rbac/form/account','0','fa fa-user'),
110(9,'Menu',6,'rbac/form/menu','0','fa fa-bookmark'),
111(10,'Privileges',6,'rbac/form/privileges','0','fa fa-home'),
112(11,'Activity',NULL,'#','0','fa fa-paper-plane-o'),
113(12,'Activity List',11,'activity/','0',''),
114(13,'Activity Category',11,'activity/category','0',''),
115(14,'User',NULL,'#','0','fa fa-user'),
116(15,'User Map',14,'user/form/userMap','0','fa fa-users'),
117(16,'List User',14,'user/form/user','0','fa fa-users'),
118(17,'User Type',NULL,'user/form/userType','0','fa fa-gear'),
119(18,'User Group',14,'user/form/userGroup','0','fa fa-gear');
120
121/*Table structure for table `rbac_privileges` */
122
123DROP TABLE IF EXISTS `rbac_privileges`;
124
125CREATE TABLE `rbac_privileges` (
126 `id_privileges` int(11) NOT NULL AUTO_INCREMENT,
127 `id_role` int(11) DEFAULT NULL,
128 `id_menu` int(11) DEFAULT NULL,
129 `update_dtm` datetime DEFAULT NULL,
130 PRIMARY KEY (`id_privileges`),
131 KEY `id_role` (`id_role`),
132 KEY `id_menu` (`id_menu`),
133 CONSTRAINT `rbac_privileges_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `rbac_role` (`id_role`),
134 CONSTRAINT `rbac_privileges_ibfk_2` FOREIGN KEY (`id_menu`) REFERENCES `rbac_menu` (`id_menu`)
135) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
136
137/*Data for the table `rbac_privileges` */
138
139insert into `rbac_privileges`(`id_privileges`,`id_role`,`id_menu`,`update_dtm`) values
140(3,1,6,'2019-03-27 00:08:17'),
141(4,1,7,'2019-03-30 10:33:19'),
142(8,1,8,'2019-03-30 18:39:53'),
143(9,1,9,'2019-03-30 18:40:00'),
144(24,1,10,'2019-04-13 15:44:36'),
145(25,1,11,'2019-04-30 07:25:31'),
146(26,1,12,'2019-04-30 07:25:41'),
147(27,1,13,'2019-04-30 07:25:46'),
148(28,1,14,'2019-04-21 00:05:46'),
149(29,1,15,'2019-04-21 00:06:27'),
150(30,1,16,'2019-04-21 00:09:10'),
151(31,1,17,'2019-04-21 00:09:19'),
152(32,1,18,'2019-04-21 00:09:25');
153
154/*Table structure for table `rbac_role` */
155
156DROP TABLE IF EXISTS `rbac_role`;
157
158CREATE TABLE `rbac_role` (
159 `id_role` int(11) NOT NULL AUTO_INCREMENT,
160 `name` text NOT NULL,
161 PRIMARY KEY (`id_role`)
162) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
163
164/*Data for the table `rbac_role` */
165
166insert into `rbac_role`(`id_role`,`name`) values
167(0,'All Roles'),
168(1,'Superadmin');
169
170/*Table structure for table `user` */
171
172DROP TABLE IF EXISTS `user`;
173
174CREATE TABLE `user` (
175 `id_user` int(11) NOT NULL AUTO_INCREMENT,
176 `first_name` varchar(40) NOT NULL,
177 `last_name` varchar(40) NOT NULL,
178 `gender` char(1) NOT NULL,
179 `birth_date` date NOT NULL,
180 `birth_place` varchar(45) NOT NULL,
181 `user_type_id` int(11) NOT NULL,
182 `create_date` date NOT NULL,
183 PRIMARY KEY (`id_user`)
184) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
185
186/*Data for the table `user` */
187
188insert into `user`(`id_user`,`first_name`,`last_name`,`gender`,`birth_date`,`birth_place`,`user_type_id`,`create_date`) values
189(17,'Ramdhani Lukman','Mochamad','m','1997-06-02','Bandung',31,'2019-04-21');
190
191/*Table structure for table `user_detail` */
192
193DROP TABLE IF EXISTS `user_detail`;
194
195CREATE TABLE `user_detail` (
196 `id_user_detail` int(11) NOT NULL AUTO_INCREMENT,
197 `id_user` int(11) NOT NULL,
198 `picture` text,
199 `xs1` text,
200 `xs2` text,
201 `xs3` text,
202 `xs4` text,
203 `xs5` text,
204 `xn1` int(11) DEFAULT NULL,
205 `xn2` int(11) DEFAULT NULL,
206 `xn3` int(11) DEFAULT NULL,
207 `xd1` date DEFAULT NULL,
208 `xd2` date DEFAULT NULL,
209 `xd3` date DEFAULT NULL,
210 `last_update` datetime DEFAULT NULL,
211 PRIMARY KEY (`id_user_detail`),
212 KEY `FK_IDUSER_USERDETAIL` (`id_user`),
213 CONSTRAINT `FK_IDUSER_USERDETAIL` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE
214) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
215
216/*Data for the table `user_detail` */
217
218insert into `user_detail`(`id_user_detail`,`id_user`,`picture`,`xs1`,`xs2`,`xs3`,`xs4`,`xs5`,`xn1`,`xn2`,`xn3`,`xd1`,`xd2`,`xd3`,`last_update`) values
219(1,17,'17-2019_04_21__11_37_10.jpg','','','',NULL,NULL,0,NULL,NULL,'0000-00-00',NULL,NULL,'2019-04-21 11:37:11'),
220(2,17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2019-04-21 00:00:00');
221
222/*Table structure for table `user_file` */
223
224DROP TABLE IF EXISTS `user_file`;
225
226CREATE TABLE `user_file` (
227 `id_user_file` int(11) NOT NULL AUTO_INCREMENT,
228 `id_user` int(11) DEFAULT NULL,
229 `file1` text,
230 `file2` text,
231 `file3` text,
232 `file4` text,
233 `file5` text,
234 `picture1` text,
235 `picture2` text,
236 `picture3` text,
237 `picture4` text,
238 `picture5` text,
239 PRIMARY KEY (`id_user_file`)
240) ENGINE=InnoDB DEFAULT CHARSET=latin1;
241
242/*Data for the table `user_file` */
243
244/*Table structure for table `user_group` */
245
246DROP TABLE IF EXISTS `user_group`;
247
248CREATE TABLE `user_group` (
249 `user_group_id` int(11) NOT NULL AUTO_INCREMENT,
250 `user_group_name` text NOT NULL,
251 `create_date` date NOT NULL,
252 PRIMARY KEY (`user_group_id`)
253) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254
255/*Data for the table `user_group` */
256
257/*Table structure for table `user_group_member` */
258
259DROP TABLE IF EXISTS `user_group_member`;
260
261CREATE TABLE `user_group_member` (
262 `id_user_group_member` int(11) NOT NULL AUTO_INCREMENT,
263 `user_group_id` int(11) NOT NULL,
264 `id_user` int(11) NOT NULL,
265 `create_date` date NOT NULL,
266 PRIMARY KEY (`id_user_group_member`)
267) ENGINE=InnoDB DEFAULT CHARSET=latin1;
268
269/*Data for the table `user_group_member` */
270
271/*Table structure for table `user_map` */
272
273DROP TABLE IF EXISTS `user_map`;
274
275CREATE TABLE `user_map` (
276 `id_user_map` int(11) NOT NULL AUTO_INCREMENT,
277 `id_account` int(11) NOT NULL,
278 `id_user` int(11) NOT NULL,
279 `create_date` date NOT NULL,
280 PRIMARY KEY (`id_user_map`)
281) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
282
283/*Data for the table `user_map` */
284
285insert into `user_map`(`id_user_map`,`id_account`,`id_user`,`create_date`) values
286(2,5,17,'2019-04-21');
287
288/*Table structure for table `user_type` */
289
290DROP TABLE IF EXISTS `user_type`;
291
292CREATE TABLE `user_type` (
293 `user_type_id` int(11) NOT NULL AUTO_INCREMENT,
294 `user_type_name` varchar(35) NOT NULL,
295 PRIMARY KEY (`user_type_id`)
296) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
297
298/*Data for the table `user_type` */
299
300insert into `user_type`(`user_type_id`,`user_type_name`) values
301(31,'Superadmin');
302
303/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
304/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
305/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
306/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;