· 8 years ago · Nov 10, 2017, 08:32 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.16 - MySQL Community Server (GPL)
4-- Server OS: Win32
5-- HeidiSQL Version: 8.3.0.4694
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for mot
14CREATE DATABASE IF NOT EXISTS `mot` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `mot`;
16
17
18-- Dumping structure for table mot.members
19CREATE TABLE IF NOT EXISTS `members` (
20 `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
21 `nama` varchar(250) COLLATE latin1_general_ci DEFAULT NULL,
22 `tanggal_lahir` date DEFAULT NULL,
23 `alamat` varchar(250) COLLATE latin1_general_ci DEFAULT NULL,
24 `email` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
25 `telepon` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
26 PRIMARY KEY (`id`)
27) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
28
29-- Dumping data for table mot.members: ~3 rows (approximately)
30DELETE FROM `members`;
31/*!40000 ALTER TABLE `members` DISABLE KEYS */;
32INSERT INTO `members` (`id`, `nama`, `tanggal_lahir`, `alamat`, `email`, `telepon`) VALUES
33 (1, 'Trest Amar', '2017-06-22', 'yk', 'trest@yahoo.com', '08889000766'),
34 (2, 'Mimi', '2015-06-02', 'Bantul', 'mimi@gmail.com', '0274-3569970'),
35 (4, 'Hanafi', '2013-06-01', 'Bandung', 'hana@gmail.com', '08974567834');
36/*!40000 ALTER TABLE `members` ENABLE KEYS */;
37
38
39-- Dumping structure for table mot.system_menu
40CREATE TABLE IF NOT EXISTS `system_menu` (
41 `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
42 `parent_id` int(20) unsigned NOT NULL DEFAULT '0',
43 `href` varchar(50) CHARACTER SET latin1 DEFAULT '#',
44 `code` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
45 `url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
46 `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
47 `order_number` int(11) unsigned NOT NULL DEFAULT '0',
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
50
51-- Dumping data for table mot.system_menu: ~7 rows (approximately)
52DELETE FROM `system_menu`;
53/*!40000 ALTER TABLE `system_menu` DISABLE KEYS */;
54INSERT INTO `system_menu` (`id`, `parent_id`, `href`, `code`, `url`, `name`, `order_number`) VALUES
55 (1, 0, '#', 'VIEW_DASHBOARD', 'dashboard.html', 'Dashboard', 0),
56 (2, 0, '#', 'VIEW_MENU', 'Menu', 'Menu', 2),
57 (3, 0, '#', 'VIEW_SETTING', 'Setting', 'Setting', 3),
58 (4, 3, '#', 'VIEW_HAK_AKSES', 'hak-akses.html', 'Hak Akses', 0),
59 (5, 3, '#', 'VIEW_USER_MANAGEMENT', 'user-management.html', 'User', 2),
60 (6, 0, '#', 'VIEW_MASTER', 'Master', 'Master', 1),
61 (7, 6, '#', 'VIEW_MASTER_MEMBERS', 'members.html', 'Master Member', 1);
62/*!40000 ALTER TABLE `system_menu` ENABLE KEYS */;
63
64
65-- Dumping structure for table mot.system_role
66CREATE TABLE IF NOT EXISTS `system_role` (
67 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
68 `nama` varchar(255) COLLATE latin1_general_ci NOT NULL,
69 PRIMARY KEY (`id`)
70) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
71
72-- Dumping data for table mot.system_role: ~2 rows (approximately)
73DELETE FROM `system_role`;
74/*!40000 ALTER TABLE `system_role` DISABLE KEYS */;
75INSERT INTO `system_role` (`id`, `nama`) VALUES
76 (1, 'ADMIN'),
77 (2, 'USER');
78/*!40000 ALTER TABLE `system_role` ENABLE KEYS */;
79
80
81-- Dumping structure for table mot.system_role_menu
82CREATE TABLE IF NOT EXISTS `system_role_menu` (
83 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
84 `menu_id` bigint(20) unsigned NOT NULL,
85 `role_id` bigint(20) unsigned NOT NULL,
86 `can_read` tinyint(4) DEFAULT '0',
87 `can_edit` tinyint(4) DEFAULT '0',
88 `can_save` tinyint(4) DEFAULT '0',
89 `can_delete` tinyint(4) DEFAULT '0',
90 `can_print` tinyint(4) DEFAULT '0',
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
93
94-- Dumping data for table mot.system_role_menu: ~14 rows (approximately)
95DELETE FROM `system_role_menu`;
96/*!40000 ALTER TABLE `system_role_menu` DISABLE KEYS */;
97INSERT INTO `system_role_menu` (`id`, `menu_id`, `role_id`, `can_read`, `can_edit`, `can_save`, `can_delete`, `can_print`) VALUES
98 (1, 1, 1, 1, 0, 0, 0, 0),
99 (2, 2, 1, 0, 0, 0, 0, 0),
100 (3, 3, 1, 1, 0, 0, 0, 0),
101 (4, 4, 1, 1, 0, 0, 0, 0),
102 (5, 5, 1, 1, 0, 0, 0, 0),
103 (6, 6, 1, 1, 0, 0, 0, 0),
104 (7, 7, 1, 1, 0, 0, 0, 0),
105 (37, 1, 2, 0, 0, 0, 0, 0),
106 (38, 6, 2, 1, 0, 0, 0, 0),
107 (39, 2, 2, 0, 0, 0, 0, 0),
108 (40, 3, 2, 0, 0, 0, 0, 0),
109 (41, 7, 2, 1, 0, 0, 0, 0),
110 (42, 4, 2, 0, 0, 0, 0, 0),
111 (43, 5, 2, 0, 0, 0, 0, 0);
112/*!40000 ALTER TABLE `system_role_menu` ENABLE KEYS */;
113
114
115-- Dumping structure for table mot.system_role_user
116CREATE TABLE IF NOT EXISTS `system_role_user` (
117 `id` bigint(10) NOT NULL AUTO_INCREMENT,
118 `user_id` bigint(10) NOT NULL,
119 `role_id` bigint(10) NOT NULL,
120 PRIMARY KEY (`id`)
121) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
122
123-- Dumping data for table mot.system_role_user: ~5 rows (approximately)
124DELETE FROM `system_role_user`;
125/*!40000 ALTER TABLE `system_role_user` DISABLE KEYS */;
126INSERT INTO `system_role_user` (`id`, `user_id`, `role_id`) VALUES
127 (1, 1, 1),
128 (2, 2, 2),
129 (3, 3, 1),
130 (4, 4, 2),
131 (5, 5, 1);
132/*!40000 ALTER TABLE `system_role_user` ENABLE KEYS */;
133
134
135-- Dumping structure for table mot.system_users
136CREATE TABLE IF NOT EXISTS `system_users` (
137 `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
138 `realname` varchar(255) CHARACTER SET latin1 NOT NULL,
139 `username` varchar(255) CHARACTER SET latin1 NOT NULL,
140 `password` varchar(255) CHARACTER SET latin1 NOT NULL,
141 `email` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
142 `is_delete` enum('Y','N') CHARACTER SET latin1 NOT NULL DEFAULT 'N',
143 `delete_by` bigint(20) DEFAULT NULL,
144 `delete_time` datetime DEFAULT NULL,
145 `role_id` bigint(20) NOT NULL,
146 PRIMARY KEY (`id`),
147 UNIQUE KEY `username` (`username`)
148) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
149
150-- Dumping data for table mot.system_users: ~4 rows (approximately)
151DELETE FROM `system_users`;
152/*!40000 ALTER TABLE `system_users` DISABLE KEYS */;
153INSERT INTO `system_users` (`id`, `realname`, `username`, `password`, `email`, `is_delete`, `delete_by`, `delete_time`, `role_id`) VALUES
154 (1, 'ADMIN', 'ADMIN', 'PASSWORD', '-', 'N', NULL, NULL, 1),
155 (2, 'user', 'username', 'nvkLHE+McjkP2ZNC9QVkPYB8ncArUuL+vScnUck4UqNuxJsVIX9X0apDmcpqqAud', 'user@gmail.com', 'N', NULL, NULL, 2),
156 (3, 'ceki', 'cek', '/V3MxMVIb5KUTMAhhF1kgvjHKIISQGq0qCAyEe8CZQv6mBciXlYZdDUMuK9+lyU0', 'cek@cek.com', 'N', NULL, NULL, 1),
157 (4, 'user', 'user', 'k6qNDXiCBn7wl5GGtaOXeW/0X83+9WrRFAUqWEeYfWGPC5TkXsn0xpXBjNR5nS9/', 'user@gmail.com', 'N', NULL, NULL, 2);
158/*!40000 ALTER TABLE `system_users` ENABLE KEYS */;
159/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
160/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
161/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;