cq_tables.sql

魔域源代码需要的可以学习一下真么这么麻烦啊

# delay_ms - 0: for default delay.

# width - width of magic. 0-180 for degree of fan (sort 4), 0 for default.


#
# Table structure for table 'cq_magic'
#

CREATE TABLE cq_magic (
  id int(4) unsigned zerofill NOT NULL auto_increment,
  ownerid int(4) unsigned zerofill NOT NULL default '0000',
  type smallint(4) unsigned zerofill NOT NULL default '0000',
  level smallint(4) unsigned zerofill NOT NULL default '0000',
  exp int(4) unsigned zerofill NOT NULL default '0000',
  unlearn tinyint(1) unsigned zerofill NOT NULL default '0',
  old_level smallint(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY (id),
  KEY user_magic(ownerid)
) TYPE=MyISAM;


#
# Table structure for table 'cq_syndicate'
#

CREATE TABLE cq_syndicate (
  id int(4) unsigned zerofill NOT NULL auto_increment,
  name varchar(15) binary NOT NULL default '', 
  announce varchar(255) binary NOT NULL default '', 
  tenet varchar(255) binary NOT NULL default '', 
  member_title varchar(15) binary NOT NULL default '弟子', 
  leader_id int(4) unsigned zerofill NOT NULL default '0000',
  leader_name varchar(15) binary NOT NULL default '', 
  money int(4) zerofill NOT NULL default '0000',
  fealty_syn int(4) unsigned zerofill NOT NULL default '0000',
  del_flag tinyint(1) unsigned zerofill NOT NULL default '0',
  amount int(4) unsigned zerofill NOT NULL default '0000',
  enemy0 int(4) unsigned zerofill NOT NULL default '0000',
  enemy1 int(4) unsigned zerofill NOT NULL default '0000',
  enemy2 int(4) unsigned zerofill NOT NULL default '0000',
  enemy3 int(4) unsigned zerofill NOT NULL default '0000',
  enemy4 int(4) unsigned zerofill NOT NULL default '0000',
  ally0 int(4) unsigned zerofill NOT NULL default '0000',
  ally1 int(4) unsigned zerofill NOT NULL default '0000',
  ally2 int(4) unsigned zerofill NOT NULL default '0000',
  ally3 int(4) unsigned zerofill NOT NULL default '0000',
  ally4 int(4) unsigned zerofill NOT NULL default '0000',
  rank tinyint(1) unsigned zerofill NOT NULL default '0',
  saint tinyint(1) unsigned zerofill NOT NULL default '0',
  mantle tinyint(1) unsigned zerofill NOT NULL default '0',
  distime int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY (id),
  UNIQUE KEY name(name)
) TYPE=MyISAM;
# del_flag: delete by syndicate leader


#
# Table structure for table 'cq_synattr'
#

CREATE TABLE cq_synattr (
  id int(4) unsigned zerofill NOT NULL,
  syn_id int(4) unsigned zerofill NOT NULL default '0000',
  rank int(4) unsigned zerofill NOT NULL default '0000',
  proffer int(4) unsigned zerofill NOT NULL default '0000',
  title int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY (id)
) TYPE=MyISAM;


#
# Table structure for table 'cq_leaveword'
#

DROP TABLE IF EXISTS cq_leaveword;
CREATE TABLE cq_leaveword (
  id int(4) unsigned zerofill NOT NULL auto_increment,
  user_name char(15) binary NOT NULL default '未知',
  send_name char(15) binary NOT NULL default '未知',
  time char(15) binary NOT NULL default '00000000000000',
  words char(255) binary NOT NULL default '未命名',
  PRIMARY KEY (id),
  KEY user_name(user_name)
) TYPE=MyISAM;


#
# Table structure for table 'cq_bonus'
#

CREATE TABLE cq_bonus (
  serianumber char(15) binary NOT NULL default '未知',
  password char(15) binary NOT NULL default '未知',
  action int(4) unsigned zerofill NOT NULL default '0000',
  id int(4) unsigned zerofill NOT NULL auto_increment,
  PRIMARY KEY (id),
  UNIQUE KEY serianumber(serianumber)
) TYPE=MyISAM;


#
# Table structure for table 'cq_traptype'
#

DROP TABLE IF EXISTS cq_traptype;
CREATE TABLE cq_traptype (
  id int(4) unsigned zerofill NOT NULL,
  sort tinyint(3) unsigned zerofill NOT NULL default '0',
  look int(4) unsigned zerofill NOT NULL default '0000',
  action_id int(4) unsigned zerofill NOT NULL default '0000',
  level int(4) unsigned zerofill NOT NULL default '0000',
  attack_max int(4) unsigned zerofill NOT NULL default '0000',
  attack_min int(4) unsigned zerofill NOT NULL default '0000',
  dexterity int(4) unsigned zerofill NOT NULL default '0000',
  attack_speed int(4) unsigned zerofill NOT NULL default '1000',
  active_times int(4) unsigned zerofill NOT NULL default '0000',
  magic_type int(4) unsigned zerofill NOT NULL default '0000',
  magic_hitrate int(4) unsigned zerofill NOT NULL default '0100',
  size int(4) unsigned zerofill NOT NULL default '0000',
  atk_mode int(3) unsigned zerofill NOT NULL default '0001',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
insert cq_traptype values(1, 1,1091010,0,20,250,250,80,1000,0,1000,50,1,1);
insert cq_traptype values(2,10,1091010,0,20,25,25,80,1000,0,1000,50,7,1);

# sort:
	TRAPSORT_SYSTRAP	=1,					// 系统的陷阱，多次有效
	TRAPSORT_FIREWALL	=10,				// 火墙, 可由系统放置
# look - 0: invisible trap
# action_id - run action when active trap, only effect for TRAPSORT_SYSTRAP
# active_times - 0: forever effect
# magic_type - 0: hit by weapon mode
# atk_mode: 可叠加
	ATKMODE_USER		= 1,
	ATKMODE_MONSTER		= 2,
	ATKMODE_NOATTACK	= 4,				// 不攻击对象，只触发ACTION

CREATE TABLE cq_trap (
  id int(4) unsigned zerofill NOT NULL,
  type int(4) unsigned zerofill NOT NULL default '0000',
  look int(4) unsigned zerofill NOT NULL default '0000',
  owner_id int(4) unsigned zerofill NOT NULL default '0000',
  map_id int(4) unsigned zerofill NOT NULL default '0000',
  pos_x int(4) unsigned zerofill NOT NULL default '0000',
  pos_y int(4) unsigned zerofill NOT NULL default '0000',
  data int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
insert cq_trap values(990001,1,1091010,0,1002,404,400,0);
insert cq_trap values(990002,2,1091012,0,1002,439,400,0);

# id - 990001 ~ 999999
# look - 0: invisible trap


#
# Table structure for table 'cq_point_allot'
#

DROP TABLE IF EXISTS cq_point_allot;
CREATE TABLE cq_point_allot (
  id int(4) unsigned zerofill NOT NULL auto_increment,
  prof_sort int(4) unsigned zerofill NOT NULL default '0000',
  level int(4) unsigned zerofill NOT NULL default '0000',
  force int(4) unsigned zerofill NOT NULL default '0000',
  Speed int(4) unsigned zerofill NOT NULL default '0000',
  health int(4) unsigned zerofill NOT NULL default '0000',
  soul int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY  (id),
  UNIQUE KEY idx(prof_sort,level)
) TYPE=MyISAM;

INSERT cq_point_allot VALUES(0,0,0,0,0,0,0);


#
# Table structure for table 'cq_superman'
#

CREATE TABLE cq_superman (
  id int(4) unsigned zerofill NOT NULL,
  number int(4) unsigned zerofill NOT NULL default '0000',
  name varchar(15) binary NOT NULL default '--',
  PRIMARY KEY  (id),
  KEY number(number)
) TYPE=MyISAM;


#
# Table structure for table 'cq_config'
#

CREATE TABLE cq_config (
  id int(4) unsigned zerofill NOT NULL,
  name varchar(15) binary NOT NULL default '',
  data int(4) unsigned zerofill NOT NULL default '0000',
  string varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (id),
  KEY name(name)
) TYPE=MyISAM;


#
# Table structure for table 'cq_rebirth'
#

DROP TABLE IF EXISTS cq_rebirth;
CREATE TABLE cq_rebirth (
  id int(4) unsigned zerofill NOT NULL,
  need_prof int(4) unsigned zerofill NOT NULL default '0000',
  new_prof int(4) unsigned zerofill NOT NULL default '0000',
  need_level int(4) unsigned zerofill NOT NULL default '0000',
  new_level int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Table structure for table 'cq_dropitemrule'
#

DROP TABLE IF EXISTS cq_dropitemrule;
CREATE TABLE cq_dropitemrule(
	id int unsigned NOT NULL,
	RuleId int unsigned NOT NULL default '0',
	Chance int unsigned NOT NULL default '0',
	Item0 int unsigned NOT NULL default '0',
	Item1 int unsigned NOT NULL default '0',
	Item2 int unsigned NOT NULL default '0',
	Item3 int unsigned NOT NULL default '0',
	Item4 int unsigned NOT NULL default '0',
	Item5 int unsigned NOT NULL default '0',
	Item6 int unsigned NOT NULL default '0',
	Item7 int unsigned NOT NULL default '0',
	Item8 int unsigned NOT NULL default '0',
	Item9 int unsigned NOT NULL default '0',
	Item10 int unsigned NOT NULL default '0',
	Item11 int unsigned NOT NULL default '0',
	Item12 int unsigned NOT NULL default '0',
	Item13 int unsigned NOT NULL default '0',
	Item14 int unsigned NOT NULL default '0',

	PRIMARY KEY (id, RuleId)
) TYPE=MyISAM;


#
# Table structure for table 'cq_table'
#

DROP TABLE IF EXISTS cq_table;
CREATE TABLE cq_table (
  id int(4) unsigned zerofill NOT NULL auto_increment,
  npc_id int(4) unsigned zerofill NOT NULL default '0000',
  type int(4) unsigned zerofill NOT NULL default '0000',
  key_id int(4) unsigned zerofill NOT NULL default '0000',
  datastr varchar(255) binary NOT NULL default '', 
  data0 int(4) unsigned zerofill NOT NULL default '0000',
  data1 int(4) unsigned zerofill NOT NULL default '0000',
  data2 int(4) unsigned zerofill NOT NULL default '0000',
  data3 int(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY (id),
) TYPE=MyISAM;