· 10 years ago · Feb 25, 2016, 04:18 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 25, 2016 at 05:14 AM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `veboo`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `article`
21--
22
23CREATE TABLE IF NOT EXISTS `article` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `slug` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
26 `title` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
27 `body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
28 `view` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
29 `category_id` int(11) DEFAULT NULL,
30 `thumbnail_base_url` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
31 `thumbnail_path` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
32 `author_id` int(11) DEFAULT NULL,
33 `updater_id` int(11) DEFAULT NULL,
34 `status` smallint(6) NOT NULL DEFAULT '0',
35 `published_at` int(11) DEFAULT NULL,
36 `created_at` int(11) DEFAULT NULL,
37 `updated_at` int(11) DEFAULT NULL,
38 PRIMARY KEY (`id`),
39 KEY `fk_article_author` (`author_id`),
40 KEY `fk_article_updater` (`updater_id`),
41 KEY `fk_article_category` (`category_id`)
42) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `article_attachment`
48--
49
50CREATE TABLE IF NOT EXISTS `article_attachment` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `article_id` int(11) NOT NULL,
53 `path` varchar(255) CHARACTER SET latin1 NOT NULL,
54 `base_url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
55 `type` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
56 `size` int(11) DEFAULT NULL,
57 `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
58 `created_at` int(11) DEFAULT NULL,
59 PRIMARY KEY (`id`),
60 KEY `fk_article_attachment_article` (`article_id`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `article_category`
67--
68
69CREATE TABLE IF NOT EXISTS `article_category` (
70 `id` int(11) NOT NULL AUTO_INCREMENT,
71 `slug` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
72 `title` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
73 `body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
74 `parent_id` int(11) DEFAULT NULL,
75 `status` smallint(6) NOT NULL DEFAULT '0',
76 `created_at` int(11) DEFAULT NULL,
77 `updated_at` int(11) DEFAULT NULL,
78 PRIMARY KEY (`id`),
79 KEY `fk_article_category_section` (`parent_id`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
81
82--
83-- Dumping data for table `article_category`
84--
85
86INSERT INTO `article_category` (`id`, `slug`, `title`, `body`, `parent_id`, `status`, `created_at`, `updated_at`) VALUES
87(1, 'news', 'News', NULL, NULL, 1, 1441038957, NULL);
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `book`
93--
94
95CREATE TABLE IF NOT EXISTS `book` (
96 `book_id` int(11) NOT NULL AUTO_INCREMENT,
97 `user_id` int(11) NOT NULL,
98 `book_code` varchar(30) NOT NULL,
99 `vehicle_id` int(11) DEFAULT NULL,
100 `customer_id` int(11) DEFAULT NULL,
101 `book_date` datetime NOT NULL,
102 `start_date` date NOT NULL,
103 `end_date` date NOT NULL,
104 `days` int(11) DEFAULT NULL,
105 `quantity` smallint(6) NOT NULL,
106 `unit_price` tinyint(4) NOT NULL,
107 `start_from` smallint(6) NOT NULL DEFAULT '0',
108 `destination_to` smallint(6) NOT NULL DEFAULT '0',
109 `description` text CHARACTER SET latin1,
110 `book_status` tinyint(4) DEFAULT NULL,
111 `attributes_1` int(30) DEFAULT NULL,
112 `attributes_2` int(30) DEFAULT NULL,
113 `attributes_3` int(30) DEFAULT NULL,
114 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
115 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
116 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
117 PRIMARY KEY (`book_id`),
118 KEY `FK_FK_MC_B` (`customer_id`),
119 KEY `FK_FK_MV_B2` (`vehicle_id`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=155 ;
121
122--
123-- Dumping data for table `book`
124--
125
126INSERT INTO `book` (`book_id`, `user_id`, `book_code`, `vehicle_id`, `customer_id`, `book_date`, `start_date`, `end_date`, `days`, `quantity`, `unit_price`, `start_from`, `destination_to`, `description`, `book_status`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
127(150, 96, 'BV00000001', 15, 96, '2016-02-23 23:12:39', '2016-02-24', '2016-02-25', NULL, 2, 1, 0, 0, '-', 1, NULL, NULL, NULL, NULL, NULL, NULL),
128(151, 96, 'BV00000002', 15, 96, '2016-02-23 23:18:37', '2016-02-23', '2016-02-23', NULL, 1, 1, 0, 0, '-', 1, NULL, NULL, NULL, NULL, NULL, NULL),
129(152, 96, 'BV00000003', 15, 96, '2016-02-23 00:00:00', '2016-03-15', '2016-03-16', NULL, 2, 1, 5, 5, '-', 1, NULL, NULL, NULL, NULL, NULL, NULL),
130(153, 96, 'BV00000004', 15, 96, '2016-02-23 00:00:00', '2016-03-15', '2016-03-16', NULL, 2, 1, 5, 5, '-', 1, NULL, NULL, NULL, NULL, NULL, NULL),
131(154, 96, 'BV00000005', 15, 96, '2016-02-23 00:00:00', '2016-03-15', '2016-03-16', NULL, 2, 2, 5, 5, '-', 1, NULL, NULL, NULL, NULL, NULL, NULL);
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `driver`
137--
138
139CREATE TABLE IF NOT EXISTS `driver` (
140 `driver_id` int(11) NOT NULL AUTO_INCREMENT,
141 `vehicle_id` int(11) NOT NULL,
142 `user_id` int(11) NOT NULL,
143 `email` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
144 `ktp_number` bigint(20) DEFAULT NULL,
145 `name` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
146 `phone_number` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
147 `other_phone_number` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
148 `birth_place` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
149 `birth_date` date DEFAULT NULL,
150 `gender` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
151 `address` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
152 `postal_code` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
153 `religion` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
154 `driver_status` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
155 `country` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
156 `type_sim` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
157 `experience` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
158 `cost` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
159 `information` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
160 `avatar_path` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
161 `avatar_base_url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
162 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
163 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
164 `attributes_1` int(30) DEFAULT NULL,
165 `attributes_2` int(30) DEFAULT NULL,
166 `attributes_3` int(30) DEFAULT NULL,
167 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
168 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
169 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
170 PRIMARY KEY (`driver_id`),
171 KEY `FK_FK_MV_D` (`vehicle_id`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
173
174-- --------------------------------------------------------
175
176--
177-- Table structure for table `file_storage_item`
178--
179
180CREATE TABLE IF NOT EXISTS `file_storage_item` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `component` varchar(255) NOT NULL,
183 `base_url` varchar(1024) NOT NULL,
184 `path` varchar(1024) NOT NULL,
185 `type` varchar(255) DEFAULT NULL,
186 `size` int(11) DEFAULT NULL,
187 `name` varchar(255) DEFAULT NULL,
188 `upload_ip` varchar(15) DEFAULT NULL,
189 `created_at` int(11) NOT NULL,
190 PRIMARY KEY (`id`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=355 ;
192
193--
194-- Dumping data for table `file_storage_item`
195--
196
197INSERT INTO `file_storage_item` (`id`, `component`, `base_url`, `path`, `type`, `size`, `name`, `upload_ip`, `created_at`) VALUES
198(283, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/AxaQrXJACG5YIKKGdS0jt_bM3tqYtnWB.jpg', 'image/jpeg', 200209, 'AxaQrXJACG5YIKKGdS0jt_bM3tqYtnWB', '61.5.85.118', 1453708602),
199(284, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/Y0arU1doRujPOh55NKRsxAUWcjKXCWGE.jpg', 'image/jpeg', 197847, 'Y0arU1doRujPOh55NKRsxAUWcjKXCWGE', '61.5.85.118', 1453708811),
200(286, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/y7X0RVIieRVnmCd8KKcIM0Rd09tymzOt.jpg', 'image/jpeg', 200209, 'y7X0RVIieRVnmCd8KKcIM0Rd09tymzOt', '61.5.85.118', 1453709356),
201(287, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/RIRCAz-iqlZJhHdAav4Yg4QfWvMMirTN.jpg', 'image/jpeg', 197847, 'RIRCAz-iqlZJhHdAav4Yg4QfWvMMirTN', '61.5.85.118', 1453709369),
202(288, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/6GL66e8j33aWuHq1zs5XzwZizryzxRLG.jpg', 'image/jpeg', 174032, '6GL66e8j33aWuHq1zs5XzwZizryzxRLG', '61.5.85.118', 1453709379),
203(292, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/U1wf_ji7Ij2aQHjCQowgB4KRrlgKRPqL.jpg', 'image/jpeg', 200209, 'U1wf_ji7Ij2aQHjCQowgB4KRrlgKRPqL', '61.5.85.118', 1453715971),
204(293, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/sXqi9DBvKvdmuvqnh9nkPOrKIv0UkzhS.jpg', 'image/jpeg', 197847, 'sXqi9DBvKvdmuvqnh9nkPOrKIv0UkzhS', '61.5.85.118', 1453716180),
205(294, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/YIU0zMXgENpVDT87ryCKOxgz4YifiZOU.jpg', 'image/jpeg', 174032, 'YIU0zMXgENpVDT87ryCKOxgz4YifiZOU', '61.5.85.118', 1453716191),
206(295, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/aP6No20I-aPXnpA8lrmxDKT2qmqCl-8b.jpg', 'image/jpeg', 200209, 'aP6No20I-aPXnpA8lrmxDKT2qmqCl-8b', '61.5.85.118', 1453716325),
207(296, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/JZROGmTnKco8B6yVcatEWi344USCKzF4.jpg', 'image/jpeg', 197847, 'JZROGmTnKco8B6yVcatEWi344USCKzF4', '61.5.85.118', 1453716334),
208(297, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/7nsT3T08cVDSt9O2s71RJ6grnqWUDJwi.jpg', 'image/jpeg', 174032, '7nsT3T08cVDSt9O2s71RJ6grnqWUDJwi', '61.5.85.118', 1453716342),
209(298, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/nX8Xz56lFKQPBFIcMapylpCg_TjCBXBd.jpg', 'image/jpeg', 200209, 'nX8Xz56lFKQPBFIcMapylpCg_TjCBXBd', '61.5.85.118', 1453716586),
210(299, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/Vf-pRmt3iKvd5q-foAyG7VGhjUnZU6cE.jpg', 'image/jpeg', 197847, 'Vf-pRmt3iKvd5q-foAyG7VGhjUnZU6cE', '61.5.85.118', 1453716595),
211(300, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/4gfTNFzj0PSPZbyxFn7PU6Pz2m3HeRqY.jpg', 'image/jpeg', 174032, '4gfTNFzj0PSPZbyxFn7PU6Pz2m3HeRqY', '61.5.85.118', 1453716605),
212(301, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/Uy2ic8t7Dfzg8rFUtd5e1Pum03RSldFH.jpg', 'image/jpeg', 200209, 'Uy2ic8t7Dfzg8rFUtd5e1Pum03RSldFH', '61.5.85.118', 1453716804),
213(302, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/XHPVKla-jcbu5rjnJLVQYXjfActefJc7.jpg', 'image/jpeg', 197847, 'XHPVKla-jcbu5rjnJLVQYXjfActefJc7', '61.5.85.118', 1453716840),
214(303, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/G85Qmi-H7hdpus0HaCq68xfkCl-MTZkp.jpg', 'image/jpeg', 200209, 'G85Qmi-H7hdpus0HaCq68xfkCl-MTZkp', '61.5.85.118', 1453716896),
215(304, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/sym_LK1eF0MHcTdmPkB_sCy9fx0SEECP.png', 'image/png', 746042, 'sym_LK1eF0MHcTdmPkB_sCy9fx0SEECP', '125.161.202.55', 1453739174),
216(305, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/600ZlyWcYkKPxRfbf-koSTD-ZNggb30D.jpg', 'image/jpeg', 35344, '600ZlyWcYkKPxRfbf-koSTD-ZNggb30D', '125.161.202.55', 1453739259),
217(306, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/hViKQBqohXVvMvGZbUGIaPJidQFCTG2B.jpg', 'image/jpeg', 39862, 'hViKQBqohXVvMvGZbUGIaPJidQFCTG2B', '125.161.202.55', 1453739362),
218(307, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/EL4ezsfQV1UxI0MHBXPr8x7umvVA5U4D.jpg', 'image/jpeg', 35544, 'EL4ezsfQV1UxI0MHBXPr8x7umvVA5U4D', '125.161.202.55', 1453739426),
219(308, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/ToJx8GqLwjN-tqA_aCfzJai34HRahHbb.png', 'image/png', 357809, 'ToJx8GqLwjN-tqA_aCfzJai34HRahHbb', '125.161.202.55', 1453739502),
220(309, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/Ao_ZecdgowfFsyr1wirvjwKu4dacG3TX.jpg', 'image/jpeg', 48380, 'Ao_ZecdgowfFsyr1wirvjwKu4dacG3TX', '125.161.202.55', 1453739637),
221(310, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/EUmVpoNDVQZgS_5S_QfsNn9hU20gXsZv.jpg', 'image/jpeg', 353257, 'EUmVpoNDVQZgS_5S_QfsNn9hU20gXsZv', '125.161.202.55', 1453739796),
222(311, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/ew65t3Iwcv9FzooqjvVCwjM0DyVbGWsl.jpg', 'image/jpeg', 13853, 'ew65t3Iwcv9FzooqjvVCwjM0DyVbGWsl', '125.161.202.55', 1453740481),
223(312, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/AD73Z5soBQRPvX1oXgUtVvbYSqJ0oKcy.jpg', 'image/jpeg', 13052, 'AD73Z5soBQRPvX1oXgUtVvbYSqJ0oKcy', '36.84.155.81', 1453775329),
224(313, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/Ovdr3bPAfz8CUJwCApslfLDCEqAMQBf_.jpg', 'image/jpeg', 13052, 'Ovdr3bPAfz8CUJwCApslfLDCEqAMQBf_', '36.84.155.81', 1453777303),
225(314, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/eYx8NlX4SwkrzBBDtacL17TMfL29SlnO.gif', 'image/gif', 1165950, 'eYx8NlX4SwkrzBBDtacL17TMfL29SlnO', '36.84.155.81', 1453777349),
226(315, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/zsrD0Ks_nylgobkVzrSybx_2ttJM9LAR.jpg', 'image/jpeg', 13052, 'zsrD0Ks_nylgobkVzrSybx_2ttJM9LAR', '36.84.155.81', 1453777533),
227(316, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/QNtxYHYu-Yk6JZHOHsobWJjvlyelonWU.jpg', 'image/jpeg', 77305, 'QNtxYHYu-Yk6JZHOHsobWJjvlyelonWU', '36.84.155.81', 1453777562),
228(317, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/tKsGgparx1EFd2ySqA7mJ4LklWCRFHbf.png', 'image/png', 49703, 'tKsGgparx1EFd2ySqA7mJ4LklWCRFHbf', '36.84.155.81', 1453777603),
229(318, 'fileStorage', 'http://veboo.co.id/storage/web/source', '1/gxKAw4fR1-CaSS9G1RU1oq1kqgRjH7Ky.jpg', 'image/jpeg', 13052, 'gxKAw4fR1-CaSS9G1RU1oq1kqgRjH7Ky', '36.84.155.81', 1453777698),
230(320, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/lIpozo1_nMQtJrsgDwd2me7ECMjMl4eh.jpg', 'image/jpeg', 200209, 'lIpozo1_nMQtJrsgDwd2me7ECMjMl4eh', '::1', 1454152538),
231(321, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/zvwf1u-auzTW0ABJxSFPWSxQX9Gn-Eqf.jpg', 'image/jpeg', 197847, 'zvwf1u-auzTW0ABJxSFPWSxQX9Gn-Eqf', '::1', 1454152547),
232(322, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/HuRyHJQiQdrNntyG-y1Ge2hjFehy1MLJ.jpg', 'image/jpeg', 174032, 'HuRyHJQiQdrNntyG-y1Ge2hjFehy1MLJ', '::1', 1454152555),
233(323, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/f-UfeZk6O1YDsxDLt6nNQ9gV87HtnbdN.jpg', 'image/jpeg', 77305, 'f-UfeZk6O1YDsxDLt6nNQ9gV87HtnbdN', '::1', 1454157755),
234(324, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/gvaoPhVaYspJtaxeSJuHxKneT06YcDVu.png', 'image/png', 162959, 'gvaoPhVaYspJtaxeSJuHxKneT06YcDVu', '::1', 1454311207),
235(325, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/BpxADUYCwxxqkd108BwmBsYdWjOpforF.png', 'image/png', 5075, 'BpxADUYCwxxqkd108BwmBsYdWjOpforF', '::1', 1454389512),
236(326, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/Us59HDIYmTqLRg7SfjefA2inz0iXmFHR.png', 'image/png', 486191, 'Us59HDIYmTqLRg7SfjefA2inz0iXmFHR', '::1', 1454398374),
237(327, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/W15UU_ad8QA0-6idkv6rf4Wb1m7-E6Kb.jpg', 'image/jpeg', 1929035, 'W15UU_ad8QA0-6idkv6rf4Wb1m7-E6Kb', '::1', 1454557388),
238(328, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/fUmkiNkum00XbW9jkMbad7qjseOzUmii.jpg', 'image/jpeg', 37723, 'fUmkiNkum00XbW9jkMbad7qjseOzUmii', '::1', 1454562777),
239(329, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/8LvgHZTOm_r4NL67eLuSZlBUH4nPP9bc.jpg', 'image/png', 380058, '8LvgHZTOm_r4NL67eLuSZlBUH4nPP9bc', '::1', 1454562904),
240(330, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/uTvkpKaW_slhY5W8f-eKyzjNQEjUXe0H.jpg', 'image/jpeg', 30510, 'uTvkpKaW_slhY5W8f-eKyzjNQEjUXe0H', '::1', 1454563024),
241(331, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/ogA0IMZVUWeM4XS1AGth_OtztUYif9xH.png', 'image/png', 277359, 'ogA0IMZVUWeM4XS1AGth_OtztUYif9xH', '::1', 1454581378),
242(332, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/w01o9FBsJCRwXSd7S5PDBH5_jrugR4Nw.jpg', 'image/jpeg', 35553, 'w01o9FBsJCRwXSd7S5PDBH5_jrugR4Nw', '::1', 1454581381),
243(333, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/wu3scj39yPhIOJ-WHobSlE22rClOsVHP.jpg', 'image/jpeg', 51018, 'wu3scj39yPhIOJ-WHobSlE22rClOsVHP', '::1', 1454581383),
244(334, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/D-GfFyky8kd47EZWgjY769j_1hmJa640.png', 'image/png', 277359, 'D-GfFyky8kd47EZWgjY769j_1hmJa640', '::1', 1454582245),
245(335, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/O6aaxRe2Je6liHySewJIIhR9mZG9IaNZ.png', 'image/png', 277359, 'O6aaxRe2Je6liHySewJIIhR9mZG9IaNZ', '::1', 1454582288),
246(336, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/9i7bRBPtUC4jn34lvH6s5ZLGl829ciII.png', 'image/png', 277359, '9i7bRBPtUC4jn34lvH6s5ZLGl829ciII', '::1', 1454582299),
247(337, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/lYrujV0TaekYbb9AXlEIxQDwi5V-UTGe.jpg', 'image/jpeg', 30510, 'lYrujV0TaekYbb9AXlEIxQDwi5V-UTGe', '::1', 1454656102),
248(338, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/3DUQ8w8So-zG4ZprGntp-38seiyTaAXz.jpg', 'image/png', 380058, '3DUQ8w8So-zG4ZprGntp-38seiyTaAXz', '::1', 1455016738),
249(339, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/ppRqkv5Lvp-3zSPMhAFpXKSKkJf9LIyh.jpg', 'image/jpeg', 35553, 'ppRqkv5Lvp-3zSPMhAFpXKSKkJf9LIyh', '::1', 1455016775),
250(340, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/7sTb0NZw7qAW5xwP3OKBoKcqquuBA8Vb.jpg', 'image/jpeg', 35553, '7sTb0NZw7qAW5xwP3OKBoKcqquuBA8Vb', '::1', 1455019092),
251(341, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/u4MflraawoCs1N_WYA0UwcHE1qHikHOW.jpg', 'image/jpeg', 35553, 'u4MflraawoCs1N_WYA0UwcHE1qHikHOW', '::1', 1455019229),
252(342, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/XpGnvXvZ7rgVfT2oRKJgRKlqyBS0ZuqO.jpg', 'image/jpeg', 35553, 'XpGnvXvZ7rgVfT2oRKJgRKlqyBS0ZuqO', '::1', 1455019403),
253(343, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/nsqNfwluR1vLEmYDoToUIgMm5ZnpQeBB.jpg', 'image/jpeg', 35553, 'nsqNfwluR1vLEmYDoToUIgMm5ZnpQeBB', '::1', 1455028141),
254(344, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/yHmrHUp0oNQ3yRp7hquI_0vmvw7RhQA1.jpg', 'image/jpeg', 35553, 'yHmrHUp0oNQ3yRp7hquI_0vmvw7RhQA1', '::1', 1455028154),
255(345, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/E0qqAsYW34uD_NRQD9axJ5zNiSZdWJoF.jpg', 'image/jpeg', 35553, 'E0qqAsYW34uD_NRQD9axJ5zNiSZdWJoF', '::1', 1455028186),
256(346, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/TLgo8Cf6jGH_VipJpGQj9FokNVsAjMwi.jpg', 'image/jpeg', 35553, 'TLgo8Cf6jGH_VipJpGQj9FokNVsAjMwi', '::1', 1455028276),
257(347, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/sF8dOagG6HTuEcaPYYgD7pCZJoicPSvf.jpg', 'image/jpeg', 35553, 'sF8dOagG6HTuEcaPYYgD7pCZJoicPSvf', '::1', 1455091961),
258(348, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/u6tjwyM5vA8z-reODJT617M4yJLKaJN5.jpg', 'image/jpeg', 35553, 'u6tjwyM5vA8z-reODJT617M4yJLKaJN5', '::1', 1455092278),
259(349, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/zbP2K_TAtoejMpKnBvy76-GaGZn81MKf.jpg', 'image/jpeg', 30510, 'zbP2K_TAtoejMpKnBvy76-GaGZn81MKf', '::1', 1455095023),
260(350, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/HbQi8QLCLURQuMXAQ-ky-r7la4HbPAR6.gif', 'image/gif', 1165950, 'HbQi8QLCLURQuMXAQ-ky-r7la4HbPAR6', '::1', 1455193677),
261(351, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/6v2S70aajRgZlGasqZUHtHP54I_Li5OG.gif', 'image/gif', 1165950, '6v2S70aajRgZlGasqZUHtHP54I_Li5OG', '::1', 1455193794),
262(352, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/IhP_Ie0mPsldqMNY5iYP0_auG_k0SrND.gif', 'image/gif', 1165950, 'IhP_Ie0mPsldqMNY5iYP0_auG_k0SrND', '::1', 1455193843),
263(353, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/Ki2D72nA3OkwoX3xo3JoRaPShNJC-_mJ.png', 'image/png', 28263, 'Ki2D72nA3OkwoX3xo3JoRaPShNJC-_mJ', '::1', 1455196461),
264(354, 'fileStorage', 'http://localhost/veboo/storage/web/source', '1/6IQS8j--PHSnKh6eKGTS7tmTVt7TmyX0.png', 'image/png', 80270, '6IQS8j--PHSnKh6eKGTS7tmTVt7TmyX0', '::1', 1456204819);
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `i18n_message`
270--
271
272CREATE TABLE IF NOT EXISTS `i18n_message` (
273 `id` int(11) NOT NULL DEFAULT '0',
274 `language` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
275 `translation` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
276 PRIMARY KEY (`id`,`language`)
277) ENGINE=InnoDB DEFAULT CHARSET=utf8;
278
279--
280-- Dumping data for table `i18n_message`
281--
282
283INSERT INTO `i18n_message` (`id`, `language`, `translation`) VALUES
284(693, 'id', 'Aplikasi'),
285(694, 'id', 'Pengaturan Aplikasi'),
286(695, 'id', 'Backend sidebar collapsed'),
287(696, 'id', 'Backend theme'),
288(697, 'id', 'Boxed backend layout'),
289(698, 'id', 'Tempat penyimpanan sementara'),
290(699, 'id', 'Cache entry has been successfully deleted'),
291(700, 'id', 'Cache has been successfully flushed'),
292(701, 'id', 'Tanggal'),
293(702, 'id', '{code} Kesalahan'),
294(703, 'id', 'Kejadian'),
295(704, 'id', 'Perempuan'),
296(705, 'id', 'Fixed backend layout'),
297(706, 'id', 'Frontend maintenance mode'),
298(707, 'id', 'Laki-laki'),
299(708, 'id', 'Pengguna ({identity}) telah mendaftar pada {created_at}'),
300(709, 'id', 'Roles'),
301(710, 'id', 'Nama pengguna telah digunakan'),
302(711, 'id', 'Lihat pengguna'),
303(712, 'id', 'Anda memiliki kejadian baru'),
304(713, 'id', 'Anda memiliki pengguna baru'),
305(714, 'id', 'Akun'),
306(715, 'id', 'Aktif'),
307(716, 'id', 'Application timeline'),
308(717, 'id', 'Apakah anda yakin akan menghapus item ini?'),
309(718, 'id', 'Apakah anda yakin akan menghapus tempat penyimpanan sementara ini?'),
310(719, 'id', 'Kategori Artikel'),
311(720, 'id', 'ArtÃkel'),
312(721, 'id', 'Penggunaan CPU'),
313(722, 'id', 'Carousel Widgets'),
314(723, 'id', 'Carousel slide wberhasil disimpan'),
315(724, 'id', 'Kategori'),
316(725, 'id', 'Bersihkan'),
317(726, 'id', 'Muatan'),
318(727, 'id', 'Total'),
319(728, 'id', 'Simpan'),
320(729, 'id', 'Simpan {modelClass}'),
321(730, 'id', 'DB Type'),
322(731, 'id', 'DB Version'),
323(732, 'id', 'Hapus'),
324(733, 'id', 'Hapus sebuah nilai dengan spesifikasi kunci dari tempat penyimpanan'),
325(734, 'id', 'Tidak Aktif'),
326(735, 'id', 'Ubah Akun'),
327(736, 'id', 'Ubah profil'),
328(737, 'id', 'Email'),
329(738, 'id', 'Aktif'),
330(739, 'id', 'Kesalahan #{id}'),
331(740, 'id', 'IP External'),
332(741, 'id', 'File Manager'),
333(742, 'id', 'File Storage'),
334(743, 'id', 'Item penyimpanan file'),
335(744, 'id', 'File di tempat penyimpanan'),
336(745, 'id', 'Flush'),
337(746, 'id', 'Free Swap'),
338(747, 'id', 'Memori bebas'),
339(748, 'id', 'Halo, {username}'),
340(749, 'id', 'Hostname'),
341(750, 'id', 'I18n Messages'),
342(751, 'id', 'I18n Source Messages'),
343(752, 'id', 'ID'),
344(753, 'id', 'Jika Anda akan meninggalkan bidang ini kosong, slug akan dihasilkan secara otomatis'),
345(754, 'id', 'Username atau password salah'),
346(755, 'id', 'IP internal'),
347(756, 'id', 'Invalidate tag'),
348(757, 'id', 'Versi kernel'),
349(758, 'id', 'Key'),
350(759, 'id', 'Key Storage Items'),
351(760, 'id', 'Key-Value Storage'),
352(761, 'id', 'Bahasa'),
353(762, 'id', 'Level'),
354(763, 'id', 'Load average'),
355(764, 'id', 'Log Time'),
356(765, 'id', 'Keluar'),
357(766, 'id', 'Logs'),
358(767, 'id', 'Anggota sejak {0, date, short}'),
359(768, 'id', 'Memori'),
360(769, 'id', 'Penggunaan Memori'),
361(770, 'id', 'Widgets del Menú'),
362(771, 'id', 'Pesan'),
363(772, 'id', 'Info selengkapnya'),
364(773, 'id', 'Jaringan'),
365(774, 'id', 'Kejadian tidak ditemukan'),
366(775, 'id', 'Tidak Dipublikasi'),
367(776, 'id', 'Notifikasi'),
368(777, 'id', 'Nomor dari inti'),
369(778, 'id', 'SO'),
370(779, 'id', 'Rilis OS'),
371(780, 'id', 'Mati'),
372(781, 'id', 'Melayani Penawaran'),
373(782, 'id', 'Melayani Penawaran'),
374(783, 'id', 'Melayani Penawaran Saya'),
375(784, 'id', 'Nyala'),
376(785, 'id', 'Sistem Operasi'),
377(786, 'id', 'Versi PHP'),
378(787, 'id', 'Halaman'),
379(788, 'id', 'Kata Sandi'),
380(789, 'id', 'Konfirmasi Kata Sandi'),
381(790, 'id', 'Port'),
382(791, 'id', 'Prefix'),
383(792, 'id', 'Prosesor'),
384(793, 'id', 'Arsitektur Prosesor'),
385(794, 'id', 'Profil'),
386(795, 'id', 'Terpublikasi'),
387(796, 'id', 'Waktu sebenarnya'),
388(797, 'id', 'Ingat saya'),
389(798, 'id', 'Setel ulang'),
390(799, 'id', 'Simpan'),
391(800, 'id', 'Cari'),
392(801, 'id', 'Pilih tempat penyimpanan'),
393(802, 'id', 'Masuk'),
394(803, 'id', 'Masuk'),
395(804, 'id', 'Perangkat Lunak'),
396(805, 'id', 'Maaf, aplikasi gagal untuk mendapatkan informasi tentang sistem Anda. Lihat {link}'),
397(806, 'id', 'Source Message'),
398(807, 'id', 'Static pages'),
399(808, 'id', 'Sistem'),
400(809, 'id', 'Sistem Tanggal'),
401(810, 'id', 'Sistem Informasi'),
402(811, 'id', 'Sistem Log'),
403(812, 'id', 'Sistem Waktu'),
404(813, 'id', 'Label'),
405(814, 'id', 'TagDependency was invalidated'),
406(815, 'id', 'Text Blocks'),
407(816, 'id', 'Text Widgets'),
408(817, 'id', 'Harga unit ini sudah dibuat'),
409(818, 'id', 'Tipe kapasitas ini sudah dibuat'),
410(819, 'id', 'Waktu'),
411(820, 'id', 'Timeline'),
412(821, 'id', 'Timezone'),
413(822, 'id', ' Toggle Navigation'),
414(823, 'id', 'Total Swap'),
415(824, 'id', 'Total Memori'),
416(825, 'id', 'Terjemahkan'),
417(826, 'id', 'Ubah'),
418(827, 'id', 'Memperbarui {modelClass}:'),
419(828, 'id', 'waktu penggunaan'),
420(829, 'id', 'Jumlah Penggunaan'),
421(830, 'id', 'Registrasi Pengguna'),
422(831, 'id', 'Nama akun'),
423(832, 'id', 'Pengguna'),
424(833, 'id', 'Lihat Semua'),
425(834, 'id', 'Server Web'),
426(835, 'id', 'Widget Carousel Items'),
427(836, 'id', 'Widget Carousels'),
428(837, 'id', 'Widget Menus'),
429(838, 'id', 'Kamu memiliki {num} item log'),
430(839, 'id', 'Akun anda berhasil disimpan'),
431(840, 'id', 'Profil anda berhasil disimpan'),
432(841, 'id', 'Internacionalización'),
433(842, 'id', 'Mensaje i18n'),
434(843, 'id', 'Mensaje fuente i18n'),
435(844, 'id', '"{attribute}" debe de ser JSON válido'),
436(845, 'id', 'Lihat Artikel'),
437(846, 'id', 'Aktif'),
438(847, 'id', 'ID Artikel'),
439(848, 'id', 'Penulis'),
440(849, 'id', 'URL Base'),
441(850, 'id', 'Url Base'),
442(851, 'id', 'Bodi'),
443(852, 'id', 'Leyenda'),
444(853, 'id', 'Carrusel ID'),
445(854, 'id', 'Kategori'),
446(855, 'id', 'Komentar'),
447(856, 'id', 'Componente'),
448(857, 'id', 'Konfigurasi'),
449(858, 'id', 'Tanggal Pembuatan'),
450(859, 'id', 'Tanggal Pembuatan'),
451(860, 'id', 'Telah dihapus'),
452(861, 'id', 'Sedang dalam perawatan.'),
453(862, 'id', 'E-mail'),
454(863, 'id', 'Tipe File'),
455(864, 'id', 'Nama Depan'),
456(865, 'id', 'Jenis Kelamin'),
457(866, 'id', 'ID'),
458(867, 'id', 'Avatar'),
459(868, 'id', 'Kunci'),
460(869, 'id', 'Login Terakhir'),
461(870, 'id', 'Nama Terakhir'),
462(871, 'id', 'Bahasa'),
463(872, 'id', 'Nama Tengah'),
464(873, 'id', 'Nama'),
465(874, 'id', 'Pemesanan'),
466(875, 'id', 'Lihat Halaman'),
467(876, 'id', 'Kategori Orangtua'),
468(877, 'id', 'Ruta'),
469(878, 'id', 'Halaman tidak ditemukan.'),
470(879, 'id', 'Orang'),
471(880, 'id', 'Gambar'),
472(881, 'id', 'Publikasi'),
473(882, 'id', 'Tanggal Publikasi'),
474(883, 'id', 'Bangku'),
475(884, 'id', 'Ukuran'),
476(885, 'id', 'Slug'),
477(886, 'id', 'Status'),
478(887, 'id', 'Simpan'),
479(888, 'id', 'Miniatur'),
480(889, 'id', 'Title'),
481(890, 'id', 'Tipe'),
482(891, 'id', 'Diperbaharui'),
483(892, 'id', 'Diperbaharui'),
484(893, 'id', 'Actualizado por'),
485(894, 'id', 'Ubah'),
486(895, 'id', 'IP'),
487(896, 'id', 'Url'),
488(897, 'id', 'ID Pengguna'),
489(898, 'id', 'Nama Pengguna'),
490(899, 'id', 'Valor'),
491(900, 'id', 'Anda tidak diizinkan untuk mengakses halaman ini'),
492(901, 'id', '1. Penyedia Kendaraan'),
493(902, 'id', '2. Penyewa/Pelanggan Kendaraan'),
494(903, 'id', 'Tentang Kami'),
495(904, 'id', 'Tentang'),
496(905, 'id', 'Pengaturan Akun'),
497(906, 'id', 'Semua'),
498(907, 'id', 'Artikel'),
499(908, 'id', 'Lampiran'),
500(909, 'id', 'Kendaraan'),
501(910, 'id', 'Meja Kantor'),
502(911, 'id', 'Сообщение'),
503(912, 'id', 'Reservasi'),
504(913, 'id', 'Reservasi Sekarang'),
505(914, 'id', 'Reservasi'),
506(915, 'id', 'Reservasi Kendaraan'),
507(916, 'id', 'Kembali'),
508(917, 'id', 'Menyiarkan Peluang'),
509(918, 'id', 'Cek email anda untuk instruksi lebih lanjut.'),
510(919, 'id', 'Konfirmasi Kata Sandi'),
511(920, 'id', 'Karir'),
512(921, 'id', 'Kontak Kami'),
513(922, 'id', 'Kontak'),
514(923, 'id', 'Konfirmasi'),
515(924, 'id', 'Bergabung'),
516(925, 'id', 'Pilih'),
517(926, 'id', 'Pilih Area'),
518(927, 'id', 'Pelanggan'),
519(928, 'id', 'Kapasitas'),
520(929, 'id', 'Perusahaan'),
521(930, 'id', 'Warna'),
522(931, 'id', 'Telpon Pemilik'),
523(932, 'id', 'Membuat Peluang'),
524(933, 'id', 'Perbarui Peluang'),
525(934, 'id', 'Batal'),
526(935, 'id', 'E-mail'),
527(936, 'id', 'Email'),
528(937, 'id', 'Ubah Akun'),
529(938, 'id', 'Ubah Akun Saya'),
530(939, 'id', 'Ubah Profil'),
531(940, 'id', 'Ubah Profil Saya'),
532(941, 'id', 'Tanggal Kembali'),
533(942, 'id', 'Masukkan email Anda untuk mendapatkan berita terbaru, penjualan dan hadiah'),
534(943, 'id', 'Masukkan email Anda'),
535(944, 'id', 'Kesalahan saat proses oauth.'),
536(945, 'id', 'Cari'),
537(946, 'id', 'Perempuan'),
538(947, 'id', 'Dapatkan lebih banyak peluang dari ribuan pelanggan kami, Anda dapat mendaftarkan semua kendaraan anda dan mengatur transaksi booking anda sendiri. VEBOO akan mengirimkan notifikasi booking pada kendaraan anda melalui smart-phone.'),
539(948, 'id', 'Masuk ke profile saya'),
540(949, 'id', 'Beranda'),
541(950, 'id', 'Jika anda lupa password anda, anda dapat mengatur ulang <a href="{link}">disini</a>'),
542(951, 'id', 'Nama Pengguna atau Kata Sandi Salah.'),
543(952, 'id', 'Akun anda telah diaktivasi'),
544(953, 'id', 'Kotak Masuk'),
545(954, 'id', 'Bahasa'),
546(955, 'id', 'Masuk dengan'),
547(956, 'id', 'Masuk'),
548(957, 'id', 'Keluar'),
549(958, 'id', 'Laki-laki'),
550(959, 'id', 'Reservasi Saya'),
551(960, 'id', 'Surat Kabar'),
552(961, 'id', 'Nama'),
553(962, 'id', 'Butuh Akun? Daftar'),
554(963, 'id', 'Tidak ada deskripsi'),
555(964, 'id', 'Sandi telah disimpan'),
556(965, 'id', 'Solusi kami akan membantu anda untuk menciptakan peluang baru ketika kendaaran anda siap digunakan. Pelanggan kami akan memilih kendaraan anda untuk membawa muatan / sewa atau membuat kesepakatan langsung dengan pelanggan.'),
557(966, 'id', 'Melayani Penawaran'),
558(967, 'id', 'Melayani Penawaran'),
559(968, 'id', 'Daftar Penawaran'),
560(969, 'id', 'Reservasi Penawaran'),
561(970, 'id', 'Hanya pelanggan yang dapat menggunakan fitur pemesanan'),
562(971, 'id', 'Halaman tidak ditemukan.'),
563(972, 'id', 'Kata Sandi'),
564(973, 'id', 'Setel ulang kata sandi untuk {name}'),
565(974, 'id', 'Pengaturan Profil'),
566(975, 'id', 'Silakan memperbarui profil Anda beberapa saat dengan gambar dan beberapa rincian tentang diri Anda. Pemilik kendaraan akan lebih cepat merespon kepada pelanggan dengan profil yang lengkap.'),
567(976, 'id', 'Silakan memperbarui profil Anda beberapa saat dengan gambar dan beberapa rincian tentang diri Anda. Pelanggan akan lebih cepat merespon kepada pemilik kendaraan dengan profil yang lengkap.'),
568(977, 'id', 'Silahkan hubungi kami '),
569(978, 'id', 'Silahkan Lengkapi Pencarian Reservasi'),
570(979, 'id', 'Silahkan masuk untuk mengubah profil Anda'),
571(980, 'id', 'Ingat Saya'),
572(981, 'id', 'Permintaan setel ulang kata sandi'),
573(982, 'id', 'Setel Ulang Kata Sandi'),
574(983, 'id', 'Daftar'),
575(984, 'id', 'Daftar dengan'),
576(985, 'id', 'Tanggal Pinjam'),
577(986, 'id', 'Solusi'),
578(987, 'id', 'Daftar'),
579(988, 'id', 'Daftar'),
580(989, 'id', 'Maaf, kami tidak dapat me-reset password untuk email tersedia.'),
581(990, 'id', 'Subjek'),
582(991, 'id', 'Berlangganan'),
583(992, 'id', 'Cari'),
584(993, 'id', 'Pengaturan'),
585(994, 'id', 'Submit'),
586(995, 'id', 'Bagikan'),
587(996, 'id', 'Lihat Hasil'),
588(997, 'id', 'Terima kasih telah tertarik dengan VEBOO, kami siap untuk melayani Anda'),
589(998, 'id', 'Terima kasih sudah menghubungi kami. Kami akan merespon anda secepatnya.'),
590(999, 'id', 'Ada kesalahan saat mengirim email.'),
591(1000, 'id', 'Alamat email ini sudah digunakan.'),
592(1001, 'id', 'Nama pengguna ini sudah digunakan'),
593(1002, 'id', 'Transmisi'),
594(1003, 'id', 'Pantau kendaraan anda kemanapun dia pergi. Solusi ini membantu pemilik memantau kendaraan secara real time, melihat histori perjalanan dan memberikan peringatan ketika terdapat suatu kejadian yang membutuhkan perhatian anda.'),
595(1004, 'id', 'Ikuti'),
596(1005, 'id', 'Ubah'),
597(1006, 'id', 'Nama Pengguna'),
598(1007, 'id', 'Nama pengguna atau email'),
599(1008, 'id', 'Pengaturan Pengguna'),
600(1009, 'id', 'Verifikasi kode'),
601(1010, 'id', 'Lihat'),
602(1011, 'id', 'Lihat Rincian'),
603(1012, 'id', 'Kendaraan'),
604(1013, 'id', 'Daftar Sebagai'),
605(1014, 'id', 'Anda harus login untuk pemesanan kendaraan.'),
606(1015, 'id', 'Anda terdaftar sebagai penyedia kendaraan'),
607(1016, 'id', 'Anda terdaftar sebagai pelanggan'),
608(1017, 'id', 'Kami sudah memiliki pengguna dengan email {email}.'),
609(1018, 'id', 'Selamat datang di {app-name}. Email dengan informasi login Anda telah dikirim ke email Anda.'),
610(1019, 'id', 'Selamat Datang'),
611(1020, 'id', 'Mengapa Memilih Kami'),
612(1021, 'id', 'Profil anda berhasil disimpan'),
613(1022, 'id', 'Profil anda gagal disimpan'),
614(1023, 'id', 'Akun anda berhasil disimpan'),
615(1024, 'id', 'Pendaftaran telah selesai'),
616(1025, 'id', 'Pendaftaran anggota gagal'),
617(1026, 'id', 'Akun anda telah aktif'),
618(1027, 'id', '{app-name} | Informasi login Anda'),
619(1028, 'id', 'PROBLEMATIKA'),
620(1029, 'id', 'Permasalahan umum bagi perusahaan penyedia kendaraan adalah ketika sudah menginvestasikan dana dalam pembelian kendaraan untuk memulai bisnis akan tetapi, aset yang telah dibeli tidak bisa mencapai target yang telah direncanakan. Hal ini bisa disebabkan oleh banyaknya aset yang tidak bisa diutilisasi secara maksimal karena hanya melayani pelanggan dalam jumlah yang sedikit sehingga menjadi beban dan menghambat dalam perkembangan bisnis.'),
621(1030, 'id', 'Melihat permasalahan diatas Veboo hadir sebagai pemberi solusi bagi perusahaan penyedia kendaraan dan perusahaan penyewa kendaraan untuk bisa saling bertemu dan berkolaborasi dalam memperbaiki layanan secara bersama. Perusahaan penyewa kendaraan bisa dengan mudah mencari dan menyewa langsung kepada penyedia kendaraan sesuai dengan kriteria yang dibutuhkan.'),
622(1031, 'id', 'Ketika perusahaan penyewa membutuhkan harga yang kompetitif, maka perusahaan penyewa dapat membuat iklan atau mengumumkan kebutuhan layanan kepada perusahaan penyedia kendaraan sehingga perusahaan penyewa bisa mendapatkan penawaran secara cepat, kompetitif dan bersaing.'),
623(1032, 'id', 'Keuntungan yang lain bagi perusahaan penyedia kendaraan adalah segala proses transaksi baik pemesanan, penagihan, operasional dan perawatan semuanya bisa diatur dengan sistem dari Veboo, real time, tanpa repot dan bisa dipantau dimana saja.'),
624(1033, 'id', 'Kami Siap Membantu Anda'),
625(1034, 'id', 'Solusi Terbaik Untuk Bisnis Anda'),
626(1035, 'id', 'Telepon Kami');
627
628-- --------------------------------------------------------
629
630--
631-- Table structure for table `i18n_source_message`
632--
633
634CREATE TABLE IF NOT EXISTS `i18n_source_message` (
635 `id` int(11) NOT NULL AUTO_INCREMENT,
636 `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
637 `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
638 PRIMARY KEY (`id`)
639) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1036 ;
640
641--
642-- Dumping data for table `i18n_source_message`
643--
644
645INSERT INTO `i18n_source_message` (`id`, `category`, `message`) VALUES
646(693, 'backend', 'Application'),
647(694, 'backend', 'Application settings'),
648(695, 'backend', 'Backend sidebar collapsed'),
649(696, 'backend', 'Backend theme'),
650(697, 'backend', 'Boxed backend layout'),
651(698, 'backend', 'Cache'),
652(699, 'backend', 'Cache entry has been successfully deleted'),
653(700, 'backend', 'Cache has been successfully flushed'),
654(701, 'backend', 'Date'),
655(702, 'backend', 'Error {code}'),
656(703, 'backend', 'Event'),
657(704, 'backend', 'Female'),
658(705, 'backend', 'Fixed backend layout'),
659(706, 'backend', 'Frontend maintenance mode'),
660(707, 'backend', 'Male'),
661(708, 'backend', 'New user ({identity}) was registered at {created_at}'),
662(709, 'backend', 'Roles'),
663(710, 'backend', 'This username has already been taken.'),
664(711, 'backend', 'View user'),
665(712, 'backend', 'You have new event'),
666(713, 'backend', 'You have new user!'),
667(714, 'backend', 'Account'),
668(715, 'backend', 'Active'),
669(716, 'backend', 'Application timeline'),
670(717, 'backend', 'Are you sure you want to delete this item?'),
671(718, 'backend', 'Are you sure you want to flush this cache?'),
672(719, 'backend', 'Article Categories'),
673(720, 'backend', 'Articles'),
674(721, 'backend', 'CPU Usage'),
675(722, 'backend', 'Carousel Widgets'),
676(723, 'backend', 'Carousel slide was successfully saved'),
677(724, 'backend', 'Category'),
678(725, 'backend', 'Clear'),
679(726, 'backend', 'Content'),
680(727, 'backend', 'Count'),
681(728, 'backend', 'Create'),
682(729, 'backend', 'Create {modelClass}'),
683(730, 'backend', 'DB Type'),
684(731, 'backend', 'DB Version'),
685(732, 'backend', 'Delete'),
686(733, 'backend', 'Delete a value with the specified key from cache'),
687(734, 'backend', 'Disabled'),
688(735, 'backend', 'Edit account'),
689(736, 'backend', 'Edit profile'),
690(737, 'backend', 'Email'),
691(738, 'backend', 'Enabled'),
692(739, 'backend', 'Error #{id}'),
693(740, 'backend', 'External IP'),
694(741, 'backend', 'File Manager'),
695(742, 'backend', 'File Storage'),
696(743, 'backend', 'File Storage Items'),
697(744, 'backend', 'Files in storage'),
698(745, 'backend', 'Flush'),
699(746, 'backend', 'Free Swap'),
700(747, 'backend', 'Free memory'),
701(748, 'backend', 'Hello, {username}'),
702(749, 'backend', 'Hostname'),
703(750, 'backend', 'I18n Messages'),
704(751, 'backend', 'I18n Source Messages'),
705(752, 'backend', 'ID'),
706(753, 'backend', 'If you''ll leave this field empty, slug will be generated automatically'),
707(754, 'backend', 'Incorrect username or password.'),
708(755, 'backend', 'Internal IP'),
709(756, 'backend', 'Invalidate tag'),
710(757, 'backend', 'Kernel version'),
711(758, 'backend', 'Key'),
712(759, 'backend', 'Key Storage Items'),
713(760, 'backend', 'Key-Value Storage'),
714(761, 'backend', 'Language'),
715(762, 'backend', 'Level'),
716(763, 'backend', 'Load average'),
717(764, 'backend', 'Log Time'),
718(765, 'backend', 'Logout'),
719(766, 'backend', 'Logs'),
720(767, 'backend', 'Member since {0, date, short}'),
721(768, 'backend', 'Memory'),
722(769, 'backend', 'Memory Usage'),
723(770, 'backend', 'Menu Widgets'),
724(771, 'backend', 'Message'),
725(772, 'backend', 'More info'),
726(773, 'backend', 'Network'),
727(774, 'backend', 'No events found'),
728(775, 'backend', 'Not Published'),
729(776, 'backend', 'Notification'),
730(777, 'backend', 'Number of cores'),
731(778, 'backend', 'OS'),
732(779, 'backend', 'OS Release'),
733(780, 'backend', 'Off'),
734(781, 'backend', 'Offering Service'),
735(782, 'backend', 'Offering Services'),
736(783, 'backend', 'My Offering Service'),
737(784, 'backend', 'On'),
738(785, 'backend', 'Operating System'),
739(786, 'backend', 'PHP Version'),
740(787, 'backend', 'Pages'),
741(788, 'backend', 'Password'),
742(789, 'backend', 'Password Confirm'),
743(790, 'backend', 'Port'),
744(791, 'backend', 'Prefix'),
745(792, 'backend', 'Processor'),
746(793, 'backend', 'Processor Architecture'),
747(794, 'backend', 'Profile'),
748(795, 'backend', 'Published'),
749(796, 'backend', 'Real time'),
750(797, 'backend', 'Remember Me'),
751(798, 'backend', 'Reset'),
752(799, 'backend', 'Save'),
753(800, 'backend', 'Search'),
754(801, 'backend', 'Select cache'),
755(802, 'backend', 'Sign In'),
756(803, 'backend', 'Sign me in'),
757(804, 'backend', 'Software'),
758(805, 'backend', 'Sorry, application failed to collect information about your system. See {link}.'),
759(806, 'backend', 'Source Message'),
760(807, 'backend', 'Static pages'),
761(808, 'backend', 'System'),
762(809, 'backend', 'System Date'),
763(810, 'backend', 'System Information'),
764(811, 'backend', 'System Logs'),
765(812, 'backend', 'System Time'),
766(813, 'backend', 'Tag'),
767(814, 'backend', 'TagDependency was invalidated'),
768(815, 'backend', 'Text Blocks'),
769(816, 'backend', 'Text Widgets'),
770(817, 'backend', 'This Unit Price Type has already been taken'),
771(818, 'backend', 'This Capacity Type has already been taken'),
772(819, 'backend', 'Time'),
773(820, 'backend', 'Timeline'),
774(821, 'backend', 'Timezone'),
775(822, 'backend', 'Toggle navigation'),
776(823, 'backend', 'Total Swap'),
777(824, 'backend', 'Total memory'),
778(825, 'backend', 'Translation'),
779(826, 'backend', 'Update'),
780(827, 'backend', 'Update {modelClass}: '),
781(828, 'backend', 'Uptime'),
782(829, 'backend', 'Used size'),
783(830, 'backend', 'User Registrations'),
784(831, 'backend', 'Username'),
785(832, 'backend', 'Users'),
786(833, 'backend', 'View all'),
787(834, 'backend', 'Web Server'),
788(835, 'backend', 'Widget Carousel Items'),
789(836, 'backend', 'Widget Carousels'),
790(837, 'backend', 'Widget Menus'),
791(838, 'backend', 'You have {num} log items'),
792(839, 'backend', 'Your account has been successfully saved'),
793(840, 'backend', 'Your profile has been successfully saved'),
794(841, 'backend', 'i18n'),
795(842, 'backend', 'i18n Message'),
796(843, 'backend', 'i18n Source Message'),
797(844, 'common', '"{attribute}" must be a valid JSON'),
798(845, 'common', 'Article View'),
799(846, 'common', 'Active'),
800(847, 'common', 'Article ID'),
801(848, 'common', 'Author'),
802(849, 'common', 'Base URL'),
803(850, 'common', 'Base Url'),
804(851, 'common', 'Body'),
805(852, 'common', 'Caption'),
806(853, 'common', 'Carousel ID'),
807(854, 'common', 'Category'),
808(855, 'common', 'Comment'),
809(856, 'common', 'Component'),
810(857, 'common', 'Config'),
811(858, 'common', 'Created At'),
812(859, 'common', 'Created at'),
813(860, 'common', 'Deleted'),
814(861, 'common', 'Down to maintenance.'),
815(862, 'common', 'E-mail'),
816(863, 'common', 'File Type'),
817(864, 'common', 'Firstname'),
818(865, 'common', 'Gender'),
819(866, 'common', 'ID'),
820(867, 'common', 'Image'),
821(868, 'common', 'Key'),
822(869, 'common', 'Last login'),
823(870, 'common', 'Lastname'),
824(871, 'common', 'Locale'),
825(872, 'common', 'Middlename'),
826(873, 'common', 'Name'),
827(874, 'common', 'Order'),
828(875, 'common', 'Page View'),
829(876, 'common', 'Parent Category'),
830(877, 'common', 'Path'),
831(878, 'common', 'Page not found.'),
832(879, 'common', 'Person'),
833(880, 'common', 'Picture'),
834(881, 'common', 'Published'),
835(882, 'common', 'Published At'),
836(883, 'common', 'Seat'),
837(884, 'common', 'Size'),
838(885, 'common', 'Slug'),
839(886, 'common', 'Status'),
840(887, 'common', 'Save'),
841(888, 'common', 'Thumbnail'),
842(889, 'common', 'Title'),
843(890, 'common', 'Type'),
844(891, 'common', 'Updated At'),
845(892, 'common', 'Updated at'),
846(893, 'common', 'Updater'),
847(894, 'common', 'Update'),
848(895, 'common', 'Upload Ip'),
849(896, 'common', 'Url'),
850(897, 'common', 'User ID'),
851(898, 'common', 'Username'),
852(899, 'common', 'Value'),
853(900, 'common', 'You are not allowed to access this page'),
854(901, 'frontend', '1. Vehicle Provider'),
855(902, 'frontend', '2. Vehicle Customer'),
856(903, 'frontend', 'About Us'),
857(904, 'frontend', 'About'),
858(905, 'frontend', 'Account Settings'),
859(906, 'frontend', 'All'),
860(907, 'frontend', 'Articles'),
861(908, 'frontend', 'Attachments'),
862(909, 'frontend', 'Available Vehicle'),
863(910, 'frontend', 'Back Office'),
864(911, 'frontend', 'Body'),
865(912, 'frontend', 'Book'),
866(913, 'frontend', 'Book Now'),
867(914, 'frontend', 'Booking'),
868(915, 'frontend', 'Book Vehicle'),
869(916, 'frontend', 'Back'),
870(917, 'frontend', 'Broadcast Opportunity'),
871(918, 'frontend', 'Check your email for further instructions.'),
872(919, 'frontend', 'Confirm Password'),
873(920, 'frontend', 'Career'),
874(921, 'frontend', 'Contact Us'),
875(922, 'frontend', 'Contact'),
876(923, 'frontend', 'Confirmed'),
877(924, 'frontend', 'Connect'),
878(925, 'frontend', 'Choose'),
879(926, 'frontend', 'Choose Area'),
880(927, 'frontend', 'Customer'),
881(928, 'frontend', 'Capacity'),
882(929, 'frontend', 'Company'),
883(930, 'frontend', 'Color'),
884(931, 'frontend', 'Call Owner'),
885(932, 'frontend', 'Create Opportunity'),
886(933, 'frontend', 'Update Opportunity'),
887(934, 'frontend', 'Cancel'),
888(935, 'frontend', 'E-mail'),
889(936, 'frontend', 'Email'),
890(937, 'frontend', 'Edit Account'),
891(938, 'frontend', 'Edit My Account'),
892(939, 'frontend', 'Edit Profile'),
893(940, 'frontend', 'Edit My Profile'),
894(941, 'frontend', 'End Date'),
895(942, 'frontend', 'Enter your email address for news, sales and giveaways!'),
896(943, 'frontend', 'Enter your email'),
897(944, 'frontend', 'Error while oauth process.'),
898(945, 'frontend', 'Find it'),
899(946, 'frontend', 'Female'),
900(947, 'frontend', 'Get more opportunity with our thousand customers, You can list all your vehicles and manage transaction by yourself. VEBOO will send you book notification in your smart-phone'),
901(948, 'frontend', 'Go to my profile'),
902(949, 'frontend', 'Home'),
903(950, 'frontend', 'If you forgot your password you can reset it <a href="{link}">here</a>'),
904(951, 'frontend', 'Incorrect username or password.'),
905(952, 'frontend', 'Invalid key or your account has been activated'),
906(953, 'frontend', 'Inbox'),
907(954, 'frontend', 'Language'),
908(955, 'frontend', 'Log in with'),
909(956, 'frontend', 'Login'),
910(957, 'frontend', 'Logout'),
911(958, 'frontend', 'Male'),
912(959, 'frontend', 'My Book'),
913(960, 'frontend', 'Newsletters'),
914(961, 'frontend', 'Name'),
915(962, 'frontend', 'Need an account? Sign up.'),
916(963, 'frontend', 'Not Descripted'),
917(964, 'frontend', 'New password was saved.'),
918(965, 'frontend', 'Our platform will help you to generate new lead, when your vehicle is available to book. Our customers will choose your vehicle to pick up / rent or make the deal with customers'),
919(966, 'frontend', 'Offering Service'),
920(967, 'frontend', 'Offering Services'),
921(968, 'frontend', 'Offering List'),
922(969, 'frontend', 'Offering Book'),
923(970, 'frontend', 'Only Customer member can use feature booking'),
924(971, 'frontend', 'Page not found.'),
925(972, 'frontend', 'Password'),
926(973, 'frontend', 'Password reset for {name}'),
927(974, 'frontend', 'Profile settings'),
928(975, 'frontend', 'Please take a few moments to update your profile with a picture and a few details about yourself. Vehicle owners are more likely to respond more quickly to customer with profiles.'),
929(976, 'frontend', 'Please take a few moments to update your profile with a picture and a few details about yourself. Customers are more likely to respond more quickly to vehicle owner with profiles.'),
930(977, 'frontend', 'Please contact us '),
931(978, 'frontend', 'Please Complete Booking Search'),
932(979, 'frontend', 'Please login to edit your profile'),
933(980, 'frontend', 'Remember Me'),
934(981, 'frontend', 'Request password reset'),
935(982, 'frontend', 'Reset password'),
936(983, 'frontend', 'Register'),
937(984, 'frontend', 'Sign up with'),
938(985, 'frontend', 'Start Date'),
939(986, 'frontend', 'Solution'),
940(987, 'frontend', 'Signup'),
941(988, 'frontend', 'Sign Up'),
942(989, 'frontend', 'Sorry, we are unable to reset password for email provided.'),
943(990, 'frontend', 'Subject'),
944(991, 'frontend', 'Subscribe'),
945(992, 'frontend', 'Search'),
946(993, 'frontend', 'Settings'),
947(994, 'frontend', 'Submit'),
948(995, 'frontend', 'Share'),
949(996, 'frontend', 'Showing Result'),
950(997, 'frontend', 'Thank you for your interesting with VEBOO, wee here to serve you'),
951(998, 'frontend', 'Thank you for contacting us. We will respond to you as soon as possible.'),
952(999, 'frontend', 'There was an error sending email.'),
953(1000, 'frontend', 'This email address has already been taken.'),
954(1001, 'frontend', 'This username has already been taken.'),
955(1002, 'frontend', 'Transmission'),
956(1003, 'frontend', 'Track your vehicle when ever its go. This solution lets vehicle owner to track objects in real time, view historical tracks and be notified events that requires your attention and reports'),
957(1004, 'frontend', 'Track'),
958(1005, 'frontend', 'Update'),
959(1006, 'frontend', 'Username'),
960(1007, 'frontend', 'Username or email'),
961(1008, 'frontend', 'User Settings'),
962(1009, 'frontend', 'Verification Code'),
963(1010, 'frontend', 'View'),
964(1011, 'frontend', 'View Detail'),
965(1012, 'frontend', 'Vehicle'),
966(1013, 'frontend', 'Register as'),
967(1014, 'frontend', 'You have to login for booking vehicle.'),
968(1015, 'frontend', 'You registred as vehicle owner'),
969(1016, 'frontend', 'You registred as customer'),
970(1017, 'frontend', 'We already have a user with email {email}'),
971(1018, 'frontend', 'Welcome to {app-name}. Email with your login information was sent to your email.'),
972(1019, 'frontend', 'Welcome'),
973(1020, 'frontend', 'Why Choose Us'),
974(1021, 'frontend', 'Your profile has been successfully saved'),
975(1022, 'frontend', 'Your profile failed to save'),
976(1023, 'frontend', 'Your account has been successfully saved'),
977(1024, 'frontend', 'Your registration member completed'),
978(1025, 'frontend', 'Your registration member failed'),
979(1026, 'frontend', 'Your account already active'),
980(1027, 'frontend', '{app-name} | Your login information'),
981(1028, 'frontend', 'The Problem'),
982(1029, 'frontend', 'The most vehicle provider problem, they have huge investment on asset for doing the business and mostly the asset utilization not achieve the target, too many asset un-utilized, because they only support for small customers. It does become an expense and difficult to growth the business. They need more customers and continuous order from customers.'),
983(1030, 'frontend', 'Veboo is market place for customers and providers. They could collaborate to improve their service together, when customers need vehicles, with easy step customers can search available vehicle with certain term and condition then they could book it. New evolution in supply chain and logistics commerce to make good service and competitive price.'),
984(1031, 'frontend', 'When customers need vehicle with competitive price they can broadcast their demand on this platform, specifically this system will send information to provider regarding of customer demand then vehicle provider offer their services.'),
985(1032, 'frontend', 'Vehicle provider needs a support system for archiving transaction: booking, order, invoicing, operational cost, maintenance. Mostly the company operate vehicles they did not has a good system, manually keep transaction in excel.'),
986(1033, 'frontend', 'We Are Ready to Help You'),
987(1034, 'frontend', 'Get The Best Solution for Your Business'),
988(1035, 'frontend', 'Call us');
989
990-- --------------------------------------------------------
991
992--
993-- Table structure for table `invoice`
994--
995
996CREATE TABLE IF NOT EXISTS `invoice` (
997 `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
998 `invoice_code` varchar(30) NOT NULL,
999 `user_id` int(11) NOT NULL,
1000 `order_id` int(11) DEFAULT NULL,
1001 `driver_id` int(11) DEFAULT NULL,
1002 `customer_id` int(11) DEFAULT NULL,
1003 `invoice_date` timestamp NULL DEFAULT NULL,
1004 `invoice_number` varchar(20) DEFAULT NULL,
1005 `currency` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1006 `order_date` timestamp NULL DEFAULT NULL,
1007 `days` int(11) DEFAULT NULL,
1008 `quantity` smallint(6) NOT NULL,
1009 `start_from` tinyint(4) DEFAULT NULL,
1010 `destination_to` tinyint(4) DEFAULT NULL,
1011 `price` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1012 `unit_price` tinyint(4) DEFAULT NULL,
1013 `additional_price_1` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1014 `additional_price_2` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1015 `additional_price_3` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1016 `discount` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1017 `voucher` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1018 `order_quantity` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1019 `order_amount` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1020 `description` text CHARACTER SET latin1,
1021 `payment_term` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1022 `payment_method` tinyint(4) NOT NULL,
1023 `due_date` timestamp NULL DEFAULT NULL,
1024 `invoice_amount` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1025 `invoice_status` tinyint(4) DEFAULT NULL,
1026 `attributes_1` int(30) DEFAULT NULL,
1027 `attributes_2` int(30) DEFAULT NULL,
1028 `attributes_3` int(30) DEFAULT NULL,
1029 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1030 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1031 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1032 PRIMARY KEY (`invoice_id`),
1033 KEY `FK_FK_O_I` (`order_id`),
1034 KEY `FK_invoice_master_customer` (`customer_id`),
1035 KEY `FK_invoice_user` (`user_id`)
1036) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1037
1038-- --------------------------------------------------------
1039
1040--
1041-- Table structure for table `key_storage_item`
1042--
1043
1044CREATE TABLE IF NOT EXISTS `key_storage_item` (
1045 `key` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1046 `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1047 `comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1048 `updated_at` int(11) DEFAULT NULL,
1049 `created_at` int(11) DEFAULT NULL,
1050 PRIMARY KEY (`key`),
1051 UNIQUE KEY `idx_key_storage_item_key` (`key`)
1052) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1053
1054--
1055-- Dumping data for table `key_storage_item`
1056--
1057
1058INSERT INTO `key_storage_item` (`key`, `value`, `comment`, `updated_at`, `created_at`) VALUES
1059('backend.layout-boxed', '0', NULL, 1454320559, NULL),
1060('backend.layout-collapsed-sidebar', '0', NULL, 1454320559, NULL),
1061('backend.layout-fixed', '0', NULL, 1454320559, NULL),
1062('backend.theme-skin', 'skin-black', 'skin-blue, skin-black, skin-purple, skin-green, skin-red, skin-yellow', 1454320559, NULL),
1063('frontend.maintenance', 'disabled', 'Set it to "true" to turn on maintenance mode', 1454320559, NULL);
1064
1065-- --------------------------------------------------------
1066
1067--
1068-- Table structure for table `maintenance_item`
1069--
1070
1071CREATE TABLE IF NOT EXISTS `maintenance_item` (
1072 `maintenance_item_id` int(11) NOT NULL AUTO_INCREMENT,
1073 `item` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1074 `description` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
1075 `attributes_1` int(30) DEFAULT NULL,
1076 `attributes_2` int(30) DEFAULT NULL,
1077 `attributes_3` int(30) DEFAULT NULL,
1078 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1079 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1080 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1081 PRIMARY KEY (`maintenance_item_id`)
1082) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1083
1084-- --------------------------------------------------------
1085
1086--
1087-- Table structure for table `maintenance_trx`
1088--
1089
1090CREATE TABLE IF NOT EXISTS `maintenance_trx` (
1091 `maintenance_trx_id` int(11) NOT NULL AUTO_INCREMENT,
1092 `vehicle_id` int(11) DEFAULT NULL,
1093 `maintenance_item_id` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
1094 `maintenance_date` date DEFAULT NULL,
1095 `unit_price` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1096 `quantity` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
1097 `amount` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1098 `remark` text CHARACTER SET latin1,
1099 `attributes_1` int(30) DEFAULT NULL,
1100 `attributes_2` int(30) DEFAULT NULL,
1101 `attributes_3` int(30) DEFAULT NULL,
1102 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1103 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1104 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1105 PRIMARY KEY (`maintenance_trx_id`),
1106 KEY `FK_FK_MV_MT` (`vehicle_id`),
1107 KEY `FK_FK_MI_MT` (`maintenance_item_id`)
1108) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1109
1110-- --------------------------------------------------------
1111
1112--
1113-- Table structure for table `master_customer`
1114--
1115
1116CREATE TABLE IF NOT EXISTS `master_customer` (
1117 `id` int(11) NOT NULL AUTO_INCREMENT,
1118 `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1119 `auth_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1120 `password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1121 `password_reset_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1122 `oauth_client` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1123 `oauth_client_user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1124 `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1125 `status` smallint(6) DEFAULT '0',
1126 `role` tinyint(1) NOT NULL DEFAULT '2',
1127 `created_at` int(11) NOT NULL,
1128 `updated_at` int(11) NOT NULL,
1129 `logged_at` int(11) DEFAULT NULL,
1130 PRIMARY KEY (`id`)
1131) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000034 ;
1132
1133--
1134-- Dumping data for table `master_customer`
1135--
1136
1137INSERT INTO `master_customer` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `oauth_client`, `oauth_client_user_id`, `email`, `status`, `role`, `created_at`, `updated_at`, `logged_at`) VALUES
1138(96, 'fahrul', 'rOBhuYHx-Bh_eKB94ZRXk--ouQPnfgYy', '$2y$13$71Lh0devr8wpTscy7WM3z.NVGgvas10bUlBSD.ryeVZMlqP1iC37i', NULL, NULL, NULL, 'fahrul@logikapratama.com', 1, 2, 1451714135, 1456369236, 1456369236),
1139(1000002, 'Ari Sandi Robert', 'VXO-0894A9LwPnGvfR9j2dywvLQjMXsV', '$2y$13$mBHIYUuiHfTM.ZGQm.3H.uKSFnrL7AHBQT6DESXHaRJX8u76Omy/W', NULL, NULL, NULL, 'arisandirobert@gmail.com', 1, 2, 1451489475, 1452056138, 1452056138),
1140(1000004, 'haruncustomer', 'ez8X_2c53RZQu9NM0_jDuFfhrEkLU48c', '$2y$13$gKxP61FQFyIonWMWZipZl.s7oBM0C5ti4Svc0yFcfT17wVyMJOeom', NULL, NULL, NULL, 'mhtofik@logikapratama.com', 1, 2, 1451656728, 1455246249, 1455246249),
1141(1000006, NULL, 'mIbl0tx3cNPeAHNmOJnO-b2M-_7KWF1r', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444020702, 1444020702, NULL),
1142(1000007, NULL, 'Dwt9iev0wyps7to9qwbYEd1EQKAhOwLs', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027282, 1444027282, NULL),
1143(1000008, NULL, '3-RyqFZisSK9VOHCseeqanVY0sIrapV0', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027624, 1444027624, NULL),
1144(1000009, NULL, 'F2qL1H1y77szVoHTubJEa93NUedXP_Ts', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027693, 1444027693, NULL),
1145(1000010, NULL, 'dr6vjd30e6_II4pUHkvzUyAsgJckIw_S', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027736, 1444027736, NULL),
1146(1000011, NULL, 'lnG7ih8mY2GJOgeEmn6JFzWAVACZrTJ0', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027786, 1444027786, NULL),
1147(1000012, NULL, 'iyteGglDNYx70iZGePfrpI9mud5Dt9BJ', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027841, 1444027841, NULL),
1148(1000013, NULL, 'r-H5jXPvxLPmQDrlDs2a5MLzCO4hAYiF', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444027914, 1444027914, NULL),
1149(1000014, NULL, 'nW5lKSGuWqsE3j2r7mbUsrR5cakxoNxH', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444028025, 1444028025, NULL),
1150(1000015, NULL, 'EcP3DY2_3fzCSOIVXuYAC4Bo_bpOwjvv', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444040645, 1444040645, NULL),
1151(1000016, NULL, 'RCBBMCEuGBivfmYJqNnk8TFPf1p_IgCa', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444067885, 1444067885, NULL),
1152(1000017, 'rusman', 'c7ABzhZ-gNYR4WHyTXdcDxDO2JbUnWh4', '$2y$13$pWSIFxIjRxf4dHtr3sm//OE0TzaGpUdhnF7yjs7G3Ux3rqhQHtljy', NULL, NULL, NULL, 'arusman75@yahoo.com', 0, 2, 1444093641, 1444093641, NULL),
1153(1000018, 'hexenjagd', '40OKRIiD-F-PNaouroZLX_lrDDvwitrM', '$2y$13$o9O.6H1vYh/JEgKhMcvISunlu9BgpA7XKgHdCgMKJAL9nYG/GSlDC', NULL, NULL, NULL, 'striker_system@hotmail.com', 0, 2, 1444096282, 1444096282, NULL),
1154(1000019, 'Mario', 'gYUCQEX-AeBdppTCPl5CaVir4PHgctCQ', '$2y$13$3KMRZMHIE6QKZ7XsvTi8iepJy40sM7eFgXDUfftcYi3FKaQ1iZvmu', NULL, NULL, NULL, 'Seaport.jkt@Gmail.com', 0, 2, 1444097408, 1444097408, NULL),
1155(1000020, NULL, '1iUDGne6GOOKmj4kBbzbse-_0ALEuDsc', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444107029, 1444107029, NULL),
1156(1000021, NULL, '8FHcJRI0BHfhX5q87U_pYdvqLArNVSXm', NULL, NULL, NULL, NULL, NULL, 1, 2, 1444107186, 1444107186, NULL),
1157(1000022, 'logikatest', 'xy2quYYEmqJJmg_6hZRYJ54UydMd_RKg', '$2y$13$E/U9QY2lQPjnfidenAp74ulJoTlJrpQEjRciWv715pdKxQxR8Vk3q', NULL, NULL, NULL, 'cs@logikapratama.com', 1, 2, 1444632667, 1444632846, 1444632846),
1158(1000023, 'saleslogika', 'P6XjVo6jutaes6_hVza0tnumaR65iiHD', '$2y$13$UY.kwRii9oq9AMa/1iqDg.xgtEypaDAQTg3HYaZ2GIguGt7t.yQ.i', NULL, NULL, NULL, 'sales@logikapratama.com', 1, 2, 1444632924, 1444633524, 1444633524),
1159(1000024, 'mamaku', 'bEbkTzzt8Q_a_A_CUOaqlIDYtkb8keWm', '$2y$13$gyr6Ej9xVmc/w13CXBc.o.kPCr.kvPXDURmYLBYunGN/i83XoPcYW', NULL, NULL, NULL, 'anggriawan@lum3u.com', 1, 2, 1445152797, 1450941549, 1450941549),
1160(1000025, 'anggrikhan', '0j3mT3HdXTrtNU_8kb_QmxxT0gWeQj2p', '$2y$13$MKQKwMtmuFq6cxYTGWEMvuZrj85R2.WqWhctZ7QNSmuGggxlCze5.', NULL, NULL, NULL, 'anggriawan@yahoo.com', 0, 2, 1445152852, 1445152852, NULL),
1161(1000026, 'Achmad Yazid', 'j_J7NBv5zQKTBIOcnpwL9aPXthyfLgCs', '$2y$13$6cQm7FRiPMyrv0GWXu2xsOFAv71dhej5kDCPILgzcz8O1TYxrHU8C', NULL, NULL, NULL, 'parawirahandal.tangguh2022@gmail.com', 1, 2, 1445929419, 1445929704, 1445929704),
1162(1000027, 'prouslof@dodsi.com', 'fYjGfZhkcVQGzoNEmmx3w4Xo3fPOewE5', '$2y$13$s7cx4pPzDixGe64DF6KcQuaxhJrhOtEOeD8GXOVuUIU5s/lKjFQV.', NULL, NULL, NULL, 'prouslof@dodsi.com', 0, 2, 1449722921, 1449722921, NULL),
1163(1000028, 'clepriav@dodsi.com', 'sbpgpwPY5fHENrwUStA8tHEgufC4MJy2', '$2y$13$GTHe994WzCsfX8uzJyTLYOMUV21W24msUQk7AA7ccgKoDMk56W4VK', NULL, NULL, NULL, 'clepriav@dodsi.com', 0, 2, 1449722961, 1449722961, NULL),
1164(1000029, '', 'anGBLAvlET7URBD-B65kiCvxzhal90SS', NULL, NULL, NULL, NULL, '', 1, 2, 1453437689, 1453437689, NULL),
1165(1000030, '', 'Ra4neIoOwjt35h8cH6-QGTNeJVonbAjm', NULL, NULL, NULL, NULL, '', 1, 2, 1453437709, 1453437709, NULL),
1166(1000031, '', 'qiFcm6jzaUlzkB4oEMZgsaIMpj10uu8z', NULL, NULL, NULL, NULL, '', 1, 2, 1453437736, 1453437736, NULL),
1167(1000032, '', 'oDNmXBSGll7P7ahot1dCPqUbfs04t61P', NULL, NULL, NULL, NULL, '', 1, 2, 1453437742, 1453437742, NULL),
1168(1000033, '', 'iU5E3w-M_JLCkuDxadOimQEsuxl-_RNF', NULL, NULL, NULL, NULL, '', 1, 2, 1454398330, 1454398330, NULL);
1169
1170--
1171-- Triggers `master_customer`
1172--
1173DROP TRIGGER IF EXISTS `delete_customer`;
1174DELIMITER //
1175CREATE TRIGGER `delete_customer` AFTER DELETE ON `master_customer`
1176 FOR EACH ROW #begin
1177#delete from calibration where torque_id=OLD.id_torque;
1178#end
1179Begin
1180
1181 DELETE FROM master_customer_profile where customer_id=OLD.id;
1182
1183END
1184//
1185DELIMITER ;
1186
1187-- --------------------------------------------------------
1188
1189--
1190-- Table structure for table `master_customer_profile`
1191--
1192
1193CREATE TABLE IF NOT EXISTS `master_customer_profile` (
1194 `customer_id` int(11) NOT NULL AUTO_INCREMENT,
1195 `user_id` int(11) NOT NULL DEFAULT '0',
1196 `firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1197 `middlename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1198 `lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1199 `phone_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1200 `other_phone_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1201 `ktp_number` bigint(20) DEFAULT NULL,
1202 `birth_place` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1203 `birth_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1204 `gender` smallint(1) DEFAULT NULL,
1205 `address` varchar(114) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1206 `postal_code` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1207 `religion` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1208 `country` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1209 `customer_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1210 `locale` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1211 `avatar_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1212 `avatar_base_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1213 `attributes_1` int(30) DEFAULT NULL,
1214 `attributes_2` int(30) DEFAULT NULL,
1215 `attributes_3` int(30) DEFAULT NULL,
1216 `attributes_4` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1217 `attributes_5` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1218 `attributes_6` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1219 PRIMARY KEY (`customer_id`),
1220 KEY `FK_master_customer_profile_user` (`user_id`)
1221) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000031 ;
1222
1223--
1224-- Dumping data for table `master_customer_profile`
1225--
1226
1227INSERT INTO `master_customer_profile` (`customer_id`, `user_id`, `firstname`, `middlename`, `lastname`, `phone_number`, `other_phone_number`, `ktp_number`, `birth_place`, `birth_date`, `gender`, `address`, `postal_code`, `religion`, `country`, `customer_status`, `locale`, `avatar_path`, `avatar_base_url`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
1228(96, 0, 'Fahrul', '0', 'Syah', '0857', '', NULL, '', '2016-02-11', 1, 'Bogor', '', '', '101', NULL, 'id', 'favicon2.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1229(1000001, 2, 'Bpk. Salman', '0', 'Paris', '+628118787901', '+628111751214', NULL, '', NULL, 2, 'Jakarta, Indonesia', '13530', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1230(1000002, 0, 'Ari Sandi', '0', 'Robert', '085749990600', NULL, NULL, NULL, NULL, 1, 'Tangerang Selatan', NULL, NULL, 'ID', NULL, 'id', '1/lSYwqKoTxwhQyAQyo1cQISkG4YZ3fCOJ.jpg', 'http://veboo.co.id/storage/web/source', NULL, NULL, NULL, NULL, NULL, NULL),
1231(1000004, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1232(1000006, 3, 'amar', '1', 'suganda', '0877657489376', '', NULL, 'bandung', NULL, 2, 'jl.bunga', '', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1233(1000007, 2, 'PT Hero ', '1', 'Indonesia', '+622152007890', '+622152007890', NULL, '', '', 2, 'Jakarta, Indonesia', '13530', '', 'ID', 'Married', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1234(1000008, 2, 'PT Indomaret', '1', 'Indonesia', '+622151000019', '', NULL, '', '', 2, 'Jakarta, Indonesia', '', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1235(1000009, 2, 'Bpk. Wiguna', '0', 'Rahmadi', '+628111751214', '+628111751214', NULL, '', NULL, 2, 'Jakarta, Indonesia', '13530', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1236(1000010, 2, 'PT Kamadjaya', '1', 'Logistic', '+628111752321', '+628111751214', NULL, '', NULL, 2, 'Jakarta, Indonesia', '13530', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1237(1000012, 2, 'IMS', '1', 'Logistic', '+628112801881', '+628112801881', NULL, '', NULL, 2, 'Jakarta, Indonesia', '', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1238(1000013, 2, 'PT Mart', '1', 'Indonesia', '+622151009001', '622151009001', NULL, '', NULL, 2, 'Jakarta, Indonesia', '', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1239(1000014, 2, 'PT Bestari', '1', 'Logistic', '+622152012005', '+622152012005', NULL, '', NULL, 2, 'TB Simatupang No. 19', '', '', 'ID', '', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1240(1000015, 6, 'Ridwan', '1', 'Adesta (HERO)', '0218887945', '', NULL, '', NULL, 2, 'Jl raya cibitung', '', '', 'ID', 'Married', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1241(1000016, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1242(1000017, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1243(1000018, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1244(1000019, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1245(1000020, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1246(1000021, 36, 'Joko', '0', 'Tingkir', '09', '09', 9, 'Jakarta', '2015-12-03', 2, 'asd', '1', 'q', 'ID', 'Single', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1247(1000022, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1248(1000023, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1249(1000024, 0, 'Indomaret', '1', 'Jakarta', '021-25100909', NULL, NULL, NULL, NULL, 1, 'Jakarta', NULL, NULL, 'ID', NULL, 'en-US', '1/EtqpRTAd4JbRr2lKu4AAecGh5V2hjcyI.jpg', 'http://veboo.co.id/storage/web/source', NULL, NULL, NULL, NULL, NULL, NULL),
1250(1000025, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1251(1000026, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1252(1000027, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1253(1000028, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1254(1000029, 92, 'Fadli', '0', 'rachman', '222', '000', 0, 'jakarta', '2016-01-22', 2, 'sad', '16340', '1', 'AL', 'Single', 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1255(1000030, 92, 'tiara', '1', 'puspitasari', '', 'adasd', 22, 'asd', '2016-02-17', 2, 'semampu saya', '22', '1', 'AF', 'Single', 'id', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1256
1257-- --------------------------------------------------------
1258
1259--
1260-- Table structure for table `master_vehicle`
1261--
1262
1263CREATE TABLE IF NOT EXISTS `master_vehicle` (
1264 `vehicle_id` int(11) NOT NULL AUTO_INCREMENT,
1265 `user_id` int(11) DEFAULT NULL,
1266 `vehicle_type` varchar(30) CHARACTER SET latin1 NOT NULL,
1267 `brand` varchar(11) CHARACTER SET latin1 NOT NULL,
1268 `transmission` varchar(30) CHARACTER SET latin1 NOT NULL,
1269 `capacity` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
1270 `plat_number` varchar(11) CHARACTER SET latin1 NOT NULL,
1271 `color` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
1272 `years` year(4) DEFAULT NULL,
1273 `tracking` varchar(114) CHARACTER SET latin1 NOT NULL,
1274 `description` varchar(700) CHARACTER SET latin1 DEFAULT NULL,
1275 `status` tinyint(4) NOT NULL DEFAULT '0',
1276 `share_status` tinyint(1) NOT NULL,
1277 `avatar_path` varchar(50) DEFAULT NULL,
1278 `avatar_base_url` varchar(50) DEFAULT NULL,
1279 `image1` tinytext,
1280 `image2` tinytext,
1281 `image3` tinytext,
1282 `image4` tinytext,
1283 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1284 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
1285 `attributes_1` int(30) DEFAULT NULL,
1286 `attributes_2` int(30) DEFAULT NULL,
1287 `attributes_3` int(30) DEFAULT NULL,
1288 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1289 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1290 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1291 PRIMARY KEY (`vehicle_id`),
1292 KEY `FK_FK_U_MV` (`user_id`)
1293) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
1294
1295--
1296-- Dumping data for table `master_vehicle`
1297--
1298
1299INSERT INTO `master_vehicle` (`vehicle_id`, `user_id`, `vehicle_type`, `brand`, `transmission`, `capacity`, `plat_number`, `color`, `years`, `tracking`, `description`, `status`, `share_status`, `avatar_path`, `avatar_base_url`, `image1`, `image2`, `image3`, `image4`, `created_at`, `updated_at`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
1300(1, 91, 'Dump Truck', 'UD', 'AT', '> 25 Ton', 'B 9095 VOL', 'Kuning', 2013, 'Yes', 'Kendaraan dengan mesin bertenaga 3000 cc, akselerasi 40 km/pjam dalam waktu 5 detik.', 0, 1, NULL, NULL, 'yellowtruck.png', NULL, NULL, NULL, '2016-01-25 16:26:16', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1301(2, 91, 'Wing Box', 'Hino', 'AT', '> 25 Ton', 'B 2921 TAK', 'Merah', 2011, 'Yes', 'Kendaraan dengan mesin bertenaga 3000 cc, akselerasi 40 km/pjam dalam waktu 5 detik.', 0, 1, NULL, NULL, 'wing box truck.jpg', NULL, NULL, NULL, '2016-01-25 16:28:05', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1302(3, 91, 'CDD', 'Mitsubishi', 'MT', '15 Ton', 'B 3421 GK', 'Kuning', 2011, 'Yes', 'CDD 15 Ton', 0, 1, NULL, NULL, 'CDD Mitshubisi.jpg', NULL, NULL, NULL, '2016-01-25 16:29:27', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1303(4, 91, 'CDE', 'Daihatsu', 'MT', '15 Ton', 'B 2921 TAY', 'Putih', 2013, 'Yes', 'CDE Mitsubishi 15 Tom', 0, 1, NULL, NULL, 'CDE isuzu.jpg', NULL, NULL, NULL, '2016-01-25 16:30:47', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1304(5, 91, 'Passenger Car', 'Toyota', 'AT', '5 Seat', 'B 9011 FRE', 'Silver5', 2014, 'Yes', 'Totoya Azanza', 0, 1, NULL, NULL, 'Toyota Avanza.png', NULL, NULL, NULL, '2016-01-25 16:32:20', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1305(6, 91, 'Blind Van', 'Mitsubishi', 'MT', '14 CBM', 'B 4510 CE', 'Putih', 2014, 'Yes', 'BlinVan 2014', 0, 1, NULL, NULL, 'Mitsubisi BlindVan2.jpg', NULL, NULL, NULL, '2016-01-25 16:34:44', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1306(7, 91, 'Motor Bike', 'Harlay', 'MT', '2 Seat', 'B 1010 GK', 'Hitam', 2016, 'Yes', 'Harlay 2016', 0, 1, NULL, NULL, 'harley.jpg', NULL, NULL, NULL, '2016-01-25 16:36:40', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1307(8, 92, 'Motor Bike', 'Honda', 'AT', '2 Seat', 'B 1437 KFS', 'Black', 2013, 'Yes', 'Kendaraan dengan mesin bertenaga 3000 cc, akselerasi 40 km/pjam dalam waktu 5 detik. Kendaraan yang sangat menakjubkan', 0, 1, NULL, NULL, '4.jpg', NULL, NULL, NULL, '2016-01-30 12:42:36', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1308(9, 92, 'CDE', 'Mitsubishi', 'MT', '7 Ton', '12', 'black', 2016, 'Yes', 'Kapasitas tanki 5000 L, per Liiter dapat menempuh jarak 50 km. kapasitas mesin 2500 CC, memiliki 4 kursi poenumpang', 0, 1, NULL, NULL, 'Home.PNG', NULL, NULL, NULL, '2016-02-02 07:32:55', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1309(10, 96, 'Dump Truck', 'etc', 'AT', '7 Ton', 'B 1334 RFS', 'Black', 2013, 'Yes', 'Kendaraan dengan mesin bertenaga 3000 cc, akselerasi 40 km/pjam dalam waktu 5 detik.', 0, 1, NULL, NULL, '2016_ford_escape_angularfront.jpg', '2015_Ford_Escape_10.jpg', '2015-ford-escape-trunk_9862_049_640x480.jpg', NULL, '2016-02-04 05:15:09', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1310(15, 96, 'CDE', 'Isuzu', 'AT', '20 Ton', 'fahrul FF', 'a', 2016, 'Yes', 'adas', 0, 1, NULL, NULL, '2015-ford-escape-trunk_9862_049_640x480.jpg', NULL, NULL, NULL, '2016-02-10 09:03:44', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL),
1311(16, 96, 'Motor Bike', 'Mitsubishi', 'MT', '1 Seat', 'adasdadasd', 'a', 2016, 'Yes', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2016-02-10 17:24:07', '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL);
1312
1313-- --------------------------------------------------------
1314
1315--
1316-- Table structure for table `menu`
1317--
1318
1319CREATE TABLE IF NOT EXISTS `menu` (
1320 `id` int(11) NOT NULL DEFAULT '0',
1321 `name` varchar(128) NOT NULL,
1322 `parent` int(11) DEFAULT NULL,
1323 `route` varchar(256) NOT NULL,
1324 `order` int(11) NOT NULL,
1325 `data` text NOT NULL,
1326 PRIMARY KEY (`id`),
1327 KEY `parent` (`parent`)
1328) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1329
1330-- --------------------------------------------------------
1331
1332--
1333-- Table structure for table `migration`
1334--
1335
1336CREATE TABLE IF NOT EXISTS `migration` (
1337 `version` varchar(180) CHARACTER SET latin1 NOT NULL,
1338 `apply_time` int(11) DEFAULT NULL,
1339 PRIMARY KEY (`version`)
1340) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1341
1342-- --------------------------------------------------------
1343
1344--
1345-- Table structure for table `notification`
1346--
1347
1348CREATE TABLE IF NOT EXISTS `notification` (
1349 `id` int(11) NOT NULL AUTO_INCREMENT,
1350 `event` char(50) NOT NULL,
1351 `customer_id` int(11) NOT NULL,
1352 `user_id` int(11) NOT NULL,
1353 `description` char(100) NOT NULL,
1354 `ref_id` int(11) NOT NULL,
1355 `status` tinyint(4) NOT NULL,
1356 `created_at` datetime NOT NULL,
1357 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1358 PRIMARY KEY (`id`),
1359 KEY `FK_notification_user` (`user_id`)
1360) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=261 ;
1361
1362--
1363-- Dumping data for table `notification`
1364--
1365
1366INSERT INTO `notification` (`id`, `event`, `customer_id`, `user_id`, `description`, `ref_id`, `status`, `created_at`, `updated_at`) VALUES
1367(250, 'New Book "BV00000001"', 96, 96, '-', 150, 1, '2016-02-23 23:02:44', '2016-02-24 19:19:13'),
1368(251, 'New Book "BV00000002"', 96, 96, '-', 151, 0, '2016-02-23 23:02:18', NULL),
1369(252, 'New Opportunity', 96, 91, 'nadya pinjam mobil', 44, 0, '2016-02-23 23:02:23', '2016-02-23 16:23:23'),
1370(253, 'New Opportunity', 96, 92, 'nadya pinjam mobil', 44, 0, '2016-02-23 23:02:26', '2016-02-23 16:23:26'),
1371(254, 'New Opportunity', 96, 96, 'nadya pinjam mobil', 44, 1, '2016-02-23 23:02:28', '2016-02-23 16:27:54'),
1372(255, 'New Opportunity', 96, 91, 'nadya pinjam mobil 2', 45, 0, '2016-02-23 23:02:16', '2016-02-23 16:25:16'),
1373(256, 'New Opportunity', 96, 92, 'nadya pinjam mobil 2', 45, 0, '2016-02-23 23:02:18', '2016-02-23 16:25:18'),
1374(257, 'New Opportunity', 96, 96, 'nadya pinjam mobil 2', 45, 1, '2016-02-23 23:02:21', '2016-02-23 16:25:49'),
1375(258, 'New Book "BV00000003"', 96, 96, 'fahrul lho', 152, 0, '2016-02-23 23:02:52', NULL),
1376(259, 'New Book "BV00000004"', 96, 96, 'fahrul lho', 153, 0, '2016-02-23 23:02:00', NULL),
1377(260, 'New Book "BV00000005"', 96, 96, 'ini baru keren', 154, 1, '2016-02-23 23:02:48', '2016-02-24 19:19:02');
1378
1379-- --------------------------------------------------------
1380
1381--
1382-- Table structure for table `offering_service`
1383--
1384
1385CREATE TABLE IF NOT EXISTS `offering_service` (
1386 `id` int(11) NOT NULL AUTO_INCREMENT,
1387 `customer_id` int(11) NOT NULL,
1388 `user_id` int(11) NOT NULL,
1389 `opportunities_id` int(11) NOT NULL,
1390 `vehicle_id` int(11) NOT NULL,
1391 `quantity` tinyint(4) NOT NULL,
1392 `unit_price` tinyint(4) NOT NULL,
1393 `description` text CHARACTER SET latin1 NOT NULL,
1394 `price` decimal(10,0) NOT NULL,
1395 `status` tinyint(4) NOT NULL,
1396 `create_at` timestamp NULL DEFAULT NULL,
1397 `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1398 PRIMARY KEY (`id`),
1399 KEY `customer_id` (`customer_id`),
1400 KEY `user_id` (`user_id`),
1401 KEY `opportunities_id` (`opportunities_id`)
1402) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=113 ;
1403
1404--
1405-- Dumping data for table `offering_service`
1406--
1407
1408INSERT INTO `offering_service` (`id`, `customer_id`, `user_id`, `opportunities_id`, `vehicle_id`, `quantity`, `unit_price`, `description`, `price`, `status`, `create_at`, `update_at`) VALUES
1409(111, 96, 96, 45, 15, 1, 1, 'fahrul lho', '14', 1, '2016-02-22 17:00:00', '2016-02-23 16:30:52'),
1410(112, 96, 96, 45, 15, 1, 2, 'ini baru keren', '110', 1, '2016-02-22 17:00:00', '2016-02-23 16:31:48');
1411
1412-- --------------------------------------------------------
1413
1414--
1415-- Table structure for table `operation_cost`
1416--
1417
1418CREATE TABLE IF NOT EXISTS `operation_cost` (
1419 `operation_id` int(11) NOT NULL AUTO_INCREMENT,
1420 `user_id` int(11) NOT NULL,
1421 `order_id` int(11) NOT NULL,
1422 `item` tinytext CHARACTER SET latin1 NOT NULL,
1423 `item_description` text CHARACTER SET latin1 NOT NULL,
1424 `price` decimal(10,0) NOT NULL,
1425 `qty` smallint(6) NOT NULL,
1426 `amount` decimal(10,0) NOT NULL,
1427 PRIMARY KEY (`operation_id`),
1428 KEY `order_id` (`order_id`)
1429) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1430
1431-- --------------------------------------------------------
1432
1433--
1434-- Table structure for table `opportunities`
1435--
1436
1437CREATE TABLE IF NOT EXISTS `opportunities` (
1438 `id` int(11) NOT NULL AUTO_INCREMENT,
1439 `customer_id` int(11) NOT NULL,
1440 `opportunity_name` varchar(100) CHARACTER SET latin1 NOT NULL,
1441 `vehicle_type_needed` varchar(30) CHARACTER SET latin1 NOT NULL,
1442 `qty_vehcile` smallint(6) NOT NULL,
1443 `was_booked` smallint(6) NOT NULL,
1444 `Start_date` timestamp NULL DEFAULT NULL,
1445 `End_Date` timestamp NULL DEFAULT NULL,
1446 `start_from_location` int(11) NOT NULL,
1447 `to_destination_location` int(11) NOT NULL,
1448 `status` tinyint(4) NOT NULL,
1449 `create_at` timestamp NULL DEFAULT NULL,
1450 `update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1451 PRIMARY KEY (`id`),
1452 KEY `customer_id` (`customer_id`)
1453) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;
1454
1455--
1456-- Dumping data for table `opportunities`
1457--
1458
1459INSERT INTO `opportunities` (`id`, `customer_id`, `opportunity_name`, `vehicle_type_needed`, `qty_vehcile`, `was_booked`, `Start_date`, `End_Date`, `start_from_location`, `to_destination_location`, `status`, `create_at`, `update_at`) VALUES
1460(44, 96, 'nadya pinjam mobil', 'CDE', 3, 3, '2016-03-14 17:00:00', '2016-03-22 17:00:00', 5, 5, 0, '2016-02-23 16:23:19', '2016-02-23 16:23:19'),
1461(45, 96, 'nadya pinjam mobil 2', 'CDE', 3, 0, '2016-03-14 17:00:00', '2016-03-15 17:00:00', 5, 5, 1, '2016-02-23 16:25:12', '2016-02-23 16:31:48');
1462
1463-- --------------------------------------------------------
1464
1465--
1466-- Table structure for table `order`
1467--
1468
1469CREATE TABLE IF NOT EXISTS `order` (
1470 `order_id` int(11) NOT NULL AUTO_INCREMENT,
1471 `order_code` varchar(30) NOT NULL,
1472 `user_id` int(11) NOT NULL,
1473 `book_id` int(11) DEFAULT NULL,
1474 `vehicle_id` int(11) DEFAULT NULL,
1475 `customer_id` int(11) DEFAULT NULL,
1476 `driver_id` int(11) DEFAULT NULL,
1477 `currency` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1478 `order_date` date NOT NULL,
1479 `days` int(11) DEFAULT NULL,
1480 `quantity` smallint(6) NOT NULL,
1481 `start_from` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
1482 `destination_to` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
1483 `price` varchar(30) CHARACTER SET latin1 NOT NULL,
1484 `unit_price` tinyint(4) NOT NULL,
1485 `additional_price_1` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1486 `additional_price_2` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1487 `additional_price_3` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1488 `discount` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1489 `voucher` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1490 `order_quantity` varchar(30) CHARACTER SET latin1 NOT NULL,
1491 `order_amount` varchar(30) CHARACTER SET latin1 NOT NULL,
1492 `description` text CHARACTER SET latin1,
1493 `order_status` tinyint(4) NOT NULL,
1494 `attributes_1` int(30) DEFAULT NULL,
1495 `attributes_2` int(30) DEFAULT NULL,
1496 `attributes_3` int(30) DEFAULT NULL,
1497 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1498 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1499 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1500 PRIMARY KEY (`order_id`),
1501 KEY `FK_FK_B_O` (`book_id`),
1502 KEY `FK_FK_O_MC` (`customer_id`),
1503 KEY `vehicle_id` (`vehicle_id`)
1504) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1505
1506-- --------------------------------------------------------
1507
1508--
1509-- Table structure for table `page`
1510--
1511
1512CREATE TABLE IF NOT EXISTS `page` (
1513 `id` int(11) NOT NULL AUTO_INCREMENT,
1514 `slug` varchar(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1515 `title` varchar(512) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1516 `body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1517 `view` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1518 `status` smallint(6) NOT NULL,
1519 `created_at` int(11) DEFAULT NULL,
1520 `updated_at` int(11) DEFAULT NULL,
1521 PRIMARY KEY (`id`)
1522) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
1523
1524--
1525-- Dumping data for table `page`
1526--
1527
1528INSERT INTO `page` (`id`, `slug`, `title`, `body`, `view`, `status`, `created_at`, `updated_at`) VALUES
1529(1, 'about', 'About', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', NULL, 1, 1441038957, 1441038957);
1530
1531-- --------------------------------------------------------
1532
1533--
1534-- Table structure for table `payment`
1535--
1536
1537CREATE TABLE IF NOT EXISTS `payment` (
1538 `payment_id` int(11) NOT NULL AUTO_INCREMENT,
1539 `user_id` int(11) NOT NULL,
1540 `payment_voucher` varchar(14) CHARACTER SET latin1 NOT NULL DEFAULT '-',
1541 `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1542 `payment_method` tinyint(4) NOT NULL,
1543 `invoice_id` int(11) NOT NULL,
1544 `invoice_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
1545 `invoice_number` varchar(20) CHARACTER SET latin1 NOT NULL,
1546 `invoice_amount` double NOT NULL,
1547 `payment_amount` double NOT NULL,
1548 `remain_amount` decimal(10,0) NOT NULL,
1549 `attach_file` tinytext CHARACTER SET latin1,
1550 PRIMARY KEY (`payment_id`),
1551 KEY `FK_payment_invoice` (`invoice_id`),
1552 KEY `FK_payment_user` (`user_id`)
1553) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1554
1555-- --------------------------------------------------------
1556
1557--
1558-- Table structure for table `price_list`
1559--
1560
1561CREATE TABLE IF NOT EXISTS `price_list` (
1562 `price_list_id` int(11) NOT NULL AUTO_INCREMENT,
1563 `user_id` int(11) NOT NULL,
1564 `vehicle_type` varchar(30) NOT NULL,
1565 `capacity` varchar(11) NOT NULL,
1566 `currency` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
1567 `unit_price` tinyint(4) NOT NULL,
1568 `start_from` int(11) NOT NULL,
1569 `destination_to` int(11) NOT NULL,
1570 `day_estimated` smallint(6) NOT NULL,
1571 `price` int(11) NOT NULL,
1572 `additional_price_1` int(11) DEFAULT NULL,
1573 `additional_price_2` int(11) DEFAULT NULL,
1574 `additional_price_3` int(11) DEFAULT NULL,
1575 `attributes_1` int(30) DEFAULT NULL,
1576 `attributes_2` int(30) DEFAULT NULL,
1577 `attributes_3` int(30) DEFAULT NULL,
1578 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1579 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1580 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
1581 PRIMARY KEY (`price_list_id`),
1582 KEY `start_from` (`start_from`),
1583 KEY `destination_to` (`destination_to`),
1584 KEY `user_id` (`user_id`)
1585) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
1586
1587--
1588-- Dumping data for table `price_list`
1589--
1590
1591INSERT INTO `price_list` (`price_list_id`, `user_id`, `vehicle_type`, `capacity`, `currency`, `unit_price`, `start_from`, `destination_to`, `day_estimated`, `price`, `additional_price_1`, `additional_price_2`, `additional_price_3`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
1592(1, 91, 'Dump Truck', '> 25 Ton', 'IDR', 3, 0, 0, 0, 32000000, 3000000, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1593(2, 91, 'Wing Box', '20 Ton', 'IDR', 2, 0, 0, 0, 7000000, 500000, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1594(3, 91, 'CDD', '15 CBM', 'IDR', 1, 0, 0, 0, 600000, 150000, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1595(4, 91, 'CDE', '15 Ton', 'IDR', 1, 0, 0, 0, 600000, 150000, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1596(5, 91, 'Passenger Car', '5 Seat', 'IDR', 1, 0, 0, 0, 300000, 100000, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1597(6, 91, 'Motor Bike', '2', 'IDR', 1, 0, 0, 0, 500000, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
1598(7, 1, 'Passenger Car', '5 Seat', 'IDR', 5, 5, 6, 2, 10000, 5000, 2000, 3000, NULL, NULL, NULL, NULL, NULL, NULL),
1599(8, 92, 'Motor Bike', '2', 'IDR', 1, 0, 0, 2, 10000, 1, 5, 2, NULL, NULL, NULL, NULL, NULL, NULL),
1600(9, 92, 'Motor Bike', '2', 'IDR', 2, 0, 0, 0, 2000, 1, 2, 3, NULL, NULL, NULL, NULL, NULL, NULL),
1601(10, 92, 'Motor Bike', '2', 'IDR', 3, 0, 0, 0, 3000, 1000, 3, 4, NULL, NULL, NULL, NULL, NULL, NULL),
1602(11, 91, 'Passenger Car', '5 Seat', 'IDR', 2, 0, 0, 0, 5000, 1000, 2000, 3000, NULL, NULL, NULL, NULL, NULL, NULL),
1603(17, 96, 'Passenger Car', '32 Seat', 'IDR', 1, 0, 0, 0, 1, 2, 3, 4, NULL, NULL, NULL, NULL, NULL, NULL),
1604(18, 96, 'Passenger Car', '32 Seat', 'IDR', 6, 6, 7, 0, 2, 2, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL),
1605(19, 96, 'Passenger Car', '32 Seat', 'IDR', 2, 0, 0, 0, 2000, 2, 3, 4, NULL, NULL, NULL, NULL, NULL, NULL),
1606(20, 96, 'Passenger Car', '32 Seat', 'IDR', 5, 127, 127, 0, 1, 2, 3, 4, NULL, NULL, NULL, NULL, NULL, NULL),
1607(21, 96, 'Motor Bike', '2 Seat', 'IDR', 2, 0, 0, 0, 1, 2, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL),
1608(22, 96, 'CDE', '20 Ton', 'IDR', 1, 0, 0, 0, 4, 3, 2, 5, NULL, NULL, NULL, NULL, NULL, NULL),
1609(23, 96, 'Dump Truck', '7 Ton', 'IDR', 1, 0, 0, 0, 5, 5, 6, 7, NULL, NULL, NULL, NULL, NULL, NULL),
1610(24, 96, 'Passenger Car', '32 Seat', 'IDR', 3, 0, 0, 0, 2, 2, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL),
1611(25, 96, 'CDE', '20 Ton', 'DOLLAR', 2, 0, 0, 0, 11, 22, 33, 44, NULL, NULL, NULL, NULL, NULL, NULL),
1612(26, 96, 'CDE', '20 Ton', 'IDR', 3, 0, 0, 0, 10, 20, 30, 40, NULL, NULL, NULL, NULL, NULL, NULL),
1613(27, 96, 'CDE', '20 Ton', 'IDR', 4, 0, 0, 0, 2000000, 80, 900, 1000, NULL, NULL, NULL, NULL, NULL, NULL);
1614
1615-- --------------------------------------------------------
1616
1617--
1618-- Table structure for table `rbac_auth_assignment`
1619--
1620
1621CREATE TABLE IF NOT EXISTS `rbac_auth_assignment` (
1622 `id` int(11) NOT NULL AUTO_INCREMENT,
1623 `item_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1624 `user_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1625 `role_id` varchar(64) NOT NULL,
1626 `created_at` int(11) DEFAULT NULL,
1627 PRIMARY KEY (`item_name`,`user_id`),
1628 UNIQUE KEY `id` (`id`)
1629) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=135 ;
1630
1631--
1632-- Dumping data for table `rbac_auth_assignment`
1633--
1634
1635INSERT INTO `rbac_auth_assignment` (`id`, `item_name`, `user_id`, `role_id`, `created_at`) VALUES
1636(70, 'administrator', '1', '1', 1455529484),
1637(23, 'customer', '1000002', '2', NULL),
1638(7, 'customer', '1000004', '2', 1451656728),
1639(24, 'customer', '1000006', '2', NULL),
1640(25, 'customer', '1000007', '2', NULL),
1641(26, 'customer', '1000008', '2', NULL),
1642(27, 'customer', '1000009', '2', NULL),
1643(28, 'customer', '1000010', '2', NULL),
1644(29, 'customer', '1000011', '2', NULL),
1645(30, 'customer', '1000012', '2', NULL),
1646(31, 'customer', '1000013', '2', NULL),
1647(32, 'customer', '1000014', '2', NULL),
1648(33, 'customer', '1000015', '2', NULL),
1649(34, 'customer', '1000016', '2', NULL),
1650(35, 'customer', '1000017', '2', NULL),
1651(36, 'customer', '1000018', '2', NULL),
1652(37, 'customer', '1000019', '2', NULL),
1653(38, 'customer', '1000020', '2', NULL),
1654(39, 'customer', '1000021', '2', NULL),
1655(40, 'customer', '1000022', '2', NULL),
1656(41, 'customer', '1000023', '2', NULL),
1657(42, 'customer', '1000024', '2', NULL),
1658(43, 'customer', '1000025', '2', NULL),
1659(44, 'customer', '1000026', '2', NULL),
1660(45, 'customer', '1000027', '2', NULL),
1661(46, 'customer', '1000028', '2', NULL),
1662(56, 'customer', '1000034', '2', 1454425452),
1663(57, 'customer', '1000035', '2', 1454425510),
1664(58, 'customer', '1000036', '2', 1454425573),
1665(59, 'customer', '1000037', '2', 1454425609),
1666(62, 'customer', '1000038', '2', 1454556546),
1667(63, 'customer', '1000039', '2', 1454556694),
1668(65, 'customer', '1000041', '2', 1454646061),
1669(67, 'customer', '1000042', '2', 1455012172),
1670(68, 'customer', '1000043', '2', 1455012219),
1671(69, 'customer', '1000045', '2', 1455267028),
1672(87, 'customer', '1000089', '2', 1455549428),
1673(89, 'customer', '1000090', '2', 1455549495),
1674(91, 'customer', '1000093', '2', 1455549743),
1675(93, 'customer', '1000096', '2', 1455550048),
1676(94, 'customer', '1000098', '2', 1455550147),
1677(95, 'customer', '1000099', '2', 1455550266),
1678(97, 'customer', '1000100', '2', 1455550691),
1679(98, 'customer', '1000101', '2', 1455550706),
1680(123, 'customer', '1000103', '2', 1456201886),
1681(129, 'customer', '1000104', '2', 1456204541),
1682(130, 'customer', '1000105', '2', 1456204597),
1683(131, 'customer', '1000106', '2', 1456204612),
1684(132, 'customer', '1000107', '2', 1456204777),
1685(8, 'customer', '96', '2', 1451714135),
1686(118, 'user', '103', '1', 1456200686),
1687(119, 'user', '104', '1', 1456200978),
1688(120, 'user', '105', '1', 1456201142),
1689(121, 'user', '106', '1', 1456201213),
1690(122, 'user', '107', '1', 1456201662),
1691(124, 'user', '108', '1', 1456202291),
1692(125, 'user', '109', '1', 1456203430),
1693(126, 'user', '110', '1', 1456203472),
1694(127, 'user', '111', '1', 1456204308),
1695(128, 'user', '112', '1', 1456204400),
1696(133, 'user', '113', '1', 1456204875),
1697(134, 'user', '114', '1', 1456233074),
1698(12, 'user', '17', '1', NULL),
1699(13, 'user', '18', '1', NULL),
1700(14, 'user', '19', '1', NULL),
1701(15, 'user', '20', '1', NULL),
1702(16, 'user', '22', '1', NULL),
1703(17, 'user', '24', '1', NULL),
1704(18, 'user', '29', '1', NULL),
1705(19, 'user', '30', '1', NULL),
1706(20, 'user', '31', '1', NULL),
1707(22, 'user', '33', '1', NULL),
1708(9, 'user', '6', '1', NULL),
1709(10, 'user', '7', '1', NULL),
1710(11, 'user', '9', '1', NULL),
1711(6, 'user', '91', '1', 1451655795),
1712(49, 'user', '92', '1', 1451975700),
1713(60, 'user', '94', '1', 1454429748),
1714(61, 'user', '95', '1', 1454429856),
1715(66, 'user', '96', '1', 1454647034),
1716(96, 'user', '97', '1', 1455550287),
1717(99, 'user', '98', '1', 1455550719);
1718
1719-- --------------------------------------------------------
1720
1721--
1722-- Table structure for table `rbac_auth_item`
1723--
1724
1725CREATE TABLE IF NOT EXISTS `rbac_auth_item` (
1726 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1727 `type` int(11) NOT NULL,
1728 `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1729 `rule_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1730 `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1731 `created_at` int(11) DEFAULT NULL,
1732 `updated_at` int(11) DEFAULT NULL,
1733 PRIMARY KEY (`name`),
1734 KEY `rule_name` (`rule_name`),
1735 KEY `idx-auth_item-type` (`type`)
1736) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1737
1738--
1739-- Dumping data for table `rbac_auth_item`
1740--
1741
1742INSERT INTO `rbac_auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
1743('/api/*', 2, NULL, NULL, NULL, 1454149546, 1454149546),
1744('/api/v1/*', 2, NULL, NULL, NULL, 1454148073, 1454148073),
1745('/article/*', 2, NULL, NULL, NULL, 1454252401, 1454252401),
1746('/attribute/*', 2, NULL, NULL, NULL, 1454148194, 1454148194),
1747('/book/ajax-date-vehicle', 2, NULL, NULL, NULL, 1454401158, 1454401158),
1748('/book/book-ajax-field', 2, NULL, NULL, NULL, 1454386869, 1454386869),
1749('/book/cancel', 2, NULL, NULL, NULL, 1454149568, 1454149568),
1750('/book/clear-session-operational', 2, NULL, NULL, NULL, 1454149567, 1454149567),
1751('/book/create', 2, NULL, NULL, NULL, 1454149569, 1454149569),
1752('/book/create-driver', 2, NULL, NULL, NULL, 1454149569, 1454149569),
1753('/book/delete', 2, NULL, NULL, NULL, 1454149571, 1454149571),
1754('/book/driver-ajax-field', 2, NULL, NULL, NULL, 1454149571, 1454149571),
1755('/book/index', 2, NULL, NULL, NULL, 1454149572, 1454149572),
1756('/book/order', 2, NULL, NULL, NULL, 1454149573, 1454149573),
1757('/book/price-list-ajax', 2, NULL, NULL, NULL, 1454149573, 1454149573),
1758('/book/submit-price', 2, NULL, NULL, NULL, 1454149574, 1454149574),
1759('/book/update', 2, NULL, NULL, NULL, 1454149574, 1454149574),
1760('/book/vehicle-id-ajax', 2, NULL, NULL, NULL, 1454149562, 1454149562),
1761('/book/view', 2, NULL, NULL, NULL, 1454149562, 1454149562),
1762('/book/view-administrator', 2, NULL, NULL, NULL, 1454148497, 1454148497),
1763('/cache/*', 2, NULL, NULL, NULL, 1454148192, 1454148192),
1764('/countries/*', 2, NULL, NULL, NULL, 1454610934, 1454610934),
1765('/debug/*', 2, NULL, NULL, NULL, 1454148191, 1454148191),
1766('/debug/default/*', 2, NULL, NULL, NULL, 1454404822, 1454404822),
1767('/driver/*', 2, NULL, NULL, NULL, 1454150072, 1454150072),
1768('/file-manager-elfinder/*', 2, NULL, NULL, NULL, 1454156784, 1454156784),
1769('/file-manager-elfinder/connect', 2, NULL, NULL, NULL, 1454156132, 1454156132),
1770('/file-manager-elfinder/manager', 2, NULL, NULL, NULL, 1454156132, 1454156132),
1771('/file-manager/*', 2, NULL, NULL, NULL, 1454156784, 1454156784),
1772('/file-manager/index', 2, NULL, NULL, NULL, 1454156308, 1454156308),
1773('/file-storage/*', 2, NULL, NULL, NULL, 1454148267, 1454148267),
1774('/gii/*', 2, NULL, NULL, NULL, 1454156322, 1454156322),
1775('/i18n/*', 2, NULL, NULL, NULL, 1454148181, 1454148181),
1776('/inbox/*', 2, NULL, NULL, NULL, 1454149595, 1454149595),
1777('/invoice/*', 2, NULL, NULL, NULL, 1454404802, 1454404802),
1778('/key-storage/*', 2, NULL, NULL, NULL, 1454148302, 1454148302),
1779('/list-customer/*', 2, NULL, NULL, NULL, 1454148304, 1454148304),
1780('/list-customer/index', 2, NULL, NULL, NULL, 1454150107, 1454150107),
1781('/log/*', 2, NULL, NULL, NULL, 1454148304, 1454148304),
1782('/maintenance-item/*', 2, NULL, NULL, NULL, 1454150112, 1454150112),
1783('/maintenance-trx/*', 2, NULL, NULL, NULL, 1454150114, 1454150114),
1784('/master-customer-profile/create', 2, NULL, NULL, NULL, 1454150121, 1454150121),
1785('/master-customer-profile/delete', 2, NULL, NULL, NULL, 1454150120, 1454150120),
1786('/master-customer-profile/index', 2, NULL, NULL, NULL, 1454150120, 1454150120),
1787('/master-customer-profile/update', 2, NULL, NULL, NULL, 1454150120, 1454150120),
1788('/master-customer-profile/view', 2, NULL, NULL, NULL, 1454150119, 1454150119),
1789('/master-customer-profile/view-administrator', 2, NULL, NULL, NULL, 1454154587, 1454154587),
1790('/master-customer/*', 2, NULL, NULL, NULL, 1454232425, 1454232425),
1791('/master-vehicle/ajax-suggest-area', 2, NULL, NULL, NULL, 1454150136, 1454150136),
1792('/master-vehicle/avatar-delete', 2, NULL, NULL, NULL, 1454150136, 1454150136),
1793('/master-vehicle/avatar-upload', 2, NULL, NULL, NULL, 1454150136, 1454150136),
1794('/master-vehicle/brand-list', 2, NULL, NULL, NULL, 1454150135, 1454150135),
1795('/master-vehicle/capacity', 2, NULL, NULL, NULL, 1454150134, 1454150134),
1796('/master-vehicle/car', 2, NULL, NULL, NULL, 1454150127, 1454150127),
1797('/master-vehicle/create', 2, NULL, NULL, NULL, 1454150127, 1454150127),
1798('/master-vehicle/delete', 2, NULL, NULL, NULL, 1455090973, 1455090973),
1799('/master-vehicle/index', 2, NULL, NULL, NULL, 1454150126, 1454150126),
1800('/master-vehicle/map', 2, NULL, NULL, NULL, 1454383360, 1454383360),
1801('/master-vehicle/price-list', 2, NULL, NULL, NULL, 1454150124, 1454150124),
1802('/master-vehicle/update', 2, NULL, NULL, NULL, 1454398389, 1454398389),
1803('/master-vehicle/vehicle-list', 2, NULL, NULL, NULL, 1454150135, 1454150135),
1804('/master-vehicle/view', 2, NULL, NULL, NULL, 1454654842, 1454654842),
1805('/master-vehicle/view-admin', 2, NULL, NULL, NULL, 1454647544, 1454647544),
1806('/mimin/*', 2, NULL, NULL, NULL, 1454148169, 1454148169),
1807('/notification/index', 2, NULL, NULL, NULL, 1454157364, 1454157364),
1808('/notification/index-administrator', 2, NULL, NULL, NULL, 1454231161, 1454231161),
1809('/offering-service/ajax-price', 2, NULL, NULL, NULL, 1454158087, 1454158087),
1810('/offering-service/booking', 2, NULL, NULL, NULL, 1454158042, 1454158042),
1811('/offering-service/create', 2, NULL, NULL, NULL, 1454158089, 1454158089),
1812('/offering-service/index', 2, NULL, NULL, NULL, 1454158048, 1454158048),
1813('/offering-service/submit-price', 2, NULL, NULL, NULL, 1454158090, 1454158090),
1814('/offering-service/update', 2, NULL, NULL, NULL, 1454158091, 1454158091),
1815('/offering-service/view', 2, NULL, NULL, NULL, 1454158091, 1454158091),
1816('/operation-cost/index', 2, NULL, NULL, NULL, 1454392801, 1454392801),
1817('/operation-cost/view', 2, NULL, NULL, NULL, 1454392802, 1454392802),
1818('/opportunities/create', 2, NULL, NULL, NULL, 1454157107, 1454157107),
1819('/opportunities/index', 2, NULL, NULL, NULL, 1454157090, 1454157090),
1820('/opportunities/update', 2, NULL, NULL, NULL, 1454157281, 1454157281),
1821('/opportunities/view', 2, NULL, NULL, NULL, 1454157277, 1454157277),
1822('/opportunities/view-administrator', 2, NULL, NULL, NULL, 1454232006, 1454232006),
1823('/order/*', 2, NULL, NULL, NULL, 1454150157, 1454150157),
1824('/payment/*', 2, NULL, NULL, NULL, 1455627569, 1455627569),
1825('/price-list/*', 2, NULL, NULL, NULL, 1454150161, 1454150161),
1826('/service-area/*', 2, NULL, NULL, NULL, 1454150163, 1454150163),
1827('/sign-in/*', 2, NULL, NULL, NULL, 1454148116, 1454148116),
1828('/site/*', 2, NULL, NULL, NULL, 1454298605, 1454298605),
1829('/site/ajax-suggest-area', 2, NULL, NULL, NULL, 1454252483, 1454252483),
1830('/site/available-vehicle', 2, NULL, NULL, NULL, 1454252484, 1454252484),
1831('/site/book', 2, NULL, NULL, NULL, 1454252487, 1454252487),
1832('/site/captcha', 2, NULL, NULL, NULL, 1454252488, 1454252488),
1833('/site/contact', 2, NULL, NULL, NULL, 1454252488, 1454252488),
1834('/site/error', 2, NULL, NULL, NULL, 1454252489, 1454252489),
1835('/site/index', 2, NULL, NULL, NULL, 1454252594, 1454252594),
1836('/site/set-locale', 2, NULL, NULL, NULL, 1454252596, 1454252596),
1837('/site/share', 2, NULL, NULL, NULL, 1454252494, 1454252494),
1838('/site/test', 2, NULL, NULL, NULL, 1454252496, 1454252496),
1839('/site/track', 2, NULL, NULL, NULL, 1454252495, 1454252495),
1840('/subscribe/*', 2, NULL, NULL, NULL, 1454149666, 1454149666),
1841('/system-information/*', 2, NULL, NULL, NULL, 1454148110, 1454148110),
1842('/track/*', 2, NULL, NULL, NULL, 1454148105, 1454148105),
1843('/tracking/*', 2, NULL, NULL, NULL, 1454311348, 1454311348),
1844('/user/create', 2, NULL, NULL, NULL, 1454399133, 1454399133),
1845('/user/default/account', 2, NULL, NULL, NULL, 1454150185, 1454150185),
1846('/user/default/avatar-delete', 2, NULL, NULL, NULL, 1454149679, 1454149679),
1847('/user/default/avatar-upload', 2, NULL, NULL, NULL, 1454149680, 1454149680),
1848('/user/default/index', 2, NULL, NULL, NULL, 1454149760, 1454149760),
1849('/user/default/index-customer', 2, NULL, NULL, NULL, 1454152497, 1454152497),
1850('/user/default/index-owner', 2, NULL, NULL, NULL, 1454150192, 1454150192),
1851('/user/default/profile', 2, NULL, NULL, NULL, 1454149688, 1454149688),
1852('/user/index', 2, NULL, NULL, NULL, 1454399134, 1454399134),
1853('/user/sign-in/*', 2, NULL, NULL, NULL, 1454149353, 1454149353),
1854('/user/update', 2, NULL, NULL, NULL, 1454399134, 1454399134),
1855('/user/view', 2, NULL, NULL, NULL, 1454399135, 1454399135),
1856('/warehouse/*', 2, NULL, NULL, NULL, 1454150196, 1454150196),
1857('/widget-carousel-item/*', 2, NULL, NULL, NULL, 1454150344, 1454150344),
1858('/widget-carousel/*', 2, NULL, NULL, NULL, 1454150345, 1454150345),
1859('/widget-menu/*', 2, NULL, NULL, NULL, 1454150344, 1454150344),
1860('/widget-text/*', 2, NULL, NULL, NULL, 1454150343, 1454150343),
1861('administrator', 1, NULL, NULL, NULL, 1441038963, 1454314082),
1862('createOpportunity', 2, NULL, 'ownModelRule', NULL, 1454056844, 1454056844),
1863('customer', 1, NULL, NULL, NULL, 1441038963, 1454426290),
1864('updateOwnPost', 2, 'Update own post', 'ownModelRule', NULL, 1454057637, 1454057652),
1865('updatePost', 2, NULL, NULL, NULL, 1454057714, 1454057714),
1866('user', 1, NULL, NULL, NULL, 1441038963, 1454417609);
1867
1868-- --------------------------------------------------------
1869
1870--
1871-- Table structure for table `rbac_auth_item_child`
1872--
1873
1874CREATE TABLE IF NOT EXISTS `rbac_auth_item_child` (
1875 `parent` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1876 `child` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1877 PRIMARY KEY (`parent`,`child`),
1878 KEY `child` (`child`)
1879) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1880
1881--
1882-- Dumping data for table `rbac_auth_item_child`
1883--
1884
1885INSERT INTO `rbac_auth_item_child` (`parent`, `child`) VALUES
1886('administrator', '/api/*'),
1887('customer', '/api/*'),
1888('user', '/api/*'),
1889('administrator', '/api/v1/*'),
1890('customer', '/api/v1/*'),
1891('user', '/api/v1/*'),
1892('administrator', '/article/*'),
1893('administrator', '/attribute/*'),
1894('customer', '/book/ajax-date-vehicle'),
1895('user', '/book/ajax-date-vehicle'),
1896('customer', '/book/book-ajax-field'),
1897('user', '/book/book-ajax-field'),
1898('customer', '/book/cancel'),
1899('user', '/book/cancel'),
1900('customer', '/book/clear-session-operational'),
1901('user', '/book/clear-session-operational'),
1902('customer', '/book/create'),
1903('user', '/book/create'),
1904('customer', '/book/create-driver'),
1905('user', '/book/create-driver'),
1906('customer', '/book/delete'),
1907('user', '/book/delete'),
1908('customer', '/book/driver-ajax-field'),
1909('user', '/book/driver-ajax-field'),
1910('customer', '/book/index'),
1911('user', '/book/index'),
1912('customer', '/book/order'),
1913('user', '/book/order'),
1914('customer', '/book/price-list-ajax'),
1915('user', '/book/price-list-ajax'),
1916('customer', '/book/submit-price'),
1917('user', '/book/submit-price'),
1918('customer', '/book/update'),
1919('user', '/book/update'),
1920('customer', '/book/vehicle-id-ajax'),
1921('user', '/book/vehicle-id-ajax'),
1922('customer', '/book/view'),
1923('user', '/book/view'),
1924('administrator', '/book/view-administrator'),
1925('administrator', '/cache/*'),
1926('administrator', '/countries/*'),
1927('administrator', '/debug/*'),
1928('user', '/debug/*'),
1929('user', '/debug/default/*'),
1930('user', '/driver/*'),
1931('administrator', '/file-manager-elfinder/*'),
1932('administrator', '/file-manager-elfinder/connect'),
1933('administrator', '/file-manager-elfinder/manager'),
1934('administrator', '/file-manager/*'),
1935('administrator', '/file-manager/index'),
1936('administrator', '/file-storage/*'),
1937('administrator', '/gii/*'),
1938('administrator', '/i18n/*'),
1939('customer', '/inbox/*'),
1940('user', '/invoice/*'),
1941('administrator', '/key-storage/*'),
1942('administrator', '/list-customer/*'),
1943('user', '/list-customer/index'),
1944('administrator', '/log/*'),
1945('user', '/maintenance-item/*'),
1946('user', '/maintenance-trx/*'),
1947('user', '/master-customer-profile/create'),
1948('user', '/master-customer-profile/delete'),
1949('user', '/master-customer-profile/index'),
1950('user', '/master-customer-profile/update'),
1951('user', '/master-customer-profile/view'),
1952('administrator', '/master-customer-profile/view-administrator'),
1953('administrator', '/master-customer/*'),
1954('customer', '/master-vehicle/ajax-suggest-area'),
1955('user', '/master-vehicle/ajax-suggest-area'),
1956('customer', '/master-vehicle/avatar-delete'),
1957('user', '/master-vehicle/avatar-delete'),
1958('customer', '/master-vehicle/avatar-upload'),
1959('user', '/master-vehicle/avatar-upload'),
1960('customer', '/master-vehicle/brand-list'),
1961('user', '/master-vehicle/brand-list'),
1962('customer', '/master-vehicle/capacity'),
1963('user', '/master-vehicle/capacity'),
1964('customer', '/master-vehicle/car'),
1965('user', '/master-vehicle/car'),
1966('customer', '/master-vehicle/create'),
1967('user', '/master-vehicle/create'),
1968('user', '/master-vehicle/delete'),
1969('customer', '/master-vehicle/index'),
1970('user', '/master-vehicle/index'),
1971('customer', '/master-vehicle/map'),
1972('user', '/master-vehicle/map'),
1973('customer', '/master-vehicle/price-list'),
1974('user', '/master-vehicle/price-list'),
1975('user', '/master-vehicle/update'),
1976('customer', '/master-vehicle/vehicle-list'),
1977('user', '/master-vehicle/vehicle-list'),
1978('customer', '/master-vehicle/view'),
1979('user', '/master-vehicle/view'),
1980('user', '/master-vehicle/view-admin'),
1981('administrator', '/mimin/*'),
1982('user', '/notification/index'),
1983('administrator', '/notification/index-administrator'),
1984('user', '/offering-service/ajax-price'),
1985('customer', '/offering-service/booking'),
1986('user', '/offering-service/booking'),
1987('user', '/offering-service/create'),
1988('customer', '/offering-service/index'),
1989('user', '/offering-service/index'),
1990('user', '/offering-service/submit-price'),
1991('user', '/offering-service/update'),
1992('customer', '/offering-service/view'),
1993('user', '/offering-service/view'),
1994('user', '/operation-cost/index'),
1995('user', '/operation-cost/view'),
1996('customer', '/opportunities/create'),
1997('customer', '/opportunities/index'),
1998('user', '/opportunities/index'),
1999('customer', '/opportunities/update'),
2000('customer', '/opportunities/view'),
2001('user', '/opportunities/view'),
2002('administrator', '/opportunities/view-administrator'),
2003('user', '/order/*'),
2004('user', '/payment/*'),
2005('user', '/price-list/*'),
2006('user', '/service-area/*'),
2007('administrator', '/sign-in/*'),
2008('customer', '/sign-in/*'),
2009('user', '/sign-in/*'),
2010('customer', '/site/*'),
2011('user', '/site/ajax-suggest-area'),
2012('user', '/site/available-vehicle'),
2013('user', '/site/book'),
2014('user', '/site/captcha'),
2015('user', '/site/contact'),
2016('user', '/site/error'),
2017('user', '/site/index'),
2018('user', '/site/set-locale'),
2019('user', '/site/share'),
2020('user', '/site/test'),
2021('user', '/site/track'),
2022('customer', '/subscribe/*'),
2023('user', '/subscribe/*'),
2024('administrator', '/system-information/*'),
2025('administrator', '/track/*'),
2026('customer', '/track/*'),
2027('user', '/track/*'),
2028('user', '/tracking/*'),
2029('administrator', '/user/create'),
2030('customer', '/user/default/account'),
2031('user', '/user/default/account'),
2032('customer', '/user/default/avatar-delete'),
2033('user', '/user/default/avatar-delete'),
2034('customer', '/user/default/avatar-upload'),
2035('user', '/user/default/avatar-upload'),
2036('customer', '/user/default/index'),
2037('user', '/user/default/index'),
2038('customer', '/user/default/index-customer'),
2039('user', '/user/default/index-owner'),
2040('customer', '/user/default/profile'),
2041('administrator', '/user/index'),
2042('administrator', '/user/sign-in/*'),
2043('customer', '/user/sign-in/*'),
2044('user', '/user/sign-in/*'),
2045('administrator', '/user/update'),
2046('administrator', '/user/view'),
2047('user', '/warehouse/*'),
2048('administrator', '/widget-carousel-item/*'),
2049('administrator', '/widget-carousel/*'),
2050('administrator', '/widget-menu/*'),
2051('administrator', '/widget-text/*');
2052
2053-- --------------------------------------------------------
2054
2055--
2056-- Table structure for table `rbac_auth_rule`
2057--
2058
2059CREATE TABLE IF NOT EXISTS `rbac_auth_rule` (
2060 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2061 `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
2062 `created_at` int(11) DEFAULT NULL,
2063 `updated_at` int(11) DEFAULT NULL,
2064 PRIMARY KEY (`name`)
2065) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2066
2067--
2068-- Dumping data for table `rbac_auth_rule`
2069--
2070
2071INSERT INTO `rbac_auth_rule` (`name`, `data`, `created_at`, `updated_at`) VALUES
2072('ownModelRule', 'O:25:"common\\rbac\\rule\\OwnModel":3:{s:4:"name";s:12:"ownModelRule";s:9:"createdAt";i:1454040121;s:9:"updatedAt";i:1454054039;}', 1454040121, 1454054039);
2073
2074-- --------------------------------------------------------
2075
2076--
2077-- Table structure for table `route`
2078--
2079
2080CREATE TABLE IF NOT EXISTS `route` (
2081 `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
2082 `alias` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
2083 `type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
2084 `status` smallint(6) NOT NULL DEFAULT '1',
2085 PRIMARY KEY (`name`)
2086) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2087
2088--
2089-- Dumping data for table `route`
2090--
2091
2092INSERT INTO `route` (`name`, `alias`, `type`, `status`) VALUES
2093('/*', '*', '', 1),
2094('/admin/*', '*', 'admin', 1),
2095('/admin/assignment/*', '*', 'admin/assignment', 1),
2096('/admin/assignment/assign', 'assign', 'admin/assignment', 1),
2097('/admin/assignment/index', 'index', 'admin/assignment', 1),
2098('/admin/assignment/search', 'search', 'admin/assignment', 1),
2099('/admin/assignment/view', 'view', 'admin/assignment', 1),
2100('/admin/default/*', '*', 'admin/default', 1),
2101('/admin/default/index', 'index', 'admin/default', 1),
2102('/admin/menu/*', '*', 'admin/menu', 1),
2103('/admin/menu/create', 'create', 'admin/menu', 1),
2104('/admin/menu/delete', 'delete', 'admin/menu', 1),
2105('/admin/menu/index', 'index', 'admin/menu', 1),
2106('/admin/menu/update', 'update', 'admin/menu', 1),
2107('/admin/menu/view', 'view', 'admin/menu', 1),
2108('/admin/permission/*', '*', 'admin/permission', 1),
2109('/admin/permission/assign', 'assign', 'admin/permission', 1),
2110('/admin/permission/create', 'create', 'admin/permission', 1),
2111('/admin/permission/delete', 'delete', 'admin/permission', 1),
2112('/admin/permission/index', 'index', 'admin/permission', 1),
2113('/admin/permission/search', 'search', 'admin/permission', 1),
2114('/admin/permission/update', 'update', 'admin/permission', 1),
2115('/admin/permission/view', 'view', 'admin/permission', 1),
2116('/admin/role/*', '*', 'admin/role', 1),
2117('/admin/role/assign', 'assign', 'admin/role', 1),
2118('/admin/role/create', 'create', 'admin/role', 1),
2119('/admin/role/delete', 'delete', 'admin/role', 1),
2120('/admin/role/index', 'index', 'admin/role', 1),
2121('/admin/role/search', 'search', 'admin/role', 1),
2122('/admin/role/update', 'update', 'admin/role', 1),
2123('/admin/role/view', 'view', 'admin/role', 1),
2124('/admin/route/*', '*', 'admin/route', 1),
2125('/admin/route/assign', 'assign', 'admin/route', 1),
2126('/admin/route/create', 'create', 'admin/route', 1),
2127('/admin/route/index', 'index', 'admin/route', 1),
2128('/admin/route/search', 'search', 'admin/route', 1),
2129('/admin/rule/*', '*', 'admin/rule', 1),
2130('/admin/rule/create', 'create', 'admin/rule', 1),
2131('/admin/rule/delete', 'delete', 'admin/rule', 1),
2132('/admin/rule/index', 'index', 'admin/rule', 1),
2133('/admin/rule/update', 'update', 'admin/rule', 1),
2134('/admin/rule/view', 'view', 'admin/rule', 1),
2135('/api/*', '*', 'api', 1),
2136('/api/v1/*', '*', 'api/v1', 1),
2137('/api/v1/article/*', '*', 'api/v1/article', 1),
2138('/api/v1/article/index', 'index', 'api/v1/article', 1),
2139('/api/v1/article/options', 'options', 'api/v1/article', 1),
2140('/api/v1/article/view', 'view', 'api/v1/article', 1),
2141('/api/v1/user/*', '*', 'api/v1/user', 1),
2142('/api/v1/user/index', 'index', 'api/v1/user', 1),
2143('/api/v1/user/options', 'options', 'api/v1/user', 1),
2144('/api/v1/user/view', 'view', 'api/v1/user', 1),
2145('/article-category/*', '*', 'article-category', 1),
2146('/article-category/create', 'create', 'article-category', 1),
2147('/article-category/delete', 'delete', 'article-category', 1),
2148('/article-category/index', 'index', 'article-category', 1),
2149('/article-category/update', 'update', 'article-category', 1),
2150('/article-category/view', 'view', 'article-category', 1),
2151('/article/*', '*', 'article', 1),
2152('/article/attachment-download', 'attachment-download', 'article', 1),
2153('/article/create', 'create', 'article', 1),
2154('/article/delete', 'delete', 'article', 1),
2155('/article/index', 'index', 'article', 1),
2156('/article/update', 'update', 'article', 1),
2157('/article/view', 'view', 'article', 1),
2158('/attribute/*', '*', 'attribute', 1),
2159('/attribute/create', 'create', 'attribute', 1),
2160('/attribute/delete', 'delete', 'attribute', 1),
2161('/attribute/index', 'index', 'attribute', 1),
2162('/attribute/update', 'update', 'attribute', 1),
2163('/attribute/view', 'view', 'attribute', 1),
2164('/available-vehicle/*', '*', 'available-vehicle', 1),
2165('/available-vehicle/book-ajax-field', 'book-ajax-field', 'available-vehicle', 1),
2166('/available-vehicle/booked-date', 'booked-date', 'available-vehicle', 1),
2167('/available-vehicle/create', 'create', 'available-vehicle', 1),
2168('/available-vehicle/delete', 'delete', 'available-vehicle', 1),
2169('/available-vehicle/index', 'index', 'available-vehicle', 1),
2170('/available-vehicle/tabs-data', 'tabs-data', 'available-vehicle', 1),
2171('/available-vehicle/update', 'update', 'available-vehicle', 1),
2172('/available-vehicle/view', 'view', 'available-vehicle', 1),
2173('/book/*', '*', 'book', 1),
2174('/book/ajax-date-vehicle', 'ajax-date-vehicle', 'book', 1),
2175('/book/ajax-operational-cost', 'ajax-operational-cost', 'book', 1),
2176('/book/book-ajax-field', 'book-ajax-field', 'book', 1),
2177('/book/cancel', 'cancel', 'book', 1),
2178('/book/clear-session-operational', 'clear-session-operational', 'book', 1),
2179('/book/create', 'create', 'book', 1),
2180('/book/create-driver', 'create-driver', 'book', 1),
2181('/book/delete', 'delete', 'book', 1),
2182('/book/driver-ajax-field', 'driver-ajax-field', 'book', 1),
2183('/book/index', 'index', 'book', 1),
2184('/book/order', 'order', 'book', 1),
2185('/book/price-list-ajax', 'price-list-ajax', 'book', 1),
2186('/book/submit-price', 'submit-price', 'book', 1),
2187('/book/update', 'update', 'book', 1),
2188('/book/vehicle-id-ajax', 'vehicle-id-ajax', 'book', 1),
2189('/book/view', 'view', 'book', 1),
2190('/book/view-administrator', 'view-administrator', 'book', 1),
2191('/cache/*', '*', 'cache', 1),
2192('/cache/flush-cache', 'flush-cache', 'cache', 1),
2193('/cache/flush-cache-key', 'flush-cache-key', 'cache', 1),
2194('/cache/flush-cache-tag', 'flush-cache-tag', 'cache', 1),
2195('/cache/index', 'index', 'cache', 1),
2196('/countries/*', '*', 'countries', 1),
2197('/countries/create', 'create', 'countries', 1),
2198('/countries/delete', 'delete', 'countries', 1),
2199('/countries/index', 'index', 'countries', 1),
2200('/countries/update', 'update', 'countries', 1),
2201('/countries/view', 'view', 'countries', 1),
2202('/debug/*', '*', 'debug', 1),
2203('/debug/default/*', '*', 'debug/default', 1),
2204('/debug/default/db-explain', 'db-explain', 'debug/default', 1),
2205('/debug/default/download-mail', 'download-mail', 'debug/default', 1),
2206('/debug/default/index', 'index', 'debug/default', 1),
2207('/debug/default/toolbar', 'toolbar', 'debug/default', 1),
2208('/debug/default/view', 'view', 'debug/default', 1),
2209('/driver/*', '*', 'driver', 1),
2210('/driver/create', 'create', 'driver', 1),
2211('/driver/delete', 'delete', 'driver', 1),
2212('/driver/index', 'index', 'driver', 1),
2213('/driver/update', 'update', 'driver', 1),
2214('/driver/view', 'view', 'driver', 1),
2215('/file-manager-elfinder/*', '*', 'file-manager-elfinder', 1),
2216('/file-manager-elfinder/connect', 'connect', 'file-manager-elfinder', 1),
2217('/file-manager-elfinder/manager', 'manager', 'file-manager-elfinder', 1),
2218('/file-manager/*', '*', 'file-manager', 1),
2219('/file-manager/index', 'index', 'file-manager', 1),
2220('/file-storage/*', '*', 'file-storage', 1),
2221('/file-storage/delete', 'delete', 'file-storage', 1),
2222('/file-storage/index', 'index', 'file-storage', 1),
2223('/file-storage/upload', 'upload', 'file-storage', 1),
2224('/file-storage/upload-delete', 'upload-delete', 'file-storage', 1),
2225('/file-storage/upload-imperavi', 'upload-imperavi', 'file-storage', 1),
2226('/file-storage/view', 'view', 'file-storage', 1),
2227('/gii/*', '*', 'gii', 1),
2228('/gii/default/*', '*', 'gii/default', 1),
2229('/gii/default/action', 'action', 'gii/default', 1),
2230('/gii/default/diff', 'diff', 'gii/default', 1),
2231('/gii/default/index', 'index', 'gii/default', 1),
2232('/gii/default/preview', 'preview', 'gii/default', 1),
2233('/gii/default/view', 'view', 'gii/default', 1),
2234('/i18n/*', '*', 'i18n', 1),
2235('/i18n/i18n-message/*', '*', 'i18n/i18n-message', 1),
2236('/i18n/i18n-message/create', 'create', 'i18n/i18n-message', 1),
2237('/i18n/i18n-message/delete', 'delete', 'i18n/i18n-message', 1),
2238('/i18n/i18n-message/index', 'index', 'i18n/i18n-message', 1),
2239('/i18n/i18n-message/update', 'update', 'i18n/i18n-message', 1),
2240('/i18n/i18n-source-message/*', '*', 'i18n/i18n-source-message', 1),
2241('/i18n/i18n-source-message/create', 'create', 'i18n/i18n-source-message', 1),
2242('/i18n/i18n-source-message/delete', 'delete', 'i18n/i18n-source-message', 1),
2243('/i18n/i18n-source-message/index', 'index', 'i18n/i18n-source-message', 1),
2244('/i18n/i18n-source-message/update', 'update', 'i18n/i18n-source-message', 1),
2245('/i18n/i18n-source-message/view', 'view', 'i18n/i18n-source-message', 1),
2246('/inbox/*', '*', 'inbox', 1),
2247('/inbox/index', 'index', 'inbox', 1),
2248('/invoice/*', '*', 'invoice', 1),
2249('/invoice/create', 'create', 'invoice', 1),
2250('/invoice/delete', 'delete', 'invoice', 1),
2251('/invoice/export-excel', 'export-excel', 'invoice', 1),
2252('/invoice/export-pdf', 'export-pdf', 'invoice', 1),
2253('/invoice/index', 'index', 'invoice', 1),
2254('/invoice/order-ajax-field', 'order-ajax-field', 'invoice', 1),
2255('/invoice/update', 'update', 'invoice', 1),
2256('/invoice/view', 'view', 'invoice', 1),
2257('/invoice/view-invoice', 'view-invoice', 'invoice', 1),
2258('/key-storage/*', '*', 'key-storage', 1),
2259('/key-storage/create', 'create', 'key-storage', 1),
2260('/key-storage/delete', 'delete', 'key-storage', 1),
2261('/key-storage/index', 'index', 'key-storage', 1),
2262('/key-storage/update', 'update', 'key-storage', 1),
2263('/list-customer/*', '*', 'list-customer', 1),
2264('/list-customer/index', 'index', 'list-customer', 1),
2265('/log/*', '*', 'log', 1),
2266('/log/delete', 'delete', 'log', 1),
2267('/log/index', 'index', 'log', 1),
2268('/log/view', 'view', 'log', 1),
2269('/maintenance-item/*', '*', 'maintenance-item', 1),
2270('/maintenance-item/create', 'create', 'maintenance-item', 1),
2271('/maintenance-item/delete', 'delete', 'maintenance-item', 1),
2272('/maintenance-item/index', 'index', 'maintenance-item', 1),
2273('/maintenance-item/update', 'update', 'maintenance-item', 1),
2274('/maintenance-item/view', 'view', 'maintenance-item', 1),
2275('/maintenance-trx/*', '*', 'maintenance-trx', 1),
2276('/maintenance-trx/create', 'create', 'maintenance-trx', 1),
2277('/maintenance-trx/delete', 'delete', 'maintenance-trx', 1),
2278('/maintenance-trx/index', 'index', 'maintenance-trx', 1),
2279('/maintenance-trx/update', 'update', 'maintenance-trx', 1),
2280('/maintenance-trx/view', 'view', 'maintenance-trx', 1),
2281('/master-customer-profile/*', '*', 'master-customer-profile', 1),
2282('/master-customer-profile/create', 'create', 'master-customer-profile', 1),
2283('/master-customer-profile/delete', 'delete', 'master-customer-profile', 1),
2284('/master-customer-profile/index', 'index', 'master-customer-profile', 1),
2285('/master-customer-profile/update', 'update', 'master-customer-profile', 1),
2286('/master-customer-profile/view', 'view', 'master-customer-profile', 1),
2287('/master-customer-profile/view-administrator', 'view-administrator', 'master-customer-profile', 1),
2288('/master-customer/*', '*', 'master-customer', 1),
2289('/master-customer/create', 'create', 'master-customer', 1),
2290('/master-customer/delete', 'delete', 'master-customer', 1),
2291('/master-customer/index', 'index', 'master-customer', 1),
2292('/master-customer/index-administrator', 'index-administrator', 'master-customer', 1),
2293('/master-customer/update', 'update', 'master-customer', 1),
2294('/master-customer/view', 'view', 'master-customer', 1),
2295('/master-vehicle/*', '*', 'master-vehicle', 1),
2296('/master-vehicle/ajax-suggest-area', 'ajax-suggest-area', 'master-vehicle', 1),
2297('/master-vehicle/avatar-delete', 'avatar-delete', 'master-vehicle', 1),
2298('/master-vehicle/avatar-upload', 'avatar-upload', 'master-vehicle', 1),
2299('/master-vehicle/brand-list', 'brand-list', 'master-vehicle', 1),
2300('/master-vehicle/capacity', 'capacity', 'master-vehicle', 1),
2301('/master-vehicle/car', 'car', 'master-vehicle', 1),
2302('/master-vehicle/create', 'create', 'master-vehicle', 1),
2303('/master-vehicle/delete', 'delete', 'master-vehicle', 1),
2304('/master-vehicle/index', 'index', 'master-vehicle', 1),
2305('/master-vehicle/map', 'map', 'master-vehicle', 1),
2306('/master-vehicle/price-list', 'price-list', 'master-vehicle', 1),
2307('/master-vehicle/update', 'update', 'master-vehicle', 1),
2308('/master-vehicle/vehicle-list', 'vehicle-list', 'master-vehicle', 1),
2309('/master-vehicle/view', 'view', 'master-vehicle', 1),
2310('/master-vehicle/view-admin', 'view-admin', 'master-vehicle', 1),
2311('/mimin/*', '*', 'mimin', 1),
2312('/mimin/role/*', '*', 'mimin/role', 1),
2313('/mimin/role/create', 'create', 'mimin/role', 1),
2314('/mimin/role/delete', 'delete', 'mimin/role', 1),
2315('/mimin/role/index', 'index', 'mimin/role', 1),
2316('/mimin/role/permission', 'permission', 'mimin/role', 1),
2317('/mimin/role/update', 'update', 'mimin/role', 1),
2318('/mimin/role/view', 'view', 'mimin/role', 1),
2319('/mimin/route/*', '*', 'mimin/route', 1),
2320('/mimin/route/create', 'create', 'mimin/route', 1),
2321('/mimin/route/delete', 'delete', 'mimin/route', 1),
2322('/mimin/route/generate', 'generate', 'mimin/route', 1),
2323('/mimin/route/index', 'index', 'mimin/route', 1),
2324('/mimin/route/update', 'update', 'mimin/route', 1),
2325('/mimin/route/view', 'view', 'mimin/route', 1),
2326('/mimin/user/*', '*', 'mimin/user', 1),
2327('/mimin/user/create', 'create', 'mimin/user', 1),
2328('/mimin/user/delete', 'delete', 'mimin/user', 1),
2329('/mimin/user/index', 'index', 'mimin/user', 1),
2330('/mimin/user/update', 'update', 'mimin/user', 1),
2331('/mimin/user/view', 'view', 'mimin/user', 1),
2332('/notification/*', '*', 'notification', 1),
2333('/notification/index', 'index', 'notification', 1),
2334('/notification/index-administrator', 'index-administrator', 'notification', 1),
2335('/offering-service/*', '*', 'offering-service', 1),
2336('/offering-service/ajax-price', 'ajax-price', 'offering-service', 1),
2337('/offering-service/booking', 'booking', 'offering-service', 1),
2338('/offering-service/create', 'create', 'offering-service', 1),
2339('/offering-service/delete', 'delete', 'offering-service', 1),
2340('/offering-service/index', 'index', 'offering-service', 1),
2341('/offering-service/submit-price', 'submit-price', 'offering-service', 1),
2342('/offering-service/update', 'update', 'offering-service', 1),
2343('/offering-service/view', 'view', 'offering-service', 1),
2344('/operation-cost/*', '*', 'operation-cost', 1),
2345('/operation-cost/create', 'create', 'operation-cost', 1),
2346('/operation-cost/delete', 'delete', 'operation-cost', 1),
2347('/operation-cost/index', 'index', 'operation-cost', 1),
2348('/operation-cost/update', 'update', 'operation-cost', 1),
2349('/operation-cost/view', 'view', 'operation-cost', 1),
2350('/opportunities/*', '*', 'opportunities', 1),
2351('/opportunities/create', 'create', 'opportunities', 1),
2352('/opportunities/delete', 'delete', 'opportunities', 1),
2353('/opportunities/index', 'index', 'opportunities', 1),
2354('/opportunities/update', 'update', 'opportunities', 1),
2355('/opportunities/view', 'view', 'opportunities', 1),
2356('/opportunities/view-administrator', 'view-administrator', 'opportunities', 1),
2357('/order/*', '*', 'order', 1),
2358('/order/ajax-operational-cost', 'ajax-operational-cost', 'order', 1),
2359('/order/book-ajax-field', 'book-ajax-field', 'order', 1),
2360('/order/clear-session-operational', 'clear-session-operational', 'order', 1),
2361('/order/create', 'create', 'order', 1),
2362('/order/create-driver', 'create-driver', 'order', 1),
2363('/order/delete', 'delete', 'order', 1),
2364('/order/driver-ajax-field', 'driver-ajax-field', 'order', 1),
2365('/order/index', 'index', 'order', 1),
2366('/order/order-ajax-field', 'order-ajax-field', 'order', 1),
2367('/order/price-list-ajax', 'price-list-ajax', 'order', 1),
2368('/order/submit-price', 'submit-price', 'order', 1),
2369('/order/update', 'update', 'order', 1),
2370('/order/view', 'view', 'order', 1),
2371('/page/*', '*', 'page', 1),
2372('/page/create', 'create', 'page', 1),
2373('/page/delete', 'delete', 'page', 1),
2374('/page/index', 'index', 'page', 1),
2375('/page/update', 'update', 'page', 1),
2376('/page/view', 'view', 'page', 1),
2377('/payment/*', '*', 'payment', 1),
2378('/payment/ajax-invoice-data', 'ajax-invoice-data', 'payment', 1),
2379('/payment/create', 'create', 'payment', 1),
2380('/payment/delete', 'delete', 'payment', 1),
2381('/payment/index', 'index', 'payment', 1),
2382('/payment/update', 'update', 'payment', 1),
2383('/payment/view', 'view', 'payment', 1),
2384('/price-list/*', '*', 'price-list', 1),
2385('/price-list/create', 'create', 'price-list', 1),
2386('/price-list/delete', 'delete', 'price-list', 1),
2387('/price-list/index', 'index', 'price-list', 1),
2388('/price-list/unit-price-ritase', 'unit-price-ritase', 'price-list', 1),
2389('/price-list/update', 'update', 'price-list', 1),
2390('/price-list/view', 'view', 'price-list', 1),
2391('/service-area/*', '*', 'service-area', 1),
2392('/service-area/create', 'create', 'service-area', 1),
2393('/service-area/delete', 'delete', 'service-area', 1),
2394('/service-area/index', 'index', 'service-area', 1),
2395('/service-area/update', 'update', 'service-area', 1),
2396('/service-area/view', 'view', 'service-area', 1),
2397('/sign-in/*', '*', 'sign-in', 1),
2398('/sign-in/account', 'account', 'sign-in', 1),
2399('/sign-in/avatar-delete', 'avatar-delete', 'sign-in', 1),
2400('/sign-in/avatar-upload', 'avatar-upload', 'sign-in', 1),
2401('/sign-in/login', 'login', 'sign-in', 1),
2402('/sign-in/logout', 'logout', 'sign-in', 1),
2403('/sign-in/profile', 'profile', 'sign-in', 1),
2404('/sign-in/view', 'view', 'sign-in', 1),
2405('/site/*', '*', 'site', 1),
2406('/site/ajax-suggest-area', 'ajax-suggest-area', 'site', 1),
2407('/site/available-vehicle', 'available-vehicle', 'site', 1),
2408('/site/book', 'book', 'site', 1),
2409('/site/captcha', 'captcha', 'site', 1),
2410('/site/contact', 'contact', 'site', 1),
2411('/site/error', 'error', 'site', 1),
2412('/site/fahrul', 'fahrul', 'site', 1),
2413('/site/index', 'index', 'site', 1),
2414('/site/set-locale', 'set-locale', 'site', 1),
2415('/site/settings', 'settings', 'site', 1),
2416('/site/share', 'share', 'site', 1),
2417('/site/test', 'test', 'site', 1),
2418('/site/track', 'track', 'site', 1),
2419('/subscribe/*', '*', 'subscribe', 1),
2420('/subscribe/create', 'create', 'subscribe', 1),
2421('/subscribe/delete', 'delete', 'subscribe', 1),
2422('/subscribe/index', 'index', 'subscribe', 1),
2423('/subscribe/update', 'update', 'subscribe', 1),
2424('/subscribe/view', 'view', 'subscribe', 1),
2425('/system-information/*', '*', 'system-information', 1),
2426('/system-information/index', 'index', 'system-information', 1),
2427('/timeline-event/*', '*', 'timeline-event', 1),
2428('/timeline-event/index', 'index', 'timeline-event', 1),
2429('/timeline-event/index-administrator', 'index-administrator', 'timeline-event', 1),
2430('/track/*', '*', 'track', 1),
2431('/track/index', 'index', 'track', 1),
2432('/tracking/*', '*', 'tracking', 1),
2433('/tracking/index', 'index', 'tracking', 1),
2434('/user/*', '*', 'user', 1),
2435('/user/create', 'create', 'user', 1),
2436('/user/default/*', '*', 'user/default', 1),
2437('/user/default/account', 'account', 'user/default', 1),
2438('/user/default/avatar-delete', 'avatar-delete', 'user/default', 1),
2439('/user/default/avatar-upload', 'avatar-upload', 'user/default', 1),
2440('/user/default/index', 'index', 'user/default', 1),
2441('/user/default/index-customer', 'index-customer', 'user/default', 1),
2442('/user/default/index-owner', 'index-owner', 'user/default', 1),
2443('/user/default/profile', 'profile', 'user/default', 1),
2444('/user/delete', 'delete', 'user', 1),
2445('/user/index', 'index', 'user', 1),
2446('/user/sign-in/*', '*', 'user/sign-in', 1),
2447('/user/sign-in/avatar-delete', 'avatar-delete', 'user/sign-in', 1),
2448('/user/sign-in/avatar-upload', 'avatar-upload', 'user/sign-in', 1),
2449('/user/sign-in/confirm', 'confirm', 'user/sign-in', 1),
2450('/user/sign-in/index', 'index', 'user/sign-in', 1),
2451('/user/sign-in/login', 'login', 'user/sign-in', 1),
2452('/user/sign-in/logout', 'logout', 'user/sign-in', 1),
2453('/user/sign-in/oauth', 'oauth', 'user/sign-in', 1),
2454('/user/sign-in/request-password-reset', 'request-password-reset', 'user/sign-in', 1),
2455('/user/sign-in/reset-password', 'reset-password', 'user/sign-in', 1),
2456('/user/sign-in/signup', 'signup', 'user/sign-in', 1),
2457('/user/sign-in/update-profile', 'update-profile', 'user/sign-in', 1),
2458('/user/update', 'update', 'user', 1),
2459('/user/view', 'view', 'user', 1),
2460('/veboo-event/*', '*', 'veboo-event', 1),
2461('/veboo-event/index', 'index', 'veboo-event', 1),
2462('/warehouse/*', '*', 'warehouse', 1),
2463('/warehouse/create', 'create', 'warehouse', 1),
2464('/warehouse/delete', 'delete', 'warehouse', 1),
2465('/warehouse/index', 'index', 'warehouse', 1),
2466('/warehouse/update', 'update', 'warehouse', 1),
2467('/warehouse/view', 'view', 'warehouse', 1),
2468('/widget-carousel-item/*', '*', 'widget-carousel-item', 1),
2469('/widget-carousel-item/create', 'create', 'widget-carousel-item', 1),
2470('/widget-carousel-item/delete', 'delete', 'widget-carousel-item', 1),
2471('/widget-carousel-item/update', 'update', 'widget-carousel-item', 1),
2472('/widget-carousel/*', '*', 'widget-carousel', 1),
2473('/widget-carousel/create', 'create', 'widget-carousel', 1),
2474('/widget-carousel/delete', 'delete', 'widget-carousel', 1),
2475('/widget-carousel/index', 'index', 'widget-carousel', 1),
2476('/widget-carousel/update', 'update', 'widget-carousel', 1),
2477('/widget-menu/*', '*', 'widget-menu', 1),
2478('/widget-menu/create', 'create', 'widget-menu', 1),
2479('/widget-menu/delete', 'delete', 'widget-menu', 1),
2480('/widget-menu/index', 'index', 'widget-menu', 1),
2481('/widget-menu/update', 'update', 'widget-menu', 1),
2482('/widget-text/*', '*', 'widget-text', 1),
2483('/widget-text/create', 'create', 'widget-text', 1),
2484('/widget-text/delete', 'delete', 'widget-text', 1),
2485('/widget-text/index', 'index', 'widget-text', 1),
2486('/widget-text/update', 'update', 'widget-text', 1);
2487
2488-- --------------------------------------------------------
2489
2490--
2491-- Table structure for table `service_area`
2492--
2493
2494CREATE TABLE IF NOT EXISTS `service_area` (
2495 `service_area_id` int(11) NOT NULL AUTO_INCREMENT,
2496 `user_id` int(11) DEFAULT NULL,
2497 `area_name` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
2498 `attributes_1` int(30) DEFAULT NULL,
2499 `attributes_2` int(30) DEFAULT NULL,
2500 `attributes_3` int(30) DEFAULT NULL,
2501 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2502 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2503 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2504 PRIMARY KEY (`service_area_id`),
2505 KEY `FK_FK_U_SA` (`user_id`)
2506) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
2507
2508--
2509-- Dumping data for table `service_area`
2510--
2511
2512INSERT INTO `service_area` (`service_area_id`, `user_id`, `area_name`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
2513(1, 91, '374', NULL, NULL, NULL, NULL, NULL, NULL),
2514(2, 91, '372', NULL, NULL, NULL, NULL, NULL, NULL),
2515(3, 91, '375', NULL, NULL, NULL, NULL, NULL, NULL),
2516(4, 91, '371', NULL, NULL, NULL, NULL, NULL, NULL),
2517(5, 91, '373', NULL, NULL, NULL, NULL, NULL, NULL),
2518(6, 1, '65', NULL, NULL, NULL, NULL, NULL, NULL),
2519(7, 92, '9', NULL, NULL, NULL, NULL, NULL, NULL),
2520(8, 96, '14', NULL, NULL, NULL, NULL, NULL, NULL);
2521
2522-- --------------------------------------------------------
2523
2524--
2525-- Table structure for table `subscribe`
2526--
2527
2528CREATE TABLE IF NOT EXISTS `subscribe` (
2529 `subscribe_id` int(11) NOT NULL AUTO_INCREMENT,
2530 `user_id` int(11) DEFAULT NULL,
2531 `types` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
2532 `start_date` int(11) DEFAULT NULL,
2533 `end_date` int(11) DEFAULT NULL,
2534 `subscribe_status` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
2535 `attributes_1` int(30) DEFAULT NULL,
2536 `attributes_2` int(30) DEFAULT NULL,
2537 `attributes_3` int(30) DEFAULT NULL,
2538 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2539 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2540 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
2541 PRIMARY KEY (`subscribe_id`),
2542 KEY `FK_FK_S_U` (`user_id`)
2543) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2544
2545-- --------------------------------------------------------
2546
2547--
2548-- Table structure for table `system_db_migration`
2549--
2550
2551CREATE TABLE IF NOT EXISTS `system_db_migration` (
2552 `version` varchar(180) CHARACTER SET latin1 NOT NULL,
2553 `apply_time` int(11) DEFAULT NULL,
2554 PRIMARY KEY (`version`)
2555) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2556
2557--
2558-- Dumping data for table `system_db_migration`
2559--
2560
2561INSERT INTO `system_db_migration` (`version`, `apply_time`) VALUES
2562('m151024_072453_create_route_table', 1454067033);
2563
2564-- --------------------------------------------------------
2565
2566--
2567-- Table structure for table `system_log`
2568--
2569
2570CREATE TABLE IF NOT EXISTS `system_log` (
2571 `id` bigint(20) NOT NULL AUTO_INCREMENT,
2572 `level` int(11) DEFAULT NULL,
2573 `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
2574 `log_time` double DEFAULT NULL,
2575 `prefix` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
2576 `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
2577 PRIMARY KEY (`id`),
2578 KEY `idx_log_level` (`level`),
2579 KEY `idx_log_category` (`category`)
2580) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=34827 ;
2581
2582--
2583-- Dumping data for table `system_log`
2584--
2585
2586INSERT INTO `system_log` (`id`, `level`, `category`, `log_time`, `prefix`, `message`) VALUES
2587(34822, 2, 'yii\\web\\Session::init', 1456373118.8498, '[backend][/veboo/backend/log/index.aspx]', 'Session is already started'),
2588(34823, 2, 'yii\\web\\Session::init', 1456373119.0586, '[backend][/veboo/backend/log/index.aspx]', 'Session is already started'),
2589(34824, 2, 'yii\\web\\Session::init', 1456373331.8623, '[backend][/veboo/backend/sign-in/logout.aspx]', 'Session is already started'),
2590(34825, 2, 'yii\\web\\Session::init', 1456373332.1256, '[frontend][/veboo/]', 'Session is already started'),
2591(34826, 2, 'yii\\web\\Session::init', 1456373623.7933, '[frontend][/veboo/]', 'Session is already started');
2592
2593-- --------------------------------------------------------
2594
2595--
2596-- Table structure for table `system_rbac_migration`
2597--
2598
2599CREATE TABLE IF NOT EXISTS `system_rbac_migration` (
2600 `version` varchar(180) CHARACTER SET latin1 NOT NULL,
2601 `apply_time` int(11) DEFAULT NULL,
2602 PRIMARY KEY (`version`)
2603) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2604
2605--
2606-- Dumping data for table `system_rbac_migration`
2607--
2608
2609INSERT INTO `system_rbac_migration` (`version`, `apply_time`) VALUES
2610('m000000_000000_base', 1441038957),
2611('m150625_214101_roles', 1441038963),
2612('m150625_215624_init_permissions', 1441038963);
2613
2614-- --------------------------------------------------------
2615
2616--
2617-- Table structure for table `tbl_attributes`
2618--
2619
2620CREATE TABLE IF NOT EXISTS `tbl_attributes` (
2621 `id` int(11) NOT NULL AUTO_INCREMENT,
2622 `parent` int(11) NOT NULL,
2623 `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
2624 `content` text COLLATE utf8_unicode_ci NOT NULL,
2625 `code` smallint(6) NOT NULL,
2626 `type` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
2627 `position` smallint(6) NOT NULL,
2628 PRIMARY KEY (`id`)
2629) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=99 ;
2630
2631--
2632-- Dumping data for table `tbl_attributes`
2633--
2634
2635INSERT INTO `tbl_attributes` (`id`, `parent`, `name`, `content`, `code`, `type`, `position`) VALUES
2636(1, 0, 'Unit Price', '', 0, 'UNIT_PRICE', 0),
2637(2, 1, 'Day', '', 1, 'UNIT_PRICE', 1),
2638(3, 1, 'Week', '', 2, 'UNIT_PRICE', 2),
2639(4, 1, 'Month', '', 3, 'UNIT_PRICE', 3),
2640(6, 1, 'Ritase', '', 5, 'UNIT_PRICE', 5),
2641(7, 1, 'Trip', '', 6, 'UNIT_PRICE', 6),
2642(8, 1, 'Per CBM', '', 7, 'UNIT_PRICE', 7),
2643(9, 1, 'Per KM', '', 8, 'UNIT_PRICE', 8),
2644(10, 1, 'Lumpsump', '', 9, 'UNIT_PRICE', 9),
2645(5, 1, 'Year', '', 4, 'UNIT_PRICE', 4),
2646(11, 1, 'MT (Metric Ton)', '', 10, 'UNIT_PRICE', 10),
2647(12, 1, 'Per M2', '', 11, 'UNIT_PRICE', 11),
2648(13, 0, 'Vehicle Type', '', 0, 'vehicle_type', 0),
2649(14, 13, 'Passenger Car', '', 1, 'vehicle_type', 1),
2650(15, 13, 'CDE', '', 2, 'vehicle_type', 2),
2651(16, 13, 'CDD', '', 3, 'vehicle_type', 3),
2652(17, 13, 'Container', '', 4, 'vehicle_type', 4),
2653(18, 13, 'Wing Box', '', 5, 'vehicle_type', 5),
2654(19, 13, 'Dump Truck', '', 6, 'vehicle_type', 6),
2655(20, 13, 'Lowbed', '', 7, 'vehicle_type', 7),
2656(21, 13, 'Fuso', '', 8, 'vehicle_type', 8),
2657(22, 13, 'Bus', '', 9, 'vehicle_type', 9),
2658(23, 13, 'Vessel', '', 10, 'vehicle_type', 10),
2659(24, 13, 'Motor Bike', '', 11, 'vehicle_type', 11),
2660(25, 13, 'Blind Van', '', 12, 'vehicle_type', 12),
2661(26, 0, 'Vehicle Brand', '', 0, 'brand', 0),
2662(27, 26, 'Mitsubishi', '', 1, 'brand', 1),
2663(52, 0, 'Vehicle Transmission', '', 0, 'transmission', 0),
2664(29, 26, 'Isuzu', '', 2, 'brand', 2),
2665(30, 26, 'Hino', '', 3, 'brand', 3),
2666(31, 26, 'Toyota', '', 4, 'brand', 4),
2667(32, 26, 'Volvo', '', 5, 'brand', 5),
2668(33, 26, 'Scania', '', 6, 'brand', 6),
2669(34, 26, 'Mercedez', '', 7, 'brand', 7),
2670(35, 26, 'UD', '', 8, 'brand', 8),
2671(36, 26, 'Suzuki', '', 9, 'brand', 9),
2672(37, 26, 'Harlay', '', 10, 'brand', 10),
2673(38, 26, 'Kawasaki', '', 11, 'brand', 11),
2674(39, 26, 'Honda', '', 12, 'brand', 12),
2675(40, 26, 'Suzuki', '', 13, 'brand', 13),
2676(42, 26, 'Daihatsu', '', 14, 'brand', 14),
2677(43, 0, 'Vehicle Capacity', '', 0, 'capacity', 0),
2678(44, 43, '5 Seat', '', 1, 'capacity', 1),
2679(45, 43, '7 - 8 Seat', '', 2, 'capacity', 2),
2680(46, 43, '32 Seat', '', 3, 'capacity', 3),
2681(47, 43, '52 Seat', '', 4, 'capacity', 4),
2682(48, 43, '7 Ton', '', 5, 'capacity', 5),
2683(49, 43, '15 Ton', '', 6, 'capacity', 6),
2684(50, 43, '20 Ton', '', 7, 'capacity', 7),
2685(51, 43, '> 25 Ton', '', 8, 'capacity', 8),
2686(53, 52, 'Manual', '', 1, 'transmission', 1),
2687(54, 52, 'Automatic', '', 2, 'transmission', 2),
2688(61, 0, 'Religion', '', 0, 'religion', 0),
2689(55, 0, 'Vehicle Tracking', '', 0, 'tracking', 0),
2690(56, 55, 'No', '', 1, 'tracking', 1),
2691(57, 55, 'Yes', '', 2, 'tracking', 2),
2692(58, 0, 'Vehicle Share', '', 0, 'share_status', 0),
2693(59, 58, 'No', '', 1, 'share_status', 1),
2694(60, 58, 'Yes', '', 2, 'share_status', 2),
2695(62, 61, 'Islam', '', 1, 'religion', 1),
2696(63, 61, 'Kristen Protestan', '', 2, 'religion', 2),
2697(64, 61, 'Katolik', '', 3, 'religion', 3),
2698(65, 61, 'Hindu', '', 4, 'religion', 4),
2699(66, 61, 'Budha', '', 5, 'religion', 5),
2700(67, 61, 'Kong Hu Cu', '', 6, 'religion', 6),
2701(68, 0, 'Opportunity Status', '', 0, 'opportunity_status', 0),
2702(69, 68, 'Open', '', 1, 'opportunity_status', 1),
2703(70, 68, 'Close', '', 2, 'opportunity_status', 2),
2704(71, 0, 'Status Profile', '', 0, 'status_profile', 0),
2705(72, 71, 'Single', '', 1, 'status_profile', 1),
2706(73, 71, 'Married', '', 2, 'status_profile', 2),
2707(74, 71, 'Doubt / Widow', '', 3, 'status_profile', 3),
2708(75, 0, 'Experience', '', 0, 'experience', 0),
2709(76, 75, 'Newbie', '', 1, 'experience', 1),
2710(77, 75, '1 Year', '', 2, 'experience', 2),
2711(78, 75, '2 Year', '', 3, 'experience', 3),
2712(79, 75, '3 Year', '', 4, 'experience', 4),
2713(80, 75, '4 Year', '', 5, 'experience', 5),
2714(81, 75, 'More Than 4 Year', '', 6, 'experience', 6),
2715(82, 43, '14 CBM', '', 9, 'capacity', 9),
2716(83, 43, '15 CBM', '', 10, 'capacity', 10),
2717(84, 43, '19 CBM', '', 11, 'capacity', 11),
2718(85, 43, '20 CBM', '', 12, 'capacity', 12),
2719(86, 43, '28 CBM', '', 13, 'capacity', 13),
2720(87, 43, '40 CBM', '', 14, 'capacity', 14),
2721(88, 0, 'Gender', '', 0, 'gender', 0),
2722(89, 88, 'Male', '', 1, 'gender', 1),
2723(90, 88, 'Female', '', 2, 'gender', 2),
2724(91, 0, 'Payment Method', '', 0, 'payment_method', 0),
2725(92, 91, 'Cash', '', 1, 'payment_method', 1),
2726(93, 91, 'Credit Card', '', 2, 'payment_method', 2),
2727(94, 91, 'Transfer', '', 3, 'payment_method', 3),
2728(95, 0, 'Invoice Status', '', 0, 'invoice_status', 0),
2729(96, 95, 'New', '', 1, 'invoice_status', 1),
2730(97, 95, 'Partial', '', 2, 'invoice_status', 2),
2731(98, 95, 'Settled', '', 3, 'invoice_status', 3);
2732
2733-- --------------------------------------------------------
2734
2735--
2736-- Table structure for table `tbl_city`
2737--
2738
2739CREATE TABLE IF NOT EXISTS `tbl_city` (
2740 `id` int(11) NOT NULL AUTO_INCREMENT,
2741 `name` varchar(60) NOT NULL,
2742 `status` char(1) NOT NULL DEFAULT 'A',
2743 `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
2744 `date_modified` timestamp NULL DEFAULT NULL,
2745 `province_id` int(11) NOT NULL,
2746 PRIMARY KEY (`id`)
2747) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=466 ;
2748
2749--
2750-- Dumping data for table `tbl_city`
2751--
2752
2753INSERT INTO `tbl_city` (`id`, `name`, `status`, `date_created`, `date_modified`, `province_id`) VALUES
2754(0, '-', 'A', '2015-11-25 01:16:20', '2015-11-25 01:16:20', 0),
2755(5, 'KAB. SITUBONDO', 'A', '2011-06-29 21:26:23', NULL, 13),
2756(6, 'KAB. ACEH BARAT', 'A', '2011-06-29 21:26:23', NULL, 3),
2757(7, 'KAB. ACEH BARAT DAYA', 'A', '2011-06-29 21:26:23', NULL, 3),
2758(8, 'KAB. ACEH BESAR', 'A', '2011-06-29 21:26:23', NULL, 3),
2759(9, 'KAB. ACEH JAYA', 'A', '2011-06-29 21:26:23', NULL, 3),
2760(10, 'KAB. ACEH SELATAN', 'A', '2011-06-29 21:26:23', NULL, 3),
2761(11, 'KAB. ACEH SINGKIL', 'A', '2011-06-29 21:26:23', NULL, 3),
2762(12, 'KAB. ACEH TAMIANG', 'A', '2011-06-29 21:26:23', NULL, 3),
2763(13, 'KAB. ACEH TENGAH', 'A', '2011-06-29 21:26:23', NULL, 3),
2764(14, 'KAB. ACEH TENGGARA', 'A', '2011-06-29 21:26:23', NULL, 3),
2765(15, 'KAB. ACEH TIMUR', 'A', '2011-06-29 21:26:23', NULL, 3),
2766(16, 'KAB. ACEH UTARA', 'A', '2011-06-29 21:26:23', NULL, 3),
2767(17, 'KAB. AGAM', 'A', '2011-06-29 21:26:23', NULL, 32),
2768(18, 'KAB. ALOR', 'A', '2011-06-29 21:26:23', NULL, 23),
2769(19, 'KAB. ASAHAN', 'A', '2011-06-29 21:26:23', NULL, 34),
2770(20, 'KAB. ASMAT', 'A', '2011-06-29 21:26:23', NULL, 24),
2771(21, 'KAB. BADUNG', 'A', '2011-06-29 21:26:23', NULL, 4),
2772(22, 'KAB. BALANGAN', 'A', '2011-06-29 21:26:23', NULL, 15),
2773(23, 'KAB. BANDUNG', 'A', '2011-06-29 21:26:23', NULL, 11),
2774(24, 'KAB. BANDUNG BARAT', 'A', '2011-06-29 21:26:23', NULL, 11),
2775(25, 'KAB. BANGGAI', 'A', '2011-06-29 21:26:23', NULL, 29),
2776(26, 'KAB. BANGGAI KEPULAUAN', 'A', '2011-06-29 21:26:23', NULL, 29),
2777(27, 'KAB. BANGKA', 'A', '2011-06-29 21:26:23', NULL, 18),
2778(28, 'KAB. BANGKA BARAT', 'A', '2011-06-29 21:26:23', NULL, 18),
2779(29, 'KAB. BANGKA SELATAN', 'A', '2011-06-29 21:26:23', NULL, 18),
2780(30, 'KAB. BANGKA TENGAH', 'A', '2011-06-29 21:26:23', NULL, 18),
2781(31, 'KAB. BANGKALAN', 'A', '2011-06-29 21:26:23', NULL, 13),
2782(32, 'KAB. BANGLI', 'A', '2011-06-29 21:26:23', NULL, 4),
2783(33, 'KAB. BANJAR', 'A', '2011-06-29 21:26:23', NULL, 15),
2784(34, 'KAB. BANJARNEGARA', 'A', '2011-06-29 21:26:23', NULL, 12),
2785(35, 'KAB. BANTAENG', 'A', '2011-06-29 21:26:23', NULL, 28),
2786(36, 'KAB. BANTUL', 'A', '2011-06-29 21:26:23', NULL, 7),
2787(37, 'KAB. BANYUASIN', 'A', '2011-06-29 21:26:23', NULL, 33),
2788(38, 'KAB. BANYUMAS', 'A', '2011-06-29 21:26:23', NULL, 12),
2789(39, 'KAB. BANYUWANGI', 'A', '2011-06-29 21:26:23', NULL, 13),
2790(40, 'KAB. BARITO KUALA', 'A', '2011-06-29 21:26:23', NULL, 15),
2791(41, 'KAB. BARITO SELATAN', 'A', '2011-06-29 21:26:23', NULL, 16),
2792(42, 'KAB. BARITO TIMUR', 'A', '2011-06-29 21:26:23', NULL, 16),
2793(43, 'KAB. BARITO UTARA', 'A', '2011-06-29 21:26:23', NULL, 16),
2794(44, 'KAB. BARRU', 'A', '2011-06-29 21:26:23', NULL, 28),
2795(45, 'KAB. BATANG', 'A', '2011-06-29 21:26:23', NULL, 12),
2796(46, 'KAB. BATANG HARI', 'A', '2011-06-29 21:26:23', NULL, 10),
2797(47, 'KAB. BATUBARA', 'A', '2011-06-29 21:26:23', NULL, 34),
2798(48, 'KAB. BEKASI', 'A', '2011-06-29 21:26:23', NULL, 11),
2799(49, 'KAB. BELITUNG', 'A', '2011-06-29 21:26:23', NULL, 18),
2800(50, 'KAB. BELITUNG TIMUR', 'A', '2011-06-29 21:26:23', NULL, 18),
2801(51, 'KAB. BELU', 'A', '2011-06-29 21:26:23', NULL, 23),
2802(52, 'KAB. BENER MERIAH', 'A', '2011-06-29 21:26:23', NULL, 3),
2803(53, 'KAB. BENGKALIS', 'A', '2011-06-29 21:26:23', NULL, 26),
2804(54, 'KAB. BENGKAYANG', 'A', '2011-06-29 21:26:23', NULL, 14),
2805(55, 'KAB. BENGKULU SELATAN', 'A', '2011-06-29 21:26:23', NULL, 6),
2806(56, 'KAB. BENGKULU UTARA', 'A', '2011-06-29 21:26:23', NULL, 6),
2807(57, 'KAB. BERAU', 'A', '2011-06-29 21:26:23', NULL, 17),
2808(58, 'KAB. BIAK NUMFOR', 'A', '2011-06-29 21:26:23', NULL, 24),
2809(59, 'KAB. BIMA', 'A', '2011-06-29 21:26:23', NULL, 22),
2810(60, 'KAB. BINTAN', 'A', '2011-06-29 21:26:23', NULL, 18),
2811(61, 'KAB. BIREUEN', 'A', '2011-06-29 21:26:23', NULL, 3),
2812(62, 'KAB. BLITAR', 'A', '2011-06-29 21:26:23', NULL, 13),
2813(63, 'KAB. BLORA', 'A', '2011-06-29 21:26:23', NULL, 12),
2814(64, 'KAB. BOALEMO', 'A', '2011-06-29 21:26:23', NULL, 8),
2815(65, 'KAB. BOGOR', 'A', '2011-06-29 21:26:23', NULL, 11),
2816(66, 'KAB. BOJONEGORO', 'A', '2011-06-29 21:26:23', NULL, 13),
2817(67, 'KAB. BOLAANG MONGONDOW', 'A', '2011-06-29 21:26:23', NULL, 31),
2818(68, 'KAB. BOLAANG MONGONDOW UTARA', 'A', '2011-06-29 21:26:23', NULL, 31),
2819(69, 'KAB. BOMBANA', 'A', '2011-06-29 21:26:23', NULL, 30),
2820(70, 'KAB. BONDOWOSO', 'A', '2011-06-29 21:26:23', NULL, 13),
2821(71, 'KAB. BONE', 'A', '2011-06-29 21:26:23', NULL, 28),
2822(72, 'KAB. BOVEN DIGOEL', 'A', '2011-06-29 21:26:23', NULL, 24),
2823(73, 'KAB. BOYOLALI', 'A', '2011-06-29 21:26:23', NULL, 12),
2824(74, 'KAB. BREBES', 'A', '2011-06-29 21:26:23', NULL, 12),
2825(75, 'KAB. BULELENG', 'A', '2011-06-29 21:26:23', NULL, 4),
2826(76, 'KAB. BULUKUMBA', 'A', '2011-06-29 21:26:23', NULL, 28),
2827(77, 'KAB. BULUNGAN', 'A', '2011-06-29 21:26:23', NULL, 17),
2828(78, 'KAB. BUNGO', 'A', '2011-06-29 21:26:23', NULL, 10),
2829(79, 'KAB. BUOL', 'A', '2011-06-29 21:26:23', NULL, 29),
2830(80, 'KAB. BURU', 'A', '2011-06-29 21:26:23', NULL, 20),
2831(81, 'KAB. BUTON & BUTON UTARA', 'A', '2011-06-29 21:26:23', NULL, 30),
2832(82, 'KAB. CIANJUR', 'A', '2011-06-29 21:26:23', NULL, 11),
2833(83, 'KAB. CILACAP', 'A', '2011-06-29 21:26:23', NULL, 12),
2834(84, 'KAB. CIREBON', 'A', '2011-06-29 21:26:23', NULL, 11),
2835(85, 'KAB. DAIRI', 'A', '2011-06-29 21:26:23', NULL, 34),
2836(86, 'KAB. DELI SERDANG', 'A', '2011-06-29 21:26:23', NULL, 34),
2837(87, 'KAB. DEMAK', 'A', '2011-06-29 21:26:23', NULL, 12),
2838(88, 'KAB. DHARMASRAYA', 'A', '2011-06-29 21:26:23', NULL, 32),
2839(89, 'KAB. DOMPU', 'A', '2011-06-29 21:26:23', NULL, 22),
2840(90, 'KAB. DONGGALA', 'A', '2011-06-29 21:26:23', NULL, 29),
2841(91, 'KAB. EMPAT LAWANG', 'A', '2011-06-29 21:26:23', NULL, 33),
2842(92, 'KAB. ENDE', 'A', '2011-06-29 21:26:23', NULL, 23),
2843(93, 'KAB. ENREKANG', 'A', '2011-06-29 21:26:23', NULL, 28),
2844(94, 'KAB. FAK-FAK', 'A', '2011-06-29 21:26:23', NULL, 25),
2845(95, 'KAB. FLORES TIMUR', 'A', '2011-06-29 21:26:23', NULL, 23),
2846(96, 'KAB. GARUT', 'A', '2011-06-29 21:26:23', NULL, 11),
2847(97, 'KAB. GAYO LUES', 'A', '2011-06-29 21:26:23', NULL, 3),
2848(98, 'KAB. GIANYAR', 'A', '2011-06-29 21:26:23', NULL, 4),
2849(99, 'KAB. GOA', 'A', '2011-06-29 21:26:23', NULL, 28),
2850(100, 'KAB. GORONTALO', 'A', '2011-06-29 21:26:23', NULL, 8),
2851(101, 'KAB. GORONTALO UTARA', 'A', '2011-06-29 21:26:23', NULL, 8),
2852(102, 'KAB. GROBOGAN', 'A', '2011-06-29 21:26:23', NULL, 12),
2853(103, 'KAB. GUNUNG KIDUL', 'A', '2011-06-29 21:26:23', NULL, 7),
2854(104, 'KAB. GUNUNG MAS', 'A', '2011-06-29 21:26:23', NULL, 16),
2855(105, 'KAB. HALMAHERA BARAT', 'A', '2011-06-29 21:26:23', NULL, 21),
2856(106, 'KAB. HALMAHERA SELATAN', 'A', '2011-06-29 21:26:23', NULL, 21),
2857(107, 'KAB. HALMAHERA TENGAH', 'A', '2011-06-29 21:26:23', NULL, 21),
2858(108, 'KAB. HALMAHERA TIMUR', 'A', '2011-06-29 21:26:23', NULL, 21),
2859(109, 'KAB. HALMAHERA UTARA', 'A', '2011-06-29 21:26:23', NULL, 21),
2860(110, 'KAB. HULU SUNGAI SELATAN', 'A', '2011-06-29 21:26:23', NULL, 15),
2861(111, 'KAB. HULU SUNGAI TENGAH', 'A', '2011-06-29 21:26:23', NULL, 15),
2862(112, 'KAB. HULU SUNGAI UTARA', 'A', '2011-06-29 21:26:23', NULL, 15),
2863(113, 'KAB. HUMBANG HASUDUTAN', 'A', '2011-06-29 21:26:23', NULL, 34),
2864(114, 'KAB. INDRAGIRI HILIR', 'A', '2011-06-29 21:26:23', NULL, 26),
2865(115, 'KAB. INDRAGIRI HULU', 'A', '2011-06-29 21:26:23', NULL, 26),
2866(116, 'KAB. INDRAMAYU', 'A', '2011-06-29 21:26:23', NULL, 11),
2867(117, 'KAB. JAYAPURA', 'A', '2011-06-29 21:26:23', NULL, 24),
2868(118, 'KAB. JAYAWIJAYA', 'A', '2011-06-29 21:26:23', NULL, 24),
2869(119, 'KAB. JEMBER', 'A', '2011-06-29 21:26:23', NULL, 13),
2870(120, 'KAB. JEMBRANA', 'A', '2011-06-29 21:26:23', NULL, 4),
2871(121, 'KAB. JENEPONTO', 'A', '2011-06-29 21:26:23', NULL, 28),
2872(122, 'KAB. JEPARA', 'A', '2011-06-29 21:26:23', NULL, 12),
2873(123, 'KAB. JOMBANG', 'A', '2011-06-29 21:26:23', NULL, 13),
2874(124, 'KAB. KAIMANA', 'A', '2011-06-29 21:26:23', NULL, 25),
2875(125, 'KAB. KAMPAR', 'A', '2011-06-29 21:26:23', NULL, 26),
2876(126, 'KAB. KAPUAS', 'A', '2011-06-29 21:26:23', NULL, 16),
2877(127, 'KAB. KAPUAS HULU', 'A', '2011-06-29 21:26:23', NULL, 14),
2878(128, 'KAB. KARANG ANYAR', 'A', '2011-06-29 21:26:23', NULL, 12),
2879(129, 'KAB. KARANGASEM', 'A', '2011-06-29 21:26:23', NULL, 4),
2880(130, 'KAB. KARAWANG', 'A', '2011-06-29 21:26:23', NULL, 11),
2881(131, 'KAB. KARIMUN', 'A', '2011-06-29 21:26:23', NULL, 18),
2882(132, 'KAB. KARO', 'A', '2011-06-29 21:26:23', NULL, 34),
2883(133, 'KAB. KATINGAN', 'A', '2011-06-29 21:26:23', NULL, 16),
2884(134, 'KAB. KAUR', 'A', '2011-06-29 21:26:23', NULL, 6),
2885(135, 'KAB. KAYONG UTARA', 'A', '2011-06-29 21:26:23', NULL, 14),
2886(136, 'KAB. KEBUMEN', 'A', '2011-06-29 21:26:23', NULL, 12),
2887(137, 'KAB. KEDIRI', 'A', '2011-06-29 21:26:23', NULL, 13),
2888(138, 'KAB. KEEROM', 'A', '2011-06-29 21:26:23', NULL, 24),
2889(139, 'KAB. KENDAL', 'A', '2011-06-29 21:26:23', NULL, 12),
2890(140, 'KAB. KEPAHIANG', 'A', '2011-06-29 21:26:23', NULL, 6),
2891(141, 'KAB. KEPULAUAN ARU', 'A', '2011-06-29 21:26:23', NULL, 20),
2892(142, 'KAB. KEPULAUAN MENTAWAI', 'A', '2011-06-29 21:26:23', NULL, 32),
2893(143, 'KAB. KEPULAUAN SANGIHE', 'A', '2011-06-29 21:26:23', NULL, 31),
2894(144, 'KAB. KEPULAUAN SULA', 'A', '2011-06-29 21:26:23', NULL, 21),
2895(145, 'KAB. KEPULAUAN TALAUD', 'A', '2011-06-29 21:26:23', NULL, 31),
2896(146, 'KAB. KERINCI', 'A', '2011-06-29 21:26:23', NULL, 10),
2897(147, 'KAB. KETAPANG', 'A', '2011-06-29 21:26:23', NULL, 14),
2898(148, 'KAB. KLATEN', 'A', '2011-06-29 21:26:23', NULL, 12),
2899(149, 'KAB. KLUNGKUNG', 'A', '2011-06-29 21:26:23', NULL, 4),
2900(150, 'KAB. KOLAKA', 'A', '2011-06-29 21:26:23', NULL, 30),
2901(151, 'KAB. KOLAKA UTARA', 'A', '2011-06-29 21:26:23', NULL, 30),
2902(152, 'KAB. KONAWE', 'A', '2011-06-29 21:26:23', NULL, 30),
2903(153, 'KAB. KONAWE UTARA/ SELATAN', 'A', '2011-06-29 21:26:23', NULL, 30),
2904(154, 'KAB. KOTA BARU', 'A', '2011-06-29 21:26:23', NULL, 15),
2905(155, 'KAB. KOTA BAU-BAU', 'A', '2011-06-29 21:26:23', NULL, 30),
2906(156, 'KAB. KOTAWARINGIN BARAT', 'A', '2011-06-29 21:26:23', NULL, 16),
2907(157, 'KAB. KOTAWARINGIN TIMUR', 'A', '2011-06-29 21:26:23', NULL, 16),
2908(158, 'KAB. KUANTAN SENGINGI', 'A', '2011-06-29 21:26:23', NULL, 26),
2909(159, 'KAB. KUBU RAYA', 'A', '2011-06-29 21:26:23', NULL, 14),
2910(160, 'KAB. KUDUS', 'A', '2011-06-29 21:26:23', NULL, 12),
2911(161, 'KAB. KULON PROGO', 'A', '2011-06-29 21:26:23', NULL, 7),
2912(162, 'KAB. KUNINGAN', 'A', '2011-06-29 21:26:23', NULL, 11),
2913(163, 'KAB. KUPANG', 'A', '2011-06-29 21:26:23', NULL, 23),
2914(164, 'KAB. KUTAI BARAT', 'A', '2011-06-29 21:26:23', NULL, 17),
2915(165, 'KAB. KUTAI KARTANEGARA', 'A', '2011-06-29 21:26:23', NULL, 17),
2916(166, 'KAB. KUTAI TIMUR', 'A', '2011-06-29 21:26:23', NULL, 17),
2917(167, 'KAB. LABUHAN BATU', 'A', '2011-06-29 21:26:23', NULL, 34),
2918(168, 'KAB. LAHAT', 'A', '2011-06-29 21:26:23', NULL, 33),
2919(169, 'KAB. LAMANDAU', 'A', '2011-06-29 21:26:23', NULL, 16),
2920(170, 'KAB. LAMONGAN', 'A', '2011-06-29 21:26:23', NULL, 13),
2921(171, 'KAB. LAMPUNG BARAT', 'A', '2011-06-29 21:26:23', NULL, 19),
2922(172, 'KAB. LAMPUNG SELATAN', 'A', '2011-06-29 21:26:23', NULL, 19),
2923(173, 'KAB. LAMPUNG TENGAH', 'A', '2011-06-29 21:26:23', NULL, 19),
2924(174, 'KAB. LAMPUNG TIMUR', 'A', '2011-06-29 21:26:23', NULL, 19),
2925(175, 'KAB. LAMPUNG UTARA', 'A', '2011-06-29 21:26:23', NULL, 19),
2926(176, 'KAB. LANDAK', 'A', '2011-06-29 21:26:23', NULL, 14),
2927(177, 'KAB. LANGKAT', 'A', '2011-06-29 21:26:23', NULL, 34),
2928(178, 'KAB. LEBAK', 'A', '2011-06-29 21:26:23', NULL, 5),
2929(179, 'KAB. LEBONG', 'A', '2011-06-29 21:26:23', NULL, 6),
2930(180, 'KAB. LEMBATA', 'A', '2011-06-29 21:26:23', NULL, 23),
2931(181, 'KAB. LIMA PULUH KOTA', 'A', '2011-06-29 21:26:23', NULL, 32),
2932(182, 'KAB. LINGGA', 'A', '2011-06-29 21:26:23', NULL, 18),
2933(183, 'KAB. LOMBOK BARAT', 'A', '2011-06-29 21:26:23', NULL, 22),
2934(184, 'KAB. LOMBOK TENGAH', 'A', '2011-06-29 21:26:23', NULL, 22),
2935(185, 'KAB. LOMBOK TIMUR', 'A', '2011-06-29 21:26:23', NULL, 22),
2936(186, 'KAB. LUMAJANG', 'A', '2011-06-29 21:26:23', NULL, 13),
2937(187, 'KAB. LUWU TIMUR', 'A', '2011-06-29 21:26:23', NULL, 28),
2938(188, 'KAB. LUWU UTARA', 'A', '2011-06-29 21:26:23', NULL, 28),
2939(189, 'KAB. MADIUN', 'A', '2011-06-29 21:26:23', NULL, 13),
2940(190, 'KAB. MAGELANG', 'A', '2011-06-29 21:26:23', NULL, 12),
2941(191, 'KAB. MAGETAN', 'A', '2011-06-29 21:26:23', NULL, 13),
2942(192, 'KAB. MAJALENGKA', 'A', '2011-06-29 21:26:23', NULL, 11),
2943(193, 'KAB. MAJENE', 'A', '2011-06-29 21:26:23', NULL, 27),
2944(194, 'KAB. MALANG', 'A', '2011-06-29 21:26:23', NULL, 13),
2945(195, 'KAB. MALINAU', 'A', '2011-06-29 21:26:23', NULL, 17),
2946(196, 'KAB. MALUKU TENGAH', 'A', '2011-06-29 21:26:23', NULL, 20),
2947(197, 'KAB. MALUKU TENGGARA', 'A', '2011-06-29 21:26:23', NULL, 20),
2948(198, 'KAB. MALUKU TENGGARA BARAT', 'A', '2011-06-29 21:26:23', NULL, 20),
2949(199, 'KAB. MAMASA', 'A', '2011-06-29 21:26:23', NULL, 27),
2950(200, 'KAB. MAMBERAMO RAYA', 'A', '2011-06-29 21:26:23', NULL, 24),
2951(201, 'KAB. MAMUJU', 'A', '2011-06-29 21:26:23', NULL, 27),
2952(202, 'KAB. MAMUJU UTARA', 'A', '2011-06-29 21:26:23', NULL, 27),
2953(203, 'KAB. MANDAILING NATAL', 'A', '2011-06-29 21:26:23', NULL, 34),
2954(204, 'KAB. MANGGARAI', 'A', '2011-06-29 21:26:23', NULL, 23),
2955(205, 'KAB. MANGGARAI BARAT', 'A', '2011-06-29 21:26:23', NULL, 23),
2956(206, 'KAB. MANGGARAI TIMUR', 'A', '2011-06-29 21:26:23', NULL, 23),
2957(207, 'KAB. MANOKWARI', 'A', '2011-06-29 21:26:23', NULL, 25),
2958(208, 'KAB. MAPPI', 'A', '2011-06-29 21:26:23', NULL, 24),
2959(209, 'KAB. MAROS', 'A', '2011-06-29 21:26:23', NULL, 28),
2960(210, 'KAB. MELAWI', 'A', '2011-06-29 21:26:23', NULL, 14),
2961(211, 'KAB. MERANGIN', 'A', '2011-06-29 21:26:23', NULL, 10),
2962(212, 'KAB. MERANTI', 'A', '2011-06-29 21:26:23', NULL, 26),
2963(213, 'KAB. MERAUKE', 'A', '2011-06-29 21:26:23', NULL, 24),
2964(214, 'KAB. MIMIKA', 'A', '2011-06-29 21:26:23', NULL, 24),
2965(215, 'KAB. MINAHASA', 'A', '2011-06-29 21:26:23', NULL, 31),
2966(216, 'KAB. MINAHASA SELATAN', 'A', '2011-06-29 21:26:23', NULL, 31),
2967(217, 'KAB. MINAHASA TENGGARA', 'A', '2011-06-29 21:26:23', NULL, 31),
2968(218, 'KAB. MINAHASA UTARA', 'A', '2011-06-29 21:26:23', NULL, 31),
2969(219, 'KAB. MOJOKERTO', 'A', '2011-06-29 21:26:23', NULL, 13),
2970(220, 'KAB. MOROWALI', 'A', '2011-06-29 21:26:23', NULL, 29),
2971(221, 'KAB. MUARA ENIM', 'A', '2011-06-29 21:26:23', NULL, 33),
2972(222, 'KAB. MUARO JAMBI', 'A', '2011-06-29 21:26:23', NULL, 10),
2973(223, 'KAB. MUKO-MUKO', 'A', '2011-06-29 21:26:23', NULL, 6),
2974(224, 'KAB. MUNA', 'A', '2011-06-29 21:26:23', NULL, 30),
2975(225, 'KAB. MURUNG RAYA', 'A', '2011-06-29 21:26:23', NULL, 16),
2976(226, 'KAB. MUSI BANYUASIN', 'A', '2011-06-29 21:26:23', NULL, 33),
2977(227, 'KAB. MUSI RAWAS', 'A', '2011-06-29 21:26:23', NULL, 33),
2978(228, 'KAB. NABIRE', 'A', '2011-06-29 21:26:23', NULL, 24),
2979(229, 'KAB. NAGAN RAYA', 'A', '2011-06-29 21:26:23', NULL, 3),
2980(230, 'KAB. NAGEKEO', 'A', '2011-06-29 21:26:23', NULL, 23),
2981(231, 'KAB. NATUNA', 'A', '2011-06-29 21:26:23', NULL, 18),
2982(232, 'KAB. NGADA', 'A', '2011-06-29 21:26:23', NULL, 23),
2983(233, 'KAB. NGANJUK', 'A', '2011-06-29 21:26:23', NULL, 13),
2984(234, 'KAB. NGAWI', 'A', '2011-06-29 21:26:23', NULL, 13),
2985(235, 'KAB. NIAS', 'A', '2011-06-29 21:26:23', NULL, 34),
2986(236, 'KAB. NIAS SELATAN', 'A', '2011-06-29 21:26:23', NULL, 34),
2987(237, 'KAB. NUNUKAN', 'A', '2011-06-29 21:26:23', NULL, 17),
2988(238, 'KAB. OGAN ILIR', 'A', '2011-06-29 21:26:23', NULL, 33),
2989(239, 'KAB. OGAN KOMERING ILIR', 'A', '2011-06-29 21:26:23', NULL, 33),
2990(240, 'KAB. OGAN KOMERING ULU', 'A', '2011-06-29 21:26:23', NULL, 33),
2991(241, 'KAB. OGAN KOMERING ULU SELATAN', 'A', '2011-06-29 21:26:23', NULL, 33),
2992(242, 'KAB. OGAN KOMERING ULU TIMUR', 'A', '2011-06-29 21:26:23', NULL, 33),
2993(243, 'KAB. PACITAN', 'A', '2011-06-29 21:26:23', NULL, 13),
2994(244, 'KAB. PADANG LAWAS', 'A', '2011-06-29 21:26:23', NULL, 34),
2995(245, 'KAB. PADANG LAWAS UTARA', 'A', '2011-06-29 21:26:23', NULL, 34),
2996(246, 'KAB. PADANG PARIAMAN', 'A', '2011-06-29 21:26:23', NULL, 32),
2997(247, 'KAB. PAHUWALO', 'A', '2011-06-29 21:26:23', NULL, 8),
2998(248, 'KAB. PAKPAK BARAT', 'A', '2011-06-29 21:26:23', NULL, 34),
2999(249, 'KAB. PALALAWAN', 'A', '2011-06-29 21:26:23', NULL, 26),
3000(250, 'KAB. PAMEKASAN', 'A', '2011-06-29 21:26:23', NULL, 13),
3001(251, 'KAB. PANAJAM PASER UTARA', 'A', '2011-06-29 21:26:23', NULL, 17),
3002(252, 'KAB. PANDEGLANG', 'A', '2011-06-29 21:26:23', NULL, 5),
3003(253, 'KAB. PANGKAJENE KEPULAUAN', 'A', '2011-06-29 21:26:23', NULL, 28),
3004(254, 'KAB. PANIAI', 'A', '2011-06-29 21:26:23', NULL, 24),
3005(255, 'KAB. PARIGI MOUTONG', 'A', '2011-06-29 21:26:23', NULL, 29),
3006(256, 'KAB. PASAMAN', 'A', '2011-06-29 21:26:23', NULL, 32),
3007(257, 'KAB. PASAMAN BARAT', 'A', '2011-06-29 21:26:23', NULL, 32),
3008(258, 'KAB. PASER', 'A', '2011-06-29 21:26:23', NULL, 17),
3009(259, 'KAB. PASURUAN', 'A', '2011-06-29 21:26:23', NULL, 13),
3010(260, 'KAB. PATI', 'A', '2011-06-29 21:26:23', NULL, 12),
3011(261, 'KAB. PEGUNUNGAN BINTANG', 'A', '2011-06-29 21:26:23', NULL, 24),
3012(262, 'KAB. PEKALONGAN', 'A', '2011-06-29 21:26:23', NULL, 12),
3013(263, 'KAB. PEMALANG', 'A', '2011-06-29 21:26:23', NULL, 12),
3014(264, 'KAB. PESAWARAN', 'A', '2011-06-29 21:26:23', NULL, 19),
3015(265, 'KAB. PESISIR SELATAN', 'A', '2011-06-29 21:26:23', NULL, 32),
3016(266, 'KAB. PIDIE', 'A', '2011-06-29 21:26:23', NULL, 3),
3017(267, 'KAB. PIDIE JAYA', 'A', '2011-06-29 21:26:23', NULL, 3),
3018(268, 'KAB. PINRANG', 'A', '2011-06-29 21:26:23', NULL, 28),
3019(269, 'KAB. POLEWALI MANDAR', 'A', '2011-06-29 21:26:23', NULL, 27),
3020(270, 'KAB. PONOROGO', 'A', '2011-06-29 21:26:23', NULL, 13),
3021(271, 'KAB. PONTIANAK', 'A', '2011-06-29 21:26:23', NULL, 14),
3022(272, 'KAB. POSO', 'A', '2011-06-29 21:26:23', NULL, 29),
3023(273, 'KAB. PROBOLINGGO', 'A', '2011-06-29 21:26:23', NULL, 13),
3024(274, 'KAB. PULANG PISAU', 'A', '2011-06-29 21:26:23', NULL, 16),
3025(275, 'KAB. PUNCAK JAYA', 'A', '2011-06-29 21:26:23', NULL, 24),
3026(276, 'KAB. PURBALINGGA', 'A', '2011-06-29 21:26:23', NULL, 12),
3027(277, 'KAB. PURWAKARTA', 'A', '2011-06-29 21:26:23', NULL, 11),
3028(278, 'KAB. PURWOREJO', 'A', '2011-06-29 21:26:23', NULL, 12),
3029(279, 'KAB. RAJA AMPAT', 'A', '2011-06-29 21:26:23', NULL, 25),
3030(280, 'KAB. REJANG LEBONG', 'A', '2011-06-29 21:26:23', NULL, 6),
3031(281, 'KAB. REMBANG', 'A', '2011-06-29 21:26:23', NULL, 12),
3032(282, 'KAB. ROKAN HILIR', 'A', '2011-06-29 21:26:23', NULL, 26),
3033(283, 'KAB. ROKAN HULU', 'A', '2011-06-29 21:26:23', NULL, 26),
3034(284, 'KAB. ROTE NDAO', 'A', '2011-06-29 21:26:23', NULL, 23),
3035(285, 'KAB. SAMBAS', 'A', '2011-06-29 21:26:23', NULL, 14),
3036(286, 'KAB. SAMOSIR', 'A', '2011-06-29 21:26:23', NULL, 34),
3037(287, 'KAB. SAMPANG', 'A', '2011-06-29 21:26:23', NULL, 13),
3038(288, 'KAB. SANGGAU', 'A', '2011-06-29 21:26:23', NULL, 14),
3039(289, 'KAB. SARMI', 'A', '2011-06-29 21:26:23', NULL, 24),
3040(290, 'KAB. SAROLANGUN', 'A', '2011-06-29 21:26:23', NULL, 10),
3041(291, 'KAB. SEKADAU', 'A', '2011-06-29 21:26:23', NULL, 14),
3042(292, 'KAB. SELAYAR', 'A', '2011-06-29 21:26:23', NULL, 28),
3043(293, 'KAB. SELUMA', 'A', '2011-06-29 21:26:23', NULL, 6),
3044(294, 'KAB. SEMARANG', 'A', '2011-06-29 21:26:23', NULL, 12),
3045(295, 'KAB. SERAM BAGIAN BARAT', 'A', '2011-06-29 21:26:23', NULL, 20),
3046(296, 'KAB. SERAM BAGIAN TIMUR', 'A', '2011-06-29 21:26:23', NULL, 20),
3047(297, 'KAB. SERANG', 'A', '2011-06-29 21:26:23', NULL, 5),
3048(298, 'KAB. SERDANG BEDAGAI', 'A', '2011-06-29 21:26:23', NULL, 34),
3049(299, 'KAB. SERUYAN', 'A', '2011-06-29 21:26:23', NULL, 16),
3050(300, 'KAB. SIAK', 'A', '2011-06-29 21:26:23', NULL, 26),
3051(301, 'KAB. SIDOARJO', 'A', '2011-06-29 21:26:23', NULL, 13),
3052(302, 'KAB. SIJUNJUNG', 'A', '2011-06-29 21:26:23', NULL, 32),
3053(303, 'KAB. SIKKA', 'A', '2011-06-29 21:26:23', NULL, 23),
3054(304, 'KAB. SIMALUNGUN', 'A', '2011-06-29 21:26:23', NULL, 34),
3055(305, 'KAB. SIMEULEU', 'A', '2011-06-29 21:26:23', NULL, 3),
3056(306, 'KAB. SINDENRENG RAPPANG', 'A', '2011-06-29 21:26:23', NULL, 28),
3057(307, 'KAB. SINJAI', 'A', '2011-06-29 21:26:23', NULL, 28),
3058(308, 'KAB. SINTANG', 'A', '2011-06-29 21:26:23', NULL, 14),
3059(309, 'KAB. SLEMAN', 'A', '2011-06-29 21:26:23', NULL, 7),
3060(310, 'KAB. SOLOK', 'A', '2011-06-29 21:26:23', NULL, 32),
3061(311, 'KAB. SOLOK SELATAN', 'A', '2011-06-29 21:26:23', NULL, 32),
3062(312, 'KAB. SOPPENG', 'A', '2011-06-29 21:26:23', NULL, 28),
3063(313, 'KAB. SORONG', 'A', '2011-06-29 21:26:23', NULL, 25),
3064(314, 'KAB. SORONG SELATAN', 'A', '2011-06-29 21:26:23', NULL, 25),
3065(315, 'KAB. SRAGEN', 'A', '2011-06-29 21:26:23', NULL, 12),
3066(316, 'KAB. SUBANG', 'A', '2011-06-29 21:26:23', NULL, 11),
3067(317, 'KAB. SUKABUMI', 'A', '2011-06-29 21:26:23', NULL, 11),
3068(318, 'KAB. SUKAMARA', 'A', '2011-06-29 21:26:23', NULL, 16),
3069(319, 'KAB. SUKOHARJO', 'A', '2011-06-29 21:26:23', NULL, 12),
3070(320, 'KAB. SUMBA BARAT', 'A', '2011-06-29 21:26:23', NULL, 23),
3071(321, 'KAB. SUMBA BARAT DAYA', 'A', '2011-06-29 21:26:23', NULL, 23),
3072(322, 'KAB. SUMBA TENGAH', 'A', '2011-06-29 21:26:23', NULL, 23),
3073(323, 'KAB. SUMBA TIMUR', 'A', '2011-06-29 21:26:23', NULL, 23),
3074(324, 'KAB. SUMBAWA', 'A', '2011-06-29 21:26:23', NULL, 22),
3075(325, 'KAB. SUMBAWA BARAT', 'A', '2011-06-29 21:26:23', NULL, 22),
3076(326, 'KAB. SUMEDANG', 'A', '2011-06-29 21:26:23', NULL, 11),
3077(327, 'KAB. SUMENEP', 'A', '2011-06-29 21:26:23', NULL, 13),
3078(328, 'KAB. SUPIORI', 'A', '2011-06-29 21:26:23', NULL, 24),
3079(329, 'KAB. TABALONG', 'A', '2011-06-29 21:26:23', NULL, 15),
3080(330, 'KAB. TABANAN', 'A', '2011-06-29 21:26:23', NULL, 4),
3081(331, 'KAB. TAKALAR', 'A', '2011-06-29 21:26:23', NULL, 28),
3082(332, 'KAB. TALIKORA', 'A', '2011-06-29 21:26:23', NULL, 24),
3083(333, 'KAB. TAMPIN', 'A', '2011-06-29 21:26:23', NULL, 15),
3084(334, 'KAB. TANA TIDUNG', 'A', '2011-06-29 21:26:23', NULL, 17),
3085(335, 'KAB. TANA TORAJA', 'A', '2011-06-29 21:26:23', NULL, 28),
3086(336, 'KAB. TANA TORAJA UTARA', 'A', '2011-06-29 21:26:23', NULL, 28),
3087(337, 'KAB. TANAH BAMBU', 'A', '2011-06-29 21:26:23', NULL, 15),
3088(338, 'KAB. TANAH DATAR', 'A', '2011-06-29 21:26:23', NULL, 32),
3089(339, 'KAB. TANAH LAUT', 'A', '2011-06-29 21:26:23', NULL, 15),
3090(340, 'KAB. TANGERANG', 'A', '2011-06-29 21:26:23', NULL, 5),
3091(341, 'KAB. TANGGAMUS', 'A', '2011-06-29 21:26:23', NULL, 19),
3092(342, 'KAB. TANJUNG JABUNG BARAT', 'A', '2011-06-29 21:26:23', NULL, 10),
3093(343, 'KAB. TANJUNG JABUNG TIMUR', 'A', '2011-06-29 21:26:23', NULL, 10),
3094(344, 'KAB. TAPANULI SELATAN', 'A', '2011-06-29 21:26:23', NULL, 34),
3095(345, 'KAB. TAPANULI TENGAH', 'A', '2011-06-29 21:26:23', NULL, 34),
3096(346, 'KAB. TAPANULI UTARA', 'A', '2011-06-29 21:26:23', NULL, 34),
3097(347, 'KAB. TASIKMALAYA', 'A', '2011-06-29 21:26:23', NULL, 11),
3098(348, 'KAB. TEBO', 'A', '2011-06-29 21:26:23', NULL, 10),
3099(349, 'KAB. TEGAL', 'A', '2011-06-29 21:26:23', NULL, 12),
3100(350, 'KAB. TELUK BINTUNI', 'A', '2011-06-29 21:26:23', NULL, 25),
3101(351, 'KAB. TELUK WONDAMA', 'A', '2011-06-29 21:26:23', NULL, 25),
3102(352, 'KAB. TEMANGGUNG', 'A', '2011-06-29 21:26:23', NULL, 12),
3103(353, 'KAB. TIMOR TENGAH SELATAN', 'A', '2011-06-29 21:26:23', NULL, 23),
3104(354, 'KAB. TIMOR TENGAH UTARA', 'A', '2011-06-29 21:26:23', NULL, 23),
3105(355, 'KAB. TOBA SAMOSIR', 'A', '2011-06-29 21:26:23', NULL, 34),
3106(356, 'KAB. TOJO UNA-UNA', 'A', '2011-06-29 21:26:23', NULL, 29),
3107(357, 'KAB. TOLI-TOLI', 'A', '2011-06-29 21:26:23', NULL, 29),
3108(358, 'KAB. TRENGGALEK', 'A', '2011-06-29 21:26:23', NULL, 13),
3109(359, 'KAB. TUBAN', 'A', '2011-06-29 21:26:23', NULL, 13),
3110(360, 'KAB. TULANG BAWANG', 'A', '2011-06-29 21:26:23', NULL, 19),
3111(361, 'KAB. TULUNGAGUNG', 'A', '2011-06-29 21:26:23', NULL, 13),
3112(362, 'KAB. WAKATOBI', 'A', '2011-06-29 21:26:23', NULL, 30),
3113(363, 'KAB. WAROPEN', 'A', '2011-06-29 21:26:23', NULL, 24),
3114(364, 'KAB. WAY KANAN', 'A', '2011-06-29 21:26:23', NULL, 19),
3115(365, 'KAB. WONOGIRI', 'A', '2011-06-29 21:26:23', NULL, 12),
3116(366, 'KAB. WONOSOBO', 'A', '2011-06-29 21:26:23', NULL, 12),
3117(367, 'KAB. YAHUKIMO', 'A', '2011-06-29 21:26:23', NULL, 24),
3118(368, 'KAB. YAPEN WAROPEN', 'A', '2011-06-29 21:26:23', NULL, 24),
3119(369, 'KAB.CIAMIS', 'A', '2011-06-29 21:26:23', NULL, 11),
3120(370, 'KAB.GRESIK', 'A', '2011-06-29 21:26:23', NULL, 13),
3121(371, 'KOTA ADMINISTRASI JAKARTA BARAT', 'A', '2011-06-29 21:26:23', NULL, 9),
3122(372, 'KOTA ADMINISTRASI JAKARTA PUSAT', 'A', '2011-06-29 21:26:23', NULL, 9),
3123(373, 'KOTA ADMINISTRASI JAKARTA SELATAN', 'A', '2011-06-29 21:26:23', NULL, 9),
3124(374, 'KOTA ADMINISTRASI JAKARTA TIMUR', 'A', '2011-06-29 21:26:23', NULL, 9),
3125(375, 'KOTA ADMINISTRASI JAKARTA UTARA', 'A', '2011-06-29 21:26:23', NULL, 9),
3126(376, 'KOTA ADMINISTRASI KEPULAUAN SERIBU', 'A', '2011-06-29 21:26:23', NULL, 9),
3127(377, 'KOTA AMBON', 'A', '2011-06-29 21:26:23', NULL, 20),
3128(378, 'KOTA BALIKPAPAN', 'A', '2011-06-29 21:26:23', NULL, 17),
3129(379, 'KOTA BANDA ACEH', 'A', '2011-06-29 21:26:23', NULL, 3),
3130(380, 'KOTA BANDAR LAMPUNG', 'A', '2011-06-29 21:26:23', NULL, 19),
3131(381, 'KOTA BANDUNG', 'A', '2011-06-29 21:26:23', NULL, 11),
3132(382, 'KOTA BANJAR', 'A', '2011-06-29 21:26:23', NULL, 11),
3133(383, 'KOTA BANJARBARU', 'A', '2011-06-29 21:26:23', NULL, 15),
3134(384, 'KOTA BANJARMASIN', 'A', '2011-06-29 21:26:23', NULL, 15),
3135(385, 'KOTA BATAM', 'A', '2011-06-29 21:26:23', NULL, 18),
3136(386, 'KOTA BATU', 'A', '2011-06-29 21:26:23', NULL, 13),
3137(387, 'KOTA BEKASI', 'A', '2011-06-29 21:26:23', NULL, 11),
3138(388, 'KOTA BENGKULU', 'A', '2011-06-29 21:26:23', NULL, 6),
3139(389, 'KOTA BIMA', 'A', '2011-06-29 21:26:23', NULL, 22),
3140(390, 'KOTA BINJAI', 'A', '2011-06-29 21:26:23', NULL, 34),
3141(391, 'KOTA BITUNG', 'A', '2011-06-29 21:26:23', NULL, 31),
3142(392, 'KOTA BLITAR', 'A', '2011-06-29 21:26:23', NULL, 13),
3143(393, 'KOTA BOGOR', 'A', '2011-06-29 21:26:23', NULL, 11),
3144(394, 'KOTA BONE BOLANGO', 'A', '2011-06-29 21:26:23', NULL, 8),
3145(395, 'KOTA BONTANG', 'A', '2011-06-29 21:26:23', NULL, 17),
3146(396, 'KOTA BUKIT TINGGI', 'A', '2011-06-29 21:26:23', NULL, 32),
3147(397, 'KOTA CILEGON', 'A', '2011-06-29 21:26:23', NULL, 5),
3148(398, 'KOTA CIMAHI', 'A', '2011-06-29 21:26:23', NULL, 11),
3149(399, 'KOTA CIREBON', 'A', '2011-06-29 21:26:23', NULL, 11),
3150(400, 'KOTA DENPASAR', 'A', '2011-06-29 21:26:23', NULL, 4),
3151(401, 'KOTA DEPOK', 'A', '2011-06-29 21:26:23', NULL, 11),
3152(402, 'KOTA DUMAI', 'A', '2011-06-29 21:26:23', NULL, 26),
3153(403, 'KOTA GORONTALO', 'A', '2011-06-29 21:26:23', NULL, 8),
3154(404, 'KOTA JAMBI', 'A', '2011-06-29 21:26:23', NULL, 10),
3155(405, 'KOTA JAYAPURA', 'A', '2011-06-29 21:26:23', NULL, 24),
3156(406, 'KOTA KEDIRI', 'A', '2011-06-29 21:26:23', NULL, 13),
3157(407, 'KOTA KENDARI', 'A', '2011-06-29 21:26:23', NULL, 30),
3158(408, 'KOTA KUPANG', 'A', '2011-06-29 21:26:23', NULL, 23),
3159(409, 'KOTA LANGSA', 'A', '2011-06-29 21:26:23', NULL, 3),
3160(410, 'KOTA LHOKSEUMAWE', 'A', '2011-06-29 21:26:23', NULL, 3),
3161(411, 'KOTA LUBUK LINGGAU', 'A', '2011-06-29 21:26:23', NULL, 33),
3162(412, 'KOTA MADIUN', 'A', '2011-06-29 21:26:23', NULL, 13),
3163(413, 'KOTA MAGELANG', 'A', '2011-06-29 21:26:23', NULL, 12),
3164(414, 'KOTA MAKASSAR', 'A', '2011-06-29 21:26:23', NULL, 28),
3165(415, 'KOTA MALANG', 'A', '2011-06-29 21:26:23', NULL, 13),
3166(416, 'KOTA MANADO', 'A', '2011-06-29 21:26:23', NULL, 31),
3167(417, 'KOTA MATARAM', 'A', '2011-06-29 21:26:23', NULL, 22),
3168(418, 'KOTA MEDAN', 'A', '2011-06-29 21:26:23', NULL, 34),
3169(419, 'KOTA METRO', 'A', '2011-06-29 21:26:23', NULL, 19),
3170(420, 'KOTA MOJOKERTO', 'A', '2011-06-29 21:26:23', NULL, 13),
3171(421, 'KOTA PADANG', 'A', '2011-06-29 21:26:23', NULL, 32),
3172(422, 'KOTA PADANG PANJANG', 'A', '2011-06-29 21:26:23', NULL, 32),
3173(423, 'KOTA PADANG SIDEMPUAN', 'A', '2011-06-29 21:26:23', NULL, 34),
3174(424, 'KOTA PAGAR ALAM', 'A', '2011-06-29 21:26:23', NULL, 33),
3175(425, 'KOTA PALANGKARAYA', 'A', '2011-06-29 21:26:23', NULL, 16),
3176(426, 'KOTA PALEMBANG', 'A', '2011-06-29 21:26:23', NULL, 33),
3177(427, 'KOTA PALOPO', 'A', '2011-06-29 21:26:23', NULL, 28),
3178(428, 'KOTA PALU', 'A', '2011-06-29 21:26:23', NULL, 29),
3179(429, 'KOTA PANGKAL PINANG', 'A', '2011-06-29 21:26:23', NULL, 18),
3180(430, 'KOTA PARE-PARE', 'A', '2011-06-29 21:26:23', NULL, 28),
3181(431, 'KOTA PARIAMAN', 'A', '2011-06-29 21:26:23', NULL, 32),
3182(432, 'KOTA PASURUAN', 'A', '2011-06-29 21:26:23', NULL, 13),
3183(433, 'KOTA PAYAKUMBUH', 'A', '2011-06-29 21:26:23', NULL, 32),
3184(434, 'KOTA PEKALONGAN', 'A', '2011-06-29 21:26:23', NULL, 12),
3185(435, 'KOTA PEKANBARU', 'A', '2011-06-29 21:26:23', NULL, 26),
3186(436, 'KOTA PEMATANGSIANTAR', 'A', '2011-06-29 21:26:23', NULL, 34),
3187(437, 'KOTA PONTIANAK', 'A', '2011-06-29 21:26:23', NULL, 14),
3188(438, 'KOTA PRABUMULIH', 'A', '2011-06-29 21:26:23', NULL, 33),
3189(439, 'KOTA PROBOLINGGO', 'A', '2011-06-29 21:26:23', NULL, 13),
3190(440, 'KOTA SABANG', 'A', '2011-06-29 21:26:23', NULL, 3),
3191(441, 'KOTA SALATIGA', 'A', '2011-06-29 21:26:23', NULL, 12),
3192(442, 'KOTA SAMARINDA', 'A', '2011-06-29 21:26:23', NULL, 17),
3193(443, 'KOTA SAWAHLUNTO', 'A', '2011-06-29 21:26:23', NULL, 32),
3194(444, 'KOTA SEMARANG', 'A', '2011-06-29 21:26:23', NULL, 12),
3195(445, 'KOTA SERANG', 'A', '2011-06-29 21:26:23', NULL, 5),
3196(446, 'KOTA SIBOLGA', 'A', '2011-06-29 21:26:23', NULL, 34),
3197(447, 'KOTA SINGKAWANG', 'A', '2011-06-29 21:26:23', NULL, 14),
3198(448, 'KOTA SOLOK', 'A', '2011-06-29 21:26:23', NULL, 32),
3199(449, 'KOTA SORONG', 'A', '2011-06-29 21:26:23', NULL, 25),
3200(450, 'KOTA SUBULUSSALAM', 'A', '2011-06-29 21:26:23', NULL, 3),
3201(451, 'KOTA SUKABUMI', 'A', '2011-06-29 21:26:23', NULL, 11),
3202(452, 'KOTA SURABAYA', 'A', '2011-06-29 21:26:23', NULL, 13),
3203(453, 'KOTA SURAKARTA', 'A', '2011-06-29 21:26:23', NULL, 12),
3204(454, 'KOTA TANGERANG', 'A', '2011-06-29 21:26:23', NULL, 5),
3205(455, 'KOTA TANJUNG BALAI', 'A', '2011-06-29 21:26:23', NULL, 34),
3206(456, 'KOTA TANJUNG PINANG', 'A', '2011-06-29 21:26:23', NULL, 18),
3207(457, 'KOTA TARAKAN', 'A', '2011-06-29 21:26:23', NULL, 17),
3208(458, 'KOTA TASIKMALAYA', 'A', '2011-06-29 21:26:23', NULL, 11),
3209(459, 'KOTA TEBING TINGGI', 'A', '2011-06-29 21:26:23', NULL, 34),
3210(460, 'KOTA TEGAL', 'A', '2011-06-29 21:26:23', NULL, 12),
3211(461, 'KOTA TERNATE', 'A', '2011-06-29 21:26:23', NULL, 21),
3212(462, 'KOTA TIDORE', 'A', '2011-06-29 21:26:23', NULL, 21),
3213(463, 'KOTA TOMOHON', 'A', '2011-06-29 21:26:23', NULL, 31),
3214(464, 'KOTA WAJO', 'A', '2011-06-29 21:26:23', NULL, 28),
3215(465, 'KOTA YOGYAKARTA', 'A', '2011-06-29 21:26:23', NULL, 7);
3216
3217-- --------------------------------------------------------
3218
3219--
3220-- Table structure for table `tbl_countries`
3221--
3222
3223CREATE TABLE IF NOT EXISTS `tbl_countries` (
3224 `id` int(11) NOT NULL AUTO_INCREMENT,
3225 `country_code` varchar(2) NOT NULL DEFAULT '',
3226 `country_name` varchar(100) NOT NULL DEFAULT '',
3227 PRIMARY KEY (`id`)
3228) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=247 ;
3229
3230--
3231-- Dumping data for table `tbl_countries`
3232--
3233
3234INSERT INTO `tbl_countries` (`id`, `country_code`, `country_name`) VALUES
3235(1, 'AF', 'Afghanistan'),
3236(2, 'AL', 'Albania'),
3237(3, 'DZ', 'Algeria'),
3238(4, 'DS', 'American Samoa'),
3239(5, 'AD', 'Andorra'),
3240(6, 'AO', 'Angola'),
3241(7, 'AI', 'Anguilla'),
3242(8, 'AQ', 'Antarctica'),
3243(9, 'AG', 'Antigua and Barbuda'),
3244(10, 'AR', 'Argentina'),
3245(11, 'AM', 'Armenia'),
3246(12, 'AW', 'Aruba'),
3247(13, 'AU', 'Australia'),
3248(14, 'AT', 'Austria'),
3249(15, 'AZ', 'Azerbaijan'),
3250(16, 'BS', 'Bahamas'),
3251(17, 'BH', 'Bahrain'),
3252(18, 'BD', 'Bangladesh'),
3253(19, 'BB', 'Barbados'),
3254(20, 'BY', 'Belarus'),
3255(21, 'BE', 'Belgium'),
3256(22, 'BZ', 'Belize'),
3257(23, 'BJ', 'Benin'),
3258(24, 'BM', 'Bermuda'),
3259(25, 'BT', 'Bhutan'),
3260(26, 'BO', 'Bolivia'),
3261(27, 'BA', 'Bosnia and Herzegovina'),
3262(28, 'BW', 'Botswana'),
3263(29, 'BV', 'Bouvet Island'),
3264(30, 'BR', 'Brazil'),
3265(31, 'IO', 'British Indian Ocean Territory'),
3266(32, 'BN', 'Brunei Darussalam'),
3267(33, 'BG', 'Bulgaria'),
3268(34, 'BF', 'Burkina Faso'),
3269(35, 'BI', 'Burundi'),
3270(36, 'KH', 'Cambodia'),
3271(37, 'CM', 'Cameroon'),
3272(38, 'CA', 'Canada'),
3273(39, 'CV', 'Cape Verde'),
3274(40, 'KY', 'Cayman Islands'),
3275(41, 'CF', 'Central African Republic'),
3276(42, 'TD', 'Chad'),
3277(43, 'CL', 'Chile'),
3278(44, 'CN', 'China'),
3279(45, 'CX', 'Christmas Island'),
3280(46, 'CC', 'Cocos (Keeling) Islands'),
3281(47, 'CO', 'Colombia'),
3282(48, 'KM', 'Comoros'),
3283(49, 'CG', 'Congo'),
3284(50, 'CK', 'Cook Islands'),
3285(51, 'CR', 'Costa Rica'),
3286(52, 'HR', 'Croatia (Hrvatska)'),
3287(53, 'CU', 'Cuba'),
3288(54, 'CY', 'Cyprus'),
3289(55, 'CZ', 'Czech Republic'),
3290(56, 'DK', 'Denmark'),
3291(57, 'DJ', 'Djibouti'),
3292(58, 'DM', 'Dominica'),
3293(59, 'DO', 'Dominican Republic'),
3294(60, 'TP', 'East Timor'),
3295(61, 'EC', 'Ecuador'),
3296(62, 'EG', 'Egypt'),
3297(63, 'SV', 'El Salvador'),
3298(64, 'GQ', 'Equatorial Guinea'),
3299(65, 'ER', 'Eritrea'),
3300(66, 'EE', 'Estonia'),
3301(67, 'ET', 'Ethiopia'),
3302(68, 'FK', 'Falkland Islands (Malvinas)'),
3303(69, 'FO', 'Faroe Islands'),
3304(70, 'FJ', 'Fiji'),
3305(71, 'FI', 'Finland'),
3306(72, 'FR', 'France'),
3307(73, 'FX', 'France, Metropolitan'),
3308(74, 'GF', 'French Guiana'),
3309(75, 'PF', 'French Polynesia'),
3310(76, 'TF', 'French Southern Territories'),
3311(77, 'GA', 'Gabon'),
3312(78, 'GM', 'Gambia'),
3313(79, 'GE', 'Georgia'),
3314(80, 'DE', 'Germany'),
3315(81, 'GH', 'Ghana'),
3316(82, 'GI', 'Gibraltar'),
3317(83, 'GK', 'Guernsey'),
3318(84, 'GR', 'Greece'),
3319(85, 'GL', 'Greenland'),
3320(86, 'GD', 'Grenada'),
3321(87, 'GP', 'Guadeloupe'),
3322(88, 'GU', 'Guam'),
3323(89, 'GT', 'Guatemala'),
3324(90, 'GN', 'Guinea'),
3325(91, 'GW', 'Guinea-Bissau'),
3326(92, 'GY', 'Guyana'),
3327(93, 'HT', 'Haiti'),
3328(94, 'HM', 'Heard and Mc Donald Islands'),
3329(95, 'HN', 'Honduras'),
3330(96, 'HK', 'Hong Kong'),
3331(97, 'HU', 'Hungary'),
3332(98, 'IS', 'Iceland'),
3333(99, 'IN', 'India'),
3334(100, 'IM', 'Isle of Man'),
3335(101, 'ID', 'Indonesia'),
3336(102, 'IR', 'Iran (Islamic Republic of)'),
3337(103, 'IQ', 'Iraq'),
3338(104, 'IE', 'Ireland'),
3339(105, 'IL', 'Israel'),
3340(106, 'IT', 'Italy'),
3341(107, 'CI', 'Ivory Coast'),
3342(108, 'JE', 'Jersey'),
3343(109, 'JM', 'Jamaica'),
3344(110, 'JP', 'Japan'),
3345(111, 'JO', 'Jordan'),
3346(112, 'KZ', 'Kazakhstan'),
3347(113, 'KE', 'Kenya'),
3348(114, 'KI', 'Kiribati'),
3349(115, 'KP', 'Korea, Democratic People''s Republic of'),
3350(116, 'KR', 'Korea, Republic of'),
3351(117, 'XK', 'Kosovo'),
3352(118, 'KW', 'Kuwait'),
3353(119, 'KG', 'Kyrgyzstan'),
3354(120, 'LA', 'Lao People''s Democratic Republic'),
3355(121, 'LV', 'Latvia'),
3356(122, 'LB', 'Lebanon'),
3357(123, 'LS', 'Lesotho'),
3358(124, 'LR', 'Liberia'),
3359(125, 'LY', 'Libyan Arab Jamahiriya'),
3360(126, 'LI', 'Liechtenstein'),
3361(127, 'LT', 'Lithuania'),
3362(128, 'LU', 'Luxembourg'),
3363(129, 'MO', 'Macau'),
3364(130, 'MK', 'Macedonia'),
3365(131, 'MG', 'Madagascar'),
3366(132, 'MW', 'Malawi'),
3367(133, 'MY', 'Malaysia'),
3368(134, 'MV', 'Maldives'),
3369(135, 'ML', 'Mali'),
3370(136, 'MT', 'Malta'),
3371(137, 'MH', 'Marshall Islands'),
3372(138, 'MQ', 'Martinique'),
3373(139, 'MR', 'Mauritania'),
3374(140, 'MU', 'Mauritius'),
3375(141, 'TY', 'Mayotte'),
3376(142, 'MX', 'Mexico'),
3377(143, 'FM', 'Micronesia, Federated States of'),
3378(144, 'MD', 'Moldova, Republic of'),
3379(145, 'MC', 'Monaco'),
3380(146, 'MN', 'Mongolia'),
3381(147, 'ME', 'Montenegro'),
3382(148, 'MS', 'Montserrat'),
3383(149, 'MA', 'Morocco'),
3384(150, 'MZ', 'Mozambique'),
3385(151, 'MM', 'Myanmar'),
3386(152, 'NA', 'Namibia'),
3387(153, 'NR', 'Nauru'),
3388(154, 'NP', 'Nepal'),
3389(155, 'NL', 'Netherlands'),
3390(156, 'AN', 'Netherlands Antilles'),
3391(157, 'NC', 'New Caledonia'),
3392(158, 'NZ', 'New Zealand'),
3393(159, 'NI', 'Nicaragua'),
3394(160, 'NE', 'Niger'),
3395(161, 'NG', 'Nigeria'),
3396(162, 'NU', 'Niue'),
3397(163, 'NF', 'Norfolk Island'),
3398(164, 'MP', 'Northern Mariana Islands'),
3399(165, 'NO', 'Norway'),
3400(166, 'OM', 'Oman'),
3401(167, 'PK', 'Pakistan'),
3402(168, 'PW', 'Palau'),
3403(169, 'PS', 'Palestine'),
3404(170, 'PA', 'Panama'),
3405(171, 'PG', 'Papua New Guinea'),
3406(172, 'PY', 'Paraguay'),
3407(173, 'PE', 'Peru'),
3408(174, 'PH', 'Philippines'),
3409(175, 'PN', 'Pitcairn'),
3410(176, 'PL', 'Poland'),
3411(177, 'PT', 'Portugal'),
3412(178, 'PR', 'Puerto Rico'),
3413(179, 'QA', 'Qatar'),
3414(180, 'RE', 'Reunion'),
3415(181, 'RO', 'Romania'),
3416(182, 'RU', 'Russian Federation'),
3417(183, 'RW', 'Rwanda'),
3418(184, 'KN', 'Saint Kitts and Nevis'),
3419(185, 'LC', 'Saint Lucia'),
3420(186, 'VC', 'Saint Vincent and the Grenadines'),
3421(187, 'WS', 'Samoa'),
3422(188, 'SM', 'San Marino'),
3423(189, 'ST', 'Sao Tome and Principe'),
3424(190, 'SA', 'Saudi Arabia'),
3425(191, 'SN', 'Senegal'),
3426(192, 'RS', 'Serbia'),
3427(193, 'SC', 'Seychelles'),
3428(194, 'SL', 'Sierra Leone'),
3429(195, 'SG', 'Singapore'),
3430(196, 'SK', 'Slovakia'),
3431(197, 'SI', 'Slovenia'),
3432(198, 'SB', 'Solomon Islands'),
3433(199, 'SO', 'Somalia'),
3434(200, 'ZA', 'South Africa'),
3435(201, 'GS', 'South Georgia South Sandwich Islands'),
3436(202, 'ES', 'Spain'),
3437(203, 'LK', 'Sri Lanka'),
3438(204, 'SH', 'St. Helena'),
3439(205, 'PM', 'St. Pierre and Miquelon'),
3440(206, 'SD', 'Sudan'),
3441(207, 'SR', 'Suriname'),
3442(208, 'SJ', 'Svalbard and Jan Mayen Islands'),
3443(209, 'SZ', 'Swaziland'),
3444(210, 'SE', 'Sweden'),
3445(211, 'CH', 'Switzerland'),
3446(212, 'SY', 'Syrian Arab Republic'),
3447(213, 'TW', 'Taiwan'),
3448(214, 'TJ', 'Tajikistan'),
3449(215, 'TZ', 'Tanzania, United Republic of'),
3450(216, 'TH', 'Thailand'),
3451(217, 'TG', 'Togo'),
3452(218, 'TK', 'Tokelau'),
3453(219, 'TO', 'Tonga'),
3454(220, 'TT', 'Trinidad and Tobago'),
3455(221, 'TN', 'Tunisia'),
3456(222, 'TR', 'Turkey'),
3457(223, 'TM', 'Turkmenistan'),
3458(224, 'TC', 'Turks and Caicos Islands'),
3459(225, 'TV', 'Tuvalu'),
3460(226, 'UG', 'Uganda'),
3461(227, 'UA', 'Ukraine'),
3462(228, 'AE', 'United Arab Emirates'),
3463(229, 'GB', 'United Kingdom'),
3464(230, 'US', 'United States'),
3465(231, 'UM', 'United States minor outlying islands'),
3466(232, 'UY', 'Uruguay'),
3467(233, 'UZ', 'Uzbekistan'),
3468(234, 'VU', 'Vanuatu'),
3469(235, 'VA', 'Vatican City State'),
3470(236, 'VE', 'Venezuela'),
3471(237, 'VN', 'Vietnam'),
3472(238, 'VG', 'Virgin Islands (British)'),
3473(239, 'VI', 'Virgin Islands (U.S.)'),
3474(240, 'WF', 'Wallis and Futuna Islands'),
3475(241, 'EH', 'Western Sahara'),
3476(242, 'YE', 'Yemen'),
3477(243, 'YU', 'Yugoslavia'),
3478(244, 'ZR', 'Zaire'),
3479(245, 'ZM', 'Zambia'),
3480(246, 'ZW', 'Zimbabwe');
3481
3482-- --------------------------------------------------------
3483
3484--
3485-- Table structure for table `timeline_event`
3486--
3487
3488CREATE TABLE IF NOT EXISTS `timeline_event` (
3489 `id` int(11) NOT NULL AUTO_INCREMENT,
3490 `application` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3491 `category` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3492 `event` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3493 `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
3494 `created_at` int(11) NOT NULL,
3495 PRIMARY KEY (`id`),
3496 KEY `idx_created_at` (`created_at`)
3497) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3498
3499-- --------------------------------------------------------
3500
3501--
3502-- Table structure for table `user`
3503--
3504
3505CREATE TABLE IF NOT EXISTS `user` (
3506 `id` int(11) NOT NULL AUTO_INCREMENT,
3507 `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3508 `auth_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3509 `password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3510 `password_reset_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3511 `oauth_client` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3512 `oauth_client_user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3513 `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3514 `status` smallint(6) NOT NULL DEFAULT '0',
3515 `role` tinyint(1) NOT NULL DEFAULT '1',
3516 `created_at` int(11) DEFAULT NULL,
3517 `updated_at` int(11) DEFAULT NULL,
3518 `logged_at` int(11) DEFAULT NULL,
3519 PRIMARY KEY (`id`)
3520) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ;
3521
3522--
3523-- Dumping data for table `user`
3524--
3525
3526INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `oauth_client`, `oauth_client_user_id`, `email`, `status`, `role`, `created_at`, `updated_at`, `logged_at`) VALUES
3527(1, 'admin', 'w6sF-zQEK5jsN1-cN9LxKgIThiGLY_0z', '$2y$13$keNglqMIQxSwo9qFYvPsT.vUZJTJ/dcos2qIn0EcPVLUMXFz3OUiW', 'iDuQ0Y-9DJn4SVIihKUv6Brp2Nz-a42e_1442992947', NULL, NULL, '1admin@veboo.co.id', 1, 1, 1441038955, 1456369916, 1456369916),
3528(6, 'marcostrans', '0uEcO-LO4Nd0ypD8RfKE0AhQWpvgXmSW', '$2y$13$oIkN8qegbycU0nPoLtUiR.WvGkatbLGFrliQuBtn4UdIOK9BdqPy6', NULL, NULL, NULL, '1trans.marcos@yahoo.co.id', 1, 1, 1444040497, 1445921053, 1445921053),
3529(7, 'Sanjaya', 'nWLM7lAVnT4hrr1n_0tXhLjw4nh4rv4Z', '$2y$13$DovjQKfjBioKFtQ1851ple2kIVgfRFdZX6wVKYC9jII/jIg9CT.C.', NULL, NULL, NULL, '1sanjaya@samaberkat.com', 0, 1, 1444060708, 1444060708, NULL),
3530(9, 'youfrejer', 'np4JAv5aA9eyMhW5GoHbOFsP5keyX-3y', '$2y$13$h3pBUjQqlPnVrCfWdLAQcu28eG0Nlb5Pc1EN..12ZujLjF0yZPUye', NULL, NULL, NULL, '1youfrejer@icloud.com', 0, 1, 1444129992, 1444129992, NULL),
3531(17, 'Frans Simanjuntak', 'iFE2m8vrDxdX0r46E5saXpsuwKF7Nwd6', '$2y$13$3vWBPLa7bMEpvqw.FBXukueNabj965q26hRIyK2f3XUBVBwxYDJdW', NULL, NULL, NULL, '1fhhary@yahoo.com', 0, 1, 1444268080, 1444268080, NULL),
3532(18, 'donney616', '65S0Y_SGW7NmMhcHDSTQ64friea2PWHk', '$2y$13$zR/KzABgqsp8Ve/WuQT7GOTYDRxr5wfZ7YtcUfNTc4imK2aIX0gPm', NULL, NULL, NULL, '1donney6163@gmail.com', 0, 1, 1444555132, 1444555132, NULL),
3533(19, 'Bomby80', 'm89tVEBfEaP27RgwpHW6_Pxg6vNjiHrq', '$2y$13$NSZxN5Kmph16kzVDt1a3fOKXimXdz2Orqsk6cfRAafnyXxE.u.u5S', NULL, NULL, NULL, '1bombycakrawalalogistics85@gmail.com', 0, 1, 1444558816, 1444558816, NULL),
3534(20, 'sahri unicorn', 'gTatV_i5JoAYkV8-_LZR5ml_eR8TR7tZ', '$2y$13$VzSqKVVXMBFOyXLL4Ytb7ufMFA1hf896lU/Pu8yihxTa0RPjx48n.', NULL, NULL, NULL, '11sahricldk@yahoo.com', 0, 1, 1444606740, 1444606740, NULL),
3535(22, 'nono_dewanto', 'YRvewVxA1HtLuGmFQkuU5dKm2tqndh30', '$2y$13$3V1e1A01Jv8Wh9kCldNScOHoFcsc1npufVA.URHMPeEAB74PBA1Fy', NULL, NULL, NULL, '1Nono.dewanto@gmail.com', 0, 1, 1444619702, 1444619702, NULL),
3536(24, 'Reza Fachrezy', 'nE2p3T4OjiGDE1YOBkbLQ1J0XXSfZJwG', '$2y$13$2ThTwjcncMP1TLc9mhq63OppxtZwIUsrKGUrxgDbSaiTiUxqlJrGO', NULL, NULL, NULL, '1rezafachrezy@gmail.com', 1, 1, 1444621679, 1444622989, NULL),
3537(29, 'Bagasmbj99', 'ywT7ZGW4mq1YLDt1pggAH-hrV21ZwkJU', '$2y$13$wKtheF7q2r.bsCmUvc3HyO9t6a7EpxtprqL7M.y6sLntFcRn1cB66', NULL, NULL, NULL, '1Bagas.mbj@gmail.com', 1, 1, 1445299622, 1445301147, NULL),
3538(30, 'dudi mano', 'AUkv9AVXFmYbKPLHy0YvSPT3wMHH8a75', '$2y$13$kDNQwfF4GLf6AWlGqT.UsuI/rMKedz6S0TFMu7W3Zhei2ffvVpSue', NULL, NULL, NULL, '1dudi.dude80@gmail.com', 1, 1, 1445300913, 1445613816, 1445613816),
3539(31, 'armadasemangat', 'cy_dfleBZioGmPQV8o7l15_Sc1hPRutJ', '$2y$13$k2SAdIHXOKtjQX0IV15UwuaJbH9Xvgsw7DiPeW7ED/Gf3iaXQmGfO', NULL, NULL, NULL, '1arief@semangat-group.com', 1, 1, 1445406175, 1445406784, 1445406708),
3540(33, 'ksyanuar@gmail.com', 'Wymb8-lWg99OKr78DVXnITuZm7f_qUD5', '$2y$13$HVQzx.9EGjR3ChN.h83rFeYwkcQQSbHhXeGD6Zv3UgVLf81CDAFee', NULL, NULL, NULL, '1ksyanuar@gmail.com', 1, 1, 1445656093, 1445656230, 1445656230),
3541(91, 'harunprovider', 'yvXlc1jReSIiF5ZYk0HJG3j1BtFyUi4-', '$2y$13$bq8x80nlkwvGKmaxRIToh.PGdf.7DLBrXFKLXKbaqCWSAwe77Fs4a', NULL, NULL, NULL, '1harun.tofik@gmail.com', 1, 1, 1451655795, 1455246269, 1455246269),
3542(92, '1haifahrul', 'w6sF-zQEK5jsN1-cN9LxKgIThiGLY_0z', '$2y$13$klKG2OpMiFhazSXbEHdadO.UffInmEvcW4cOBMraq.KCxZNg/2Hku', NULL, NULL, NULL, '1haifahrul@gmail.com', 1, 1, 1451975700, 1456135537, 1456135537),
3543(93, 'Miltondow', 'VfmoJE3xbJc2rQ1WrL60ZJP2GRuGweDq', '$2y$13$MhzuHNBiV8bTB4Ogp7gTg.GPJrZcy0OtVuYaKc8iPiHRCf3qfEwHC', NULL, NULL, NULL, '1a.n.ton.m.e.lnik.o.v6.2.9@gmail.com', 0, 1, NULL, NULL, NULL),
3544(96, 'haifahrul', 'd2C0ZLUqhtYlTWV-GYO6J4uIJtBs1JFE', '$2y$13$CsGCbt22vELs0Jro4ZRTyOJHxE6JnCXBB7qcCZzDYzFrTOuk48gCa', 'Z-21J_cznfxmb8VD2W2F0TK8SivuEctC_1454646903', NULL, NULL, 'haifahrul@gmail.com', 1, 1, 1454557616, 1456369874, 1456369874);
3545
3546-- --------------------------------------------------------
3547
3548--
3549-- Table structure for table `user_profile`
3550--
3551
3552CREATE TABLE IF NOT EXISTS `user_profile` (
3553 `user_id` int(11) NOT NULL AUTO_INCREMENT,
3554 `firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3555 `middlename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3556 `lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3557 `phone_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3558 `other_phone_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3559 `ktp_number` bigint(20) DEFAULT NULL,
3560 `birth_place` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3561 `birth_date` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3562 `gender` smallint(1) DEFAULT NULL,
3563 `address` varchar(114) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3564 `postal_code` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3565 `religion` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3566 `country` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3567 `status_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3568 `locale` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3569 `avatar_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3570 `avatar_base_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3571 `attributes_1` int(30) DEFAULT NULL,
3572 `attributes_2` int(30) DEFAULT NULL,
3573 `attributes_3` int(30) DEFAULT NULL,
3574 `attributes_4` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3575 `attributes_5` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3576 `attributes_6` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3577 PRIMARY KEY (`user_id`)
3578) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ;
3579
3580--
3581-- Dumping data for table `user_profile`
3582--
3583
3584INSERT INTO `user_profile` (`user_id`, `firstname`, `middlename`, `lastname`, `phone_number`, `other_phone_number`, `ktp_number`, `birth_place`, `birth_date`, `gender`, `address`, `postal_code`, `religion`, `country`, `status_user`, `locale`, `avatar_path`, `avatar_base_url`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
3585(1, 'Administrator', 'Veboo', '', '', '', NULL, '', '2016-01-07', 1, 'jalan condet raya \r\nJakarta Timur ', '12870', '', 'Indonesia', 'Lajang', 'en-US', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL),
3586(6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3587(7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3588(9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3589(17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3590(18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3591(19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3592(20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3593(22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3594(24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3595(29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3596(30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3597(31, 'Arief', '', 'Budiman', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3598(33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en-US', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3599(91, 'Saran', 'PT Sarana Transport Jakarta', 'Transport', '08111751214', '', NULL, '', '2007-11-13', 1, 'Condet', '16340', NULL, 'Indonesia', 'Lajang', 'en-US', 'gxKAw4fR1-CaSS9G1RU1oq1kqgRjH7Ky.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3600(92, '', '', '', '', '', NULL, '', '1992-01-01', 2, '', '', NULL, '', '', 'id', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3601(93, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
3602(96, 'haifahrul', 'Hi Tech', '', '', '', NULL, '', '1992-01-30', 1, '', '', '2', '', '1', 'en-US', 'Ki2D72nA3OkwoX3xo3JoRaPShNJC-_mJ.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
3603
3604-- --------------------------------------------------------
3605
3606--
3607-- Table structure for table `warehouse`
3608--
3609
3610CREATE TABLE IF NOT EXISTS `warehouse` (
3611 `warehouse_id` int(11) NOT NULL AUTO_INCREMENT,
3612 `customer_id` int(11) NOT NULL,
3613 `email` varchar(30) CHARACTER SET latin1 NOT NULL,
3614 `name` varchar(114) CHARACTER SET latin1 NOT NULL,
3615 `address` varchar(114) CHARACTER SET latin1 DEFAULT NULL,
3616 `postal_code` varchar(11) CHARACTER SET latin1 DEFAULT NULL,
3617 `telephone` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
3618 `longitude` varchar(114) DEFAULT NULL,
3619 `latitude` varchar(114) DEFAULT NULL,
3620 `pic` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
3621 `attributes_1` int(30) DEFAULT NULL,
3622 `attributes_2` int(30) DEFAULT NULL,
3623 `attributes_3` int(30) DEFAULT NULL,
3624 `attributes_4` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
3625 `attributes_5` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
3626 `attributes_6` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
3627 PRIMARY KEY (`warehouse_id`),
3628 KEY `FK_FK_MC_W` (`customer_id`)
3629) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
3630
3631--
3632-- Dumping data for table `warehouse`
3633--
3634
3635INSERT INTO `warehouse` (`warehouse_id`, `customer_id`, `email`, `name`, `address`, `postal_code`, `telephone`, `longitude`, `latitude`, `pic`, `attributes_1`, `attributes_2`, `attributes_3`, `attributes_4`, `attributes_5`, `attributes_6`) VALUES
3636(1, 100029, 'asd@gmail.com', 'sad', 'asd', '22', '22', '2', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
3637
3638-- --------------------------------------------------------
3639
3640--
3641-- Table structure for table `widget_carousel`
3642--
3643
3644CREATE TABLE IF NOT EXISTS `widget_carousel` (
3645 `id` int(11) NOT NULL AUTO_INCREMENT,
3646 `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3647 `status` smallint(6) DEFAULT '0',
3648 PRIMARY KEY (`id`)
3649) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
3650
3651--
3652-- Dumping data for table `widget_carousel`
3653--
3654
3655INSERT INTO `widget_carousel` (`id`, `key`, `status`) VALUES
3656(3, 'home-slide', 1);
3657
3658-- --------------------------------------------------------
3659
3660--
3661-- Table structure for table `widget_carousel_item`
3662--
3663
3664CREATE TABLE IF NOT EXISTS `widget_carousel_item` (
3665 `id` int(11) NOT NULL AUTO_INCREMENT,
3666 `carousel_id` int(11) NOT NULL,
3667 `base_url` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3668 `path` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3669 `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3670 `url` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3671 `caption` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
3672 `status` smallint(6) NOT NULL DEFAULT '0',
3673 `order` int(11) DEFAULT '0',
3674 `created_at` int(11) DEFAULT NULL,
3675 `updated_at` int(11) DEFAULT NULL,
3676 PRIMARY KEY (`id`),
3677 KEY `fk_item_carousel` (`carousel_id`)
3678) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
3679
3680--
3681-- Dumping data for table `widget_carousel_item`
3682--
3683
3684INSERT INTO `widget_carousel_item` (`id`, `carousel_id`, `base_url`, `path`, `type`, `url`, `caption`, `status`, `order`, `created_at`, `updated_at`) VALUES
3685(10, 3, 'http://localhost/veboo/storage/web/source', '1/lIpozo1_nMQtJrsgDwd2me7ECMjMl4eh.jpg', 'image/jpeg', '', '', 1, 1, 1453716328, 1454152540),
3686(11, 3, 'http://localhost/veboo/storage/web/source', '1/zvwf1u-auzTW0ABJxSFPWSxQX9Gn-Eqf.jpg', 'image/jpeg', '', '', 1, 2, 1453716336, 1454152549),
3687(12, 3, 'http://localhost/veboo/storage/web/source', '1/HuRyHJQiQdrNntyG-y1Ge2hjFehy1MLJ.jpg', 'image/jpeg', '', '', 1, 3, 1453716345, 1454152557);
3688
3689-- --------------------------------------------------------
3690
3691--
3692-- Table structure for table `widget_menu`
3693--
3694
3695CREATE TABLE IF NOT EXISTS `widget_menu` (
3696 `id` int(11) NOT NULL AUTO_INCREMENT,
3697 `key` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3698 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3699 `items` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3700 `status` smallint(6) NOT NULL DEFAULT '0',
3701 PRIMARY KEY (`id`)
3702) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
3703
3704--
3705-- Dumping data for table `widget_menu`
3706--
3707
3708INSERT INTO `widget_menu` (`id`, `key`, `title`, `items`, `status`) VALUES
3709(1, 'frontend-index', 'Frontend index menu', '[\r\n {\r\n "label": "Get started with Yii2",\r\n "url": "http://www.yiiframework.com",\r\n "options": {\r\n "tag": "span"\r\n },\r\n "template": "<a href=\\"{url}\\" class=\\"btn btn-lg btn-success\\">{label}</a>",\r\n "visible": "Yii::$app->user->isGuest"\r\n },\r\n {\r\n "label": "Yii2 Starter Kit on GitHub",\r\n "url": "https://github.com/trntv/yii2-starter-kit",\r\n "options": {\r\n "tag": "span"\r\n },\r\n "template": "<a href=\\"{url}\\" class=\\"btn btn-lg btn-primary\\">{label}</a>"\r\n },\r\n {\r\n "label": "Find a bug?",\r\n "url": "https://github.com/trntv/yii2-starter-kit/issues",\r\n "options": {\r\n "tag": "span"\r\n },\r\n "template": "<a href=\\"{url}\\" class=\\"btn btn-lg btn-danger\\">{label}</a>"\r\n }\r\n]', 1);
3710
3711-- --------------------------------------------------------
3712
3713--
3714-- Table structure for table `widget_text`
3715--
3716
3717CREATE TABLE IF NOT EXISTS `widget_text` (
3718 `id` int(11) NOT NULL AUTO_INCREMENT,
3719 `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3720 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3721 `body` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
3722 `status` smallint(6) DEFAULT NULL,
3723 `created_at` int(11) DEFAULT NULL,
3724 `updated_at` int(11) DEFAULT NULL,
3725 PRIMARY KEY (`id`),
3726 KEY `idx_widget_text_key` (`key`)
3727) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
3728
3729--
3730-- Dumping data for table `widget_text`
3731--
3732
3733INSERT INTO `widget_text` (`id`, `key`, `title`, `body`, `status`, `created_at`, `updated_at`) VALUES
3734(1, 'the_problem', 'The Problem', 'The Problem', 1, 1453101289, 1453103706),
3735(2, 'the_problem_post_1', 'The Problem Post 1', 'The most vehicle provider problem, they have huge investment on asset for doing the business and mostly the asset utilization not achieve the target, too many asset un-utilized, because they only support for small customers. It does become an expense and difficult to growth the business. They need more customers and continuous order from customers.', 1, 1453100388, 1453103723),
3736(3, 'the_problem_post_2', 'The Problem Post 2', 'Veboo is market place for customers and providers. They could collaborate to improve their service together, when customers need vehicles, with easy step customers can search available vehicle with certain term and condition then they could book it. New evolution in supply chain and logistics commerce to make good service and competitive price.', 1, 1453103096, 1453103096),
3737(4, 'the_problem_post_3', 'The Problem Post 3', 'When customers need vehicle with competitive price they can broadcast their demand on this platform, specifically this system will send information to provider regarding of customer demand then vehicle provider offer their services.', 1, 1453103096, 1453104015),
3738(5, 'the_problem_post_4', 'The Problem Post 4', 'Vehicle provider needs a support system for archiving transaction: booking, order, invoicing, operational cost, maintenance. Mostly the company operate vehicles they did not has a good system, manually keep transaction in excel.', 1, 1453103096, 1453104181),
3739(6, 'footer_text', 'Footer Text', 'Copyright @ 2015 - VEBOO - All Right Service - Privacy Statment | Terms and Conditions', 1, 1453103096, 1453103096),
3740(7, 'contact_phone', 'Contact Phone', ' +62 21 - 80879546', 1, 1453103096, 1453103096),
3741(8, 'site_book', 'Book', 'Get more opportunity with our thousand customers, You can list all your vehicles and manage transaction by yourself. VEBOO will send you book notification in your smart-phone', 1, 1453103096, 1453103096),
3742(9, 'site_track', 'Track', 'Track your vehicle when ever its go. This solution lets vehicle owner to track objects in real time, view historical tracks and be notified events that requires your attention and reports', 1, 1453103096, 1453103096),
3743(10, 'site_share', 'Share', 'Our platform will help you to generate new lead, when your vehicle is available to book. Our customers will choose your vehicle to pick up / rent or make the deal with customers', 1, 1453103096, 1453103096),
3744(11, 'email_create_opportunity_1', 'Email Dear Provider via Create Broadcast Opportunity', 'Dear Provider,', 1, 1455870961, 1455870961),
3745(12, 'email_create_opportunity_2', 'informasi peluang muatan', 'Berikut peluang muatan atau sewa yang dikirim oleh pelanggan dan\r\nsesuai dengan lokasi service atau kendaraan anda. <br><br>\r\nUntuk mengirimkan penawaran, silahkan klik tombol dibawah ini:', 1, 1455871107, 1455871107),
3746(13, 'email_create_opportunity_3', 'Ucapan Terima kasih', 'Terima kasih karena telah menggunakan layanan kami.', 1, 1455871406, 1455871406);
3747
3748--
3749-- Constraints for dumped tables
3750--
3751
3752--
3753-- Constraints for table `article`
3754--
3755ALTER TABLE `article`
3756 ADD CONSTRAINT `fk_article_author` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
3757 ADD CONSTRAINT `fk_article_category` FOREIGN KEY (`category_id`) REFERENCES `article_category` (`id`),
3758 ADD CONSTRAINT `fk_article_updater` FOREIGN KEY (`updater_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
3759
3760--
3761-- Constraints for table `article_attachment`
3762--
3763ALTER TABLE `article_attachment`
3764 ADD CONSTRAINT `fk_article_attachment_article` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3765
3766--
3767-- Constraints for table `article_category`
3768--
3769ALTER TABLE `article_category`
3770 ADD CONSTRAINT `fk_article_category_section` FOREIGN KEY (`parent_id`) REFERENCES `article_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3771
3772--
3773-- Constraints for table `book`
3774--
3775ALTER TABLE `book`
3776 ADD CONSTRAINT `FK_FK_MV_B2` FOREIGN KEY (`vehicle_id`) REFERENCES `master_vehicle` (`vehicle_id`) ON DELETE CASCADE ON UPDATE CASCADE;
3777
3778--
3779-- Constraints for table `driver`
3780--
3781ALTER TABLE `driver`
3782 ADD CONSTRAINT `FK_FK_MV_D` FOREIGN KEY (`vehicle_id`) REFERENCES `master_vehicle` (`vehicle_id`) ON UPDATE CASCADE;
3783
3784--
3785-- Constraints for table `i18n_message`
3786--
3787ALTER TABLE `i18n_message`
3788 ADD CONSTRAINT `fk_i18n_message_source_message` FOREIGN KEY (`id`) REFERENCES `i18n_source_message` (`id`) ON DELETE CASCADE;
3789
3790--
3791-- Constraints for table `invoice`
3792--
3793ALTER TABLE `invoice`
3794 ADD CONSTRAINT `FK_FK_O_I` FOREIGN KEY (`order_id`) REFERENCES `order` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3795 ADD CONSTRAINT `FK_invoice_master_customer` FOREIGN KEY (`customer_id`) REFERENCES `master_customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
3796 ADD CONSTRAINT `FK_invoice_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
3797
3798--
3799-- Constraints for table `maintenance_trx`
3800--
3801ALTER TABLE `maintenance_trx`
3802 ADD CONSTRAINT `FK_FK_MV_MT` FOREIGN KEY (`vehicle_id`) REFERENCES `master_vehicle` (`vehicle_id`);
3803
3804--
3805-- Constraints for table `master_vehicle`
3806--
3807ALTER TABLE `master_vehicle`
3808 ADD CONSTRAINT `FK_FK_U_MV` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
3809
3810--
3811-- Constraints for table `menu`
3812--
3813ALTER TABLE `menu`
3814 ADD CONSTRAINT `FK_menu_menu` FOREIGN KEY (`parent`) REFERENCES `menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3815
3816--
3817-- Constraints for table `notification`
3818--
3819ALTER TABLE `notification`
3820 ADD CONSTRAINT `FK_notification_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3821
3822--
3823-- Constraints for table `offering_service`
3824--
3825ALTER TABLE `offering_service`
3826 ADD CONSTRAINT `FK_offering_service_master_customer` FOREIGN KEY (`customer_id`) REFERENCES `master_customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
3827 ADD CONSTRAINT `FK_offering_service_opportunities` FOREIGN KEY (`opportunities_id`) REFERENCES `opportunities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
3828 ADD CONSTRAINT `FK_offering_service_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3829
3830--
3831-- Constraints for table `operation_cost`
3832--
3833ALTER TABLE `operation_cost`
3834 ADD CONSTRAINT `operation_cost_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `order` (`order_id`) ON DELETE CASCADE ON UPDATE CASCADE;
3835
3836--
3837-- Constraints for table `opportunities`
3838--
3839ALTER TABLE `opportunities`
3840 ADD CONSTRAINT `FK_opportunities_master_customer` FOREIGN KEY (`customer_id`) REFERENCES `master_customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3841
3842--
3843-- Constraints for table `order`
3844--
3845ALTER TABLE `order`
3846 ADD CONSTRAINT `FK_FK_B_O` FOREIGN KEY (`book_id`) REFERENCES `book` (`book_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3847 ADD CONSTRAINT `FK_order_master_customer` FOREIGN KEY (`customer_id`) REFERENCES `master_customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
3848 ADD CONSTRAINT `FK_order_master_vehicle` FOREIGN KEY (`vehicle_id`) REFERENCES `master_vehicle` (`vehicle_id`) ON DELETE CASCADE ON UPDATE CASCADE;
3849
3850--
3851-- Constraints for table `payment`
3852--
3853ALTER TABLE `payment`
3854 ADD CONSTRAINT `FK_payment_invoice` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`invoice_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3855 ADD CONSTRAINT `FK_payment_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3856
3857--
3858-- Constraints for table `price_list`
3859--
3860ALTER TABLE `price_list`
3861 ADD CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3862
3863--
3864-- Constraints for table `rbac_auth_assignment`
3865--
3866ALTER TABLE `rbac_auth_assignment`
3867 ADD CONSTRAINT `rbac_auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `rbac_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
3868
3869--
3870-- Constraints for table `rbac_auth_item`
3871--
3872ALTER TABLE `rbac_auth_item`
3873 ADD CONSTRAINT `rbac_auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `rbac_auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE;
3874
3875--
3876-- Constraints for table `rbac_auth_item_child`
3877--
3878ALTER TABLE `rbac_auth_item_child`
3879 ADD CONSTRAINT `rbac_auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `rbac_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
3880 ADD CONSTRAINT `rbac_auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `rbac_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
3881
3882--
3883-- Constraints for table `service_area`
3884--
3885ALTER TABLE `service_area`
3886 ADD CONSTRAINT `FK_FK_U_SA` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
3887
3888--
3889-- Constraints for table `subscribe`
3890--
3891ALTER TABLE `subscribe`
3892 ADD CONSTRAINT `FK_FK_S_U` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
3893
3894--
3895-- Constraints for table `user_profile`
3896--
3897ALTER TABLE `user_profile`
3898 ADD CONSTRAINT `fk_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
3899
3900--
3901-- Constraints for table `widget_carousel_item`
3902--
3903ALTER TABLE `widget_carousel_item`
3904 ADD CONSTRAINT `fk_item_carousel` FOREIGN KEY (`carousel_id`) REFERENCES `widget_carousel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;