PageRenderTime 15ms CodeModel.GetById 11ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/VistaDB/VistaDBUpgradeTo1.6From1.5.vsql3

#
Unknown | 35 lines | 28 code | 7 blank | 0 comment | 0 complexity | 21cd5285adf0c168c1cc4b1e7df9e4c1 MD5 | raw file
 1CREATE TABLE [be_BlogRollItems]
 2(
 3[BlogRollId] UNIQUEIDENTIFIER NOT NULL,
 4[Title] NVARCHAR (255) NOT NULL,
 5[Description] NTEXT,
 6[BlogUrl] VARCHAR (255) CODE PAGE 1252 NOT NULL,
 7[FeedUrl] VARCHAR (255) CODE PAGE 1252,
 8[Xfn] VARCHAR (255) CODE PAGE 1252,
 9[SortIndex] INT NOT NULL
10);
11
12ALTER TABLE [be_BlogRollItems]
13ADD
14CONSTRAINT [Primary Key] PRIMARY KEY ([BlogRollId]);
15
16CREATE TABLE [be_Referrers]
17(
18[ReferrerId] UNIQUEIDENTIFIER NOT NULL,
19[ReferralDay] DATETIME NOT NULL DEFAULT 'GETDATE()',
20[ReferrerUrl] VARCHAR (255) CODE PAGE 1252 NOT NULL,
21[ReferralCount] INT NOT NULL,
22[Url] VARCHAR (255) CODE PAGE 1252,
23[IsSpam] BIT
24);
25
26ALTER TABLE [be_Referrers]
27ADD
28CONSTRAINT [Primary Key] PRIMARY KEY ([ReferrerId]);
29
30ALTER TABLE dbo.be_Pages ADD Slug nvarchar(255) NULL;
31
32ALTER TABLE dbo.be_PostComment ADD ModeratedBy nvarchar(100) NULL;
33
34ALTER TABLE dbo.be_PostComment ADD Avatar nvarchar(255) NULL;
35