SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

IF Not EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_pa_tag_tableId]') AND type = 'D')
Begin
CREATE TABLE [dbo].[pa_tag](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[tableId] [int] NULL,
	[count] [int] NULL,
 CONSTRAINT [PK_pa_tag] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [dbo].[pa_tag] ADD  CONSTRAINT [DF_pa_tag_tableId]  DEFAULT ((0)) FOR [tableId]
ALTER TABLE [dbo].[pa_tag] ADD  CONSTRAINT [DF_pa_tag_count]  DEFAULT ((0)) FOR [count]
END


IF Not EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pa_tag_data]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[pa_tag_data](
	[tagId] [int] NULL,
	[tableId] [int] NULL,
	[tableDataId] [int] NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[pa_tag_data] ADD  CONSTRAINT [DF_pa_tag_data_tagId]  DEFAULT ((0)) FOR [tagId]
ALTER TABLE [dbo].[pa_tag_data] ADD  CONSTRAINT [DF_pa_tag_data_tableId]  DEFAULT ((0)) FOR [tableId]
ALTER TABLE [dbo].[pa_tag_data] ADD  CONSTRAINT [DF_pa_tag_data_tableDataId]  DEFAULT ((0)) FOR [tableDataId]
END



/******添加标签管理菜单******/
IF Not EXISTS (select id from [pa_admin_menu] where controller='Tag')
Begin
update pa_admin_menu set xuhao=1 where controller='SiteSet' and parentId=49
update pa_admin_menu set xuhao=2 where controller='Column' and parentId=49
update pa_admin_menu set xuhao=4 where controller='TemplateManager' and parentId=49
INSERT INTO [pa_admin_menu]
           ([parentId]
           ,[name]
           ,[icon]
           ,[level]
           ,[nameSpace]
           ,[area]
           ,[controller]
           ,[action]
           ,[isFinal]
           ,[isExpand]
           ,[state]
           ,[isSys]
           ,[target]
           ,[pluginName]
           ,[zdyUrl]
           ,[sysNode]
           ,[xuhao])
     VALUES
           (49
           ,'标签管理'
           ,''
           ,3
           ,'PageAdmin.Web.Areas.Admin.Controllers'
           ,'admin'
           ,'Tag'
           ,'index'
           ,1
           ,0
           ,1
           ,1
           ,''
           ,''
           ,''
           ,''
           ,3)
END


IF not EXISTS (select * from syscolumns where id=object_id('pa_info_table') and name='templateDetail')
Begin
/*创建字段templateDetail*/
ALTER TABLE [pa_info_table] ADD [templateDetail] NVARCHAR(50)
END


IF Not EXISTS (select * from syscolumns where id=object_id('pa_sub_table') and name='subTableType')
Begin
/*a_sub_table创建字段subTableType*/
ALTER TABLE [pa_sub_table] ADD [subTableType] VARCHAR(20)
exec('update pa_sub_table set subTableType=fieldChildType')
ALTER TABLE pa_sub_table DROP COLUMN fieldChildType
END

IF not EXISTS (select * from syscolumns where id=object_id('pa_field') and name='subTableType')
Begin
/*pa_field创建字段subTableType*/
ALTER TABLE [pa_field] ADD [subTableType] VARCHAR(50)
ALTER TABLE [pa_field] ADD [zdyCondition] NVARCHAR(100)
ALTER TABLE [pa_field] ADD [valueField] VARCHAR(50)
ALTER TABLE [pa_field] ADD [textField] VARCHAR(50)
ALTER TABLE [pa_field] ADD [textFieldName] VARCHAR(50)
ALTER TABLE [pa_field] ADD [selectDataType] tinyint default 0
ALTER TABLE [pa_field] ADD [isMultiLevelTable] tinyint default 0
ALTER TABLE [pa_field] ADD [onlySelectFinal] tinyint default 0
exec('update pa_field set subTableType=fieldChildType,zdyCondition=datasourceWhere,ValueField=datasourceValueField,TextField=datasourceTextField,TextFieldName=datasourceTextFieldName,selectDataType=datasourceShowType,IsMultiLevelTable=datasourceMultiLevel,OnlySelectFinal=datasourceOnlySelectFinal')

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_pa_field_datasourceShowType]') AND type = 'D')
BEGIN
ALTER TABLE [pa_field] DROP CONSTRAINT [DF_pa_field_datasourceShowType]
END


IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_pa_field_datasourceMultiLevel]') AND type = 'D')
BEGIN
ALTER TABLE [pa_field] DROP CONSTRAINT [DF_pa_field_datasourceMultiLevel]
END


IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_pa_field_datasourceOnlySelectFinal]') AND type = 'D')
BEGIN
ALTER TABLE [pa_field] DROP CONSTRAINT [DF_pa_field_datasourceOnlySelectFinal]
END

ALTER TABLE pa_field DROP COLUMN fieldChildType
ALTER TABLE pa_field DROP COLUMN datasourceWhere
ALTER TABLE pa_field DROP COLUMN datasourceValueField
ALTER TABLE pa_field DROP COLUMN datasourceTextField
ALTER TABLE pa_field DROP COLUMN datasourceTextFieldName
ALTER TABLE pa_field DROP COLUMN datasourceShowType
ALTER TABLE pa_field DROP COLUMN datasourceMultiLevel
ALTER TABLE pa_field DROP COLUMN datasourceOnlySelectFinal

END