yunshuguanli.rar_VB SQL 系统_sql vb_vb 系统_yunshuguanli_运输

use master go if exists (select * from dbo.sysdatabases where name = 'Vehicle') drop database Vehicle GO create database Vehicle go use Vehicle go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[accident]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[accident] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[driver]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[driver] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[repair]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[repair] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[statistic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[statistic] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vehicle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[vehicle] GO CREATE TABLE [dbo].[accident] ( [sgid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [sgdriver] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [sgdate] [datetime] NOT NULL , [sgplace] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [sgreason] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [sgopp_id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [sgopp_dept] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [sgmode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [sgvalue] [numeric](10, 2) NULL , [sgmemo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[driver] ( [sjid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [sjname] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [sjsex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [sjbirthday] [datetime] NULL , [sjaddress] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [sjfirstdate] [datetime] NULL , [sjtype] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [sjbegin_date] [datetime] NULL , [sjend_date] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[repair] ( [wxid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [wxdate] [datetime] NOT NULL , [wxdept] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [wxcontent] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [wxprice] [numeric](10, 2) NULL , [wxslave] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [wxmemo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[statistic] ( [yyid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [yydriver] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [yybegin_date] [datetime] NOT NULL , [yyend_date] [datetime] NOT NULL , [yydistance] [numeric](8, 2) NULL , [yywaste] [numeric](8, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[vehicle] ( [clid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [clkind] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [clowner] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [clcode1] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [clcode2] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [clcode3] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [cltotal] [numeric](8, 2) NULL , [clpassenger] [numeric](2, 0) NULL , [clregist_date] [datetime] NULL , [clcertifi_date] [datetime] NULL , [clcolor] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , [cldriver] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO