feQix3Am

1create table if not Exists tblOberkategorien(
2
3	p_okatID 		 	int unsigned NOT NUll Auto_increment primary key,
4	okatName		 	varchar(30) NOT NUll
5
6);
7
8create table if not Exists tblUnterkategorie(
9	p_ukatID 			int unsigned Not NUll Auto_increment primary key,
10	ukatname  			varchar(30) Not NUll,
11	f_okatID 			int unsigned Not NUll,
12	foreign key(f_okatID) references tblOberkategorien(p_okatID)
13
14);
15
16create table if not Exists tblStati(
17	p_stID 				int unsigned Not Null Auto_increment primary key,
18	stBezeichnung 		varchar(30) Not Null
19
20);
21create table if not Exists tblBenutzergruppe(
22	p_beGrupID 			int unsigned Not Null Auto_increment primary key,
23	beGrupName 			varchar(30) Not Null
24);
25
26create table if not Exists tblBenutzer(
27	p_benID 			int unsigned not Null Auto_increment primary key,
28	benName 			varchar(30) Not Null UNIQUE,
29	benPasswd	 		varchar(32) Not Null ,
30	benMail 			varchar(100) Not Null UNIQUE,
31	benGebDatum 		date Not Null,
32	benGeschlecht 		char(1) Not Null, 
33	benRegDatum 		datetime not null,
34	benBild 			varchar(255),
35	benUeberMich 		text,
36	f_beGrupID 			int unsigned Not Null,
37	foreign key(f_beGrupID)references tblBenutzergruppe(p_beGrupID)
38
39
40);
41
42create table if not Exists tblThemen(
43	p_tID 				int unsigned Not NUll Auto_increment primary key,
44	tErstellDatum 		datetime Not Null,
45	tTitel 				varchar(30) Not Null,
46	f_stdID 			int unsigned Not Null,
47	f_ukatID 			int unsigned Not Null,
48	f_benID				int unsigned not null,
49	foreign key(f_stdID) references tblStati(p_stID),
50	foreign key(f_ukatID) references tblUnterkategorie(p_ukatID),
51	foreign key(f_benID) references tblBenutzer(p_benID)
52
53);
54
55
56
57create table if not Exists tblBeitraege(
58	p_beiID 			int unsigned Not Null Auto_increment primary key,
59	beiErstellDatum 	datetime Not Null,
60	beiInhalt 			text Not Null,
61	f_tID 				int unsigned Not Null,
62	f_benID 			int unsigned Not Null,
63	foreign key(f_tID) references tblThemen(p_tID),
64	foreign key(f_benID) references tblBenutzer(p_benID)
65
66);
67
68create table if not Exists tblLogins(
69	p_logID 			int unsigned not null Auto_increment primary key,
70	logZeitVon 			datetime Not null,
71	logZeitBis 			datetime,
72	logIP 				varchar(15) Not Null ,
73	f_benID 			int unsigned Not Null,
74	foreign key (f_benID) references tblBenutzer(p_benID)
75);