StevenJW-University/Y2S1-Database_Design
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
master
Y2S1-Database_Design/SQL/create_generated.sql
StevenJW c0d3f8b07a Upload project.
2020-06-07 22:29:59 +01:00

556 lines
37 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

USE [master]
GO
/****** Object: Database [MediaLibrary] Script Date: 14/12/2018 00:13:31 ******/
CREATE DATABASE [MediaLibrary]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'MediaLibrary', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\MediaLibrary.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'MediaLibrary_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\MediaLibrary_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [MediaLibrary] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [MediaLibrary].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [MediaLibrary] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [MediaLibrary] SET ANSI_NULLS OFF
GO
ALTER DATABASE [MediaLibrary] SET ANSI_PADDING OFF
GO
ALTER DATABASE [MediaLibrary] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [MediaLibrary] SET ARITHABORT OFF
GO
ALTER DATABASE [MediaLibrary] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [MediaLibrary] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [MediaLibrary] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [MediaLibrary] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [MediaLibrary] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [MediaLibrary] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [MediaLibrary] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [MediaLibrary] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [MediaLibrary] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [MediaLibrary] SET DISABLE_BROKER
GO
ALTER DATABASE [MediaLibrary] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [MediaLibrary] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [MediaLibrary] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [MediaLibrary] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [MediaLibrary] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [MediaLibrary] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [MediaLibrary] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [MediaLibrary] SET RECOVERY SIMPLE
GO
ALTER DATABASE [MediaLibrary] SET MULTI_USER
GO
ALTER DATABASE [MediaLibrary] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [MediaLibrary] SET DB_CHAINING OFF
GO
ALTER DATABASE [MediaLibrary] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [MediaLibrary] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [MediaLibrary] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [MediaLibrary] SET QUERY_STORE = OFF
GO
USE [MediaLibrary]
GO
ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY;
GO
USE [MediaLibrary]
GO
/****** Object: Table [dbo].[AiredTypes] Script Date: 14/12/2018 00:13:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AiredTypes](
[AiredTypeID] [int] IDENTITY(1,1) NOT NULL,
[AiredType] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[AiredTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AudioEntry] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioEntry](
[AudioID] [int] IDENTITY(1,1) NOT NULL,
[EntryID] [int] NOT NULL,
[FileTypeID] [int] NOT NULL,
[ReleaseTypeID] [int] NOT NULL,
[AudioLength] [int] NOT NULL,
[BitRate] [int] NOT NULL,
[AudioFileName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[AudioID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AudioFileTypes] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioFileTypes](
[FileTypeID] [int] IDENTITY(1,1) NOT NULL,
[TypeName] [varchar](255) NOT NULL,
[TypeExtention] [varchar](10) NOT NULL,
PRIMARY KEY CLUSTERED
(
[FileTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AudioGenre] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioGenre](
[GenreID] [int] IDENTITY(1,1) NOT NULL,
[GenreName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[GenreID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AudioGenreEntry] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioGenreEntry](
[GenreEntryID] [int] IDENTITY(1,1) NOT NULL,
[AudioID] [int] NOT NULL,
[GenreID] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[GenreEntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AudioPreview] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AudioPreview](
[PreviewID] [int] IDENTITY(1,1) NOT NULL,
[AudioID] [int] NOT NULL,
[FileTypeID] [int] NOT NULL,
[AudioLength] [int] NOT NULL,
[BitRate] [int] NOT NULL,
[AudioFileName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[PreviewID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Category] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
[CategoryID] [int] IDENTITY(1,1) NOT NULL,
[CategoryName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[CategoryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Comment] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Comment](
[CommentID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[PageID] [int] NOT NULL,
[Content] [text] NOT NULL,
[ParentComment] [int] NULL,
PRIMARY KEY CLUSTERED
(
[CommentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[ContentPage] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ContentPage](
[PageID] [int] IDENTITY(1,1) NOT NULL,
[EntryID] [int] NOT NULL,
[Likes] [int] NOT NULL,
[Dislikes] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[PageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ImageEntry] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ImageEntry](
[ImageID] [int] IDENTITY(1,1) NOT NULL,
[EntryID] [int] NOT NULL,
[FileTypeID] [int] NOT NULL,
[ImageFileName] [varchar](255) NOT NULL,
[Height] [int] NOT NULL,
[Width] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ImageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ImageFileTypes] Script Date: 14/12/2018 00:13:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ImageFileTypes](
[FileTypeID] [int] IDENTITY(1,1) NOT NULL,
[FileTypeName] [varchar](255) NOT NULL,
[FileTypeExtension] [varchar](10) NOT NULL,
PRIMARY KEY CLUSTERED
(
[FileTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[MediaEntry] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MediaEntry](
[EntryID] [int] IDENTITY(1,1) NOT NULL,
[CategoryID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[ProductionID] [int] NULL,
[Title] [varchar](255) NOT NULL,
[EntryDescription] [text] NULL,
[UploadDate] [datetime] NOT NULL,
[Premium] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[EntryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Production] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Production](
[ProductionID] [int] IDENTITY(1,1) NOT NULL,
[ProductionName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[ProductionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ProfilePicture] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfilePicture](
[PictureID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[PictureFileName] [varchar](255) NOT NULL,
[Height] [int] NOT NULL,
[Width] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[PictureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ReleaseType] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReleaseType](
[ReleaseTypeID] [int] IDENTITY(1,1) NOT NULL,
[TypeName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[ReleaseTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[RoleAllocation] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RoleAllocation](
[RoleAllocationID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[RoleID] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[RoleAllocationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Roles] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Roles](
[RoleID] [int] IDENTITY(1,1) NOT NULL,
[RoleName] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[RoleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Thumbnail] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Thumbnail](
[ThumbnailID] [int] IDENTITY(1,1) NOT NULL,
[EntryID] [int] NOT NULL,
[ThumbnailFileName] [varchar](255) NOT NULL,
[Height] [int] NOT NULL,
[Width] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[ThumbnailID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Users] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [varchar](25) NOT NULL,
[LikeCount] [int] NOT NULL,
[UserDescription] [text] NULL,
PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[VideoEncode] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoEncode](
[EncodeID] [int] IDENTITY(1,1) NOT NULL,
[EncodeName] [varchar](255) NOT NULL,
[Width] [int] NOT NULL,
[Height] [int] NOT NULL,
[Framerate] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[EncodeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[VideoEntry] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoEntry](
[VideoID] [int] IDENTITY(1,1) NOT NULL,
[EntryID] [int] NOT NULL,
[EncodeID] [int] NOT NULL,
[FileTypeID] [int] NOT NULL,
[AiredTypeID] [int] NULL,
[VideoFileName] [varchar](255) NOT NULL,
[AiredOn] [datetime] NULL,
[Length] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[VideoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[VideoFileTypes] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoFileTypes](
[FileTypeID] [int] IDENTITY(1,1) NOT NULL,
[TypeName] [varchar](255) NOT NULL,
[TypeExtension] [varchar](10) NOT NULL,
[Codec] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED
(
[FileTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[VideoPreview] Script Date: 14/12/2018 00:13:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[VideoPreview](
[PreviewID] [int] IDENTITY(1,1) NOT NULL,
[VideoID] [int] NOT NULL,
[EncodeID] [int] NOT NULL,
[FileTypeID] [int] NOT NULL,
[VideoFileName] [varchar](255) NOT NULL,
[AiredOn] [datetime] NULL,
[Length] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[PreviewID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AudioEntry] WITH CHECK ADD FOREIGN KEY([EntryID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
ALTER TABLE [dbo].[AudioEntry] WITH CHECK ADD FOREIGN KEY([FileTypeID])
REFERENCES [dbo].[AudioFileTypes] ([FileTypeID])
GO
ALTER TABLE [dbo].[AudioEntry] WITH CHECK ADD FOREIGN KEY([ReleaseTypeID])
REFERENCES [dbo].[ReleaseType] ([ReleaseTypeID])
GO
ALTER TABLE [dbo].[AudioGenreEntry] WITH CHECK ADD FOREIGN KEY([AudioID])
REFERENCES [dbo].[AudioEntry] ([AudioID])
GO
ALTER TABLE [dbo].[AudioGenreEntry] WITH CHECK ADD FOREIGN KEY([GenreID])
REFERENCES [dbo].[AudioGenre] ([GenreID])
GO
ALTER TABLE [dbo].[AudioPreview] WITH CHECK ADD FOREIGN KEY([AudioID])
REFERENCES [dbo].[AudioEntry] ([AudioID])
GO
ALTER TABLE [dbo].[AudioPreview] WITH CHECK ADD FOREIGN KEY([FileTypeID])
REFERENCES [dbo].[AudioFileTypes] ([FileTypeID])
GO
ALTER TABLE [dbo].[Comment] WITH CHECK ADD FOREIGN KEY([PageID])
REFERENCES [dbo].[ContentPage] ([PageID])
GO
ALTER TABLE [dbo].[Comment] WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[ContentPage] WITH CHECK ADD FOREIGN KEY([EntryID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
ALTER TABLE [dbo].[ImageEntry] WITH CHECK ADD FOREIGN KEY([EntryID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
ALTER TABLE [dbo].[ImageEntry] WITH CHECK ADD FOREIGN KEY([FileTypeID])
REFERENCES [dbo].[ImageFileTypes] ([FileTypeID])
GO
ALTER TABLE [dbo].[MediaEntry] WITH CHECK ADD FOREIGN KEY([CategoryID])
REFERENCES [dbo].[Category] ([CategoryID])
GO
ALTER TABLE [dbo].[MediaEntry] WITH CHECK ADD FOREIGN KEY([ProductionID])
REFERENCES [dbo].[Production] ([ProductionID])
GO
ALTER TABLE [dbo].[MediaEntry] WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[ProfilePicture] WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[RoleAllocation] WITH CHECK ADD FOREIGN KEY([RoleID])
REFERENCES [dbo].[Roles] ([RoleID])
GO
ALTER TABLE [dbo].[RoleAllocation] WITH CHECK ADD FOREIGN KEY([UserID])
REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Thumbnail] WITH CHECK ADD FOREIGN KEY([EntryID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
ALTER TABLE [dbo].[VideoEntry] WITH CHECK ADD FOREIGN KEY([AiredTypeID])
REFERENCES [dbo].[AiredTypes] ([AiredTypeID])
GO
ALTER TABLE [dbo].[VideoEntry] WITH CHECK ADD FOREIGN KEY([EncodeID])
REFERENCES [dbo].[VideoEncode] ([EncodeID])
GO
ALTER TABLE [dbo].[VideoEntry] WITH CHECK ADD FOREIGN KEY([EntryID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
ALTER TABLE [dbo].[VideoEntry] WITH CHECK ADD FOREIGN KEY([FileTypeID])
REFERENCES [dbo].[VideoFileTypes] ([FileTypeID])
GO
ALTER TABLE [dbo].[VideoPreview] WITH CHECK ADD FOREIGN KEY([EncodeID])
REFERENCES [dbo].[VideoEncode] ([EncodeID])
GO
ALTER TABLE [dbo].[VideoPreview] WITH CHECK ADD FOREIGN KEY([FileTypeID])
REFERENCES [dbo].[VideoFileTypes] ([FileTypeID])
GO
ALTER TABLE [dbo].[VideoPreview] WITH CHECK ADD FOREIGN KEY([VideoID])
REFERENCES [dbo].[MediaEntry] ([EntryID])
GO
USE [master]
GO
ALTER DATABASE [MediaLibrary] SET READ_WRITE
GO
Reference in New Issue View Git Blame Copy Permalink