alter table   p_systempopupmenu add visible1 int default(0)
alter table   p_systempopupmenu add visible2 int default(0)

alter table p_systembillflow add stepBackText varchar(20)
go
alter table p_systembillflow add stepApplyContent varchar(50)
go
alter table p_systembillflow add stepBackContent varchar(50)
go
update p_systembillflow set stepBackText='返退',stepApplyContent='同意',stepBackContent='不同意'
go
alter table p_systemdlltabflow add stepBackText varchar(20)
go
alter table p_systemdlltabflow add stepApplyContent varchar(50)
go
alter table p_systemdlltabflow add stepBackContent varchar(50)
go
update p_systemdlltabflow set stepBackText='返退',stepApplyContent='同意',stepBackContent='不同意'
go
alter table p_systemDlltab add printSQL varchar(2000)
alter table p_systemDlltab add printSQL1 varchar(2000)
alter table p_systemDlltab add printSQL2 varchar(2000)
alter table p_systemDlltab add printFile varchar(200)
alter table p_systemDlltab add printType int

--增加分组功能
alter table p_systemwordbooktab add GroupId int default(0) not null

CREATE TABLE [dbo].[p_systemAddGroup](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[GroupName] [nvarchar](50) NULL,
	[controlLeft] [int] NOT NULL,
	[controlTop] [int] NOT NULL,
	[controlHeight] [int] NOT NULL,
	[controlWidth] [int] NOT NULL,
	[formKey] [uniqueidentifier] NOT NULL,
	[controlType] [smallint] NOT NULL,
 CONSTRAINT [PK_p_systemAddGroup] 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]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'左边距' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlLeft'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上边距' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlTop'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件高度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlHeight'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件宽度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlWidth'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关联模块' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'formKey'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'p_systemAddGroup', @level2type=N'COLUMN',@level2name=N'controlType'
GO

alter table dbo.p_systemControlLocation add GroupId int default(0) not null
GO


CREATE TABLE [dbo].[p_systemdlltabChart](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[tab] [varchar](20) NULL,
	[tabKey] [uniqueidentifier] NULL,
	[chartType] [int] NULL,
	[chartTitle] [varchar](50) NULL,
	[chartColor] [varchar](20) NULL,
	[chartColorDf] [varchar](20) NULL,
	[chart3D] [int] NULL,
	[gridLineVisible] [int] NULL,
	[XLabelField] [varchar](30) NULL,
	[YValueField] [varchar](30) NULL,
	[XAxisTitle] [varchar](20) NULL,
	[YAxisTitle] [varchar](20) NULL,
	[YAxisShared] [int] NULL,
	[markVisible] [int] NULL,
	[legendVisible] [int] NULL,
	[isVisible] [int] NULL,
	[orderId] [int] NULL,
 CONSTRAINT [PK_p_systemdlltabChart] 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]

GO

SET ANSI_PADDING OFF
GO