palycard.sql

来自「包包版网络游戏大厅和网络桥牌系统」· SQL 代码 · 共 42 行

CREATE DATABASE [PlayCard2]

use [PlayCard2]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PlayerList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PlayerList]
GO

CREATE TABLE [dbo].[PlayerList] (
	[UserID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[isLogin] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ImageIndex] [int] NOT NULL ,
	[Port] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Score] [int] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PlayerList] WITH NOCHECK ADD 
	CONSTRAINT [PK_PlayerList] PRIMARY KEY  CLUSTERED 
	(
		[UserID]
	)  ON [PRIMARY] 
GO

Insert into PlayerList(UserID, UserName, Password, isLogin, ImageIndex, Port, Score)
values('jax',N'包包','1','0',1,'5153',100)

Insert into PlayerList(UserID, UserName, Password, isLogin, ImageIndex, Port, Score)
values('DX',N'丁学','1','0',2,'5152',100)

Insert into PlayerList(UserID, UserName, Password, isLogin, ImageIndex, Port, Score)
values('Jeffrey1',N'老赵','1','0',5,'5156',100)

Insert into PlayerList(UserID, UserName, Password, isLogin, ImageIndex, Port, Score)
values('Anders',N'Anders Liu','1','0',3,'5154',100)

Insert into PlayerList(UserID, UserName, Password, isLogin, ImageIndex, Port, Score)
values('Kitty',N'贾姐姐','1','0',4,'5155',100)