Databasstruktur

CREATE TABLE user (
	ID int(11) PRIMARY KEY,
	EMAIL varchar(255) NOT NULL UNIQUE,
	NICK varchar(255) NOT NULL UNIQUE,
	PASSWORD varchar(255) NOT NULL,
	TIME datetime NOT NULL
);

CREATE TABLE usergroup (
	ID int(11) PRIMARY KEY,
	NAME varchar(255) NOT NULL UNIQUE,
        TIME datetime NOT NULL
);

CREATE TABLE post (
	ID int(11) PRIMARY KEY AUTO_INCREMENT,	
	TITLE varchar(255) NOT NULL,
	TEXT varchar(255) NOT NULL,
	POSTER int(11) NOT NULL REFERENCES user(ID),
	USERGROUP int(11) NOT NULL REFERENCES usergroup(ID),
        TIME datetime NOT NULL
);

CREATE TABLE comment (
	ID int(11) PRIMARY KEY AUTO_INCREMENT,
	TEXT varchar(255) NOT NULL,
	POST int(11) NOT NULL REFERENCES post(ID),
	COMMENTER int(11) NOT NULL REFERENCES user(ID),
	STATUS int(11) NOT NULL,
	TIME datetime NOT NULL
);

CREATE TABLE membership (
	USER_ID int(11) REFERENCES user(ID),
	USERGROUP_ID int(11) REFERENCES usergroup(ID),
	STATUS int(11) NOT NULL,
	TIME datetime NOT NULL,
	PRIMARY KEY(USER_ID, USERGROUP_ID)
);

CREATE TABLE hiddenpost (
	USER_ID int(11) REFERENCES user(ID),
	POST_ID int(11) REFERENCES post(ID),
	TIME datetime NOT NULL,
	PRIMARY KEY(USER_ID, POST_ID)
);