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

 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