JavaServ/Bundesliga_init.sql at master · arothenhaeuser/JavaServ · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE DATABASE IF NOT EXISTS Bundesliga;
USE Bundesliga;
CREATE TABLE IF NOT EXISTS Abgeordnete(
	LastName varchar(255),
	FirstName varchar(255),
	DateOfBirth date,
	Job varchar(255),
	Qualification varchar(255),
	Picture varchar(255),
	StatusID tinyint,
	CityID tinyint,
	ProvinceID tinyint,
	PartyID tinyint,
	ConfessionID tinyint
);
CREATE TABLE IF NOT EXISTS Stati(
	ID tinyint,
	Label varchar(255)
);
CREATE TABLE IF NOT EXISTS Cities(
	ID tinyint,
	Label varchar(255)
);
CREATE TABLE IF NOT EXISTS Provinces(
	ID tinyint,
	Label varchar(255),
	Emblem image,
	Capital varchar(255)
);
CREATE TABLE IF NOT EXISTS Parties(
	ID tinyint,
	Label varchar(255),
	Emblem image,
	Leader varchar(255),
	Chairman varchar(255)
);
CREATE TABLE IF NOT EXISTS Confessions(
	ID tinyint,
	Label varchar(255)
);