/BlogEngine/BlogEngine.NET/setup/SQLServer/MSSQLUpgradeFrom1.6To2.0.sql
SQL | 34 lines | 26 code | 8 blank | 0 comment | 0 complexity | d965bc14eb1709c77d28a9a165f69087 MD5 | raw file
Possible License(s): LGPL-2.1, Apache-2.0, BSD-3-Clause
-
-
- 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
-