create_tbl_stditem_etc.sql
上传用户:szopptop
上传日期:2013-04-23
资源大小:1047k
文件大小:1k
源码类别:
模拟服务器
开发平台:
Visual C++
- /* **************************************************************************
- 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_STDITEM_ETC
- GO
- /*
- Standard General Item
- */
- CREATE TABLE TBL_STDITEM_ETC
- (
- FLD_INDEX INT NOT NULL,
- FLD_NAME VARCHAR(20) NOT NULL,
- FLD_STDMODE SMALLINT NULL,
- FLD_SHAPE SMALLINT NULL,
- FLD_LOOKS INT NULL,
- FLD_WEIGHT SMALLINT NULL,
- FLD_PRICE INT NULL,
- FLD_VAL1 INT NULL,
- FLD_VAL2 INT NULL,
- )
- GO
- ALTER TABLE TBL_STDITEM_ETC ADD CONSTRAINT PK_STDITEM_ETC PRIMARY KEY (FLD_INDEX)
- GO