/*
Navicat MySQL Data Transfer

Source Server         : play
Source Server Version : 50142
Source Host           : play.net-7.org:3307
Source Database       : net7

Target Server Type    : MYSQL
Target Server Version : 50142
File Encoding         : 65001

Date: 2010-03-04 23:59:07
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `assets`
-- ----------------------------
DROP TABLE IF EXISTS `assets`;
CREATE TABLE `assets` (
  `base_id` int(10) unsigned NOT NULL DEFAULT '0',
  `descr` text NOT NULL,
  `main_cat` text NOT NULL,
  `sub_cat` text NOT NULL,
  `filename` text NOT NULL,
  `rslid` int(11) NOT NULL,
  PRIMARY KEY (`base_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `asteroid_content_selection`
-- ----------------------------
DROP TABLE IF EXISTS `asteroid_content_selection`;
CREATE TABLE `asteroid_content_selection` (
  `asteroid_type` int(11) NOT NULL,
  `item_subcat_id` int(11) NOT NULL,
  `item_subcat_desc` text,
  KEY `asteroid_content_selection_ik1` (`asteroid_type`,`item_subcat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `avatar_base`
-- ----------------------------
DROP TABLE IF EXISTS `avatar_base`;
CREATE TABLE `avatar_base` (
  `Race` tinyint(3) unsigned NOT NULL,
  `Profession` tinyint(3) unsigned NOT NULL,
  `base_shield` int(10) unsigned NOT NULL,
  `base_reactor` int(10) unsigned NOT NULL,
  `base_engine` int(10) unsigned NOT NULL,
  `base_weapon` int(10) unsigned NOT NULL,
  `base_hull_asset` int(10) unsigned NOT NULL,
  `base_profession_asset` int(10) unsigned NOT NULL,
  `base_wing_asset` int(10) unsigned NOT NULL,
  `base_engine_asset` int(10) unsigned NOT NULL,
  `starting_sector` int(10) unsigned NOT NULL,
  `base_faction` int(10) unsigned NOT NULL,
  `base_scan_range` int(10) unsigned NOT NULL,
  `base_signature` int(10) unsigned NOT NULL,
  `base_speed` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `base_ore_list`
-- ----------------------------
DROP TABLE IF EXISTS `base_ore_list`;
CREATE TABLE `base_ore_list` (
  `item_id` int(11) NOT NULL,
  `name` text,
  `sector_id` int(11) NOT NULL,
  `frequency` float NOT NULL,
  KEY `base_ore_list_ik1` (`sector_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `buffs`
-- ----------------------------
DROP TABLE IF EXISTS `buffs`;
CREATE TABLE `buffs` (
  `buff_id` bigint(20) NOT NULL,
  `buff_name` varchar(128) NOT NULL,
  `StatName` varchar(128) NOT NULL,
  `StatType` int(1) NOT NULL,
  `EffectID` bigint(20) NOT NULL,
  `EffectLength` int(10) NOT NULL,
  `tooltip` text,
  `description` text,
  `is_good_buff` tinyint(1) NOT NULL,
  PRIMARY KEY (`buff_id`),
  KEY `StatName` (`StatName`),
  KEY `EffectID` (`EffectID`),
  CONSTRAINT `buffs_ibfk_1` FOREIGN KEY (`StatName`) REFERENCES `item_effect_stats` (`Stat_Name`),
  CONSTRAINT `buffs_ibfk_2` FOREIGN KEY (`EffectID`) REFERENCES `effects` (`effect_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `damage_types`
-- ----------------------------
DROP TABLE IF EXISTS `damage_types`;
CREATE TABLE `damage_types` (
  `id` int(10) unsigned NOT NULL,
  `type` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `effects`
-- ----------------------------
DROP TABLE IF EXISTS `effects`;
CREATE TABLE `effects` (
  `effect_id` bigint(20) NOT NULL,
  `effect_class` text NOT NULL,
  `description` text,
  `start_link_id` bigint(20) NOT NULL,
  `next_link_id` bigint(20) NOT NULL,
  `base_asset_id` bigint(20) NOT NULL,
  `sound_fx_file` text NOT NULL,
  PRIMARY KEY (`effect_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `faction_matrix`
-- ----------------------------
DROP TABLE IF EXISTS `faction_matrix`;
CREATE TABLE `faction_matrix` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `faction_id` bigint(20) NOT NULL DEFAULT '0',
  `faction_entry_id` bigint(20) NOT NULL DEFAULT '0',
  `base_value` double(11,4) NOT NULL DEFAULT '0.0000',
  `current_value` double(11,4) NOT NULL DEFAULT '0.0000',
  `reward_faction` double(11,4) NOT NULL DEFAULT '0.0000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1415 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `factions`
-- ----------------------------
DROP TABLE IF EXISTS `factions`;
CREATE TABLE `factions` (
  `faction_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'FIXME',
  `description` text NOT NULL,
  `player_PDA` tinyint(4) NOT NULL DEFAULT '1',
  `PDA_text` varchar(512) NOT NULL DEFAULT '',
  `faction_gain_sound` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`faction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `hulls`
-- ----------------------------
DROP TABLE IF EXISTS `hulls`;
CREATE TABLE `hulls` (
  `Race` tinyint(3) unsigned NOT NULL,
  `Profession` tinyint(3) unsigned NOT NULL,
  `upgrade_level` tinyint(3) unsigned NOT NULL,
  `hull_points` int(10) unsigned NOT NULL,
  `weapon_slots` tinyint(3) unsigned NOT NULL,
  `device_slots` tinyint(3) unsigned NOT NULL,
  `cargo_slots` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_ammo`
-- ----------------------------
DROP TABLE IF EXISTS `item_ammo`;
CREATE TABLE `item_ammo` (
  `item_id` int(10) unsigned NOT NULL,
  `ammo_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  `damage_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `fire_effect` int(10) unsigned NOT NULL DEFAULT '0',
  `maneuv_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `damage_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_ammo_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_ammo_type`
-- ----------------------------
DROP TABLE IF EXISTS `item_ammo_type`;
CREATE TABLE `item_ammo_type` (
  `id` int(10) unsigned NOT NULL,
  `sub_category` smallint(6) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_base`
-- ----------------------------
DROP TABLE IF EXISTS `item_base`;
CREATE TABLE `item_base` (
  `id` int(10) unsigned NOT NULL,
  `level` tinyint(1) unsigned NOT NULL,
  `category` int(6) NOT NULL,
  `sub_category` int(6) NOT NULL,
  `type` int(3) unsigned NOT NULL,
  `max_stack` int(5) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  `description` text NOT NULL,
  `manufacturer` int(10) unsigned NOT NULL,
  `2d_asset` int(10) unsigned NOT NULL,
  `3d_asset` int(10) unsigned NOT NULL,
  `no_trade` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `no_store` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `no_destroy` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `no_manu` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `unique` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `item_base_id` int(10) unsigned DEFAULT NULL,
  `custom_flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `status` int(10) unsigned NOT NULL DEFAULT '0',
  `effect_id` bigint(20) DEFAULT '0',
  `price` int(10) unsigned NOT NULL,
  `man_cost_base` int(11) DEFAULT '0',
  `man_cost_mod` int(11) DEFAULT '1',
  `man_cost` int(11) DEFAULT '0',
  `man_dif` int(10) DEFAULT '0',
  `ana_dif` int(10) DEFAULT '0',
  `dis_dif` int(10) DEFAULT '0',
  `price_tweak` int(11) DEFAULT '1',
  `selling_price` int(11) DEFAULT '0',
  `buying_price` int(11) DEFAULT '0',
  `sell_mod` int(11) DEFAULT '1',
  `buy_mod` int(11) DEFAULT '1',
  `quality_mod` double unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `FK_item_base_1` (`manufacturer`),
  KEY `FK_item_base_2` (`item_base_id`),
  KEY `FK_item_base_3` (`effect_id`),
  CONSTRAINT `FK_item_base_1` FOREIGN KEY (`manufacturer`) REFERENCES `item_manufacturer_base` (`id`),
  CONSTRAINT `FK_item_base_2` FOREIGN KEY (`item_base_id`) REFERENCES `item_base` (`id`),
  CONSTRAINT `FK_item_base_3` FOREIGN KEY (`effect_id`) REFERENCES `effects` (`effect_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_beam`
-- ----------------------------
DROP TABLE IF EXISTS `item_beam`;
CREATE TABLE `item_beam` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `damage_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `fire_effect` smallint(5) unsigned NOT NULL DEFAULT '0',
  `damage_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `reload_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_cat_subcat_type`
-- ----------------------------
DROP TABLE IF EXISTS `item_cat_subcat_type`;
CREATE TABLE `item_cat_subcat_type` (
  `category_id` int(10) NOT NULL DEFAULT '0',
  `subcategory_id` int(10) NOT NULL DEFAULT '0',
  `type_id` int(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_categories`
-- ----------------------------
DROP TABLE IF EXISTS `item_categories`;
CREATE TABLE `item_categories` (
  `id` int(10) NOT NULL DEFAULT '0',
  `category` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_device`
-- ----------------------------
DROP TABLE IF EXISTS `item_device`;
CREATE TABLE `item_device` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_devices_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_effect_base`
-- ----------------------------
DROP TABLE IF EXISTS `item_effect_base`;
CREATE TABLE `item_effect_base` (
  `EffectID` int(10) NOT NULL AUTO_INCREMENT,
  `EffectType` int(1) NOT NULL DEFAULT '1' COMMENT 'Equipable Effect (0) or Activatable (1)',
  `Name` varchar(256) NOT NULL COMMENT 'Effect Name',
  `Description` varchar(256) NOT NULL COMMENT 'Effect Description',
  `Tooltip` varchar(256) NOT NULL COMMENT 'Effect Tooltip',
  `flag1` int(10) NOT NULL DEFAULT '0' COMMENT 'Effect Flag',
  `flag2` int(10) NOT NULL DEFAULT '0' COMMENT 'Effect Flag',
  `Constant1Value` float(10,3) NOT NULL DEFAULT '0.000' COMMENT 'Constant Value',
  `Constant1Stat` varchar(50) NOT NULL DEFAULT 'NO_STAT' COMMENT 'Modifying Stat',
  `Constant1Type` int(1) NOT NULL DEFAULT '0' COMMENT '(0) Not Used (1) Inc Value (2) Dec Value (3) Inc % (4) Dec %',
  `Constant2Value` float(10,3) NOT NULL DEFAULT '0.000' COMMENT 'Constant Value',
  `Constant2Stat` varchar(50) NOT NULL DEFAULT 'NO_STAT' COMMENT 'Modifying Stat',
  `Constant2Type` int(1) NOT NULL DEFAULT '0' COMMENT '(0) Not Used (1) Inc Value (2) Dec Value (3) Inc % (4) Dec %',
  `Var1Stat` varchar(50) NOT NULL DEFAULT 'NO_STAT' COMMENT 'Modifying Stat',
  `Var1Type` int(1) NOT NULL DEFAULT '0' COMMENT '(0) Not Used (1) Inc Value (2) Dec Value (3) Inc % (4) Dec %',
  `Var2Stat` varchar(50) NOT NULL DEFAULT 'NO_STAT' COMMENT 'Modifying Stat',
  `Var2Type` int(1) NOT NULL DEFAULT '0' COMMENT '(0) Not Used (1) Inc Value (2) Dec Value (3) Inc % (4) Dec %',
  `Var3Stat` varchar(50) NOT NULL DEFAULT 'NO_STAT' COMMENT 'Modifying Stat',
  `Var3Type` int(1) NOT NULL DEFAULT '0' COMMENT '(0) Not Used (1) Inc Value (2) Dec Value (3) Inc % (4) Dec %',
  `Buff_Name` varchar(50) NOT NULL DEFAULT 'BUFF_NONE',
  `VisualEffect` int(10) NOT NULL DEFAULT '-1' COMMENT 'Visual Effects',
  `Var1_mod` float NOT NULL DEFAULT '1' COMMENT 'Modifier for Variable 1',
  `Var2_mod` float NOT NULL DEFAULT '1' COMMENT 'Modifier for Variable 2',
  `Var3_mod` float NOT NULL DEFAULT '1' COMMENT 'Modifier for Variable 3',
  `O2OEffect` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'type of visual effect',
  PRIMARY KEY (`EffectID`),
  KEY `Constant1Stat` (`Constant1Stat`),
  KEY `Constant2Stat` (`Constant2Stat`),
  KEY `Var1Stat` (`Var1Stat`),
  KEY `Var2Stat` (`Var2Stat`),
  KEY `Var3Stat` (`Var3Stat`),
  CONSTRAINT `item_effect_base_ibfk_1` FOREIGN KEY (`Constant1Stat`) REFERENCES `item_effect_stats` (`Stat_Name`),
  CONSTRAINT `item_effect_base_ibfk_2` FOREIGN KEY (`Constant2Stat`) REFERENCES `item_effect_stats` (`Stat_Name`),
  CONSTRAINT `item_effect_base_ibfk_3` FOREIGN KEY (`Var1Stat`) REFERENCES `item_effect_stats` (`Stat_Name`),
  CONSTRAINT `item_effect_base_ibfk_4` FOREIGN KEY (`Var2Stat`) REFERENCES `item_effect_stats` (`Stat_Name`),
  CONSTRAINT `item_effect_base_ibfk_5` FOREIGN KEY (`Var3Stat`) REFERENCES `item_effect_stats` (`Stat_Name`)
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_effect_container`
-- ----------------------------
DROP TABLE IF EXISTS `item_effect_container`;
CREATE TABLE `item_effect_container` (
  `EffectContainerID` int(10) NOT NULL AUTO_INCREMENT,
  `ItemID` int(10) NOT NULL COMMENT 'Item ID',
  `EquipEffect` binary(1) NOT NULL DEFAULT '0' COMMENT 'Equipable Effect (0) or Activatable (1)',
  `RechargeTime` int(10) NOT NULL DEFAULT '0',
  `Unknown2` int(10) NOT NULL DEFAULT '0',
  `_Range` int(10) NOT NULL DEFAULT '0',
  `Unknown4` int(10) NOT NULL DEFAULT '0',
  `EnergyUse` int(10) NOT NULL DEFAULT '0' COMMENT 'Energy Used for activatable',
  `Energy_mod` float NOT NULL DEFAULT '1' COMMENT 'Modifier for EnergyUse value',
  PRIMARY KEY (`EffectContainerID`)
) ENGINE=InnoDB AUTO_INCREMENT=2231 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_effect_stats`
-- ----------------------------
DROP TABLE IF EXISTS `item_effect_stats`;
CREATE TABLE `item_effect_stats` (
  `Stat_Name` varchar(128) NOT NULL,
  `Stat_Description` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`Stat_Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_effects`
-- ----------------------------
DROP TABLE IF EXISTS `item_effects`;
CREATE TABLE `item_effects` (
  `ItemEffectID` int(10) NOT NULL AUTO_INCREMENT,
  `ItemID` int(10) NOT NULL,
  `item_effect_base_id` int(10) NOT NULL,
  `Var1Data` float(10,3) NOT NULL DEFAULT '0.000' COMMENT 'Value for Descriptive varable',
  `Var2Data` float(10,3) NOT NULL DEFAULT '0.000' COMMENT 'Value for Descriptive varable',
  `Var3Data` float(10,3) NOT NULL DEFAULT '0.000' COMMENT 'Value for Descriptive varable',
  PRIMARY KEY (`ItemEffectID`),
  KEY `item_effect_base_id` (`item_effect_base_id`),
  CONSTRAINT `item_effects_ibfk_1` FOREIGN KEY (`item_effect_base_id`) REFERENCES `item_effect_base` (`EffectID`)
) ENGINE=InnoDB AUTO_INCREMENT=3951 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_engine`
-- ----------------------------
DROP TABLE IF EXISTS `item_engine`;
CREATE TABLE `item_engine` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `warp` smallint(5) unsigned NOT NULL,
  `warp_drain_100` float(6,2) unsigned NOT NULL,
  `thrust_100` smallint(5) unsigned NOT NULL,
  `signature_100` smallint(5) unsigned NOT NULL,
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_engine_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_manufacture`
-- ----------------------------
DROP TABLE IF EXISTS `item_manufacture`;
CREATE TABLE `item_manufacture` (
  `item_id` int(10) unsigned NOT NULL,
  `comp_1` int(11) NOT NULL DEFAULT '-1',
  `comp_2` int(11) NOT NULL DEFAULT '-1',
  `comp_3` int(11) NOT NULL DEFAULT '-1',
  `comp_4` int(11) NOT NULL DEFAULT '-1',
  `comp_5` int(11) NOT NULL DEFAULT '-1',
  `comp_6` int(11) NOT NULL DEFAULT '-1',
  `difficulty` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_manufacture_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_manufacture_difficulty`
-- ----------------------------
DROP TABLE IF EXISTS `item_manufacture_difficulty`;
CREATE TABLE `item_manufacture_difficulty` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_manufacturer_base`
-- ----------------------------
DROP TABLE IF EXISTS `item_manufacturer_base`;
CREATE TABLE `item_manufacturer_base` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_missile`
-- ----------------------------
DROP TABLE IF EXISTS `item_missile`;
CREATE TABLE `item_missile` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ammo` varchar(64) DEFAULT NULL,
  `ammo_per_shot` tinyint(3) unsigned NOT NULL,
  `energy_100` double(6,2) unsigned NOT NULL DEFAULT '0.00',
  `reload_100` double(6,2) unsigned NOT NULL DEFAULT '0.00',
  `ammo_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_missle_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_other_req`
-- ----------------------------
DROP TABLE IF EXISTS `item_other_req`;
CREATE TABLE `item_other_req` (
  `item_id` int(10) unsigned NOT NULL,
  `overall_lvl` smallint(5) unsigned NOT NULL DEFAULT '0',
  `combat_lvl` smallint(5) unsigned NOT NULL DEFAULT '0',
  `explore_lvl` smallint(5) unsigned NOT NULL DEFAULT '0',
  `trade_level` smallint(5) unsigned NOT NULL DEFAULT '0',
  `other_skill` varchar(45) DEFAULT NULL,
  `over_skill_lvl` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `energy_drain` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `shield_drain` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_other_req_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_projectile`
-- ----------------------------
DROP TABLE IF EXISTS `item_projectile`;
CREATE TABLE `item_projectile` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ammo` varchar(64) DEFAULT NULL,
  `ammo_per_shot` tinyint(3) unsigned NOT NULL,
  `range_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `reload_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `ammo_type_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_projectile_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_reactor`
-- ----------------------------
DROP TABLE IF EXISTS `item_reactor`;
CREATE TABLE `item_reactor` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `cap_100` int(10) unsigned NOT NULL,
  `recharge_100` float(6,2) unsigned NOT NULL,
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_reactor_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_refine`
-- ----------------------------
DROP TABLE IF EXISTS `item_refine`;
CREATE TABLE `item_refine` (
  `item_id` int(10) unsigned NOT NULL,
  `refine_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_shield`
-- ----------------------------
DROP TABLE IF EXISTS `item_shield`;
CREATE TABLE `item_shield` (
  `item_id` int(10) unsigned NOT NULL,
  `rest_prof` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `rest_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `cap_100` int(10) unsigned NOT NULL,
  `recharge_100` float(6,2) unsigned NOT NULL,
  `energy_100` float(6,2) unsigned NOT NULL DEFAULT '0.00',
  `range_100` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  CONSTRAINT `FK_item_shield_1` FOREIGN KEY (`item_id`) REFERENCES `item_base` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_subcategories`
-- ----------------------------
DROP TABLE IF EXISTS `item_subcategories`;
CREATE TABLE `item_subcategories` (
  `id` int(10) NOT NULL DEFAULT '0',
  `subcategory` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_type`
-- ----------------------------
DROP TABLE IF EXISTS `item_type`;
CREATE TABLE `item_type` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `item_verification_status`
-- ----------------------------
DROP TABLE IF EXISTS `item_verification_status`;
CREATE TABLE `item_verification_status` (
  `id` int(10) NOT NULL DEFAULT '0',
  `status` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `level_xp`
-- ----------------------------
DROP TABLE IF EXISTS `level_xp`;
CREATE TABLE `level_xp` (
  `level` bigint(20) NOT NULL,
  `trade_xp` bigint(20) DEFAULT NULL,
  `explore_xp` bigint(20) DEFAULT NULL,
  `combat_xp` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `manufacturers`
-- ----------------------------
DROP TABLE IF EXISTS `manufacturers`;
CREATE TABLE `manufacturers` (
  `manufacturer_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slogan` text,
  `faction_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`manufacturer_id`),
  KEY `FKC92656C2C1D175D2` (`faction_id`),
  CONSTRAINT `FKC92656C2C1D175D2` FOREIGN KEY (`faction_id`) REFERENCES `factions` (`faction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `missions`
-- ----------------------------
DROP TABLE IF EXISTS `missions`;
CREATE TABLE `missions` (
  `mission_id` int(11) NOT NULL AUTO_INCREMENT,
  `mission_XML` text CHARACTER SET ascii,
  `mission_name` text,
  `mission_key` int(11) DEFAULT NULL,
  `mission_type` smallint(5) unsigned DEFAULT NULL,
  `mission_minSecurityLevel` int(5) DEFAULT '0',
  PRIMARY KEY (`mission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=426 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `mob_agressiveness`
-- ----------------------------
DROP TABLE IF EXISTS `mob_agressiveness`;
CREATE TABLE `mob_agressiveness` (
  `id` int(10) NOT NULL,
  `name` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `mob_base`
-- ----------------------------
DROP TABLE IF EXISTS `mob_base`;
CREATE TABLE `mob_base` (
  `mob_id` bigint(20) NOT NULL,
  `name` text NOT NULL,
  `level` int(11) NOT NULL,
  `intelligence` float NOT NULL,
  `bravery` float NOT NULL,
  `type` int(11) NOT NULL,
  `faction_id` bigint(20) NOT NULL,
  `base_asset_id` bigint(20) NOT NULL,
  `altruism` float NOT NULL,
  `aggressiveness` float NOT NULL,
  `ai` text NOT NULL,
  `h` float NOT NULL,
  `s` float NOT NULL,
  `v` float NOT NULL,
  `scale` float NOT NULL,
  `skill0` int(11) NOT NULL DEFAULT '-1',
  `skill1` int(11) NOT NULL DEFAULT '-1',
  `skill2` int(11) NOT NULL DEFAULT '-1',
  `skill3` int(11) NOT NULL DEFAULT '-1',
  `skill4` int(11) NOT NULL DEFAULT '-1',
  `skill5` int(11) NOT NULL DEFAULT '-1',
  `skill6` int(11) NOT NULL DEFAULT '-1',
  `skill7` int(11) NOT NULL DEFAULT '-1',
  `skill8` int(11) NOT NULL DEFAULT '-1',
  `skill9` int(11) NOT NULL DEFAULT '-1',
  `shield_modifier` float(11,2) NOT NULL DEFAULT '1.00',
  `damage_modifier` float(11,2) NOT NULL DEFAULT '1.00',
  `range_modifier` float(11,2) NOT NULL DEFAULT '1.00',
  `skillchance` int(11) NOT NULL DEFAULT '1',
  `skillcooldown` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`mob_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `mob_items`
-- ----------------------------
DROP TABLE IF EXISTS `mob_items`;
CREATE TABLE `mob_items` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mob_id` bigint(20) NOT NULL,
  `item_base_id` bigint(20) NOT NULL,
  `usage_chance` int(10) unsigned NOT NULL,
  `drop_chance` float(10,1) unsigned NOT NULL,
  `type` int(10) unsigned NOT NULL,
  `qty` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12776 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `mob_spawn_group`
-- ----------------------------
DROP TABLE IF EXISTS `mob_spawn_group`;
CREATE TABLE `mob_spawn_group` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `spawn_group_id` bigint(20) NOT NULL,
  `mob_id` bigint(20) NOT NULL,
  `group_index` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4494 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `mob_type`
-- ----------------------------
DROP TABLE IF EXISTS `mob_type`;
CREATE TABLE `mob_type` (
  `Value` int(10) NOT NULL,
  `Name` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`Value`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_allocation`
-- ----------------------------
DROP TABLE IF EXISTS `sector_allocation`;
CREATE TABLE `sector_allocation` (
  `sector_id` int(10) NOT NULL COMMENT 'Sector ID',
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID for list',
  `username` varchar(50) NOT NULL COMMENT 'Username',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_nav_points`
-- ----------------------------
DROP TABLE IF EXISTS `sector_nav_points`;
CREATE TABLE `sector_nav_points` (
  `sector_object_id` bigint(20) NOT NULL,
  `nav_type` int(11) DEFAULT NULL,
  `signature` float DEFAULT NULL,
  `is_huge` tinyint(1) DEFAULT NULL,
  `sector_id` bigint(20) DEFAULT NULL,
  `base_xp` int(11) DEFAULT NULL,
  `exploration_range` float DEFAULT '0',
  `object_radius_patch` float DEFAULT NULL,
  PRIMARY KEY (`sector_object_id`),
  KEY `FKDA2235F8F1675362` (`sector_id`),
  KEY `FKDA2235F8CAAD542F` (`sector_object_id`),
  CONSTRAINT `FKDA2235F8CAAD542F` FOREIGN KEY (`sector_object_id`) REFERENCES `sector_objects` (`sector_object_id`),
  CONSTRAINT `FKDA2235F8F1675362` FOREIGN KEY (`sector_id`) REFERENCES `sectors` (`sector_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects`;
CREATE TABLE `sector_objects` (
  `sector_object_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `base_asset_id` int(11) DEFAULT NULL,
  `h` float DEFAULT NULL,
  `s` float DEFAULT NULL,
  `v` float DEFAULT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `scale` float DEFAULT NULL,
  `position_x` float DEFAULT NULL,
  `position_y` float DEFAULT NULL,
  `position_z` float DEFAULT NULL,
  `orientation_u` float DEFAULT NULL,
  `orientation_v` float DEFAULT NULL,
  `orientation_w` float DEFAULT NULL,
  `orientation_z` float DEFAULT NULL,
  `name` text,
  `appears_in_radar` tinyint(1) DEFAULT NULL,
  `radar_range` float DEFAULT NULL,
  `sector_id` bigint(20) DEFAULT NULL,
  `gate_to` bigint(20) DEFAULT NULL,
  `sound_effect_id` bigint(20) DEFAULT NULL,
  `sound_effect_range` float DEFAULT NULL,
  PRIMARY KEY (`sector_object_id`),
  KEY `FK1D9BFD3BF1675362` (`sector_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16130 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_harvestable`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_harvestable`;
CREATE TABLE `sector_objects_harvestable` (
  `resource_id` bigint(20) NOT NULL,
  `level` int(11) NOT NULL DEFAULT '0',
  `field` int(11) NOT NULL DEFAULT '0',
  `res_count` int(11) NOT NULL DEFAULT '0',
  `spawn_radius` float(11,0) NOT NULL DEFAULT '0',
  `pop_rock_chance` float(11,0) NOT NULL DEFAULT '0',
  `max_field_radius` float(11,0) NOT NULL DEFAULT '0',
  `respawn_timer` int(11) DEFAULT NULL,
  KEY `Index_2` (`resource_id`) USING BTREE,
  CONSTRAINT `Index_2` FOREIGN KEY (`resource_id`) REFERENCES `sector_objects` (`sector_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_harvestable_oretypes`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_harvestable_oretypes`;
CREATE TABLE `sector_objects_harvestable_oretypes` (
  `resource_id` int(11) NOT NULL,
  `additional_ore_item_id` int(11) NOT NULL,
  `frequency` float NOT NULL,
  KEY `sector_objects_harvestable_oretypes_ik1` (`resource_id`,`additional_ore_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_harvestable_restypes`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_harvestable_restypes`;
CREATE TABLE `sector_objects_harvestable_restypes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4294 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_mob`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_mob`;
CREATE TABLE `sector_objects_mob` (
  `mob_id` bigint(20) NOT NULL,
  `mob_count` int(11) DEFAULT NULL,
  `mob_spawn_radius` float DEFAULT NULL,
  `respawn_time` float DEFAULT NULL,
  `delayed_spawn` tinyint(1) DEFAULT NULL,
  `group_aggro` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`mob_id`),
  CONSTRAINT `FK_sector_objects_mob_1` FOREIGN KEY (`mob_id`) REFERENCES `sector_objects` (`sector_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_planets`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_planets`;
CREATE TABLE `sector_objects_planets` (
  `planet_id` bigint(20) NOT NULL,
  `orbit_id` int(11) DEFAULT NULL,
  `orbit_dist` float DEFAULT NULL,
  `orbit_angle` float DEFAULT NULL,
  `orbit_rate` float DEFAULT NULL,
  `rotate_angle` float DEFAULT NULL,
  `rotate_rate` float DEFAULT NULL,
  `tilt_angle` float DEFAULT NULL,
  `is_landable` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`planet_id`),
  KEY `FK8F33FAD721C270CF` (`planet_id`),
  CONSTRAINT `FK8F33FAD721C270CF` FOREIGN KEY (`planet_id`) REFERENCES `sector_objects` (`sector_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_starbases`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_starbases`;
CREATE TABLE `sector_objects_starbases` (
  `starbase_id` bigint(20) NOT NULL,
  `capShip` tinyint(1) NOT NULL,
  `dockable` tinyint(1) NOT NULL,
  PRIMARY KEY (`starbase_id`),
  KEY `FK9497DAAC94803E64` (`starbase_id`),
  CONSTRAINT `FK9497DAAC94803E64` FOREIGN KEY (`starbase_id`) REFERENCES `sector_objects` (`sector_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_stargates`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_stargates`;
CREATE TABLE `sector_objects_stargates` (
  `stargate_id` bigint(20) NOT NULL,
  `classSpecific` tinyint(1) NOT NULL,
  `minSecurityLevel` int(5) NOT NULL DEFAULT '0',
  `faction_id` bigint(20) NOT NULL,
  PRIMARY KEY (`stargate_id`),
  KEY `FK94DE53F29D0D7E2A` (`stargate_id`),
  CONSTRAINT `FK94DE53F29D0D7E2A` FOREIGN KEY (`stargate_id`) REFERENCES `sector_objects` (`sector_object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sector_objects_turrets`
-- ----------------------------
DROP TABLE IF EXISTS `sector_objects_turrets`;
CREATE TABLE `sector_objects_turrets` (
  `turret_id` int(11) NOT NULL,
  `turret_mob_id` int(11) NOT NULL DEFAULT '0',
  `treat_as_mob` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`turret_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `sectors`
-- ----------------------------
DROP TABLE IF EXISTS `sectors`;
CREATE TABLE `sectors` (
  `sector_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` text,
  `x_min` float DEFAULT NULL,
  `y_min` float DEFAULT NULL,
  `z_min` float DEFAULT NULL,
  `x_max` float DEFAULT NULL,
  `y_max` float DEFAULT NULL,
  `z_max` float DEFAULT NULL,
  `grid_x` int(11) DEFAULT NULL,
  `grid_y` int(11) DEFAULT NULL,
  `grid_z` int(11) DEFAULT NULL,
  `fog_near` float DEFAULT NULL,
  `fog_far` float DEFAULT NULL,
  `debris_mode` int(11) DEFAULT NULL,
  `light_backdrop` tinyint(1) DEFAULT NULL,
  `fog_backdrop` tinyint(1) DEFAULT NULL,
  `swap_backdrop` tinyint(1) DEFAULT NULL,
  `backdrop_fog_near` float DEFAULT NULL,
  `backdrop_fog_far` float DEFAULT NULL,
  `max_tilt` float DEFAULT NULL,
  `auto_level` tinyint(1) DEFAULT NULL,
  `impulse_rate` float DEFAULT NULL,
  `decay_velocity` float DEFAULT NULL,
  `decay_spin` float DEFAULT NULL,
  `backdrop_asset` int(11) DEFAULT NULL,
  `greetings` text,
  `notes` text,
  `system_id` int(11) DEFAULT NULL,
  `galaxy_x` float DEFAULT NULL,
  `galaxy_y` float DEFAULT NULL,
  `sector_ip_addr` bigint(20) DEFAULT NULL,
  `galaxy_z` float DEFAULT NULL,
  `sector_type` int(11) DEFAULT NULL,
  `challenge_rating` tinyint(4) DEFAULT '0' COMMENT 'Guided challenge rating for sector',
  PRIMARY KEY (`sector_id`),
  KEY `FK756F95CD5DF472C2` (`system_id`),
  CONSTRAINT `FK756F95CD5DF472C2` FOREIGN KEY (`system_id`) REFERENCES `systems` (`system_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4606 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `skill_abilities`
-- ----------------------------
DROP TABLE IF EXISTS `skill_abilities`;
CREATE TABLE `skill_abilities` (
  `ability_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `skill_id` bigint(20) NOT NULL DEFAULT '0',
  `min_level` int(11) NOT NULL DEFAULT '0',
  `description` varchar(512) NOT NULL DEFAULT 'none',
  `activation_cost` int(11) NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  PRIMARY KEY (`ability_id`)
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `skill_levels`
-- ----------------------------
DROP TABLE IF EXISTS `skill_levels`;
CREATE TABLE `skill_levels` (
  `skill_level_id` bigint(20) unsigned NOT NULL,
  `skill_id` bigint(20) NOT NULL,
  `level` int(11) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`skill_level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `skills`
-- ----------------------------
DROP TABLE IF EXISTS `skills`;
CREATE TABLE `skills` (
  `skill_id` bigint(20) NOT NULL,
  `name` text,
  `description` text,
  `is_activated` tinyint(1) DEFAULT NULL,
  `category` text,
  `warrior_max_level` int(11) DEFAULT NULL,
  `sentinal_max_level` int(11) DEFAULT NULL,
  `privateer_max_level` int(11) DEFAULT NULL,
  `defender_max_level` int(11) DEFAULT NULL,
  `explorer_max_level` int(11) DEFAULT NULL,
  `seeker_max_level` int(11) DEFAULT NULL,
  `enforcer_max_level` int(11) DEFAULT NULL,
  `scout_max_level` int(11) DEFAULT NULL,
  `tradesman_max_level` int(11) DEFAULT NULL,
  PRIMARY KEY (`skill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_npc_avatar_templates`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_npc_avatar_templates`;
CREATE TABLE `starbase_npc_avatar_templates` (
  `avatar_template_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `avatar_type` int(11) DEFAULT NULL,
  `avatar_version` tinyint(4) DEFAULT NULL,
  `race` int(11) DEFAULT NULL,
  `profession` int(11) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `mood_type` int(11) DEFAULT NULL,
  `personality` tinyint(4) DEFAULT NULL,
  `nlp` tinyint(4) DEFAULT NULL,
  `shirt_type` tinyint(4) DEFAULT NULL,
  `pants_type` tinyint(4) DEFAULT NULL,
  `head_type` tinyint(4) DEFAULT NULL,
  `hair_type` tinyint(4) DEFAULT NULL,
  `ear_type` tinyint(4) DEFAULT NULL,
  `goggle_num` tinyint(4) DEFAULT NULL,
  `beard_num` tinyint(4) DEFAULT NULL,
  `weapon_hip_num` tinyint(4) DEFAULT NULL,
  `weapon_unique_num` tinyint(4) DEFAULT NULL,
  `weapon_back_num` tinyint(4) DEFAULT NULL,
  `head_texture_num` tinyint(4) DEFAULT NULL,
  `tatoo_texture_num` tinyint(4) DEFAULT NULL,
  `tatoo_x` float DEFAULT NULL,
  `tatoo_y` float DEFAULT NULL,
  `tatoo_z` float DEFAULT NULL,
  `hair_color_0` float DEFAULT NULL,
  `hair_color_1` float DEFAULT NULL,
  `hair_color_2` float DEFAULT NULL,
  `beard_color_0` float DEFAULT NULL,
  `beard_color_1` float DEFAULT NULL,
  `beard_color_2` float DEFAULT NULL,
  `eye_color_0` float DEFAULT NULL,
  `eye_color_1` float DEFAULT NULL,
  `eye_color_2` float DEFAULT NULL,
  `skin_color_0` float DEFAULT NULL,
  `skin_color_1` float DEFAULT NULL,
  `skin_color_2` float DEFAULT NULL,
  `shirt1_color_0` float DEFAULT NULL,
  `shirt1_color_1` float DEFAULT NULL,
  `shirt1_color_2` float DEFAULT NULL,
  `shirt2_color_0` float DEFAULT NULL,
  `shirt2_color_1` float DEFAULT NULL,
  `shirt2_color_2` float DEFAULT NULL,
  `pants1_color_0` float DEFAULT NULL,
  `pants1_color_1` float DEFAULT NULL,
  `pants1_color_2` float DEFAULT NULL,
  `pants2_color_0` float DEFAULT NULL,
  `pants2_color_1` float DEFAULT NULL,
  `pants2_color_2` float DEFAULT NULL,
  `shirt1_metal` int(11) DEFAULT NULL,
  `shirt2_metal` int(11) DEFAULT NULL,
  `pants1_metal` int(11) DEFAULT NULL,
  `pants2_metal` int(11) DEFAULT NULL,
  `body_weight0` float DEFAULT NULL,
  `body_weight1` float DEFAULT NULL,
  `body_weight2` float DEFAULT NULL,
  `body_weight3` float DEFAULT NULL,
  `body_weight4` float DEFAULT NULL,
  `head_weight0` float DEFAULT NULL,
  `head_weight1` float DEFAULT NULL,
  `head_weight2` float DEFAULT NULL,
  `head_weight3` float DEFAULT NULL,
  `head_weight4` float DEFAULT NULL,
  PRIMARY KEY (`avatar_template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=673 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_npcs`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_npcs`;
CREATE TABLE `starbase_npcs` (
  `npc_Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(19) DEFAULT NULL,
  `last_name` varchar(19) DEFAULT NULL,
  `location` int(11) DEFAULT NULL,
  `faction_id` bigint(20) DEFAULT NULL,
  `description` varchar(255) NOT NULL DEFAULT 'description',
  `talk_tree_handle` varchar(64000) NOT NULL DEFAULT 'talk tree handle',
  `room_id` bigint(20) DEFAULT NULL,
  `npc_index` int(11) DEFAULT NULL,
  PRIMARY KEY (`npc_Id`),
  KEY `FK686FF44EC1D175D2` (`faction_id`),
  KEY `FK686FF44E127AF405` (`room_id`),
  KEY `FK686FF44E4945394` (`npc_Id`),
  KEY `FK_starbase_npcs_4` (`npc_Id`),
  CONSTRAINT `FK686FF44E127AF405` FOREIGN KEY (`room_id`) REFERENCES `starbase_rooms` (`room_id`),
  CONSTRAINT `FK686FF44E678609EC` FOREIGN KEY (`npc_Id`) REFERENCES `starbase_vendors` (`vendor_id`),
  CONSTRAINT `FK686FF44EC1D175D2` FOREIGN KEY (`faction_id`) REFERENCES `factions` (`faction_id`),
  CONSTRAINT `FK_starbase_npcs_4` FOREIGN KEY (`npc_Id`) REFERENCES `starbase_npc_avatar_templates` (`avatar_template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=673 DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 9216 kB; (`room_id`) REFER `enb_index/starbase_';

-- ----------------------------
-- Table structure for `starbase_room_type`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_room_type`;
CREATE TABLE `starbase_room_type` (
  `room_type` int(10) NOT NULL,
  `typeName` varchar(50) NOT NULL,
  PRIMARY KEY (`room_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_rooms`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_rooms`;
CREATE TABLE `starbase_rooms` (
  `room_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `style` int(11) DEFAULT NULL,
  `fog_near` int(11) DEFAULT NULL,
  `fog_far` int(11) DEFAULT NULL,
  `fog_red` int(11) unsigned zerofill DEFAULT '00000000000',
  `fog_green` int(11) unsigned zerofill DEFAULT '00000000000',
  `fog_blue` int(11) unsigned zerofill DEFAULT '00000000000',
  `description` varchar(255) DEFAULT NULL,
  `starbase_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`room_id`),
  KEY `FKA5C6ABDCD7388442` (`starbase_id`),
  CONSTRAINT `FKA5C6ABDCD7388442` FOREIGN KEY (`starbase_id`) REFERENCES `starbases` (`starbase_id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_terminals`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_terminals`;
CREATE TABLE `starbase_terminals` (
  `terminal_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `location` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `attribute` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `room_id` bigint(20) DEFAULT NULL,
  `terminal_index` int(11) DEFAULT NULL,
  `terminal_level` int(11) DEFAULT NULL,
  PRIMARY KEY (`terminal_id`),
  KEY `FK80ABBC5B127AF405` (`room_id`),
  CONSTRAINT `FK80ABBC5B127AF405` FOREIGN KEY (`room_id`) REFERENCES `starbase_rooms` (`room_id`)
) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_vender_groups`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_vender_groups`;
CREATE TABLE `starbase_vender_groups` (
  `GroupID` int(10) NOT NULL AUTO_INCREMENT,
  `GroupName` varchar(50) NOT NULL,
  `SellMultiplyer` float(10,2) NOT NULL DEFAULT '1.00',
  `BuyMultiplyer` float(10,2) NOT NULL DEFAULT '1.00',
  `BuyOnlyList` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`GroupID`)
) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_vender_inventory`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_vender_inventory`;
CREATE TABLE `starbase_vender_inventory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `groupid` int(10) NOT NULL,
  `itemid` int(10) NOT NULL DEFAULT '0',
  `sell_price` int(10) NOT NULL DEFAULT '0',
  `buy_price` int(10) NOT NULL DEFAULT '0',
  `quanity` int(10) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11272 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbase_vendors`
-- ----------------------------
DROP TABLE IF EXISTS `starbase_vendors`;
CREATE TABLE `starbase_vendors` (
  `vendor_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `level` int(11) DEFAULT '0',
  `booth_type` int(11) DEFAULT '-1',
  `groupid` int(10) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`vendor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=673 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `starbases`
-- ----------------------------
DROP TABLE IF EXISTS `starbases`;
CREATE TABLE `starbases` (
  `starbase_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sector_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `welcome_message` varchar(255) DEFAULT NULL,
  `target_sector_object` bigint(20) DEFAULT NULL,
  `faction_id` bigint(20) DEFAULT NULL,
  `starbase_sector_id` bigint(20) DEFAULT NULL,
  `challenge_rating` tinyint(4) DEFAULT '0' COMMENT 'Guided challenge rating for starbase',
  PRIMARY KEY (`starbase_id`),
  KEY `FK801DF0B0C1D175D2` (`faction_id`),
  CONSTRAINT `FK801DF0B0C1D175D2` FOREIGN KEY (`faction_id`) REFERENCES `factions` (`faction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `systems`
-- ----------------------------
DROP TABLE IF EXISTS `systems`;
CREATE TABLE `systems` (
  `system_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text,
  `galaxy_x` float DEFAULT NULL,
  `galaxy_y` float DEFAULT NULL,
  `galaxy_z` float DEFAULT NULL,
  `color_r` float DEFAULT NULL,
  `color_g` float DEFAULT NULL,
  `color_b` float DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`system_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `table_changes`
-- ----------------------------
DROP TABLE IF EXISTS `table_changes`;
CREATE TABLE `table_changes` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `tablename` varchar(100) NOT NULL,
  `modification` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `modified` varchar(50) NOT NULL,
  `new_values` varchar(12000) NOT NULL,
  `old_values` varchar(12000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `test_trigger`
-- ----------------------------
DROP TABLE IF EXISTS `test_trigger`;
CREATE TABLE `test_trigger` (
  `index` int(10) NOT NULL AUTO_INCREMENT,
  `test1` text NOT NULL,
  `test2` float(10,3) NOT NULL,
  `test3` varchar(1024) NOT NULL,
  `user` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`index`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `tirgger_save`
-- ----------------------------
DROP TABLE IF EXISTS `tirgger_save`;
CREATE TABLE `tirgger_save` (
  `table` varchar(1024) NOT NULL,
  `change` text NOT NULL,
  `index` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`index`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for `versions`
-- ----------------------------
DROP TABLE IF EXISTS `versions`;
CREATE TABLE `versions` (
  `EName` varchar(40) NOT NULL DEFAULT '',
  `Version` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`EName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- View structure for `ammo_launcher_view`
-- ----------------------------
DROP VIEW IF EXISTS `ammo_launcher_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `ammo_launcher_view` AS select `net7`.`item_projectile`.`item_id` AS `item_id`,`net7`.`item_projectile`.`ammo_type_id` AS `ammo_type_id` from (`item_ammo` join `item_projectile` on((`net7`.`item_ammo`.`ammo_type_id` = `net7`.`item_projectile`.`ammo_type_id`)));

-- ----------------------------
-- View structure for `basic_item_info_view`
-- ----------------------------
DROP VIEW IF EXISTS `basic_item_info_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `basic_item_info_view` AS select `net7`.`item_base`.`level` AS `level`,`net7`.`item_base`.`type` AS `type`,`net7`.`item_base`.`name` AS `name`,`net7`.`item_base`.`description` AS `description`,`net7`.`item_base`.`manufacturer` AS `manufacturer`,`net7`.`item_base`.`2d_asset` AS `2d_asset`,`net7`.`item_base`.`no_manu` AS `no_manu`,`net7`.`assets`.`filename` AS `filename`,`net7`.`item_type`.`name` AS `type_name`,`net7`.`item_manufacturer_base`.`name` AS `manu_name`,`net7`.`item_base`.`id` AS `item_id` from (((`item_base` join `assets`) join `item_type`) join `item_manufacturer_base`) where ((`net7`.`assets`.`base_id` = `net7`.`item_base`.`2d_asset`) and (`net7`.`item_base`.`type` = `net7`.`item_type`.`id`) and (`net7`.`item_manufacturer_base`.`id` = `net7`.`item_base`.`manufacturer`));

-- ----------------------------
-- View structure for `item_base_view`
-- ----------------------------
DROP VIEW IF EXISTS `item_base_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `item_base_view` AS select `net7`.`item_base`.`id` AS `id`,`net7`.`item_base`.`level` AS `level`,`net7`.`item_base`.`max_stack` AS `max_stack`,`net7`.`item_base`.`name` AS `name`,`net7`.`item_base`.`description` AS `description`,`net7`.`item_base`.`no_trade` AS `no_trade`,`net7`.`item_base`.`no_store` AS `no_store`,`net7`.`item_base`.`no_destroy` AS `no_destroy`,`net7`.`item_base`.`no_manu` AS `no_manu`,`net7`.`item_base`.`unique` AS `unique`,`net7`.`item_base`.`item_base_id` AS `item_base_id`,`net7`.`item_base`.`custom_flag` AS `custom_flag`,`net7`.`item_base`.`status` AS `status`,`net7`.`item_base`.`price` AS `price`,`net7`.`item_base`.`man_cost_base` AS `man_cost_base`,`net7`.`item_base`.`man_cost_mod` AS `man_cost_mod`,`net7`.`item_base`.`man_cost` AS `man_cost`,`net7`.`item_base`.`man_dif` AS `man_dif`,`net7`.`item_base`.`ana_dif` AS `ana_dif`,`net7`.`item_base`.`dis_dif` AS `dis_dif`,`net7`.`item_base`.`price_tweak` AS `price_tweak`,`net7`.`item_base`.`selling_price` AS `selling_price`,`net7`.`item_base`.`buying_price` AS `buying_price`,`net7`.`item_base`.`sell_mod` AS `sell_mod`,`net7`.`item_base`.`buy_mod` AS `buy_mod`,`net7`.`item_base`.`quality_mod` AS `quality_mod`,`net7`.`item_type`.`name` AS `type`,`net7`.`item_categories`.`category` AS `category`,`net7`.`item_subcategories`.`subcategory` AS `subcategory`,`net7`.`item_manufacturer_base`.`name` AS `manufacturer`,`net7`.`assets`.`filename` AS `2d_asset`,`net7`.`item_base`.`type` AS `type_id` from (((((`item_base` join `item_type`) join `item_categories`) join `item_subcategories`) join `item_manufacturer_base`) join `assets`) where ((`net7`.`item_base`.`type` = `net7`.`item_type`.`id`) and (`net7`.`item_base`.`category` = `net7`.`item_categories`.`id`) and (`net7`.`item_base`.`sub_category` = `net7`.`item_subcategories`.`id`) and (`net7`.`item_base`.`manufacturer` = `net7`.`item_manufacturer_base`.`id`) and (`net7`.`item_base`.`2d_asset` = `net7`.`assets`.`base_id`));

-- ----------------------------
-- View structure for `item_prof_race_view_all`
-- ----------------------------
DROP VIEW IF EXISTS `item_prof_race_view_all`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `item_prof_race_view_all` AS select `net7`.`item_base`.`id` AS `id`,`net7`.`item_base`.`level` AS `level`,`net7`.`item_base`.`name` AS `name`,`net7`.`item_base`.`description` AS `description` from (((`item_base` join `item_beam` on((`net7`.`item_beam`.`rest_race` = 3))) join `item_engine` on((`net7`.`item_engine`.`rest_race` = 3))) join `item_missile` on((`net7`.`item_missile`.`rest_race` = 3))) where ((`net7`.`item_beam`.`item_id` = `net7`.`item_base`.`id`) or (`net7`.`item_engine`.`item_id` = `net7`.`item_base`.`id`) or (`net7`.`item_missile`.`item_id` = `net7`.`item_base`.`id`)) group by `net7`.`item_base`.`id` limit 0,300;

-- ----------------------------
-- View structure for `mob_location_view`
-- ----------------------------
DROP VIEW IF EXISTS `mob_location_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `mob_location_view` AS select `net7`.`mob_spawn_group`.`mob_id` AS `mob_id`,`net7`.`mob_spawn_group`.`spawn_group_id` AS `spawn_group_id`,`net7`.`sectors`.`name` AS `name` from ((`mob_spawn_group` join `sectors`) join `sector_objects`) where ((`net7`.`sector_objects`.`sector_object_id` = `net7`.`mob_spawn_group`.`spawn_group_id`) and (`net7`.`sectors`.`sector_id` = `net7`.`sector_objects`.`sector_id`)) order by `net7`.`sectors`.`name`;

-- ----------------------------
-- View structure for `mob_select_view`
-- ----------------------------
DROP VIEW IF EXISTS `mob_select_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `mob_select_view` AS select `net7`.`mob_base`.`name` AS `name`,`net7`.`mob_base`.`level` AS `level`,`net7`.`mob_base`.`faction_id` AS `faction_id`,`net7`.`mob_base`.`aggressiveness` AS `aggressiveness`,`net7`.`mob_items`.`item_base_id` AS `item_base_id`,`net7`.`mob_items`.`drop_chance` AS `drop_chance`,`net7`.`mob_items`.`type` AS `type`,`net7`.`mob_items`.`qty` AS `qty`,`net7`.`mob_base`.`mob_id` AS `mob_base_id`,`net7`.`mob_items`.`mob_id` AS `mob_items_id` from (`mob_base` join `mob_items`);

-- ----------------------------
-- View structure for `vendor_info_view`
-- ----------------------------
DROP VIEW IF EXISTS `vendor_info_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `vendor_info_view` AS select `net7`.`starbase_npcs`.`first_name` AS `first_name`,`net7`.`starbase_npcs`.`last_name` AS `last_name`,`net7`.`starbases`.`name` AS `name`,`net7`.`sectors`.`name` AS `sec_name`,`net7`.`starbase_vender_inventory`.`groupid` AS `groupid`,`net7`.`starbase_vender_inventory`.`itemid` AS `itemid` from ((((((`starbase_vender_inventory` join `starbase_vender_groups` on((`net7`.`starbase_vender_groups`.`GroupID` = `net7`.`starbase_vender_inventory`.`groupid`))) join `starbase_vendors` on((`net7`.`starbase_vendors`.`groupid` = `net7`.`starbase_vender_groups`.`GroupID`))) join `starbase_npcs` on((`net7`.`starbase_npcs`.`npc_Id` = `net7`.`starbase_vendors`.`vendor_id`))) join `starbase_rooms` on((`net7`.`starbase_rooms`.`room_id` = `net7`.`starbase_npcs`.`room_id`))) join `starbases` on((`net7`.`starbase_rooms`.`starbase_id` = `net7`.`starbases`.`starbase_id`))) join `sectors` on((`net7`.`starbases`.`sector_id` = `net7`.`sectors`.`sector_id`)));

-- ----------------------------
-- View structure for `vendor_location_view`
-- ----------------------------
DROP VIEW IF EXISTS `vendor_location_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`Gundy`@`%` SQL SECURITY DEFINER VIEW `vendor_location_view` AS select `net7`.`starbases`.`name` AS `name`,`net7`.`sectors`.`name` AS `sec_name`,`net7`.`starbase_npcs`.`first_name` AS `first_name`,`net7`.`starbase_npcs`.`last_name` AS `last_name`,`net7`.`starbase_vender_inventory`.`groupid` AS `inventory_group`,`net7`.`starbase_vendors`.`groupid` AS `vendor_group`,`net7`.`starbase_vendors`.`level` AS `level` from ((((((`starbase_vender_inventory` join `starbase_vender_groups` on((`net7`.`starbase_vender_groups`.`GroupID` = `net7`.`starbase_vender_inventory`.`groupid`))) join `starbase_vendors` on((`net7`.`starbase_vendors`.`groupid` = `net7`.`starbase_vender_groups`.`GroupID`))) join `starbase_npcs` on((`net7`.`starbase_npcs`.`npc_Id` = `net7`.`starbase_vendors`.`vendor_id`))) join `starbase_rooms` on((`net7`.`starbase_rooms`.`room_id` = `net7`.`starbase_npcs`.`room_id`))) join `starbases` on((`net7`.`starbase_rooms`.`starbase_id` = `net7`.`starbases`.`starbase_id`))) join `sectors` on((`net7`.`starbases`.`sector_id` = `net7`.`sectors`.`sector_id`)));

-- ----------------------------
-- Procedure structure for `updateFactionMatrix`
-- ----------------------------
DROP PROCEDURE IF EXISTS `updateFactionMatrix`;
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `updateFactionMatrix`(IN `newID` integer)
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE curID INT;
  DECLARE cur1 CURSOR FOR SELECT faction_id FROM factions;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

  OPEN cur1;
    REPEAT
      FETCH cur1 INTO curID;
      IF (SELECT COUNT(*) FROM faction_matrix WHERE ((faction_id = newID) AND (faction_entry_id = curID))) = 0 THEN
        INSERT INTO faction_matrix(faction_id,faction_entry_id) VALUES(newID,curID);
      END IF;
      IF (SELECT COUNT(*) FROM faction_matrix WHERE ((faction_id = curID) AND (faction_entry_id = newID))) = 0 THEN
        INSERT INTO faction_matrix(faction_id,faction_entry_id) VALUES(curID,newID);
      END IF;
    UNTIL done END REPEAT;
  CLOSE cur1;
END
;;
DELIMITER ;