USE [VocaloidSite] GO /****** Object: Schema [mikubot] Script Date: 13.1.2015 20:28:17 ******/ CREATE SCHEMA [mikubot] GO /****** Object: Schema [mikudb] Script Date: 13.1.2015 20:28:17 ******/ CREATE SCHEMA [mikudb] GO /****** Object: Schema [voter] Script Date: 13.1.2015 20:28:17 ******/ CREATE SCHEMA [voter] GO /****** Object: Table [dbo].[ActivityEntries] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ActivityEntries]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [CreateDate] [datetime] NOT NULL, [EditEvent] [varchar](20) NOT NULL, [EntryType] [varchar](20) NOT NULL, [Album] [int] NULL, [Artist] [int] NULL, [Song] [int] NULL, CONSTRAINT [PK_ActivityEntries] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlbumComments] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumComments]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Author] [int] NULL, [AuthorName] [nvarchar](100) NOT NULL, [Created] [datetime] NOT NULL, [Message] [nvarchar](800) NOT NULL, CONSTRAINT [PK_AlbumComments] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumHits] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumHits]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Agent] [int] NOT NULL, [Date] [datetime] NOT NULL CONSTRAINT [DF_AlbumHits_Date] DEFAULT (getdate()), CONSTRAINT [PK_AlbumHits] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumIdentifiers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AlbumIdentifiers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Type] [varchar](30) NOT NULL CONSTRAINT [DF_AlbumIdentifiers_Type] DEFAULT ('Barcode'), [Value] [nvarchar](50) NOT NULL, CONSTRAINT [PK_AlbumIdentifiers] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlbumMergeRecords] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumMergeRecords]( [Id] [int] IDENTITY(1,1) NOT NULL, [Source] [int] NOT NULL, [Target] [int] NOT NULL, CONSTRAINT [PK_AlbumMergeRecords] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumNames] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumNames]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Language] [nvarchar](16) NOT NULL, [Value] [nvarchar](255) NOT NULL, CONSTRAINT [PK_AlbumNames] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumPictureFiles] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumPictureFiles]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Author] [int] NOT NULL, [Created] [datetime] NOT NULL, [Mime] [nvarchar](32) NOT NULL, [Name] [nvarchar](200) NOT NULL, CONSTRAINT [PK_ArtistPictureFiles] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumReleaseEvents] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumReleaseEvents]( [Id] [int] IDENTITY(1,1) NOT NULL, [Date] [datetime] NULL, [Description] [nvarchar](400) NOT NULL, [Name] [nvarchar](50) NOT NULL, [Series] [int] NULL, [SeriesNumber] [int] NOT NULL CONSTRAINT [DF_AlbumReleaseEvents_SeriesNumber] DEFAULT ((0)), [SeriesSuffix] [nvarchar](50) NOT NULL CONSTRAINT [DF_AlbumReleaseEvents_SeriesSuffix] DEFAULT (''), CONSTRAINT [PK_AlbumReleaseEvents] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumReleaseEventSeries] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumReleaseEventSeries]( [Id] [int] IDENTITY(1,1) NOT NULL, [Description] [nvarchar](400) NOT NULL, [Name] [nvarchar](50) NOT NULL, CONSTRAINT [PK_AlbumReleaseEventSeries] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumReleaseEventSeriesAliases] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumReleaseEventSeriesAliases]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NOT NULL, [Series] [int] NOT NULL, CONSTRAINT [PK_AlbumReleaseEventSeriesAliases] PRIMARY KEY CLUSTERED ( [Id] 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].[Albums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Albums]( [Id] [int] IDENTITY(1,1) NOT NULL, [AdditionalNamesString] [nvarchar](1024) NOT NULL CONSTRAINT [DF_Albums_AdditionalNamesString] DEFAULT (''), [ArtistString] [nvarchar](500) NOT NULL CONSTRAINT [DF_Albums_ArtistString] DEFAULT (''), [ArtistStringDefault] [nvarchar](500) NOT NULL CONSTRAINT [DF_Albums_ArtistStringDefault] DEFAULT (''), [ArtistStringEnglish] [nvarchar](500) NOT NULL CONSTRAINT [DF_Albums_ArtistStringEnglish] DEFAULT (''), [ArtistStringRomaji] [nvarchar](500) NOT NULL CONSTRAINT [DF_Albums_ArtistStringRomaji] DEFAULT (''), [CoverPicture] [int] NULL, [CoverPictureBytes] [varbinary](max) NULL, [CoverPictureMime] [nvarchar](32) NULL, [CoverPictureThumb250Bytes] [varbinary](max) NULL, [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Albums_CreateDate] DEFAULT (getdate()), [Deleted] [bit] NOT NULL CONSTRAINT [DF_Albums_Deleted] DEFAULT ('False'), [DefaultNameLanguage] [nvarchar](32) NOT NULL, [Description] [nvarchar](max) NOT NULL CONSTRAINT [DF_Albums_Description] DEFAULT (''), [EnglishName] [nvarchar](255) NULL, [JapaneseName] [nvarchar](255) NOT NULL, [RatingAverage] [int] NOT NULL CONSTRAINT [DF_Albums_RatingAverage] DEFAULT ((0)), [RatingCount] [int] NOT NULL CONSTRAINT [DF_Albums_RatingCount] DEFAULT ((0)), [RatingTotal] [int] NOT NULL CONSTRAINT [DF_Albums_RatingTotal] DEFAULT ((0)), [ReleaseCatNum] [nvarchar](50) NULL CONSTRAINT [DF_Albums_ProductCode] DEFAULT (''), [ReleaseDay] [int] NULL, [ReleaseEventName] [nvarchar](50) NULL, [ReleaseMonth] [int] NULL, [ReleaseYear] [int] NULL, [RomajiName] [nvarchar](255) NULL, [Status] [varchar](10) NOT NULL CONSTRAINT [DF_Albums_Status] DEFAULT ('Draft'), [Type] [nvarchar](32) NOT NULL CONSTRAINT [DF_Albums_Type] DEFAULT ('Album'), [Version] [int] NOT NULL CONSTRAINT [DF_Albums_Version] DEFAULT ((0)), [Barcode] [nvarchar](30) NULL, CONSTRAINT [PK_Albums] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlbumsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AlbumsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [MediaType] [nvarchar](50) NOT NULL CONSTRAINT [DF_AlbumsForUsers_MediaType] DEFAULT ('Other'), [PurchaseStatus] [varchar](30) NOT NULL CONSTRAINT [DF_AlbumsForUsers_PurchaseStatus] DEFAULT ('Owned'), [Rating] [int] NOT NULL CONSTRAINT [DF_AlbumsForUsers_Rating] DEFAULT ((0)), [User] [int] NOT NULL, CONSTRAINT [PK_AlbumsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlbumTagUsages] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumTagUsages]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Count] [int] NOT NULL, [Tag] [nvarchar](30) NOT NULL, CONSTRAINT [PK_AlbumTagUses] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumTagVotes] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlbumTagVotes]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Usage] [bigint] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_AlbumTagVotes] PRIMARY KEY CLUSTERED ( [Id] 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].[AlbumWebLinks] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AlbumWebLinks]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Category] [varchar](20) NOT NULL CONSTRAINT [DF_AlbumWebLinks_Category] DEFAULT ('Other'), [Description] [nvarchar](512) NOT NULL, [Url] [nvarchar](512) NOT NULL, CONSTRAINT [PK_AlbumWebLinks] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedAlbumVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedAlbumVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [AgentName] [nvarchar](100) NOT NULL, [Album] [int] NOT NULL, [Author] [int] NULL, [ChangedFields] [varchar](100) NOT NULL CONSTRAINT [DF_ArchivedAlbumVersions_ChangedFields] DEFAULT (''), [CoverPictureBytes] [varbinary](max) NULL, [CoverPictureMime] [nvarchar](32) NULL, [Created] [datetime] NOT NULL, [Data] [xml] NULL, [IsSnapshot] [bit] NOT NULL CONSTRAINT [DF_ArchivedAlbumVersions_IsSnapshot] DEFAULT ('True'), [Notes] [nvarchar](200) NOT NULL CONSTRAINT [DF_ArchivedAlbumVersions_Notes] DEFAULT (''), [Reason] [varchar](30) NOT NULL CONSTRAINT [DF_ArchivedAlbumVersions_Reason] DEFAULT ('Unknown'), [Status] [varchar](10) NOT NULL CONSTRAINT [DF_ArchivedAlbumVersions_Status] DEFAULT ('Draft'), [Version] [int] NOT NULL, CONSTRAINT [PK_ArchivedAlbumVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedArtistVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedArtistVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [AgentName] [nvarchar](100) NOT NULL, [Artist] [int] NOT NULL, [Author] [int] NULL, [ChangedFields] [varchar](100) NOT NULL CONSTRAINT [DF_ArchivedArtistVersions_ChangedFields] DEFAULT (''), [Created] [datetime] NOT NULL, [Data] [xml] NULL, [IsSnapshot] [bit] NOT NULL CONSTRAINT [DF_ArchivedArtistVersions_IsSnapshot] DEFAULT ('True'), [Notes] [nvarchar](200) NOT NULL CONSTRAINT [DF_ArchivedArtistVersions_Notes] DEFAULT (''), [PictureBytes] [varbinary](max) NULL, [PictureMime] [nvarchar](32) NULL, [Reason] [varchar](30) NOT NULL CONSTRAINT [DF_ArchivedArtistVersions_Reason] DEFAULT ('Unknown'), [Status] [varchar](10) NOT NULL CONSTRAINT [DF_ArchivedArtistVersions_Status] DEFAULT ('Draft'), [Version] [int] NOT NULL, CONSTRAINT [PK_ArtistVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedEventVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedEventVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [ChangedFields] [varchar](100) NOT NULL, [CommonEditEvent] [varchar](30) NOT NULL, [Created] [datetime] NOT NULL, [Date] [datetime] NULL, [Description] [nvarchar](400) NOT NULL, [Event] [int] NOT NULL, [Name] [nvarchar](50) NOT NULL, [Series] [int] NULL, [SeriesNumber] [int] NOT NULL CONSTRAINT [DF_ArchivedEventVersions_SeriesNumber] DEFAULT ((0)), CONSTRAINT [PK_ArchivedEventVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedSongListVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedSongListVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [ChangedFields] [varchar](100) NOT NULL, [CommonEditEvent] [varchar](30) NOT NULL, [Created] [datetime] NOT NULL, [SongList] [int] NOT NULL, [Status] [varchar](10) NOT NULL, CONSTRAINT [PK_ArchivedSongListVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedSongVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedSongVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [AgentName] [nvarchar](100) NOT NULL, [Author] [int] NULL, [ChangedFields] [varchar](100) NOT NULL CONSTRAINT [DF_ArchivedSongVersions_ChangedFields] DEFAULT (''), [Created] [datetime] NOT NULL, [Data] [xml] NOT NULL, [IsSnapshot] [bit] NOT NULL CONSTRAINT [DF_ArchivedSongVersions_IsSnapshot] DEFAULT ('True'), [Notes] [nvarchar](200) NOT NULL CONSTRAINT [DF_ArchivedSongVersions_Notes] DEFAULT (''), [Reason] [varchar](30) NOT NULL CONSTRAINT [DF_ArchivedSongVersions_Reason] DEFAULT ('Unknown'), [Song] [int] NOT NULL, [Status] [varchar](10) NOT NULL CONSTRAINT [DF_ArchivedSongVersions_Status] DEFAULT ('Draft'), [Version] [int] NOT NULL, CONSTRAINT [PK_ArchivedSongVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArchivedTagVersions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArchivedTagVersions]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [CategoryName] [nvarchar](30) NOT NULL, [ChangedFields] [varchar](100) NOT NULL, [CommonEditEvent] [varchar](30) NOT NULL, [Created] [datetime] NOT NULL, [Description] [nvarchar](1000) NOT NULL, [Status] [varchar](10) NOT NULL CONSTRAINT [DF_ArchivedTagVersions_Status] DEFAULT ('Finished'), [Tag] [nvarchar](30) NOT NULL, CONSTRAINT [PK_ArchivedTagVersions] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArtistComments] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistComments]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Author] [int] NOT NULL, [Created] [datetime] NOT NULL, [Message] [nvarchar](800) NOT NULL, CONSTRAINT [PK_ArtistComments] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistMergeRecords] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistMergeRecords]( [Id] [int] IDENTITY(1,1) NOT NULL, [Source] [int] NOT NULL, [Target] [int] NOT NULL, CONSTRAINT [PK_ArtistMergeRecords] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistMetadata] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistMetadata]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Type] [nvarchar](50) NOT NULL, [Value] [nvarchar](max) NOT NULL, CONSTRAINT [PK_ArtistMetadata] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistNames] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistNames]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Language] [nvarchar](16) NOT NULL, [Value] [nvarchar](255) NOT NULL, CONSTRAINT [PK_ArtistNames] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistPictureFiles] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistPictureFiles]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Author] [int] NOT NULL, [Created] [datetime] NOT NULL, [Mime] [nvarchar](32) NOT NULL, [Name] [nvarchar](200) NOT NULL, CONSTRAINT [PK_ArtistPictureFiles_1] PRIMARY KEY CLUSTERED ( [Id] 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].[Artists] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Artists]( [Id] [int] IDENTITY(1,1) NOT NULL, [AdditionalNamesString] [nvarchar](1024) NOT NULL CONSTRAINT [DF_Artists_AdditionalNamesString] DEFAULT (''), [ArtistType] [nvarchar](32) NOT NULL, [Author] [int] NULL, [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Artists_CreateDate] DEFAULT (getdate()), [DefaultNameLanguage] [nvarchar](32) NOT NULL, [Deleted] [bit] NOT NULL CONSTRAINT [DF_Artists_Deleted] DEFAULT ('False'), [Description] [nvarchar](max) NOT NULL CONSTRAINT [DF_Artists_Description] DEFAULT (''), [LastModified] [datetime] NOT NULL CONSTRAINT [DF_Artists_LastModified] DEFAULT (getdate()), [LastModifiedBy] [int] NULL, [OtherName] [nvarchar](255) NULL, [RomajiName] [nvarchar](255) NULL, [PictureBytes] [varbinary](max) NULL, [PictureMime] [nvarchar](32) NULL, [PictureThumb250Bytes] [varbinary](max) NULL, [EnglishName] [nvarchar](255) NULL, [JapaneseName] [nvarchar](255) NOT NULL, [StartDate] [datetime] NULL, [Status] [nvarchar](10) NULL, [Version] [int] NOT NULL CONSTRAINT [DF_Artists_Version] DEFAULT ((0)), [BaseVoicebank] [int] NULL, CONSTRAINT [PK_Artists] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ArtistsForAlbums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistsForAlbums]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NULL, [Album] [int] NOT NULL, [Name] [nvarchar](250) NULL, [IsSupport] [bit] NOT NULL CONSTRAINT [DF_ArtistsForAlbums_IsSupport] DEFAULT ('False'), [Roles] [int] NOT NULL CONSTRAINT [DF_ArtistsForAlbums_Roles] DEFAULT ((0)), CONSTRAINT [PK_ArtistsForAlbums] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistsForSongs] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistsForSongs]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NULL, [Name] [nvarchar](250) NULL, [Roles] [int] NOT NULL CONSTRAINT [DF_ArtistsForSongs_Roles] DEFAULT ((0)), [Song] [int] NOT NULL, [IsSupport] [bit] NOT NULL CONSTRAINT [DF_ArtistsForSongs_IsSupport] DEFAULT ('False'), CONSTRAINT [PK_ArtistsForSongs] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [EmailNotifications] [bit] NOT NULL CONSTRAINT [DF_ArtistsForUsers_EmailNotifications] DEFAULT ('False'), [SiteNotifications] [bit] NOT NULL CONSTRAINT [DF_ArtistsForUsers_SiteNotifications] DEFAULT ('True'), [User] [int] NOT NULL, CONSTRAINT [PK_ArtistsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistTagUsages] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistTagUsages]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Count] [int] NOT NULL, [Tag] [nvarchar](30) NOT NULL, CONSTRAINT [PK_ArtistTagUsages] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistTagVotes] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ArtistTagVotes]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Usage] [bigint] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_ArtistTagVotes] PRIMARY KEY CLUSTERED ( [Id] 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].[ArtistWebLinks] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ArtistWebLinks]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [Category] [varchar](20) NOT NULL CONSTRAINT [DF_ArtistWebLinks_Category] DEFAULT ('Other'), [Description] [nvarchar](512) NOT NULL, [Url] [nvarchar](512) NOT NULL, CONSTRAINT [PK_ArtistWebLinks] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AuditLogEntries] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AuditLogEntries]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Action] [nvarchar](400) NOT NULL, [AgentName] [nvarchar](100) NOT NULL, [Time] [datetime] NOT NULL CONSTRAINT [DF_AuditLog_Time] DEFAULT (getdate()), [User] [int] NULL, CONSTRAINT [PK_AuditLog] PRIMARY KEY CLUSTERED ( [Id] 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].[EntryReports] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[EntryReports]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NULL, [Artist] [int] NULL, [Created] [datetime] NOT NULL, [EntryType] [varchar](10) NOT NULL, [Hostname] [nvarchar](50) NOT NULL, [Notes] [nvarchar](400) NOT NULL, [ReportedUser] [int] NULL, [ReportType] [varchar](20) NOT NULL, [Song] [int] NULL, [User] [int] NULL, CONSTRAINT [PK_EntryReports] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[FavoriteAlbumsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FavoriteAlbumsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_FavoriteAlbumsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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].[FavoriteArtistsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FavoriteArtistsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_FavoriteArtistsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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].[FavoriteSongsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FavoriteSongsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Rating] [int] NOT NULL CONSTRAINT [DF_FavoriteSongsForUsers_Rating] DEFAULT ((5)), [Song] [int] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_FavoriteSongsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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].[GroupsForArtists] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[GroupsForArtists]( [Id] [int] IDENTITY(1,1) NOT NULL, [Group] [int] NOT NULL, [Member] [int] NOT NULL, CONSTRAINT [PK_GroupsForArtists] PRIMARY KEY CLUSTERED ( [Id] 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].[IPRules] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[IPRules]( [Id] [int] IDENTITY(1,1) NOT NULL, [Address] [varchar](40) NOT NULL, [Created] [datetime] NOT NULL CONSTRAINT [DF_IPRules_Created] DEFAULT (getdate()), [Notes] [nvarchar](100) NOT NULL CONSTRAINT [DF_IPRules_Notes] DEFAULT (''), CONSTRAINT [PK_IPRule] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[LyricsForSongs] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LyricsForSongs]( [Id] [int] IDENTITY(1,1) NOT NULL, [Language] [nvarchar](16) NOT NULL, [Song] [int] NOT NULL, [Source] [nvarchar](255) NOT NULL CONSTRAINT [DF_LyricsForSongs_Source] DEFAULT (''), [Text] [nvarchar](max) NOT NULL, CONSTRAINT [PK_LyricsForSongs] PRIMARY KEY CLUSTERED ( [Id] 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].[NewsEntries] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[NewsEntries]( [Id] [int] IDENTITY(1,1) NOT NULL, [Anonymous] [bit] NOT NULL CONSTRAINT [DF_NewsEntries_Anonymous] DEFAULT ('True'), [Author] [int] NOT NULL, [CreateDate] [datetime] NOT NULL, [Deleted] [bit] NOT NULL CONSTRAINT [DF_NewsEntries_Deleted] DEFAULT ('False'), [Important] [bit] NOT NULL CONSTRAINT [DF_NewsEntries_Important] DEFAULT ('False'), [Stickied] [bit] NOT NULL CONSTRAINT [DF_NewsEntries_Stickied] DEFAULT ('False'), [Text] [nvarchar](2000) NOT NULL, CONSTRAINT [PK_NewsEntries] PRIMARY KEY CLUSTERED ( [Id] 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].[OtherArtistsForAlbums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OtherArtistsForAlbums]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Name] [nvarchar](250) NOT NULL, [IsSupport] [bit] NOT NULL, [Roles] [int] NOT NULL, CONSTRAINT [PK_OtherArtistsForAlbums] PRIMARY KEY CLUSTERED ( [Id] 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].[OtherArtistsForSongs] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OtherArtistsForSongs]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](250) NOT NULL, [IsSupport] [bit] NOT NULL, [Roles] [int] NOT NULL, [Song] [int] NOT NULL, CONSTRAINT [PK_OtherArtistsForSongs] PRIMARY KEY CLUSTERED ( [Id] 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].[OwnedArtistsForUsers] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OwnedArtistsForUsers]( [Id] [int] IDENTITY(1,1) NOT NULL, [Artist] [int] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_OwnedArtistsForUsers] PRIMARY KEY CLUSTERED ( [Id] 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].[PasswordResetRequests] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PasswordResetRequests]( [Id] [uniqueidentifier] NOT NULL, [Created] [datetime] NOT NULL CONSTRAINT [DF_PasswordResetRequests_Created] DEFAULT (getdate()), [Email] [nvarchar](50) NOT NULL CONSTRAINT [DF_PasswordResetRequests_Email] DEFAULT (''), [User] [int] NOT NULL, CONSTRAINT [PK_PasswordResetRequests] PRIMARY KEY CLUSTERED ( [Id] 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].[PVsForAlbums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PVsForAlbums]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [Author] [nvarchar](100) NOT NULL CONSTRAINT [DF_PVsForAlbums_Author] DEFAULT (''), [Name] [nvarchar](200) NOT NULL CONSTRAINT [DF_PVsForAlbums_Name] DEFAULT (''), [PVId] [nvarchar](100) NOT NULL, [PVType] [nvarchar](20) NOT NULL, [Service] [nvarchar](20) NOT NULL, CONSTRAINT [PK_PVsForAlbums] PRIMARY KEY CLUSTERED ( [Id] 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].[PVsForSongs] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PVsForSongs]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [nvarchar](100) NOT NULL CONSTRAINT [DF_PVsForSongs_Author] DEFAULT (''), [Length] [int] NOT NULL CONSTRAINT [DF_PVsForSongs_Length] DEFAULT ((0)), [Name] [nvarchar](200) NOT NULL, [PVId] [nvarchar](255) NOT NULL, [PVType] [nvarchar](20) NULL, [Service] [nvarchar](20) NOT NULL, [Song] [int] NOT NULL, [ThumbUrl] [nvarchar](255) NOT NULL CONSTRAINT [DF_PVsForSongs_ThumbUrl] DEFAULT (''), CONSTRAINT [PK_PVsForSongs] PRIMARY KEY CLUSTERED ( [Id] 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].[SongComments] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongComments]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [Created] [datetime] NOT NULL, [Message] [nvarchar](800) NOT NULL, [Song] [int] NOT NULL, CONSTRAINT [PK_SongComments] PRIMARY KEY CLUSTERED ( [Id] 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].[SongHits] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongHits]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Agent] [int] NOT NULL, [Song] [int] NOT NULL, [Date] [datetime] NOT NULL CONSTRAINT [DF_SongHits_Date] DEFAULT (getdate()), CONSTRAINT [PK_SongHits] PRIMARY KEY CLUSTERED ( [Id] 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].[SongLists] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SongLists]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [Description] [nvarchar](2000) NOT NULL, [FeaturedCategory] [varchar](20) NOT NULL CONSTRAINT [DF_SongLists_FeaturedCategory] DEFAULT ('Nothing'), [Name] [nvarchar](200) NOT NULL, [ThumbMime] [varchar](30) NULL, CONSTRAINT [PK_SongLists] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SongMergeRecords] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongMergeRecords]( [Id] [int] IDENTITY(1,1) NOT NULL, [Source] [int] NOT NULL, [Target] [int] NOT NULL, CONSTRAINT [PK_SongMergeRecords] PRIMARY KEY CLUSTERED ( [Id] 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].[SongMetadata] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongMetadata]( [Id] [int] IDENTITY(1,1) NOT NULL, [Song] [int] NOT NULL, [Type] [nvarchar](50) NOT NULL, [Value] [nvarchar](max) NOT NULL, CONSTRAINT [PK_SongMetadata] PRIMARY KEY CLUSTERED ( [Id] 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].[SongNames] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongNames]( [Id] [int] IDENTITY(1,1) NOT NULL, [Song] [int] NOT NULL, [Language] [nvarchar](16) NOT NULL, [Value] [nvarchar](255) NOT NULL, CONSTRAINT [PK_SongNames] PRIMARY KEY CLUSTERED ( [Id] 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].[Songs] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Songs]( [Id] [int] IDENTITY(1,1) NOT NULL, [AdditionalNamesString] [nvarchar](1024) NOT NULL CONSTRAINT [DF_Songs_AdditionalNamesString] DEFAULT (''), [ArtistString] [nvarchar](500) NOT NULL CONSTRAINT [DF_Songs_ArtistString] DEFAULT (''), [ArtistStringDefault] [nvarchar](500) NOT NULL CONSTRAINT [DF_Songs_ArtistStringDefault] DEFAULT (''), [ArtistStringEnglish] [nvarchar](500) NOT NULL CONSTRAINT [DF_Songs_ArtistStringEnglish] DEFAULT (''), [ArtistStringRomaji] [nvarchar](500) NOT NULL CONSTRAINT [DF_Songs_ArtistStringRomaji] DEFAULT (''), [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Songs_CreateDate] DEFAULT (getdate()), [DefaultNameLanguage] [nvarchar](20) NOT NULL CONSTRAINT [DF_Songs_DefaultNameLanguage] DEFAULT ('Japanese'), [Deleted] [bit] NOT NULL CONSTRAINT [DF_Songs_Deleted] DEFAULT ('False'), [EnglishName] [nvarchar](255) NULL, [FavoritedTimes] [int] NOT NULL CONSTRAINT [DF_Songs_FavoritedTimes] DEFAULT ((0)), [JapaneseName] [nvarchar](255) NOT NULL, [LengthSeconds] [int] NOT NULL CONSTRAINT [DF_Songs_LengthSeconds] DEFAULT ((0)), [NicoId] [nvarchar](20) NULL, [Notes] [nvarchar](800) NOT NULL CONSTRAINT [DF_Songs_Notes] DEFAULT (''), [OriginalName] [nvarchar](255) NOT NULL CONSTRAINT [DF_Songs_OriginalName] DEFAULT (''), [OriginalVersion] [int] NULL, [PVServices] [int] NOT NULL CONSTRAINT [DF_Songs_PVServices] DEFAULT ((0)), [RatingScore] [int] NOT NULL CONSTRAINT [DF_Songs_RatingScore] DEFAULT ((0)), [RomajiName] [nvarchar](255) NULL, [SongType] [nvarchar](20) NOT NULL CONSTRAINT [DF_Songs_SongType] DEFAULT ('Original'), [Status] [int] NOT NULL CONSTRAINT [DF_Songs_Status] DEFAULT ((0)), [ThumbBytes] [varbinary](max) NULL, [ThumbMime] [nvarchar](32) NULL, [Version] [int] NOT NULL CONSTRAINT [DF_Songs_Version] DEFAULT ((0)), CONSTRAINT [PK_Songs] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SongsInAlbums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongsInAlbums]( [Id] [int] IDENTITY(1,1) NOT NULL, [Album] [int] NOT NULL, [DiscNumber] [int] NOT NULL CONSTRAINT [DF_SongsInAlbums_DiscNumber] DEFAULT ((1)), [Name] [nvarchar](250) NULL, [Song] [int] NOT NULL, [TrackNumber] [int] NOT NULL, CONSTRAINT [PK_AlbumsForSongs] PRIMARY KEY CLUSTERED ( [Id] 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].[SongsInLists] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongsInLists]( [Id] [int] IDENTITY(1,1) NOT NULL, [List] [int] NOT NULL, [Notes] [nvarchar](200) NOT NULL CONSTRAINT [DF_SongsInLists_Notes] DEFAULT (''), [Order] [int] NOT NULL, [Song] [int] NOT NULL, CONSTRAINT [PK_SongsInLists] PRIMARY KEY CLUSTERED ( [Id] 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].[SongsInPoll] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongsInPoll]( [Id] [int] IDENTITY(1,1) NOT NULL, [Poll] [int] NOT NULL, [Song] [int] NOT NULL, [SortIndex] [int] NOT NULL CONSTRAINT [DF_SongsInPoll_Placement] DEFAULT ((0)), [VoteCount] [int] NOT NULL CONSTRAINT [DF_SongsInPoll_VoteCount] DEFAULT ((0)), CONSTRAINT [PK_SongInPoll] PRIMARY KEY CLUSTERED ( [Id] 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].[SongTagUsages] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongTagUsages]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Count] [int] NOT NULL, [Song] [int] NOT NULL, [Tag] [nvarchar](30) NOT NULL, CONSTRAINT [PK_SongTagUsages] PRIMARY KEY CLUSTERED ( [Id] 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].[SongTagVotes] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SongTagVotes]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Usage] [bigint] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_SongTagVotes] PRIMARY KEY CLUSTERED ( [Id] 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].[SongWebLinks] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SongWebLinks]( [Id] [int] IDENTITY(1,1) NOT NULL, [Category] [varchar](20) NOT NULL CONSTRAINT [DF_SongWebLinks_Category] DEFAULT ('Other'), [Description] [nvarchar](512) NOT NULL, [Song] [int] NOT NULL, [Url] [nvarchar](512) NOT NULL, CONSTRAINT [PK_SongWebLinks] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Tags] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Tags]( [Name] [nvarchar](30) NOT NULL, [Id] [int] IDENTITY(1,1) NOT NULL, [AliasedTo] [nvarchar](30) NULL, [CategoryName] [nvarchar](30) NOT NULL CONSTRAINT [DF_Tags_CategoryName] DEFAULT (''), [Description] [nvarchar](1000) NOT NULL CONSTRAINT [DF_Tags_Description] DEFAULT (''), [Parent] [nvarchar](30) NULL, [Status] [int] NOT NULL CONSTRAINT [DF_Tags_Status] DEFAULT ((1)), [ThumbMime] [varchar](30) NULL, CONSTRAINT [PK_Tags] PRIMARY KEY CLUSTERED ( [Name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Tags] UNIQUE NONCLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[TrashedEntries] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[TrashedEntries]( [Id] [int] IDENTITY(1,1) NOT NULL, [Created] [datetime] NOT NULL, [Data] [xml] NOT NULL, [EntryType] [varchar](20) NOT NULL, [Name] [nvarchar](255) NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_TrashedEntries] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[UserAdditionalPermissions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserAdditionalPermissions]( [PermissionId] [uniqueidentifier] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_UserAdditionalPermissions] PRIMARY KEY CLUSTERED ( [PermissionId] ASC, [User] 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].[UserComments] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserComments]( [Id] [int] IDENTITY(1,1) NOT NULL, [Author] [int] NOT NULL, [Created] [datetime] NOT NULL, [Message] [nvarchar](800) NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_UserComments] PRIMARY KEY CLUSTERED ( [Id] 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].[UserMessages] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserMessages]( [Id] [int] IDENTITY(1,1) NOT NULL, [Created] [datetime] NOT NULL, [Message] [nvarchar](max) NOT NULL, [Read] [bit] NOT NULL, [Receiver] [int] NOT NULL, [Sender] [int] NULL, [Subject] [nvarchar](200) NOT NULL, CONSTRAINT [PK_UserMessages] PRIMARY KEY CLUSTERED ( [Id] 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].[UserOptions] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserOptions]( [Id] [int] IDENTITY(1,1) NOT NULL, [AboutMe] [nvarchar](max) NOT NULL CONSTRAINT [DF_UserOptions_AboutMe] DEFAULT (''), [AlbumFormatString] [nvarchar](200) NOT NULL CONSTRAINT [DF_UserOptions_AlbumFormatString] DEFAULT (''), [EmailVerified] [bit] NOT NULL CONSTRAINT [DF_UserOptions_EmailVerified] DEFAULT ('False'), [LastLoginAddress] [nvarchar](20) NOT NULL CONSTRAINT [DF_UserOptions_LastLoginAddress] DEFAULT (''), [Location] [nvarchar](50) NOT NULL CONSTRAINT [DF_UserOptions_Location] DEFAULT (''), [Poisoned] [bit] NOT NULL CONSTRAINT [DF_UserOptions_Poisoned] DEFAULT ('False'), [PublicAlbumCollection] [bit] NOT NULL CONSTRAINT [DF_UserOptions_PublicAlbumCollection] DEFAULT ((1)), [PublicRatings] [bit] NOT NULL CONSTRAINT [DF_UserOptions_PublicRatings] DEFAULT ('true'), [TwitterId] [int] NOT NULL CONSTRAINT [DF_UserOptions_TwitterId] DEFAULT ((0)), [TwitterName] [nvarchar](200) NOT NULL CONSTRAINT [DF_UserOptions_TwitterName] DEFAULT (''), [TwitterOAuthToken] [nvarchar](70) NOT NULL CONSTRAINT [DF_UserOptions_OAuthToken] DEFAULT (''), [TwitterOAuthTokenSecret] [nvarchar](70) NOT NULL CONSTRAINT [DF_UserOptions_OAuthTokenSecret] DEFAULT (''), [User] [int] NOT NULL, CONSTRAINT [PK_UserOptions] PRIMARY KEY CLUSTERED ( [Id] 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].[Users] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Users]( [Id] [int] IDENTITY(1,1) NOT NULL, [AccessKey] [nvarchar](20) NOT NULL CONSTRAINT [DF_Users_AccessKey] DEFAULT (''), [Active] [bit] NOT NULL CONSTRAINT [DF_Users_Active] DEFAULT ('True'), [AnonymousActivity] [bit] NOT NULL CONSTRAINT [DF_Users_AnonymousActivity] DEFAULT ('False'), [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Users_CreateDate] DEFAULT (getdate()), [Culture] [varchar](5) NOT NULL CONSTRAINT [DF_Users_Culture] DEFAULT (''), [DefaultLanguageSelection] [nvarchar](32) NOT NULL CONSTRAINT [DF_Users_DefaultNameLanguage] DEFAULT ('Romaji'), [Email] [nvarchar](50) NOT NULL, [EmailOptions] [int] NOT NULL CONSTRAINT [DF_Users_EmailOptions] DEFAULT ((2)), [Language] [nvarchar](5) NOT NULL CONSTRAINT [DF_Users_Language] DEFAULT (''), [LastLogin] [datetime] NOT NULL CONSTRAINT [DF_Users_LastLogin] DEFAULT (getdate()), [Name] [nvarchar](100) NOT NULL CONSTRAINT [DF_Users_DisplayName] DEFAULT (''), [NameLC] [nvarchar](100) NOT NULL, [Roles] [int] NOT NULL CONSTRAINT [DF_Users_Roles] DEFAULT ((0)), [Password] [nvarchar](50) NOT NULL, [PermissionFlags] [int] NULL, [PreferredVideoService] [nvarchar](20) NOT NULL CONSTRAINT [DF_Users_PreferredVideoService] DEFAULT ('Youtube'), [Salt] [int] NOT NULL, [UserGroup] [varchar](10) NOT NULL CONSTRAINT [DF_Users_Group] DEFAULT ('Regular'), CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_Users] UNIQUE NONCLUSTERED ( [NameLC] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[UserWebLinks] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserWebLinks]( [Id] [int] IDENTITY(1,1) NOT NULL, [Description] [nvarchar](512) NOT NULL, [Url] [nvarchar](512) NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_UserWebLinks] PRIMARY KEY CLUSTERED ( [Id] 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 [mikubot].[LinkRecords] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [mikubot].[LinkRecords]( [Id] [int] IDENTITY(1,1) NOT NULL, [Channel] [nvarchar](50) NOT NULL CONSTRAINT [DF_LinkRecords_Channel] DEFAULT (N'#mikuchan'), [Date] [datetime] NOT NULL, [Description] [nvarchar](512) NOT NULL, [Nick] [nvarchar](50) NOT NULL, [Url] [nvarchar](255) NOT NULL, CONSTRAINT [PK_Urls] PRIMARY KEY CLUSTERED ( [Id] 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 [mikudb].[ImportedAlbums] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [mikudb].[ImportedAlbums]( [Id] [int] IDENTITY(1,1) NOT NULL, [CoverPictureBytes] [varbinary](max) NULL, [CoverPictureMime] [nvarchar](32) NULL, [Created] [datetime] NOT NULL, [Data] [xml] NOT NULL, [SourceUrl] [nvarchar](255) NOT NULL, [Status] [nvarchar](20) NOT NULL, [Title] [nvarchar](100) NOT NULL, CONSTRAINT [PK_ImportedAlbum] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO /****** Object: Table [voter].[PollMetadata] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [voter].[PollMetadata]( [Id] [int] IDENTITY(1,1) NOT NULL, [Poll] [int] NOT NULL, [Type] [nvarchar](50) NOT NULL, [Value] [nvarchar](max) NOT NULL, CONSTRAINT [PK_PollMetadata] PRIMARY KEY CLUSTERED ( [Id] 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 [voter].[Polls] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [voter].[Polls]( [Id] [int] IDENTITY(1,1) NOT NULL, [Type] [nvarchar](50) NOT NULL CONSTRAINT [DF_Polls_Type] DEFAULT ('WVR'), [CreateDate] [datetime] NOT NULL CONSTRAINT [DF_Polls_CreateDate] DEFAULT (getdate()), [Description] [nvarchar](max) NOT NULL CONSTRAINT [DF_Polls_Description] DEFAULT (''), [EndTime] [datetime] NOT NULL, [Name] [nvarchar](255) NOT NULL, [NicoId] [nvarchar](50) NOT NULL CONSTRAINT [DF_Polls_NicoId] DEFAULT (''), [WVRId] [int] NULL, CONSTRAINT [PK_Polls] PRIMARY KEY CLUSTERED ( [Id] 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 [voter].[Votes] Script Date: 13.1.2015 20:28:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [voter].[Votes]( [Id] [int] IDENTITY(1,1) NOT NULL, [CreateDate] [datetime] NOT NULL, [SongInPoll] [int] NOT NULL, [User] [int] NOT NULL, CONSTRAINT [PK_Votes] PRIMARY KEY CLUSTERED ( [Id] 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 [voter].[Votes] ADD CONSTRAINT [DF_Votes_CreateDate] DEFAULT (getdate()) FOR [CreateDate] GO ALTER TABLE [dbo].[ActivityEntries] WITH CHECK ADD CONSTRAINT [FK_ActivityEntries_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ActivityEntries] CHECK CONSTRAINT [FK_ActivityEntries_Albums] GO ALTER TABLE [dbo].[ActivityEntries] WITH CHECK ADD CONSTRAINT [FK_ActivityEntries_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ActivityEntries] CHECK CONSTRAINT [FK_ActivityEntries_Artists] GO ALTER TABLE [dbo].[ActivityEntries] WITH CHECK ADD CONSTRAINT [FK_ActivityEntries_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ActivityEntries] CHECK CONSTRAINT [FK_ActivityEntries_Songs] GO ALTER TABLE [dbo].[ActivityEntries] WITH CHECK ADD CONSTRAINT [FK_ActivityEntries_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ActivityEntries] CHECK CONSTRAINT [FK_ActivityEntries_Users] GO ALTER TABLE [dbo].[AlbumComments] WITH CHECK ADD CONSTRAINT [FK_AlbumComments_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumComments] CHECK CONSTRAINT [FK_AlbumComments_Albums] GO ALTER TABLE [dbo].[AlbumComments] WITH CHECK ADD CONSTRAINT [FK_AlbumComments_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE SET NULL GO ALTER TABLE [dbo].[AlbumComments] CHECK CONSTRAINT [FK_AlbumComments_Users] GO ALTER TABLE [dbo].[AlbumHits] WITH CHECK ADD CONSTRAINT [FK_AlbumHits_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumHits] CHECK CONSTRAINT [FK_AlbumHits_Albums] GO ALTER TABLE [dbo].[AlbumIdentifiers] WITH CHECK ADD CONSTRAINT [FK_AlbumIdentifiers_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumIdentifiers] CHECK CONSTRAINT [FK_AlbumIdentifiers_Albums] GO ALTER TABLE [dbo].[AlbumMergeRecords] WITH CHECK ADD CONSTRAINT [FK_AlbumMergeRecords_Albums] FOREIGN KEY([Source]) REFERENCES [dbo].[Albums] ([Id]) GO ALTER TABLE [dbo].[AlbumMergeRecords] CHECK CONSTRAINT [FK_AlbumMergeRecords_Albums] GO ALTER TABLE [dbo].[AlbumMergeRecords] WITH CHECK ADD CONSTRAINT [FK_AlbumMergeRecords_Albums1] FOREIGN KEY([Target]) REFERENCES [dbo].[Albums] ([Id]) GO ALTER TABLE [dbo].[AlbumMergeRecords] CHECK CONSTRAINT [FK_AlbumMergeRecords_Albums1] GO ALTER TABLE [dbo].[AlbumNames] WITH CHECK ADD CONSTRAINT [FK_AlbumNames_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumNames] CHECK CONSTRAINT [FK_AlbumNames_Albums] GO ALTER TABLE [dbo].[AlbumPictureFiles] WITH CHECK ADD CONSTRAINT [FK_AlbumPictureFiles_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumPictureFiles] CHECK CONSTRAINT [FK_AlbumPictureFiles_Albums] GO ALTER TABLE [dbo].[AlbumPictureFiles] WITH CHECK ADD CONSTRAINT [FK_AlbumPictureFiles_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[AlbumPictureFiles] CHECK CONSTRAINT [FK_AlbumPictureFiles_Users] GO ALTER TABLE [dbo].[AlbumReleaseEvents] WITH CHECK ADD CONSTRAINT [FK_AlbumReleaseEvents_AlbumReleaseEventSeries] FOREIGN KEY([Series]) REFERENCES [dbo].[AlbumReleaseEventSeries] ([Id]) ON DELETE SET NULL GO ALTER TABLE [dbo].[AlbumReleaseEvents] CHECK CONSTRAINT [FK_AlbumReleaseEvents_AlbumReleaseEventSeries] GO ALTER TABLE [dbo].[AlbumReleaseEventSeriesAliases] WITH CHECK ADD CONSTRAINT [FK_AlbumReleaseEventSeriesAliases_AlbumReleaseEventSeries] FOREIGN KEY([Series]) REFERENCES [dbo].[AlbumReleaseEventSeries] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumReleaseEventSeriesAliases] CHECK CONSTRAINT [FK_AlbumReleaseEventSeriesAliases_AlbumReleaseEventSeries] GO ALTER TABLE [dbo].[Albums] WITH CHECK ADD CONSTRAINT [FK_Albums_AlbumPictureFiles] FOREIGN KEY([CoverPicture]) REFERENCES [dbo].[AlbumPictureFiles] ([Id]) GO ALTER TABLE [dbo].[Albums] CHECK CONSTRAINT [FK_Albums_AlbumPictureFiles] GO ALTER TABLE [dbo].[AlbumsForUsers] WITH CHECK ADD CONSTRAINT [FK_AlbumsForUsers_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumsForUsers] CHECK CONSTRAINT [FK_AlbumsForUsers_Albums] GO ALTER TABLE [dbo].[AlbumsForUsers] WITH CHECK ADD CONSTRAINT [FK_AlbumsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumsForUsers] CHECK CONSTRAINT [FK_AlbumsForUsers_Users] GO ALTER TABLE [dbo].[AlbumTagUsages] WITH CHECK ADD CONSTRAINT [FK_AlbumTagUsages_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumTagUsages] CHECK CONSTRAINT [FK_AlbumTagUsages_Albums] GO ALTER TABLE [dbo].[AlbumTagUsages] WITH CHECK ADD CONSTRAINT [FK_AlbumTagUsages_Tags] FOREIGN KEY([Tag]) REFERENCES [dbo].[Tags] ([Name]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumTagUsages] CHECK CONSTRAINT [FK_AlbumTagUsages_Tags] GO ALTER TABLE [dbo].[AlbumTagVotes] WITH CHECK ADD CONSTRAINT [FK_AlbumTagVotes_AlbumTagUsages] FOREIGN KEY([Usage]) REFERENCES [dbo].[AlbumTagUsages] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumTagVotes] CHECK CONSTRAINT [FK_AlbumTagVotes_AlbumTagUsages] GO ALTER TABLE [dbo].[AlbumTagVotes] WITH CHECK ADD CONSTRAINT [FK_AlbumTagVotes_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumTagVotes] CHECK CONSTRAINT [FK_AlbumTagVotes_Users] GO ALTER TABLE [dbo].[AlbumWebLinks] WITH CHECK ADD CONSTRAINT [FK_AlbumWebLinks_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[AlbumWebLinks] CHECK CONSTRAINT [FK_AlbumWebLinks_Albums] GO ALTER TABLE [dbo].[ArchivedAlbumVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedAlbumVersions_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedAlbumVersions] CHECK CONSTRAINT [FK_ArchivedAlbumVersions_Albums] GO ALTER TABLE [dbo].[ArchivedAlbumVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedAlbumVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[ArchivedAlbumVersions] CHECK CONSTRAINT [FK_ArchivedAlbumVersions_Users] GO ALTER TABLE [dbo].[ArchivedArtistVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedArtistVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[ArchivedArtistVersions] CHECK CONSTRAINT [FK_ArchivedArtistVersions_Users] GO ALTER TABLE [dbo].[ArchivedArtistVersions] WITH CHECK ADD CONSTRAINT [FK_ArtistVersions_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedArtistVersions] CHECK CONSTRAINT [FK_ArtistVersions_Artists] GO ALTER TABLE [dbo].[ArchivedEventVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedEventVersions_AlbumReleaseEvents] FOREIGN KEY([Event]) REFERENCES [dbo].[AlbumReleaseEvents] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedEventVersions] CHECK CONSTRAINT [FK_ArchivedEventVersions_AlbumReleaseEvents] GO ALTER TABLE [dbo].[ArchivedEventVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedEventVersions_AlbumReleaseEventSeries] FOREIGN KEY([Series]) REFERENCES [dbo].[AlbumReleaseEventSeries] ([Id]) ON DELETE SET NULL GO ALTER TABLE [dbo].[ArchivedEventVersions] CHECK CONSTRAINT [FK_ArchivedEventVersions_AlbumReleaseEventSeries] GO ALTER TABLE [dbo].[ArchivedEventVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedEventVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedEventVersions] CHECK CONSTRAINT [FK_ArchivedEventVersions_Users] GO ALTER TABLE [dbo].[ArchivedSongListVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedSongListVersions_SongsInLists] FOREIGN KEY([SongList]) REFERENCES [dbo].[SongLists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedSongListVersions] CHECK CONSTRAINT [FK_ArchivedSongListVersions_SongsInLists] GO ALTER TABLE [dbo].[ArchivedSongListVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedSongListVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[ArchivedSongListVersions] CHECK CONSTRAINT [FK_ArchivedSongListVersions_Users] GO ALTER TABLE [dbo].[ArchivedSongVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedSongVersions_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedSongVersions] CHECK CONSTRAINT [FK_ArchivedSongVersions_Songs] GO ALTER TABLE [dbo].[ArchivedSongVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedSongVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE SET NULL GO ALTER TABLE [dbo].[ArchivedSongVersions] CHECK CONSTRAINT [FK_ArchivedSongVersions_Users] GO ALTER TABLE [dbo].[ArchivedTagVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedTagVersions_Tags] FOREIGN KEY([Tag]) REFERENCES [dbo].[Tags] ([Name]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedTagVersions] CHECK CONSTRAINT [FK_ArchivedTagVersions_Tags] GO ALTER TABLE [dbo].[ArchivedTagVersions] WITH CHECK ADD CONSTRAINT [FK_ArchivedTagVersions_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArchivedTagVersions] CHECK CONSTRAINT [FK_ArchivedTagVersions_Users] GO ALTER TABLE [dbo].[ArtistComments] WITH CHECK ADD CONSTRAINT [FK_ArtistComments_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistComments] CHECK CONSTRAINT [FK_ArtistComments_Artists] GO ALTER TABLE [dbo].[ArtistComments] WITH CHECK ADD CONSTRAINT [FK_ArtistComments_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistComments] CHECK CONSTRAINT [FK_ArtistComments_Users] GO ALTER TABLE [dbo].[ArtistMergeRecords] WITH CHECK ADD CONSTRAINT [FK_ArtistMergeRecords_Artists] FOREIGN KEY([Source]) REFERENCES [dbo].[Artists] ([Id]) GO ALTER TABLE [dbo].[ArtistMergeRecords] CHECK CONSTRAINT [FK_ArtistMergeRecords_Artists] GO ALTER TABLE [dbo].[ArtistMergeRecords] WITH CHECK ADD CONSTRAINT [FK_ArtistMergeRecords_Artists1] FOREIGN KEY([Target]) REFERENCES [dbo].[Artists] ([Id]) GO ALTER TABLE [dbo].[ArtistMergeRecords] CHECK CONSTRAINT [FK_ArtistMergeRecords_Artists1] GO ALTER TABLE [dbo].[ArtistNames] WITH CHECK ADD CONSTRAINT [FK_ArtistNames_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistNames] CHECK CONSTRAINT [FK_ArtistNames_Artists] GO ALTER TABLE [dbo].[ArtistPictureFiles] WITH CHECK ADD CONSTRAINT [FK_ArtistPictureFiles_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistPictureFiles] CHECK CONSTRAINT [FK_ArtistPictureFiles_Artists] GO ALTER TABLE [dbo].[ArtistPictureFiles] WITH CHECK ADD CONSTRAINT [FK_ArtistPictureFiles_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistPictureFiles] CHECK CONSTRAINT [FK_ArtistPictureFiles_Users] GO ALTER TABLE [dbo].[Artists] WITH CHECK ADD CONSTRAINT [FK_Artists_Artists] FOREIGN KEY([BaseVoicebank]) REFERENCES [dbo].[Artists] ([Id]) GO ALTER TABLE [dbo].[Artists] CHECK CONSTRAINT [FK_Artists_Artists] GO ALTER TABLE [dbo].[ArtistsForAlbums] WITH CHECK ADD CONSTRAINT [FK_ArtistsForAlbums_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForAlbums] CHECK CONSTRAINT [FK_ArtistsForAlbums_Albums] GO ALTER TABLE [dbo].[ArtistsForAlbums] WITH CHECK ADD CONSTRAINT [FK_ArtistsForAlbums_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForAlbums] CHECK CONSTRAINT [FK_ArtistsForAlbums_Artists] GO ALTER TABLE [dbo].[ArtistsForSongs] WITH CHECK ADD CONSTRAINT [FK_ArtistsForSongs_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForSongs] CHECK CONSTRAINT [FK_ArtistsForSongs_Artists] GO ALTER TABLE [dbo].[ArtistsForSongs] WITH CHECK ADD CONSTRAINT [FK_ArtistsForSongs_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForSongs] CHECK CONSTRAINT [FK_ArtistsForSongs_Songs] GO ALTER TABLE [dbo].[ArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_ArtistsForUsers_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForUsers] CHECK CONSTRAINT [FK_ArtistsForUsers_Artists] GO ALTER TABLE [dbo].[ArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_ArtistsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistsForUsers] CHECK CONSTRAINT [FK_ArtistsForUsers_Users] GO ALTER TABLE [dbo].[ArtistTagUsages] WITH CHECK ADD CONSTRAINT [FK_ArtistTagUsages_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistTagUsages] CHECK CONSTRAINT [FK_ArtistTagUsages_Artists] GO ALTER TABLE [dbo].[ArtistTagVotes] WITH CHECK ADD CONSTRAINT [FK_ArtistTagVotes_ArtistTagUsages] FOREIGN KEY([Usage]) REFERENCES [dbo].[ArtistTagUsages] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistTagVotes] CHECK CONSTRAINT [FK_ArtistTagVotes_ArtistTagUsages] GO ALTER TABLE [dbo].[ArtistTagVotes] WITH CHECK ADD CONSTRAINT [FK_ArtistTagVotes_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[ArtistTagVotes] CHECK CONSTRAINT [FK_ArtistTagVotes_Users] GO ALTER TABLE [dbo].[ArtistWebLinks] WITH CHECK ADD CONSTRAINT [FK_ArtistWebLinks_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) GO ALTER TABLE [dbo].[ArtistWebLinks] CHECK CONSTRAINT [FK_ArtistWebLinks_Artists] GO ALTER TABLE [dbo].[AuditLogEntries] WITH CHECK ADD CONSTRAINT [FK_AuditLog_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE SET NULL GO ALTER TABLE [dbo].[AuditLogEntries] CHECK CONSTRAINT [FK_AuditLog_Users] GO ALTER TABLE [dbo].[EntryReports] WITH CHECK ADD CONSTRAINT [FK_EntryReports_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[EntryReports] CHECK CONSTRAINT [FK_EntryReports_Albums] GO ALTER TABLE [dbo].[EntryReports] WITH CHECK ADD CONSTRAINT [FK_EntryReports_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[EntryReports] CHECK CONSTRAINT [FK_EntryReports_Artists] GO ALTER TABLE [dbo].[EntryReports] WITH CHECK ADD CONSTRAINT [FK_EntryReports_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[EntryReports] CHECK CONSTRAINT [FK_EntryReports_Songs] GO ALTER TABLE [dbo].[EntryReports] WITH CHECK ADD CONSTRAINT [FK_EntryReports_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[EntryReports] CHECK CONSTRAINT [FK_EntryReports_Users] GO ALTER TABLE [dbo].[EntryReports] WITH CHECK ADD CONSTRAINT [FK_EntryReports_Users1] FOREIGN KEY([ReportedUser]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[EntryReports] CHECK CONSTRAINT [FK_EntryReports_Users1] GO ALTER TABLE [dbo].[FavoriteAlbumsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteAlbumsForUsers_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteAlbumsForUsers] CHECK CONSTRAINT [FK_FavoriteAlbumsForUsers_Albums] GO ALTER TABLE [dbo].[FavoriteAlbumsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteAlbumsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteAlbumsForUsers] CHECK CONSTRAINT [FK_FavoriteAlbumsForUsers_Users] GO ALTER TABLE [dbo].[FavoriteArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteArtistsForUsers_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteArtistsForUsers] CHECK CONSTRAINT [FK_FavoriteArtistsForUsers_Artists] GO ALTER TABLE [dbo].[FavoriteArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteArtistsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteArtistsForUsers] CHECK CONSTRAINT [FK_FavoriteArtistsForUsers_Users] GO ALTER TABLE [dbo].[FavoriteSongsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteSongsForUsers_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteSongsForUsers] CHECK CONSTRAINT [FK_FavoriteSongsForUsers_Songs] GO ALTER TABLE [dbo].[FavoriteSongsForUsers] WITH CHECK ADD CONSTRAINT [FK_FavoriteSongsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[FavoriteSongsForUsers] CHECK CONSTRAINT [FK_FavoriteSongsForUsers_Users] GO ALTER TABLE [dbo].[GroupsForArtists] WITH CHECK ADD CONSTRAINT [FK_GroupsForArtists_Artists] FOREIGN KEY([Group]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[GroupsForArtists] CHECK CONSTRAINT [FK_GroupsForArtists_Artists] GO ALTER TABLE [dbo].[GroupsForArtists] WITH CHECK ADD CONSTRAINT [FK_GroupsForArtists_Artists1] FOREIGN KEY([Member]) REFERENCES [dbo].[Artists] ([Id]) GO ALTER TABLE [dbo].[GroupsForArtists] CHECK CONSTRAINT [FK_GroupsForArtists_Artists1] GO ALTER TABLE [dbo].[LyricsForSongs] WITH CHECK ADD CONSTRAINT [FK_LyricsForSongs_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[LyricsForSongs] CHECK CONSTRAINT [FK_LyricsForSongs_Songs] GO ALTER TABLE [dbo].[NewsEntries] WITH CHECK ADD CONSTRAINT [FK_NewsEntries_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[NewsEntries] CHECK CONSTRAINT [FK_NewsEntries_Users] GO ALTER TABLE [dbo].[OwnedArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_OwnedArtistsForUsers_Artists] FOREIGN KEY([Artist]) REFERENCES [dbo].[Artists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OwnedArtistsForUsers] CHECK CONSTRAINT [FK_OwnedArtistsForUsers_Artists] GO ALTER TABLE [dbo].[OwnedArtistsForUsers] WITH CHECK ADD CONSTRAINT [FK_OwnedArtistsForUsers_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OwnedArtistsForUsers] CHECK CONSTRAINT [FK_OwnedArtistsForUsers_Users] GO ALTER TABLE [dbo].[PasswordResetRequests] WITH CHECK ADD CONSTRAINT [FK_PasswordResetRequests_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[PasswordResetRequests] CHECK CONSTRAINT [FK_PasswordResetRequests_Users] GO ALTER TABLE [dbo].[PVsForAlbums] WITH CHECK ADD CONSTRAINT [FK_PVsForAlbums_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[PVsForAlbums] CHECK CONSTRAINT [FK_PVsForAlbums_Albums] GO ALTER TABLE [dbo].[PVsForSongs] WITH CHECK ADD CONSTRAINT [FK_PVsForSongs_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[PVsForSongs] CHECK CONSTRAINT [FK_PVsForSongs_Songs] GO ALTER TABLE [dbo].[SongComments] WITH CHECK ADD CONSTRAINT [FK_SongComments_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongComments] CHECK CONSTRAINT [FK_SongComments_Songs] GO ALTER TABLE [dbo].[SongComments] WITH CHECK ADD CONSTRAINT [FK_SongComments_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongComments] CHECK CONSTRAINT [FK_SongComments_Users] GO ALTER TABLE [dbo].[SongHits] WITH CHECK ADD CONSTRAINT [FK_SongHits_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongHits] CHECK CONSTRAINT [FK_SongHits_Songs] GO ALTER TABLE [dbo].[SongLists] WITH CHECK ADD CONSTRAINT [FK_SongLists_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[SongLists] CHECK CONSTRAINT [FK_SongLists_Users] GO ALTER TABLE [dbo].[SongMergeRecords] WITH CHECK ADD CONSTRAINT [FK_SongMergeRecords_Songs] FOREIGN KEY([Source]) REFERENCES [dbo].[Songs] ([Id]) GO ALTER TABLE [dbo].[SongMergeRecords] CHECK CONSTRAINT [FK_SongMergeRecords_Songs] GO ALTER TABLE [dbo].[SongMergeRecords] WITH CHECK ADD CONSTRAINT [FK_SongMergeRecords_Songs1] FOREIGN KEY([Target]) REFERENCES [dbo].[Songs] ([Id]) GO ALTER TABLE [dbo].[SongMergeRecords] CHECK CONSTRAINT [FK_SongMergeRecords_Songs1] GO ALTER TABLE [dbo].[SongNames] WITH CHECK ADD CONSTRAINT [FK_SongNames_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongNames] CHECK CONSTRAINT [FK_SongNames_Songs] GO ALTER TABLE [dbo].[Songs] WITH CHECK ADD CONSTRAINT [FK_Songs_Songs] FOREIGN KEY([OriginalVersion]) REFERENCES [dbo].[Songs] ([Id]) GO ALTER TABLE [dbo].[Songs] CHECK CONSTRAINT [FK_Songs_Songs] GO ALTER TABLE [dbo].[SongsInAlbums] WITH CHECK ADD CONSTRAINT [FK_AlbumsForSongs_Albums] FOREIGN KEY([Album]) REFERENCES [dbo].[Albums] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongsInAlbums] CHECK CONSTRAINT [FK_AlbumsForSongs_Albums] GO ALTER TABLE [dbo].[SongsInAlbums] WITH CHECK ADD CONSTRAINT [FK_AlbumsForSongs_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongsInAlbums] CHECK CONSTRAINT [FK_AlbumsForSongs_Songs] GO ALTER TABLE [dbo].[SongsInLists] WITH CHECK ADD CONSTRAINT [FK_SongsInLists_SongLists] FOREIGN KEY([List]) REFERENCES [dbo].[SongLists] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongsInLists] CHECK CONSTRAINT [FK_SongsInLists_SongLists] GO ALTER TABLE [dbo].[SongsInLists] WITH CHECK ADD CONSTRAINT [FK_SongsInLists_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongsInLists] CHECK CONSTRAINT [FK_SongsInLists_Songs] GO ALTER TABLE [dbo].[SongTagUsages] WITH CHECK ADD CONSTRAINT [FK_SongTagUsages_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongTagUsages] CHECK CONSTRAINT [FK_SongTagUsages_Songs] GO ALTER TABLE [dbo].[SongTagUsages] WITH CHECK ADD CONSTRAINT [FK_SongTagUsages_Tags] FOREIGN KEY([Tag]) REFERENCES [dbo].[Tags] ([Name]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongTagUsages] CHECK CONSTRAINT [FK_SongTagUsages_Tags] GO ALTER TABLE [dbo].[SongTagVotes] WITH CHECK ADD CONSTRAINT [FK_SongTagVotes_SongTagUsages] FOREIGN KEY([Usage]) REFERENCES [dbo].[SongTagUsages] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongTagVotes] CHECK CONSTRAINT [FK_SongTagVotes_SongTagUsages] GO ALTER TABLE [dbo].[SongTagVotes] WITH CHECK ADD CONSTRAINT [FK_SongTagVotes_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongTagVotes] CHECK CONSTRAINT [FK_SongTagVotes_Users] GO ALTER TABLE [dbo].[SongWebLinks] WITH CHECK ADD CONSTRAINT [FK_SongWebLinks_Songs] FOREIGN KEY([Song]) REFERENCES [dbo].[Songs] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[SongWebLinks] CHECK CONSTRAINT [FK_SongWebLinks_Songs] GO ALTER TABLE [dbo].[Tags] WITH CHECK ADD CONSTRAINT [FK_Tags_Tags] FOREIGN KEY([AliasedTo]) REFERENCES [dbo].[Tags] ([Name]) GO ALTER TABLE [dbo].[Tags] CHECK CONSTRAINT [FK_Tags_Tags] GO ALTER TABLE [dbo].[Tags] WITH CHECK ADD CONSTRAINT [FK_Tags_Tags1] FOREIGN KEY([Parent]) REFERENCES [dbo].[Tags] ([Name]) GO ALTER TABLE [dbo].[Tags] CHECK CONSTRAINT [FK_Tags_Tags1] GO ALTER TABLE [dbo].[TrashedEntries] WITH CHECK ADD CONSTRAINT [FK_TrashedEntries_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[TrashedEntries] CHECK CONSTRAINT [FK_TrashedEntries_Users] GO ALTER TABLE [dbo].[UserAdditionalPermissions] WITH CHECK ADD CONSTRAINT [FK_UserAdditionalPermissions_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[UserAdditionalPermissions] CHECK CONSTRAINT [FK_UserAdditionalPermissions_Users] GO ALTER TABLE [dbo].[UserComments] WITH CHECK ADD CONSTRAINT [FK_UserComments_Users] FOREIGN KEY([Author]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[UserComments] CHECK CONSTRAINT [FK_UserComments_Users] GO ALTER TABLE [dbo].[UserComments] WITH CHECK ADD CONSTRAINT [FK_UserComments_Users1] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[UserComments] CHECK CONSTRAINT [FK_UserComments_Users1] GO ALTER TABLE [dbo].[UserMessages] WITH CHECK ADD CONSTRAINT [FK_UserMessages_Users] FOREIGN KEY([Receiver]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[UserMessages] CHECK CONSTRAINT [FK_UserMessages_Users] GO ALTER TABLE [dbo].[UserMessages] WITH CHECK ADD CONSTRAINT [FK_UserMessages_Users1] FOREIGN KEY([Sender]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[UserMessages] CHECK CONSTRAINT [FK_UserMessages_Users1] GO ALTER TABLE [dbo].[UserOptions] WITH CHECK ADD CONSTRAINT [FK_UserOptions_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[UserOptions] CHECK CONSTRAINT [FK_UserOptions_Users] GO ALTER TABLE [dbo].[UserWebLinks] WITH CHECK ADD CONSTRAINT [FK_UserWebLinks_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[UserWebLinks] CHECK CONSTRAINT [FK_UserWebLinks_Users] GO ALTER TABLE [voter].[PollMetadata] WITH CHECK ADD CONSTRAINT [FK_PollMetadata_Polls] FOREIGN KEY([Poll]) REFERENCES [voter].[Polls] ([Id]) ON DELETE CASCADE GO ALTER TABLE [voter].[PollMetadata] CHECK CONSTRAINT [FK_PollMetadata_Polls] GO ALTER TABLE [voter].[Votes] WITH CHECK ADD CONSTRAINT [FK_Votes_Users] FOREIGN KEY([User]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [voter].[Votes] CHECK CONSTRAINT [FK_Votes_Users] GO