s5SKpUVa

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.7.25-0ubuntu0.18.04.2 - (Ubuntu)
4-- Server OS:                    Linux
5-- HeidiSQL Version:             10.1.0.5464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table yarsi_april_wisuda.auth_assignment
15CREATE TABLE IF NOT EXISTS `auth_assignment` (
16  `item_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
17  `user_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
18  `created_at` int(11) DEFAULT NULL,
19  PRIMARY KEY (`item_name`,`user_id`),
20  CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
23-- Dumping data for table yarsi_april_wisuda.auth_assignment: ~2 rows (approximately)
24/*!40000 ALTER TABLE `auth_assignment` DISABLE KEYS */;
25INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES
26	('Super Admin', '1', 1522765404);
27INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES
28	('Super Admin', '3', NULL);
29/*!40000 ALTER TABLE `auth_assignment` ENABLE KEYS */;
30
31-- Dumping structure for table yarsi_april_wisuda.auth_item
32CREATE TABLE IF NOT EXISTS `auth_item` (
33  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
34  `type` smallint(6) NOT NULL,
35  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
36  `rule_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
37  `data` blob,
38  `created_at` int(11) DEFAULT NULL,
39  `updated_at` int(11) DEFAULT NULL,
40  PRIMARY KEY (`name`),
41  KEY `rule_name` (`rule_name`),
42  KEY `idx-auth_item-type` (`type`),
43  CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
44) ENGINE=InnoDB DEFAULT CHARSET=utf8;
45
46-- Dumping data for table yarsi_april_wisuda.auth_item: ~11 rows (approximately)
47/*!40000 ALTER TABLE `auth_item` DISABLE KEYS */;
48INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
49	('/*', 2, NULL, NULL, NULL, 1551977195, 1551977195);
50INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
51	('/apps/*', 2, NULL, NULL, NULL, 1551977215, 1551977215);
52INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
53	('/profile/*', 2, NULL, NULL, NULL, 1551977231, 1551977231);
54INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
55	('/roles/*', 2, NULL, NULL, NULL, 1551977229, 1551977229);
56INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
57	('/site/*', 2, NULL, NULL, NULL, 1551977218, 1551977218);
58INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
59	('/user-management/*', 2, NULL, NULL, NULL, 1551977221, 1551977221);
60INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
61	('Admin PD DIKTI', 1, NULL, NULL, NULL, 1551992687, 1551992687);
62INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
63	('Admin Program Studi', 1, NULL, NULL, NULL, 1551992680, 1551992680);
64INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
65	('Admin Rektorat', 1, NULL, NULL, NULL, 1548339156, 1551992670);
66INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
67	('Mahasiswa', 1, NULL, NULL, NULL, 1548437474, 1551992640);
68INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
69	('Super Admin', 1, NULL, NULL, NULL, 1509549076, 1522765326);
70/*!40000 ALTER TABLE `auth_item` ENABLE KEYS */;
71
72-- Dumping structure for table yarsi_april_wisuda.auth_item_child
73CREATE TABLE IF NOT EXISTS `auth_item_child` (
74  `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
75  `child` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
76  PRIMARY KEY (`parent`,`child`),
77  KEY `child` (`child`),
78  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
79  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
80) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81
82-- Dumping data for table yarsi_april_wisuda.auth_item_child: ~3 rows (approximately)
83/*!40000 ALTER TABLE `auth_item_child` DISABLE KEYS */;
84INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
85	('Super Admin', '/*');
86INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
87	('Mahasiswa', '/profile/*');
88INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
89	('Mahasiswa', '/site/*');
90/*!40000 ALTER TABLE `auth_item_child` ENABLE KEYS */;
91
92-- Dumping structure for table yarsi_april_wisuda.auth_rule
93CREATE TABLE IF NOT EXISTS `auth_rule` (
94  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
95  `data` blob,
96  `created_at` int(11) DEFAULT NULL,
97  `updated_at` int(11) DEFAULT NULL,
98  PRIMARY KEY (`name`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8;
100
101-- Dumping data for table yarsi_april_wisuda.auth_rule: ~0 rows (approximately)
102/*!40000 ALTER TABLE `auth_rule` DISABLE KEYS */;
103/*!40000 ALTER TABLE `auth_rule` ENABLE KEYS */;
104
105-- Dumping structure for table yarsi_april_wisuda.configuration
106CREATE TABLE IF NOT EXISTS `configuration` (
107  `id` int(11) NOT NULL AUTO_INCREMENT,
108  `key` varchar(50) NOT NULL,
109  `value` longtext,
110  PRIMARY KEY (`id`),
111  KEY `key` (`key`)
112) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='Configuration the app such as title, logo and etc';
113
114-- Dumping data for table yarsi_april_wisuda.configuration: ~12 rows (approximately)
115/*!40000 ALTER TABLE `configuration` DISABLE KEYS */;
116INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
117	(1, 'logo', '65974008a310aa8c22d3934b1a97728ea3d52831.png');
118INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
119	(2, 'favicon', '56db8d57a7e33f5c9e87e2737827246e818bc91c.ico');
120INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
121	(3, 'kontak', '');
122INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
123	(4, 'email', '');
124INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
125	(5, 'alamat', '');
126INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
127	(6, 'deskripsi', '');
128INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
129	(7, 'title', 'YARSI');
130INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
131	(8, 'short_title', 'Y');
132INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
133	(9, 'copyright', 'Asha');
134INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
135	(10, 'version', '0.1');
136INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
137	(11, 'title_login', '');
138INSERT INTO `configuration` (`id`, `key`, `value`) VALUES
139	(12, 'content_dashboard', '<h2 class="text-center">Selamat Datang di Aplikasi Sistem Web Pendeteksi Benturan Jadwal Mata Kuliah Berdasarkan Unggah Berkas File Jadwal (File Excel).</h2>');
140/*!40000 ALTER TABLE `configuration` ENABLE KEYS */;
141
142-- Dumping structure for table yarsi_april_wisuda.route
143CREATE TABLE IF NOT EXISTS `route` (
144  `name` varchar(65) NOT NULL,
145  `alias` varchar(65) DEFAULT NULL,
146  `type` varchar(65) DEFAULT NULL,
147  `status` smallint(6) NOT NULL DEFAULT '1',
148  PRIMARY KEY (`name`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8;
150
151-- Dumping data for table yarsi_april_wisuda.route: ~206 rows (approximately)
152/*!40000 ALTER TABLE `route` DISABLE KEYS */;
153INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
154	('/*', '*', '', 1);
155INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
156	('/admin/*', '*', 'admin', 1);
157INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
158	('/admin/banner/*', '*', 'admin/banner', 1);
159INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
160	('/admin/banner/create', 'create', 'admin/banner', 1);
161INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
162	('/admin/banner/delete', 'delete', 'admin/banner', 1);
163INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
164	('/admin/banner/delete-items', 'delete-items', 'admin/banner', 1);
165INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
166	('/admin/banner/index', 'index', 'admin/banner', 1);
167INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
168	('/admin/banner/update', 'update', 'admin/banner', 1);
169INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
170	('/admin/banner/view', 'view', 'admin/banner', 1);
171INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
172	('/admin/configuration/*', '*', 'admin/configuration', 1);
173INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
174	('/admin/configuration/create', 'create', 'admin/configuration', 1);
175INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
176	('/admin/configuration/delete', 'delete', 'admin/configuration', 1);
177INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
178	('/admin/configuration/delete-items', 'delete-items', 'admin/configuration', 1);
179INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
180	('/admin/configuration/index', 'index', 'admin/configuration', 1);
181INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
182	('/admin/configuration/update', 'update', 'admin/configuration', 1);
183INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
184	('/admin/configuration/view', 'view', 'admin/configuration', 1);
185INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
186	('/admin/default/*', '*', 'admin/default', 1);
187INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
188	('/admin/default/error', 'error', 'admin/default', 1);
189INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
190	('/admin/default/index', 'index', 'admin/default', 1);
191INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
192	('/admin/kota-kabupaten/*', '*', 'admin/kota-kabupaten', 1);
193INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
194	('/admin/kota-kabupaten/create', 'create', 'admin/kota-kabupaten', 1);
195INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
196	('/admin/kota-kabupaten/delete', 'delete', 'admin/kota-kabupaten', 1);
197INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
198	('/admin/kota-kabupaten/delete-items', 'delete-items', 'admin/kota-kabupaten', 1);
199INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
200	('/admin/kota-kabupaten/index', 'index', 'admin/kota-kabupaten', 1);
201INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
202	('/admin/kota-kabupaten/update', 'update', 'admin/kota-kabupaten', 1);
203INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
204	('/admin/kota-kabupaten/view', 'view', 'admin/kota-kabupaten', 1);
205INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
206	('/admin/provinsi/*', '*', 'admin/provinsi', 1);
207INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
208	('/admin/provinsi/create', 'create', 'admin/provinsi', 1);
209INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
210	('/admin/provinsi/delete', 'delete', 'admin/provinsi', 1);
211INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
212	('/admin/provinsi/delete-items', 'delete-items', 'admin/provinsi', 1);
213INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
214	('/admin/provinsi/index', 'index', 'admin/provinsi', 1);
215INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
216	('/admin/provinsi/update', 'update', 'admin/provinsi', 1);
217INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
218	('/admin/provinsi/view', 'view', 'admin/provinsi', 1);
219INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
220	('/apps/*', '*', 'apps', 1);
221INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
222	('/apps/coa/*', '*', 'apps/coa', 1);
223INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
224	('/apps/coa/create', 'create', 'apps/coa', 1);
225INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
226	('/apps/coa/delete', 'delete', 'apps/coa', 1);
227INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
228	('/apps/coa/index', 'index', 'apps/coa', 1);
229INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
230	('/apps/coa/update', 'update', 'apps/coa', 1);
231INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
232	('/apps/coa/view', 'view', 'apps/coa', 1);
233INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
234	('/apps/customer/*', '*', 'apps/customer', 1);
235INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
236	('/apps/customer/create', 'create', 'apps/customer', 1);
237INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
238	('/apps/customer/delete', 'delete', 'apps/customer', 1);
239INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
240	('/apps/customer/index', 'index', 'apps/customer', 1);
241INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
242	('/apps/customer/update', 'update', 'apps/customer', 1);
243INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
244	('/apps/customer/view', 'view', 'apps/customer', 1);
245INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
246	('/apps/default/*', '*', 'apps/default', 1);
247INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
248	('/apps/default/error', 'error', 'apps/default', 1);
249INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
250	('/apps/default/index', 'index', 'apps/default', 1);
251INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
252	('/apps/divisi/*', '*', 'apps/divisi', 1);
253INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
254	('/apps/divisi/ajax-list-divisi', 'ajax-list-divisi', 'apps/divisi', 1);
255INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
256	('/apps/divisi/create', 'create', 'apps/divisi', 1);
257INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
258	('/apps/divisi/delete', 'delete', 'apps/divisi', 1);
259INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
260	('/apps/divisi/index', 'index', 'apps/divisi', 1);
261INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
262	('/apps/divisi/update', 'update', 'apps/divisi', 1);
263INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
264	('/apps/divisi/view', 'view', 'apps/divisi', 1);
265INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
266	('/apps/jurnal-penyesuaian/*', '*', 'apps/jurnal-penyesuaian', 1);
267INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
268	('/apps/jurnal-penyesuaian/create', 'create', 'apps/jurnal-penyesuaian', 1);
269INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
270	('/apps/jurnal-penyesuaian/delete', 'delete', 'apps/jurnal-penyesuaian', 1);
271INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
272	('/apps/jurnal-penyesuaian/index', 'index', 'apps/jurnal-penyesuaian', 1);
273INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
274	('/apps/jurnal-penyesuaian/update', 'update', 'apps/jurnal-penyesuaian', 1);
275INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
276	('/apps/jurnal-penyesuaian/view', 'view', 'apps/jurnal-penyesuaian', 1);
277INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
278	('/apps/jurnal-voucher/*', '*', 'apps/jurnal-voucher', 1);
279INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
280	('/apps/jurnal-voucher/create', 'create', 'apps/jurnal-voucher', 1);
281INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
282	('/apps/jurnal-voucher/delete', 'delete', 'apps/jurnal-voucher', 1);
283INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
284	('/apps/jurnal-voucher/index', 'index', 'apps/jurnal-voucher', 1);
285INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
286	('/apps/jurnal-voucher/update', 'update', 'apps/jurnal-voucher', 1);
287INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
288	('/apps/jurnal-voucher/view', 'view', 'apps/jurnal-voucher', 1);
289INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
290	('/apps/periode-bulanan/*', '*', 'apps/periode-bulanan', 1);
291INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
292	('/apps/periode-bulanan/create', 'create', 'apps/periode-bulanan', 1);
293INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
294	('/apps/periode-bulanan/delete', 'delete', 'apps/periode-bulanan', 1);
295INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
296	('/apps/periode-bulanan/index', 'index', 'apps/periode-bulanan', 1);
297INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
298	('/apps/periode-bulanan/update', 'update', 'apps/periode-bulanan', 1);
299INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
300	('/apps/periode-bulanan/view', 'view', 'apps/periode-bulanan', 1);
301INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
302	('/apps/periode-tahunan/*', '*', 'apps/periode-tahunan', 1);
303INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
304	('/apps/periode-tahunan/create', 'create', 'apps/periode-tahunan', 1);
305INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
306	('/apps/periode-tahunan/delete', 'delete', 'apps/periode-tahunan', 1);
307INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
308	('/apps/periode-tahunan/index', 'index', 'apps/periode-tahunan', 1);
309INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
310	('/apps/periode-tahunan/update', 'update', 'apps/periode-tahunan', 1);
311INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
312	('/apps/periode-tahunan/view', 'view', 'apps/periode-tahunan', 1);
313INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
314	('/apps/vendor/*', '*', 'apps/vendor', 1);
315INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
316	('/apps/vendor/create', 'create', 'apps/vendor', 1);
317INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
318	('/apps/vendor/delete', 'delete', 'apps/vendor', 1);
319INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
320	('/apps/vendor/index', 'index', 'apps/vendor', 1);
321INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
322	('/apps/vendor/update', 'update', 'apps/vendor', 1);
323INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
324	('/apps/vendor/view', 'view', 'apps/vendor', 1);
325INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
326	('/debug/*', '*', 'debug', 1);
327INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
328	('/debug/default/*', '*', 'debug/default', 1);
329INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
330	('/debug/default/db-explain', 'db-explain', 'debug/default', 1);
331INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
332	('/debug/default/download-mail', 'download-mail', 'debug/default', 1);
333INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
334	('/debug/default/index', 'index', 'debug/default', 1);
335INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
336	('/debug/default/toolbar', 'toolbar', 'debug/default', 1);
337INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
338	('/debug/default/view', 'view', 'debug/default', 1);
339INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
340	('/debug/user/*', '*', 'debug/user', 1);
341INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
342	('/debug/user/reset-identity', 'reset-identity', 'debug/user', 1);
343INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
344	('/debug/user/set-identity', 'set-identity', 'debug/user', 1);
345INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
346	('/gii/*', '*', 'gii', 1);
347INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
348	('/gii/default/*', '*', 'gii/default', 1);
349INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
350	('/gii/default/action', 'action', 'gii/default', 1);
351INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
352	('/gii/default/diff', 'diff', 'gii/default', 1);
353INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
354	('/gii/default/index', 'index', 'gii/default', 1);
355INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
356	('/gii/default/preview', 'preview', 'gii/default', 1);
357INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
358	('/gii/default/view', 'view', 'gii/default', 1);
359INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
360	('/gridview/*', '*', 'gridview', 1);
361INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
362	('/gridview/export/*', '*', 'gridview/export', 1);
363INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
364	('/gridview/export/download', 'download', 'gridview/export', 1);
365INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
366	('/logs/*', '*', 'logs', 1);
367INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
368	('/logs/create/*', '*', 'logs/create', 1);
369INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
370	('/logs/create/create', 'create', 'logs/create', 1);
371INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
372	('/logs/create/delete', 'delete', 'logs/create', 1);
373INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
374	('/logs/create/delete-items', 'delete-items', 'logs/create', 1);
375INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
376	('/logs/create/index', 'index', 'logs/create', 1);
377INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
378	('/logs/create/update', 'update', 'logs/create', 1);
379INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
380	('/logs/create/view', 'view', 'logs/create', 1);
381INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
382	('/logs/default/*', '*', 'logs/default', 1);
383INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
384	('/logs/default/index', 'index', 'logs/default', 1);
385INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
386	('/logs/delete/*', '*', 'logs/delete', 1);
387INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
388	('/logs/delete/create', 'create', 'logs/delete', 1);
389INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
390	('/logs/delete/delete', 'delete', 'logs/delete', 1);
391INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
392	('/logs/delete/delete-items', 'delete-items', 'logs/delete', 1);
393INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
394	('/logs/delete/index', 'index', 'logs/delete', 1);
395INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
396	('/logs/delete/update', 'update', 'logs/delete', 1);
397INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
398	('/logs/delete/view', 'view', 'logs/delete', 1);
399INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
400	('/logs/download/*', '*', 'logs/download', 1);
401INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
402	('/logs/download/create', 'create', 'logs/download', 1);
403INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
404	('/logs/download/delete', 'delete', 'logs/download', 1);
405INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
406	('/logs/download/delete-items', 'delete-items', 'logs/download', 1);
407INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
408	('/logs/download/index', 'index', 'logs/download', 1);
409INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
410	('/logs/download/update', 'update', 'logs/download', 1);
411INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
412	('/logs/download/view', 'view', 'logs/download', 1);
413INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
414	('/logs/events/*', '*', 'logs/events', 1);
415INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
416	('/logs/events/create', 'create', 'logs/events', 1);
417INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
418	('/logs/events/delete', 'delete', 'logs/events', 1);
419INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
420	('/logs/events/delete-items', 'delete-items', 'logs/events', 1);
421INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
422	('/logs/events/index', 'index', 'logs/events', 1);
423INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
424	('/logs/events/update', 'update', 'logs/events', 1);
425INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
426	('/logs/events/view', 'view', 'logs/events', 1);
427INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
428	('/logs/login/*', '*', 'logs/login', 1);
429INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
430	('/logs/login/index', 'index', 'logs/login', 1);
431INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
432	('/logs/login/view', 'view', 'logs/login', 1);
433INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
434	('/logs/main/*', '*', 'logs/main', 1);
435INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
436	('/logs/print/*', '*', 'logs/print', 1);
437INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
438	('/logs/print/create', 'create', 'logs/print', 1);
439INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
440	('/logs/print/delete', 'delete', 'logs/print', 1);
441INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
442	('/logs/print/delete-items', 'delete-items', 'logs/print', 1);
443INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
444	('/logs/print/index', 'index', 'logs/print', 1);
445INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
446	('/logs/print/update', 'update', 'logs/print', 1);
447INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
448	('/logs/print/view', 'view', 'logs/print', 1);
449INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
450	('/logs/sql-error/*', '*', 'logs/sql-error', 1);
451INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
452	('/logs/sql-error/index', 'index', 'logs/sql-error', 1);
453INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
454	('/logs/update/*', '*', 'logs/update', 1);
455INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
456	('/logs/update/create', 'create', 'logs/update', 1);
457INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
458	('/logs/update/delete', 'delete', 'logs/update', 1);
459INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
460	('/logs/update/delete-items', 'delete-items', 'logs/update', 1);
461INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
462	('/logs/update/index', 'index', 'logs/update', 1);
463INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
464	('/logs/update/update', 'update', 'logs/update', 1);
465INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
466	('/logs/update/view', 'view', 'logs/update', 1);
467INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
468	('/logs/view/*', '*', 'logs/view', 1);
469INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
470	('/logs/view/create', 'create', 'logs/view', 1);
471INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
472	('/logs/view/delete', 'delete', 'logs/view', 1);
473INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
474	('/logs/view/delete-items', 'delete-items', 'logs/view', 1);
475INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
476	('/logs/view/index', 'index', 'logs/view', 1);
477INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
478	('/logs/view/update', 'update', 'logs/view', 1);
479INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
480	('/logs/view/view', 'view', 'logs/view', 1);
481INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
482	('/profile/*', '*', 'profile', 1);
483INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
484	('/profile/captcha', 'captcha', 'profile', 1);
485INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
486	('/profile/change-password', 'change-password', 'profile', 1);
487INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
488	('/profile/change-theme', 'change-theme', 'profile', 1);
489INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
490	('/profile/error', 'error', 'profile', 1);
491INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
492	('/profile/index', 'index', 'profile', 1);
493INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
494	('/roles/*', '*', 'roles', 1);
495INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
496	('/roles/role/*', '*', 'roles/role', 1);
497INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
498	('/roles/role/create', 'create', 'roles/role', 1);
499INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
500	('/roles/role/delete', 'delete', 'roles/role', 1);
501INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
502	('/roles/role/index', 'index', 'roles/role', 1);
503INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
504	('/roles/role/permission', 'permission', 'roles/role', 1);
505INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
506	('/roles/role/update', 'update', 'roles/role', 1);
507INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
508	('/roles/role/view', 'view', 'roles/role', 1);
509INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
510	('/roles/route/*', '*', 'roles/route', 1);
511INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
512	('/roles/route/create', 'create', 'roles/route', 1);
513INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
514	('/roles/route/delete', 'delete', 'roles/route', 1);
515INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
516	('/roles/route/generate', 'generate', 'roles/route', 1);
517INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
518	('/roles/route/index', 'index', 'roles/route', 1);
519INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
520	('/roles/route/update', 'update', 'roles/route', 1);
521INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
522	('/roles/route/view', 'view', 'roles/route', 1);
523INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
524	('/roles/user/*', '*', 'roles/user', 1);
525INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
526	('/roles/user/create', 'create', 'roles/user', 1);
527INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
528	('/roles/user/delete', 'delete', 'roles/user', 1);
529INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
530	('/roles/user/index', 'index', 'roles/user', 1);
531INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
532	('/roles/user/update', 'update', 'roles/user', 1);
533INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
534	('/roles/user/view', 'view', 'roles/user', 1);
535INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
536	('/site/*', '*', 'site', 1);
537INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
538	('/site/captcha', 'captcha', 'site', 1);
539INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
540	('/site/error', 'error', 'site', 1);
541INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
542	('/site/index', 'index', 'site', 1);
543INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
544	('/site/login', 'login', 'site', 1);
545INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
546	('/site/logout', 'logout', 'site', 1);
547INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
548	('/site/test-email', 'test-email', 'site', 1);
549INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
550	('/user-management/*', '*', 'user-management', 1);
551INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
552	('/user-management/default/*', '*', 'user-management/default', 1);
553INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
554	('/user-management/default/change-password', 'change-password', 'user-management/default', 1);
555INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
556	('/user-management/default/create', 'create', 'user-management/default', 1);
557INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
558	('/user-management/default/delete', 'delete', 'user-management/default', 1);
559INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
560	('/user-management/default/index', 'index', 'user-management/default', 1);
561INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
562	('/user-management/default/open-banned', 'open-banned', 'user-management/default', 1);
563INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
564	('/user-management/default/update', 'update', 'user-management/default', 1);
565INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
566	('/user-management/default/view', 'view', 'user-management/default', 1);
567/*!40000 ALTER TABLE `route` ENABLE KEYS */;
568
569-- Dumping structure for table yarsi_april_wisuda.user
570CREATE TABLE IF NOT EXISTS `user` (
571  `id` int(11) NOT NULL AUTO_INCREMENT,
572  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
573  `auth_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
574  `password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
575  `password_reset_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
576  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
577  `status` smallint(6) NOT NULL DEFAULT '10' COMMENT '0: Inactive, 10: Active',
578  `created_at` int(11) DEFAULT NULL,
579  `updated_at` int(11) DEFAULT NULL,
580  `created_by` int(11) DEFAULT NULL,
581  `updated_by` int(11) DEFAULT NULL,
582  PRIMARY KEY (`id`)
583) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
584
585-- Dumping data for table yarsi_april_wisuda.user: ~3 rows (approximately)
586/*!40000 ALTER TABLE `user` DISABLE KEYS */;
587INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
588	(1, 'superadmin', NULL, '$2y$13$sUApP3sHtiVQDkPY9VLQyOMoeWQ2FubL/6UlerVQRYqGRpy7CsL5i', NULL, 'apps@gmail.com', 10, 1509549909, 1547140353, 1, 1);
589INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
590	(2, 'admin', NULL, '$2y$13$NPT6WHR7AVAUNZx0m/zik.aXDsc0ej9AJZy49xj8u.fRmqxvnb9zO', NULL, 'admin@gmail.com', 10, 1551194947, 1551978375, 7, 1);
591INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
592	(3, 'manager', NULL, '$2y$13$7OWsWhh2UTkiQmT5Zr2Q7ewMWC30mBWuScUu8EHf.Wsf54qCDL7vi', NULL, 'haifahrul@gmail.com', 10, 1550349482, 1550349526, 1, 1);
593/*!40000 ALTER TABLE `user` ENABLE KEYS */;
594
595-- Dumping structure for table yarsi_april_wisuda.user_profile
596CREATE TABLE IF NOT EXISTS `user_profile` (
597  `user_id` int(11) NOT NULL,
598  `firstname` varchar(50) DEFAULT NULL,
599  `lastname` varchar(50) DEFAULT NULL,
600  `fullname` varchar(50) DEFAULT NULL,
601  `no_telp` varchar(50) DEFAULT NULL,
602  `avatar` varchar(225) DEFAULT NULL,
603  `alamat` mediumtext,
604  `created_at` int(11) DEFAULT NULL,
605  `created_by` int(11) DEFAULT NULL,
606  `updated_by` int(11) DEFAULT NULL,
607  `updated_at` int(11) DEFAULT NULL,
608  PRIMARY KEY (`user_id`),
609  CONSTRAINT `FK_user_profile_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
610) ENGINE=InnoDB DEFAULT CHARSET=utf8;
611
612-- Dumping data for table yarsi_april_wisuda.user_profile: ~3 rows (approximately)
613/*!40000 ALTER TABLE `user_profile` DISABLE KEYS */;
614INSERT INTO `user_profile` (`user_id`, `firstname`, `lastname`, `fullname`, `no_telp`, `avatar`, `alamat`, `created_at`, `created_by`, `updated_by`, `updated_at`) VALUES
615	(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
616INSERT INTO `user_profile` (`user_id`, `firstname`, `lastname`, `fullname`, `no_telp`, `avatar`, `alamat`, `created_at`, `created_by`, `updated_by`, `updated_at`) VALUES
617	(2, 'admin', 'admin', NULL, NULL, NULL, NULL, 1551194947, 7, 7, 1551194947);
618INSERT INTO `user_profile` (`user_id`, `firstname`, `lastname`, `fullname`, `no_telp`, `avatar`, `alamat`, `created_at`, `created_by`, `updated_by`, `updated_at`) VALUES
619	(3, 'Yadi ', 'Suryadi', '', NULL, NULL, NULL, 1550349482, 1, 1, 1550349482);
620/*!40000 ALTER TABLE `user_profile` ENABLE KEYS */;
621
622/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
623/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
624/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;