CREATE TABLE Users (
UserID INT(255) NOT NULL AUTO_INCREMENT,
Username VARCHAR(255) NOT NULL,
eMail VARCHAR(255) NOT NULL,
Password VARCHAR(255) NOT NULL,
SessionID VARCHAR(255) NOT NULL,
RegistrationDate DATE NULL,
Firstname VARCHAR(255) NULL,
Lastname VARCHAR(255) NULL,
Birthday DATE NULL,
ShowRealname BOOL NOT NULL DEFAULT 0,
PRIMARY KEY(UserID)
)
TYPE=InnoDB;
CREATE TABLE Blogs (
BlogID INT(255) NOT NULL AUTO_INCREMENT,
UserID_FK INT(255) NOT NULL,
Title VARCHAR(255) NOT NULL,
CreateDate DATE NOT NULL,
PRIMARY KEY(BlogID),
INDEX Blogs_FKIndex1(UserID_FK)
)
TYPE=InnoDB;
CREATE TABLE Categories (
CategoryID INT(255) NOT NULL AUTO_INCREMENT,
Categoryname VARCHAR(255) NULL,
PRIMARY KEY(CategoryID)
)
TYPE=InnoDB;
CREATE TABLE Blog_Categories (
BlogID INT(255) NOT NULL,
CategoryID INT(255) NOT NULL,
PRIMARY KEY(BlogID, CategoryID),
INDEX Blog_Categories_FKIndex1(BlogID),
INDEX Blog_Categories_FKIndex2(CategoryID)
)
TYPE=InnoDB;
CREATE TABLE Blog_Articles (
Blog_ArticleID INT(255) NOT NULL AUTO_INCREMENT,
LastModifiedBy INT(255) NOT NULL,
CreatedBy INT(255) NOT NULL,
BlogID_FK INT(255) NOT NULL,
Headline TEXT NOT NULL,
Articletext TEXT NOT NULL,
CreateDate DATE NOT NULL,
LastModifiedDate DATE NOT NULL,
Published BOOL NOT NULL DEFAULT 0,
PRIMARY KEY(Blog_ArticleID),
INDEX Blog_Articles_FKIndex1(BlogID_FK),
INDEX Blog_Articles_FKIndex2(CreatedBy),
INDEX Blog_Articles_FKIndex3(LastModifiedBy)
)
TYPE=InnoDB;
CREATE TABLE Blog_Article_Pages (
Page INT(255) NOT NULL,
Blog_ArticleID INT(255) NOT NULL,
Articletext TEXT NULL,
PRIMARY KEY(Page, Blog_ArticleID),
INDEX Blog_Article_Pages_FKIndex1(Blog_ArticleID)
)
TYPE=InnoDB;
CREATE TABLE Blog_Article_Comments (
Blog_Article_CommentID INT(255) NOT NULL AUTO_INCREMENT,
LastModifiedBy INT(255) NOT NULL,
CreatedBy INT(255) NOT NULL,
Blog_ArticleID INT(255) NOT NULL,
Commenttext TEXT NOT NULL,
CreateDate DATE NOT NULL,
LastModifiedDate DATE NOT NULL,
PRIMARY KEY(Blog_Article_CommentID),
INDEX Blog_Article_Comments_FKIndex1(Blog_ArticleID),
INDEX Blog_Article_Comments_FKIndex2(CreatedBy),
INDEX Blog_Article_Comments_FKIndex3(LastModifiedBy)
)
TYPE=InnoDB;