85 lines
3.1 KiB
SQL
85 lines
3.1 KiB
SQL
CREATE TABLE tx_watten_domain_model_athleten (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
crdate int(11) DEFAULT '0' NOT NULL,
|
|
gender int(4) DEFAULT '0' NOT NULL,
|
|
isactive int(4) DEFAULT '0' NOT NULL,
|
|
name varchar(50) NOT NULL DEFAULT '',
|
|
image varchar(50) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (uid)
|
|
);
|
|
|
|
CREATE TABLE tx_watten_domain_model_ergebnisse (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
crdate int(11) DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) DEFAULT '0' NOT NULL,
|
|
event_id int(11) DEFAULT '0' NOT NULL,
|
|
datum int(11) DEFAULT '0' NOT NULL,
|
|
s1 int(11) DEFAULT '0' NOT NULL,
|
|
s2 int(11) DEFAULT '0' NOT NULL,
|
|
v1 int(11) DEFAULT '0' NOT NULL,
|
|
v2 int(11) DEFAULT '0' NOT NULL,
|
|
bumid int(11) DEFAULT '0' NOT NULL,
|
|
gstrichen int(11) DEFAULT '0' NOT NULL,
|
|
tournaments_id int(11) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid)
|
|
);
|
|
|
|
CREATE TABLE tx_watten_domain_model_events (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
crdate int(11) DEFAULT '0' NOT NULL,
|
|
tournaments_id int(11) DEFAULT '0' NOT NULL,
|
|
datum int(11) DEFAULT '0' NOT NULL,
|
|
event varchar(50) NOT NULL DEFAULT '',
|
|
story text,
|
|
isactive tinyint(4) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid)
|
|
);
|
|
|
|
CREATE TABLE tx_watten_tournaments (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
crdate int(11) DEFAULT '0' NOT NULL,
|
|
tournament varchar(50) NOT NULL DEFAULT '',
|
|
active tinyint(4) DEFAULT '0' NOT NULL,
|
|
king tinyint(4) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid)
|
|
);
|
|
|
|
CREATE TABLE tx_watten_tournaments_ergebnisse (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
crdate int(11) DEFAULT '0' NOT NULL,
|
|
tstamp int(11) DEFAULT '0' NOT NULL,
|
|
tournament_id int(11) DEFAULT '0' NOT NULL,
|
|
type varchar(20) DEFAULT '0' NOT NULL,
|
|
tournament varchar(30) DEFAULT '0' NOT NULL,
|
|
koenig_id int(11) DEFAULT '0' NOT NULL,
|
|
koenig varchar(120) DEFAULT '0' NOT NULL,
|
|
schneewatter_id int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter varchar(120) DEFAULT '0' NOT NULL,
|
|
koenig_spiele int(11) DEFAULT '0' NOT NULL,
|
|
koenig_punkte double(5, 1) DEFAULT '0' NOT NULL,
|
|
koenig_siege int(11) DEFAULT '0' NOT NULL,
|
|
koenig_niederlagen int(11) DEFAULT '0' NOT NULL,
|
|
koenig_schneider int(11) DEFAULT '0' NOT NULL,
|
|
koenig_schneider_niederlage int(11) DEFAULT '0' NOT NULL,
|
|
koenig_retour_schneider int(11) DEFAULT '0' NOT NULL,
|
|
koenig_retour_schneider_niederlage int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_spiele int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_punkte double(5, 1) DEFAULT '0' NOT NULL,
|
|
schneewatter_siege int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_niederlagen int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_schneider int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_schneider_niederlage int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_retour_schneider int(11) DEFAULT '0' NOT NULL,
|
|
schneewatter_retour_schneider_niederlage int(11) DEFAULT '0' NOT NULL,
|
|
result_json text DEFAULT NULL,
|
|
PRIMARY KEY (uid)
|
|
); |