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

# · Unknown · 35 lines · 28 code · 7 blank · 0 comment · 0 complexity · 21cd5285adf0c168c1cc4b1e7df9e4c1 MD5 · raw file

  1. CREATE 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. ALTER TABLE [be_BlogRollItems]
  12. ADD
  13. CONSTRAINT [Primary Key] PRIMARY KEY ([BlogRollId]);
  14. CREATE TABLE [be_Referrers]
  15. (
  16. [ReferrerId] UNIQUEIDENTIFIER NOT NULL,
  17. [ReferralDay] DATETIME NOT NULL DEFAULT 'GETDATE()',
  18. [ReferrerUrl] VARCHAR (255) CODE PAGE 1252 NOT NULL,
  19. [ReferralCount] INT NOT NULL,
  20. [Url] VARCHAR (255) CODE PAGE 1252,
  21. [IsSpam] BIT
  22. );
  23. ALTER TABLE [be_Referrers]
  24. ADD
  25. CONSTRAINT [Primary Key] PRIMARY KEY ([ReferrerId]);
  26. ALTER TABLE dbo.be_Pages ADD Slug nvarchar(255) NULL;
  27. ALTER TABLE dbo.be_PostComment ADD ModeratedBy nvarchar(100) NULL;
  28. ALTER TABLE dbo.be_PostComment ADD Avatar nvarchar(255) NULL;