几天写了个sql 郁闷半天哦 有错却找不出 首先是用txt写的
if exists(select * from sysdatabase where name=N'DBNews')
drop database DBNews
Go
create database DBNews
go
use DBNews
go
if exists(select * from sysobjects where id=object_id(N'[dbo].[db_admin]') and objectproperty(id,N'IsUserTable')=1)
drop table [dbo].[db_admin]
go
if exists(select * from sysobjects where id=object_id(N'[dbo].[db_news]') and objectproperty(id,N'IsUserTable')=1)
drop table [dbo].[db_news]
go
if exists(select * from sysobjects where id=object_id(N'[dbo].[db_class]') and objectproperty(id,N'IsUserTable')=1)
drop table [dbo].[db_class]
go
if exists(select * from sysobjects where id=object_id(N'[dbo].[db_comment]') and objectproperty(id,N'IsUserTable')=1)
drop table [dbo].[db_comment]
go
if exists(select * from sysobjects where id=object_id(N'[dbo].[db_upfile]') and objectproperty(id,N'IsUserTable')=1)
drop table [dbo].[db_upfile]
go
--创建管理员表
create table [dbo].[db_admin]
(
[userid] [int] identity(1,1) primary key, --用户ID
[username] [varchar](50) NOT NULL,--用户名
[password] [varchar](20) NOT NULL,--密码
[userclass] [text] ,--用户等级
[remark] [text],--备注
[popedom] [varchar](20) NOT NULL,--权限
[classname] [varchar](250), --分类 对哪一类进行管理 是All为全部 否则就为新闻类别名称
[addnum] [int] default 0--添加新闻数
)
go
--创建新闻类别表
create table [dbo].[db_class]
(
[classid] [int] identity(1,1) primary key,-- 分类编号
[classname] [varchar] (250),--分类名称
[newsnum] [int] default 0,-- 总新闻数
[dataandtime] [datetime] default getdate()--添加时间
)
go
--创建新闻表
create table [dbo].[db_news]
(
[newid] [int] identity(1,1) primary key,
[title] [varchar] (250) NOT NULL,
[content] [text] NOT NULL,
[classid] [int] foreign key references [dbo].[db_class]([classid]),
[userid] foreign key references [dbo].[db_admin]([userid]),
[headline] [smallint] ,
[highlight] [smallint],
[summary] [text],
[NKey] [text],--相关新闻
[writer] [varchar] (50),--作者
[source] [varchar] (250),--来源
[hints] [int] default 0,--点击数
[dateandtime] [datetime] default getdate(),
[popedom] [varchar] (20),--发布者权限
[isaudit] [smallint] default 0 --是否审核
)
go
create table db_commnet
(
commnetid [int] identity(1,1) primary key,
[username] [varchar] (250),
[body] [text],
[dateandtime] [datetime] default 0,
[ip] [varchar] [20]
)
go
create table db_upfile
(
[id] [int] identity(1,1) primary key,
[name] [varchar] (250),
[path] [varchar] (250),
[userid] [int] foreign key references [dbo].[db_admin]([userid])
[newsid] [int] foreign key references [dbo].[db_news]([newsid]),
[dateandtime] [datetime] default getdate()
)
半天之后 我快郁闷死,发现老是提示' '出错 原来是空格错了 我用了全角空格,sql只能用半角空格
哎 郁闷死