data.sql

DELETE FROM commission;
DELETE FROM bid;
DELETE FROM account;
DELETE FROM item;
DELETE FROM coupon;
DELETE FROM users;

ALTER SEQUENCE coupon_coupon_id_seq RESTART WITH 1;
ALTER SEQUENCE item_item_id_seq RESTART WITH 1;
ALTER SEQUENCE bid_bid_id_seq RESTART WITH 1;
ALTER SEQUENCE account_account_id_seq RESTART WITH 1;
ALTER SEQUENCE commission_commission_id_seq RESTART WITH 1;

INSERT INTO users  VALUES ('seller1', 'spw1', 'jumin1', FALSE);
INSERT INTO users  VALUES ('seller2', 'spw2', 'jumin2', FALSE);
INSERT INTO users  VALUES ('buyer1', 'bpw1', 'jumin3', FALSE);
INSERT INTO users  VALUES ('buyer2', 'bpw1', 'jumin4', FALSE);
INSERT INTO users  VALUES ('admin1', 'apw1', 'kim', TRUE);

INSERT INTO coupon VALUES (DEFAULT, 10, 'seller1', 'USABLE', '2024-11-11', '2024-12-11');
INSERT INTO coupon VALUES (DEFAULT, 20, 'seller2', 'USABLE', '2024-11-11', '2024-12-11');

INSERT INTO item VALUES (DEFAULT, 'iphone12', 'ELECTRONICS', 'LIKE_NEW', 'it was my phone', 500.5, 750, '2024-11-11 10:00:00', '2024-12-11 10:00:00', 'OPENED', 'seller1', 1);
INSERT INTO item VALUES (DEFAULT, 'lovely doll', 'OTHERS', 'ACCEPTABLE', 'it was my favorite doll', 50.25, 100.5, '2024-11-11 10:00:00', '2024-12-11 10:00:00', 'OPENED', 'seller2', 2);

INSERT INTO bid VALUES (DEFAULT, 1, 'buyer1', 550, '2024-11-12 10:00:00', 'buyer1', 550, DEFAULT, NULL);
INSERT INTO bid VALUES (DEFAULT, 2, 'buyer2', 60, '2024-11-12 10:00:00', 'buyer2', 60, DEFAULT, NULL);

INSERT INTO account VALUES (DEFAULT, 'buyer1', '1500', 'base profit', '2024-11-10 10:00:00');
INSERT INTO account VALUES (DEFAULT, 'buyer2', '200', 'base profit', '2024-11-10 10:00:00');