/BlogEngine/BlogEngine.NET/setup/SQLServer/MSSQLUpgradeFrom1.6To2.0.sql
# · SQL · 34 lines · 26 code · 8 blank · 0 comment · 0 complexity · d965bc14eb1709c77d28a9a165f69087 MD5 · raw file
- ALTER TABLE [dbo].[be_PostComment] ADD IsSpam bit NOT NULL DEFAULT 0
- GO
-
- ALTER TABLE [dbo].[be_PostComment] ADD IsDeleted bit NOT NULL DEFAULT 0
- GO
-
- ALTER TABLE [dbo].[be_Posts] ADD IsDeleted bit NOT NULL DEFAULT 0
- GO
-
- ALTER TABLE [dbo].[be_Pages] ADD IsDeleted bit NOT NULL DEFAULT 0
- GO
-
- CREATE TABLE [dbo].[be_Rights](
- [RightName] [nvarchar](100) NOT NULL,
- CONSTRAINT [PK_be_Rights] PRIMARY KEY CLUSTERED
- (
- [RightName] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
-
- CREATE TABLE [dbo].[be_RightRoles](
- [RightName] [nvarchar](100) NOT NULL,
- [Role] [nvarchar](100) NOT NULL,
- CONSTRAINT [PK_be_RightRoles] PRIMARY KEY CLUSTERED
- (
- [RightName] ASC,
- [Role] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO