STMS.rar_stms_生产 跟踪_生产管理

/****** Object: Database stmsdb Script Date: 2007-10-24 0:14:50 ******/ IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'stmsdb') DROP DATABASE [stmsdb] GO CREATE DATABASE [stmsdb] ON (NAME = N'stmsdb_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\stmsdb_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'stmsdb_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\stmsdb_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) GO exec sp_dboption N'stmsdb', N'autoclose', N'true' GO exec sp_dboption N'stmsdb', N'bulkcopy', N'false' GO exec sp_dboption N'stmsdb', N'trunc. log', N'true' GO exec sp_dboption N'stmsdb', N'torn page detection', N'true' GO exec sp_dboption N'stmsdb', N'read only', N'false' GO exec sp_dboption N'stmsdb', N'dbo use', N'false' GO exec sp_dboption N'stmsdb', N'single', N'false' GO exec sp_dboption N'stmsdb', N'autoshrink', N'true' GO exec sp_dboption N'stmsdb', N'ANSI null default', N'false' GO exec sp_dboption N'stmsdb', N'recursive triggers', N'false' GO exec sp_dboption N'stmsdb', N'ANSI nulls', N'false' GO exec sp_dboption N'stmsdb', N'concat null yields null', N'false' GO exec sp_dboption N'stmsdb', N'cursor close on commit', N'false' GO exec sp_dboption N'stmsdb', N'default to local cursor', N'false' GO exec sp_dboption N'stmsdb', N'quoted identifier', N'false' GO exec sp_dboption N'stmsdb', N'ANSI warnings', N'false' GO exec sp_dboption N'stmsdb', N'auto create statistics', N'true' GO exec sp_dboption N'stmsdb', N'auto update statistics', N'true' GO use [stmsdb] GO /****** Object: Table [dbo].[工单ST制造确认信息] Script Date: 2007-10-24 0:14:53 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工单ST制造确认信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工单ST制造确认信息] GO /****** Object: Table [dbo].[工单ST品质确认信息] Script Date: 2007-10-24 0:14:53 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工单ST品质确认信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[工单ST品质确认信息] GO /****** Object: Table [dbo].[文控录入信息] Script Date: 2007-10-24 0:14:53 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[文控录入信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[文控录入信息] GO /****** Object: Table [dbo].[生管工单ST录入信息] Script Date: 2007-10-24 0:14:53 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生管工单ST录入信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[生管工单ST录入信息] GO /****** Object: Table [dbo].[用户清单] Script Date: 2007-10-24 0:14:53 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户清单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户清单] GO /****** Object: User dbo Script Date: 2007-10-24 0:14:51 ******/ /****** Object: Table [dbo].[工单ST制造确认信息] Script Date: 2007-10-24 0:14:54 ******/ CREATE TABLE [dbo].[工单ST制造确认信息] ( [条目号] [int] IDENTITY (1, 1) NOT NULL , [工单编号] [char] (10) NOT NULL , [工单对应ST执行情况] [char] (8) NOT NULL , [工单对应ST改造线别] [char] (8) NOT NULL , [工单制造确认时间] [datetime] NOT NULL , [工单制造确认人] [char] (8) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[工单ST品质确认信息] Script Date: 2007-10-24 0:14:55 ******/ CREATE TABLE [dbo].[工单ST品质确认信息] ( [条目号] [int] IDENTITY (1, 1) NOT NULL , [工单编号] [char] (10) NOT NULL , [工单品质确认时间] [datetime] NOT NULL , [工单品质确认人] [char] (8) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[文控录入信息] Script Date: 2007-10-24 0:14:55 ******/ CREATE TABLE [dbo].[文控录入信息] ( [条目号] [bigint] IDENTITY (1, 1) NOT NULL , [ST编号] [char] (20) NOT NULL , [发行日期] [datetime] NOT NULL , [ST标题] [char] (1000) NOT NULL , [ST内容概要] [varchar] (8000) NOT NULL , [ST执行性质] [char] (8) NOT NULL , [对应机种] [char] (1000) NOT NULL , [对应工单数量] [char] (300) NULL , [开始执行日期] [da�