createitemtracelog.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateItemTraceLog.sql
#  Description : 
#
#  History
# ------------ -------------- -----------------------------------------------
###############################################################################

# 抛捞喉 积己 
DROP TABLE IF EXISTS ItemTraceLog;

CREATE TABLE ItemTraceLog (
	ItemID		bigint(20) unsigned									NOT NULL default 0,
	ItemClass	char(25)											NOT NULL default '',
	ItemType	tinyint(3) unsigned									NOT NULL default 0,
	OptionType	varchar(30)											NOT NULL default '',
	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', 'SHOPBUY', 'PICKUP', 'EVENTNPC',
					 'SHOPSELL', 'TIMEOUT', 'ENCHANT', 'OPCLEAR',
					 'DROP', 'TRADE', 'ETC' ) 						NOT NULL default 'ETC',
	Time		datetime											NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

# 牢郸胶 积己