wog3_sql_big5.sql

WEBGAME源码,有架设说明,只是非常简单

# MySQL-Front 3.2  (Build 13.39)


# Host: localhost    Database: test456
# ------------------------------------------------------
# Server version 4.0.24-nt

#
# Table structure for table wog_ch_exp
#

DROP TABLE IF EXISTS `wog_ch_exp`;
CREATE TABLE `wog_ch_exp` (
  `p_id` int(10) unsigned NOT NULL default '0',
  `ch_6` smallint(4) unsigned NOT NULL default '0',
  `ch_7` smallint(4) unsigned NOT NULL default '0',
  `ch_8` smallint(4) unsigned NOT NULL default '0',
  `ch_9` smallint(4) unsigned NOT NULL default '0',
  `ch_10` smallint(4) unsigned NOT NULL default '0',
  `ch_11` smallint(4) unsigned NOT NULL default '0',
  `ch_12` smallint(4) unsigned NOT NULL default '0',
  `ch_13` smallint(4) unsigned NOT NULL default '0',
  `ch_14` smallint(4) unsigned NOT NULL default '0',
  `ch_15` smallint(4) unsigned NOT NULL default '0',
  `ch_16` smallint(4) unsigned NOT NULL default '0',
  `ch_17` smallint(4) unsigned NOT NULL default '0',
  `ch_18` smallint(4) unsigned NOT NULL default '0',
  `ch_19` smallint(4) unsigned NOT NULL default '0',
  `ch_20` smallint(4) unsigned NOT NULL default '0',
  `ch_21` smallint(4) unsigned NOT NULL default '0',
  `ch_22` smallint(4) unsigned NOT NULL default '0',
  `ch_23` smallint(4) unsigned NOT NULL default '0',
  `ch_24` smallint(4) unsigned NOT NULL default '0',
  `ch_25` smallint(4) unsigned NOT NULL default '0',
  `ch_26` smallint(4) unsigned NOT NULL default '0',
  `ch_27` smallint(4) unsigned NOT NULL default '0',
  `ch_28` smallint(4) unsigned NOT NULL default '0',
  `ch_29` smallint(4) unsigned NOT NULL default '0',
  `ch_30` smallint(4) unsigned NOT NULL default '0',
  `ch_31` smallint(4) unsigned NOT NULL default '0',
  `ch_32` smallint(4) unsigned NOT NULL default '0',
  `ch_33` smallint(4) unsigned NOT NULL default '0',
  `ch_34` smallint(4) unsigned NOT NULL default '0',
  `ch_35` smallint(4) unsigned NOT NULL default '0',
  `ch_36` smallint(4) unsigned NOT NULL default '0',
  `ch_37` smallint(5) unsigned NOT NULL default '0',
  `ch_38` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`p_id`),
  KEY `p_id` (`p_id`)
) TYPE=MyISAM;

#
# Dumping data for table wog_ch_exp
#

INSERT INTO `wog_ch_exp` VALUES (1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

#
# Table structure for table wog_character
#

DROP TABLE IF EXISTS `wog_character`;
CREATE TABLE `wog_character` (
  `ch_id` int(11) NOT NULL auto_increment,
  `ch_name` varchar(30) NOT NULL default '',
  `ch_str` char(3) NOT NULL default '0',
  `ch_agl` char(3) NOT NULL default '0',
  `ch_life` char(3) NOT NULL default '0',
  `ch_vit` char(3) NOT NULL default '0',
  `ch_smart` char(3) NOT NULL default '0',
  `ch_mstr` smallint(5) unsigned NOT NULL default '0',
  `ch_magl` smallint(5) unsigned NOT NULL default '0',
  `ch_msmart` smallint(5) unsigned NOT NULL default '0',
  `ch_mlv` smallint(5) unsigned NOT NULL default '0',
  `ch_mlife` smallint(5) unsigned NOT NULL default '0',
  `ch_au` char(3) NOT NULL default '0',
  `ch_be` char(3) NOT NULL default '0',
  `s_at` float unsigned NOT NULL default '1',
  `s_df` float unsigned NOT NULL default '1',
  `s_mat` float unsigned NOT NULL default '1',
  `s_mdf` float unsigned NOT NULL default '1',
  `s_agl` float unsigned NOT NULL default '1',
  `s_money` float unsigned NOT NULL default '1',
  `s_r` tinyint(2) unsigned NOT NULL default '0',
  `s_o` tinyint(2) unsigned NOT NULL default '0',
  `s_s` tinyint(2) unsigned NOT NULL default '0',
  `s_a` tinyint(2) unsigned NOT NULL default '0',
  `s_m_at` float unsigned NOT NULL default '1',
  `s_m_df` float unsigned NOT NULL default '1',
  `s_m_mdf` float unsigned NOT NULL default '1',
  `s_m_mat` float unsigned NOT NULL default '1',
  `s_m_agl` float unsigned NOT NULL default '1',
  `s_hp` float unsigned NOT NULL default '0',
  PRIMARY KEY  (`ch_id`)
) TYPE=MyISAM;

#
# Dumping data for table wog_character
#

INSERT INTO `wog_character` VALUES (6,'战士','1,4','0,1','0,2','0,1','0,1',0,0,0,1,0,'0,1','0,1',1,1.2,1,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (7,'术士','0,1','0,1','0,2','0,1','1,4',0,0,0,1,0,'0,1','0,2',1,1,1.2,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (8,'盗贼','0,3','1,3','0,2','0,1','0,1',0,0,0,1,0,'0,1','0,1',1,1,1,1,1,1.2,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (9,'武道家','1,4','0,2','0,2','0,1','0,1',20,10,10,10,0,'0,1','0,1',1,1,1,1,1,1,0,0,10,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (10,'法师','0,2','1,2','0,2','0,1','1,4',8,10,20,10,0,'0,1','1,2',1,1,1,1,1,1,0,0,0,0,1,1,0.8,1,1,0);
INSERT INTO `wog_character` VALUES (11,'弓箭手','1,3','1,3','0,2','0,1','1,2',15,20,10,10,0,'0,1','0,1',1,1,1,1,1,1,10,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (12,'见习骑士','1,3','1,2','1,2','0,2','0,2',30,15,10,15,0,'0,1','0,1',1,1,1,1,1,1,5,5,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (13,'上乘射手','1,3','2,3','0,3','0,2','1,2',29,45,0,25,0,'0,2','0,2',1,1,1,1,1,1,0,0,0,3,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (14,'祭师','0,2','1,3','0,2','0,2','2,4',0,28,51,25,0,'0,2','1,3',1,1,1,1,1,1,0,0,0,0,1,1,1,1,1,0.1);
INSERT INTO `wog_character` VALUES (15,'武技长','2,4','0,3','1,3','1,2','0,2',52,28,0,25,0,'0,2','0,1',1.2,1,1,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (16,'杀手','1,3','2,4','1,2','0,2','1,2',40,78,28,52,0,'0,2','0,2',1,1,1,1,1,1,0,10,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (17,'巫师','0,2','1,3','0,2','0,2','2,5',28,30,80,52,0,'0,2','1,3',1,1,1.2,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (18,'斗士','2,5','0,3','1,3','1,3','0,2',84,38,0,52,90,'0,2','0,1',1,1,1,1,1,1,0,0,0,0,1,0.8,1,1,1,0);
INSERT INTO `wog_character` VALUES (19,'游侠','2,3','2,3','0,2','0,2','1,3',91,101,50,85,0,'0,3','0,3',1,1,1,1,1,1,0,0,0,0,1,1,1,1,0.8,0);
INSERT INTO `wog_character` VALUES (20,'妖师','0,3','1,3','1,2','1,2','2,5',30,70,110,85,0,'0,3','1,3',1,1,1,1,1,1,0,0,0,0,1,1,1,0.8,1,0);
INSERT INTO `wog_character` VALUES (21,'勇者','2,3','2,3','1,3','2,2','1,2',350,350,350,250,350,'1,4','1,3',1.1,1.1,1.1,1.1,1.1,1,0,0,0,1,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (22,'神偷','1,4','2,5','1,2','1,2','1,3',120,180,80,130,90,'1,2','0,3',1,1,1,1,1,1,20,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (23,'主教','1,2','1,4','1,2','1,3','2,4',70,80,180,130,70,'0,3','1,4',1,1,1,1,1,1,0,0,0,0,1,1,1,1,1,0.15);
INSERT INTO `wog_character` VALUES (24,'领主','2,6','0,3','1,4','2,3','1,2',180,120,70,130,160,'1,2','0,3',1,1,1,1,1,1,0,0,0,0,0.8,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (25,'传奇舞者','1,4','2,5','1,2','1,2','1,4',180,300,180,260,180,'2,4','1,4',1,1,1,1,1,1,10,0,0,2,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (26,'炼术士','1,3','1,3','1,2','1,4','2,4',167,180,253,185,167,'0,4','1,4',1,1,1,1.2,1,1,0,0,0,0,1,1,1,1,1,0.1);
INSERT INTO `wog_character` VALUES (27,'重战士','2,7','0,2','1,4','2,4','0,2',270,200,150,185,255,'0,2','0,2',1,1.2,1,1.2,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (28,'圣骑士','2,6','1,3','1,3','1,4','1,2',550,400,300,320,520,'0,4','1,4',1,1,1,1,1,1,0,0,15,0,1,1,1,1,1,0.02);
INSERT INTO `wog_character` VALUES (29,'上忍','2,4','2,6','1,3','1,3','1,4',470,550,360,320,470,'1,3','1,2',1,1,1,1,1,1,20,20,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (30,'大贤者','1,2','2,3','1,3','1,4','2,7',200,390,600,320,350,'1,4','2,4',1,1,1,1,1,1,0,0,0,0,0.8,1,1,0.8,1,0);
INSERT INTO `wog_character` VALUES (31,'英雄','3,7','2,3','1,4','1,3','1,3',900,600,400,500,750,'1,4','0,3',1.2,1,1,1,1,1,15,0,0,1,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (32,'风魔','2,3','2,7','1,3','1,2','2,4',780,900,500,500,750,'1,2','1,3',1,1,1,1,1,1,0,100,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (33,'召唤师','1,4','2,5','1,2','1,3','3,7',350,500,900,500,480,'1,3','2,3',1,1,1.5,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (34,'龙魂','3,7','1,3','2,3','2,3','1,3',1600,1000,800,800,1400,'0,4','1,3',1.5,1,1,1,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (35,'精灵王','1,3','2,4','1,3','1,4','4,7',800,1000,1600,800,1000,'1,5','2,4',1,1.2,1,1.5,1,1,0,0,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (36,'传说','2,5','3,6','1,4','1,2','1,4',1400,1400,1000,800,1200,'1,4','1,3',1,1,1,1,1.5,1,0,0,5,1,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (37,'准骑士','2,4','1,3','1,2','2,3','0,3',120,60,30,85,120,'0,2','0,2',1,1,1,1,1,1,10,10,0,0,1,1,1,1,1,0);
INSERT INTO `wog_character` VALUES (38,'中忍','2,4','2,4','1,3','1,2','1,3',180,270,180,185,180,'0,3','1,2',1,1,1,1,2,1,0,0,0,0,1,1,1,1,1,0);

#
# Table structure for table wog_cp
#

DROP TABLE IF EXISTS `wog_cp`;