【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-prodb.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
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