structure.sql

三國好好 子

#
# Table structure for table `phaos_admin`
#

CREATE TABLE `phaos_help` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `body` longtext NOT NULL,
  `file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `title` (`title`),
  KEY `category` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

CREATE TABLE `phaos_admin` (
  `id` int(11) NOT NULL auto_increment,
  `admin_user` varchar(100) NOT NULL default '',
  `admin_pass` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

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

#
# Table structure for table `phaos_armor`
#

CREATE TABLE `phaos_armor` (
  `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=66 ;

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

#
# Table structure for table `phaos_boots`
#

CREATE TABLE `phaos_boots` (
  `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=130 ;

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

#
# Table structure for table `phaos_buildings`
#

CREATE TABLE `phaos_buildings` (
  `shop_id` int(11) unsigned NOT NULL auto_increment,
  `location` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `owner_id` int(11) NOT NULL default '1000',
  `capacity` int(11) NOT NULL default '10',
  KEY `shop_id` (`shop_id`),
  KEY `location` (`location`)
) TYPE=MyISAM AUTO_INCREMENT=125 ;

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

#
# Table structure for table `phaos_char_inventory`
#

CREATE TABLE `phaos_char_inventory` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `item_id` int(11) NOT NULL default '0',
  `type` varchar(50) NOT NULL default '',
  `equiped` char(1) NOT NULL default 'N',
  `asking_price` int(11) NOT NULL default '0',
  `sell_to` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=289385 ;

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

#
# Table structure for table `phaos_characters`
#

CREATE TABLE `phaos_characters` (
  `id` int(11) NOT NULL auto_increment,
  `location` int(11) NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `name` varchar(50) NOT NULL default 'a',
  `age` int(4) NOT NULL default '0',
  `sex` varchar(20) NOT NULL default 'not specified',
  `strength` int(3) NOT NULL default '0',
  `dexterity` int(3) NOT NULL default '0',
  `wisdom` int(3) NOT NULL default '0',
  `constitution` int(3) NOT NULL default '0',
  `weapon` int(3) NOT NULL default '0',
  `hit_points` int(6) NOT NULL default '0',
  `race` varchar(30) NOT NULL default '',
  `class` varchar(30) NOT NULL default '',
  `xp` int(10) NOT NULL default '0',
  `level` varchar(5) NOT NULL default '',
  `gold` int(10) NOT NULL default '0',
  `armor` int(3) NOT NULL default '0',
  `image_path` longtext NOT NULL,
  `stat_points` int(11) NOT NULL default '0',
  `boots` int(3) NOT NULL default '0',
  `gloves` int(3) NOT NULL default '0',
  `helm` int(3) NOT NULL default '0',
  `shield` int(3) NOT NULL default '0',
  `regen_time` int(11) NOT NULL default '0',
  `dungeon_location` int(11) NOT NULL default '1',
  `stamina` int(10) NOT NULL default '0',
  `stamina_time` int(11) NOT NULL default '0',
  `fight` int(5) NOT NULL default '1',
  `defence` int(5) NOT NULL default '1',
  `weaponless` int(5) NOT NULL default '1',
  `lockpick` int(5) NOT NULL default '1',
  `traps` int(5) NOT NULL default '1',
  `rep_time` int(11) NOT NULL default '0',
  `rep_points` int(11) NOT NULL default '0',
  `rep_helpfull` int(11) NOT NULL default '0',
  `rep_generious` int(11) NOT NULL default '0',
  `rep_combat` int(11) NOT NULL default '0',
  `bankgold` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=146555 ;

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

#
# Table structure for table `phaos_clan_admin`
#

CREATE TABLE `phaos_clan_admin` (
  `id` int(11) NOT NULL auto_increment,
  `clanname` varchar(30) NOT NULL default '',
  `clanleader` varchar(30) NOT NULL default '',
  `clanleader_1` varchar(30) NOT NULL default '',
  `clanbanner` varchar(100) NOT NULL default '',
  `clansig` varchar(6) NOT NULL default '',
  `clanlocation` varchar(11) NOT NULL default '',
  `clanslogan` varchar(100) NOT NULL default '',
  `clancashbox` int(11) NOT NULL default '0',
  `clanmembers` int(10) NOT NULL default '0',
  `clancreatedate` varchar(11) NOT NULL default '',
  `clanrank_1` varchar(20) NOT NULL default '',
  `clanrank_2` varchar(20) NOT NULL default '',
  `clanrank_3` varchar(20) NOT NULL default '',
  `clanrank_4` varchar(20) NOT NULL default '',
  `clanrank_5` varchar(20) NOT NULL default '',
  `clanrank_6` varchar(20) NOT NULL default '',
  `clanrank_7` varchar(20) NOT NULL default '',
  `clanrank_8` varchar(20) NOT NULL default '',
  `clanrank_9` varchar(20) NOT NULL default '',
  `clanrank_10` varchar(20) NOT NULL default '',
  `clan_sig` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=37 ;

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

#
# Table structure for table `phaos_clan_in`
#

CREATE TABLE `phaos_clan_in` (
  `id` int(11) NOT NULL auto_increment,
  `clanname` varchar(30) NOT NULL default '',
  `clanmember` varchar(30) NOT NULL default '',
  `clanindate` varchar(30) NOT NULL default '',
  `givegold` varchar(30) NOT NULL default '',
  `clanrank` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=184 ;

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

#
# Table structure for table `phaos_clan_search`
#

CREATE TABLE `phaos_clan_search` (
  `id` int(11) NOT NULL auto_increment,
  `clanname` varchar(30) NOT NULL default '',
  `charname` varchar(30) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=46 ;

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

#
# Table structure for table `phaos_classes`
#

CREATE TABLE `phaos_classes` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `fight` int(5) NOT NULL default '1',
  `defence` int(5) NOT NULL default '1',
  `weaponless` int(5) NOT NULL default '1',
  `lockpick` int(5) NOT NULL default '1',
  `traps` int(5) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

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

#
# Table structure for table `phaos_gloves`
#

CREATE TABLE `phaos_gloves` (
  `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=130 ;

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

#
# Table structure for table `phaos_ground`
#

CREATE TABLE `phaos_ground` (
  `location` int(11) unsigned NOT NULL default '0',
  `item_id` int(11) NOT NULL default '0',
  `item_type` varchar(50) NOT NULL default '',
  `number` int(11) NOT NULL default '0',
  PRIMARY KEY  (`location`,`item_id`,`item_type`)
) TYPE=MyISAM;

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

#
# Table structure for table `phaos_helmets`
#

CREATE TABLE `phaos_helmets` (
  `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=122 ;

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

#
# Table structure for table `phaos_level_chart`
#

CREATE TABLE `phaos_level_chart` (
  `id` int(11) NOT NULL auto_increment,
  `level` int(3) NOT NULL default '0',
  `xp_needed` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1001 ;

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

#
# Table structure for table `phaos_locations`
#

CREATE TABLE `phaos_locations` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default 'Wilderness',
  `above_left` int(11) NOT NULL default '0',
  `above` int(11) NOT NULL default '0',
  `above_right` int(11) NOT NULL default '0',
  `leftside` int(11) NOT NULL default '0',
  `rightside` int(11) NOT NULL default '0',
  `below_left` int(11) NOT NULL default '0',
  `below` int(11) NOT NULL default '0',
  `below_right` int(11) NOT NULL default '0',
  `image_path` varchar(100) NOT NULL default 'images/land/2.png',
  `special` int(11) NOT NULL default '0',
  `buildings` char(1) NOT NULL default 'n',
  `pass` char(1) NOT NULL default 'y',
  `explore` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=103186 ;

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

#
# Table structure for table `phaos_mail`
#

CREATE TABLE `phaos_mail` (
  `UserTo` tinytext NOT NULL,
  `UserFrom` tinytext NOT NULL,
  `Subject` mediumtext NOT NULL,
  `Message` longtext NOT NULL,
  `STATUS` text NOT NULL,
  `SentDate` text NOT NULL,
  `mail_id` int(80) NOT NULL auto_increment,
  PRIMARY KEY  (`mail_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

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