createmoneytracelog.sql

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

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateMoneyTraceLog.sql
#  Description : 捣肺弊
#
#  History
# ------------ -------------- -----------------------------------------------
###############################################################################

# 抛捞喉 积己 
CREATE TABLE MoneyTraceLog (
	PreOwnerID	char(10)														NOT NULL default '',
	OwnerID		char(10)														NOT NULL default '',
	LogType		enum('CREATE','TRADE','DELETE','MOVE','NONE') 					NOT NULL default 'NONE',
	DetailType	enum('COMMAND', 'DROP', 'PICKUP', 'TRADE', 'TIMEOUT', 'ETC' )	NOT NULL default 'ETC',
	Amount		int(10) 														UNSIGNED default 0,
	Time		datetime														NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

# 牢郸胶 积己