书上有个文件管理器的简单例子。脚本文件的内容我放到mdf文件的新建查询里运行了一下,总是出错,两个表的脚本都出错。特别是tblFile的最后一个ALTER TABLE。请问这两个脚本文件怎么改才能让VS2015的数据库达到书上的脚本的效果?
tblUser的内容:
CREATE TABLE tblUser
(
UserID VARCHAR(50) NOT NULL,
UserName VARCHAR(10) NOT NULL,
UserPassword VARCHAR(50) NOT NULL,
UserMail VARCHAR(50) NOT NULL,
UserType INTEGER DEFAULT (0),
UserCreated DATETIME DEFAULT (getdate()) NOT NULL
);
GO
CREATE INDEX PK_tblUser ON tblUser (UserID ASC);
GO
ALTER TABLE tblUser ADD CONSTRAINT PK_tblUser PRIMARY KEY (UserID);
GO
tblFile的内容:
CREATE TABLE tblFile (
FileID BIGINT NOT NULL,
FileName VARCHAR(255) NOT NULL,
FilePath VARCHAR(255) NOT NULL,
FileType VARCHAR(10),
FileOwner VARCHAR(50) NOT NULL,
FileCreated DATETIME DEFAULT (getdate()) NOT NULL,
FileSubject VARCHAR(100) NOT NULL
);
GO
CREATE INDEX PK_tblFile ON tblFile (FileID ASC);
GO
CREATE UNIQUE INDEX IX_tblFile ON tblFile (FileOwner ASC);
GO
ALTER TABLE tblFile ADD CONSTRAINT PK_tblFile PRIMARY KEY (FileID);
GO
ALTER TABLE tblFile ADD CONSTRAINT FK_tblFile_tblUser FOREIGN KEY (FileOwner)
REFERENCES tblUser (UserID)
ON DELETE RESTRICT
ON UPDATE RESTRICT
GO
问题解决了,使用以下脚本就执行成功了。
if OBJECT_ID('tblFile') is not null
drop table tblFile
if OBJECT_ID('tblUser') is not null
drop table tblUser
go
-- 以上不用管,重点看一下注释掉的那几行 。
CREATE TABLE tblUser
(
UserID VARCHAR(50) NOT NULL,
UserName VARCHAR(10) NOT NULL,
UserPassword VARCHAR(50) NOT NULL,
UserMail VARCHAR(50) NOT NULL,
UserType INTEGER DEFAULT (0),
UserCreated DATETIME DEFAULT (getdate()) NOT NULL
);
GO
--CREATE INDEX PK_tblUser ON tblUser (UserID ASC);
GO
ALTER TABLE tblUser ADD CONSTRAINT PK_tblUser PRIMARY KEY (UserID);
GO
CREATE TABLE tblFile (
FileID BIGINT NOT NULL,
FileName VARCHAR(255) NOT NULL,
FilePath VARCHAR(255) NOT NULL,
FileType VARCHAR(10),
FileOwner VARCHAR(50) NOT NULL,
FileCreated DATETIME DEFAULT (getdate()) NOT NULL,
FileSubject VARCHAR(100) NOT NULL
);
GO
--CREATE INDEX PK_tblFile ON tblFile (FileID ASC);
GO
CREATE UNIQUE INDEX IX_tblFile ON tblFile (FileOwner ASC);
GO
ALTER TABLE tblFile ADD CONSTRAINT PK_tblFile PRIMARY KEY (FileID);
GO
ALTER TABLE tblFile ADD CONSTRAINT FK_tblFile_tblUser FOREIGN KEY (FileOwner)
REFERENCES tblUser (UserID)
--ON DELETE RESTRICT
--ON UPDATE RESTRICT
GO