数据库初始脚本

新建查询，将下面的脚本执行：

CREATE database [GameDB]
GO
USE [GameDB]
GO

CREATE TABLE [Users](
	[id] [varchar](12),
	[name] [varchar](20),
	[pwd] [varchar](15) ,
	[note] [varchar](50),
	[photo] [image],
        CONSTRAINT [PK_Users] PRIMARY KEY ([id])
) 

CREATE TABLE [Category](
	[CategoryID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryName] [nchar](20) NOT NULL,
	[IsPayout] [bit] NOT NULL,
	[Remark] [varchar](50),
        CONSTRAINT [PK_Category] PRIMARY KEY ([CategoryID] ASC)
)

CREATE TABLE [Item](
	[ItemID] [int] IDENTITY(1,1) NOT NULL,
	[ItemName] [nchar](10) NOT NULL,
	[CategoryID] [int] NOT NULL,
	[Remark] [varchar](50),
        CONSTRAINT [PK_Item] PRIMARY KEY ([ItemID] ASC)
)

CREATE TABLE [List](
	[ListID] [int] IDENTITY(1,1) NOT NULL,
	[ItemID] [int],
	[TradeDate] [datetime] NOT NULL,
	[Explain] [nchar](20) NULL,
	[Amount] [float],
	[Remark] [varchar](50),
        CONSTRAINT [PK_List] PRIMARY KEY ([ListID] ASC)
)

insert Users