--V2.8
--Ë÷Ò×ÖÇÄÜÖпØ
IF OBJECT_ID (N'T_TSC_MODE') IS NULL
BEGIN  
CREATE TABLE [dbo].[T_TSC_MODE](
	[F_INDEX] [int] NOT NULL,
	[F_NAME] [varchar](50) NOT NULL,
	[F_ENABLEONE] [int] NOT NULL,
	[F_ENABLETWO] [int] NOT NULL,
	[F_ENABLETHREE] [int] NOT NULL,
	[F_STATUSONE] [int] NOT NULL,
	[F_STATUSTWO] [int] NOT NULL,
	[F_STATUSTHREE] [int] NOT NULL,
	[F_BRIGHT] [int] NOT NULL,
	[F_TEMPERATURE] [int] NOT NULL,
	[F_SHOPID] [varchar](10) NULL
) ON [PRIMARY]
END
GO

IF OBJECT_ID (N'T_TSC_STATE') IS NULL
BEGIN  
CREATE TABLE [dbo].[T_TSC_STATE](
	[F_MODEINDEX] [int] NOT NULL,
	[F_STATUSONE] [int] NOT NULL,
	[F_STATUSTWO] [int] NOT NULL,
	[F_STATUSTHREE] [int] NOT NULL,
	[F_BRIGHT] [int] NOT NULL,
	[F_TEMPERATURE] [int] NOT NULL,
	[F_ADDRESS] [varchar](20) NOT NULL,
	[F_REMARK] [varchar](100) NULL,
	[F_ENABLEONE] [int] NOT NULL,
	[F_ENABLETWO] [int] NOT NULL,
	[F_ENABLETHREE] [int] NOT NULL,
	[F_READDATETIME] [datetime] NULL,
	[F_WRITEDATETIME] [datetime] NULL,
	[F_SHOPID] [varchar](10) NULL
) ON [PRIMARY]
END
GO