fuMZxURz

1drop table if exists calendar_item;
2drop table if exists game_event;
3drop table if exists sponsor;
4drop table if exists game_side;
5drop table if exists game_ground;
6drop table if exists equipment_item;
7drop table if exists team;
8drop table if exists team_member;
9drop table if exists Player;
10
11
12create table Player(
13	player_id serial primary key,
14	login text,
15	ppassword char(32),
16	firstName char(32),
17	secondName char(32),
18	dateOfBirth date,
19	nickname char(32),
20	plocation char(32),
21	photo text, 
22	team char(32) references team()
23	);
24	
25create table team(
26	team_id serial primary key,
27	teamName char(32) NOT NULL, 
28	capitan char(32),
29	numMember integer,
30	emblem text);
31	
32create table equipment_item(
33	item_id serial primary key,
34	equipmentType char(32),
35	equipmentName char(32),
36	equipmentPhoto text
37	);
38
39create table game_ground(
40	ground_id serial primary key,
41	address text,
42	capacity integer);
43	
44	
45create table game_side(
46	side_id serial primary key,
47	side_name char(32));
48
49create table sponsor(
50	sponsor_id serial primary key,
51	firstName char(32),
52	secondName char(32),
53	company_name char(32),
54	information text,
55	emblem text);
56	
57create table game_event(
58	game_id serial primary key,
59	gameName char(64),
60	gameSponsor char(64),
61	gameDate TIMESTAMP,
62	gameType char(32),
63	gameLocation char(64),
64	max_player_number integer,
65	game_cost integer,
66	game_information text);
67	
68	
69create table calendar_item(
70	citem_id serial primary key,
71	cdate date,
72	gameName char(64));
73	
74
75
76	
77insert into Player values(1, 'Fynduk', 'qwerty', 'German', 'Duk', 1998-09-15, 'Duker', 'SPB', 'https://sun9-11.userapi.com/c853428/v853428714/110e07/bPMeN_rYKTI.jpg');