P04AzQYG

1IF (NOT EXISTS (SELECT * 
2                 FROM INFORMATION_SCHEMA.TABLES 
3                 WHERE TABLE_SCHEMA = 'dbo' 
4                 AND  TABLE_NAME = 'UserAccount'))
5BEGIN
6   CREATE TABLE [dbo].[UserAccount] (
7       [UserAccountId]                  INT           IDENTITY (1, 1) NOT NULL,
8       [DisplayName]                    NVARCHAR (20)    NULL,
9       [Email]                          NVARCHAR (129)   NOT NULL,
10       [CreateDate]                     DATETIME         NOT NULL
11   );
12   ALTER TABLE [dbo].[UserAccount]
13       ADD CONSTRAINT [PK_UserAccount] PRIMARY KEY CLUSTERED ([UserAccountId] ASC) WITH (FILLFACTOR = 80, ALLOW_PAGE_LOCKS = OFF, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);
14
15   CREATE TABLE [dbo].[Channel] (
16       [ChannelId]                      INT           IDENTITY (1, 1) NOT NULL,
17       [Title]                          NVARCHAR (128)   NOT NULL,
18       [UserAccountId]                  INT           NOT NULL,
19       [ModifyDate]                     DATETIME         NOT NULL
20   );
21   ALTER TABLE [dbo].[Channel]
22       ADD CONSTRAINT [PK_Channel] PRIMARY KEY CLUSTERED ([ChannelId] ASC) WITH (FILLFACTOR = 80, ALLOW_PAGE_LOCKS = OFF, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);
23   ALTER TABLE [dbo].[Channel]
24       ADD CONSTRAINT [FK_Channel_UserAccountId_UserAccount_UserAccountId] FOREIGN KEY ([UserAccountId]) REFERENCES [dbo].[UserAccount] ([UserAccountId]) ON DELETE NO ACTION ON UPDATE NO ACTION;
25
26   CREATE TABLE [dbo].[Media] (
27       [MediaId]                           INT           IDENTITY (1, 1) NOT NULL,
28       [ChannelId]                         INT           NOT NULL,
29       [Title]                             NVARCHAR (128)   NULL,
30       [Width]                             INT              NOT NULL,
31       [Height]                            INT              NOT NULL,
32       [Duration]                          INT           NOT NULL,
33       [ContentUrl]                        NVARCHAR (MAX)   NULL,
34   );
35   ALTER TABLE [dbo].[Media]
36       ADD CONSTRAINT [PK_Media] PRIMARY KEY CLUSTERED ([MediaId] ASC) WITH (FILLFACTOR = 80, ALLOW_PAGE_LOCKS = OFF, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);
37   ALTER TABLE [dbo].[Media]
38       ADD CONSTRAINT [FK_Media_ChannelId_Channel_ChannelId] FOREIGN KEY ([ChannelId]) REFERENCES [dbo].[Channel] ([ChannelId]) ON DELETE NO ACTION ON UPDATE NO ACTION;
39END