技术类

http://www.yuanma.org/data/2007/1214/article_2924.htm
http://www.vdisk.cn/user/admin/ghbullor
USE [cm]
GO
/****** 对象:  Table [dbo].[Company]    脚本日期: 06/12/2010 23:59:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Company](
[CompanyId] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CompanyName] [nvarchar](80) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Management] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[City] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Fax] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Character] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
USE [cm]
GO
/****** 对象:  Table [dbo].[Customer]    脚本日期: 06/13/2010 00:00:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustomerId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CompanyId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[ProductId] [varchar](30) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CustomerName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Tel] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Address] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[EMail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ProductName] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[ProductSpec] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL,
[ProductAmount] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ModelType] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Price] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Currency] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[Supply] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[Position] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

评论

1 楼 ghbullor 2010-06-11  

USE [cm]
GO
/****** 对象:  Table [dbo].[Customer]    脚本日期: 06/11/2010 16:40:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustomerId] [varchar](30) NOT NULL,
[CompanyId] [varchar](30) NOT NULL CONSTRAINT [DF_Customer_CompanyId]  DEFAULT ('Company.companyId'),
[ProductId] [varchar](30) NOT NULL,
[CustomerName] [varchar](100) NULL,
[Tel] [nvarchar](20) NULL,
[Address] [varchar](100) NULL,
[EMail] [varchar](50) NULL,
[ProductName] [varchar](100) NULL,
[ProductSpec] [varchar](200) NULL,
[ProductAmount] [varchar](50) NULL,
CONSTRAINT [PK_Customer_1] PRIMARY KEY CLUSTERED
(
[CustomerId] ASC,
[CompanyId] ASC,
[ProductId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


USE [cm]
GO
/****** 对象:  Table [dbo].[Company]    脚本日期: 06/11/2010 16:40:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Company](
[CompanyId] [nvarchar](20) NOT NULL,
[CompanyName] [nvarchar](80) NULL,
[Address] [nvarchar](100) NULL,
[Tel] [nvarchar](20) NULL
) ON [PRIMARY]