Theme sql

gistfile1.sql

CREATE TABLE Theme (
    ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	name varchar(255) NULL,
	active bit NOT NULL,
	dateAdded datetime NOT NULL
)
GO

CREATE TABLE ThemeFileType (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	name varchar(100) NOT NULL,
	extension varchar(10) NOT NULL
)
GO

CREATE TABLE ThemeFile (
	ID int IDENTITY(1,1) PRIMARY KEY NOT NULL,
	themeID int NOT NULL FOREIGN KEY REFERENCES Theme(ID),
	ThemeFileTypeID int NOT NULL FOREIGN KEY REFERENCES ThemeFileType(ID),
	moduleID int NOT NULL FOREIGN KEY REFERENCES Modules(id),
	filePath varchar(255) NOT NULL,
	renderOrder int NOT NULL,
)
GO