data.sql

/* pre-populated data */

INSERT INTO "buyer" VALUES (DEFAULT, 'hoanh', 'hoanhan@bennington.edu', 7114);
INSERT INTO "buyer" VALUES (DEFAULT, 'five', 'fivegrant@bennington.edu', 10951);
INSERT INTO "buyer" VALUES (DEFAULT, 'matt', 'mattcollyer@bennington.edu', 9005);
INSERT INTO "buyer" VALUES (DEFAULT, 'juul', 'julianlambert@bennington.edu', 6446);
INSERT INTO "buyer" VALUES (DEFAULT, 'zak', 'zalkar@bennington.edu', 9603);

INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,12,218,106,101,96}', 'Sharpie', 'black',  7.11, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,29,208,106,101,96}', 'Drone', 'it a drone',  9.22, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,53,205,106,101,96}', 'Sage City Symphony', 'hello',  4.44, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,137,16,98,101,96}', 'Skittles', 'the perfect amount',  300.33, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,3,5,106,101,96}', 'Expo Marker', 'hot take: chalk iz better',  5.55, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,187,16,122,101,96}', 'Wire Strippers', 'hot take: use your bare hands',  9.755, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,40,220,106,101,96}', 'iPhone 6', 'hot take: antoines car is stupid',  0.5, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,68,0,7,4,161,16,122,101,96}', 'Water Bottle', 'hot take: hydration is 4 the weak',  50.55, DEFAULT, NULL);
INSERT INTO "item" VALUES (DEFAULT, '{1,0,4,8,4,203,223,234,10,48,0}', 'Card', 'hot take: skittles are shitty m&ms',  3.22, DEFAULT, NULL);

INSERT INTO "stock" VALUES (DEFAULT, 1);
INSERT INTO "stock" VALUES (DEFAULT, 2);
INSERT INTO "stock" VALUES (DEFAULT, 3);
INSERT INTO "stock" VALUES (DEFAULT, 4);
INSERT INTO "stock" VALUES (DEFAULT, 5);
INSERT INTO "stock" VALUES (DEFAULT, 6);
INSERT INTO "stock" VALUES (DEFAULT, 7);
INSERT INTO "stock" VALUES (DEFAULT, 8);
INSERT INTO "stock" VALUES (DEFAULT, 9);