API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 4th, 2019
496
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.95 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.3
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost:3306
  6. -- Generation Time: May 04, 2019 at 03:19 PM
  7. -- Server version: 10.3.14-MariaDB
  8. -- PHP Version: 7.2.7
  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: `foodcour_main`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `admin`
  29. --
  30.  
  31. CREATE TABLE `admin` (
  32. `id` int(22) NOT NULL,
  33. `ausername` varchar(22) NOT NULL,
  34. `apassword` varchar(222) NOT NULL,
  35. `alevel` varchar(22) NOT NULL,
  36. `aemail` varchar(22) NOT NULL,
  37. `a2fa` varchar(22) NOT NULL
  38. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  39.  
  40. --
  41. -- Dumping data for table `admin`
  42. --
  43.  
  44. INSERT INTO `admin` (`id`, `ausername`, `apassword`, `alevel`, `aemail`, `a2fa`) VALUES
  45. (1, 'omar@gmail.com', 'f5bb0c8de146c67b44babbf4e6584cc0', '1', 'omar@gamecracy.com', '2');
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Table structure for table `bundle`
  51. --
  52.  
  53. CREATE TABLE `bundle` (
  54. `bid` int(11) NOT NULL,
  55. `price` decimal(10,2) DEFAULT NULL,
  56. `desc` varchar(255) DEFAULT NULL,
  57. `status` varchar(255) DEFAULT NULL,
  58. `rid` int(11) DEFAULT NULL
  59. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  60.  
  61. -- --------------------------------------------------------
  62.  
  63. --
  64. -- Table structure for table `bundleitems`
  65. --
  66.  
  67. CREATE TABLE `bundleitems` (
  68. `bundleid` int(11) NOT NULL,
  69. `itemid` int(11) DEFAULT NULL,
  70. `itemamount` int(255) DEFAULT NULL
  71. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  72.  
  73. -- --------------------------------------------------------
  74.  
  75. --
  76. -- Table structure for table `cartbundles`
  77. --
  78.  
  79. CREATE TABLE `cartbundles` (
  80. `brecordid` int(11) NOT NULL,
  81. `cartid` int(233) NOT NULL,
  82. `bundleid` int(233) NOT NULL,
  83. `qty` int(233) NOT NULL,
  84. `price` int(222) NOT NULL
  85. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  86.  
  87. -- --------------------------------------------------------
  88.  
  89. --
  90. -- Table structure for table `cartitems`
  91. --
  92.  
  93. CREATE TABLE `cartitems` (
  94. `irecordid` int(22) NOT NULL,
  95. `cartid` int(22) NOT NULL,
  96. `itemid` int(22) NOT NULL,
  97. `qty` int(22) NOT NULL,
  98. `price` int(222) NOT NULL
  99. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  100.  
  101. -- --------------------------------------------------------
  102.  
  103. --
  104. -- Table structure for table `foodcourt`
  105. --
  106.  
  107. CREATE TABLE `foodcourt` (
  108. `fid` int(255) NOT NULL,
  109. `fname` varchar(255) DEFAULT NULL,
  110. `flocation` varchar(255) DEFAULT NULL,
  111. `fcapacity` varchar(255) DEFAULT NULL,
  112. `fowner` varchar(255) DEFAULT NULL
  113. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  114.  
  115. --
  116. -- Dumping data for table `foodcourt`
  117. --
  118.  
  119. INSERT INTO `foodcourt` (`fid`, `fname`, `flocation`, `fcapacity`, `fowner`) VALUES
  120. (1, 'FUE', 'Cairo', '3', 'FUE'),
  121. (2, 'City Stars', 'Cairo', '3', 'John wick'),
  122. (3, 'Oscar', 'Sad', '2', 'Wow');
  123.  
  124. -- --------------------------------------------------------
  125.  
  126. --
  127. -- Table structure for table `items`
  128. --
  129.  
  130. CREATE TABLE `items` (
  131. `iid` int(11) NOT NULL,
  132. `iname` varchar(255) DEFAULT NULL,
  133. `idesc` varchar(255) DEFAULT NULL,
  134. `inut` varchar(255) DEFAULT NULL,
  135. `iprice` varchar(255) DEFAULT NULL,
  136. `irate` varchar(255) DEFAULT NULL,
  137. `istock` varchar(255) DEFAULT NULL,
  138. `itimestart` datetime DEFAULT NULL,
  139. `itimeend` datetime DEFAULT NULL,
  140. `rid` int(11) DEFAULT NULL,
  141. `ikeyword` varchar(11) NOT NULL,
  142. `isold` int(11) NOT NULL
  143. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  144.  
  145. --
  146. -- Dumping data for table `items`
  147. --
  148.  
  149. INSERT INTO `items` (`iid`, `iname`, `idesc`, `inut`, `iprice`, `irate`, `istock`, `itimestart`, `itimeend`, `rid`, `ikeyword`, `isold`) VALUES
  150. (35, 'Guava with Milk', 'gawafa bel laban', '70', '20', NULL, '50', NULL, NULL, 4, '', 0),
  151. (34, 'Banana with Milk', 'moz bel laban', '80', '20', NULL, '50', NULL, NULL, 4, '', 0),
  152. (32, 'Sugar cane juice', 'asab', '50', '5', NULL, '100', NULL, NULL, 4, '', 0),
  153. (33, 'Dinner box', '2 pcs chiken + riz + pepsi + fries ', '2500', '70', NULL, '520', NULL, NULL, 1, '', 0),
  154. (29, 'Roma', 'gfggf', '100', '69', NULL, '1', NULL, NULL, 2, '', 0),
  155. (30, 'mcChicken', 'fra5', '500', '96', NULL, '96', NULL, NULL, 2, '', 0),
  156. (31, 'McFries', 'batates', '900', '90', NULL, '90', NULL, NULL, 2, '', 0),
  157. (28, 'Apple Pie', 'Its just a pie', '12', '13', NULL, '12', NULL, NULL, 2, '', 0),
  158. (27, 'Big Tasty', 'Its Tasty', '123', '12', NULL, '12', NULL, NULL, 2, '', 0),
  159. (26, 'Big Mac', 'Big Mac', '11', '14', NULL, '12', NULL, NULL, 2, '', 0),
  160. (36, 'Family meal', '12 Chicken pcs + 1 family fries + 1 Large Coleslaw + 6 buns', '1500', '160', NULL, '200', NULL, NULL, 1, '', 0),
  161. (37, 'Family meal', '12 Chicken pcs + 1 family fries + 1 Large Coleslaw + 6 buns', '1500', '160', NULL, '200', NULL, NULL, 1, '', 0),
  162. (38, 'Strawberry', 'farawla', '80', '15', NULL, '50', NULL, NULL, 4, '', 0),
  163. (39, 'WAGBET EL TAWFIR ( 15 PCS )', '15 pcs. of spicy or original chicken, family fries, large coleslaw and 8 fresh buns', '2600', '214', NULL, '236', NULL, NULL, 1, '', 0),
  164. (40, 'Mango', 'manga', '85', '15', NULL, '50', NULL, NULL, 4, '', 0),
  165. (41, 'CHILLA BOX', ' 3 Twister Sandwiches + 6 pcs Chicken (Original or Spicy or MIX) + 1 Family Fries + 1 L Pepsi', '1400', '175', NULL, '170', NULL, NULL, 1, '', 0),
  166. (42, 'Hibiscus', 'Karakadey', '90', '15', NULL, '70', NULL, NULL, 4, '', 0),
  167. (43, 'WAGBA SUPER ( 9 PCS )', '9 pcs. of spicy or original chicken, family fries and 5 fresh buns', '1700', '140', NULL, '150', NULL, NULL, 1, '', 0),
  168. (44, 'Tamarind ', 'Tamrhindi', '40', '10', NULL, '70', NULL, NULL, 4, '', 0),
  169. (45, 'Stewed Apricot', 'Qamar Al-Din', '40', '10', NULL, '80', NULL, NULL, 4, '', 0),
  170. (46, 'Coconut with Milk', 'Sobia', '60', '10', NULL, '100', NULL, NULL, 4, '', 0),
  171. (47, 'Carob ', 'Kharoob ', '40', '15', NULL, '100', NULL, NULL, 4, '', 0),
  172. (48, 'WAGBET EL HAFALAT ( 21 PCS )', '21 pcs. of spicy or original chicken, family fries, large coleslaw and 12 fresh buns', '26000', '284', NULL, '236', NULL, NULL, 1, '', 0),
  173. (49, 'Orchid – Orchis Mascula', 'Sahlab', '80', '12', NULL, '80', NULL, NULL, 4, '', 0),
  174. (50, 'SHRIMPS SHARING MEAL', '20 pcs of Shrimps, 2 Cocktail Sauce, 2 Dynamite Sauces, 1 Large Coleslaw, 1 Family Fries, 3 Large Rice (w/o chicken) and 8 Buns', '2330', '215', NULL, '100', NULL, NULL, 1, '', 0),
  175. (51, 'Cantaloupe', 'refreshing', '60', '15', NULL, '50', NULL, NULL, 4, '', 0),
  176. (52, 'Watermelon', 'refreshing', '60', '15', NULL, '80', NULL, NULL, 4, '', 0);
  177.  
  178. -- --------------------------------------------------------
  179.  
  180. --
  181. -- Table structure for table `keywords`
  182. --
  183.  
  184. CREATE TABLE `keywords` (
  185. `kwid` int(11) NOT NULL,
  186. `kwname` varchar(255) NOT NULL,
  187. `kwmp` int(11) NOT NULL
  188. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  189.  
  190. -- --------------------------------------------------------
  191.  
  192. --
  193. -- Table structure for table `orderitems`
  194. --
  195.  
  196. CREATE TABLE `orderitems` (
  197. `orderid` int(11) NOT NULL,
  198. `itemid` int(11) DEFAULT NULL,
  199. `bundleid` varchar(255) DEFAULT NULL
  200. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  201.  
  202. -- --------------------------------------------------------
  203.  
  204. --
  205. -- Table structure for table `orders`
  206. --
  207.  
  208. CREATE TABLE `orders` (
  209. `oid` int(11) NOT NULL,
  210. `oiid` int(11) NOT NULL,
  211. `inote` varchar(255) DEFAULT NULL,
  212. `opayment` varchar(255) DEFAULT NULL,
  213. `obalance` varchar(255) DEFAULT NULL,
  214. `oprice` decimal(10,2) DEFAULT NULL,
  215. `opaymentmethod` varchar(255) DEFAULT NULL,
  216. `stat` varchar(255) DEFAULT NULL,
  217. `orderrest` int(255) DEFAULT NULL,
  218. `orderuser` int(22) NOT NULL,
  219. `oday` int(22) NOT NULL,
  220. `ohour` int(22) NOT NULL,
  221. `ominute` int(22) NOT NULL,
  222. `omonth` int(22) NOT NULL,
  223. `oyear` int(22) NOT NULL
  224. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  225.  
  226. --
  227. -- Dumping data for table `orders`
  228. --
  229.  
  230. INSERT INTO `orders` (`oid`, `oiid`, `inote`, `opayment`, `obalance`, `oprice`, `opaymentmethod`, `stat`, `orderrest`, `orderuser`, `oday`, `ohour`, `ominute`, `omonth`, `oyear`) VALUES
  231. (41, 28, 'Apple Pie', '1', '13', '13.00', '3', '1', 2, 39, 4, 13, 54, 5, 2019),
  232. (40, 28, 'Apple Pie', '1', '13', '13.00', '1', '1', 2, 39, 4, 13, 54, 5, 2019),
  233. (39, 26, 'Big Mac', '1', '14', '14.00', '1', '1', 2, 39, 4, 13, 47, 5, 2019),
  234. (38, 9, 'FUE Candy 2', '1', '68', '68.00', '1', '1', 2, 39, 4, 13, 46, 5, 2019),
  235. (37, 9, 'FUE Candy 2', '1', '68', '68.00', '2', '1', 2, 39, 4, 13, 45, 5, 2019),
  236. (42, 28, 'Apple Pie', '1', '13', '13.00', '3', '1', 2, 39, 4, 13, 54, 5, 2019),
  237. (43, 28, 'Apple Pie', '1', '13', '13.00', '1', '0', 2, 39, 4, 13, 54, 5, 2019),
  238. (44, 28, 'Apple Pie', '1', '13', '13.00', '1', '3', 2, 39, 4, 13, 55, 5, 2019),
  239. (45, 28, 'Apple Pie', '1', '13', '13.00', '2', '3', 2, 50, 4, 14, 13, 5, 2019),
  240. (46, 28, 'Apple Pie', '1', '13', '13.00', '1', '1', 2, 39, 4, 18, 50, 5, 2019),
  241. (47, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  242. (48, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  243. (49, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  244. (50, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  245. (51, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  246. (52, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  247. (53, 29, 'Roma', '1', '69', '69.00', '3', '1', 2, 39, 4, 19, 7, 5, 2019),
  248. (54, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  249. (55, 29, 'Roma', '1', '69', '69.00', '3', '1', 2, 39, 4, 19, 7, 5, 2019),
  250. (56, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  251. (57, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  252. (58, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  253. (59, 29, 'Roma', '1', '69', '69.00', '1', '1', 2, 39, 4, 19, 7, 5, 2019),
  254. (60, 29, 'Roma', '1', '69', '69.00', '2', '1', 2, 39, 4, 19, 34, 5, 2019);
  255.  
  256. -- --------------------------------------------------------
  257.  
  258. --
  259. -- Table structure for table `restaurant`
  260. --
  261.  
  262. CREATE TABLE `restaurant` (
  263. `rid` int(11) NOT NULL,
  264. `rusername` varchar(255) NOT NULL,
  265. `password` varchar(99) NOT NULL,
  266. `rname` varchar(255) DEFAULT NULL,
  267. `rworkhoursbegin` varchar(255) DEFAULT NULL,
  268. `rworkhoursend` varchar(55) NOT NULL,
  269. `rpricerange` varchar(255) DEFAULT NULL,
  270. `rrate` varchar(255) DEFAULT NULL,
  271. `fd_id` int(11) DEFAULT NULL,
  272. `ownermail` varchar(33) NOT NULL,
  273. `phonenumber` varchar(33) NOT NULL,
  274. `level` varchar(33) NOT NULL
  275. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  276.  
  277. --
  278. -- Dumping data for table `restaurant`
  279. --
  280.  
  281. INSERT INTO `restaurant` (`rid`, `rusername`, `password`, `rname`, `rworkhoursbegin`, `rworkhoursend`, `rpricerange`, `rrate`, `fd_id`, `ownermail`, `phonenumber`, `level`) VALUES
  282. (1, 'kfc', 'f5bb0c8de146c67b44babbf4e6584cc0', 'KFC', '1', '10', '3', '5', 1, '', '', ''),
  283. (2, 'mac', 'f5bb0c8de146c67b44babbf4e6584cc0', 'McDonalds', '1', '10', '3', '5', 1, '', '', ''),
  284. (3, 'walid', 'f5bb0c8de146c67b44babbf4e6584cc0', 'Walid Food', '2', '10', '3', '5', 2, '', '', ''),
  285. (4, 'mounir', 'f5bb0c8de146c67b44babbf4e6584cc0', 'Mounir Drinks', '2', '10', '3', '5', 2, '', '', ''),
  286. (5, 'omar', 'f5bb0c8de146c67b44babbf4e6584cc0', 'Omar Icecream', '3', '10', '3', '5', 3, '', '', ''),
  287. (6, 'hakeem', 'f5bb0c8de146c67b44babbf4e6584cc0', 'Hakeem Kebab', '1', '10', '3', '5', 3, '', '', ''),
  288. (7, 'emilie', 'f5bb0c8de146c67b44babbf4e6584cc0', '1', '1', '1', '1', '1', 1, '1', '1', '1');
  289.  
  290. -- --------------------------------------------------------
  291.  
  292. --
  293. -- Table structure for table `users`
  294. --
  295.  
  296. CREATE TABLE `users` (
  297. `uid` int(11) NOT NULL,
  298. `cartid` int(22) NOT NULL,
  299. `fname` varchar(255) DEFAULT NULL,
  300. `lastname` varchar(255) DEFAULT NULL,
  301. `nickname` varchar(255) DEFAULT NULL,
  302. `bdate` date DEFAULT NULL,
  303. `gender` varchar(255) DEFAULT NULL,
  304. `mobile` varchar(255) DEFAULT NULL,
  305. `email` varchar(255) DEFAULT NULL,
  306. `password` varchar(999) NOT NULL,
  307. `lpoints` varchar(255) DEFAULT NULL,
  308. `balance` varchar(255) DEFAULT NULL,
  309. `accstatus` varchar(255) DEFAULT NULL,
  310. `level` varchar(255) DEFAULT NULL,
  311. `mailing` varchar(255) DEFAULT NULL,
  312. `intrest` varchar(255) DEFAULT NULL,
  313. `ActiveFC` int(11) DEFAULT NULL
  314. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  315.  
  316. --
  317. -- Dumping data for table `users`
  318. --
  319.  
  320. INSERT INTO `users` (`uid`, `cartid`, `fname`, `lastname`, `nickname`, `bdate`, `gender`, `mobile`, `email`, `password`, `lpoints`, `balance`, `accstatus`, `level`, `mailing`, `intrest`, `ActiveFC`) VALUES
  321. (31, 0, 'ahmed', 'walid', NULL, NULL, NULL, '01100446911', 'ahmed.wm96@gmail.com', 'f3c9f8ff331dab41a2363bca631e7aff', NULL, '99999999', NULL, NULL, NULL, NULL, NULL),
  322. (38, 0, 'Omar', 'Khaled', NULL, NULL, NULL, '1221184766', 'okmk@gmail.com', 'f5bb0c8de146c67b44babbf4e6584cc0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  323. (23, 0, 'kondos', 'otter', NULL, NULL, NULL, '123123123', '123@123.123', 'f5bb0c8de146c67b44babbf4e6584cc0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  324. (22, 0, 'Omar', 'Khaled', NULL, NULL, NULL, '1221184766', 'leoisomar@gmail.com', 'f5bb0c8de146c67b44babbf4e6584cc0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  325. (39, 0, 'Emilie', 'Braun', NULL, NULL, NULL, '011111111', 'emilie@emy.com', 'f5bb0c8de146c67b44babbf4e6584cc0', '11', '938', NULL, NULL, NULL, NULL, NULL),
  326. (40, 0, 'Mikky', 'Hana', NULL, NULL, NULL, '0111111111', 'mikky@gmail.com', 'f5bb0c8de146c67b44babbf4e6584cc0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  327. (41, 0, 'Sad', 'Sad', NULL, NULL, NULL, '1111111111', 'sad@sad.com', 'f5bb0c8de146c67b44babbf4e6584cc0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  328. (42, 0, 'Hazem', 'Khaled', NULL, NULL, NULL, '01015089906', 'hazem.khaled1411@yahoo.com', '73276d5555732d9ad9677e8c6bb17e9c', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  329. (43, 0, 'fewg', '4why53hy', NULL, NULL, NULL, '11111111111', 'sosad@sad.com', '49f0bad299687c62334182178bfd75d8', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  330. (44, 0, 'Mohamed ', 'Amer', NULL, NULL, NULL, '01010657535', 'medoamer2530@yahoo.com', '9ce04de8917799a7bfd72ba2163a46ed', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  331. (45, 0, 'Mira', 'Tamer', NULL, NULL, NULL, '010022222', 'mira@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', NULL, '9999', NULL, NULL, NULL, NULL, NULL),
  332. (46, 0, 'sara', 'ahmed', NULL, NULL, NULL, '010000000', 'sara@gmail.com', '25f9e794323b453885f5181f1b624d0b', NULL, '99996', NULL, NULL, NULL, NULL, NULL),
  333. (47, 0, 'Diea', 'Ahmed', NULL, NULL, NULL, '01000677899', 'diea.strategy@gmail.com', 'f1e09ef95b0f5b2be217ee9d9baa198c', NULL, '9861', NULL, NULL, NULL, NULL, NULL),
  334. (48, 0, 'wel', 'most', NULL, NULL, NULL, '01100446919', 'BL7@batnya.com', '25f9e794323b453885f5181f1b624d0b', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  335. (49, 0, 'Ahmed', 'Hakim', NULL, NULL, NULL, '01000427030', 'hamada_prince@ymail.com', 'ae1d04f8ecdff0896f3002c38e69f3e0', NULL, '15000000000', NULL, NULL, NULL, NULL, NULL),
  336. (50, 0, 'Kamalo', 'Ahmed', NULL, NULL, NULL, '011111111', 'kamalo@gmail.com', 'f5bb0c8de146c67b44babbf4e6584cc0', '44444444', '3333320', NULL, NULL, NULL, NULL, NULL);
  337.  
  338. --
  339. -- Indexes for dumped tables
  340. --
  341.  
  342. --
  343. -- Indexes for table `admin`
  344. --
  345. ALTER TABLE `admin`
  346. ADD PRIMARY KEY (`id`);
  347.  
  348. --
  349. -- Indexes for table `bundle`
  350. --
  351. ALTER TABLE `bundle`
  352. ADD PRIMARY KEY (`bid`);
  353.  
  354. --
  355. -- Indexes for table `bundleitems`
  356. --
  357. ALTER TABLE `bundleitems`
  358. ADD PRIMARY KEY (`bundleid`),
  359. ADD KEY `itemid` (`itemid`);
  360.  
  361. --
  362. -- Indexes for table `cartbundles`
  363. --
  364. ALTER TABLE `cartbundles`
  365. ADD PRIMARY KEY (`brecordid`);
  366.  
  367. --
  368. -- Indexes for table `cartitems`
  369. --
  370. ALTER TABLE `cartitems`
  371. ADD PRIMARY KEY (`irecordid`);
  372.  
  373. --
  374. -- Indexes for table `foodcourt`
  375. --
  376. ALTER TABLE `foodcourt`
  377. ADD PRIMARY KEY (`fid`),
  378. ADD UNIQUE KEY `fid` (`fid`) USING BTREE;
  379.  
  380. --
  381. -- Indexes for table `items`
  382. --
  383. ALTER TABLE `items`
  384. ADD PRIMARY KEY (`iid`),
  385. ADD KEY `rid` (`rid`);
  386.  
  387. --
  388. -- Indexes for table `keywords`
  389. --
  390. ALTER TABLE `keywords`
  391. ADD PRIMARY KEY (`kwid`);
  392.  
  393. --
  394. -- Indexes for table `orderitems`
  395. --
  396. ALTER TABLE `orderitems`
  397. ADD PRIMARY KEY (`orderid`),
  398. ADD KEY `itemid` (`itemid`);
  399.  
  400. --
  401. -- Indexes for table `orders`
  402. --
  403. ALTER TABLE `orders`
  404. ADD PRIMARY KEY (`oid`),
  405. ADD KEY `orderrest` (`orderrest`),
  406. ADD KEY `orderuser` (`orderuser`);
  407.  
  408. --
  409. -- Indexes for table `restaurant`
  410. --
  411. ALTER TABLE `restaurant`
  412. ADD PRIMARY KEY (`rid`) USING BTREE,
  413. ADD KEY `fd_id` (`fd_id`);
  414.  
  415. --
  416. -- Indexes for table `users`
  417. --
  418. ALTER TABLE `users`
  419. ADD PRIMARY KEY (`uid`);
  420.  
  421. --
  422. -- AUTO_INCREMENT for dumped tables
  423. --
  424.  
  425. --
  426. -- AUTO_INCREMENT for table `admin`
  427. --
  428. ALTER TABLE `admin`
  429. MODIFY `id` int(22) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  430.  
  431. --
  432. -- AUTO_INCREMENT for table `bundle`
  433. --
  434. ALTER TABLE `bundle`
  435. MODIFY `bid` int(11) NOT NULL AUTO_INCREMENT;
  436.  
  437. --
  438. -- AUTO_INCREMENT for table `cartbundles`
  439. --
  440. ALTER TABLE `cartbundles`
  441. MODIFY `brecordid` int(11) NOT NULL AUTO_INCREMENT;
  442.  
  443. --
  444. -- AUTO_INCREMENT for table `cartitems`
  445. --
  446. ALTER TABLE `cartitems`
  447. MODIFY `irecordid` int(22) NOT NULL AUTO_INCREMENT;
  448.  
  449. --
  450. -- AUTO_INCREMENT for table `foodcourt`
  451. --
  452. ALTER TABLE `foodcourt`
  453. MODIFY `fid` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  454.  
  455. --
  456. -- AUTO_INCREMENT for table `items`
  457. --
  458. ALTER TABLE `items`
  459. MODIFY `iid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
  460.  
  461. --
  462. -- AUTO_INCREMENT for table `keywords`
  463. --
  464. ALTER TABLE `keywords`
  465. MODIFY `kwid` int(11) NOT NULL AUTO_INCREMENT;
  466.  
  467. --
  468. -- AUTO_INCREMENT for table `orders`
  469. --
  470. ALTER TABLE `orders`
  471. MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
  472.  
  473. --
  474. -- AUTO_INCREMENT for table `restaurant`
  475. --
  476. ALTER TABLE `restaurant`
  477. MODIFY `rid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  478.  
  479. --
  480. -- AUTO_INCREMENT for table `users`
  481. --
  482. ALTER TABLE `users`
  483. MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
  484. COMMIT;
  485.  
  486. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  487. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  488. /*!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!