structure.sql

三國好好 子

#
# Table structure for table `phaos_npcs`
#

CREATE TABLE `phaos_npcs` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `race` varchar(20) NOT NULL default '',
  `image_path` longtext NOT NULL,
  `location` int(11) NOT NULL default '0',
  `rumors` longtext NOT NULL,
  `quest` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_opponents`
#

CREATE TABLE `phaos_opponents` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `hit_points` int(3) NOT NULL default '0',
  `race` varchar(30) NOT NULL default '',
  `class` varchar(30) NOT NULL default '',
  `min_damage` int(3) NOT NULL default '0',
  `max_damage` varchar(100) NOT NULL default '',
  `AC` int(3) NOT NULL default '0',
  `xp_given` int(11) NOT NULL default '0',
  `gold_given` int(11) NOT NULL default '0',
  `image_path` longtext NOT NULL,
  `location` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=201 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_potion`
#

CREATE TABLE `phaos_potion` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default 'potion',
  `image_path` longtext NOT NULL,
  `effect` varchar(100) NOT NULL default 'none',
  `buy_price` int(11) NOT NULL default '0',
  `sell_price` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_potions`
#

CREATE TABLE `phaos_potions` (
  `image_path` longtext NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `heal_amount` int(11) NOT NULL default '0',
  `buy_price` int(11) NOT NULL default '0',
  `sell_price` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_questhunters`
#

CREATE TABLE `phaos_questhunters` (
  `charid` int(11) NOT NULL default '0',
  `questid` int(11) NOT NULL default '0',
  `starttime` bigint(20) NOT NULL default '0',
  `startexp` int(11) NOT NULL default '0',
  `startgold` int(11) NOT NULL default '0',
  `monstkill` int(11) NOT NULL default '0',
  `battles` int(11) NOT NULL default '0',
  `expearned` int(11) NOT NULL default '0',
  `goldearned` int(11) NOT NULL default '0',
  `complete` int(11) NOT NULL default '0'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `phaos_quests`
#

CREATE TABLE `phaos_quests` (
  `questid` int(11) NOT NULL auto_increment,
  `npc` int(11) NOT NULL default '0',
  `reqexp` int(11) NOT NULL default '0',
  `narrate` text NOT NULL,
  `tracemsg` text NOT NULL,
  `waitmsg` text NOT NULL,
  `completemsg` text NOT NULL,
  `rewarditemid` int(11) NOT NULL default '0',
  `rewarditemtype` int(11) NOT NULL default '0',
  `rewardgold` int(11) NOT NULL default '0',
  `rewardwexp` int(11) NOT NULL default '0',
  `monsterkillid` int(11) NOT NULL default '0',
  `monstercollectid` int(11) NOT NULL default '0',
  `monstercollectq` int(11) NOT NULL default '0',
  `battles` int(11) NOT NULL default '0',
  `tr_ar` int(11) NOT NULL default '0',
  `haveitemtype` int(11) NOT NULL default '0',
  `haveitemid` int(11) NOT NULL default '0',
  `paygold` int(11) NOT NULL default '0',
  `havegold` int(11) NOT NULL default '0',
  `earngold` int(11) NOT NULL default '0',
  `payexp` int(11) NOT NULL default '0',
  `haveexp` int(11) NOT NULL default '0',
  `earnexp` int(11) NOT NULL default '0',
  `complete` tinyint(4) NOT NULL default '0',
  `hunters` int(11) NOT NULL default '0',
  `maxtime` bigint(20) NOT NULL default '0',
  `restnum` int(11) NOT NULL default '0',
  PRIMARY KEY  (`questid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_races`
#

CREATE TABLE `phaos_races` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `str` int(1) NOT NULL default '0',
  `dex` int(1) NOT NULL default '0',
  `wis` int(1) NOT NULL default '0',
  `con` int(1) NOT NULL default '0',
  `stamina_regen_time` smallint(5) unsigned NOT NULL default '0',
  `stamina_regen_rate` smallint(5) unsigned NOT NULL default '0',
  `healing_time` smallint(5) unsigned NOT NULL default '0',
  `healing_rate` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_sex`
#

CREATE TABLE `phaos_sex` (
  `id` int(11) NOT NULL auto_increment,
  `sex` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_shields`
#

CREATE TABLE `phaos_shields` (
  `name` varchar(100) NOT NULL default '',
  `armor_class` int(4) NOT NULL default '0',
  `buy_price` int(11) NOT NULL default '0',
  `sell_price` int(11) NOT NULL default '0',
  `image_path` longtext NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=82 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_shop_basics`
#

CREATE TABLE `phaos_shop_basics` (
  `shop_id` int(11) NOT NULL auto_increment,
  `shop_type` varchar(255) NOT NULL default 'blacksmith',
  `item_location_id` int(11) NOT NULL default '0',
  `restock_time` int(11) NOT NULL default '0',
  `restock_time_delta` int(11) NOT NULL default '3600',
  PRIMARY KEY  (`shop_id`)
) TYPE=MyISAM AUTO_INCREMENT=119 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_shop_inventory`
#

CREATE TABLE `phaos_shop_inventory` (
  `shop_id` int(11) NOT NULL default '0',
  `type` varchar(100) NOT NULL default 'potion',
  `item_id` int(11) NOT NULL default '1',
  `buy` int(11) NOT NULL default '1',
  `sell` int(11) NOT NULL default '2000000000',
  `quantity` int(6) NOT NULL default '1',
  `max` int(6) NOT NULL default '5'
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `phaos_shop_refill`
#

CREATE TABLE `phaos_shop_refill` (
  `shop_id` int(11) NOT NULL default '0',
  `item_type` varchar(255) NOT NULL default 'armor',
  `item_value_min` int(11) NOT NULL default '1',
  `item_value_growth` decimal(9,2) NOT NULL default '2.00',
  `item_value_growth_probability` decimal(9,6) NOT NULL default '0.500000',
  `item_count_min` int(4) NOT NULL default '1',
  `item_name_like` varchar(255) NOT NULL default '%',
  PRIMARY KEY  (`shop_id`,`item_type`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `phaos_shout`
#

CREATE TABLE `phaos_shout` (
  `id` int(11) NOT NULL auto_increment,
  `location` int(11) NOT NULL default '0',
  `postname` varchar(255) NOT NULL default '',
  `destname` varchar(255) NOT NULL default '',
  `postdate` int(11) NOT NULL default '0',
  `posttext` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `location` (`location`),
  KEY `destname` (`destname`)
) TYPE=MyISAM AUTO_INCREMENT=2449 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_spells_items`
#

CREATE TABLE `phaos_spells_items` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `min_damage` int(11) NOT NULL default '0',
  `max_damage` int(11) NOT NULL default '0',
  `buy_price` int(11) NOT NULL default '0',
  `sell_price` int(11) NOT NULL default '0',
  `image_path` longtext NOT NULL,
  `req_skill` int(11) NOT NULL default '0',
  `damage_mess` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=257 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_store_inventory`
#

CREATE TABLE `phaos_store_inventory` (
  `id` int(11) NOT NULL auto_increment,
  `weapon_1` int(11) NOT NULL default '0',
  `weapon_2` int(11) NOT NULL default '0',
  `weapon_3` int(11) NOT NULL default '0',
  `weapon_4` int(11) NOT NULL default '0',
  `weapon_5` int(11) NOT NULL default '0',
  `armor_1` int(11) NOT NULL default '0',
  `armor_2` int(11) NOT NULL default '0',
  `armor_3` int(11) NOT NULL default '0',
  `armor_4` int(11) NOT NULL default '0',
  `armor_5` int(11) NOT NULL default '0',
  `restock_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=92361 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_users`
#

CREATE TABLE `phaos_users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email_address` varchar(50) NOT NULL default '',
  `full_name` varchar(50) NOT NULL default '',
  `lang` varchar(10) NOT NULL default 'en',
  `grid_size` smallint(6) NOT NULL default '52',
  `grid_status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=7071 ;

# --------------------------------------------------------

#
# Table structure for table `phaos_weapons`
#

CREATE TABLE `phaos_weapons` (
  `name` varchar(100) NOT NULL default '',
  `min_damage` int(11) NOT NULL default '0',
  `max_damage` int(11) NOT NULL default '0',
  `buy_price` int(11) NOT NULL default '0',
  `sell_price` int(11) NOT NULL default '0',
  `image_path` longtext NOT NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=262 ;