create_tbl_serverinfo.sql

来自「传奇的SQL版本的数据文件非DBC的文件使用SQL版本的可以用的到」· SQL 代码 · 共 31 行

/* **************************************************************************
	
	Create Database for Legend of Mir 2

	All written by Euy-heon, Jeong
	Copyright (C) 2001 Wemade Entertainment. All rights reserved.

   *************************************************************************** */

USE LEGENDOFMIR
GO

DROP TABLE TBL_SERVERINFO
GO

/* 
	Server Information Table 
*/

CREATE TABLE TBL_SERVERINFO
(
	FLD_SERVERIDX		INT		IDENTITY(0, 1),
	FLD_SERVERNAME	NCHAR(40)	NOT NULL,
	FLD_SERVERIP		NCHAR(20)	NOT NULL
)
GO

ALTER TABLE TBL_SERVERINFO ADD CONSTRAINT PK_SERVERINFO PRIMARY KEY (FLD_SERVERIDX)
GO