API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 9th, 2017
549
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 16.50 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.4.1deb2ubuntu2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Apr 09, 2017 at 04:44 PM
  7. -- Server version: 5.7.17-0ubuntu0.16.04.2
  8. -- PHP Version: 7.0.15-0ubuntu0.16.04.4
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `app_eresto`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `tbl_booking`
  21. --
  22.  
  23. CREATE TABLE `tbl_booking` (
  24.   `id` int(4) NOT NULL,
  25.   `content` text NOT NULL,
  26.   `waktu` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  27. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  28.  
  29. --
  30. -- Dumping data for table `tbl_booking`
  31. --
  32.  
  33. INSERT INTO `tbl_booking` (`id`, `content`, `waktu`) VALUES
  34. (1, 'a:5:{s:5:"email";s:13:"tian@tian.com";s:10:"keterangan";s:18:"kajshd kjahskdjasd";s:11:"namaLengkap";s:7:"septian";s:8:"noKontak";s:11:"92384792834";s:10:"tglBooking";s:24:"2017-04-05T17:00:00.000Z";}', '2017-04-06 07:48:19'),
  35. (2, 'a:5:{s:5:"email";s:13:"tian@tian.com";s:10:"keterangan";s:18:"kajshd kjahskdjasd";s:11:"namaLengkap";s:7:"Richard";s:8:"noKontak";s:11:"92384792834";s:10:"tglBooking";s:24:"2017-04-05T17:00:00.000Z";}', '2017-04-06 07:48:44'),
  36. (3, 'a:5:{s:5:"email";s:14:"rudi@gmail.com";s:10:"keterangan";s:27:"ini aldskh aksljdl aksjdasd";s:11:"namaLengkap";s:12:"Rudi Mancuso";s:8:"noKontak";s:8:"23987293";s:10:"tglBooking";s:24:"2017-04-07T17:00:00.000Z";}', '2017-04-06 08:11:42'),
  37. (4, 'a:5:{s:5:"email";s:14:"nama@gmail.com";s:10:"keterangan";s:15:"asfsa as das da";s:11:"namaLengkap";s:9:"nama baru";s:8:"noKontak";s:5:"89239";s:10:"tglBooking";s:24:"2017-04-06T17:00:00.000Z";}', '2017-04-06 08:13:53'),
  38. (5, 'a:5:{s:5:"email";s:16:"ronald@gmail.com";s:10:"keterangan";s:46:"ini adalah keterangan baruuukj askdj askjdnasd";s:11:"namaLengkap";s:10:"Ronaldinho";s:8:"noKontak";s:11:"98237498274";s:10:"tglBooking";s:24:"2017-04-21T17:00:00.000Z";}', '2017-04-06 08:52:03'),
  39. (6, 'a:5:{s:5:"email";s:15:"email@gmail.com";s:10:"keterangan";s:129:"saya mau booking untuk acara pesta ulang tahun pada tanggal 29 April 2017. Mohon tempatnya disediakan dengan baik...\n\nTerimakasih";s:11:"namaLengkap";s:4:"Yuki";s:8:"noKontak";s:10:"9283749234";s:10:"tglBooking";s:24:"2017-04-19T17:00:00.000Z";}', '2017-04-06 14:14:41');
  40.  
  41. -- --------------------------------------------------------
  42.  
  43. --
  44. -- Table structure for table `tbl_kategori`
  45. --
  46.  
  47. CREATE TABLE `tbl_kategori` (
  48.   `id` int(2) NOT NULL,
  49.   `kategori_name` varchar(99) NOT NULL
  50. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  51.  
  52. --
  53. -- Dumping data for table `tbl_kategori`
  54. --
  55.  
  56. INSERT INTO `tbl_kategori` (`id`, `kategori_name`) VALUES
  57. (1, 'makanan'),
  58. (2, 'minuman'),
  59. (3, 'cemilan');
  60.  
  61. -- --------------------------------------------------------
  62.  
  63. --
  64. -- Table structure for table `tbl_login`
  65. --
  66.  
  67. CREATE TABLE `tbl_login` (
  68.   `id` int(4) NOT NULL,
  69.   `username` varchar(30) NOT NULL,
  70.   `nama_lengkap` varchar(99) NOT NULL,
  71.   `password` varchar(32) NOT NULL,
  72.   `email` varchar(99) NOT NULL,
  73.   `no_telp` varchar(20) NOT NULL,
  74.   `level` varchar(99) NOT NULL
  75. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  76.  
  77. --
  78. -- Dumping data for table `tbl_login`
  79. --
  80.  
  81. INSERT INTO `tbl_login` (`id`, `username`, `nama_lengkap`, `password`, `email`, `no_telp`, `level`) VALUES
  82. (1, 'admin', 'administrator', '21232f297a57a5a743894a0e4a801fc3', 'admin@admin', '23234', 'admin');
  83.  
  84. -- --------------------------------------------------------
  85.  
  86. --
  87. -- Table structure for table `tbl_options`
  88. --
  89.  
  90. CREATE TABLE `tbl_options` (
  91.   `id` int(2) NOT NULL,
  92.   `name` varchar(100) NOT NULL,
  93.   `content` text NOT NULL,
  94.   `waktu` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  95. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  96.  
  97. --
  98. -- Dumping data for table `tbl_options`
  99. --
  100.  
  101. INSERT INTO `tbl_options` (`id`, `name`, `content`, `waktu`) VALUES
  102. (1, 'profile', 'a:3:{s:7:"content";s:36:"<p>ini adalah halaman location</p>\r\n";s:9:"imageLink";s:98:"http://localhost/mobile_project/app_eresto/api/upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";s:7:"longlat";s:22:"-6.9006769,107.6049197";}', '2017-04-07 06:57:19'),
  103. (2, 'contact', 'a:2:{s:7:"content";s:34:"<p>ini adalah halama kontact</p>\r\n";s:9:"imageLink";s:98:"http://localhost/mobile_project/app_eresto/api/upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";}', '2017-04-04 10:21:55'),
  104. (3, 'gallery', 'a:2:{s:9:"imageLink";a:2:{i:0;s:98:"http://localhost/mobile_project/app_eresto/api/upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";i:1;s:98:"http://localhost/mobile_project/app_eresto/api/upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";}s:11:"description";a:2:{i:0;s:11:"deskripsi 1";i:1;s:11:"Deskripsi 3";}}', '2017-04-07 09:05:40'),
  105. (4, 'location', 'a:3:{s:7:"content";s:35:"<p>ini adalah halama location</p>\r\n";s:9:"imageLink";s:98:"http://localhost/mobile_project/app_eresto/api/upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";s:7:"longlat";s:22:"-6.9006769,107.6049197";}', '2017-04-07 06:59:38');
  106.  
  107. -- --------------------------------------------------------
  108.  
  109. --
  110. -- Table structure for table `tbl_order`
  111. --
  112.  
  113. CREATE TABLE `tbl_order` (
  114.   `id` int(4) NOT NULL,
  115.   `data` text NOT NULL,
  116.   `waktu` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  117.   `status` varchar(10) NOT NULL DEFAULT 'belum'
  118. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  119.  
  120. --
  121. -- Dumping data for table `tbl_order`
  122. --
  123.  
  124. INSERT INTO `tbl_order` (`id`, `data`, `waktu`, `status`) VALUES
  125. (3, 's:372:"{"alamat":"bandung","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"}]}","namaLengkap":"riana hol","noKontak":"9823794"}";', '2017-04-07 09:23:52', 'sudah'),
  126. (4, 's:483:"{"alamat":"Jakarta Selatan","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"8\\",\\"_name\\":\\"Produk Ketiga\\",\\"_price\\":15000,\\"_quantity\\":1,\\"_data\\":\\"item\\"}]}","namaLengkap":"Andi Solihin","noKontak":"92384798234"}";', '2017-04-07 10:08:39', 'sudah'),
  127. (5, 's:487:"{"alamat":"bandung bandung","checkout":"{\\"payment\\":\\"transfer\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"8\\",\\"_name\\":\\"Produk Ketiga\\",\\"_price\\":15000,\\"_quantity\\":1,\\"_data\\":\\"item\\"}]}","namaLengkap":"Dokter Richard","noKontak":"29348023"}";', '2017-04-04 06:24:35', 'belum'),
  128. (6, 's:512:"{"alamat":"Jalan Kopo Bandung nomer aslkdj aslkjdas","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Fajar Maulana","noKontak":"982374928347"}";', '2017-04-07 09:45:13', 'belum'),
  129. (7, 's:502:"{"alamat":"Bandung kopo klajs dlkjas ldkjasd","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Rizky Maulana","noKontak":"289392834"}";', '2017-04-07 09:52:21', 'belum'),
  130. (8, 's:480:"{"alamat":"Bandung","checkout":"{\\"payment\\":\\"transfer\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Aditya Agung","noKontak":"238479823"}";', '2017-04-07 09:54:30', 'belum'),
  131. (9, 's:480:"{"alamat":"Bandung","checkout":"{\\"payment\\":\\"transfer\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Aditya Agung","noKontak":"238479823"}";', '2017-04-07 09:54:40', 'belum'),
  132. (10, 's:480:"{"alamat":"Bandung","checkout":"{\\"payment\\":\\"transfer\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Aditya Agung","noKontak":"238479823"}";', '2017-04-07 09:55:01', 'belum'),
  133. (11, 's:404:"{"checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}"}";', '2017-04-07 09:55:13', 'belum'),
  134. (12, 's:490:"{"alamat":"kjahs dfkjhsd kfjhs kdjfh","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"Ijay askjh","noKontak":"32989823"}";', '2017-04-07 09:56:06', 'belum'),
  135. (13, 's:496:"{"alamat":"bandung bandung bandung","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"user pengguna","noKontak":"9823479823794"}";', '2017-04-07 10:00:03', 'belum'),
  136. (14, 's:475:"{"alamat":"akajshd kjash d","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"hohoh","noKontak":"93829283"}";', '2017-04-07 10:00:44', 'belum'),
  137. (15, 's:497:"{"alamat":"Bandung absdka sdkjh askdjhasd","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"6\\",\\"_name\\":\\"Produk Pertama\\",\\"_price\\":20000,\\"_quantity\\":1,\\"_data\\":\\"item\\"},{\\"_id\\":\\"9\\",\\"_name\\":\\"Produk Keempat\\",\\"_price\\":130000,\\"_quantity\\":7,\\"_data\\":\\"item\\"}]}","namaLengkap":"muke gile","noKontak":"29834798234"}";', '2017-04-07 10:24:30', 'belum'),
  138. (16, 's:314:"{"alamat":"Taman Kopo Indah Nomer 536738 r","checkout":"{\\"payment\\":\\"cod\\"}","detailOrder":"{\\"shipping\\":null,\\"taxRate\\":null,\\"tax\\":null,\\"items\\":[{\\"_id\\":\\"7\\",\\"_name\\":\\"Produk Kedua\\",\\"_price\\":30000,\\"_quantity\\":3,\\"_data\\":\\"item\\"}]}","namaLengkap":"ini pengguna dari HP","noKontak":"85945767076"}";', '2017-04-08 14:39:29', 'belum');
  139.  
  140. -- --------------------------------------------------------
  141.  
  142. --
  143. -- Table structure for table `tbl_produk`
  144. --
  145.  
  146. CREATE TABLE `tbl_produk` (
  147.   `id` int(4) NOT NULL,
  148.   `id_kategori` int(2) NOT NULL,
  149.   `judul` varchar(200) NOT NULL,
  150.   `deskripsi` text NOT NULL,
  151.   `image` text NOT NULL,
  152.   `headline` varchar(1) NOT NULL,
  153.   `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  154.   `publish` varchar(1) NOT NULL,
  155.   `author` varchar(20) NOT NULL,
  156.   `price` varchar(9) NOT NULL DEFAULT '0'
  157. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  158.  
  159. --
  160. -- Dumping data for table `tbl_produk`
  161. --
  162.  
  163. INSERT INTO `tbl_produk` (`id`, `id_kategori`, `judul`, `deskripsi`, `image`, `headline`, `stamp`, `publish`, `author`, `price`) VALUES
  164. (7, 2, 'Produk Kedua', '<p>Product description here...</p>\r\n', 'a:2:{i:0;s:100:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/146caf8bd0cb6da437d6d90621cee84c.jpg";i:1;s:101:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/aa3a3e949437cfff540d3e97f08b4500.jpeg";}', '0', '2017-03-28 00:23:07', '1', 'admin', '30000'),
  165. (8, 3, 'Produk Ketiga', '<p>Product description here...</p>\r\n', 'a:2:{i:0;s:100:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/3b44790ef99f0b16b05a8fcb73caa3d7.jpg";i:1;s:100:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/bf685321b1a598c2b66f3720d1e6273a.jpg";}', '0', '2017-03-28 00:23:47', '1', 'admin', '15000'),
  166. (9, 1, 'Produk Keempat', '<p>Product description here...</p>\r\n', 'a:2:{i:0;s:100:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/180a84196a87e0f6075df1f6659f2bc1.jpg";i:1;s:100:"http://localhost/mobile_project/app_eresto/api/./upload/2017-03/b4398f23865bd5e43c27e65528e48956.jpg";}', '0', '2017-03-28 01:14:25', '1', 'admin', '130000');
  167.  
  168. --
  169. -- Indexes for dumped tables
  170. --
  171.  
  172. --
  173. -- Indexes for table `tbl_booking`
  174. --
  175. ALTER TABLE `tbl_booking`
  176.   ADD PRIMARY KEY (`id`);
  177.  
  178. --
  179. -- Indexes for table `tbl_kategori`
  180. --
  181. ALTER TABLE `tbl_kategori`
  182.   ADD PRIMARY KEY (`id`);
  183.  
  184. --
  185. -- Indexes for table `tbl_login`
  186. --
  187. ALTER TABLE `tbl_login`
  188.   ADD PRIMARY KEY (`id`);
  189.  
  190. --
  191. -- Indexes for table `tbl_options`
  192. --
  193. ALTER TABLE `tbl_options`
  194.   ADD PRIMARY KEY (`id`);
  195.  
  196. --
  197. -- Indexes for table `tbl_order`
  198. --
  199. ALTER TABLE `tbl_order`
  200.   ADD PRIMARY KEY (`id`);
  201.  
  202. --
  203. -- Indexes for table `tbl_produk`
  204. --
  205. ALTER TABLE `tbl_produk`
  206.   ADD PRIMARY KEY (`id`);
  207.  
  208. --
  209. -- AUTO_INCREMENT for dumped tables
  210. --
  211.  
  212. --
  213. -- AUTO_INCREMENT for table `tbl_booking`
  214. --
  215. ALTER TABLE `tbl_booking`
  216.   MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  217. --
  218. -- AUTO_INCREMENT for table `tbl_kategori`
  219. --
  220. ALTER TABLE `tbl_kategori`
  221.   MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  222. --
  223. -- AUTO_INCREMENT for table `tbl_login`
  224. --
  225. ALTER TABLE `tbl_login`
  226.   MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  227. --
  228. -- AUTO_INCREMENT for table `tbl_options`
  229. --
  230. ALTER TABLE `tbl_options`
  231.   MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  232. --
  233. -- AUTO_INCREMENT for table `tbl_order`
  234. --
  235. ALTER TABLE `tbl_order`
  236.   MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  237. --
  238. -- AUTO_INCREMENT for table `tbl_produk`
  239. --
  240. ALTER TABLE `tbl_produk`
  241.   MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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!