数据库.sql

企业客户管理信息系统 企业管理信息系统的对象是企业、企业化管理的事业单位。 客户管理系统为企事业单位提供保存信息、修改信息、信息咨询等服务。 传统的纸介材料的数据信息管理已经不适合当代企业公司的发

use master
go

if exists (select * from dbo.sysdatabases where name = 'Trade') 
drop database Trade
GO

create database Trade
go
use Trade
go


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[suppliers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[suppliers]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[user_Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kk_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kk_Info]
GO

CREATE TABLE [dbo].[suppliers] (
	[SupplierID] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CompanyName] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ContactName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Region] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostalCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SupplierMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[kk] (
	[SupplierID] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CompanyName] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ContactName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Region] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostalCode] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SupplierMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[user_Info] (
	[user_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_PWD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
) ON [PRIMARY]
GO

use Trade
INSERT INTO user_info
VALUES (1,1);