ncQLacL5

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.7.24-0ubuntu0.18.04.1 - (Ubuntu)
4-- Server OS:                    Linux
5-- HeidiSQL Version:             9.5.0.5196
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_ibnu.auth_item_child
15CREATE TABLE IF NOT EXISTS `auth_item_child` (
16  `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
17  `child` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
18  PRIMARY KEY (`parent`,`child`),
19  KEY `child` (`child`),
20  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
21  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24-- Dumping data for table yarsi_ibnu.auth_item_child: ~39 rows (approximately)
25/*!40000 ALTER TABLE `auth_item_child` DISABLE KEYS */;
26REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
27	('Super User', '/*');
28REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
29	('Data Master', '/admin/aspek-penilaian-tipe/*');
30REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
31	('Data Master', '/admin/aspek-penilaian/*');
32REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
33	('Basic Access', '/admin/default/index');
34REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
35	('Data Master', '/admin/fakultas-unit/*');
36REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
37	('Interviewer', '/admin/formulir/cetak');
38REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
39	('Administrator', '/admin/formulir/index');
40REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
41	('Interviewer', '/admin/formulir/index');
42REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
43	('Interviewer - Hasil Wawancara', '/admin/formulir/index');
44REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
45	('Administrator', '/admin/formulir/view');
46REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
47	('Interviewer', '/admin/formulir/view');
48REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
49	('Interviewer - Hasil Wawancara', '/admin/formulir/view');
50REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
51	('Data Master', '/admin/jabatan/*');
52REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
53	('Administrator', '/admin/jadwal-wawancara/*');
54REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
55	('Jadwal Wawancara Full Akses', '/admin/jadwal-wawancara/*');
56REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
57	('Interviewer', '/admin/jadwal-wawancara/index');
58REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
59	('Interviewer - Jadwal Wawancara', '/admin/jadwal-wawancara/index');
60REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
61	('Interviewer', '/admin/jadwal-wawancara/view');
62REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
63	('Interviewer - Jadwal Wawancara', '/admin/jadwal-wawancara/view');
64REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
65	('Data Master', '/admin/keputusan-tipe/*');
66REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
67	('Interviewer', '/admin/mulai-interview/*');
68REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
69	('Administrator', '/admin/profile/*');
70REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
71	('Basic Access', '/admin/profile/*');
72REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
73	('Administrator', '/admin/site/*');
74REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
75	('Basic Access', '/admin/site/*');
76REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
77	('Administrator', '/admin/user-calon/*');
78REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
79	('Interviewer - Data Calon', '/admin/user-calon/download-cv');
80REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
81	('Interviewer - Data Calon', '/admin/user-calon/index');
82REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
83	('Interviewer - Data Calon', '/admin/user-calon/view');
84REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
85	('Administrator', '/admin/user-interviewer/*');
86REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
87	('Basic Access', '/profile/*');
88REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
89	('Basic Access', '/site/*');
90REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
91	('Pelamar', '/site/*');
92REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
93	('Administrator', 'Basic Access');
94REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
95	('Interviewer', 'Basic Access');
96REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
97	('Administrator', 'Data Master');
98REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
99	('Interviewer', 'Interviewer - Data Calon');
100REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
101	('Interviewer', 'Interviewer - Hasil Wawancara');
102REPLACE INTO `auth_item_child` (`parent`, `child`) VALUES
103	('Interviewer', 'Interviewer - Jadwal Wawancara');
104/*!40000 ALTER TABLE `auth_item_child` ENABLE KEYS */;
105
106/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
107/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
108/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;