API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 16th, 2017
279
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 27.75 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE Supervisor ( staffNo CHAR(5) NOT NULL,
  2. salary VARCHAR(5) NOT NULL,
  3. firstName VARCHAR(15) NOT NULL,
  4. lastName VARCHAR(15) NOT NULL,
  5. address VARCHAR(70) NOT NULL,
  6. email VARCHAR(30) NOT NULL,
  7. sex CHAR(1),
  8. DOB DATE NOT NULL,
  9. password VARCHAR(15) NOT NULL,
  10. worksAt CHAR(5) NOT NULL,
  11. telNo VARCHAR(14) NOT NULL,
  12. constraint pk1 primary key (staffNo),
  13. constraint fk1 Foreign Key (worksAt) references Club(clubNo) ON UPDATE NO ACTION ON DELETE CASCADE);
  14.  
  15. CREATE TABLE bartender ( staffNo CHAR(5) NOT NULL,
  16. salary VARCHAR(5) NOT NULL,
  17. firstName VARCHAR(15) NOT NULL,
  18. lastName VARCHAR(15) NOT NULL,
  19. address VARCHAR(70) NOT NULL,
  20. email VARCHAR(3) NOT NULL,
  21. sex CHAR(1),
  22. DOB DATE NOT NULL,
  23. password VARCHAR(15) NOT NULL,
  24. worksAt CHAR(5) NOT NULL,
  25. telNo VARCHAR(14) NOT NULL,
  26. supervisedBy CHAR(5) NOT NULL,
  27. constraint pk3 primary key (staffNo),
  28. Foreign Key (worksAt) references club(clubNo),
  29. Foreign Key (supervisedBy) references supervisor(staffNo));
  30.  
  31. CREATE TABLE security ( staffNo CHAR(5) NOT NULL,
  32. salary VARCHAR(5) NOT NULL,
  33. firstName VARCHAR(15) NOT NULL,
  34. lastName VARCHAR(15) NOT NULL,
  35. address VARCHAR(70) NOT NULL,
  36. email VARCHAR(3) NOT NULL,
  37. sex CHAR(1),
  38. DOB DATE NOT NULL,
  39. password VARCHAR(15) NOT NULL,
  40. worksAt CHAR(5) NOT NULL,
  41. telNo VARCHAR(14) NOT NULL,
  42. supervisedBy CHAR(5) NOT NULL,
  43. constraint pk3 primary key (staffNo),
  44. Foreign Key (worksAt) references club(clubNo),
  45. Foreign Key (supervisedBy) references supervisor(staffNo));
  46.  
  47. CREATE TABLE manager ( staffNo CHAR(5) NOT NULL,
  48. salary VARCHAR(5) NOT NULL,
  49. firstName VARCHAR(15) NOT NULL,
  50. lastName VARCHAR(15) NOT NULL,
  51. address VARCHAR(70) NOT NULL,
  52. email VARCHAR(3) NOT NULL,
  53. sex CHAR(1),
  54. DOB DATE NOT NULL,
  55. password VARCHAR(15) NOT NULL,
  56. worksAt CHAR(5) NOT NULL,
  57. telNo VARCHAR(14) NOT NULL,
  58. constraint pk3 primary key (staffNo),
  59. Foreign Key (worksAt) references club(clubNo));
  60.  
  61. CREATE TABLE club ( clubNo CHAR(5) NOT NULL,
  62. street VARCHAR(30) NOT NULL,
  63. city VARCHAR(15) NOT NULL,
  64. county VARCHAR(15) NOT NULL,
  65. postcode VARCHAR(7) NOT NULL,
  66. telNo VARCHAR(14) NOT NULL,
  67. managedBy CHAR(5) NOT NULL,
  68. constraint pk3 primary key (clubNo),
  69. Foreign Key (managedBy) references manager(staffNo));
  70.  
  71. CREATE TABLE members ( memberNo CHAR(5) NOT NULL,
  72. firstName VARCHAR(15) NOT NULL,
  73. lastName VARCHAR(15) NOT NULL,
  74. street VARCHAR(30) NOT NULL,
  75. city VARCHAR(15) NOT NULL,
  76. county VARCHAR(15) NOT NULL,
  77. postcode VARCHAR(7) NOT NULL,
  78. guestSlots CHAR(2) NOT NULL,
  79. lastVisitDate DATE,
  80. email VARCHAR(3) NOT NULL,
  81. sex CHAR(1),
  82. DOB DATE NOT NULL,
  83. registerDate DATE NOT NULL,
  84. renewalDate DATE NOT NULL,
  85. registeredBy CHAR(5) NOT NULL,
  86. constraint pk3 primary key (memberNo),
  87. Foreign Key (registeredBy) references staff(staffNo));
  88.  
  89. CREATE TABLE members_telephone ( telNo VARCHAR(14) NOT NULL,
  90. memberNo CHAR(5) NOT NULL,
  91. constraint pk3 primary key (telNo),
  92. Foreign Key (memberNo) references member(memberNo));
  93.  
  94. CREATE TABLE guest (guestNo CHAR(5) NOT NULL,
  95. name VARCHAR(30) NOT NULL,
  96. email VARCHAR(30),
  97. DOB DATE NOT NULL,
  98. registeredBy CHAR(5) NOT NULL,
  99. constraint pk3 primary key (guestNo),
  100. Foreign Key (registeredBy) references staff(staffNo));
  101.  
  102. CREATE TABLE drinks ( drinkNo CHAR(5) NOT NULL,
  103. brand VARCHAR(20) NOT NULL,
  104. TYPE VARCHAR(20) NOT NULL,
  105. price FLOAT NOT NULL,
  106. constraint pk3 primary key (drinkNo));
  107.  
  108. CREATE TABLE drink_stock ( drinkNo CHAR(5) NOT NULL,
  109. clubNo CHAR(5) NOT NULL,
  110. quantity INTEGER NOT NULL,
  111. constraint pk3 primary key (drinkNo, clubNo),
  112. Foreign Key (clubNo) references club(clubNo));
  113.  
  114. CREATE TABLE distributor ( distributorNo CHAR(5) NOT NULL,
  115. cName VARCHAR(30) NOT NULL,
  116. street VARCHAR(30) NOT NULL,
  117. city VARCHAR(15) NOT NULL,
  118. county VARCHAR(15) NOT NULL,
  119. postcode VARCHAR(7) NOT NULL,
  120. supplies CHAR(5) NOT NULL,
  121. constraint pk3 primary key (distributorNo),
  122. Foreign Key (supplies) references club(clubNo));
  123.  
  124. CREATE TABLE orders ( orderNo CHAR(5) NOT NULL,
  125. orderDate DATE NOT NULL,
  126. totalCost FLOAT NOT NULL,
  127. complete BOOLEAN,
  128. notes VARCHAR(250),
  129. orderedBy CHAR(5) NOT NULL,
  130. fulfilledBy CHAR(5) NOT NULL,
  131. constraint pk3 primary key (orderNo),
  132. Foreign Key (orderedBy) references club(clubNo),
  133. Foreign Key (fulfilledBy) references distributor(distributorNo));
  134.  
  135. CREATE TABLE orders_drinks ( drinkNo CHAR(5) NOT NULL,
  136. quantity int(4) NOT NULL,
  137. orderDate DATE NOT NULL,
  138. orderTime TIME NOT NULL,
  139. orderedBy CHAR(5) NOT NULL,
  140. orderNo CHAR(5) NOT NULL,
  141. constraint pk3 primary key (drinkNo, orderDate, orderTime, orderedBy),
  142. Foreign Key (drinkNo) references drink(drinkNo),
  143. Foreign Key (orderDate) references orders(orderDate),
  144. Foreign Key (orderedBy) references orders(orderedBy),
  145. Foreign Key (orderNo) references orders(orderNo));
  146.  
  147. CREATE TABLE visit ( memberNo CHAR(5) NOT NULL,
  148. clubNo CHAR(5) NOT NULL,
  149. dateOfVisit DATE NOT NULL,
  150. constraint pk3 primary key (memberNo, clubNo, dateOfVisit),
  151. Foreign Key (memberNo) references members(memberNo),
  152. Foreign Key (clubNo) references club(clubNo));
  153.  
  154. CREATE TABLE guest_visit ( guestNo CHAR(5) NOT NULL,
  155. visitDate DATE NOT NULL,
  156. memberNo CHAR(5) NOT NULL,
  157. constraint pk3 primary key (guestNo, visitDate),
  158. Foreign Key (guestNo) references guest(guestNo),
  159. Foreign Key (visitDate) references visit(visitNo),
  160. Foreign Key (memberNo) references members(memberNo));
  161.  
  162. CREATE TABLE sales ( transactionID CHAR(5) NOT NULL,
  163. clubNo CHAR(5) NOT NULL,
  164. dateOfSale DATE NOT NULL,
  165. timeOfSale TIME NOT NULL,
  166. saleMadeBy CHAR(5) NOT NULL,
  167. totalCost FLOAT NOT NULL,
  168. constraint pk3 primary key (transactionID),
  169. Foreign Key (saleMadeBy) references bartender(staffNo));
  170.  
  171. CREATE TABLE sale_drinks ( drinkNo CHAR(5) NOT NULL,
  172. clubNo CHAR(5) NOT NULL,
  173. dateOfSale DATE NOT NULL,
  174. timeOfSale TIME NOT NULL,
  175. transactionID CHAR(5) NOT NULL,
  176. quantity INTEGER NOT NULL,
  177. constraint pk3 primary key (drinkNo, clubNo, dateOfSale, timeOfSale),
  178. Foreign Key (drinkNo) references drink(drinkNo),
  179. Foreign Key (clubNo) references club(clubNo),
  180. Foreign Key (transactionID) references sales(transactionID),
  181. Foreign Key (dateOfSale) references sales(dateOfSale),
  182. Foreign Key (timeOfSale) references sales(timeOfSale));
  183.  
  184. INSERT INTO Supervisor
  185. VALUES ("S0001", 45000, "William", "Gatens", "London", "will-gatens@msn.co.uk", "M", "1988-02-23", "bonfire1", "C0001", "07543761827");
  186.  
  187. INSERT INTO Supervisor
  188. VALUES ("S0002", 45000, "David", "Gray", "Cork", "gray324@msn.co.uk", "M", "1978-02-25", "rotterdut", "C0002", "07574382645");
  189.  
  190. INSERT INTO supervisor VALUES ("S0003", 45000, "Francesca", "May" , "Derby", "frannymay@hotmail.com", "F", "1982-01-13", "pony12", "C0003", "079594234339");
  191.  
  192. INSERT INTO Supervisor
  193. VALUES ("S0004", 45000, "Chuck", "Davidson", "Newcastle", "cdavids-son@msn.co.uk", "M", 1981-03-19, "frepston", "C0004", "01332564735");
  194.  
  195. INSERT INTO Supervisor
  196. VALUES ("S0005", 45000, "Henrietta", "Facesom", "Bury", "hennie23@hotmail.com", "F", "1963-05-18", "fyre13", "C0005", "07978650687");
  197.  
  198. INSERT INTO Bartender
  199. VALUES ("S0006", 38000, "John", "Doe", "Manchester", "bakeacake@hotmail.co.uk", "M", "1988-05-28", "fewu12", "C0002", "07657453263", "S0002");
  200.  
  201.  
  202. INSERT INTO Bartender
  203. VALUES ("S0007", 38000, "Faye", "Gray", "Manchester", "fayebell@hotmail.com", "F", "1987-09-19", "green3", "C0002", "076467356123", "S0002");
  204.  
  205.  
  206. INSERT INTO Bartender
  207. VALUES ("S0008", 38000, "Andrew", "James", "Liverpool", "ajjameson@hotmail.co.uk", "M", "1989-04-14", "disgusse", "C0002", "07946362435", "S0002");
  208.  
  209.  
  210. INSERT INTO Bartender
  211. VALUES ("S0009", 38000, "Nik", "McCarthy", "Nottingham", "nikrok@gmail.com", "M", "1972-03-03", "hgdwre2", "C0001", "07970708756", "S0001");
  212.  
  213.  
  214. INSERT INTO Bartender
  215. VALUES ("S0010", 38000, "Jane", "Thomas", "Crewe", "jane3425@hotmail.co.uk", "F", "1973-03-02", "hedgehog16", "C0001", "07776745321", "S0001");
  216.  
  217. INSERT INTO Bartender
  218. VALUES ("S0011", 38000, "Harriet", "Rimmington", "Cardiff", "harjhat@hotmail.co.uk", "F", "1977-02-18", "bombfire6", "C0001", "07657453213", "S0001");
  219.  
  220.  
  221. INSERT INTO Bartender
  222. VALUES ("S0012", 38000, "Ted" , "Mosby", "Nottingham", "theodore1@gmail.com", "M", "1983-09-13", "himym2", "C0003", "07124657446", "S0003");
  223.  
  224.  
  225. INSERT INTO Bartender
  226. VALUES ("S0013", 38000, "Thomas", "Eyre", "Bradford", "tommyeyre@hotmail.com", "M", "1989-07-07", "haitan1", "C0003", "07936745321", "S0003");
  227.  
  228. INSERT INTO Bartender
  229. VALUES ("S0014", "38000", "Emma", "Beard", "Swansea", "emmet12@hotmail.co.uk", "F", "1977-04-23", "duracell43", "C0003", "07658753213", "S0003");
  230.  
  231. INSERT INTO Bartender
  232. VALUES ("S0015", 38000, "Carla", "Espinosa", "Sheffield", "Carlar2@gmail.com", "F", "1986-04-25", "54rose2", "C0004", "07645362123", "S0004");
  233.  
  234.  
  235. INSERT INTO Bartender
  236. VALUES ("S0016", 38000, "Thomas", "Eyre", "Lancaster", "tomzybear@hotmail.com", "M", "1987-11-10", "rossi42", "C0004", "07975647596", "S0004");
  237.  
  238. INSERT INTO Bartender
  239. VALUES ("S0017", 38000, "Rachel", "Hodgekiss", "Liverpool", "racheyface@hotmail.co.uk", "F", "1977-10-14", "trarp985", "C0004", "07978675645", "S0004");
  240.  
  241. INSERT INTO Bartender
  242. VALUES ("S0018", 38000, "Daniel", "Spencer", "Cambridge", "spanner21@gmail.co.uk", "M", "1982-12-25", "spoonman31", "C0005", "07564536475", "S0005");
  243.  
  244.  
  245. INSERT INTO Bartender
  246. VALUES ("S0019", 38000, "Julie", "Woon", "Oxford", "julesflower@hotmail.com", "F", "1989-02-20", "handyman2", "C0005", "07574746547", "S0005");
  247.  
  248. INSERT INTO Bartender
  249. VALUES ("S0020", 38000, "David", "Parry", "Kent", "davepez@hotmail.co.uk", "M", "1974-03-29", "rockband2", "C0005", "07121321242", "S0005");
  250.  
  251.  
  252. INSERT INTO Security
  253. VALUES ("S0021", 42000, "Dan", "O'Shea", "Stockport", "doshazaenous@hotmail.com", "M", "1976-03-12", "rover32", "C0001", "07654345435", "S0001");
  254.  
  255. INSERT INTO Security
  256. VALUES ("S0022", 42000, "George", "Richardson", "Bedford", "grson@yahoo.com", "M", "1989-11-30", "philli2", "C0001", "07898789673", "S0001");
  257.  
  258. INSERT INTO Security
  259. VALUES ("S0023", 42000, "Lucy", "Dodson", "Derby", "loof21@hotmail.co.uk", "F", "1990-10-22", "freewilly8", "C0002", "07876453215", "S0002");
  260.  
  261. INSERT INTO Security
  262. VALUES ("S0024", 42000, "Rebecca", "Williams", "Derby", "cherrox@yahoo.co.uk", "F", "1982-03-20", "harrypotter1", "C0002", "07876768546", "S0002");
  263.  
  264. INSERT INTO Security
  265. VALUES ("S0025", 42000, "Kate", "Davies", "London", "davydaveson@gmail.co.uk", "F", "1980-03-12", "walesrugby1", "C0003", "07654908789", "S0003");
  266.  
  267. INSERT INTO Security
  268. VALUES ("S0026", 42000, "Rob", "Seeley", "Birmingham", "seelester@hotmail.com", "M", "1976-05-19", "brapbrap2", "C0003", "07876123214", "S0003");
  269.  
  270. INSERT INTO Security
  271. VALUES ("S0027", "42000", "Alfie", "Penfold", "Nottingham", "alfstar@gmail.co.uk", "M", "1972-09-30", "sports3", "C0004", 07687675475, "S0004");
  272.  
  273. INSERT INTO Security
  274. VALUES ("S0028", "42000", "Rob", "Finnamore", "Bristol", "finny@hotmail.com", "M", "1961-03-02", "liv09tor", "C0004", "07989098907", "S0004");
  275.  
  276. INSERT INTO Security
  277. VALUES ("S0029", 42000, "Louis", "Saha", "Liverpool", "kinglouis@yahoo.com", "M", "1971-08-27", "evert1", "C0005", "07867564536", "S0005");
  278.  
  279. INSERT INTO Security
  280. VALUES ("S0030", 42000, "Park", "Ji-Sung", "Manchester", "jisie@yahoo.com", "M", "1978-01-31", "4everred", "C0005", "07564783209", "S0005");
  281.  
  282. INSERT INTO Security
  283. VALUES ("S0036", 42000, "Emily", "Knowles", "Newquay", "emsybabe@yahoo.com", "F", "1960-07-01", "chesefoo5", "C0001", "07987654362", "S0001");
  284.  
  285.  
  286. INSERT INTO Security
  287. VALUES ("S0037", 42000, "Dave", "Pritchard", "Cocoon", "pritchpriest@yahoo.com", "M", "1941-09-29", "plopseven", "C0002", "07898987865", "S0002");
  288.  
  289.  
  290. INSERT INTO Security
  291. VALUES ("S0038", 42000, "Eddie", "Gordo", "Sheffield", "eddddie@msn.co.uk", "M", "1982-05-03", "tekken43", "C0004", "07876765676", "S0004");
  292.  
  293. INSERT INTO Security
  294. VALUES ("S0039", 42000, "Kelly", "Twells", "Liverpool", "kee@yahoo.com", "F", "1987-02-13", "jughead5", "C0003", "08787654732", "S0003");
  295.  
  296. INSERT INTO Security
  297. VALUES ("S0040", 42000, "Jan", "Roguzca", "Kent", "janathanikos@gmail.co.uk", "F", "1989-11-05", "napster43", "C0005", "07898768543", "S0005");
  298.  
  299.  
  300. INSERT INTO Manager
  301. VALUES ("S0031", 75000, "Richard", "Gaunt", "Derby", "gaunty3@hotmail.co.uk", "M", "1989-09-16", "XIIIFF8", "C0001", "07974564509");
  302.  
  303. INSERT INTO Manager
  304. VALUES ("S0032", 75000, "Paul", "Nulty", "Dundee", "naughynulty@yahoo.com", "M", "1972-04-16", "noice23", "C0002", "07986756453");
  305.  
  306. INSERT INTO Manager
  307. VALUES ("S0033", 75000, "Didier", "Darricau", "Carlisle", "dididid@gmail.co.uk", "M", "1976-04-12", "kklolth12", "C0003", "07867564756");
  308.  
  309. INSERT INTO Manager
  310. VALUES ("S0034", 75000, "Kostas", "Lianos", "Liverpool", "kostaslianos@hotmail.com", "M", "1980-07-14", "fetacheze1", "C0004", "07923213451");
  311.  
  312. INSERT INTO Manager
  313. VALUES ("S0035", 75000, "Paul", "Bell", "Liverpool", "pllbe@hotmail.co.uk", "M", "1980-05-03", "comp201", "C0005", "07989075431");
  314.  
  315.  
  316.  
  317. INSERT INTO Club
  318. VALUES ("C0001", "Hardman Street", "Liverpool", "Merseyside", "L7 8TR", "0151776543", "S0031");
  319.  
  320. INSERT INTO Club
  321. VALUES ("C0002", "Matt Busyby Way", "Manchester", "Greater Manchester", "M23 2UD", "07876574629", "S0032");
  322.  
  323. INSERT INTO Club
  324. VALUES ("C0003", "High Street", "London", "Greater London", "L74 2EX", "01325635423", "S0033");
  325.  
  326. INSERT INTO Club
  327. VALUES ("C0004", "Maple Drive", "Scarborough", "Yorkshire", "Y19 3RB", "01513456432", "S0034");
  328.  
  329. INSERT INTO Club
  330. VALUES ("C0005", "Coventry Road", "Belfast", "Antrim", "B21 1RT", "078767656543", "S0035");
  331.  
  332.  
  333. INSERT INTO members
  334. VALUES ("M0001", "David", "Jackson", "Hardman Street", "Liverpool", "Merseyside", "L7 8TR", "7", "2010-03-02", "djackson@liv.ac.uk", "M", "1980-09-12", "2010-05-02", "2011-05-02", "S0006");
  335.  
  336. INSERT INTO members
  337. VALUES ("M0002", "Peter", "Newbold", "Boyd Grove", "Derby", "Derbyshire", "DE74 1XN", "0", NULL, "pnbewbold@yahoo.com", "M", "1976-07-03", "2009-07-09", "2011-07-09", "S0016");
  338.  
  339. INSERT INTO members
  340. VALUES ("M0003", "Meredith", "Grant", "Moyne Garden", "Leicester", "Leicestershire", "LE21 1TN", "18", "2010-03-10", "mgrant@hotmail.co.uk", "F", "1989-02-12", "2010-01-31", "2011-01-31", "S0020");
  341.  
  342. INSERT INTO members
  343. VALUES ("M0004", "Paul", "Caldbeck", "High Street", "London", "Greater London", "L23 4FN", "6", "2010-03-11", "pc5000@yahoo.co.uk", "M", "1960-03-15", "2008-02-28", "2012-02-28", "s0016");
  344.  
  345. INSERT INTO members
  346. VALUES ("M0005", "Mary", "McCrory", "Dave Street", "Liverpool", "Merseyside", "L7 5TN", "8", "2010-02-17", "macattack@hotmail.co.uk", "F", "1979-11-08", "2003-12-28", "2010-12-28", "S0012");
  347.  
  348. INSERT INTO members
  349. VALUES ("M0006", "Daniel", "Jakobbson", "High Street", "Liverpool", "Merseyside", "L8 2NX", "10", NULL, "djace@google.co.uk", "M", "1964-08-21", "2005-12-12", "2010-12-12", "S0019");
  350.  
  351. INSERT INTO members
  352. VALUES ("M0007", "Adam", "Eley", "Nunsfield Avenue", "Derby", "Derbyshire", "DE87 2DS", "20", "2010-01-17", "adamanted@yahoo.co.uk", "M", "1970-03-24", "2008-12-01", "2010-12-01", "S0009");
  353.  
  354. INSERT INTO members
  355. VALUES ("M0008", "Zuoyi", "Zhou", "Charlton Grove", "Manchester", "Greater Manchester", "2M2 1PO", "1", NULL, "zoubag@hotmail.co.uk", "F", "1989-02-02", "2010-03-22", "2011-03-22", "S0013");
  356.  
  357. INSERT INTO members
  358. VALUES ("M0009", "Amanda", "Webb", "MAple Drive", "York", "Yorkshire", "YO2 3RN", "3", "2010-21-03", "amandawebb@hotmail.com", "F", "1989-04-15", "2010-01-01", "2011-01-01", "S0018");
  359.  
  360. INSERT INTO members
  361. VALUES ("M0010", "Alex", "Lomas", "Dave Street", "Liverpool", "Merseyside", "L7 5TN", "14", "2009-03-28", "lomee@hotmail.com", "M", "1988-12-09", "2010-03-07", "2011-03-07", "S0019");
  362.  
  363. INSERT INTO members
  364. VALUES ("M0011", "Jack", "Lawless", "Boyd Grove", "Derby", "Derbyshire", "DE72 3RT", "12", "2009-12-12", "lawlessbyjack@hotmail.co.uk", "M", "1987-03-21", "2009-12-12", "2011-12-12", "S0002");
  365.  
  366. INSERT INTO members
  367. VALUES ("M0012", "Holly", "McDade", "Boyd Grove", "Derby", "Derbyshire", "DE72 3RT", "6", 2010-01-02, "holpol12@hotmail.co.uk", "F", "1987-08-19", "2009-12-12", "2011-12-12", "S0012");
  368.  
  369.  
  370. INSERT INTO members_Telephone
  371. VALUES ("07975647509","M0001");
  372.  
  373. INSERT INTO members_Telephone
  374. VALUES ("01332706846", "M0001");
  375.  
  376. INSERT INTO members_Telephone
  377. VALUES ("07564736548", "M0002");
  378.  
  379. INSERT INTO members_Telephone
  380. VALUES ("01523465746", "M0002");
  381.  
  382. INSERT INTO members_Telephone
  383. VALUES ("01434567867", "M0002");
  384.  
  385. INSERT INTO members_Telephone
  386. VALUES ("07986756475", "M0003");
  387.  
  388. INSERT INTO members_Telephone
  389. VALUES ("07975644657", "M0004");
  390.  
  391. INSERT INTO members_Telephone
  392. VALUES ("01324567465", "M0004");
  393.  
  394. INSERT INTO members_Telephone
  395. VALUES ("07976856746", "M0005");
  396.  
  397. INSERT INTO members_Telephone
  398. VALUES ("07889987651", "M0006");
  399.  
  400. INSERT INTO members_Telephone
  401. VALUES ("07898212231", "M0007");
  402.  
  403. INSERT INTO members_Telephone
  404. VALUES ("07898787654", "M0008");
  405.  
  406. INSERT INTO members_Telephone
  407. VALUES ("07898765219", "M0008");
  408.  
  409. INSERT INTO members_Telephone
  410. VALUES ("01332701231", "M0009");
  411.  
  412. INSERT INTO members_Telephone
  413. VALUES ("01512343763", "M0010");
  414.  
  415. INSERT INTO members_Telephone
  416. VALUES ("07876564320", "M0010");
  417.  
  418. INSERT INTO members_Telephone
  419. VALUES ("07865756621", "M0011");
  420.  
  421. INSERT INTO members_Telephone
  422. VALUES ("07898768710", "M0012");
  423.  
  424. INSERT INTO members_Telephone
  425. VALUES ("01332765239", "M0012");
  426.  
  427.  
  428. INSERT INTO Guest
  429. VALUES ("G0001", "David Kay", NULL, "1980-08-23", "S0011");
  430.  
  431. INSERT INTO Guest
  432. VALUES ("G0002", "Dan Goodman", NULL, "1968-10-04", "S0013");
  433.  
  434. INSERT INTO Guest
  435. VALUES ("G0003", "Faye Goodman", NULL, "1969-02-22", "S0013");
  436.  
  437. INSERT INTO Guest
  438. VALUES ("G0004", "Daniel Craig", "dcraig@yahoo.com", "1990-01-01", "S0012");
  439.  
  440. INSERT INTO Guest
  441. VALUES ("G0005", "Kate Davies", NULL, "1972-08-09", "S0011");
  442.  
  443.  
  444. INSERT INTO drinks
  445. VALUES ("SSmir", "Smirnoff Vodka", "Spirits", 1.50);
  446.  
  447.         INSERT INTO drink_stock
  448.         VALUES ("SSmir", "C0001", 23);
  449.  
  450.         INSERT INTO drink_stock
  451.         VALUES ("SSmir", "C0002", 198);
  452.  
  453.         INSERT INTO drink_stock
  454.         VALUES ("SSmir", "C0003", 18);
  455.  
  456.         INSERT INTO drink_stock
  457.         VALUES ("SSmir", "C0004", 27);
  458.  
  459.         INSERT INTO drink_stock
  460.         VALUES ("SSmir", "C0005", 72);
  461.  
  462. INSERT INTO drinks
  463. VALUES ("BFost", "Fosters", "Beer", 3.00);
  464.  
  465.         INSERT INTO drink_stock
  466.         VALUES ("BFost", "C0001", 259);
  467.  
  468.         INSERT INTO drink_stock
  469.         VALUES ("BFost", "C0002", 38);
  470.  
  471.         INSERT INTO drink_stock
  472.         VALUES ("BFost", "C0003", 78);
  473.  
  474.         INSERT INTO drink_stock
  475.         VALUES ("BFost", "C0004", 69);
  476.  
  477.         INSERT INTO drink_stock
  478.         VALUES ("BFost", "C0005", 20);
  479.  
  480.  
  481. INSERT INTO drinks
  482. VALUES ("BBerg", "Carlsberg", "Beer", 2.80);
  483.  
  484.         INSERT INTO drink_stock
  485.         VALUES ("BBerg", "C0001", 86);
  486.  
  487.  
  488.         INSERT INTO drink_stock
  489.         VALUES ("BBerg", "C0002", 97);
  490.  
  491.  
  492.         INSERT INTO drink_stock
  493.         VALUES ("BBerg", "C0003", 21);
  494.  
  495.  
  496.         INSERT INTO drink_stock
  497.         VALUES ("BBerg", "C0004", 28);
  498.  
  499.  
  500.         INSERT INTO drink_stock
  501.         VALUES ("BBerg", "C0005", 83);
  502.  
  503.  
  504. INSERT INTO drinks
  505. VALUES ("SSail", "Sailor Jerrys Spiced Rum", "Spirits", 1.50);
  506.  
  507.  
  508.         INSERT INTO drink_stock
  509.         VALUES ("SSail", "C0001", 23);
  510.  
  511.         INSERT INTO drink_stock
  512.         VALUES ("SSail", "C0002", 28);
  513.  
  514.         INSERT INTO drink_stock
  515.         VALUES ("SSail", "C0003", 39);
  516.  
  517.         INSERT INTO drink_stock
  518.         VALUES ("SSail", "C0004", 42);
  519.  
  520.         INSERT INTO drink_stock
  521.         VALUES ("SSail", "C0005", 97);
  522.  
  523.  
  524.  
  525. INSERT INTO drinks
  526. VALUES ("BCarl", "Carling", "Beer", 2.80);
  527.  
  528.         INSERT INTO drink_stock
  529.         VALUES ("BCarl", "C0001", 102);
  530.  
  531.         INSERT INTO drink_stock
  532.         VALUES ("BCarl", "C0002", 138);
  533.  
  534.         INSERT INTO drink_stock
  535.         VALUES ("BCarl", "C0003", 23);
  536.  
  537.         INSERT INTO drink_stock
  538.         VALUES ("BCarl", "C0004", 86);
  539.  
  540.         INSERT INTO drink_stock
  541.         VALUES ("BCarl", "C0005", 92);
  542.  
  543.  
  544.  
  545.  
  546. INSERT INTO drinks
  547. VALUES ("CStro", "Strongbow", "Cider", 3.00);
  548.  
  549.         INSERT INTO drink_stock
  550.         VALUES ("CStro", "C0001", 201);
  551.  
  552.  
  553.         INSERT INTO drink_stock
  554.         VALUES ("CStro", "C0002", 98);
  555.  
  556.  
  557.         INSERT INTO drink_stock
  558.         VALUES ("CStro", "C0003", 13);
  559.  
  560.  
  561.         INSERT INTO drink_stock
  562.         VALUES ("CStro", "C0004", 18);
  563.  
  564.  
  565.         INSERT INTO drink_stock
  566.         VALUES ("CStro", "C0005", 29);
  567.  
  568.  
  569.  
  570. INSERT INTO drinks
  571. VALUES ("CFros", "Frosty Jacks", "Cider", 3.50);
  572.  
  573.  
  574.         INSERT INTO drink_stock
  575.         VALUES ("CFros", "C0001", 28);
  576.  
  577.  
  578.         INSERT INTO drink_stock
  579.         VALUES ("CFros", "C0002", 97);
  580.  
  581.  
  582.         INSERT INTO drink_stock
  583.         VALUES ("CFros", "C0003", 86);
  584.  
  585.  
  586.         INSERT INTO drink_stock
  587.         VALUES ("CFros", "C0004", 102);
  588.  
  589.  
  590.         INSERT INTO drink_stock
  591.         VALUES ("CFros", "C0005", 21);
  592.  
  593.  
  594. INSERT INTO drinks
  595. VALUES ("BiGui", "Guinness", "Bitter", 3.50);
  596.  
  597.         INSERT INTO drink_stock
  598.         VALUES ("BiGui", "C0001", 64);
  599.  
  600.          INSERT INTO drink_stock
  601.         VALUES ("BiGui", "C0002", 72);
  602.  
  603.         INSERT INTO drink_stock
  604.         VALUES ("BiGui", "C0003", 128);
  605.  
  606.         INSERT INTO drink_stock
  607.         VALUES ("BiGui", "C0004", 82);
  608.  
  609.         INSERT INTO drink_stock
  610.         VALUES ("BiGui", "C0005", 96);
  611.  
  612. INSERT INTO drinks
  613. VALUES ("BBeck", "Becks Vier", "Beer", "2.00");
  614.  
  615.         INSERT INTO drink_stock
  616.         VALUES ("BBeck", "C0001", 250);
  617.  
  618.         INSERT INTO drink_stock
  619.         VALUES ("BBeck", "C0002", 210);
  620.  
  621.         INSERT INTO drink_stock
  622.         VALUES ("BBeck", "C0003", 79);
  623.  
  624.         INSERT INTO drink_stock
  625.         VALUES ("BBeck", "C0004", 100);
  626.  
  627.         INSERT INTO drink_stock
  628.         VALUES ("BBeck", "C0005", 150);
  629.  
  630.  
  631. INSERT INTO drinks
  632. VALUES ("CBros", "Brothers Strawberry", "Cider", 3.00);
  633.  
  634.         INSERT INTO drink_stock
  635.         VALUES ("CBros", "C0001", 23);
  636.  
  637.         INSERT INTO drink_stock
  638.         VALUES ("CBros", "C0002", 54);
  639.  
  640.         INSERT INTO drink_stock
  641.         VALUES ("CBros", "C0003", 67);
  642.  
  643.         INSERT INTO drink_stock
  644.         VALUES ("CBros", "C0004", 12);
  645.  
  646.         INSERT INTO drink_stock
  647.         VALUES ("CBros", "C0005", 198);
  648.  
  649. INSERT INTO drinks
  650. VALUES ("CBroa", "Brothers Apple", "Cider", 3.00);
  651.  
  652.         INSERT INTO drink_stock
  653.         VALUES ("CBroa", "C0001", 23);
  654.  
  655.         INSERT INTO drink_stock
  656.         VALUES ("CBroa", "C0002", 43);
  657.  
  658.         INSERT INTO drink_stock
  659.         VALUES ("CBroa", "C0003", 8);
  660.  
  661.         INSERT INTO drink_stock
  662.         VALUES ("CBroa", "C0004", 102);
  663.  
  664.         INSERT INTO drink_stock
  665.         VALUES ("CBroa", "C0005", 201);
  666.  
  667. INSERT INTO drinks
  668. VALUES ("PCoke", "Coke", "Pop", 2.00);
  669.  
  670.         INSERT INTO drink_stock
  671.         VALUES ("PCoke", "C0001", 23);
  672.  
  673.         INSERT INTO drink_stock
  674.         VALUES ("PCoke", "C0002", 89);
  675.  
  676.         INSERT INTO drink_stock
  677.         VALUES ("PCoke", "C0003", 12);
  678.  
  679.         INSERT INTO drink_stock
  680.         VALUES ("PCoke", "C0004", 189);
  681.  
  682.         INSERT INTO drink_stock
  683.         VALUES ("PCoke", "C0005", 12);
  684.  
  685. INSERT INTO drinks
  686. VALUES ("PCokD", "Diet Coke", "Pop", 2.00);
  687.  
  688.         INSERT INTO drink_stock
  689.         VALUES ("PCokD", "C0001", 23);
  690.  
  691.         INSERT INTO drink_stock
  692.         VALUES ("PCokD", "C0002", 27);
  693.  
  694.         INSERT INTO drink_stock
  695.         VALUES ("PCokD", "C0003", 78);
  696.  
  697.         INSERT INTO drink_stock
  698.         VALUES ("PCokD", "C0004", 98);
  699.  
  700.         INSERT INTO drink_stock
  701.         VALUES ("PCokD", "C0005", 123);
  702.  
  703. INSERT INTO drinks
  704. VALUES ("PLemo", "Lemonade", "Pop", 1.50);
  705.  
  706.         INSERT INTO drink_stock
  707.         VALUES ("PLemo", "C0001", 30);
  708.  
  709.         INSERT INTO drink_stock
  710.         VALUES ("PLemo", "C0002", 50);
  711.  
  712.         INSERT INTO drink_stock
  713.         VALUES ("PLemo", "C0003", 180);
  714.  
  715.         INSERT INTO drink_stock
  716.         VALUES ("PLemo", "C0004", 8);
  717.  
  718.  
  719.         INSERT INTO drink_stock
  720.         VALUES ("PLemo", "C0005", 200);
  721.  
  722. INSERT INTO drinks
  723. VALUES ("SSoco", "Southern Comfort", "Spirits", 2.00);
  724.  
  725.         INSERT INTO drink_stock
  726.         VALUES ("SSoco", "C0001", 213);
  727.  
  728.         INSERT INTO drink_stock
  729.         VALUES ("SSoco", "C0002", 190);
  730.  
  731.         INSERT INTO drink_stock
  732.         VALUES ("SSoco", "C0003", 31);
  733.  
  734.         INSERT INTO drink_stock
  735.         VALUES ("SSoco", "C0004", 98);
  736.  
  737.         INSERT INTO drink_stock
  738.         VALUES ("SSoco", "C0005", 123);
  739.  
  740.  
  741.  
  742.  
  743. INSERT INTO drinks
  744. VALUES ("MLime", "Lime Cordial", "Mixers", 1.00);
  745.  
  746.         INSERT INTO drink_stock
  747.         VALUES ("MLime", "C0001", 38);
  748.  
  749.         INSERT INTO drink_stock
  750.         VALUES ("MLime", "C0002", 179);
  751.  
  752.         INSERT INTO drink_stock
  753.         VALUES ("MLime", "C0003", 54);
  754.  
  755.         INSERT INTO drink_stock
  756.         VALUES ("MLime", "C0004", 84);
  757.  
  758.         INSERT INTO drink_stock
  759.         VALUES ("MLime", "C0005", 96);
  760.  
  761. INSERT INTO drinks
  762. VALUES ("MBlac", "Blackcurrant", "Mixers", 1.00);
  763.  
  764.         INSERT INTO drink_stock
  765.         VALUES ("MBlac", "C0001", 190);
  766.  
  767.         INSERT INTO drink_stock
  768.         VALUES ("MBlac", "C0002", 200);
  769.  
  770.         INSERT INTO drink_stock
  771.         VALUES ("MBlac", "C0003", 83);
  772.  
  773.         INSERT INTO drink_stock
  774.         VALUES ("MBlac", "C0004", 211);
  775.  
  776.         INSERT INTO drink_stock
  777.         VALUES ("MBlac", "C0005", 201);
  778.  
  779.  
  780. INSERT INTO orders VALUES ("O0001", "2010-01-01", 600, TRUE, "drinks for club one", "C0001", "D0001");
  781. INSERT INTO orders_drinks VALUES ("SSmir", 100, "2010-01-01", "14:00", "C0001", "O0001");
  782. INSERT INTO orders_drinks VALUES ("BFost", 100, "2010-01-01", "14:00", "C0001", "O0001");
  783. INSERT INTO orders_drinks VALUES ("BCarl", 100, "2010-01-01", "14:00", "C0001", "O0001");
  784. INSERT INTO orders_drinks VALUES ("SSail", 100, "2010-01-01", "14:00", "C0001", "O0001");
  785.  
  786. INSERT INTO orders VALUES("O0003", "2010-01-03", 600, TRUE, "drinks for club one", "C0001", "D0001");
  787. INSERT INTO orders_drinks VALUES("SSmir", 100, "2010-01-03", "14:00", "C0001", "O0003");
  788. INSERT INTO orders_drinks VALUES("BFost", 100, "2010-01-03", "14:00", "C0001", "O0003");
  789. INSERT INTO orders_drinks VALUES("SSail", 100, "2010-01-03", "14:00", "C0001", "O0003");
  790. INSERT INTO orders_drinks VALUES("BCarl", 100, "2010-01-03", "14:00", "C0001", "O0003");
  791.  
  792. INSERT INTO orders VALUES("O0002", "2010-01-01", 600, TRUE, "drinks for club one", "C0002", "D0002");
  793. INSERT INTO orders_drinks VALUES("SSmir", 100, "2010-01-01", "14:00", "C0002", "O0002");
  794. INSERT INTO orders_drinks VALUES("BFost", 100, "2010-01-01", "14:00", "C0002", "O0002");
  795. INSERT INTO orders_drinks VALUES("BCarl", 100, "2010-01-01", "14:00", "C0002", "O0002");
  796.  
  797. INSERT INTO orders VALUES("O0004", "2010-01-03", 600, TRUE, "drinks for club one", "C0002", "D0001");
  798. INSERT INTO orders_drinks VALUES("SSmir", 100, "2010-01-03", "14:00", "C0002", "O0004");
  799. INSERT INTO orders_drinks VALUES("SSail", 100, "2010-01-03", "14:00", "C0002", "O0004");
  800. INSERT INTO orders_drinks VALUES("BCarl", 100, "2010-01-03", "14:00", "C0002", "O0004");
  801.  
  802. INSERT INTO orders VALUES("O0005", "2010-01-04", 600, TRUE, "drinks for club one", "C0003", "D0005");
  803. INSERT INTO orders_drinks VALUES ("SSmir", 100, "2010-01-04", "14:00", "C0003", "O0005");
  804. INSERT INTO orders_drinks VALUES ("BCarl", 100, "2010-01-04", "14:00", "C0003", "O0005");
  805. INSERT INTO orders_drinks VALUES ("BFost", 100, "2010-01-04", "14:00", "C0003", "O0005");
  806.  
  807. INSERT INTO orders VALUES("O0006", "2010-01-05", 600, TRUE, "drinks for club one", "C0003", "D0005");
  808. INSERT INTO orders_drinks VALUES ("BFost", 100, "2010-01-05", "14:00", "C0003", "O0006");
  809. INSERT INTO orders_drinks VALUES("SSail", 100, "2010-01-05", "14:00", "C0003", "O0006");
  810. INSERT INTO orders_drinks VALUES("BCarl", 100, "2010-01-05", "14:00", "C0003", "O0006");
  811.  
  812. INSERT INTO orders VALUES("O0007", "2010-01-05", 600, TRUE, "blaablaa", "C0004", "D0004");
  813. INSERT INTO orders_drinks VALUES("BFost", 100, "2010-01-05", "14:00", "C0004", "O0007");
  814. INSERT INTO orders_drinks VALUES("BCarl", 100, "2010-01-05", "14:00", "C0004", "O0007");
  815. INSERT INTO orders_drinks VALUES("SSail", 100, "2010-01-05", "14:00", "C0004", "O0007");
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!