API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.80 KB | None | 0 0
raw download clone embed print report
  1. --customer table
  2. INSERT INTO customer_table VALUES ('1','Max','Anderson','Maxanderson123@gmail.com','07475560321','82','CM2 8QZ');
  3. INSERT INTO customer_table VALUES ('2','Chaz','Singh','chazsingh123@gmail.com','07594430222','12','SO18 1GK');
  4. INSERT INTO customer_table VALUES ('3','Martin','Smith','Martinsmith120@gmail.com','07475600931','10','GK30 1PK');
  5. INSERT INTO customer_table VALUES ('4','Sean','Applebottom','Seanapple340@gmail.com','07732019231','12','CM2 9PK');
  6. INSERT INTO customer_table VALUES ('5','Steve','Smith','steveyboy250@gmail.com','07475543103','105','FK1 0PK');
  7. INSERT INTO customer_table VALUES ('6','Laura','Wood','lauraloving333@gmail.com','07352139045','100','WS2 9AJ');
  8. INSERT INTO customer_table VALUES ('7','James','Jones','Jamesjones@buildersrus.com','07364039231','1','GJ2 8QZ');
  9. INSERT INTO customer_table VALUES ('8','Hassan','Bukhari','hass@bukharibuilders.com','07177769321','82','BH9 1LJ');
  10. INSERT INTO customer_table VALUES ('9','Ryan','Anderson','ryan@buildersbournemouth.com','07475560321','3','BH1 5PJ');
  11. INSERT INTO customer_table VALUES ('10','George','Banfield','banfield@webuild4you.com','01245348863','5','JK0 4FJ');
  12.  
  13. --commercial table
  14. INSERT INTO commercial_table VALUES('7','Builders R Us','AB2103','CB912762');
  15. INSERT INTO commercial_table VALUES('8','Bukhari Builders','CB2340','LB320459');
  16. INSERT INTO commercial_table VALUES('9','Builders Bournemouth','JK2490','HG329150');
  17. INSERT INTO commercial_table VALUES('10','We Build 4 you','FH2590','SK320590');
  18.  
  19. --payment table
  20. INSERT INTO payment_table VALUES('1','PayPal',TO_DATE('1-JUN-2016','dd-MON-yyyy'));
  21. INSERT INTO payment_table VALUES('2','Card',TO_DATE('13-MAY-2016','dd-MON-yyyy'));
  22. INSERT INTO payment_table VALUES('3','Payment on collection',TO_DATE('19-JAN-2016','dd-MON-yyyy'));
  23. INSERT INTO payment_table VALUES('4','Card',TO_DATE('19-JAN-2016','dd-MON-yyyy'));
  24. INSERT INTO payment_table VALUES('5','PayPal',TO_DATE('10-JUL-2016','dd-MON-yyyy'));
  25. INSERT INTO payment_table VALUES('6','Card',TO_DATE('30-JAN-2016','dd-MON-yyyy'));
  26. INSERT INTO payment_table VALUES('7','Payment on collection',TO_DATE('1-DEC-2016','dd-MON-yyyy'));
  27. INSERT INTO payment_table VALUES('8','Payment on collection',TO_DATE('5-SEP-2016','dd-MON-yyyy'));
  28. INSERT INTO payment_table VALUES('9','Card',TO_DATE('23-FEB-2016','dd-MON-yyyy'));
  29. INSERT INTO payment_table VALUES('10','PayPal',TO_DATE('3-AUG-2016','dd-MON-yyyy'));
  30. INSERT INTO payment_table VALUES('11','Payment on collection',TO_DATE('5-OCT-2016','dd-MON-yyyy'));
  31. INSERT INTO payment_table VALUES('12','Payment on collection',TO_DATE('5-NOV-2016','dd-MON-yyyy'));
  32.  
  33. --order table
  34. INSERT INTO order_table VALUES('1','7');
  35. INSERT INTO order_table VALUES('2','7');
  36. INSERT INTO order_table VALUES('3','8');
  37. INSERT INTO order_table VALUES('4','9');
  38. INSERT INTO order_table VALUES('5','10');
  39. INSERT INTO order_table VALUES('6','2');
  40. INSERT INTO order_table VALUES('7','1');
  41. INSERT INTO order_table VALUES('8','3');
  42. INSERT INTO order_table VALUES('9','4');
  43. INSERT INTO order_table VALUES('10','5');
  44. INSERT INTO order_table VALUES('11','6');
  45. INSERT INTO order_table VALUES('12','1');
  46.  
  47. -- payment linktable
  48. INSERT INTO payment_linktable VALUES('3','3','10');
  49. INSERT INTO payment_linktable VALUES('2','3','7.99');
  50. INSERT INTO payment_linktable VALUES('1','2','5.99');
  51. INSERT INTO payment_linktable VALUES('1','4','2');
  52. INSERT INTO payment_linktable VALUES('5','10','3.99');
  53. INSERT INTO payment_linktable VALUES('6','9','2.50');
  54. INSERT INTO payment_linktable VALUES('7','8','8.99');
  55. INSERT INTO payment_linktable VALUES('8','6','14999.99');
  56. INSERT INTO payment_linktable VALUES('9','7','35');
  57. INSERT INTO payment_linktable VALUES('10','5','3000');
  58. INSERT INTO payment_linktable VALUES('4','1','13200');
  59. INSERT INTO payment_linktable VALUES('11','11','11.99');
  60. INSERT INTO payment_linktable VALUES('12','12','3.99');
  61.  
  62. -- delivery table
  63. INSERT INTO delivery_table VALUES('1','82','BH9 1LJ','Y',TO_DATE('19-JAN-2016 07:07', 'dd-MON-yyyy hh24:mi'));
  64. INSERT INTO delivery_table VALUES('2','10','WS2 2KJ','N',NULL);
  65. INSERT INTO delivery_table VALUES('3','1','PK1 1JF', 'N', NULL);
  66. INSERT INTO delivery_table VALUES('4','20','I34 4HJ','Y',TO_DATE('10-FEB-2016 12:20', 'dd-MON-yyyy hh24:mi'));
  67. INSERT INTO delivery_table VALUES('5','34', 'HJ9 2JH','Y',TO_DATE('15-MAR-2016 15:30','dd-MON-yyyy hh24:mi'));
  68. INSERT INTO delivery_table VALUES('6','88', 'BH8 8JU','N', NULL);
  69. INSERT INTO delivery_table VALUES('7','77', 'KL8 6FP','Y',TO_DATE('15-JUN-2016 11:20', 'dd-MON-yyyy hh24:mi'));
  70. INSERT INTO delivery_table VALUES('8','39', 'CM9 7QZ','Y',TO_DATE('15-JUL-2016 17:31', 'dd-MON-yyyy hh24:mi'));
  71. INSERT INTO delivery_table VALUES('9','13', 'PD2 8QZ','N', NULL);
  72. INSERT INTO delivery_table VALUES('10','48', 'CO2 8PK','N', NULL);
  73. INSERT INTO delivery_table VALUES('11','50', 'CM2 9DJ','N', TO_DATE('16-AUG-2016 15:20', 'dd-MON-yyyy hh24:mi'));
  74. INSERT INTO delivery_table VALUES('12','32', 'MC1 9BH','N', NULL);
  75.  
  76. -- product category table
  77. INSERT INTO product_category_table VALUES('1','Hand Tools');
  78. INSERT INTO product_category_table VALUES('2','Vehicles');
  79. INSERT INTO product_category_table VALUES('3','Safety equipment');
  80. INSERT INTO product_category_table VALUES('4','Building Materials');
  81.  
  82. -- product table
  83. INSERT INTO product_table VALUES('1','Stanley 17" saw','This 17" handsaw is great for wood cutting.','10');
  84. INSERT INTO product_table VALUES('2','Yellow high visability jacket','Durable jacket, perfect for everyday wear.','5.99');
  85. INSERT INTO product_table VALUES('3','Estwing 16oz hammer','This hammer is perfect for carpenters','7.99');
  86. INSERT INTO product_table VALUES('4','Hard hat','Best protection on a construction site.','3.99');
  87. INSERT INTO product_table VALUES('5','Building sand 10kg','Perfect for general building use.','2');
  88. INSERT INTO product_table VALUES('6','20mm gravel','20mm gravel is suitable for driveways and paths.','2.50');
  89. INSERT INTO product_table VALUES('7','Block paving sand 10kg','This paving sand prevents weeds.','8.99');
  90. INSERT INTO product_table VALUES('8','JCB excavator','This JCB digger is perfect for big jobs.','14999.99');
  91. INSERT INTO product_table VALUES('9','JCB bulldozer','This bulldozer is perfect for destroying structures.','3000');
  92. INSERT INTO product_table VALUES('10','Scruffs safety boots','Fitted with steel toe caps for protection.','35');
  93. INSERT INTO product_table VALUES('11','Estwing wood axe','Durable and lightweight axe.','11.99');
  94. INSERT INTO product_table VALUES('12','JCB loader','This loader can carry 1 ton of building supplies.','13200');
  95.  
  96. -- product category linktable
  97. INSERT INTO product_category_linktable('1','1');
  98. INSERT INTO product_category_linktable('2','3');
  99. INSERT INTO product_category_linktable('3','1');
  100. INSERT INTO product_category_linktable('3','3');
  101. INSERT INTO product_category_linktable('4','3');
  102. INSERT INTO product_category_linktable('5','4');
  103. INSERT INTO product_category_linktable('6','4');
  104. INSERT INTO product_category_linktable('7','4');
  105. INSERT INTO product_category_linktable('8','2');
  106. INSERT INTO product_category_linktable('9','2');
  107. INSERT INTO product_category_linktable('10','3');
  108. INSERT INTO product_category_linktable('11','1');
  109. INSERT INTO product_category_linktable('12','2');
  110. -- order item linktable
  111.  
  112. INSERT INTO order_item_table('1','1','2','3');
  113. INSERT INTO order_item_table('2','3','2','3');
  114. INSERT INTO order_item_table('3','2','1','2');
  115. INSERT INTO order_item_table('4','5','3','4');
  116. INSERT INTO order_item_table('5','4','4','10');
  117. INSERT INTO order_item_table('6','6','5','9');
  118. INSERT INTO order_item_table('7','7','7','8');
  119. INSERT INTO order_item_table('8','8','6','6');
  120. INSERT INTO order_item_table('9','10','9','7');
  121. INSERT INTO order_item_table('10','9','8','5');
  122. INSERT INTO order_item_table('11','12','12','1');
  123. INSERT INTO order_item_table('12','11','11','11');
  124. INSERT INTO order_item_table('13','4','10','12');
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!