/BlogEngine/BlogEngine.NET/setup/SQLServer/MSSQLUpgradeFrom1.6To2.0.sql

# · SQL · 34 lines · 26 code · 8 blank · 0 comment · 0 complexity · d965bc14eb1709c77d28a9a165f69087 MD5 · raw file

  1. ALTER TABLE [dbo].[be_PostComment] ADD IsSpam bit NOT NULL DEFAULT 0
  2. GO
  3. ALTER TABLE [dbo].[be_PostComment] ADD IsDeleted bit NOT NULL DEFAULT 0
  4. GO
  5. ALTER TABLE [dbo].[be_Posts] ADD IsDeleted bit NOT NULL DEFAULT 0
  6. GO
  7. ALTER TABLE [dbo].[be_Pages] ADD IsDeleted bit NOT NULL DEFAULT 0
  8. GO
  9. CREATE TABLE [dbo].[be_Rights](
  10. [RightName] [nvarchar](100) NOT NULL,
  11. CONSTRAINT [PK_be_Rights] PRIMARY KEY CLUSTERED
  12. (
  13. [RightName] ASC
  14. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  15. ) ON [PRIMARY]
  16. GO
  17. CREATE TABLE [dbo].[be_RightRoles](
  18. [RightName] [nvarchar](100) NOT NULL,
  19. [Role] [nvarchar](100) NOT NULL,
  20. CONSTRAINT [PK_be_RightRoles] PRIMARY KEY CLUSTERED
  21. (
  22. [RightName] ASC,
  23. [Role] ASC
  24. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  25. ) ON [PRIMARY]
  26. GO