prodb.sql

来自「JSP工程应用与项目实践」· SQL 代码 · 共 53 行

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

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

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

CREATE TABLE [dbo].[associator] (
	[用户id] [int] IDENTITY (1, 1) NOT NULL ,
	[用户名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[密码] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[电子邮件] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[真实姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[性别] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[年龄] [int] NULL ,
	[权限] [int] NULL ,
	[在线] [int] NULL ,
	[个人主页] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[自我介绍] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[stat] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[q1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[q2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[q3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[zz] (
	[姓名] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[性别] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[电子邮件] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[网页地址] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[留言主题] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[留言内容] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[stat] WITH NOCHECK ADD 
	CONSTRAINT [PK_stat] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO