FillDB.sql

INSERT INTO account VALUES ('derp12@gmail.com', 'Johanna Wall', 'Never Street 52', 'zxc'); 
INSERT INTO account VALUES ('erik@gmail.com', 'Erik Smith', 'Nonexisting Street 3', 'asdf'); 
INSERT INTO account VALUES ('ilikeme@gmail.com', 'Indy Anna Jones', 'Computer Street 42', 'qwert'); 
INSERT INTO account VALUES ('alfredo@gmail.com', 'Christine Steinberger', 'King Avenue 6', 'abc'); 
INSERT INTO account VALUES ('weirdo@gmail.com', 'John Anderson', 'Curry Puff Boulevard 100', 'weirdo');
INSERT INTO account VALUES ('dish@hotmail.com', 'Brandybuck Cheese', 'Happy Road 1', 'zxcv');
INSERT INTO account VALUES ('vegemite@gmail.com', 'Rinkydink Vegemite', 'Sandwich Road 15', 'veggie');
INSERT INTO account VALUES ('barn@gmail.com', 'Barnoldswick Crumplehorn', 'Tuple Avenue 5', 'barn');
INSERT INTO account VALUES ('bomb@gmail.com', 'Bombadil Cottagecheese', 'SQL Road 7', 'bomb');
INSERT INTO account VALUES ('blender@yahoo.com', 'Blenderstitch Crackersprout', 'Seaside Boulevard 164', 'blend');
INSERT INTO account VALUES ('englishclass@yahoo.com', 'Language Master', 'Entity Road 9', '111', 'TRUE');

INSERT INTO item(name, location, condition, description, owner) VALUES ('Water Bottle', 'Choa Chu Kang', 'Good', '150ml water bottle', 'derp12@gmail.com');
INSERT INTO item(name, location, condition, description, owner) VALUES ('Table', 'Bedok', 'Good', 'wooden table with 4 legs', 'derp12@gmail.com');
INSERT INTO item(name, location, condition, description, owner) VALUES ('Cellphone 1', 'Woodlands', 'Excellent', 'Apple Iphone 8 128GB', 'derp12@gmail.com');
INSERT INTO item(name, location, condition, description, owner) VALUES ('Donkey', 'Jurong West', 'Excellent', '200kg donkey that can ride dragons', 'erik@gmail.com');
INSERT INTO item(name, location, condition, description, owner) VALUES ('Mug', 'Bukit Batok', 'Excellent', 'Self-stirring mug', 'erik@gmail.com');
INSERT INTO item(name, location, description, owner) VALUES ('Water Bottle', 'Ang Mo Kio', '1.5L water bottle', 'dish@hotmail.com'); /*Example of excluding cols with default values */ 
INSERT INTO item(name, location, description, owner) VALUES ('Soap', 'Queenstown', 'Soap from Israel', 'vegemite@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Moose', 'Punggol', 'vegemite@gmail.com');
INSERT INTO item(name, location, description, owner) VALUES ('HP Envy Laptop', 'Hougang', '2.5kg running Windows 11', 'vegemite@gmail.com');
INSERT INTO item(name, location, description, owner) VALUES ('Lawnmower', 'Bukit Panjang', 'grass-cutting machine', 'derp12@gmail.com');
INSERT INTO item(name, location, condition, description, owner) VALUES ('Cellphone 2', 'Sengkang', 'Poor', 'Samsung Note 7 with cracked screen', 'derp12@gmail.com');
INSERT INTO item(name, location, condition, owner) VALUES ('Lawnmower', 'Bukit Merah', 'Excellent','ilikeme@gmail.com');
INSERT INTO item(name, location, description, owner) VALUES ('Table', 'Clementi', 'Oak wood table', 'ilikeme@gmail.com');
INSERT INTO item(name, location, description, condition, owner) VALUES ('Portable charger', 'Toa Payoh', 'Xiaomi', 'Excellent', 'alfredo@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Avocado', 'Kallang', 'weirdo@gmail.com');
INSERT INTO item(name, location, condition, owner) VALUES ('Cat', 'Yishun', 'Poor', 'dish@hotmail.com');
INSERT INTO item(name, location, condition, owner) VALUES ('Society', 'Yishun', 'Poor', 'vegemite@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Basketball', 'Tampines', 'vegemite@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Cellphone', 'Tampines', 'vegemite@gmail.com');
INSERT INTO item(name, location,condition, owner) VALUES ('Bukit Batok', '', 'Excellent','barn@gmail.com');
INSERT INTO item(name, location,condition, owner) VALUES ('Soccer ball', 'Sengkang', 'Poor', 'barn@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Cellphone', 'Serangoon', 'bomb@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Ladder', 'Ang Mo Kio', 'bomb@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Hammer', 'Hougang', 'bomb@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Football', 'Bedok', 'bomb@gmail.com');
INSERT INTO item(name, location, owner) VALUES ('Cellphone', 'Geylang', 'blender@yahoo.com');
INSERT INTO item(name, location, owner) VALUES ('Pizza', 'Pasir Ris', 'blender@yahoo.com');
INSERT INTO item(name, location, owner) VALUES ('Table', 'Pasir Ris', 'blender@yahoo.com');
INSERT INTO item(name, location, description, condition, owner) VALUES ('Turtle', 'Jurong West', 'My favourite turtle called Bob', 'Excellent', 'blender@yahoo.com');
INSERT INTO item(name, location, description, condition, owner) VALUES ('Screwdriver', 'Yishun', 'Rusty, but works the way you expect it to work', 'Poor', 'dish@hotmail.com');

INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(50, '2016-11-29', '2016-12-10', 3, 'erik@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(55, '2016-11-28', '2016-12-20', 2, 'alfredo@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(25, '2016-11-30', '2016-12-05', 1, 'alfredo@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(30, '2016-12-02', '2016-12-08', 1, 'barn@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(70, '2016-12-02', '2016-12-08', 1, 'dish@hotmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(700,'2016-12-02', '2016-12-08', 3, 'ilikeme@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(500,'2016-12-02', '2016-12-08', 7, 'ilikeme@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(25, '2016-12-02', '2016-12-08', 4, 'derp12@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(23, '2016-12-02', '2016-12-08', 5, 'derp12@gmail.com');
INSERT INTO bid(fee, StartDate, EndDate, item_id, bidder_email) VALUES(23, '2016-12-02', '2016-12-08', 5, 'derp12@gmail.com');