Advertisement
Guest User

Untitled

a guest
Apr 8th, 2018
959
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.84 KB | None | 0 0
  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.  
  11. CREATE TABLE Restaurants(
  12. RESTAURANTID SERIAL NOT NULL PRIMARY KEY,
  13. RESTAURANT_NAME TEXT NOT NULL,
  14. CUISINE TEXT NOT NULL,
  15. URL TEXT,
  16. HOUR_OPEN INT,
  17. HOUR_CLOSE INT
  18. );
  19.  
  20. CREATE TABLE Locations(
  21. LOCATIONID SERIAL NOT NULL PRIMARY KEY,
  22. FIRST_OPEN_DATE DATE NOT NULL,
  23. MANAGER_NAME TEXT,
  24. PHONE_NUMBER TEXT,
  25. ADDRESS TEXT NOT NULL,
  26. RESTAURANTID SERIAL NOT NULL,
  27. FOREIGN KEY (RESTAURANTID)
  28. REFERENCES Restaurants(RESTAURANTID)
  29. ON DELETE REJECT ON UPDATE CASCADE
  30. );
  31.  
  32.  
  33. CREATE TABLE Menu_Items(
  34. ITEMID SERIAL NOT NULL PRIMARY KEY,
  35. NAME TEXT NOT NULL,
  36. TYPE TEXT NOT NULL,
  37. DESCRIPTION TEXT,
  38. PRICE NUMERIC NOT NULL,
  39. RESTAURANTID SERIAL NOT NULL,
  40. FOREIGN KEY (RESTAURANTID)
  41. REFERENCES Restaurants(RESTAURANTID)
  42. ON DELETE SET NULL ON UPDATE CASCADE
  43. );
  44.  
  45. CREATE TABLE Ratings(
  46. USERID SERIAL NOT NULL,
  47. RATING_DATE DATE NOT NULL DEFAULT CURRENT_DATE,
  48. PRICE INT NOT NULL,
  49. FOOD INT NOT NULL ,
  50. MOOD INT,
  51. STAFF INT,
  52. COMMENTS TEXT ,
  53. RESTAURANTID SERIAL NOT NULL,
  54. PRIMARY KEY (USERID, RATING_DATE),
  55. FOREIGN KEY (USERID)
  56. REFERENCES Raters(USERID)
  57. ON DELETE SET DEFAULT ON UPDATE CASCADE
  58. );
  59.  
  60. CREATE TABLE Rating_Items(
  61. USERID SERIAL NOT NULL,
  62. RATING_DATE DATE NOT NULL DEFAULT CURRENT_DATE,
  63. ITEMID SERIAL NOT NULL,
  64. RATING INT NOT NULL,
  65. COMMENTS TEXT,
  66. CHECK(RATING BETWEEN 1 AND 5),
  67. PRIMARY KEY (USERID, RATING_DATE, ITEMID),
  68. FOREIGN KEY (USERID, RATING_DATE)
  69. REFERENCES Ratings(USERID, RATING_DATE),
  70. ON DELETE SET NULL ON UPDATE CASCADE
  71. FOREIGN KEY (USERID)
  72. REFERENCES Raters(USERID)
  73. ON DELETE SET NULL ON UPDATE CASCADE
  74. );
  75.  
  76. INSERT INTO Raters VALUES ('0', 'routinesafe@gmail.com', 'routinesafe45', '2018-03-03', 'blog', '5');
  77. INSERT INTO Raters VALUES ('1', 'steakcar@gmail.com', 'steakcar43', '2017-01-01', 'food critic', '9');
  78. INSERT INTO Raters VALUES ('2', 'economysavings@gmail.com', 'economysavings83', '2017-02-14', 'food critic', '1');
  79. INSERT INTO Raters VALUES ('3', 'chancecommand@gmail.com', 'chancecommand84', '2017-08-06', 'blog', '3');
  80. INSERT INTO Raters VALUES ('4', 'developmentemphasis@gmail.com', 'developmentemphasis41', '2017-03-14', 'food critic', '4');
  81. INSERT INTO Raters VALUES ('5', 'leaguehospital@gmail.com', 'leaguehospital31', '2018-02-04', 'food critic', '9');
  82. INSERT INTO Raters VALUES ('6', 'poolregion@gmail.com', 'poolregion41', '2018-04-16', 'food critic', '5');
  83. INSERT INTO Raters VALUES ('7', 'worldguess@gmail.com', 'worldguess19', '2018-09-09', 'blog', '4');
  84. INSERT INTO Raters VALUES ('8', 'employeesize@gmail.com', 'employeesize16', '2018-04-11', 'blog', '7');
  85. INSERT INTO Raters VALUES ('9', 'rocktruth@gmail.com', 'rocktruth69', '2017-06-06', 'online', '10');
  86. INSERT INTO Raters VALUES ('10', 'agentburn@gmail.com', 'agentburn7', '2018-03-11', 'food critic', '2');
  87. INSERT INTO Raters VALUES ('11', 'burnhomework@gmail.com', 'burnhomework83', '2017-01-01', 'blog', '8');
  88. INSERT INTO Raters VALUES ('12', 'respectelection@gmail.com', 'respectelection79', '2017-04-05', 'food critic', '2');
  89. INSERT INTO Raters VALUES ('13', 'otherskill@gmail.com', 'otherskill88', '2018-04-02', 'blog', '6');
  90. INSERT INTO Raters VALUES ('14', 'physicswalk@gmail.com', 'physicswalk57', '2018-02-15', 'blog', '4');
  91. INSERT INTO Restaurants VALUES ('0', 'Baby Permission', 'canadian', 'BabyPermission@gmail.com', '11', '21');
  92. INSERT INTO Restaurants VALUES ('1', 'Stomach Classic', 'chinese', 'StomachClassic@gmail.com', '11', '21');
  93. INSERT INTO Restaurants VALUES ('2', 'Organization Struggle', 'french', 'OrganizationStruggle@gmail.com', '11', '22');
  94. INSERT INTO Restaurants VALUES ('3', 'Round Fat', 'middle eastern', 'RoundFat@gmail.com', '11', '19');
  95. INSERT INTO Restaurants VALUES ('4', 'Bunch Skin', 'ethnic', 'BunchSkin@gmail.com', '11', '16');
  96. INSERT INTO Restaurants VALUES ('5', 'Person Anybody', 'japanese', 'PersonAnybody@gmail.com', '11', '19');
  97. INSERT INTO Restaurants VALUES ('6', 'Parent Establishment', 'french', 'ParentEstablishment@gmail.com', '11', '24');
  98. INSERT INTO Restaurants VALUES ('7', 'Meaning Local', 'canadian', 'MeaningLocal@gmail.com', '11', '15');
  99. INSERT INTO Restaurants VALUES ('8', 'Mood Bench', 'italian', 'MoodBench@gmail.com', '11', '24');
  100. INSERT INTO Restaurants VALUES ('9', 'Life Purchase', 'french', 'LifePurchase@gmail.com', '11', '19');
  101. INSERT INTO Restaurants VALUES ('10', 'Original Substance', 'chinese', 'OriginalSubstance@gmail.com', '11', '17');
  102. INSERT INTO Restaurants VALUES ('11', 'Daughter Illegal', 'canadian', 'DaughterIllegal@gmail.com', '11', '17');
  103. INSERT INTO Locations VALUES ('0', '2007-02-14', 'Emily', '422-927-7166', '951 Major Rd', '0');
  104. INSERT INTO Locations VALUES ('1', '2001-09-19', 'Sophia', '940-971-7315', '701 Term Rd', '1');
  105. INSERT INTO Locations VALUES ('2', '2007-09-12', 'Austin', '554-838-5485', '248 Roof Rd', '2');
  106. INSERT INTO Locations VALUES ('3', '2009-01-07', 'Olivia', '584-537-5324', '834 Snow Rd', '3');
  107. INSERT INTO Locations VALUES ('4', '2008-05-16', 'Liam', '129-038-0626', '156 Cover Rd', '4');
  108. INSERT INTO Locations VALUES ('5', '2001-03-19', 'Olivia', '072-930-3462', '753 Chest Rd', '5');
  109. INSERT INTO Locations VALUES ('6', '2001-08-07', 'Jacob', '209-913-9988', '847 Knee Rd', '6');
  110. INSERT INTO Locations VALUES ('7', '2001-01-03', 'Bob', '582-687-8215', '275 Break Rd', '7');
  111. INSERT INTO Locations VALUES ('8', '2007-07-18', 'Charlotte', '611-748-9125', '742 Leader Rd', '8');
  112. INSERT INTO Locations VALUES ('9', '2002-03-04', 'Emma', '322-809-7153', '906 Relation Rd', '9');
  113. INSERT INTO Locations VALUES ('10', '2000-06-16', 'Emily', '027-597-9729', '555 Situation Rd', '10');
  114. INSERT INTO Locations VALUES ('11', '2007-01-12', 'Olivia', '132-100-9688', '407 Slide Rd', '11');
  115. INSERT INTO Ratings VALUES ('12', '2017-06-11', '4', '3', '4', '1', 'make wake view literature', '6');
  116. INSERT INTO Ratings VALUES ('2', '2017-08-05', '2', '3', '4', '0', 'cancel employ upper answer country lay spare', '5');
  117. INSERT INTO Ratings VALUES ('8', '2012-06-02', '4', '4', '1', '3', 'period place sun routine sample tour education feature individual front delay weight', '8');
  118. INSERT INTO Ratings VALUES ('3', '2015-05-15', '0', '0', '4', '5', 'window professional individual title shine bottle permission search fight tone one past invite', '10');
  119. INSERT INTO Ratings VALUES ('1', '2010-03-07', '1', '3', '3', '3', 'country guess sky challenge dimension theory company trick event knife zone employer trouble lead buyer grab', '4');
  120. INSERT INTO Ratings VALUES ('0', '2012-02-17', '4', '3', '5', '3', 'car advantage agreement letter resident bear resort source weekend studio visual shelter following piece formal wind button past cut', '0');
  121. INSERT INTO Ratings VALUES ('14', '2013-03-17', '4', '5', '0', '4', 'address pull debate historian hat notice atmosphere sand communication punch extension', '2');
  122. INSERT INTO Ratings VALUES ('13', '2015-05-14', '1', '1', '3', '2', 'list stupid atmosphere wind designer material hook guarantee check hearing influence mine concern reading hair midnight engineering bid', '6');
  123. INSERT INTO Ratings VALUES ('7', '2014-04-18', '2', '0', '0', '5', 'estate mention beginning mode package negotiation visit blow eye summer string bug request', '9');
  124. INSERT INTO Ratings VALUES ('10', '2018-09-09', '4', '1', '4', '5', 'interview balance hope jury shop trainer practice doubt team bill valuable crack benefit concept kill swim', '2');
  125. INSERT INTO Ratings VALUES ('5', '2013-09-18', '1', '4', '3', '0', 'debt evening formal deal spray peace winner computer health apple comparison refrigerator', '7');
  126. INSERT INTO Ratings VALUES ('9', '2013-08-07', '4', '1', '0', '1', 'resource instruction freedom speed student environment hunt necessary east', '0');
  127. INSERT INTO Ratings VALUES ('4', '2012-01-17', '3', '5', '4', '4', 'independence glass school dealer library town town fact temperature', '6');
  128. INSERT INTO Ratings VALUES ('2', '2015-02-05', '5', '4', '3', '2', 'function', '5');
  129. INSERT INTO Ratings VALUES ('10', '2011-03-07', '0', '3', '2', '3', 'march excuse handle', '7');
  130. INSERT INTO Ratings VALUES ('3', '2011-08-15', '5', '5', '1', '4', 'remote homework oil bar few ad attempt location constant writing shoe office dirt twist life access', '6');
  131. INSERT INTO Ratings VALUES ('5', '2018-04-06', '2', '2', '0', '0', 'apple wife yard push register watch', '10');
  132. INSERT INTO Ratings VALUES ('9', '2013-05-04', '3', '5', '2', '4', 'gear hall', '6');
  133. INSERT INTO Ratings VALUES ('0', '2018-03-15', '1', '0', '1', '5', 'contact rain mixture tour', '10');
  134. INSERT INTO Ratings VALUES ('14', '2016-03-19', '1', '0', '1', '1', 'welcome truck human lesson card card head private cancer mall contribution girlfriend', '11');
  135. INSERT INTO Ratings VALUES ('13', '2014-01-07', '0', '3', '3', '1', 'permit while seat constant let growth investment lawyer sense', '5');
  136. INSERT INTO Ratings VALUES ('8', '2011-01-13', '0', '3', '2', '5', 'path internet test cabinet upper payment drink hall mine dust', '6');
  137. INSERT INTO Ratings VALUES ('1', '2014-09-12', '1', '5', '5', '1', 'buy whole discussion', '1');
  138. INSERT INTO Ratings VALUES ('6', '2017-08-13', '3', '4', '5', '4', 'laugh possibility meet judgment product reply reading repeat attack grade pass tear trip pie upper occasion child', '2');
  139. INSERT INTO Ratings VALUES ('7', '2011-02-18', '2', '2', '2', '3', 'maximum slide middle broad shock standard rub', '11');
  140. INSERT INTO Ratings VALUES ('14', '2012-05-06', '0', '5', '4', '4', 'game', '7');
  141. INSERT INTO Ratings VALUES ('0', '2010-07-19', '5', '4', '4', '4', 'stay people excitement engineering introduction cell challenge good classroom bathroom', '11');
  142. INSERT INTO Ratings VALUES ('8', '2013-09-18', '0', '1', '0', '5', 'independent script page king map temperature low league cell still nothing harm mine weight sick female', '11');
  143. INSERT INTO Ratings VALUES ('6', '2011-07-07', '4', '3', '4', '3', 'document document understanding man description collection ad war desk particular extreme win score', '10');
  144. INSERT INTO Ratings VALUES ('12', '2010-03-05', '4', '3', '5', '1', 'upstairs stable frame baby anybody section mention place train sun blood slide repair lie status stuff cycle dealer substance', '1');
  145. INSERT INTO Ratings VALUES ('9', '2016-09-05', '4', '5', '4', '1', 'doubt affect', '11');
  146. INSERT INTO Ratings VALUES ('13', '2016-04-19', '1', '0', '5', '1', 'boss catch inspector scale degree membership foundation maintenance stress age car heart western matter concern menu tune spare', '10');
  147. INSERT INTO Ratings VALUES ('1', '2016-05-06', '5', '0', '3', '0', 'yard flight total noise mobile season expression account energy', '2');
  148. INSERT INTO Ratings VALUES ('10', '2018-01-11', '4', '2', '4', '5', 'tip fill devil lecture', '10');
  149. INSERT INTO Ratings VALUES ('11', '2016-02-01', '1', '3', '4', '3', 'wake hurry drunk produce design spend tank disk length', '7');
  150. INSERT INTO Ratings VALUES ('4', '2015-02-15', '0', '1', '4', '4', 'total stable', '0');
  151. INSERT INTO Ratings VALUES ('3', '2010-03-05', '2', '2', '1', '1', 'equivalent mouth wait still hide coast god clue weather sink assist theme passion', '3');
  152. INSERT INTO Ratings VALUES ('2', '2016-06-02', '1', '2', '4', '1', 'rope entrance', '3');
  153. INSERT INTO Ratings VALUES ('11', '2018-09-03', '5', '4', '1', '2', 'usual alarm father jacket', '6');
  154. INSERT INTO Ratings VALUES ('4', '2010-05-06', '1', '5', '0', '2', 'national couple employer vegetable eat shift poet pull midnight nerve relationship pair', '9');
  155. INSERT INTO Ratings VALUES ('8', '2010-03-19', '0', '4', '2', '2', 'set screw news idea target back quarter dust clothes service fat pace suggestion affect', '10');
  156. INSERT INTO Ratings VALUES ('12', '2012-05-11', '1', '3', '0', '4', 'boss insurance culture date', '2');
  157. INSERT INTO Ratings VALUES ('10', '2018-03-06', '2', '1', '3', '0', 'job engineer conclusion tea', '1');
  158. INSERT INTO Ratings VALUES ('7', '2012-06-08', '3', '5', '4', '3', 'effective inflation dance pattern clerk guitar stage recognition setting', '6');
  159. INSERT INTO Ratings VALUES ('14', '2011-07-17', '3', '2', '4', '5', 'tower might history member death permit abuse weird counter income wine music spirit interaction driver reply return spell wall', '7');
  160. INSERT INTO Ratings VALUES ('5', '2017-04-17', '3', '3', '4', '2', 'car fear double emergency life ruin conversation pass nurse shoot view back escape', '3');
  161. INSERT INTO Ratings VALUES ('1', '2016-01-12', '3', '3', '4', '1', 'software weird smoke afternoon mind fold setting', '9');
  162. INSERT INTO Ratings VALUES ('13', '2017-05-05', '4', '4', '5', '4', 'professional software energy bother', '0');
  163. INSERT INTO Ratings VALUES ('11', '2017-01-12', '2', '2', '5', '3', 'performance specialist wealth explanation offer presentation save health', '9');
  164. INSERT INTO Ratings VALUES ('3', '2015-08-19', '0', '0', '0', '1', '', '2');
  165. INSERT INTO Ratings VALUES ('13', '2012-02-15', '4', '4', '5', '4', 'reply recording season blank salt grand', '9');
  166. INSERT INTO Ratings VALUES ('7', '2011-03-06', '3', '0', '0', '0', 'peak cry rate', '10');
  167. INSERT INTO Ratings VALUES ('9', '2012-06-01', '2', '4', '2', '1', 'inside simple increase food horse strength mail gate reception second change office basis following situation man honey', '6');
  168. INSERT INTO Ratings VALUES ('0', '2018-09-01', '1', '3', '3', '4', 'tension appointment escape join working tree', '2');
  169. INSERT INTO Ratings VALUES ('5', '2014-09-02', '4', '5', '0', '5', 'door relative jump sock', '5');
  170. INSERT INTO Ratings VALUES ('8', '2011-09-13', '4', '3', '4', '1', 'indication affect minimum debate natural owner resist account home list alcohol', '10');
  171. INSERT INTO Ratings VALUES ('1', '2012-05-19', '2', '1', '1', '3', 'freedom accident friendship bitter year', '7');
  172. INSERT INTO Ratings VALUES ('12', '2013-04-12', '4', '3', '4', '1', 'she height pack west pension gap truth dear contact party pot district case health mud half moment', '3');
  173. INSERT INTO Ratings VALUES ('10', '2014-09-07', '5', '5', '0', '5', 'post welcome coach profile', '0');
  174. INSERT INTO Ratings VALUES ('2', '2015-09-05', '5', '2', '0', '2', '', '0');
  175. INSERT INTO Ratings VALUES ('0', '2018-01-15', '3', '2', '4', '0', 'championship pattern side working thing stretch tongue cabinet cup product swimming memory blow awareness', '4');
  176. INSERT INTO Ratings VALUES ('13', '2018-02-14', '5', '4', '4', '4', 'general big outcome construction front suspect mountain wash dress pool cycle requirement channel closet shock', '5');
  177. INSERT INTO Ratings VALUES ('3', '2011-04-03', '0', '0', '4', '3', 'message population shake satisfaction external staff ice draw reveal pair rule pitch variety stage bottle coat many trouble equipment', '7');
  178. INSERT INTO Ratings VALUES ('11', '2012-09-07', '0', '3', '0', '4', 'dance staff watch carpet pick rice sink sea', '4');
  179. INSERT INTO Ratings VALUES ('9', '2011-06-13', '4', '0', '0', '4', 'camera wealth', '2');
  180. INSERT INTO Ratings VALUES ('5', '2010-01-15', '1', '0', '5', '5', 'hair truth death coat', '0');
  181. INSERT INTO Ratings VALUES ('6', '2018-05-01', '0', '3', '4', '0', 'flight date requirement husband term rule penalty spirit western transportation scheme print', '5');
  182. INSERT INTO Ratings VALUES ('12', '2018-09-18', '2', '4', '4', '4', 'picture history crack pride status championship minor series mark print host homework lunch silly', '11');
  183. INSERT INTO Ratings VALUES ('14', '2010-07-15', '4', '0', '0', '0', 'pride wish quit', '6');
  184. INSERT INTO Ratings VALUES ('4', '2017-01-14', '4', '0', '2', '3', 'position surprise net finish sign tennis map dare view tourist yesterday dish girl ask juice stretch value pause sugar', '0');
  185. INSERT INTO Ratings VALUES ('1', '2011-03-07', '5', '4', '1', '2', 'sport opinion', '3');
  186. INSERT INTO Ratings VALUES ('2', '2012-06-12', '2', '1', '0', '1', 'equivalent confidence brother', '3');
  187. INSERT INTO Ratings VALUES ('0', '2014-03-02', '4', '3', '4', '5', 'progress cloud gas', '3');
  188. INSERT INTO Ratings VALUES ('7', '2014-07-08', '1', '3', '2', '2', 'catch east disease run recover turn', '10');
  189. INSERT INTO Ratings VALUES ('8', '2017-05-02', '5', '3', '3', '3', 'method', '0');
  190. INSERT INTO Ratings VALUES ('3', '2011-05-12', '2', '1', '2', '2', 'east emotion seat soup', '6');
  191. INSERT INTO Ratings VALUES ('1', '2013-06-09', '5', '0', '1', '2', '', '2');
  192. INSERT INTO Ratings VALUES ('12', '2013-08-18', '1', '3', '2', '0', '', '3');
  193. INSERT INTO Ratings VALUES ('6', '2018-01-14', '1', '2', '3', '1', 'star basket potential peace lake end climate status draft lady recipe bet kiss priest tool', '6');
  194. INSERT INTO Ratings VALUES ('4', '2015-05-15', '3', '1', '1', '0', 'internal hit day communication kick season obligation opposite action grab camp star smile swim entrance back rough recover', '10');
  195. INSERT INTO Ratings VALUES ('14', '2014-05-06', '2', '0', '0', '1', 'dare hell clue', '2');
  196. INSERT INTO Ratings VALUES ('2', '2013-08-14', '1', '1', '1', '2', 'cover minute public bit sugar description tongue clerk tongue rub common recording sympathy net', '0');
  197. INSERT INTO Ratings VALUES ('13', '2016-02-15', '1', '2', '4', '0', 'drunk tower classroom possession project', '9');
  198. INSERT INTO Ratings VALUES ('5', '2014-02-09', '3', '4', '2', '2', 'win source cry expression hire jacket bench virus benefit math steak beach temperature person rock departure', '3');
  199. INSERT INTO Ratings VALUES ('5', '2011-01-15', '4', '4', '2', '2', 'concert device abuse patient king slip other medium wheel education pain carpet sample dream woman', '3');
  200. INSERT INTO Ratings VALUES ('7', '2017-02-14', '2', '0', '3', '0', 'judge scratch technology savings degree net description inflation wedding game mirror sail concert love internal special stuff agreement', '0');
  201. INSERT INTO Ratings VALUES ('6', '2018-07-05', '5', '4', '1', '2', 'island scratch show sail requirement education worker fruit cry medicine offer', '6');
  202. INSERT INTO Ratings VALUES ('13', '2016-01-11', '3', '1', '0', '4', 'coffee return pick care nerve bus evening contest employ personality professional brush nothing ship harm relation leather beach mom', '7');
  203. INSERT INTO Ratings VALUES ('11', '2016-05-09', '0', '2', '2', '2', 'blue knife curve tennis distribution construction light obligation fill meet traffic emphasis', '11');
  204. INSERT INTO Ratings VALUES ('0', '2012-04-19', '5', '1', '5', '4', 'many goal recording home formal permission leg long', '5');
  205. INSERT INTO Ratings VALUES ('3', '2018-02-06', '4', '5', '4', '4', 'increase thing vehicle pitch estate freedom', '0');
  206. INSERT INTO Ratings VALUES ('1', '2018-09-11', '4', '4', '3', '5', 'analyst rise purple sir choice finish cash song professional player stick anywhere possession object craft airport worth annual difficulty', '1');
  207. INSERT INTO Ratings VALUES ('12', '2018-07-05', '4', '1', '2', '3', 'harm quote permission tour', '6');
  208. INSERT INTO Ratings VALUES ('14', '2016-07-12', '2', '5', '2', '2', 'failure manufacturer drag cat grass driver worker mention calendar sell garage penalty', '3');
  209. INSERT INTO Menu_Items VALUES ('0', 'Croissant', 'Desert', 'tonight test prize development degree sample personality intention', '23.23', '10');
  210. INSERT INTO Menu_Items VALUES ('1', 'Meatloaf', 'Main', 'gene', '64.96', '9');
  211. INSERT INTO Menu_Items VALUES ('2', 'BeaverTail', 'Main', 'doubt reveal web high egg scale yellow active fly', '55.10', '11');
  212. INSERT INTO Menu_Items VALUES ('3', 'Quiche', 'Starter', 'gift seat mall speaker reference toe feedback passage guess', '10.45', '0');
  213. INSERT INTO Menu_Items VALUES ('4', 'Honey Baked Chicken', 'Desert', 'battle wait road possession hair host train analyst gear', '60.73', '7');
  214. INSERT INTO Menu_Items VALUES ('5', 'BeaverTail', 'Desert', '', '69.33', '1');
  215. INSERT INTO Menu_Items VALUES ('6', 'Croissant', 'Desert', 'fall log impact stick lift coast living remove population', '29.37', '8');
  216. INSERT INTO Menu_Items VALUES ('7', 'Croissant', 'Starter', 'wing percentage chapter', '69.22', '5');
  217. INSERT INTO Menu_Items VALUES ('8', 'Pho', 'Main', 'window housing budget chip tradition pie feeling math', '50.10', '4');
  218. INSERT INTO Menu_Items VALUES ('9', 'Pizza', 'Main', 'cup dirt rain son discount', '83.66', '2');
  219. INSERT INTO Menu_Items VALUES ('10', 'BeaverTail', 'Desert', 'wrap drive ad', '32.97', '3');
  220. INSERT INTO Menu_Items VALUES ('11', 'Honey Baked Chicken', 'Starter', 'land', '68.13', '6');
  221. INSERT INTO Menu_Items VALUES ('12', 'Croissant', 'Starter', 'television associate quality shoot principle election dump truck', '54.43', '1');
  222. INSERT INTO Menu_Items VALUES ('13', 'Pizza', 'Starter', 'garden mother comfort candle promise', '29.30', '7');
  223. INSERT INTO Menu_Items VALUES ('14', 'Curry', 'Desert', 'vegetable assist brick criticism simple lawyer girl', '36.82', '5');
  224. INSERT INTO Menu_Items VALUES ('15', 'Beef Stroganoff', 'Desert', 'beautiful bear speaker age fun gas professional idea', '97.14', '11');
  225. INSERT INTO Menu_Items VALUES ('16', 'Sushi', 'Main', 'nation shoulder', '44.97', '2');
  226. INSERT INTO Menu_Items VALUES ('17', 'Sushi', 'Main', 'importance mobile dead note beach shape', '15.73', '4');
  227. INSERT INTO Menu_Items VALUES ('18', 'Taco', 'Starter', 'library', '95.27', '3');
  228. INSERT INTO Menu_Items VALUES ('19', 'Meatloaf', 'Desert', '', '46.08', '9');
  229. INSERT INTO Menu_Items VALUES ('20', 'Quiche', 'Desert', 'sex resolution extreme reaction', '83.77', '10');
  230. INSERT INTO Menu_Items VALUES ('21', 'Donair', 'Starter', 'initiative demand a hat exam share example call page', '77.91', '0');
  231. INSERT INTO Menu_Items VALUES ('22', 'Salisbury Steak', 'Starter', '', '97.29', '6');
  232. INSERT INTO Menu_Items VALUES ('23', 'Meatloaf', 'Starter', 'a dirt apple area style corner', '0.79', '8');
  233. INSERT INTO Menu_Items VALUES ('24', 'Quiche', 'Starter', 'baby', '1.46', '9');
  234. INSERT INTO Menu_Items VALUES ('25', 'Shawarma', 'Desert', 'assignment give abuse bear basis technology let power', '15.36', '11');
  235. INSERT INTO Menu_Items VALUES ('26', 'Taco', 'Main', '', '89.82', '4');
  236. INSERT INTO Menu_Items VALUES ('27', 'Salisbury Steak', 'Starter', 'king possible peace national lay', '2.15', '5');
  237. INSERT INTO Menu_Items VALUES ('28', 'Beef Stroganoff', 'Main', 'speaker mission load upper tax gold if somewhere skill', '61.95', '1');
  238. INSERT INTO Menu_Items VALUES ('29', 'Croissant', 'Main', 'ladder box special', '27.29', '0');
  239. INSERT INTO Menu_Items VALUES ('30', 'Taco', 'Main', '', '56.05', '8');
  240. INSERT INTO Menu_Items VALUES ('31', 'BeaverTail', 'Main', 'shift tale concern guess training hotel coast chocolate', '7.42', '7');
  241. INSERT INTO Menu_Items VALUES ('32', 'Curry', 'Desert', 'sky background struggle major god produce emotion', '14.87', '10');
  242. INSERT INTO Menu_Items VALUES ('33', 'Pho', 'Desert', 'kill', '62.46', '2');
  243. INSERT INTO Menu_Items VALUES ('34', 'BeaverTail', 'Starter', 'day party', '41.84', '3');
  244. INSERT INTO Menu_Items VALUES ('35', 'Pho', 'Main', 'sort pleasure', '96.84', '6');
  245. INSERT INTO Menu_Items VALUES ('36', 'Quiche', 'Desert', 'extent upstairs it scratch pause race scale description', '41.31', '11');
  246. INSERT INTO Menu_Items VALUES ('37', 'BeaverTail', 'Desert', 'other grand role objective', '30.35', '8');
  247. INSERT INTO Menu_Items VALUES ('38', 'Taco', 'Desert', '', '13.21', '6');
  248. INSERT INTO Menu_Items VALUES ('39', 'Pho', 'Desert', '', '56.61', '10');
  249. INSERT INTO Rating_Items VALUES ('13', '2014-01-07', '23', '3', 'initiative appointment instruction test');
  250. INSERT INTO Rating_Items VALUES ('8', '2011-01-13', '30', '5', 'bike officer session original');
  251. INSERT INTO Rating_Items VALUES ('1', '2014-09-12', '20', '4', 'product direction surprise');
  252. INSERT INTO Rating_Items VALUES ('6', '2017-08-13', '25', '4', 'bend police step');
  253. INSERT INTO Rating_Items VALUES ('7', '2011-02-18', '31', '2', 'ideal bedroom habit');
  254. INSERT INTO Rating_Items VALUES ('14', '2012-05-06', '33', '3', 'comfortable');
  255. INSERT INTO Rating_Items VALUES ('0', '2010-07-19', '12', '5', 'stay read hell rest juice hospital mother improvement board');
  256. INSERT INTO Rating_Items VALUES ('8', '2013-09-18', '25', '1', '');
  257. INSERT INTO Rating_Items VALUES ('6', '2011-07-07', '9', '5', 'association interest option witness hand nail spring');
  258. INSERT INTO Rating_Items VALUES ('12', '2010-03-05', '38', '4', 'active bid road invite collection fruit teacher');
  259. INSERT INTO Rating_Items VALUES ('9', '2016-09-05', '14', '3', 'key whole editor tell adult ratio');
  260. INSERT INTO Rating_Items VALUES ('13', '2016-04-19', '27', '3', 'rough report independence people article');
  261. INSERT INTO Rating_Items VALUES ('1', '2016-05-06', '33', '1', '');
  262. INSERT INTO Rating_Items VALUES ('10', '2018-01-11', '1', '5', 'touch advantage home');
  263. INSERT INTO Rating_Items VALUES ('11', '2016-02-01', '9', '3', 'primary understanding trade broad trainer pleasure time');
  264. INSERT INTO Rating_Items VALUES ('4', '2015-02-15', '28', '4', '');
  265. INSERT INTO Rating_Items VALUES ('3', '2010-03-05', '4', '2', 'comment concept pleasure father deposit eye great potential');
  266. INSERT INTO Rating_Items VALUES ('2', '2016-06-02', '35', '4', 'abroad major mission');
  267. INSERT INTO Rating_Items VALUES ('11', '2018-09-03', '10', '1', 'pride quality swim mouth temperature husband drama');
  268. INSERT INTO Rating_Items VALUES ('4', '2010-05-06', '6', '3', 'damage disk agreement');
  269. INSERT INTO Rating_Items VALUES ('8', '2010-03-19', '10', '4', 'sugar daughter');
  270. INSERT INTO Rating_Items VALUES ('12', '2012-05-11', '32', '3', 'flow command dish variation regret performance dinner');
  271. INSERT INTO Rating_Items VALUES ('10', '2018-03-06', '36', '4', 'decision');
  272. INSERT INTO Rating_Items VALUES ('7', '2012-06-08', '30', '3', '');
  273. INSERT INTO Rating_Items VALUES ('14', '2011-07-17', '36', '2', 'population reveal juice driver');
  274. INSERT INTO Rating_Items VALUES ('5', '2017-04-17', '28', '3', 'sink slice');
  275. INSERT INTO Rating_Items VALUES ('1', '2016-01-12', '16', '3', 'conversation');
  276. INSERT INTO Rating_Items VALUES ('13', '2017-05-05', '31', '5', 'mud resist');
  277. INSERT INTO Rating_Items VALUES ('11', '2017-01-12', '17', '4', 'storm associate fee race figure hurry cake');
  278. INSERT INTO Rating_Items VALUES ('3', '2015-08-19', '39', '2', 'impact matter dump address chart birth gate condition');
  279. INSERT INTO Rating_Items VALUES ('13', '2012-02-15', '35', '2', 'selection script president list');
  280. INSERT INTO Rating_Items VALUES ('7', '2011-03-06', '35', '4', 'pollution instance');
  281. INSERT INTO Rating_Items VALUES ('9', '2012-06-01', '1', '1', 'situation literature worth tourist client sea sentence refrigerator editor');
  282. INSERT INTO Rating_Items VALUES ('0', '2018-09-01', '29', '3', 'obligation talk turn significance gene customer career historian');
  283. INSERT INTO Rating_Items VALUES ('5', '2014-09-02', '25', '4', 'grocery cause conflict dish');
  284. INSERT INTO Rating_Items VALUES ('8', '2011-09-13', '17', '5', '');
  285. INSERT INTO Rating_Items VALUES ('1', '2012-05-19', '25', '2', 'sweet step milk garbage freedom path');
  286. INSERT INTO Rating_Items VALUES ('12', '2013-04-12', '37', '2', 'long');
  287. INSERT INTO Rating_Items VALUES ('10', '2014-09-07', '16', '1', 'leader owner alternative few bottom lack invite safe');
  288. INSERT INTO Rating_Items VALUES ('2', '2015-09-05', '25', '2', 'noise impression');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement