API tools faq
paste
Guest User

sweets.sqlite dump

a guest
Nov 8th, 2016
35
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.29 KB | None | 0 0
raw download clone embed print report
  1. PRAGMA foreign_keys=OFF;
  2. BEGIN TRANSACTION;
  3. CREATE TABLE skittles(DATE DATE, variety VARCHAR(20), colour VARCHAR(10), amount SMALLINT);
  4. INSERT INTO "skittles" VALUES('2016-06-28','crazy sours','purple',14);
  5. INSERT INTO "skittles" VALUES('2016-06-28','crazy sours','green',11);
  6. INSERT INTO "skittles" VALUES('2016-06-28','crazy sours','orange',6);
  7. INSERT INTO "skittles" VALUES('2016-06-28','crazy sours','pink',11);
  8. INSERT INTO "skittles" VALUES('2016-06-28','crazy sours','yellow',10);
  9. INSERT INTO "skittles" VALUES('2016-06-29','crazy sours','orange',17);
  10. INSERT INTO "skittles" VALUES('2016-06-29','crazy sours','purple',9);
  11. INSERT INTO "skittles" VALUES('2016-06-29','crazy sours','pink',7);
  12. INSERT INTO "skittles" VALUES('2016-06-29','crazy sours','green',10);
  13. INSERT INTO "skittles" VALUES('2016-06-29','crazy sours','yellow',8);
  14. INSERT INTO "skittles" VALUES('2016-06-30','crazy sours','purple',11);
  15. INSERT INTO "skittles" VALUES('2016-06-30','crazy sours','pink',12);
  16. INSERT INTO "skittles" VALUES('2016-06-30','crazy sours','yellow',8);
  17. INSERT INTO "skittles" VALUES('2016-06-30','crazy sours','orange',12);
  18. INSERT INTO "skittles" VALUES('2016-06-30','crazy sours','green',9);
  19. INSERT INTO "skittles" VALUES('2016-07-06','crazy sours','purple',3);
  20. INSERT INTO "skittles" VALUES('2016-07-06','crazy sours','green',13);
  21. INSERT INTO "skittles" VALUES('2016-07-06','crazy sours','pink',11);
  22. INSERT INTO "skittles" VALUES('2016-07-06','crazy sours','yellow',10);
  23. INSERT INTO "skittles" VALUES('2016-07-06','crazy sours','orange',14);
  24. INSERT INTO "skittles" VALUES('2016-07-07','crazy sours','purple',6);
  25. INSERT INTO "skittles" VALUES('2016-07-07','crazy sours','yellow',14);
  26. INSERT INTO "skittles" VALUES('2016-07-07','crazy sours','pink',7);
  27. INSERT INTO "skittles" VALUES('2016-07-07','crazy sours','green',10);
  28. INSERT INTO "skittles" VALUES('2016-07-07','crazy sours','orange',15);
  29. INSERT INTO "skittles" VALUES('2016-07-08','crazy sours','pink',10);
  30. INSERT INTO "skittles" VALUES('2016-07-08','crazy sours','green',11);
  31. INSERT INTO "skittles" VALUES('2016-07-08','crazy sours','yellow',14);
  32. INSERT INTO "skittles" VALUES('2016-07-08','crazy sours','purple',8);
  33. INSERT INTO "skittles" VALUES('2016-07-08','crazy sours','orange',8);
  34. INSERT INTO "skittles" VALUES('2016-07-12','crazy sours','purple',5);
  35. INSERT INTO "skittles" VALUES('2016-07-12','crazy sours','orange',16);
  36. INSERT INTO "skittles" VALUES('2016-07-12','crazy sours','yellow',13);
  37. INSERT INTO "skittles" VALUES('2016-07-12','crazy sours','pink',9);
  38. INSERT INTO "skittles" VALUES('2016-07-12','crazy sours','green',6);
  39. INSERT INTO "skittles" VALUES('2016-07-14','crazy sours','orange',14);
  40. INSERT INTO "skittles" VALUES('2016-07-14','crazy sours','green',6);
  41. INSERT INTO "skittles" VALUES('2016-07-14','crazy sours','purple',9);
  42. INSERT INTO "skittles" VALUES('2016-07-14','crazy sours','pink',10);
  43. INSERT INTO "skittles" VALUES('2016-07-14','crazy sours','yellow',12);
  44. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','green',6);
  45. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','pink',8);
  46. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','yellow',15);
  47. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','orange',16);
  48. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','purple',6);
  49. INSERT INTO "skittles" VALUES('2016-07-15','crazy sours','purple',6);
  50. INSERT INTO "skittles" VALUES('2016-07-18','crazy sours','purple',8);
  51. INSERT INTO "skittles" VALUES('2016-07-18','crazy sours','yellow',8);
  52. INSERT INTO "skittles" VALUES('2016-07-18','crazy sours','pink',7);
  53. INSERT INTO "skittles" VALUES('2016-07-18','crazy sours','orange',13);
  54. INSERT INTO "skittles" VALUES('2016-07-18','crazy sours','green',15);
  55. INSERT INTO "skittles" VALUES('2016-07-21','crazy sours','pink',12);
  56. INSERT INTO "skittles" VALUES('2016-07-21','crazy sours','green',11);
  57. INSERT INTO "skittles" VALUES('2016-07-21','crazy sours','orange',11);
  58. INSERT INTO "skittles" VALUES('2016-07-21','crazy sours','purple',8);
  59. INSERT INTO "skittles" VALUES('2016-07-21','crazy sours','yellow',9);
  60. INSERT INTO "skittles" VALUES('2016-07-25','crazy sours','green',12);
  61. INSERT INTO "skittles" VALUES('2016-07-25','crazy sours','yellow',10);
  62. INSERT INTO "skittles" VALUES('2016-07-25','crazy sours','pink',11);
  63. INSERT INTO "skittles" VALUES('2016-07-25','crazy sours','purple',10);
  64. INSERT INTO "skittles" VALUES('2016-07-25','crazy sours','orange',10);
  65. INSERT INTO "skittles" VALUES('2016-07-27','crazy sours','yellow',15);
  66. INSERT INTO "skittles" VALUES('2016-07-27','crazy sours','pink',9);
  67. INSERT INTO "skittles" VALUES('2016-07-27','crazy sours','purple',9);
  68. INSERT INTO "skittles" VALUES('2016-07-27','crazy sours','orange',5);
  69. INSERT INTO "skittles" VALUES('2016-07-27','crazy sours','green',13);
  70. INSERT INTO "skittles" VALUES('2016-07-29','crazy sours','orange',13);
  71. INSERT INTO "skittles" VALUES('2016-07-29','crazy sours','pink',10);
  72. INSERT INTO "skittles" VALUES('2016-07-29','crazy sours','green',8);
  73. INSERT INTO "skittles" VALUES('2016-07-29','crazy sours','purple',9);
  74. INSERT INTO "skittles" VALUES('2016-07-29','crazy sours','yellow',11);
  75. INSERT INTO "skittles" VALUES('2016-08-08','crazy sours','pink',12);
  76. INSERT INTO "skittles" VALUES('2016-08-08','crazy sours','orange',8);
  77. INSERT INTO "skittles" VALUES('2016-08-08','crazy sours','green',8);
  78. INSERT INTO "skittles" VALUES('2016-08-08','crazy sours','purple',7);
  79. INSERT INTO "skittles" VALUES('2016-08-08','crazy sours','yellow',15);
  80. INSERT INTO "skittles" VALUES('2016-08-09','wild berry','blue',9);
  81. INSERT INTO "skittles" VALUES('2016-08-09','wild berry','pink',15);
  82. INSERT INTO "skittles" VALUES('2016-08-09','wild berry','red',11);
  83. INSERT INTO "skittles" VALUES('2016-08-09','wild berry','green',7);
  84. INSERT INTO "skittles" VALUES('2016-08-09','wild berry','purple',9);
  85. INSERT INTO "skittles" VALUES('2016-08-10','crazy sours','yellow',17);
  86. INSERT INTO "skittles" VALUES('2016-08-10','crazy sours','green',11);
  87. INSERT INTO "skittles" VALUES('2016-08-10','crazy sours','orange',12);
  88. INSERT INTO "skittles" VALUES('2016-08-10','crazy sours','pink',8);
  89. INSERT INTO "skittles" VALUES('2016-08-10','crazy sours','purple',3);
  90. INSERT INTO "skittles" VALUES('2016-08-11','fruits','purple',8);
  91. INSERT INTO "skittles" VALUES('2016-08-11','fruits','orange',10);
  92. INSERT INTO "skittles" VALUES('2016-08-11','fruits','green',12);
  93. INSERT INTO "skittles" VALUES('2016-08-11','fruits','red',6);
  94. INSERT INTO "skittles" VALUES('2016-08-11','fruits','yellow',14);
  95. INSERT INTO "skittles" VALUES('2016-09-08','crazy sours','pink',12);
  96. INSERT INTO "skittles" VALUES('2016-09-08','crazy sours','green',11);
  97. INSERT INTO "skittles" VALUES('2016-09-08','crazy sours','yellow',10);
  98. INSERT INTO "skittles" VALUES('2016-09-08','crazy sours','purple',8);
  99. INSERT INTO "skittles" VALUES('2016-09-08','crazy sours','orange',11);
  100. INSERT INTO "skittles" VALUES('2016-09-20','crazy sours','orange',22);
  101. INSERT INTO "skittles" VALUES('2016-09-20','crazy sours','purple',7);
  102. INSERT INTO "skittles" VALUES('2016-09-20','crazy sours','pink',7);
  103. INSERT INTO "skittles" VALUES('2016-09-20','crazy sours','yellow',8);
  104. INSERT INTO "skittles" VALUES('2016-09-20','crazy sours','green',8);
  105. INSERT INTO "skittles" VALUES('2016-09-21','crazy sours','green',5);
  106. INSERT INTO "skittles" VALUES('2016-09-21','crazy sours','pink',6);
  107. INSERT INTO "skittles" VALUES('2016-09-21','crazy sours','yellow',12);
  108. INSERT INTO "skittles" VALUES('2016-09-21','crazy sours','orange',17);
  109. INSERT INTO "skittles" VALUES('2016-09-21','crazy sours','purple',10);
  110. INSERT INTO "skittles" VALUES('2016-09-22','crazy sours','purple',15);
  111. INSERT INTO "skittles" VALUES('2016-09-22','crazy sours','orange',15);
  112. INSERT INTO "skittles" VALUES('2016-09-22','crazy sours','green',4);
  113. INSERT INTO "skittles" VALUES('2016-09-22','crazy sours','yellow',7);
  114. INSERT INTO "skittles" VALUES('2016-09-22','crazy sours','pink',10);
  115. INSERT INTO "skittles" VALUES('2016-10-07','crazy sours','pink',11);
  116. INSERT INTO "skittles" VALUES('2016-10-07','crazy sours','orange',12);
  117. INSERT INTO "skittles" VALUES('2016-10-07','crazy sours','purple',7);
  118. INSERT INTO "skittles" VALUES('2016-10-07','crazy sours','yellow',10);
  119. INSERT INTO "skittles" VALUES('2016-10-07','crazy sours','green',11);
  120. CREATE TABLE smarties(DATE DATE,variety VARCHAR(20),question VARCHAR(100),answer VARCHAR(50),capcolour VARCHAR(20),colour VARCHAR(20),amount SMALLINT);
  121. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','yellow',4);
  122. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','purple',3);
  123. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','pink',2);
  124. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','brown',7);
  125. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','blue',7);
  126. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','red',2);
  127. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','orange',3);
  128. INSERT INTO "smarties" VALUES('2016-08-08','normal','what q is a sentence that needs a answer','question','green','green',5);
  129. COMMIT;
Add Comment
Please, Sign In to add comment
Public Pastes
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!