317 lines
11 KiB
SQL
317 lines
11 KiB
SQL
CREATE TABLE fe_users (
|
|
kammermitgliedsnummer varchar(20) DEFAULT '0',
|
|
inliste int(11) DEFAULT '0' NOT NULL,
|
|
vereidigung date DEFAULT '0000-00-00',
|
|
frauenfoerderpunkt tinyint(1) DEFAULT '0' NOT NULL,
|
|
solidaritaetserklaerung int(11) DEFAULT '0',
|
|
extrasperrung int(11) DEFAULT '0',
|
|
kontoaufloesung int(11) DEFAULT '0',
|
|
kontoaufloesung_begruendung varchar(255) DEFAULT '' NOT NULL,
|
|
kontoaufloesung_active date DEFAULT '0000-00-00',
|
|
wettbewerbe int(11) DEFAULT '0',
|
|
kammernid int(11) DEFAULT '0',
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_archive_admin (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
tstamp int(11) NOT NULL DEFAULT '0',
|
|
crdate int(11) NOT NULL DEFAULT '0',
|
|
hidden tinyint(4) NOT NULL DEFAULT '0',
|
|
liste longtext,
|
|
PRIMARY KEY (uid)
|
|
) ENGINE=InnoDB DEFAULT;
|
|
|
|
|
|
CREATE TABLE tx_zuladungsliste_archive_user (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
user_id int(11) DEFAULT NULL,
|
|
archive_admin_uid int(11) unsigned NOT NULL DEFAULT '0',
|
|
tstamp int(11) unsigned NOT NULL DEFAULT '0',
|
|
crdate int(11) unsigned NOT NULL DEFAULT '0',
|
|
hidden tinyint(4) unsigned NOT NULL DEFAULT '0',
|
|
company varchar(120) NOT NULL DEFAULT '',
|
|
name varchar(120) NOT NULL DEFAULT '',
|
|
punkte varchar(20) NOT NULL DEFAULT '',
|
|
nominiert int(11) unsigned NOT NULL DEFAULT '0',
|
|
rang int(11) unsigned NOT NULL DEFAULT '0',
|
|
pos int(11) unsigned NOT NULL DEFAULT '0',
|
|
auswertung longtext,
|
|
PRIMARY KEY (uid)
|
|
) ENGINE=InnoDB DEFAULT;
|
|
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_extrasperrung (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
begruendung varchar(255) NOT NULL DEFAULT '',
|
|
sperrzeitbis date DEFAULT '0000-00-00',
|
|
extrasperrung_user int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_kammern (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
bezeichnung varchar(255) DEFAULT '' NOT NULL,
|
|
einsichtstag int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_punkte_kriterien_mm (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
uid_punkte int(11) unsigned NOT NULL DEFAULT '0',
|
|
uid_kriterien int(11) unsigned NOT NULL DEFAULT '0',
|
|
sorting int(11) unsigned NOT NULL DEFAULT '0',
|
|
punkte varchar(10) NOT NULL DEFAULT '0',
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_wettbewerbe (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
wettbewerb varchar(255) DEFAULT '' NOT NULL,
|
|
beschreibung text NOT NULL,
|
|
registrierung varchar(255) DEFAULT '' NOT NULL,
|
|
verfahrensid int(11) NOT NULL DEFAULT '0',
|
|
verfahrensort varchar(255) DEFAULT '' NOT NULL,
|
|
bundesland varchar(255) DEFAULT '' NOT NULL,
|
|
abgabetermin date DEFAULT '0000-00-00',
|
|
kammerbeschluss date DEFAULT '0000-00-00',
|
|
entscheidungstermin date DEFAULT '0000-00-00',
|
|
sperrung tinyint(1) unsigned DEFAULT '0' NOT NULL,
|
|
aufgabenstellung text NOT NULL,
|
|
wettbewerb_user int(11) unsigned DEFAULT '0' NOT NULL,
|
|
kriteriumid int(11) unsigned NOT NULL DEFAULT '0',
|
|
sperre_deaktiviert tinyint(4) NOT NULL DEFAULT '0',
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_kriterien (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
bezeichnung varchar(255) NOT NULL DEFAULT '',
|
|
punkteid int(11) unsigned DEFAULT '0',
|
|
preisartid int(11) unsigned DEFAULT '0',
|
|
sektinstagid int(11) unsigned DEFAULT '0',
|
|
kriterien_punkte int(11) unsigned DEFAULT '0',
|
|
kriterien_preisart int(11) unsigned DEFAULT '0',
|
|
kammernid int(11) unsigned DEFAULT '0',
|
|
sperrung int(11) unsigned DEFAULT '0',
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
sorting int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_punkte (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
bezeichnung varchar(255) DEFAULT '' NOT NULL,
|
|
kriterienid int(11) NOT NULL DEFAULT '0',
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
sorting int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_preisart (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
|
|
preisart varchar(255) DEFAULT '' NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_sektionstage (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) DEFAULT '0' NOT NULL,
|
|
rwcode varchar(10) DEFAULT '' NOT NULL,
|
|
bezeichnung varchar(255) DEFAULT '' NOT NULL,
|
|
stichtag date DEFAULT '0000-00-00',
|
|
sperrzeit int(11) DEFAULT '0' NOT NULL,
|
|
sperrzeitstart date DEFAULT '0000-00-00',
|
|
punktezeit int(11) DEFAULT '0' NOT NULL,
|
|
punktezeitstart date DEFAULT '0000-00-00',
|
|
neueinsteiger int(11) DEFAULT '0' NOT NULL,
|
|
neueinsteigerstart date DEFAULT '0000-00-00',
|
|
frauenfoerderung int(11) DEFAULT '0' NOT NULL,
|
|
frauenfoerderungstart date DEFAULT '0000-00-00',
|
|
frauenfoerderungsonderstart date DEFAULT '0000-00-00',
|
|
kammernid int(11) unsigned DEFAULT '0',
|
|
sektionstage_notizen text NOT NULL,
|
|
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
|
|
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
starttime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
endtime int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_wettbewerbe_architekten_mm (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp_zuordnung int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp_aktivierung int(11) unsigned DEFAULT '0' NOT NULL,
|
|
tstamp_ablehnen int(11) unsigned DEFAULT '0' NOT NULL,
|
|
uid_wettbewerbe int(11) unsigned NOT NULL DEFAULT '0',
|
|
uid_user int(11) unsigned NOT NULL DEFAULT '0',
|
|
uid_punkte int(11) unsigned NOT NULL DEFAULT '0',
|
|
ladung_durch_auslober int(11) unsigned NOT NULL DEFAULT '0',
|
|
notizen varchar(155) DEFAULT NULL,
|
|
sorting int(11) unsigned NOT NULL DEFAULT '0',
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_extrasperrung_user_mm (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
uid_extrasperrung int(11) unsigned NOT NULL DEFAULT '0',
|
|
uid_user int(11) unsigned NOT NULL DEFAULT '0',
|
|
sorting int(11) unsigned NOT NULL DEFAULT '0',
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
);
|
|
|
|
CREATE TABLE tx_zuladungsliste_konto_aufloesung_mm (
|
|
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
uid_geber int(11) unsigned NOT NULL DEFAULT '0',
|
|
uid_empfaenger int(11) unsigned NOT NULL DEFAULT '0',
|
|
prozente double(5,2) DEFAULT '0.00',
|
|
|
|
PRIMARY KEY (uid),
|
|
KEY parent (pid)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE tx_zuladungsliste_domain_model_wettbewerbe_einreichungen (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
tstamp int(11) unsigned NOT NULL DEFAULT '0',
|
|
crdate int(11) unsigned NOT NULL DEFAULT '0',
|
|
deleted tinyint(4) unsigned NOT NULL DEFAULT '0',
|
|
hidden tinyint(4) unsigned NOT NULL DEFAULT '0',
|
|
cruser_id int(11) unsigned NOT NULL DEFAULT '0',
|
|
wettbewerb varchar(255) NOT NULL DEFAULT '',
|
|
beschreibung text NOT NULL,
|
|
entscheidungstermin date DEFAULT '0000-00-00',
|
|
verfahrensort varchar(255) NOT NULL DEFAULT '',
|
|
bundesland varchar(255) NOT NULL DEFAULT '',
|
|
dokument_name varchar(20) DEFAULT NULL,
|
|
dokument_orig_name varchar(220) DEFAULT NULL,
|
|
dokument_size varchar(10) DEFAULT NULL,
|
|
dokument_type varchar(20) DEFAULT NULL,
|
|
aufgenommen int(11) unsigned NOT NULL DEFAULT '0',
|
|
abgelehnt int(11) unsigned NOT NULL DEFAULT '0',
|
|
begruendung varchar(255) NOT NULL DEFAULT '',
|
|
|
|
PRIMARY KEY (uid)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE tx_zuladungsliste_zuteilungen (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
tstamp int(11) unsigned NOT NULL DEFAULT '0',
|
|
crdate int(11) unsigned NOT NULL DEFAULT '0',
|
|
hidden tinyint(4) unsigned NOT NULL DEFAULT '0',
|
|
uid_user int(11) DEFAULT '0',
|
|
uid_wettbewerbe int(11) unsigned NOT NULL DEFAULT '0',
|
|
anzahl_architekten int(11) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (uid)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE tx_zuladungsliste_zuteilungen_user (
|
|
uid int(11) NOT NULL auto_increment,
|
|
pid int(11) NOT NULL DEFAULT '0',
|
|
tstamp int(11) unsigned NOT NULL DEFAULT '0',
|
|
crdate int(11) unsigned NOT NULL DEFAULT '0',
|
|
hidden tinyint(4) unsigned NOT NULL DEFAULT '0',
|
|
uid_zuteilungen_user int(11) unsigned NOT NULL DEFAULT '0',
|
|
user_id int(11) DEFAULT NULL,
|
|
position int(11) DEFAULT NULL,
|
|
ersatz tinyint(4) unsigned DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (uid)
|
|
) ENGINE=InnoDB;
|