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

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