x61Y0EdU

1
2DROP SCHEMA IF EXISTS tmp CASCADE;
3CREATE SCHEMA tmp ;
4SET search_path=tmp;
5
6CREATE TABLE users (
7        id INTEGER NOT NULL,
8        email VARCHAR(120),
9        PRIMARY KEY (id),
10        UNIQUE (email)
11);
12INSERT INTO users VALUES(1,'Jim.Fake@nolive.co.uk');
13INSERT INTO users VALUES(2,'osman.narnia@live.co.uk');
14INSERT INTO users VALUES(3,'KimFake1@outlook.com');
15INSERT INTO users VALUES(4,'jaakume@gmail.com');
16INSERT INTO users VALUES(5,'omarblack@protonmail.com');
17INSERT INTO users VALUES(6,'osman.everton@hotmail.com');
18INSERT INTO users VALUES(7,'radoslaw@ganczarek.in');
19INSERT INTO users VALUES(8,'kane1001@live.co.uk');
20INSERT INTO users VALUES(9,'osman.soloking009@outlook.com');
21INSERT INTO users VALUES(10,'Shum1945@fleckens.hu');
22CREATE TABLE raffle (
23        id INTEGER NOT NULL,
24        user_id INTEGER,
25        colour VARCHAR(120),
26        up1 VARCHAR(4),
27        up2 VARCHAR(4),
28        PRIMARY KEY (id),
29        CONSTRAINT _color_up1_up2_uc UNIQUE (colour, up1, up2),
30        FOREIGN KEY(user_id) REFERENCES users (id)
31);
32INSERT INTO raffle VALUES(1,1,'Blue','7c4c','5c7e');
33INSERT INTO raffle VALUES(2,1,'Pink','635d','853f');
34INSERT INTO raffle VALUES(3,1,'Plum','5e80','7611');
35INSERT INTO raffle VALUES(4,1,'Aqua','937c','1b75');
36INSERT INTO raffle VALUES(5,2,'Navy','1d9a','8914');
37INSERT INTO raffle VALUES(6,1,'Grey','d869','fc97');
38INSERT INTO raffle VALUES(7,4,'Rose','5fee','b31f');
39INSERT INTO raffle VALUES(8,1,'Ruby','d5b4','e749');
40INSERT INTO raffle VALUES(9,2,'Teal','cf0b','3bf5');
41INSERT INTO raffle VALUES(10,1,'Gold','98a7','3079');
42INSERT INTO raffle VALUES(11,1,'Jade','5c69','66f8');
43INSERT INTO raffle VALUES(12,1,'Lime','156f','6b34');
44INSERT INTO raffle VALUES(13,1,'Blue','7da3','d95b');
45INSERT INTO raffle VALUES(14,1,'Pink','a63e','b9b6');
46INSERT INTO raffle VALUES(15,1,'Plum','d989','71a5');
47INSERT INTO raffle VALUES(16,1,'Aqua','7372','0682');
48/****
49INSERT INTO raffle VALUES(17,9,'Navy','01b3','e444');
50INSERT INTO raffle VALUES(18,1,'Grey','d679','0123');
51INSERT INTO raffle VALUES(19,1,'Rose','5963','692d');
52...
53***/
54COMMIT;