API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.69 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.4.14
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Jun 06, 2017 at 05:23 PM
  7. -- Server version: 5.6.26
  8. -- PHP Version: 5.6.12
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Database: `warpsite`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `blokir`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `blokir` (
  30. `id` int(11) NOT NULL,
  31. `ip` text COLLATE utf8_unicode_ci NOT NULL,
  32. `tanggal` date NOT NULL
  33. ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  34.  
  35. --
  36. -- Dumping data for table `blokir`
  37. --
  38.  
  39. INSERT INTO `blokir` (`id`, `ip`, `tanggal`) VALUES
  40. (5, '180.252.130.170', '2017-05-13'),
  41. (6, '180.252.130.170', '2017-05-13'),
  42. (7, '180.252.130.170', '2017-05-13'),
  43. (8, '180.252.130.170', '2017-05-13'),
  44. (9, '180.252.130.170', '2017-05-13'),
  45. (10, '180.252.130.170', '2017-05-13'),
  46. (11, '180.252.130.170', '2017-05-13'),
  47. (12, '180.252.130.170', '2017-05-13'),
  48. (13, '180.252.130.170', '2017-05-13'),
  49. (14, '180.252.130.170', '2017-05-13'),
  50. (15, '125.161.74.167', '2017-05-25'),
  51. (16, '125.161.74.167', '2017-05-25'),
  52. (17, '125.161.74.167', '2017-05-25'),
  53. (18, '125.161.74.167', '2017-05-25'),
  54. (19, '125.161.74.167', '2017-05-25'),
  55. (20, '125.161.74.167', '2017-05-25'),
  56. (21, '125.161.74.167', '2017-05-28'),
  57. (22, '125.161.74.167', '2017-05-28'),
  58. (23, '125.161.74.167', '2017-05-28'),
  59. (24, '125.161.74.167', '2017-05-28'),
  60. (25, '125.166.42.117', '2017-05-29');
  61.  
  62. -- --------------------------------------------------------
  63.  
  64. --
  65. -- Table structure for table `cust_users`
  66. --
  67.  
  68. CREATE TABLE IF NOT EXISTS `cust_users` (
  69. `cust_id` int(4) NOT NULL,
  70. `cust_fn` varchar(100) NOT NULL,
  71. `cust_mail` varchar(100) NOT NULL,
  72. `cust_pass` varchar(50) NOT NULL,
  73. `status` enum('Y','N') NOT NULL,
  74. `foto` text NOT NULL,
  75. `jkel` enum('male','female','','') NOT NULL,
  76. `nomorhp` text NOT NULL,
  77. `tanggal_lahir` text NOT NULL,
  78. `tgl_daftar` date NOT NULL
  79. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  80.  
  81. --
  82. -- Dumping data for table `cust_users`
  83. --
  84.  
  85. INSERT INTO `cust_users` (`cust_id`, `cust_fn`, `cust_mail`, `cust_pass`, `status`, `foto`, `jkel`, `nomorhp`, `tanggal_lahir`, `tgl_daftar`) VALUES
  86. (1, 'jauhari', 'jauharimalik@gmail.com', 'a0b3ccfe082f525fd4e64fc3012ef776', 'Y', '', 'male', '', '', '2017-05-26'),
  87. (2, 'yugo setiawan', 'yugosetiawan@gmail.com', '678485deeed4637c9223976224447e77', 'Y', '', 'male', '', '', '2017-05-26'),
  88. (3, 'yugo setiawan', 'jugosetiawan@gmail.com', 'd177b4d1d9e6b6fa86521e4b3d00b029', 'Y', '', 'male', '', '', '2017-05-26'),
  89. (4, 'yugo setiawan', 'yugosetiawan1905@gmail.com', '678485deeed4637c9223976224447e77', 'Y', '', 'male', '', '', '2017-05-26'),
  90. (5, 'Jauhari Malik', 'Jauharimalik1905@gmail.com', '8a72b5508c5729c6241b2aa4228d91c2', 'Y', '', 'male', '', '', '2017-05-29'),
  91. (6, 'Yugo Setiawan', 'Yugosetiawan1995@gmail.com', '678485deeed4637c9223976224447e77', 'Y', '', 'male', '', '', '2017-05-29'),
  92. (7, 'Yuwan', 'yuwan@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 'Y', '', 'male', '', '', '2017-05-29'),
  93. (8, 'Yuwan malik', 'Yuwanmalik@gmail.com', 'd060f1e97628f7d72b099629a5df0022', 'Y', '', 'male', '', '', '2017-05-29'),
  94. (9, 'dewi', 'dewi@vanectro.com', '21232f297a57a5a743894a0e4a801fc3', 'Y', '', 'male', '', '', '2017-05-31'),
  95. (10, 'Misel Julianta Putra', 'putramisel1@gmail.com', '86e258c2a82fa279bd76ca5cffa6a688', 'Y', '', 'male', '', '', '2017-06-05');
  96.  
  97. -- --------------------------------------------------------
  98.  
  99. --
  100. -- Table structure for table `orders`
  101. --
  102.  
  103. CREATE TABLE IF NOT EXISTS `orders` (
  104. `order_id` varchar(20) NOT NULL,
  105. `faktur` text NOT NULL,
  106. `cust_id` int(4) NOT NULL,
  107. `nama` varchar(100) NOT NULL,
  108. `kota` varchar(50) NOT NULL,
  109. `provinsi` varchar(50) NOT NULL,
  110. `kodepos` int(6) NOT NULL,
  111. `alamat` text NOT NULL,
  112. `phone` text NOT NULL,
  113. `tgl_pesan` date NOT NULL,
  114. `tgl_proses` date NOT NULL,
  115. `tgl_kirim` date NOT NULL,
  116. `foto_proses` text NOT NULL,
  117. `foto_pengiriman` text NOT NULL,
  118. `status` varchar(50) NOT NULL DEFAULT 'Menunggu',
  119. `pelunasan` enum('0','1') NOT NULL DEFAULT '0',
  120. `dilihat` enum('0','1') NOT NULL DEFAULT '0',
  121. `ongkir` double NOT NULL DEFAULT '0',
  122. `ekspedisi` text NOT NULL,
  123. `nohp_pengiriman` text NOT NULL,
  124. `resi` text NOT NULL,
  125. `link_ekspedisi` text NOT NULL
  126. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  127.  
  128. --
  129. -- Dumping data for table `orders`
  130. --
  131.  
  132. INSERT INTO `orders` (`order_id`, `faktur`, `cust_id`, `nama`, `kota`, `provinsi`, `kodepos`, `alamat`, `phone`, `tgl_pesan`, `tgl_proses`, `tgl_kirim`, `foto_proses`, `foto_pengiriman`, `status`, `pelunasan`, `dilihat`, `ongkir`, `ekspedisi`, `nohp_pengiriman`, `resi`, `link_ekspedisi`) VALUES
  133. ('0E64662', '', 2, 'yugo setiawan', '', 'Jawa Barat', 17424, 'perum pondok gede permai jl. cendrawasih jatiasih bekasi', '85755871098', '2017-05-26', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '1', 0, '', '', '', ''),
  134. ('106438A85', '', 19, 'alfian', 'Kota Cilegon', 'Banten', 17145, 'Komp. Benalu Rt 02/25', '085777404013', '2017-01-07', '0000-00-00', '0000-00-00', '', '0', 'Dikirim', '0', '1', 18360, '', '', '', ''),
  135. ('1353BE641', '', 0, 'subhan', 'Kabupaten Gunung Kidul', 'DI Yogyakarta', 27324, 'gunung kidull', '01212545', '2016-12-21', '0000-00-00', '0000-00-00', '', '0', 'Dikirim', '0', '1', 0, '', '', '', ''),
  136. ('15227EB39', '', 20, 'HANDAY', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-11', '2017-05-23', '0000-00-00', '', '', 'Dalam Proses', '0', '1', 0, '', '', '', ''),
  137. ('152445B62', '', 20, 'HANDAY', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-02', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  138. ('152C1B426', '', 20, 'HANDAY', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-04', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  139. ('152E5ED96', '', 20, 'HANDAY', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-04', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '1', '1', 0, '', '', '', ''),
  140. ('15499A4DA', '', 20, 'handayai', 'Kota Jakarta Timur', 'DKI Jakarta', 17146, 'Kapin Belakang BSI', '089635023780', '2017-04-30', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  141. ('18245173', '', 20, 'Handayani', 'Kabupaten Balangan', 'Kalimantan Selatan', 17146, 'semarang', '1234', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  142. ('186561D8', '', 20, 'Handayani', 'Kabupaten Balangan', 'Kalimantan Selatan', 17146, 'semarang', '1234', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Dalam Proses', '0', '1', 0, '', '', '', ''),
  143. ('222E5C3C8', '', 0, 'Jauhari', 'Kabupaten Lamongan', 'Jawa Timur', 50241, 'Semarang', '089635023780', '2017-05-08', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '1', 0, '', '', '', ''),
  144. ('232165568', '', 0, 'jauhari', 'Kabupaten Lebak', 'Banten', 50241, 'Semarang', '58956356528', '2017-05-26', '2017-05-26', '2017-05-26', '', '', 'Dikirim', '0', '1', 0, '', '', '', ''),
  145. ('249508252', '', 0, 'subhan', 'Kabupaten Magelang', 'Jawa Tengah', 17146, 'jl, kebon ungu', 'sdakf00255', '2016-12-21', '0000-00-00', '0000-00-00', '', '0', 'Dikirim', '0', '1', 35360, '', '', '', ''),
  146. ('331694F9B', '', 20, 'Handay', 'Kabupaten Pandeglang', 'Banten', 12345, 'Entahlah', '896350237821', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  147. ('331EE83E5', '', 20, 'Handay', 'Kabupaten Pandeglang', 'Banten', 12345, 'Entahlah', '896350237821', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  148. ('35B2D2A6', '', 7, 'Yuwan', 'Kota Banjarbaru', 'Kalimantan Selatan', 50241, 'aaaaa', '12345', '2017-05-29', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  149. ('38622DC2D', '', 20, 'HANDAY', 'Kota Salatiga', 'Jawa Tengah', 12345, 'ENTAHLAH', '896350237821', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  150. ('386844FE3', '', 20, 'Handay', 'Kota Salatiga', 'Jawa Tengah', 12345, 'Entahlah', '896350237821', '2017-05-01', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  151. ('39903FFD8', '', 0, 'yugo', 'Kota Semarang', 'Jawa Tengah', 50241, 'semarang', '1234567', '2017-05-09', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  152. ('3991D10F0', '', 20, 'HANDAY', 'Kota Semarang', 'Jawa Tengah', 12345, 'ENTAHLAH', '89635023780', '2017-05-02', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '1', 0, '', '', '', ''),
  153. ('3995C7DDA', '', 20, 'handayai', 'Kota Semarang', 'Jawa Tengah', 17146, 'Semarang', '123', '2017-04-30', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  154. ('3997AC62E', '', 20, 'handayai', 'Kota Semarang', 'Jawa Tengah', 50241, 'Jl. Kusumawardani VI / K-28 Semarang.', '08156540572', '2017-04-30', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  155. ('399ABA338', '', 0, 'jauharimalik2', 'Kota Semarang', 'Jawa Tengah', 50241, 'Semarang', '089635023780', '2017-05-14', '2017-05-26', '2017-05-26', 'cdn/images/proses/Produk_Detail1472967_699098833443267_1002749037_n.jpg', 'cdn/images/proses/2.png', 'Dalam Proses', '0', '1', 50000, 'JNE', '123456', '45678', 'http://tiki.com'),
  156. ('399F7F733', '', 9, 'dewi', 'Kota Semarang', 'Jawa Tengah', 17146, 'Semarang', '089635023780', '2017-06-06', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '1', 0, '', '', '', ''),
  157. ('399F830FC', '', 0, 'Jauhari Malik', 'Kota Semarang', 'Jawa Tengah', 50241, 'Semarang', '50241', '2017-05-13', '2017-05-22', '0000-00-00', '', '', 'Dalam Proses', '0', '1', 0, '', '', '', ''),
  158. ('4543CBC4B', '', 20, 'handayai', 'Kabupaten Tanah Laut', 'Kalimantan Selatan', 12456, 'semarang', '112', '2017-04-30', '0000-00-00', '0000-00-00', '', '0', 'Menunggu', '0', '0', 0, '', '', '', ''),
  159. ('550214BD', '', 8, 'Yuwan malik', 'Kota Bekasi', 'Jawa Barat', 17424, 'jatirasa perum. villa nusa indah', '085746138653', '2017-05-29', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  160. ('554C1BEB', '', 4, 'yugo setiawan', 'Kota Bekasi', 'Jawa Barat', 17424, 'jatirasa bekasi', '085755871098', '2017-05-26', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '1', 0, '', '', '', ''),
  161. ('555B691D', '', 5, 'Jauhari Malik', 'Kota Bekasi', 'Jawa Barat', 17424, 'jatiasih jatirasa bekasi', '085788916571', '2017-05-29', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  162. ('55663D07', '', 0, 'Alfian', 'Kota Bekasi', 'Jawa Barat', 17145, 'KOMP. BRI', '112454445', '2016-12-21', '0000-00-00', '0000-00-00', '', '0', 'Dikirim', '0', '1', 0, '', '', '', ''),
  163. ('5567517D', '', 5, 'Jauhari Malik', 'Kota Bekasi', 'Jawa Barat', 17424, 'jatiasih jatirasa bekasi', '085788916571', '2017-05-29', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  164. ('556F3DF6', '', 1, 'jauhari', 'Kota Bekasi', 'Jawa Barat', 17424, 'kepo', '085688987651', '2017-05-26', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '1', '1', 0, '', '', '', ''),
  165. ('55B646D2', '', 3, 'yugo setiawan', 'Kota Bekasi', 'Jawa Barat', 17424, 'kel. jatirasa perum pondok gede permai', '85755871098', '2017-05-26', '0000-00-00', '0000-00-00', '', '', 'Batal', '0', '1', 0, '', '', '', ''),
  166. ('55D8A7CD', '', 6, 'Yugo Setiawan', 'Kota Bekasi', 'Jawa Barat', 17424, 'perum. pondok gede permai jl.merak 7 c. 35 no.40A jatirasa', '085761908712', '2017-05-29', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  167. ('jauhari', 'jauhari', 0, 'jauhari', 'Kabupaten Kudus', 'Jawa Tengah', 85649, 'Hulla', '', '2017-05-28', '2017-05-28', '0000-00-00', '', '', 'Dalam Proses', '1', '1', 600, '', '', '', ''),
  168. ('KOT01A8A3', '', 20, 'Handayani', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-05', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  169. ('KOT7B63BD', '', 20, 'Handayani', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-05', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  170. ('KOT9D24B1', '', 20, 'Handayani', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-05', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  171. ('KOTD25303', '', 20, 'Handayani', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-05', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  172. ('KOTF6B951', '', 20, 'Handayani', 'Kota Jakarta Pusat', 'DKI Jakarta', 12345, 'ENTAHLAH', '89635023780', '2017-05-05', '0000-00-00', '0000-00-00', '', '', 'Menunggu', '0', '0', 0, '', '', '', ''),
  173. ('Test Aja', 'Test Aja', 0, 'Jauhari Malik', 'Kota Semarang', 'Jawa Tengah', 50241, 'Pleburan', '', '2017-05-28', '2017-05-29', '2017-05-29', 'cdn/images/proses/Produk_Detail14960414658361406988879.jpg', 'cdn/images/proses/1496041520330-816699757.jpg', 'Dikirim', '1', '1', 500000, 'Jne', '0', '1235', '4'),
  174. ('test123', 'test123', 0, 'tanpa produk', 'Kabupaten Bangka Barat', 'Bangka Belitung', 17146, 'entahlah', '', '2017-05-27', '2017-05-27', '0000-00-00', '', '', 'Dalam Proses', '1', '1', 500, '', '', '', ''),
  175. ('VANECTRO', '', 19, 'alfian', 'Kabupaten Lebak', 'Banten', 17145, 'Jl. ciracas', '1232131123', '2016-12-21', '2016-12-21', '2016-12-23', 'customer/pak-samsul-kalimantan-min.jpg', 'customer/pak-samsul-kalimantan-min.jpg', 'Terkirim', '0', '1', 0, 'Go Go Ekspress', '089635023780', '123457', '');
  176.  
  177. -- --------------------------------------------------------
  178.  
  179. --
  180. -- Table structure for table `order_detail`
  181. --
  182.  
  183. CREATE TABLE IF NOT EXISTS `order_detail` (
  184. `ord_detail_id` int(4) NOT NULL,
  185. `order_id` varchar(20) NOT NULL,
  186. `produk_id` int(4) NOT NULL,
  187. `qty` int(3) NOT NULL,
  188. `total` double NOT NULL
  189. ) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1;
  190.  
  191. --
  192. -- Dumping data for table `order_detail`
  193. --
  194.  
  195. INSERT INTO `order_detail` (`ord_detail_id`, `order_id`, `produk_id`, `qty`, `total`) VALUES
  196. (58, '55663D07', 26, 1, 83000),
  197. (59, '249508252', 26, 2, 166000),
  198. (60, '1353BE641', 25, 1, 78000),
  199. (61, '1353BE641', 16, 1, 84000),
  200. (62, '232E9C13A', 25, 1, 78000),
  201. (63, '232E9C13A', 23, 1, 97000),
  202. (64, '232E9C13A', 26, 1, 83000),
  203. (65, '106438A85', 26, 1, 83000),
  204. (66, '1547858CC', 1, 2, 0),
  205. (67, '39976D45B', 1, 1, 37750000),
  206. (68, '3997AC62E', 1, 1, 37750000),
  207. (69, '3995C7DDA', 260, 1, 33800000),
  208. (70, '4543CBC4B', 6, 1, 22000000),
  209. (71, '186561D8', 4, 1, 19800000),
  210. (72, '3991D10F0', 40066, 1, 22980000),
  211. (73, '152445B62', 26, 1, 14300000),
  212. (74, '152C1B426', 9, 1, 14600000),
  213. (75, '152E5ED96', 4001, 1, 28500000),
  214. (76, 'KOTF6B951', 1, 1, 37750000),
  215. (77, 'KOTD25303', 0, 0, 0),
  216. (78, '222E5C3C8', 40066, 1, 22980000),
  217. (79, '39903FFD8', 1, 1, 37750000),
  218. (80, '15227EB39', 5, 1, 32500000),
  219. (81, '', 0, 0, 0),
  220. (82, '399F830FC', 1, 1, 37750000),
  221. (83, '399ABA338', 4, 1, 19800000),
  222. (84, '232165568', 40066, 1, 22980000),
  223. (85, '556F3DF6', 40128, 1, 151550000),
  224. (86, '12143585', 40066, 1, 22980000),
  225. (87, '0E64662', 40132, 1, 229650000),
  226. (88, '55B646D2', 40132, 1, 229650000),
  227. (89, '554C1BEB', 40132, 1, 229650000),
  228. (90, 'Test Aja', 270, 1, 34800000),
  229. (91, '555B691D', 40132, 1, 229650000),
  230. (92, '5567517D', 40766, 1, 20980000),
  231. (93, '55D8A7CD', 40132, 1, 229650000),
  232. (94, '35B2D2A6', 1, 1, 37750000),
  233. (95, '550214BD', 40132, 1, 229650000),
  234. (96, '399F7F733', 18, 1, 28800000);
  235.  
  236. --
  237. -- Indexes for dumped tables
  238. --
  239.  
  240. --
  241. -- Indexes for table `blokir`
  242. --
  243. ALTER TABLE `blokir`
  244. ADD PRIMARY KEY (`id`);
  245.  
  246. --
  247. -- Indexes for table `cust_users`
  248. --
  249. ALTER TABLE `cust_users`
  250. ADD PRIMARY KEY (`cust_id`);
  251.  
  252. --
  253. -- Indexes for table `orders`
  254. --
  255. ALTER TABLE `orders`
  256. ADD PRIMARY KEY (`order_id`);
  257.  
  258. --
  259. -- Indexes for table `order_detail`
  260. --
  261. ALTER TABLE `order_detail`
  262. ADD PRIMARY KEY (`ord_detail_id`);
  263.  
  264. --
  265. -- AUTO_INCREMENT for dumped tables
  266. --
  267.  
  268. --
  269. -- AUTO_INCREMENT for table `blokir`
  270. --
  271. ALTER TABLE `blokir`
  272. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
  273. --
  274. -- AUTO_INCREMENT for table `cust_users`
  275. --
  276. ALTER TABLE `cust_users`
  277. MODIFY `cust_id` int(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
  278. --
  279. -- AUTO_INCREMENT for table `order_detail`
  280. --
  281. ALTER TABLE `order_detail`
  282. MODIFY `ord_detail_id` int(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=97;
  283. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  284. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  285. /*!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!