书上针对SQL Server 2000的DDL在VS2015的数据库里执行出错，怎么改？

Question

书上有个文件管理器的简单例子。脚本文件的内容我放到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

Answer 1

问题解决了，使用以下脚本就执行成功了。

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