createsystemavailabilities.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateSystemAvailabilities.sql
#  Description : 霸烙郴 阿辆 扁瓷甸狼 荤侩啊瓷咯何
#
###############################################################################

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

CREATE TABLE SystemAvailabilities (
  SystemKind	int(11)		NOT NULL default '0',
  Available		tinyint(1)	NOT NULL default '0',
  Description	varchar(50)	NOT NULL default '',

  PRIMARY KEY (SystemKind)
) TYPE=MyISAM;

# 单捞磐 持扁
INSERT INTO SystemAvailabilities VALUES (0,0,'SYSTEM_PARTY');
INSERT INTO SystemAvailabilities VALUES (1,0,'SYSTEM_GAMBLE');
INSERT INTO SystemAvailabilities VALUES (2,0,'SYSTEM_RANK_BONUS');
INSERT INTO SystemAvailabilities VALUES (3,0,'SYSTEM_ENCHANT');
INSERT INTO SystemAvailabilities VALUES (4,0,'SYSTEM_GUILD');
INSERT INTO SystemAvailabilities VALUES (5,0,'SYSTEM_MASTER_LAIR');
INSERT INTO SystemAvailabilities VALUES (6,0,'SYSTEM_PK_ZONE');
INSERT INTO SystemAvailabilities VALUES (7,0,'SYSTEM_MARKET');
INSERT INTO SystemAvailabilities VALUES (8,0,'SYSTEM_GRAND_MASTER_EFFECT');
INSERT INTO SystemAvailabilities VALUES (9,0,'SYSTEM_COUPLE');
INSERT INTO SystemAvailabilities VALUES (10,0,'SYSTEM_HOLY_LAND_WAR');
INSERT INTO SystemAvailabilities VALUES (11,0,'SYSTEM_GUILD_WAR');
INSERT INTO SystemAvailabilities VALUES (12,0,'SYSTEM_RACE_WAR');
INSERT INTO SystemAvailabilities VALUES (13,0,'SYSTEM_FLAG_WAR');
INSERT INTO SystemAvailabilities VALUES (999,1,'OpenDegree');
INSERT INTO SystemAvailabilities VALUES (888,100,'SkillLimit');