API tools faq
paste
Advertisement
Guest User

Sibu.sql

a guest
Mar 29th, 2018
829
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 51.91 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.7
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost:3306
  6. -- Generation Time: Mar 30, 2018 at 12:26 AM
  7. -- Server version: 10.1.32-MariaDB
  8. -- PHP Version: 5.6.30
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `kflegacy_carrental`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `bsi_admin`
  29. --
  30.  
  31. CREATE TABLE `bsi_admin` (
  32. `id` int(11) NOT NULL,
  33. `pass` varchar(255) CHARACTER SET latin1 NOT NULL,
  34. `username` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT 'admin',
  35. `access_id` int(1) NOT NULL DEFAULT '0',
  36. `f_name` varchar(255) CHARACTER SET latin1 NOT NULL,
  37. `l_name` varchar(255) CHARACTER SET latin1 NOT NULL,
  38. `email` varchar(255) CHARACTER SET latin1 NOT NULL,
  39. `designation` varchar(255) CHARACTER SET latin1 NOT NULL,
  40. `last_login` timestamp NULL DEFAULT NULL,
  41. `status` tinyint(1) NOT NULL DEFAULT '1'
  42. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
  43.  
  44. --
  45. -- Dumping data for table `bsi_admin`
  46. --
  47.  
  48. INSERT INTO `bsi_admin` (`id`, `pass`, `username`, `access_id`, `f_name`, `l_name`, `email`, `designation`, `last_login`, `status`) VALUES
  49. (1, 'c2c7ee7885ddbc2a6bef717da2563f94', 'Administrator', 1, 'MOHAMAD FAIZAN', 'ABDUL RAHMAN', 'enquiry@sibucarrental.com', 'Administrator', '2018-03-29 16:16:46', 1);
  50.  
  51. -- --------------------------------------------------------
  52.  
  53. --
  54. -- Table structure for table `bsi_adminmenu`
  55. --
  56.  
  57. CREATE TABLE `bsi_adminmenu` (
  58. `id` int(4) NOT NULL,
  59. `name` varchar(200) NOT NULL DEFAULT '',
  60. `url` varchar(200) DEFAULT NULL,
  61. `menu_desc` varchar(200) NOT NULL DEFAULT '',
  62. `parent_id` int(4) DEFAULT '0',
  63. `status` enum('Y','N') DEFAULT 'Y',
  64. `ord` int(5) NOT NULL DEFAULT '0',
  65. `privileges` int(11) NOT NULL
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  67.  
  68. --
  69. -- Dumping data for table `bsi_adminmenu`
  70. --
  71.  
  72. INSERT INTO `bsi_adminmenu` (`id`, `name`, `url`, `menu_desc`, `parent_id`, `status`, `ord`, `privileges`) VALUES
  73. (1, 'CAR MANAGER', '#', '', 0, 'Y', 1, 1),
  74. (2, 'PRICE MANAGER', '#', '', 0, 'Y', 2, 1),
  75. (3, 'BOOKING MANAGER', '#', '', 0, 'Y', 3, 1),
  76. (4, 'SETTING', '#', '', 0, 'Y', 7, 1),
  77. (5, ' Car List', 'car-list.php', '', 1, 'Y', 1, 1),
  78. (6, 'Car Vendors', 'car-vendors.php', '', 1, 'Y', 2, 1),
  79. (7, ' Car Types', 'car-types.php', '', 1, 'Y', 3, 1),
  80. (8, 'Car Features', 'car-features.php', '', 1, 'Y', 4, 1),
  81. (9, 'Deposit Amount Setting ', 'deposit-duration.php', '', 2, 'Y', 2, 1),
  82. (10, 'Car Extras', 'car-extras.php', '', 2, 'Y', 4, 1),
  83. (11, 'Booking List', 'booking-list.php', '', 3, 'Y', 1, 1),
  84. (12, 'Customer Lookup', 'customer-lookup.php', '', 3, 'Y', 2, 1),
  85. (13, 'Car Blocking', 'car-blocking.php', '', 3, 'Y', 3, 1),
  86. (14, 'Global Setting', 'global-setting.php', '', 4, 'Y', 1, 1),
  87. (15, 'Payment Gateway', 'payment-gateway.php', '', 4, 'Y', 2, 1),
  88. (16, 'Email Contents', 'email-contents.php', '', 4, 'Y', 3, 1),
  89. (17, 'Discount upon duration', 'discount-duration.php', '', 2, 'Y', 3, 1),
  90. (18, 'Price Calculation Setup', 'price-calculation.php', '', 2, 'Y', 0, 1),
  91. (19, 'Location Manager', 'location_list.php', '', 1, 'Y', 6, 1),
  92. (20, 'Close Day Setting', 'close_day.php', '', 4, 'Y', 5, 1),
  93. (72, 'Admin Menu Manager', 'adminmenu.list.php', '', 4, 'Y', 6, 0),
  94. (73, 'LANGUAGE MANAGER', '#', '', 0, 'Y', 6, 0),
  95. (74, 'Manage Languages', 'manage_langauge.php', '', 73, 'Y', 1, 0),
  96. (75, 'Car Price Plan', 'priceplan_list.php', '', 2, 'Y', 1, 0);
  97.  
  98. -- --------------------------------------------------------
  99.  
  100. --
  101. -- Table structure for table `bsi_all_location`
  102. --
  103.  
  104. CREATE TABLE `bsi_all_location` (
  105. `loc_id` int(11) NOT NULL,
  106. `location_title` varchar(500) NOT NULL
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  108.  
  109. --
  110. -- Dumping data for table `bsi_all_location`
  111. --
  112.  
  113. INSERT INTO `bsi_all_location` (`loc_id`, `location_title`) VALUES
  114. (1, 'Sibu - Boat Express Terminal'),
  115. (2, 'Sibu - Airport'),
  116. (3, 'Sibu - Bus Terminal'),
  117. (4, 'Sibu - Others');
  118.  
  119. -- --------------------------------------------------------
  120.  
  121. --
  122. -- Table structure for table `bsi_bookings`
  123. --
  124.  
  125. CREATE TABLE `bsi_bookings` (
  126. `booking_id` int(10) NOT NULL,
  127. `booking_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  128. `pickup_datetime` datetime NOT NULL,
  129. `dropoff_datetime` datetime NOT NULL,
  130. `client_id` int(11) UNSIGNED DEFAULT NULL,
  131. `discount_coupon` varchar(50) DEFAULT NULL,
  132. `total_cost` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  133. `payment_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  134. `payment_type` varchar(255) NOT NULL,
  135. `payment_success` tinyint(1) NOT NULL DEFAULT '0',
  136. `payment_txnid` varchar(100) DEFAULT NULL,
  137. `paypal_email` varchar(500) DEFAULT NULL,
  138. `special_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  139. `special_requests` text,
  140. `is_block` tinyint(4) NOT NULL DEFAULT '0',
  141. `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
  142. `block_name` varchar(255) DEFAULT NULL,
  143. `pick_loc` varchar(255) DEFAULT NULL,
  144. `drop_loc` varchar(255) DEFAULT NULL
  145. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  146.  
  147. --
  148. -- Dumping data for table `bsi_bookings`
  149. --
  150.  
  151. INSERT INTO `bsi_bookings` (`booking_id`, `booking_time`, `pickup_datetime`, `dropoff_datetime`, `client_id`, `discount_coupon`, `total_cost`, `payment_amount`, `payment_type`, `payment_success`, `payment_txnid`, `paypal_email`, `special_id`, `special_requests`, `is_block`, `is_deleted`, `block_name`, `pick_loc`, `drop_loc`) VALUES
  152. (1522214912, '2018-03-28 05:28:32', '2018-03-29 10:00:00', '2018-03-30 10:00:00', 3, NULL, '0.00', '0.00', 'poa', 1, NULL, NULL, 0, NULL, 0, 0, NULL, 'Sibu - Airport', 'Sibu - Airport'),
  153. (1522252227, '2018-03-28 15:50:27', '2018-04-04 09:00:00', '2018-04-08 09:00:00', 4, NULL, '0.00', '0.00', 'poa', 1, NULL, NULL, 0, NULL, 0, 0, NULL, 'Sibu - Airport', 'Sibu - Bus Terminal'),
  154. (1522330824, '2018-03-29 13:40:24', '2018-03-30 09:00:00', '2018-03-31 09:00:00', 5, NULL, '101.00', '20.20', 'poa', 1, NULL, NULL, 0, NULL, 0, 0, NULL, 'Sibu - Airport', 'Sibu - Airport'),
  155. (1522332541, '2018-03-29 14:09:01', '2018-03-29 09:00:00', '2018-03-31 09:00:00', 5, NULL, '161.60', '32.32', 'poa', 1, NULL, NULL, 0, NULL, 0, 0, NULL, 'Sibu - Airport', 'Sibu - Boat Express Terminal');
  156.  
  157. -- --------------------------------------------------------
  158.  
  159. --
  160. -- Table structure for table `bsi_car_extras`
  161. --
  162.  
  163. CREATE TABLE `bsi_car_extras` (
  164. `id` int(11) NOT NULL,
  165. `car_extras` varchar(255) NOT NULL,
  166. `price` decimal(10,2) NOT NULL
  167. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  168.  
  169. --
  170. -- Dumping data for table `bsi_car_extras`
  171. --
  172.  
  173. INSERT INTO `bsi_car_extras` (`id`, `car_extras`, `price`) VALUES
  174. (1, 'Driver', '100.00'),
  175. (2, 'GPS Navigation', '50.00'),
  176. (3, 'Baby Car Seat', '15.00');
  177.  
  178. -- --------------------------------------------------------
  179.  
  180. --
  181. -- Table structure for table `bsi_car_features`
  182. --
  183.  
  184. CREATE TABLE `bsi_car_features` (
  185. `id` int(11) NOT NULL,
  186. `features_title` varchar(255) NOT NULL
  187. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  188.  
  189. --
  190. -- Dumping data for table `bsi_car_features`
  191. --
  192.  
  193. INSERT INTO `bsi_car_features` (`id`, `features_title`) VALUES
  194. (1, 'Automatic Transmission'),
  195. (2, 'Manual Transmission'),
  196. (3, '4 Doors'),
  197. (4, '5 Passanger'),
  198. (5, '7 Passanger'),
  199. (6, '12 Passanger'),
  200. (7, 'Leather Seat'),
  201. (8, '2 Suitcases'),
  202. (9, '1 Suitcases'),
  203. (10, '4 Passanger'),
  204. (11, '4 Suitcases'),
  205. (12, 'Air Conditioning');
  206.  
  207. -- --------------------------------------------------------
  208.  
  209. --
  210. -- Table structure for table `bsi_car_location`
  211. --
  212.  
  213. CREATE TABLE `bsi_car_location` (
  214. `car_id` int(11) NOT NULL,
  215. `loc_id` int(11) NOT NULL,
  216. `loc_type` int(11) NOT NULL
  217. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  218.  
  219. --
  220. -- Dumping data for table `bsi_car_location`
  221. --
  222.  
  223. INSERT INTO `bsi_car_location` (`car_id`, `loc_id`, `loc_type`) VALUES
  224. (1, 1, 1),
  225. (1, 4, 1),
  226. (1, 3, 1),
  227. (1, 2, 1),
  228. (1, 1, 2),
  229. (1, 4, 2),
  230. (1, 3, 2),
  231. (1, 2, 2),
  232. (2, 1, 1),
  233. (2, 4, 1),
  234. (2, 3, 1),
  235. (2, 2, 1),
  236. (2, 1, 2),
  237. (2, 4, 2),
  238. (2, 3, 2),
  239. (2, 2, 2),
  240. (3, 1, 1),
  241. (3, 4, 1),
  242. (3, 3, 1),
  243. (3, 2, 1),
  244. (3, 1, 2),
  245. (3, 4, 2),
  246. (3, 3, 2),
  247. (3, 2, 2),
  248. (4, 2, 1),
  249. (4, 1, 1),
  250. (4, 3, 1),
  251. (4, 4, 1),
  252. (4, 2, 2),
  253. (4, 1, 2),
  254. (4, 3, 2),
  255. (4, 4, 2),
  256. (5, 2, 1),
  257. (5, 1, 1),
  258. (5, 3, 1),
  259. (5, 4, 1),
  260. (5, 2, 2),
  261. (5, 1, 2),
  262. (5, 3, 2),
  263. (5, 4, 2),
  264. (6, 2, 1),
  265. (6, 1, 1),
  266. (6, 3, 1),
  267. (6, 4, 1),
  268. (6, 2, 2),
  269. (6, 1, 2),
  270. (6, 3, 2),
  271. (6, 4, 2);
  272.  
  273. -- --------------------------------------------------------
  274.  
  275. --
  276. -- Table structure for table `bsi_car_master`
  277. --
  278.  
  279. CREATE TABLE `bsi_car_master` (
  280. `car_id` int(11) NOT NULL,
  281. `car_type_id` int(11) NOT NULL,
  282. `car_vendor_id` int(11) NOT NULL,
  283. `car_model` varchar(255) NOT NULL,
  284. `car_img` varchar(255) NOT NULL,
  285. `mileage` varchar(50) NOT NULL,
  286. `fuel_type` varchar(255) NOT NULL,
  287. `total_car` int(11) NOT NULL,
  288. `status` tinyint(1) NOT NULL
  289. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  290.  
  291. --
  292. -- Dumping data for table `bsi_car_master`
  293. --
  294.  
  295. INSERT INTO `bsi_car_master` (`car_id`, `car_type_id`, `car_vendor_id`, `car_model`, `car_img`, `mileage`, `fuel_type`, `total_car`, `status`) VALUES
  296. (1, 1, 1, 'Viva Elite 1.0 (A)', '1522081364_viva-front.jpg', '', 'Petrol', 1, 1),
  297. (2, 1, 1, 'Viva 850 (M)', '1522081403_viva-front.jpg', '', 'Petrol', 2, 1),
  298. (3, 4, 1, 'Bezza 1.0', '1522081468_perodua-bezza.jpg', '', 'Petrol', 1, 1),
  299. (4, 1, 1, 'Kancil 850 (A)', '1522127639_GKR00G.jpg', '', 'Petrol', 1, 1),
  300. (5, 4, 2, 'Saga 1.3 (A)', '1522127776_proton-saga.jpg', '', 'Petrol', 1, 1),
  301. (6, 4, 1, 'Myvi 1.3 (A)', '1522127962_myvi.jpg', '', 'Petrol', 1, 1);
  302.  
  303. -- --------------------------------------------------------
  304.  
  305. --
  306. -- Table structure for table `bsi_car_priceplan`
  307. --
  308.  
  309. CREATE TABLE `bsi_car_priceplan` (
  310. `pp_id` int(10) NOT NULL,
  311. `car_id` int(10) NOT NULL,
  312. `start_date` date NOT NULL,
  313. `end_date` date NOT NULL,
  314. `price_type` int(1) NOT NULL,
  315. `mon` decimal(10,2) NOT NULL,
  316. `tue` decimal(10,2) NOT NULL,
  317. `wed` decimal(10,2) NOT NULL,
  318. `thu` decimal(10,2) NOT NULL,
  319. `fri` decimal(10,2) NOT NULL,
  320. `sat` decimal(10,2) NOT NULL,
  321. `sun` decimal(10,2) NOT NULL,
  322. `default_price` tinyint(4) NOT NULL DEFAULT '1'
  323. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  324.  
  325. --
  326. -- Dumping data for table `bsi_car_priceplan`
  327. --
  328.  
  329. INSERT INTO `bsi_car_priceplan` (`pp_id`, `car_id`, `start_date`, `end_date`, `price_type`, `mon`, `tue`, `wed`, `thu`, `fri`, `sat`, `sun`, `default_price`) VALUES
  330. (1, 1, '1900-01-01', '1900-01-01', 1, '100.00', '100.00', '100.00', '100.00', '100.00', '100.00', '100.00', 1),
  331. (2, 1, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1),
  332. (3, 2, '1900-01-01', '1900-01-01', 1, '100.00', '100.00', '100.00', '100.00', '100.00', '100.00', '100.00', 1),
  333. (4, 2, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1),
  334. (5, 3, '1900-01-01', '1900-01-01', 1, '140.00', '140.00', '140.00', '140.00', '140.00', '140.00', '140.00', 1),
  335. (6, 3, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1),
  336. (7, 4, '1900-01-01', '1900-01-01', 1, '80.00', '80.00', '80.00', '80.00', '80.00', '80.00', '80.00', 1),
  337. (8, 4, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1),
  338. (9, 5, '1900-01-01', '1900-01-01', 1, '130.00', '130.00', '130.00', '130.00', '130.00', '130.00', '130.00', 1),
  339. (10, 5, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1),
  340. (11, 6, '1900-01-01', '1900-01-01', 1, '120.00', '120.00', '120.00', '120.00', '120.00', '120.00', '120.00', 1),
  341. (12, 6, '1900-01-01', '1900-01-01', 2, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 1);
  342.  
  343. -- --------------------------------------------------------
  344.  
  345. --
  346. -- Table structure for table `bsi_car_type`
  347. --
  348.  
  349. CREATE TABLE `bsi_car_type` (
  350. `id` int(11) NOT NULL,
  351. `type_title` varchar(255) NOT NULL
  352. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  353.  
  354. --
  355. -- Dumping data for table `bsi_car_type`
  356. --
  357.  
  358. INSERT INTO `bsi_car_type` (`id`, `type_title`) VALUES
  359. (1, 'Small Cars'),
  360. (2, 'Premium'),
  361. (3, 'MPV & Family Cars'),
  362. (4, 'Medium Cars');
  363.  
  364. -- --------------------------------------------------------
  365.  
  366. --
  367. -- Table structure for table `bsi_car_vendor`
  368. --
  369.  
  370. CREATE TABLE `bsi_car_vendor` (
  371. `id` int(11) NOT NULL,
  372. `vendor_title` varchar(255) NOT NULL
  373. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  374.  
  375. --
  376. -- Dumping data for table `bsi_car_vendor`
  377. --
  378.  
  379. INSERT INTO `bsi_car_vendor` (`id`, `vendor_title`) VALUES
  380. (1, 'PERODUA'),
  381. (2, 'PROTON'),
  382. (3, 'TOYOTA'),
  383. (4, 'NISSAN');
  384.  
  385. -- --------------------------------------------------------
  386.  
  387. --
  388. -- Table structure for table `bsi_clients`
  389. --
  390.  
  391. CREATE TABLE `bsi_clients` (
  392. `client_id` int(10) UNSIGNED NOT NULL,
  393. `first_name` varchar(64) DEFAULT NULL,
  394. `surname` varchar(64) DEFAULT NULL,
  395. `title` varchar(16) DEFAULT NULL,
  396. `street_addr` text,
  397. `city` varchar(64) DEFAULT NULL,
  398. `province` varchar(128) DEFAULT NULL,
  399. `zip` varchar(64) DEFAULT NULL,
  400. `country` varchar(64) DEFAULT NULL,
  401. `phone` varchar(64) DEFAULT NULL,
  402. `fax` varchar(64) DEFAULT NULL,
  403. `email` varchar(128) DEFAULT NULL,
  404. `additional_comments` text,
  405. `ip` varchar(32) DEFAULT NULL,
  406. `existing_client` tinyint(1) NOT NULL DEFAULT '0'
  407. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  408.  
  409. --
  410. -- Dumping data for table `bsi_clients`
  411. --
  412.  
  413. INSERT INTO `bsi_clients` (`client_id`, `first_name`, `surname`, `title`, `street_addr`, `city`, `province`, `zip`, `country`, `phone`, `fax`, `email`, `additional_comments`, `ip`, `existing_client`) VALUES
  414. (1, 'MOHAMAD FAIZAN', 'ABDUL RAHMAN', 'Mr.', 'NO. 44, JALAN KAMPUNG NANGKA', 'SIBU', 'SARAWAK', '96000', 'MALAYSIA', '0178591411', '084255507', 'faizanrahman84@gmail.com', NULL, '162.158.167.55', 1),
  415. (2, 'Mira Falisa', 'Rahman', 'Mr.', 'Lot 303, Lorong 4,, Jalan Sentosa Salim, Jalan Sentosa Salim', 'Sibu', 'Malaysia — Sarawak', '96000', 'Malaysia', '178591411', '', 'enquiry@sibucarrental.com', NULL, '172.68.146.27', 0),
  416. (3, 'CHIN', 'ZHI LIANG', 'Mr.', 'NO.68, JALAN INDAH 19/5, TAMAN BUKIT INDAH', 'JOHOR', 'JOHOR BAHRU', '81200', 'MALAYSIA', '0178591411', '', 'faizan@kflegacyresources.com', NULL, '162.158.167.55', 1),
  417. (4, 'Tony Ting Soon Siong', 'Ting', 'Mr.', 'MJC', 'Kuching', 'Good', '96000', 'Malaysia', '0198585520', '', 'tony840927ting@hotmail.my', NULL, '162.158.165.173', 1),
  418. (5, 'muhammad adib bin', 'roslan', 'Mr.', 'dfsdf', 'Rawang', 'SELANGOR', '48300', 'Malaysia', '0176213816', '', 'adbroslan@gmail.com', NULL, '172.69.134.142', 1);
  419.  
  420. -- --------------------------------------------------------
  421.  
  422. --
  423. -- Table structure for table `bsi_close_date`
  424. --
  425.  
  426. CREATE TABLE `bsi_close_date` (
  427. `closedt` varchar(50) NOT NULL
  428. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  429.  
  430. -- --------------------------------------------------------
  431.  
  432. --
  433. -- Table structure for table `bsi_configure`
  434. --
  435.  
  436. CREATE TABLE `bsi_configure` (
  437. `conf_id` int(11) NOT NULL,
  438. `conf_key` varchar(100) NOT NULL,
  439. `conf_value` varchar(500) DEFAULT NULL
  440. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  441.  
  442. --
  443. -- Dumping data for table `bsi_configure`
  444. --
  445.  
  446. INSERT INTO `bsi_configure` (`conf_id`, `conf_key`, `conf_value`) VALUES
  447. (1, 'conf_portal_name', 'Uncle Omen Car Rental'),
  448. (2, 'conf_portal_streetaddr', 'Lot 303, Lorong 4,, Jalan Sentosa Salim'),
  449. (3, 'conf_portal_city', 'Sibu'),
  450. (4, 'conf_portal_state', 'Sarawak'),
  451. (5, 'conf_portal_country', 'Malaysia'),
  452. (6, 'conf_portal_zipcode', '96000'),
  453. (7, 'conf_portal_phone', '0178591411'),
  454. (8, 'conf_portal_fax', '084-255507'),
  455. (9, 'conf_portal_email', 'enquiry@sibucarrental.com'),
  456. (13, 'conf_currency_symbol', 'RM'),
  457. (14, 'conf_currency_code', 'MYR'),
  458. (20, 'conf_tax_amount', '1'),
  459. (21, 'conf_dateformat', 'dd-mm-yy'),
  460. (22, 'conf_booking_exptime', '500'),
  461. (24, 'conf_enabled_discount', '1'),
  462. (25, 'conf_enabled_deposit', '1'),
  463. (26, 'conf_portal_timezone', 'Asia/Kuala_Lumpur'),
  464. (27, 'conf_booking_turn_off', '0'),
  465. (28, 'conf_min_night_booking', ''),
  466. (30, 'conf_notification_email', 'enquiry@sibucarrental.com'),
  467. (38, 'conf_pickup_location', '147 West 83rd Street, New York'),
  468. (39, 'conf_dropoff_location', 'same location'),
  469. (40, 'conf_interval_between_rent', '01:59:59'),
  470. (41, 'conf_price_calculation_type', '3'),
  471. (42, 'conf_booking_start', '0'),
  472. (43, 'conf_mesurment_unit', 'Km');
  473.  
  474. -- --------------------------------------------------------
  475.  
  476. --
  477. -- Table structure for table `bsi_deposit_duration`
  478. --
  479.  
  480. CREATE TABLE `bsi_deposit_duration` (
  481. `id` int(11) NOT NULL,
  482. `day_from` int(11) NOT NULL,
  483. `day_to` int(11) NOT NULL,
  484. `deposit_percent` decimal(10,2) NOT NULL
  485. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  486.  
  487. --
  488. -- Dumping data for table `bsi_deposit_duration`
  489. --
  490.  
  491. INSERT INTO `bsi_deposit_duration` (`id`, `day_from`, `day_to`, `deposit_percent`) VALUES
  492. (1, 5, 7, '20.00'),
  493. (2, 8, 14, '10.00'),
  494. (3, 15, 21, '10.00'),
  495. (4, 22, 30, '5.00'),
  496. (5, 1, 5, '20.00');
  497.  
  498. -- --------------------------------------------------------
  499.  
  500. --
  501. -- Table structure for table `bsi_discount_duration`
  502. --
  503.  
  504. CREATE TABLE `bsi_discount_duration` (
  505. `id` int(11) NOT NULL,
  506. `day_from` int(11) NOT NULL,
  507. `day_to` int(11) NOT NULL,
  508. `discount_percent` decimal(10,2) NOT NULL
  509. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  510.  
  511. --
  512. -- Dumping data for table `bsi_discount_duration`
  513. --
  514.  
  515. INSERT INTO `bsi_discount_duration` (`id`, `day_from`, `day_to`, `discount_percent`) VALUES
  516. (1, 5, 7, '20.00'),
  517. (2, 10, 14, '25.00'),
  518. (3, 15, 21, '25.00'),
  519. (4, 1, 4, '0.00');
  520.  
  521. -- --------------------------------------------------------
  522.  
  523. --
  524. -- Table structure for table `bsi_email_contents`
  525. --
  526.  
  527. CREATE TABLE `bsi_email_contents` (
  528. `id` int(11) NOT NULL,
  529. `email_name` varchar(500) NOT NULL,
  530. `email_subject` varchar(500) NOT NULL,
  531. `email_text` longtext NOT NULL
  532. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  533.  
  534. --
  535. -- Dumping data for table `bsi_email_contents`
  536. --
  537.  
  538. INSERT INTO `bsi_email_contents` (`id`, `email_name`, `email_subject`, `email_text`) VALUES
  539. (1, 'Confirmation Email', 'Confirmation of your successfull booking for that Apartment.', 'Text can be chnage in admin Panel.'),
  540. (2, 'Cancellation Email ', 'Cancellation Email subject.', 'Text Can be changed from admin panel');
  541.  
  542. -- --------------------------------------------------------
  543.  
  544. --
  545. -- Table structure for table `bsi_invoice`
  546. --
  547.  
  548. CREATE TABLE `bsi_invoice` (
  549. `booking_id` int(10) NOT NULL,
  550. `client_name` varchar(500) NOT NULL,
  551. `client_email` varchar(500) NOT NULL,
  552. `invoice` longtext NOT NULL
  553. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  554.  
  555. --
  556. -- Dumping data for table `bsi_invoice`
  557. --
  558.  
  559. INSERT INTO `bsi_invoice` (`booking_id`, `client_name`, `client_email`, `invoice`) VALUES
  560. (1522082427, 'Mr. MOHAMAD FAIZAN ABDUL RAHMAN', 'faizanrahman84@gmail.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Airport Sibu</td>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Airport Sibu</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">27-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">28-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 1 Days 0 Hours</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\r\n </tr><tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">Viva Elite 1.0 (A)</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM100.00</td>\r\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM100.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Prepaid Amount(<span style=\"font-size: 10px;\">100.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM0.00</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  561. (1522214024, 'Mr. MOHAMAD FAIZAN ABDUL RAHMAN', 'faizanrahman84@gmail.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">29-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">30-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 1 Days 0 Hours</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\r\n </tr><tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">Viva Elite 1.0 (A)</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM100.00</td>\r\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM100.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Prepaid Amount(<span style=\"font-size: 10px;\">100.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM0.00</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  562. (1522214496, 'Mr. MOHAMAD FAIZAN ABDUL RAHMAN', 'faizanrahman84@gmail.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">29-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">30-03-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 1 Days 0 Hours</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\r\n </tr><tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\">Medium Cars</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">Bezza 1.0</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM140.00</td>\r\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM140.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Prepaid Amount(<span style=\"font-size: 10px;\">100.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM0.00</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  563. (1522214912, 'Mr. CHIN ZHI LIANG', 'faizan@kflegacyresources.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">29-03-2018\r\n &nbsp;&nbsp;\r\n 10:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">30-03-2018\r\n &nbsp;&nbsp;\r\n 10:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 1 Days 0 Hours</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\r\n </tr><tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">Viva Elite 1.0 (A)</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM100.00</td>\r\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM100.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Prepaid Amount(<span style=\"font-size: 10px;\">100.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM0.00</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  564. (1522252227, 'Mr. Tony Ting Soon Siong Ting', 'tony840927ting@hotmail.my', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\r\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Bus Terminal</td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">04-04-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">08-04-2018\r\n &nbsp;&nbsp;\r\n 9:00 AM</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 4 天 0 小时</strong></td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\r\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\r\n </tr><tr>\r\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"center\">Kancil 850 (A)</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM320.00</td>\r\n </tr><tr>\r\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"4\"><strong>Rental Options</strong></td>\r\n </tr><tr >\r\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"3\">Driver x <b>9</b> ( RM100.00 x 4day(s) )</td>\r\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM3,600.00</td>\r\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM3,920.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Prepaid Amount(<span style=\"font-size: 10px;\">15.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM0.00</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  565. (1522330824, 'Mr. etest roslan', 'adbroslan@gmail.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\n </tr>\n <tr>\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\n </tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\n </tr>\n <tr>\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">30-03-2018\n &nbsp;&nbsp;\n 9:00 AM</td>\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">31-03-2018\n &nbsp;&nbsp;\n 9:00 AM</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 1 Days 0 Hours</strong></td>\n </tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\n </tr><tr>\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\">Viva 850 (M)</td>\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM100.00</td>\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM100.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"background:#ffffff;\">Tax(1.00%)</td><td align=\"right\" style=\"background:#ffffff;\">(+) RM1.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Grand Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM101.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Deposit Amount(<span style=\"font-size: 10px;\">20.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM20.20</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>'),
  566. (1522332541, 'Mr. muhammad adib bin roslan', 'adbroslan@gmail.com', '<table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"5\" cellspacing=\"1\"><tbody><tr><td align=\"left\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\" colspan=\"4\">Rental Details</td></tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Pick-up Location</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"><strong>Drop-off Location</strong></td>\n </tr>\n <tr>\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Airport</td>\n <td bgcolor=\"#ffffff\" align=\"left\" colspan=\"2\">Sibu - Boat Express Terminal</td>\n </tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Pick-up Date &amp; Time</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"1\"><strong>Drop-off Date &amp; Time</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"left\" colspan=\"2\"></td>\n </tr>\n <tr>\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">29-03-2018\n &nbsp;&nbsp;\n 9:00 AM</td>\n <td bgcolor=\"#FFFFFF\" align=\"left\" colspan=\"1\">31-03-2018\n &nbsp;&nbsp;\n 9:00 AM</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\" colspan=\"2\"><strong> = 2 Days 0 Hours</strong></td>\n </tr>\n <tr>\n <td bgcolor=\"#f2f2f2\" align=\"left\"><strong>Car Type</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Vendor</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"center\"><strong>Car Model</strong></td>\n <td bgcolor=\"#f2f2f2\" align=\"right\" style=\"padding-right:5px;\"><strong>Gross Total</strong></td>\n </tr><tr>\n <td bgcolor=\"#FFFFFF\" align=\"left\">Small Cars</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\">PERODUA</td>\n <td bgcolor=\"#FFFFFF\" align=\"center\">Kancil 850 (A)</td>\n <td bgcolor=\"#FFFFFF\" align=\"right\" style=\"padding-right:5px;\">RM160.00</td>\n </tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Sub Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM160.00</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"background:#ffffff;\">Tax(1.00%)</td><td align=\"right\" style=\"background:#ffffff;\">(+) RM1.60</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Grand Total</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM161.60</td></tr><tr><td colspan=\"3\" align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Deposit Amount(<span style=\"font-size: 10px;\">20.00% of Grand Total</span>)</td><td align=\"right\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">RM32.32</td></tr></tbody></table><br /><table style=\"font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;\" cellpadding=\"4\" cellspacing=\"1\"><tr><td align=\"left\" colspan=\"2\" style=\"font-weight:bold; font-variant:small-caps; background:#eeeeee;\">Payment Details</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps;background:#ffffff;\">Payment Option</td><td align=\"left\" style=\"background:#ffffff;\"> CIMB BANK : 860-304-5348 KF LEGACY RESOURCES</td></tr><tr><td align=\"left\" width=\"30%\" style=\"font-weight:bold; font-variant:small-caps; background:#ffffff;\">Transaction ID</td><td align=\"left\" style=\"background:#ffffff;\">NA</td></tr></table>');
  567.  
  568. -- --------------------------------------------------------
  569.  
  570. --
  571. -- Table structure for table `bsi_language`
  572. --
  573.  
  574. CREATE TABLE `bsi_language` (
  575. `id` int(11) NOT NULL,
  576. `lang_title` varchar(255) NOT NULL,
  577. `lang_code` varchar(10) NOT NULL,
  578. `lang_file` varchar(255) NOT NULL,
  579. `lang_default` tinyint(1) NOT NULL DEFAULT '0'
  580. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  581.  
  582. --
  583. -- Dumping data for table `bsi_language`
  584. --
  585.  
  586. INSERT INTO `bsi_language` (`id`, `lang_title`, `lang_code`, `lang_file`, `lang_default`) VALUES
  587. (1, 'English', 'en', 'english.php', 1),
  588. (2, 'French', 'fr', 'french.php', 0),
  589. (3, 'German', 'de', 'german.php', 0),
  590. (4, 'Greek', 'el', 'greek.php', 0),
  591. (5, 'Spanish', 'es', 'espanol.php', 0),
  592. (6, 'Italian', 'it', 'italian.php', 0),
  593. (7, 'Dutch', 'de', 'dutch.php', 0),
  594. (8, 'Polish', 'pl', 'polish.php', 0),
  595. (9, 'Portuguese', 'pt', 'portuguese.php', 0),
  596. (10, 'Russian', 'ru', 'russian.php', 0),
  597. (11, 'Turkish', 'tr', 'turkish.php', 0),
  598. (12, 'Thai', 'th', 'thai.php', 0),
  599. (13, 'Chinese', 'zh-CN', 'chinese.php', 0),
  600. (14, 'Indonesian', 'id', 'indonesian.php', 0),
  601. (15, 'Romanian', 'ro', 'romanian.php', 0),
  602. (17, 'Japanese', 'ja', 'japanese.php', 0);
  603.  
  604. -- --------------------------------------------------------
  605.  
  606. --
  607. -- Table structure for table `bsi_payment_gateway`
  608. --
  609.  
  610. CREATE TABLE `bsi_payment_gateway` (
  611. `id` int(11) NOT NULL,
  612. `gateway_name` varchar(255) NOT NULL,
  613. `gateway_code` varchar(50) NOT NULL,
  614. `account` varchar(255) DEFAULT NULL,
  615. `enabled` tinyint(1) NOT NULL DEFAULT '0',
  616. `ord` int(11) NOT NULL DEFAULT '0'
  617. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  618.  
  619. --
  620. -- Dumping data for table `bsi_payment_gateway`
  621. --
  622.  
  623. INSERT INTO `bsi_payment_gateway` (`id`, `gateway_name`, `gateway_code`, `account`, `enabled`, `ord`) VALUES
  624. (4, ' PayPal', 'pp', 'paypal@sibucarrental.com', 1, 1),
  625. (7, ' CIMB BANK : 860-304-5348 KF LEGACY RESOURCES', 'poa', NULL, 1, 3);
  626.  
  627. -- --------------------------------------------------------
  628.  
  629. --
  630. -- Table structure for table `bsi_res_data`
  631. --
  632.  
  633. CREATE TABLE `bsi_res_data` (
  634. `booking_id` int(11) NOT NULL,
  635. `car_id` int(11) NOT NULL
  636. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  637.  
  638. --
  639. -- Dumping data for table `bsi_res_data`
  640. --
  641.  
  642. INSERT INTO `bsi_res_data` (`booking_id`, `car_id`) VALUES
  643. (1522082427, 1),
  644. (1522082554, 2),
  645. (1522082797, 3),
  646. (1522214024, 1),
  647. (1522214496, 3),
  648. (1522214763, 1),
  649. (1522214912, 1),
  650. (1522252227, 4),
  651. (1522265941, 3),
  652. (1522330824, 2),
  653. (1522331854, 4),
  654. (1522332541, 4);
  655.  
  656. -- --------------------------------------------------------
  657.  
  658. --
  659. -- Table structure for table `bsi_selected_features`
  660. --
  661.  
  662. CREATE TABLE `bsi_selected_features` (
  663. `id` int(11) NOT NULL,
  664. `car_id` int(11) NOT NULL,
  665. `features_id` int(11) NOT NULL
  666. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  667.  
  668. --
  669. -- Dumping data for table `bsi_selected_features`
  670. --
  671.  
  672. INSERT INTO `bsi_selected_features` (`id`, `car_id`, `features_id`) VALUES
  673. (1, 1, 9),
  674. (2, 1, 3),
  675. (3, 1, 10),
  676. (4, 1, 12),
  677. (5, 1, 1),
  678. (6, 2, 9),
  679. (7, 2, 3),
  680. (8, 2, 10),
  681. (9, 2, 12),
  682. (10, 2, 2),
  683. (11, 3, 8),
  684. (12, 3, 3),
  685. (13, 3, 10),
  686. (14, 3, 12),
  687. (15, 3, 1),
  688. (16, 4, 3),
  689. (17, 4, 10),
  690. (18, 4, 12),
  691. (19, 4, 1),
  692. (20, 5, 8),
  693. (21, 5, 3),
  694. (22, 5, 10),
  695. (23, 5, 12),
  696. (24, 5, 1),
  697. (25, 6, 9),
  698. (26, 6, 3),
  699. (27, 6, 10),
  700. (28, 6, 12),
  701. (29, 6, 1);
  702.  
  703. --
  704. -- Indexes for dumped tables
  705. --
  706.  
  707. --
  708. -- Indexes for table `bsi_admin`
  709. --
  710. ALTER TABLE `bsi_admin`
  711. ADD PRIMARY KEY (`id`);
  712.  
  713. --
  714. -- Indexes for table `bsi_adminmenu`
  715. --
  716. ALTER TABLE `bsi_adminmenu`
  717. ADD PRIMARY KEY (`id`),
  718. ADD UNIQUE KEY `kid` (`name`,`parent_id`);
  719.  
  720. --
  721. -- Indexes for table `bsi_all_location`
  722. --
  723. ALTER TABLE `bsi_all_location`
  724. ADD PRIMARY KEY (`loc_id`);
  725.  
  726. --
  727. -- Indexes for table `bsi_bookings`
  728. --
  729. ALTER TABLE `bsi_bookings`
  730. ADD PRIMARY KEY (`booking_id`),
  731. ADD KEY `start_date` (`pickup_datetime`),
  732. ADD KEY `end_date` (`dropoff_datetime`),
  733. ADD KEY `booking_time` (`discount_coupon`);
  734.  
  735. --
  736. -- Indexes for table `bsi_car_extras`
  737. --
  738. ALTER TABLE `bsi_car_extras`
  739. ADD PRIMARY KEY (`id`);
  740.  
  741. --
  742. -- Indexes for table `bsi_car_features`
  743. --
  744. ALTER TABLE `bsi_car_features`
  745. ADD PRIMARY KEY (`id`);
  746.  
  747. --
  748. -- Indexes for table `bsi_car_master`
  749. --
  750. ALTER TABLE `bsi_car_master`
  751. ADD PRIMARY KEY (`car_id`);
  752.  
  753. --
  754. -- Indexes for table `bsi_car_priceplan`
  755. --
  756. ALTER TABLE `bsi_car_priceplan`
  757. ADD PRIMARY KEY (`pp_id`);
  758.  
  759. --
  760. -- Indexes for table `bsi_car_type`
  761. --
  762. ALTER TABLE `bsi_car_type`
  763. ADD PRIMARY KEY (`id`);
  764.  
  765. --
  766. -- Indexes for table `bsi_car_vendor`
  767. --
  768. ALTER TABLE `bsi_car_vendor`
  769. ADD PRIMARY KEY (`id`);
  770.  
  771. --
  772. -- Indexes for table `bsi_clients`
  773. --
  774. ALTER TABLE `bsi_clients`
  775. ADD PRIMARY KEY (`client_id`),
  776. ADD KEY `email` (`email`);
  777.  
  778. --
  779. -- Indexes for table `bsi_configure`
  780. --
  781. ALTER TABLE `bsi_configure`
  782. ADD PRIMARY KEY (`conf_id`);
  783.  
  784. --
  785. -- Indexes for table `bsi_deposit_duration`
  786. --
  787. ALTER TABLE `bsi_deposit_duration`
  788. ADD PRIMARY KEY (`id`);
  789.  
  790. --
  791. -- Indexes for table `bsi_discount_duration`
  792. --
  793. ALTER TABLE `bsi_discount_duration`
  794. ADD PRIMARY KEY (`id`);
  795.  
  796. --
  797. -- Indexes for table `bsi_email_contents`
  798. --
  799. ALTER TABLE `bsi_email_contents`
  800. ADD PRIMARY KEY (`id`);
  801.  
  802. --
  803. -- Indexes for table `bsi_invoice`
  804. --
  805. ALTER TABLE `bsi_invoice`
  806. ADD PRIMARY KEY (`booking_id`);
  807.  
  808. --
  809. -- Indexes for table `bsi_language`
  810. --
  811. ALTER TABLE `bsi_language`
  812. ADD PRIMARY KEY (`id`);
  813.  
  814. --
  815. -- Indexes for table `bsi_payment_gateway`
  816. --
  817. ALTER TABLE `bsi_payment_gateway`
  818. ADD PRIMARY KEY (`id`);
  819.  
  820. --
  821. -- Indexes for table `bsi_selected_features`
  822. --
  823. ALTER TABLE `bsi_selected_features`
  824. ADD PRIMARY KEY (`id`);
  825.  
  826. --
  827. -- AUTO_INCREMENT for dumped tables
  828. --
  829.  
  830. --
  831. -- AUTO_INCREMENT for table `bsi_admin`
  832. --
  833. ALTER TABLE `bsi_admin`
  834. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  835.  
  836. --
  837. -- AUTO_INCREMENT for table `bsi_adminmenu`
  838. --
  839. ALTER TABLE `bsi_adminmenu`
  840. MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
  841.  
  842. --
  843. -- AUTO_INCREMENT for table `bsi_all_location`
  844. --
  845. ALTER TABLE `bsi_all_location`
  846. MODIFY `loc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  847.  
  848. --
  849. -- AUTO_INCREMENT for table `bsi_car_extras`
  850. --
  851. ALTER TABLE `bsi_car_extras`
  852. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  853.  
  854. --
  855. -- AUTO_INCREMENT for table `bsi_car_features`
  856. --
  857. ALTER TABLE `bsi_car_features`
  858. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  859.  
  860. --
  861. -- AUTO_INCREMENT for table `bsi_car_master`
  862. --
  863. ALTER TABLE `bsi_car_master`
  864. MODIFY `car_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  865.  
  866. --
  867. -- AUTO_INCREMENT for table `bsi_car_priceplan`
  868. --
  869. ALTER TABLE `bsi_car_priceplan`
  870. MODIFY `pp_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  871.  
  872. --
  873. -- AUTO_INCREMENT for table `bsi_car_type`
  874. --
  875. ALTER TABLE `bsi_car_type`
  876. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  877.  
  878. --
  879. -- AUTO_INCREMENT for table `bsi_car_vendor`
  880. --
  881. ALTER TABLE `bsi_car_vendor`
  882. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  883.  
  884. --
  885. -- AUTO_INCREMENT for table `bsi_clients`
  886. --
  887. ALTER TABLE `bsi_clients`
  888. MODIFY `client_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  889.  
  890. --
  891. -- AUTO_INCREMENT for table `bsi_configure`
  892. --
  893. ALTER TABLE `bsi_configure`
  894. MODIFY `conf_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
  895.  
  896. --
  897. -- AUTO_INCREMENT for table `bsi_deposit_duration`
  898. --
  899. ALTER TABLE `bsi_deposit_duration`
  900. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  901.  
  902. --
  903. -- AUTO_INCREMENT for table `bsi_discount_duration`
  904. --
  905. ALTER TABLE `bsi_discount_duration`
  906. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  907.  
  908. --
  909. -- AUTO_INCREMENT for table `bsi_email_contents`
  910. --
  911. ALTER TABLE `bsi_email_contents`
  912. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  913.  
  914. --
  915. -- AUTO_INCREMENT for table `bsi_language`
  916. --
  917. ALTER TABLE `bsi_language`
  918. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  919.  
  920. --
  921. -- AUTO_INCREMENT for table `bsi_payment_gateway`
  922. --
  923. ALTER TABLE `bsi_payment_gateway`
  924. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  925.  
  926. --
  927. -- AUTO_INCREMENT for table `bsi_selected_features`
  928. --
  929. ALTER TABLE `bsi_selected_features`
  930. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
  931. COMMIT;
  932.  
  933. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  934. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  935. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!