createpcroompaylist.sql

来自「天之炼狱OpenDE_SQL.tar.gz」· SQL 代码 · 共 30 行

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreatePCRoomPayList.sql
#  Description : 
#
#  History
# ------------ -------------- -----------------------------------------------
# 2003.08.26     全惑刮        脚痹 颇老 积己 
###############################################################################

# 抛捞喉 积己 

#DROP TABLE IF EXISTS PCRoomPayList;

CREATE TABLE PCRoomPayList (
	PCRoomID		int(10) unsigned		NOT NULL default '0',
	Year			int(10) unsigned		NOT NULL default '0',
	Month			int(10) unsigned		NOT NULL default '0',
	PayPlayMinute	int(10) unsigned		NOT NULL default '0'

) TYPE=MyISAM;

CREATE INDEX PCRoomPayList_IDX1 ON PCRoomPayList(PCRoomID);
CREATE INDEX PCRoomPayList_IDX2 ON PCRoomPayList(Year);
CREATE INDEX PCRoomPayList_IDX3 ON PCRoomPayList(Month);