/****** Object: Database hyln Script Date: 2008-6-21 15:01:54 ******/IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'hyln')DROP DATABASE [hyln]GOCREATE DATABASE [hyln] ON (NAME = N'xzCloth_Data', FILENAME = N'E:/Db/hy0831_Data.MDF' , SIZE = 40, FILEGROWTH = 10%) LOG ON (NAME = N'xzCloth_Log', FILENAME = N'E:/Db/hy0831_log.LDF' , FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_ASGOexec sp_dboption N'hyln', N'autoclose', N'false'GOexec sp_dboption N'hyln', N'bulkcopy', N'false'GOexec sp_dboption N'hyln', N'trunc. log', N'true'GOexec sp_dboption N'hyln', N'torn page detection', N'false'GOexec sp_dboption N'hyln', N'read only', N'false'GOexec sp_dboption N'hyln', N'dbo use', N'false'GOexec sp_dboption N'hyln', N'single', N'false'GOexec sp_dboption N'hyln', N'autoshrink', N'true'GOexec sp_dboption N'hyln', N'ANSI null default', N'false'GOexec sp_dboption N'hyln', N'recursive triggers', N'false'GOexec sp_dboption N'hyln', N'ANSI nulls', N'false'GOexec sp_dboption N'hyln', N'concat null yields null', N'false'GOexec sp_dboption N'hyln', N'cursor close on commit', N'false'GOexec sp_dboption N'hyln', N'default to local cursor', N'false'GOexec sp_dboption N'hyln', N'quoted identifier', N'false'GOexec sp_dboption N'hyln', N'ANSI warnings', N'false'GOexec sp_dboption N'hyln', N'auto create statistics', N'true'GOexec sp_dboption N'hyln', N'auto update statistics', N'true'GOuse [hyln]GO/****** Object: Table [dbo].[tbCheckWorks] Script Date: 2008-6-21 15:01:54 ******/if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbCheckWorks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[tbCheckWorks]GO/****** Object: Table [dbo].[tbWorkPlan] Script Date: 2008-6-21 15:01:54 ******/if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbWorkPlan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[tbWorkPlan]GO/****** Object: Table [dbo].[tbWorkPlanItem] Script Date: 2008-6-21 15:01:54 ******/if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbWorkPlanItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[tbWorkPlanItem]GO/****** Object: User guest Script Date: 2008-6-21 15:01:54 ******/if not exists (select * from dbo.sysusers where name = N'guest' and uid < 16382 and hasdbaccess = 1)EXEC sp_grantdbaccess N'guest'GO/****** Object: Table [dbo].[tbCheckWorks] Script Date: 2008-6-21 15:01:54 ******/CREATE TABLE [dbo].[tbCheckWorks] ([BillNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[TheDate] [datetime] NOT NULL ,[TheName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[OnCheckStartTime] [datetime] NOT NULL ,[OnCheckEndTime] [datetime] NOT NULL ,[OnCheckLateTime] [datetime] NOT NULL ,[OffCheckEarlyTime] [datetime] NOT NULL ,[OffCheckTime] [datetime] NOT NULL ,[OffCheckEndTime] [datetime] NOT NULL ,[OnDutySalaryRate] [float] NOT NULL ,[OffDutySalaryRate] [float] NOT NULL ,[LateSalaryRate] [float] NOT NULL ,[OffEarlySalaryRate] [float] NOT NULL ,[OffLateSalaryType] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,[Remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[TheState] [int] NOT NULL ,[Creater] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[CreateTime] [datetime] NULL ,[Stater] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[StateTime] [datetime] NULL ,[Editer] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[EditeTime] [datetime] NULL ,[History] [image] NULL ,[UseState] [int] NOT NULL ,[PrintCount] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO/****** Object: Table [dbo].[tbWorkPlan] Script Date: 2008-6-21 15:01:55 ******/CREATE TABLE [dbo].[tbWorkPlan] ([BillNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[TheDate] [datetime] NOT NULL ,[AllUsers] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[UserGroupCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,[UserCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,[Remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[TheState] [int] NOT NULL ,[Creater] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[CreateTime] [datetime] NULL ,[Stater] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[StateTime] [datetime] NULL ,[Editer] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[EditeTime] [datetime] NULL ,[History] [image] NULL ,[UseState] [int] NOT NULL ,[PrintCount] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO/****** Object: Table [dbo].[tbWorkPlanItem] Script Date: 2008-6-21 15:01:55 ******/CREATE TABLE [dbo].[tbWorkPlanItem] ([BillNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[RowNo] [int] NOT NULL ,[CheckWorkNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StartTime] [datetime] NOT NULL ,[EndTime] [datetime] NOT NULL ,[IsCircle] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,[CircleNo] [int] NOT NULL ,[CircleUnit] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,[Remark] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOALTER TABLE [dbo].[tbCheckWorks] WITH NOCHECK ADD CONSTRAINT [PK_tbCheckWorks] PRIMARY KEY CLUSTERED ([BillNo]) ON [PRIMARY] GOALTER TABLE [dbo].[tbWorkPlan] WITH NOCHECK ADD CONSTRAINT [PK_tbWorkPlan] PRIMARY KEY CLUSTERED ([BillNo]) ON [PRIMARY] GOALTER TABLE [dbo].[tbWorkPlanItem] WITH NOCHECK ADD CONSTRAINT [PK_tbWorkPlanItem] PRIMARY KEY CLUSTERED ([BillNo],[RowNo]) ON [PRIMARY] GOALTER TABLE [dbo].[tbCheckWorks] WITH NOCHECK ADD CONSTRAINT [DF_tbCheckWorks_OffLateSalaryType] DEFAULT ('工资乘*系数') FOR [OffLateSalaryType]GOALTER TABLE [dbo].[tbWorkPlan] WITH NOCHECK ADD CONSTRAINT [DF__tbWorkPla__AllUs__4A905FC3] DEFAULT ('否') FOR [AllUsers],CONSTRAINT [DF__tbWorkPla__UserG__4B8483FC] DEFAULT (0) FOR [UserGroupCode],CONSTRAINT [DF__tbWorkPla__UserC__4C78A835] DEFAULT (0) FOR [UserCode]GOALTER TABLE [dbo].[tbWorkPlanItem] WITH NOCHECK ADD CONSTRAINT [DF__tbWorkPla__Start__4E60F0A7] DEFAULT (getdate()) FOR [StartTime],CONSTRAINT [DF__tbWorkPla__EndTi__4F5514E0] DEFAULT (getdate()) FOR [EndTime],CONSTRAINT [DF__tbWorkPla__IsCir__50493919] DEFAULT ('否') FOR [IsCircle],CONSTRAINT [DF__tbWorkPla__Circl__513D5D52] DEFAULT (1) FOR [CircleNo],CONSTRAINT [DF__tbWorkPla__Circl__5231818B] DEFAULT ('周') FOR [CircleUnit]GOexec sp_addextendedproperty N'MS_Description', N'迟到早退工资处理方式', N'user', N'dbo', N'table', N'tbCheckWorks', N'column', N'OffLateSalaryType'GO
