CREATE TABLE team (
    id int NOT NULL,
    name varchar(100) NOT NULL,
    status BOOLEAN NOT NULL,
    first_year_students BOOLEAN NOT NULL,
    school_team BOOLEAN NOT NULL,
    room int NOT NULL,
    pc_num int NOT NULL,
    problems_solved int NOT NULL,
    penalty int NOT NULL,
    place int NOT NULL,
    CONSTRAINT team_pk PRIMARY KEY (id)
) WITH (
  OIDS=FALSE
);



CREATE TABLE participant (
    id int NOT NULL,
    name varchar(100) NOT NULL,
    email varchar(100) NOT NULL UNIQUE,
    phone_number varchar(100) NOT NULL UNIQUE,
    university varchar(100) NOT NULL,
    year_of_study int NOT NULL,
    from_school BOOLEAN NOT NULL,
    CONSTRAINT participant_pk PRIMARY KEY (id)
) WITH (
  OIDS=FALSE
);



CREATE TABLE championship (
    id int NOT NULL,
    team_count int NOT NULL,
    best_1_year_team_id int NOT NULL,
    best_school_team_id int NOT NULL,
    CONSTRAINT championship_pk PRIMARY KEY (id)
) WITH (
  OIDS=FALSE
);



CREATE TABLE participant_team (
    id int NOT NULL,
    participant_id int NOT NULL,
    team_id int NOT NULL,
    CONSTRAINT participantteam_pk PRIMARY KEY (id)
) WITH (
  OIDS=FALSE
);



CREATE TABLE rating (
    id int NOT NULL,
    championship_id int NOT NULL,
    team_id int NOT NULL,
    place int NOT NULL,
    CONSTRAINT rating_pk PRIMARY KEY (id)
) WITH (
  OIDS=FALSE
);




ALTER TABLE championship ADD CONSTRAINT championship_fk0 FOREIGN KEY (best_1_year_team_id) REFERENCES team(id);
ALTER TABLE championship ADD CONSTRAINT championship_fk1 FOREIGN KEY (best_school_team_id) REFERENCES team(id);

ALTER TABLE participant_team ADD CONSTRAINT participant_team_fk0 FOREIGN KEY (participant_id) REFERENCES participant(id);
ALTER TABLE participant_team ADD CONSTRAINT participant_team_fk1 FOREIGN KEY (team_id) REFERENCES team(id);

ALTER TABLE rating ADD CONSTRAINT rating_fk0 FOREIGN KEY (championship_id) REFERENCES championship(id);
ALTER TABLE rating ADD CONSTRAINT rating_fk1 FOREIGN KEY (team_id) REFERENCES team(id);



INSERT INTO participant VALUES (1, 'Maximov', 'lovepoland@yandex.ru', '89217297364', 'SPbSU', 3, false);
INSERT INTO participant VALUES (2, 'Smirnova', 'mynewmail1@yandex.ru', '89217297365', 'SPbSU', 1, false);
INSERT INTO participant VALUES (3, 'Alexeev', 'mynewmail2@yandex.ru', '89217297366', 'SPbSU', 3, false);
INSERT INTO participant VALUES (4, 'Alexin', 'mynewmail3@yandex.ru', '89217297367', 'ITMO', 4, false);
INSERT INTO participant VALUES (5, 'Petrov', 'mynewmail4@yandex.ru', '89217297368', 'SPbSU', 2, false);
INSERT INTO participant VALUES (6, 'Smirnov', 'mynewmail5@yandex.ru', '89217297369', 'SPbPU', 1, false);
INSERT INTO participant VALUES (7, 'Belichenko', 'mynewmail6@yandex.ru', '892172973610', 'SPbSU', 2, false);
INSERT INTO participant VALUES (8, 'Maximova', 'mynewmail7@yandex.ru', '89217297311', 'SPbSU', 2, false);
INSERT INTO participant VALUES (9, 'Zhmyshenko', 'mynewmail8@yandex.ru', '89217297312', 'SPbSU', 2, false);
INSERT INTO participant VALUES (10, 'Ivanov', 'mynewmail9@yandex.ru', '89217297313', '239', 0, true);
INSERT INTO participant VALUES (11, 'Andreev', 'mynewmail10@yandex.ru', '89217297314', 'SPbSU', 5, false);
INSERT INTO participant VALUES (12, 'Bushlatov', 'mynewmail11@yandex.ru', '89217297315', 'SPbSU', 3, false);
INSERT INTO participant VALUES (13, 'Gubkin', 'mynewmail12@yandex.r', '89217297316', 'SPbSU', 1, false);
INSERT INTO participant VALUES (14, 'Maximovich', 'mynewmail13@yandex.r', '89217297317', 'SPbSU', 3, false);
INSERT INTO participant VALUES (15, 'Anisimovich', 'mynewmail14@yandex.ru', '89217297318', 'SPbSU', 1, false);
INSERT INTO participant VALUES (16, 'Alexievich', 'mynewmail15@yandex.ru', '89217297319', '30', 0, true);
INSERT INTO participant VALUES (17, 'Alexinich', 'mynewmail16@yandex.ru', '89217297320', 'ITMO', 4, false);
INSERT INTO participant VALUES (18, 'Petrovich', 'mynewmail17@yandex.ru', '89217297321', 'SPbSU', 2, false);
INSERT INTO participant VALUES (19, 'Smirnovich', 'mynewmail18@yandex.ru', '89217297322', 'SPbPU', 1, false);
INSERT INTO participant VALUES (20, 'Bibikin', 'mynewmail19@yandex.ru', '89217297323', 'SPbSU', 1, false);
INSERT INTO participant VALUES (21, 'Belikov', 'mynewmail20@yandex.ru', '89217297324', 'SPbSU', 2, false);
INSERT INTO participant VALUES (22, 'Shlyapik', 'mynewmail21@yandex.ru', '89217297325', 'HSE', 2, false);
INSERT INTO participant VALUES (23, 'Borovoy', 'mynewmail22@yandex.ru', '89217297326', '239', 0, true);
INSERT INTO participant VALUES (24, 'Detrov', 'mynewmail23@yandex.ru', '89217297327', 'ITMO', 5, false);
INSERT INTO participant VALUES (25, 'Semenov', 'mynewmail24@yandex.ru', '89217297328', 'SPbSU', 3, false);
INSERT INTO participant VALUES (26, 'Pratusevich', 'mynewmail25@yandex.r', '8921297329', '239', 0, true);
INSERT INTO participant VALUES (27, 'Detrova', 'mynewmail26@yandex.r', '89217297330', 'SPbSU', 3, false);
INSERT INTO participant VALUES (28, 'Raul', 'mynewmail27@yandex.ru', '89217297331', 'MSU', 1, false);
INSERT INTO participant VALUES (29, 'Markes', 'mynewmail28@yandex.ru', '89217297332', '30', 0, true);
INSERT INTO participant VALUES (30, 'Markov', 'mynewmail29@yandex.ru', '89217297333', 'ITMO', 4, false);
INSERT INTO participant VALUES (31, 'Spirin', 'mynewmail30@yandex.ru', '89217297334', 'SPbSU', 2, false);
INSERT INTO participant VALUES (32, 'Lermontov', 'mynewmail31@yandex.ru', '89217297335', 'PTU', 1, false);
INSERT INTO participant VALUES (33, 'Pelevin', 'mynewmail32@yandex.ru', '89217297336', 'SPbSU', 1, false);
INSERT INTO participant VALUES (34, 'Pushkin', 'mynewmail33@yandex.ru', '89217297337', 'MIPT', 2, false);
INSERT INTO participant VALUES (35, 'Plyushkin', 'mynewmail34@yandex.ru', '89217297338', 'HSE', 2, false);
INSERT INTO participant VALUES (36, 'Pyshkin', 'mynewmail35@yandex.ru', '89217297339', '239', 0, true);
INSERT INTO participant VALUES (37, 'Blinchikov', 'mynewmail36@yandex.ru', '89217297340', 'ITMO', 5, false);
INSERT INTO participant VALUES (38, 'Ponchikov', 'mynewmail37@yandex.ru', '89217297341', 'SPbSU', 3, false);
INSERT INTO participant VALUES (39, 'Oladushkin', 'mynewmail38@yandex.r', '8921297342', '239', 0, true);
INSERT INTO participant VALUES (40, 'Pankeykin', 'mynewmail39@yandex.ru', '89217297343', '239', 0, true);
INSERT INTO participant VALUES (41, 'Pirozhkov', 'mynewmail40@yandex.ru', '89217297344', 'SPbSU', 5, false);
INSERT INTO participant VALUES (42, 'Karamelkin', 'mynewmail41@yandex.ru', '89217297345', 'SPbSU', 3, false);
INSERT INTO participant VALUES (43, 'Deniskin', 'mynewmail42@yandex.r', '89217297346', 'SPbSU', 1, false);
INSERT INTO participant VALUES (44, 'Albertych', 'mynewmail43@yandex.r', '89217297347', 'ITMO', 1, false);
INSERT INTO participant VALUES (45, 'Anekin', 'mynewmail44@yandex.r', '89217297348', 'SPbSU', 1, false);


INSERT INTO team VALUES (1, 'Dream Team', true , true , false , 1 , 1 , 10 , 60 , 2);
INSERT INTO team VALUES (2, 'Best Team', true , true , false , 1 , 2 , 9 , 60 , 3);
INSERT INTO team VALUES (3, 'Good Team', true , true , false , 1 , 3 , 8 , 60 , 4);
INSERT INTO team VALUES (4, 'Bad Team', true , true , false , 1 , 4 , 7 , 60 , 5);
INSERT INTO team VALUES (5, '239 Team', true , true , false , 1 , 5 , 6 , 60 , 6);
INSERT INTO team VALUES (6, 'ITMO + HSE Team', true , true , false , 1 , 6 , 5 , 60 , 7);
INSERT INTO team VALUES (7, 'SBP Team', true , true , false , 2 , 1 , 4 , 60 , 8);
INSERT INTO team VALUES (8, 'UFA Team', true , true , false , 2 , 2 , 3 , 60 , 9);
INSERT INTO team VALUES (9, 'DERYABINO Team', true , true , false , 2 , 3 , 2 , 60 , 10);
INSERT INTO team VALUES (10, 'TAMBOV Team', true , true , false , 2 , 4 , 1 , 60 , 11);
INSERT INTO team VALUES (11, 'SAMARA Team', true , true , false , 2 , 5 , 1 , 61 , 12);
INSERT INTO team VALUES (12, 'SARATOV Team', true , true , false , 2 , 6 , 1 , 62 , 13);
INSERT INTO team VALUES (13, 'KIIV Team', true , true , false , 2 , 7 , 11 , 1200 , 1);
INSERT INTO team VALUES (14, 'LVIV Team', true , true , false , 2 , 8 , 0 , 00 , 14);
INSERT INTO team VALUES (15, 'MINSK Team', true , true , false , 3 , 1 , 0 , 0 , 15);


INSERT INTO championship VALUES (1, 15, 13 , 7);


INSERT INTO rating VALUES (1, 1 , 1 , 2);
INSERT INTO rating VALUES (2, 1 , 2 , 3);
INSERT INTO rating VALUES (3, 1 , 3 , 4);
INSERT INTO rating VALUES (4, 1 , 4 , 5);
INSERT INTO rating VALUES (5, 1 , 5 , 6);
INSERT INTO rating VALUES (6, 1 , 6 , 7);
INSERT INTO rating VALUES (7, 1 , 7 , 8);
INSERT INTO rating VALUES (8, 1 , 8 , 9);
INSERT INTO rating VALUES (9, 1 , 9 , 10);
INSERT INTO rating VALUES (10, 1 , 10 , 11);
INSERT INTO rating VALUES (11, 1 , 11 , 12);
INSERT INTO rating VALUES (12, 1 , 12 , 13);
INSERT INTO rating VALUES (13, 1 , 13 , 1);
INSERT INTO rating VALUES (14, 1 , 14 , 14);
INSERT INTO rating VALUES (15, 1 , 15 , 15);



INSERT INTO participant_team VALUES (1, 30, 7);
INSERT INTO participant_team VALUES (2, 40, 7);
INSERT INTO participant_team VALUES (3, 36, 7);
INSERT INTO participant_team VALUES (4, 43, 13);
INSERT INTO participant_team VALUES (5, 44, 13);
INSERT INTO participant_team VALUES (6, 45, 13);
INSERT INTO participant_team VALUES (7, 1, 1);
INSERT INTO participant_team VALUES (8, 2, 1);
INSERT INTO participant_team VALUES (9, 3, 1);
INSERT INTO participant_team VALUES (10, 4, 2);
INSERT INTO participant_team VALUES (11, 5, 2);
INSERT INTO participant_team VALUES (12, 6, 2);
INSERT INTO participant_team VALUES (13, 7, 3);
INSERT INTO participant_team VALUES (14, 8, 3);
INSERT INTO participant_team VALUES (15, 9, 3);
INSERT INTO participant_team VALUES (16, 10, 4);
INSERT INTO participant_team VALUES (17, 11, 4);
INSERT INTO participant_team VALUES (18, 12, 4);
INSERT INTO participant_team VALUES (19, 13, 5);
INSERT INTO participant_team VALUES (20, 14, 5);
INSERT INTO participant_team VALUES (21, 15, 5);
INSERT INTO participant_team VALUES (22, 16, 6);
INSERT INTO participant_team VALUES (23, 17, 6);
INSERT INTO participant_team VALUES (24, 18, 6);
INSERT INTO participant_team VALUES (25, 19, 8);
INSERT INTO participant_team VALUES (26, 20, 8);
INSERT INTO participant_team VALUES (27, 21, 8);
INSERT INTO participant_team VALUES (28, 22, 9);
INSERT INTO participant_team VALUES (29, 23, 9);
INSERT INTO participant_team VALUES (30, 24, 9);
INSERT INTO participant_team VALUES (31, 25, 10);
INSERT INTO participant_team VALUES (32, 26, 10);
INSERT INTO participant_team VALUES (33, 27, 10);
INSERT INTO participant_team VALUES (34, 28, 11);
INSERT INTO participant_team VALUES (35, 29, 11);
INSERT INTO participant_team VALUES (36, 31, 11);
INSERT INTO participant_team VALUES (37, 32, 12);
INSERT INTO participant_team VALUES (38, 33, 12);
INSERT INTO participant_team VALUES (39, 34, 12);
INSERT INTO participant_team VALUES (40, 35, 14);
INSERT INTO participant_team VALUES (41, 37, 14);
INSERT INTO participant_team VALUES (42, 38, 14);
INSERT INTO participant_team VALUES (43, 39, 15);
INSERT INTO participant_team VALUES (44, 41, 15);
INSERT INTO participant_team VALUES (45, 42, 15);