create table Admin
(
	AdminID int primary key auto_increment,
	AdminPassword varchar(30),
	FirstName varchar(75),
	LastName varchar(75),
	EmailAddress varchar(100),
	IsEnable bool
);

create table Category
(
	CategoryID int primary key auto_increment,
	CategoryName varchar(100),
	Description varchar(500),
	HeadCategoryID int,
	foreign key (HeadCategoryID) references Category (CategoryID)
);

Create table EWebSite
(
	EWebSiteID int primary key auto_increment,
	Title varchar(100),
	WebsiteURL varchar(200),
	Intro varchar(500),
	Category varchar(100),
	Hits int,
	DateAdded timestamp,
	categoryID int,
	foreign key (CategoryID) references Category (categoryID)
	
);

create table EMagazines
(
	EMagazinesID int primary key auto_increment,
	Title varchar(200),
	Picture varchar(100),
	Intro varchar(200),
	MagazinesURL varchar(100),
	Hits int,
	DateAdded bool,
	CategoryID int,
	foreign key (CategoryID) references Category (CategoryID)
);

create table ECommunity
(
	ECommunityID int primary key auto_increment,
	Title varchar(200),
	Intro varchar(200),
	CommunityURL varchar(100),
	Hits int,
	DateAdded bool,
	Categoryid int,
	foreign key (CategoryID) references Category (categoryID)
);

create table ETip
(
	ETipID int primary key auto_increment,
	Title varchar(200),
	TipText varchar(200),
	Hits int,
	DateAdded timestamp,
	CategoryID int,
	foreign key (CategoryID) references Category (categoryID)
);

create table EBook
(
	EBookID int primary key auto_increment,
	Title varchar(200),
	AuthorName varchar(100),
	Picture varchar(100),
	Intro varchar(200),
	BookURL varchar(100),
	Hits int,
	DateAdded timestamp,
	CategoryID int,
	foreign key (CategoryID) references Category (CategoryID)
);

create table ESoftware
(
	ESoftwareID int primary key auto_increment,
	Title varchar(100),
	Version varchar(200),
	AuthorName varchar(100),
	AuthorURL varchar(100),
	Intro varchar(200),
	Hits int,
	DateAdded timestamp,
	categoryID int,
	foreign key (CategoryID) references Category (CategoryID)
);

create table Country
(
	CountryID int primary key auto_increment,
	Name varchar(100),
	IsEnable bool
);

create table City
(
	CityID int primary key auto_increment,
	Name varchar(100),
	IsEnable bool,
	CountryID int,
	foreign key (CountryID) references Country (CountryID)
);

create table Developer
(
	DeveloperID int primary key auto_increment,
	EmailAddress varchar(100),
	Password varchar(30),
	FullName varchar(100),
	ContactPersonName varchar(100),
	Address varchar(200),
	Phone varchar(50),
	Fax varchar(50),
	DeveloperURL varchar(100),
	SupportEmail varchar(100),
	SaleEmail varchar(100),
	GeneralInfoEmail varchar(100),
	CompanyIntro varchar(500),
	SupportURL varchar(100),
	DateAdded timestamp,
	IsEnable bool,
	CityID int,
	foreign key (CityID) references City (CityID)
);

create table Script
(
	ScriptID int primary key auto_increment,
	Title varchar(150),
	Version varchar(100),
	Description varchar(500),
	DownloadLink varchar(150),
	BuyLink varchar(150),
	Size varchar(100),
	Requirements varchar(200),
	SEOTitle varchar(200),
	SEODescription varchar(500),
	SEOKeywords varchar(200),
	LisenceType varchar(200),
	Price1 varchar(100),
	Price2 varchar(100),
	Price3 varchar(100),
	ScreenShot1 varchar(100),
	ScreenShot2 varchar(100),
	ScreenShot3 varchar(100),
	ScreebShot4 varchar(100),
	ScreenShot5 varchar(100),
	Hits int,
	Downloads int,
	IsApproved bool,
	IsEditorsPick bool,
	IsEnable bool,
	IsFeatured bool,
	DateAdded timestamp,
	categoryID int,
	DeveloperID int,
	foreign key (CategoryID) references Category (CategoryID),
	foreign key (DeveloperID) references Developer (DeveloperID)
);

create table Video
(
	VideoID int primary key auto_increment,
	Title varchar(200),
	Description varchar(500),
	FileName varchar(100),
	IsEnable bool,
	ScriptID int,
	foreign key (ScriptID) references Script (ScriptID)
	
);

create table PendingScript
(
	PendingScriptID int primary key auto_increment,
	Title varchar(150),
	Version varchar(100),
	Description varchar(500),
	DownloadLink varchar(150),
	BuyLink varchar(150),
	Size varchar(100),
	Requirements varchar(200),
	SEOTitle varchar(200),
	SEODescription varchar(500),
	SEOKeywords varchar(200),
	LisenceType varchar(200),
	Price1 varchar(100),
	Price2 varchar(100),
	Price3 varchar(100),
	ScreenShot1 varchar(100),
	ScreenShot2 varchar(100),
	ScreenShot3 varchar(100),
	ScreebShot4 varchar(100),
	ScreenShot5 varchar(100),
	DateAdded timestamp,
	CategoryID int,
	DeveloperID int,
	foreign key (CategoryID) references Category (CategoryID),
	foreign key (DeveloperID) references Developer (DeveloperID)
);

create table User
(
	UserID int primary key auto_increment,
	FirstName varchar(100),
	LastName varchar(100),
	EmailAddress varchar(100),
	Password varchar(50),
	DateAdded timestamp,
	IsEnable bool
);

create table Review
(
	ReviewID int primary key auto_increment,
	Title varchar(200),
	Text varchar(500),
	Rating int,
	IsEnable bool,
	Hits int,
	DateAdded timestamp,
	ScriptID int,
	UserID int,
	AdminID int,
	foreign key (ScriptID) references Script (ScriptID),
	foreign key (UserID) references User (UserID),
	foreign key (AdminID) references Admin (AdminID)

);

create table Editor
(
	EditorID int primary key auto_increment,
	FirstName varchar(50),
	LastName varchar(50),
	SmallIntro varchar(500),
	Bio varchar(200),
	EmailAddress varchar(100),
	URL varchar(100),
	Picture varchar(100),
	IsEnable bool,
	IsTutorialWriter bool,
	IsArticleWriter bool
);

create table Article
(
	ArticleID int primary key auto_increment,
	Title varchar(100),
	SEOTitle varchar(200),
	SEODescription varchar(500),
	SEOKeywords varchar(200),
	ArticleText varchar(1000),
	Views int,
	Downloads int,
	DateAdded timestamp,
	ShortDescription varchar(200),
	IsEnable bool,
	CategoryID int,
	EditorID int,
	foreign key (CategoryID) references Category (CategoryID),
	foreign key (EditorID) references Editor (EditorID)
	
);

create table Tutorial
(

	TutorialID int primary key auto_increment,
	Title varchar(200),
	SEODescription Varchar(500),
	SEOKeywords varchar(200),
	TutorialText varchar(200),
	Views int,
	Downloads int,
	DateAdded timestamp,
	ShortDescription varchar(500),
	ScriptID int,
	CategoryID int, 
	EditorID int,
	foreign key (ScriptID) references Script (ScriptID),
	foreign key (CategoryID) references Category (CategoryID),
	foreign key (EditorID) references Editor (EditorID)
);

create table Reason
(
	ReasonID int primary key auto_increment,
	DateAdded timestamp,
	ScriptID int,
	DeveloperID int,
	ReviewID int,
	BookID int,
	ESoftwareID int,
	ECommunityID int,
	EMagazineID int,
	EWebSiteID int,
	UserID int,
	AdminID int,
	ArticleID int,
	EditorID int,
	foreign key ( ScriptID ) references Script ( ScriptID ),
	foreign key ( DeveloperID ) references Developer ( DeveloperID ),
	foreign key ( ReviewID) references Review ( ReviewID ),
	foreign key ( BookID ) references Book ( BookID ),
	foreign key ( ESoftwareID ) references ESoftware ( ESoftwareID ),
	foreign key ( ECommunityID ) references ECommunity ( ECommunityID ),
	foreign key ( EMagazineID ) references EMagazine ( EMagazineID ),
	foreign key ( EWebSiteID ) references EWebSite ( EWebSiteID ),
	foreign key ( UserID ) references User ( UserID ),
	foreign key ( AdminID ) references Admin ( AdminID ),
	foreign key ( ArticleID ) references Article ( ArticleID ),
	foreign key ( EditorID ) references Editor ( EditorID )	
);