· 7 years ago · Feb 19, 2019, 10:38 AM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Server version: 5.7.19 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
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 zahironline_provider.menus
15CREATE TABLE IF NOT EXISTS `menus` (
16 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
17 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
18 `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
19 `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
20 `parent` int(11) NOT NULL,
21 `sort` int(11) NOT NULL,
22 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
23 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
24 PRIMARY KEY (`id`)
25) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
26
27-- Dumping data for table zahironline_provider.menus: ~27 rows (approximately)
28/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
29INSERT INTO `menus` (`id`, `name`, `url`, `description`, `parent`, `sort`, `created_at`, `updated_at`) VALUES
30 (1, 'Profile', '-', '-', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
31 (2, 'Service', '/memberservice', 'Servis Order', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
32 (3, 'Service Order', '/memberserviceorder', 'Member Service Order', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
33 (4, 'Database', '/db', 'List Database', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
34 (5, 'Invoice', '/admin/invoice', 'List Invoice', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
35 (6, 'DB Periode', '-', '-', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
36 (7, 'Contact', '/user', 'Contact', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
37 (8, 'List of Resellers', '/reseller', 'List of Zahir Resellers', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
38 (9, 'Variant', '-', '-', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
39 (10, 'Promo', '/promo', 'Promo Zahir', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
40 (11, 'Partner', '-', '-', 0, 0, '2019-02-18 15:10:17', '2019-02-18 15:10:17'),
41 (12, 'Dashboard', '/admin/profile/index', 'Dashboard Provider', 1, 0, '2019-02-18 15:56:19', '2019-02-18 15:56:19'),
42 (13, 'MRR Summary', '/mrr_summary', 'MRR Summary', 1, 0, '2019-02-18 15:56:21', '2019-02-18 15:56:21'),
43 (14, 'Subscription', '/dbPeriode', 'Harga per Period', 6, 0, '2019-02-18 15:56:35', '2019-02-18 15:56:35'),
44 (15, 'MRR Detail', '/mrr_detail', 'MRR Detail', 1, 0, '2019-02-18 15:56:22', '2019-02-18 15:56:22'),
45 (16, 'Add User', '/dbPeriodeUser', 'Harga per Period Add User', 6, 0, '2019-02-18 15:56:36', '2019-02-18 15:56:36'),
46 (17, 'Variant', '/variant', 'Variant', 9, 0, '2019-02-18 15:56:44', '2019-02-18 15:56:44'),
47 (18, 'Module', '/modul', 'Module Zahir', 9, 0, '2019-02-18 15:56:45', '2019-02-18 15:56:45'),
48 (19, 'Feature', '/fitur', 'Fitur Zahir', 9, 0, '2019-02-18 15:56:46', '2019-02-18 15:56:46'),
49 (20, 'Partner Classification', '/partner/classification', 'Partner Classification', 11, 0, '2019-02-18 15:57:11', '2019-02-18 15:57:11'),
50 (21, 'Referral Code', '/partner/referral-code', 'Partner Referral Code', 11, 0, '2019-02-18 15:57:12', '2019-02-18 15:57:12'),
51 (22, 'Referral Subdomain', '/partner/referral-code/referralSubdomain', 'Partner Referral Subdomain', 11, 0, '2019-02-18 15:57:13', '2019-02-18 15:57:13'),
52 (23, 'Report', '/partner/report', 'Report Referral Uses', 11, 0, '2019-02-18 15:57:16', '2019-02-18 15:57:16'),
53 (24, 'Report Summary', '/partner/report/summary', 'Report Referral Summary', 11, 0, '2019-02-18 15:57:17', '2019-02-18 15:57:17'),
54 (25, 'Bank Configuration', '/partner/configuration/bank', 'Bank Configuration', 11, 0, '2019-02-18 15:57:19', '2019-02-18 15:57:19'),
55 (26, 'Admin Fee Configuration', '/partner/configuration/adminFee', 'Admin Fee Configuration', 11, 0, '2019-02-18 15:57:21', '2019-02-18 15:57:21'),
56 (27, 'Tax Master Configuration', '/partner/configuration/taxMaster', 'Tax Master Configuration', 11, 0, '2019-02-18 15:57:23', '2019-02-18 15:57:23');
57/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
58
59/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
60/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;