API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 8th, 2018
624
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.26 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE Raters(
  2. USERID SERIAL NOT NULL PRIMARY KEY,
  3. EMAIL TEXT NOT NULL,
  4. USERNAME TEXT NOT NULL,
  5. JOIN_DATE DATE NOT NULL DEFAULT CURRENT_DATE,
  6. TYPE TEXT,
  7. REPUTATION INT NOT NULL DEFAULT 0,
  8. CHECK (REPUTATION BETWEEN 0 AND 10)
  9. );
  10. CREATE TABLE Restaurants(
  11. RESTAURANTID SERIAL NOT NULL PRIMARY KEY,
  12. RESTAURANT_NAME TEXT NOT NULL,
  13. CUISINE TEXT NOT NULL,
  14. URL TEXT,
  15. HOUR_OPEN INT,
  16. HOUR_CLOSE INT
  17. );
  18.  
  19. CREATE TABLE Locations(
  20. LOCATIONID SERIAL NOT NULL PRIMARY KEY,
  21. FIRST_OPEN_DATE DATE NOT NULL,
  22. MANAGER_NAME TEXT,
  23. PHONE_NUMBER TEXT,
  24. ADDRESS TEXT NOT NULL,
  25. RESTAURANTID SERIAL NOT NULL,
  26. FOREIGN KEY (RESTAURANTID)
  27. REFERENCES Restaurants(RESTAURANTID)
  28. );
  29.  
  30.  
  31. CREATE TABLE Menu_Items(
  32. ITEMID SERIAL NOT NULL PRIMARY KEY,
  33. NAME TEXT NOT NULL,
  34. TYPE TEXT NOT NULL,
  35. DESCRIPTION TEXT,
  36. PRICE NUMERIC NOT NULL,
  37. RESTAURANTID SERIAL NOT NULL,
  38. FOREIGN KEY (RESTAURANTID)
  39. REFERENCES Locations(LOCATIONID)
  40. );
  41.  
  42. CREATE TABLE Ratings(
  43. USERID SERIAL NOT NULL,
  44. RATING_DATE DATE NOT NULL DEFAULT CURRENT_DATE,
  45. PRICE INT NOT NULL,
  46. FOOD INT NOT NULL ,
  47. MOOD INT,
  48. STAFF INT,
  49. COMMENTS TEXT ,
  50. RESTAURANTID SERIAL NOT NULL,
  51. PRIMARY KEY (USERID, RATING_DATE),
  52. FOREIGN KEY (USERID)
  53. REFERENCES Raters(USERID)
  54. );
  55.  
  56. CREATE TABLE Rating_Items(
  57. USERID SERIAL NOT NULL,
  58. RATING_DATE DATE NOT NULL DEFAULT CURRENT_DATE,
  59. ITEMID SERIAL NOT NULL,
  60. RATING INT NOT NULL,
  61. COMMENTS TEXT,
  62. CHECK(RATING BETWEEN 1 AND 5),
  63. PRIMARY KEY (USERID, RATING_DATE, ITEMID),
  64. FOREIGN KEY (USERID, RATING_DATE)
  65. REFERENCES Ratings(USERID, RATING_DATE),
  66. FOREIGN KEY (USERID)
  67. REFERENCES Raters(USERID)
  68. );
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76. INSERT INTO Raters VALUES ('0', 'skirtgrass@gmail.com', 'skirtgrass80', '2018-02-16', 'food critic', '2');
  77. INSERT INTO Raters VALUES ('1', 'poundstomach@gmail.com', 'poundstomach67', '2018-06-05', 'blog', '8');
  78. INSERT INTO Raters VALUES ('2', 'channelsoftware@gmail.com', 'channelsoftware14', '2017-06-01', 'food critic', '7');
  79. INSERT INTO Raters VALUES ('3', 'bearnumber@gmail.com', 'bearnumber85', '2018-06-17', 'online', '6');
  80. INSERT INTO Raters VALUES ('4', 'futurepublic@gmail.com', 'futurepublic13', '2017-03-13', 'food critic', '6');
  81. INSERT INTO Raters VALUES ('5', 'friendsource@gmail.com', 'friendsource69', '2017-01-06', 'blog', '8');
  82. INSERT INTO Raters VALUES ('6', 'fruitease@gmail.com', 'fruitease3', '2018-09-01', 'blog', '8');
  83. INSERT INTO Raters VALUES ('7', 'clockfinal@gmail.com', 'clockfinal95', '2018-06-13', 'online', '7');
  84. INSERT INTO Raters VALUES ('8', 'moneypractice@gmail.com', 'moneypractice55', '2017-02-17', 'online', '6');
  85. INSERT INTO Raters VALUES ('9', 'applicationchance@gmail.com', 'applicationchance6', '2018-08-13', 'blog', '5');
  86. INSERT INTO Raters VALUES ('10', 'leaderapple@gmail.com', 'leaderapple95', '2017-02-12', 'food critic', '5');
  87. INSERT INTO Raters VALUES ('11', 'layusual@gmail.com', 'layusual1', '2018-02-19', 'online', '7');
  88. INSERT INTO Raters VALUES ('12', 'commerciallecture@gmail.com', 'commerciallecture6', '2017-02-14', 'food critic', '9');
  89. INSERT INTO Raters VALUES ('13', 'chocolatephase@gmail.com', 'chocolatephase78', '2017-05-14', 'online', '6');
  90. INSERT INTO Raters VALUES ('14', 'hourrespond@gmail.com', 'hourrespond18', '2017-01-14', 'food critic', '8');
  91. INSERT INTO Restaurants VALUES ('0', 'Suck While', 'indian', 'SuckWhile@gmail.com', '4', '20');
  92. INSERT INTO Restaurants VALUES ('1', 'Competition Miss', 'canadian', 'CompetitionMiss@gmail.com', '4', '18');
  93. INSERT INTO Restaurants VALUES ('2', 'Hall Diet', 'american', 'HallDiet@gmail.com', '4', '24');
  94. INSERT INTO Restaurants VALUES ('3', 'Shopping Blue', 'indian', 'ShoppingBlue@gmail.com', '4', '7');
  95. INSERT INTO Restaurants VALUES ('4', 'Disease Abuse', 'canadian', 'DiseaseAbuse@gmail.com', '4', '20');
  96. INSERT INTO Restaurants VALUES ('5', 'Tale Oil', 'chinese', 'TaleOil@gmail.com', '4', '19');
  97. INSERT INTO Restaurants VALUES ('6', 'Primary Aside', 'chinese', 'PrimaryAside@gmail.com', '4', '15');
  98. INSERT INTO Restaurants VALUES ('7', 'Operation Fuel', 'italian', 'OperationFuel@gmail.com', '4', '24');
  99. INSERT INTO Restaurants VALUES ('8', 'Confidence Trainer', 'canadian', 'ConfidenceTrainer@gmail.com', '4', '16');
  100. INSERT INTO Restaurants VALUES ('9', 'Promise Report', 'chinese', 'PromiseReport@gmail.com', '4', '12');
  101. INSERT INTO Restaurants VALUES ('10', 'Structure Passenger', 'american', 'StructurePassenger@gmail.com', '4', '23');
  102. INSERT INTO Restaurants VALUES ('11', 'Training Breast', 'middle eastern', 'TrainingBreast@gmail.com', '4', '19');
  103. INSERT INTO Locations VALUES ('0', '2003-06-11', 'Madison', '269-622-7156', '167 Contact Rd', '2');
  104. INSERT INTO Locations VALUES ('1', '2005-03-11', 'William', '003-134-7781', '832 Cow Rd', '1');
  105. INSERT INTO Locations VALUES ('2', '2003-09-06', 'Liam', '422-696-3288', '106 Bother Rd', '9');
  106. INSERT INTO Locations VALUES ('3', '2000-06-19', 'Mia', '573-643-5287', '309 Doubt Rd', '2');
  107. INSERT INTO Locations VALUES ('4', '2004-08-19', 'Austin', '317-894-0712', '762 Primary Rd', '4');
  108. INSERT INTO Locations VALUES ('5', '2008-05-03', 'Harper', '940-790-2146', '549 Health Rd', '6');
  109. INSERT INTO Locations VALUES ('6', '2002-06-04', 'Mia', '132-788-5036', '512 Strip Rd', '1');
  110. INSERT INTO Locations VALUES ('7', '2006-02-05', 'William', '261-258-9779', '210 Chemistry Rd', '2');
  111. INSERT INTO Locations VALUES ('8', '2000-07-13', 'Mia', '601-828-8353', '845 Service Rd', '0');
  112. INSERT INTO Locations VALUES ('9', '2004-05-08', 'Noah', '433-161-8978', '216 Chip Rd', '1');
  113. INSERT INTO Locations VALUES ('10', '2006-01-13', 'Bob', '894-695-1493', '855 Drag Rd', '0');
  114. INSERT INTO Locations VALUES ('11', '2002-07-13', 'Chloe', '818-277-8771', '461 Effect Rd', '6');
  115. INSERT INTO Ratings VALUES ('14', '2013-08-03', '2', '0', '4', '4', 'drunk thought', '11');
  116. INSERT INTO Ratings VALUES ('5', '2013-04-02', '5', '0', '2', '0', '', '2');
  117. INSERT INTO Ratings VALUES ('1', '2011-08-01', '3', '5', '0', '2', 'cut method bag travel room look landscape speaker conflict unique text mirror fat estimate bell attitude issue minor substance', '11');
  118. INSERT INTO Ratings VALUES ('4', '2016-02-08', '2', '4', '3', '1', 'clue health attempt extreme beginning', '6');
  119. INSERT INTO Ratings VALUES ('13', '2010-06-11', '2', '3', '1', '1', 'upstairs soft instruction inspection east plan button spell', '1');
  120. INSERT INTO Ratings VALUES ('9', '2015-05-13', '3', '4', '1', '3', 'coat', '11');
  121. INSERT INTO Ratings VALUES ('7', '2016-07-18', '2', '4', '1', '5', 'stretch blank age pride bridge prize being resident day rise progress', '1');
  122. INSERT INTO Ratings VALUES ('12', '2014-08-14', '4', '5', '5', '2', 'double airline success essay sweet industry part bit equal fill title promise substance wall classroom', '0');
  123. INSERT INTO Ratings VALUES ('11', '2014-08-18', '4', '5', '4', '1', 'opposite major teaching', '8');
  124. INSERT INTO Ratings VALUES ('2', '2017-03-08', '0', '4', '3', '0', 'nobody impact formal shift', '9');
  125. INSERT INTO Ratings VALUES ('3', '2015-05-16', '4', '0', '4', '2', 'dinner', '11');
  126. INSERT INTO Ratings VALUES ('0', '2012-03-14', '1', '5', '1', '4', 'form month climate knowledge restaurant fill increase length brother age assignment objective bowl depression guidance', '2');
  127. INSERT INTO Ratings VALUES ('14', '2012-07-13', '4', '1', '4', '5', 'feedback', '7');
  128. INSERT INTO Ratings VALUES ('5', '2014-03-02', '1', '2', '4', '2', 'give crazy dress length committee campaign outcome slide native arm building band guy', '11');
  129. INSERT INTO Ratings VALUES ('12', '2018-03-09', '3', '4', '3', '1', 'medicine history document', '6');
  130. INSERT INTO Ratings VALUES ('6', '2013-01-15', '4', '5', '5', '1', 'understanding', '1');
  131. INSERT INTO Ratings VALUES ('1', '2018-02-08', '2', '2', '2', '5', 'concern crazy egg injury reference', '1');
  132. INSERT INTO Ratings VALUES ('10', '2014-09-19', '0', '4', '5', '4', 'two singer sell demand value education birth airport foundation counter leading foot model report', '3');
  133. INSERT INTO Ratings VALUES ('9', '2014-03-05', '5', '2', '2', '0', 'hand link preference consideration target load common', '5');
  134. INSERT INTO Ratings VALUES ('8', '2016-06-14', '0', '1', '1', '1', '', '9');
  135. INSERT INTO Ratings VALUES ('7', '2014-06-06', '2', '1', '1', '4', 'luck', '1');
  136. INSERT INTO Ratings VALUES ('13', '2016-07-15', '2', '4', '1', '2', 'beach possession blank parent plastic', '10');
  137. INSERT INTO Ratings VALUES ('11', '2014-04-08', '1', '4', '5', '1', 'preparation war winter wake', '0');
  138. INSERT INTO Ratings VALUES ('4', '2016-05-05', '5', '1', '4', '4', 'personal upper spot communication drive lawyer leading meet addition complex water speaker accident', '3');
  139. INSERT INTO Ratings VALUES ('3', '2013-03-07', '2', '1', '1', '3', 'college control range script', '7');
  140. INSERT INTO Ratings VALUES ('1', '2016-09-17', '0', '3', '5', '3', 'brick steak copy fortune reference consist bone save wood collar document', '7');
  141. INSERT INTO Ratings VALUES ('0', '2015-02-13', '3', '0', '3', '2', '', '11');
  142. INSERT INTO Ratings VALUES ('6', '2013-02-08', '4', '2', '1', '1', 'argument stick horse benefit mine cake chance tax establishment status society signature soup idea independent meeting', '2');
  143. INSERT INTO Ratings VALUES ('11', '2012-04-08', '0', '4', '5', '5', 'attitude method load pizza elevator program environment imagination requirement', '5');
  144. INSERT INTO Ratings VALUES ('7', '2017-04-04', '4', '3', '1', '4', 'necessary wife mine fight variety stand doctor art swimming local joint thought', '2');
  145. INSERT INTO Ratings VALUES ('13', '2013-06-19', '3', '5', '1', '0', '', '9');
  146. INSERT INTO Ratings VALUES ('8', '2012-03-07', '1', '3', '5', '4', 'primary evidence extent couple power', '5');
  147. INSERT INTO Ratings VALUES ('5', '2011-05-07', '4', '3', '0', '2', 'report manner', '0');
  148. INSERT INTO Ratings VALUES ('12', '2010-03-02', '4', '3', '5', '2', 'recommendation nobody poetry tongue north active trainer guy nail junior coat research literature memory church trash bike', '6');
  149. INSERT INTO Ratings VALUES ('10', '2014-04-09', '5', '5', '3', '1', 'brush common bird poet farm thanks economics window simple big drop shopping army estimate memory guard floor tip', '5');
  150. INSERT INTO Ratings VALUES ('14', '2017-06-06', '3', '2', '0', '0', 'organization guide scratch bell tree contribution relationship series north fuel count equivalent engineer market independence', '0');
  151. INSERT INTO Ratings VALUES ('5', '2018-07-07', '1', '0', '0', '1', 'maintenance red character rub one walk', '4');
  152. INSERT INTO Ratings VALUES ('13', '2013-06-12', '4', '1', '5', '1', 'procedure stress employee slide land long winner length death line peak', '6');
  153. INSERT INTO Ratings VALUES ('14', '2012-07-13', '1', '5', '5', '1', '', '8');
  154. INSERT INTO Ratings VALUES ('2', '2010-08-19', '0', '2', '1', '4', 'stress sound campaign signature border union meal nail normal trash button nail gas hat line', '2');
  155. INSERT INTO Ratings VALUES ('11', '2010-08-14', '3', '2', '5', '2', 'normal period bath picture', '7');
  156. INSERT INTO Ratings VALUES ('1', '2011-03-19', '2', '5', '5', '2', 'host grade issue impression speech penalty affect fact', '5');
  157. INSERT INTO Ratings VALUES ('10', '2012-03-18', '0', '5', '4', '5', '', '6');
  158. INSERT INTO Ratings VALUES ('7', '2013-02-08', '2', '2', '4', '2', 'error hunt park corner string nature dear yellow decision performance sugar holiday love', '1');
  159. INSERT INTO Ratings VALUES ('4', '2018-05-13', '0', '4', '1', '0', 'second road entrance middle reserve', '9');
  160. INSERT INTO Ratings VALUES ('3', '2012-04-04', '3', '1', '3', '0', 'private', '10');
  161. INSERT INTO Ratings VALUES ('8', '2018-04-08', '4', '5', '3', '3', 'roof land sign wash master gain student', '5');
  162. INSERT INTO Ratings VALUES ('0', '2017-02-02', '3', '4', '1', '5', 'weakness pride article rent finding shock calendar queen classic contract damage screw nation alternative', '3');
  163. INSERT INTO Ratings VALUES ('4', '2017-04-14', '3', '3', '1', '1', 'visit meet cold work professor commission street stage girl permit knee source rope exercise soil act active key', '0');
  164. INSERT INTO Ratings VALUES ('3', '2015-09-03', '0', '1', '1', '4', 'salary you pass', '3');
  165. INSERT INTO Ratings VALUES ('1', '2013-09-03', '0', '2', '4', '4', 'mother commission menu food', '3');
  166. INSERT INTO Ratings VALUES ('11', '2011-05-19', '3', '3', '0', '2', 'meat fall beautiful sock user consequence fact discount support hour horror cat addition apple', '4');
  167. INSERT INTO Ratings VALUES ('14', '2012-04-16', '1', '3', '3', '4', 'quarter bother public strip birthday phrase organization apartment song', '0');
  168. INSERT INTO Ratings VALUES ('9', '2010-08-02', '1', '2', '0', '2', '', '4');
  169. INSERT INTO Ratings VALUES ('13', '2012-08-15', '0', '2', '2', '3', 'table birthday river park fault post brilliant', '11');
  170. INSERT INTO Ratings VALUES ('12', '2014-05-03', '3', '5', '1', '3', 'shape divide chemistry vegetable', '11');
  171. INSERT INTO Ratings VALUES ('7', '2016-08-03', '4', '5', '0', '3', 'style government dream life list hospital priority understanding energy dump space channel hunt wonder', '3');
  172. INSERT INTO Ratings VALUES ('6', '2017-06-07', '3', '0', '2', '2', 'committee share signal hand credit adult', '6');
  173. INSERT INTO Ratings VALUES ('2', '2015-01-06', '5', '1', '2', '5', 'perspective', '9');
  174. INSERT INTO Ratings VALUES ('0', '2013-03-09', '0', '4', '0', '3', 'home pick presentation finding knee edge grass stable raw management breath stable guitar type surprise', '3');
  175. INSERT INTO Ratings VALUES ('12', '2015-09-16', '0', '2', '5', '0', 'few split combine fishing clock deposit usual race lay bunch escape drive listen self farmer salad', '6');
  176. INSERT INTO Ratings VALUES ('4', '2012-02-09', '5', '0', '0', '4', 'soft shoulder sample league', '3');
  177. INSERT INTO Ratings VALUES ('7', '2010-08-06', '1', '3', '5', '4', 'guidance perspective lift presentation object variety ratio drunk bother fortune self meet dot', '3');
  178. INSERT INTO Ratings VALUES ('14', '2013-09-11', '5', '0', '3', '0', 'bottom piano pain character pizza cream inspector advance buy basket signature passage truck president sink role definition', '6');
  179. INSERT INTO Ratings VALUES ('5', '2013-02-05', '3', '0', '2', '4', 'culture', '3');
  180. INSERT INTO Ratings VALUES ('10', '2015-03-03', '1', '2', '1', '4', 'stage wave profit basket side credit improvement place policy oil dependent conversation equivalent', '4');
  181. INSERT INTO Ratings VALUES ('8', '2013-08-16', '3', '0', '2', '4', 'shoe knowledge water lay stroke inflation partner screw solution big total camera stroke yellow', '9');
  182. INSERT INTO Ratings VALUES ('11', '2011-07-08', '0', '3', '4', '2', 'nothing promise air duty pleasure substance middle implement square pop comfortable operation plate', '4');
  183. INSERT INTO Ratings VALUES ('13', '2010-04-05', '3', '0', '0', '4', 'motor operation freedom worry kill', '6');
  184. INSERT INTO Ratings VALUES ('0', '2010-04-14', '4', '4', '0', '2', 'song check answer nasty book transition', '9');
  185. INSERT INTO Ratings VALUES ('1', '2015-04-05', '1', '0', '2', '2', 'sleep race', '11');
  186. INSERT INTO Ratings VALUES ('2', '2012-07-06', '0', '5', '5', '4', 'advertising demand potato detail appointment article classroom awareness diamond article', '1');
  187. INSERT INTO Ratings VALUES ('11', '2017-06-09', '4', '1', '0', '3', 'degree while jury god aside high material brush regular rush delivery', '3');
  188. INSERT INTO Ratings VALUES ('4', '2011-07-03', '3', '3', '1', '1', '', '7');
  189. INSERT INTO Ratings VALUES ('8', '2011-01-19', '0', '5', '3', '0', 'sensitive mission deal extreme earth principle progress street travel excuse animal version main effective physical floor', '10');
  190. INSERT INTO Ratings VALUES ('2', '2017-05-06', '3', '3', '1', '1', 'mate staff dare roof maintenance fear cow video serve author analysis description rice series cell grab material section bath', '6');
  191. INSERT INTO Ratings VALUES ('9', '2013-05-08', '2', '0', '3', '5', 'crack goal remote duty ability female tackle menu low jury protection friendship front relative substance', '5');
  192. INSERT INTO Ratings VALUES ('10', '2013-07-15', '0', '5', '0', '3', 'head save kid pull chair routine pain refrigerator', '9');
  193. INSERT INTO Ratings VALUES ('0', '2010-09-09', '5', '4', '3', '1', 'poem diamond location program candidate', '11');
  194. INSERT INTO Ratings VALUES ('13', '2012-01-13', '4', '4', '5', '5', 'factor emotion length relation strategy interaction opposite', '2');
  195. INSERT INTO Ratings VALUES ('12', '2010-07-05', '4', '0', '2', '3', '', '10');
  196. INSERT INTO Ratings VALUES ('5', '2012-01-15', '1', '1', '4', '4', 'might head increase track neat district', '10');
  197. INSERT INTO Ratings VALUES ('3', '2014-06-08', '4', '5', '1', '4', 'value theory joke priority', '1');
  198. INSERT INTO Ratings VALUES ('7', '2012-06-03', '0', '0', '2', '2', 'minor nerve call independent', '7');
  199. INSERT INTO Ratings VALUES ('5', '2012-07-17', '3', '3', '3', '5', 'doctor string sell individual cream photo while log fire boring house pipe produce animal plastic', '9');
  200. INSERT INTO Ratings VALUES ('12', '2012-04-18', '3', '5', '2', '4', 'border schedule', '1');
  201. INSERT INTO Ratings VALUES ('1', '2014-06-13', '5', '2', '3', '0', 'user inspector', '10');
  202. INSERT INTO Ratings VALUES ('14', '2016-07-09', '0', '5', '0', '1', 'goal resort boring ground sound risk a credit', '11');
  203. INSERT INTO Ratings VALUES ('7', '2016-05-01', '1', '3', '4', '2', 'negative truck math direction mountain guess', '3');
  204. INSERT INTO Ratings VALUES ('3', '2018-01-17', '0', '0', '4', '0', 'principle news issue length pin winter partner amount chapter son ball attack account customer knee report buddy society', '9');
  205. INSERT INTO Ratings VALUES ('11', '2012-02-17', '0', '5', '3', '3', 'ordinary development middle funeral state sky description range film concert yard cake credit piece impress concert fishing active', '8');
  206. INSERT INTO Ratings VALUES ('13', '2010-01-09', '5', '2', '1', '1', '', '4');
  207. INSERT INTO Ratings VALUES ('6', '2015-01-05', '4', '5', '5', '3', 'contact green equipment collection power event boyfriend feature pollution being play lay complaint army', '0');
  208. INSERT INTO Ratings VALUES ('0', '2012-07-03', '3', '0', '5', '4', 'art attention lock camp duty limit experience classroom mixture finance expression post address assignment marriage owner increase relief', '7');
  209.  
  210.  
  211.  
  212.  
  213. INSERT INTO Menu_Items VALUES ('0', 'Beef Stroganoff', 'Desert', 'kiss sister press effective trouble leg', '97.53', '1');
  214. INSERT INTO Menu_Items VALUES ('1', 'BeaverTail', 'Starter', 'log dust tip replacement alarm red', '9.35', '10');
  215. INSERT INTO Menu_Items VALUES ('2', 'Sushi', 'Desert', 'hire inside speaker', '43.91', '0');
  216. INSERT INTO Menu_Items VALUES ('3', 'Shawarma', 'Starter', 'clerk delay stranger', '8.98', '3');
  217. INSERT INTO Menu_Items VALUES ('4', 'BeaverTail', 'Starter', 'owner ease', '80.98', '9');
  218. INSERT INTO Menu_Items VALUES ('5', 'Curry', 'Desert', 'animal profession ladder main interaction theme worth return engineer', '58.31', '4');
  219. INSERT INTO Menu_Items VALUES ('6', 'Pizza', 'Starter', 'dead entertainment weight potato cook task airline bother', '50.73', '8');
  220. INSERT INTO Menu_Items VALUES ('7', 'Pho', 'Starter', 'tomorrow original discussion attempt skirt internet go manufacturer', '28.10', '6');
  221. INSERT INTO Menu_Items VALUES ('8', 'Beef Stroganoff', 'Starter', 'distribution death restaurant landscape', '10.56', '5');
  222. INSERT INTO Menu_Items VALUES ('9', 'Sushi', 'Main', 'savings insect lift', '53.79', '2');
  223. INSERT INTO Menu_Items VALUES ('10', 'Honey Baked Chicken', 'Desert', 'associate flower wear decision tap', '85.57', '11');
  224. INSERT INTO Menu_Items VALUES ('11', 'Taco', 'Starter', 'campaign', '24.28', '7');
  225. INSERT INTO Menu_Items VALUES ('12', 'Sushi', 'Main', 'charity brush cat restaurant', '57.66', '6');
  226. INSERT INTO Menu_Items VALUES ('13', 'Bagel', 'Desert', 'dear', '72.05', '1');
  227. INSERT INTO Menu_Items VALUES ('14', 'Salisbury Steak', 'Desert', 'structure cancer finger reason bottle chip math funeral', '23.39', '5');
  228. INSERT INTO Menu_Items VALUES ('15', 'Honey Baked Chicken', 'Desert', 'blame sir degree section resolve rest', '9.29', '10');
  229. INSERT INTO Menu_Items VALUES ('16', 'Pizza', 'Starter', 'fat person', '62.63', '7');
  230. INSERT INTO Menu_Items VALUES ('17', 'Beef Stroganoff', 'Starter', 'passage patient maintenance husband male appearance record', '30.15', '3');
  231. INSERT INTO Menu_Items VALUES ('18', 'Croissant', 'Starter', 'relationship marriage', '35.80', '0');
  232. INSERT INTO Menu_Items VALUES ('19', 'Pho', 'Main', 'stable bar food steal sock ad investment course guide', '89.61', '8');
  233. INSERT INTO Menu_Items VALUES ('20', 'Shawarma', 'Desert', 'scratch', '64.06', '4');
  234. INSERT INTO Menu_Items VALUES ('21', 'Bagel', 'Desert', 'location story grandfather grocery appointment accident thought city', '63.98', '9');
  235. INSERT INTO Menu_Items VALUES ('22', 'Taco', 'Main', 'half buy self', '25.63', '11');
  236. INSERT INTO Menu_Items VALUES ('23', 'Beef Stroganoff', 'Main', 'administration dinner most', '13.14', '2');
  237. INSERT INTO Menu_Items VALUES ('24', 'BeaverTail', 'Desert', 'dog security share example solid cream pace cancer', '40.01', '8');
  238. INSERT INTO Menu_Items VALUES ('25', 'Curry', 'Starter', '', '73.11', '11');
  239. INSERT INTO Menu_Items VALUES ('26', 'Quiche', 'Main', 'video listen', '7.18', '10');
  240. INSERT INTO Menu_Items VALUES ('27', 'Donair', 'Desert', 'pair rest session impression flight guest cream', '20.79', '1');
  241. INSERT INTO Menu_Items VALUES ('28', 'Honey Baked Chicken', 'Main', 'heart midnight punch stupid police environment minute nerve', '6.82', '2');
  242. INSERT INTO Menu_Items VALUES ('29', 'Taco', 'Main', 'youth direction trust percentage split progress leader single pause', '59.26', '3');
  243. INSERT INTO Menu_Items VALUES ('30', 'Pizza', 'Main', 'editor score external motor page code hand', '95.61', '0');
  244. INSERT INTO Menu_Items VALUES ('31', 'Honey Baked Chicken', 'Desert', '', '53.76', '5');
  245. INSERT INTO Menu_Items VALUES ('32', 'Bagel', 'Main', 'fat deal door bat police room listen drawing site', '0.12', '7');
  246. INSERT INTO Menu_Items VALUES ('33', 'Curry', 'Desert', 'classic slide grocery spend mix tough might professional traffic', '17.75', '4');
  247. INSERT INTO Menu_Items VALUES ('34', 'Beef Stroganoff', 'Starter', 'ask mate pressure tune organization future dependent land gold', '40.08', '9');
  248. INSERT INTO Menu_Items VALUES ('35', 'Beef Stroganoff', 'Main', '', '82.21', '6');
  249. INSERT INTO Menu_Items VALUES ('36', 'Sushi', 'Desert', 'round player bid', '81.85', '1');
  250. INSERT INTO Menu_Items VALUES ('37', 'Croissant', 'Desert', 'might effective watch university breath perspective dance', '2.66', '8');
  251. INSERT INTO Menu_Items VALUES ('38', 'Beef Stroganoff', 'Main', '', '71.19', '5');
  252. INSERT INTO Menu_Items VALUES ('39', 'Sushi', 'Starter', 'pain brush sort variety session key text repair care', '77.22', '11');
  253.  
  254.  
  255.  
  256. INSERT INTO Rating_Items VALUES ('7', '2014-06-06', '14', '1', 'rule wake dish');
  257. INSERT INTO Rating_Items VALUES ('13', '2016-07-15', '2', '3', '');
  258. INSERT INTO Rating_Items VALUES ('11', '2014-04-08', '23', '3', 'relationship response');
  259. INSERT INTO Rating_Items VALUES ('4', '2016-05-05', '15', '2', 'ball bend leather possession');
  260. INSERT INTO Rating_Items VALUES ('3', '2013-03-07', '28', '1', '');
  261. INSERT INTO Rating_Items VALUES ('1', '2016-09-17', '3', '5', 'block organization disease luck case thing dark potato yard');
  262. INSERT INTO Rating_Items VALUES ('0', '2015-02-13', '24', '4', 'thing relative period');
  263. INSERT INTO Rating_Items VALUES ('6', '2013-02-08', '35', '2', 'grass ground side devil growth');
  264. INSERT INTO Rating_Items VALUES ('11', '2012-04-08', '21', '1', '');
  265. INSERT INTO Rating_Items VALUES ('7', '2017-04-04', '22', '2', 'pain substance relationship anything bear twist investment');
  266. INSERT INTO Rating_Items VALUES ('13', '2013-06-19', '29', '1', 'boat');
  267. INSERT INTO Rating_Items VALUES ('8', '2012-03-07', '37', '2', 'crew shoot egg understanding skin theme company');
  268. INSERT INTO Rating_Items VALUES ('5', '2011-05-07', '9', '1', 'health shine trade dance emergency strip war stranger series');
  269. INSERT INTO Rating_Items VALUES ('12', '2010-03-02', '22', '4', 'recommendation shoot hole gate road significance background');
  270. INSERT INTO Rating_Items VALUES ('10', '2014-04-09', '14', '2', 'tree leading water try judge sugar');
  271. INSERT INTO Rating_Items VALUES ('14', '2017-06-06', '17', '5', 'campaign code bench hide resist anybody');
  272. INSERT INTO Rating_Items VALUES ('5', '2018-07-07', '15', '4', 'assistant boat mine complaint hit leave burn oven band');
  273. INSERT INTO Rating_Items VALUES ('13', '2013-06-12', '28', '2', 'death week clock spend hour serve affect assumption pollution');
  274. INSERT INTO Rating_Items VALUES ('14', '2012-07-13', '24', '1', 'yellow ordinary comfortable security');
  275. INSERT INTO Rating_Items VALUES ('2', '2010-08-19', '14', '2', 'damage count cross coat television television rush sale');
  276. INSERT INTO Rating_Items VALUES ('11', '2010-08-14', '27', '2', 'place breakfast comfortable collection front cheek');
  277. INSERT INTO Rating_Items VALUES ('1', '2011-03-19', '10', '1', 'walk');
  278. INSERT INTO Rating_Items VALUES ('10', '2012-03-18', '19', '5', 'mud');
  279. INSERT INTO Rating_Items VALUES ('7', '2013-02-08', '4', '5', 'pride invite meeting promise');
  280. INSERT INTO Rating_Items VALUES ('4', '2018-05-13', '26', '3', 'river significance farm laugh candidate');
  281. INSERT INTO Rating_Items VALUES ('3', '2012-04-04', '27', '3', '');
  282. INSERT INTO Rating_Items VALUES ('8', '2018-04-08', '35', '0', 'angle internet addition save');
  283. INSERT INTO Rating_Items VALUES ('0', '2017-02-02', '8', '0', 'home year routine contact leg task debt hate supermarket');
  284. INSERT INTO Rating_Items VALUES ('4', '2017-04-14', '25', '1', 'thanks money bat anywhere bitter nothing');
  285. INSERT INTO Rating_Items VALUES ('3', '2015-09-03', '4', '1', 'slice basis union accident');
  286. INSERT INTO Rating_Items VALUES ('1', '2013-09-03', '34', '4', 'calendar vacation green');
  287. INSERT INTO Rating_Items VALUES ('11', '2011-05-19', '1', '2', 'bench picture aspect');
  288. INSERT INTO Rating_Items VALUES ('14', '2012-04-16', '26', '2', 'penalty');
  289. INSERT INTO Rating_Items VALUES ('9', '2010-08-02', '37', '4', '');
  290. INSERT INTO Rating_Items VALUES ('13', '2012-08-15', '16', '2', 'following floor tune match');
  291. INSERT INTO Rating_Items VALUES ('12', '2014-05-03', '36', '2', 'army speed emotion act lecture');
  292. INSERT INTO Rating_Items VALUES ('7', '2016-08-03', '24', '0', 'exam other curve profession two rip');
  293. INSERT INTO Rating_Items VALUES ('6', '2017-06-07', '38', '0', '');
  294. INSERT INTO Rating_Items VALUES ('2', '2015-01-06', '9', '1', 'estimate wake joint prize document maximum fear accident belt');
  295. INSERT INTO Rating_Items VALUES ('0', '2013-03-09', '22', '5', 'ease due serve city initiative');
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!