MySQL to MSSQL

I'd like to get this schema imported to MSSQL but I need to do some conversion on it. But I'm not sure which datatypes map from MySQL to MSSQL best. The scheme is below...

I'd also like to keep the indexes/primary keys etc


-- --------------------------------------------------------

--
-- Table structure for table 'TL2MaterialsForTypeWithActivity'
--

CREATE TABLE TL2MaterialsForTypeWithActivity (
  typeID int(11) NOT NULL default '0',
  activity int(11) NOT NULL default '0',
  requiredTypeID int(11) NOT NULL default '0',
  quantity int(11) default NULL,
  damagePerJob double default NULL,
  PRIMARY KEY  (typeID,activity,requiredTypeID),
  KEY TL2MaterialsForTypeWithActivity_INDX1 (typeID),
  KEY TL2MaterialsForTypeWithActivity_INDX2 (activity),
  KEY TL2MaterialsForTypeWithActivity_INDX3 (requiredTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'agtAgentTypes'
--

CREATE TABLE agtAgentTypes (
  agentTypeID int(11) NOT NULL default '0',
  agentType char(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (agentTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'agtAgents'
--

CREATE TABLE agtAgents (
  agentID int(11) NOT NULL default '0',
  divisionID int(11) default NULL,
  corporationID int(11) default NULL,
  stationID int(11) default NULL,
  "level" int(11) default NULL,
  quality int(11) default NULL,
  agentTypeID int(11) default NULL,
  PRIMARY KEY  (agentID),
  KEY agtAgents_INDX2 (divisionID),
  KEY agtAgents_INDX3 (corporationID),
  KEY agtAgents_INDX4 (stationID),
  KEY agtAgents_INDX5 (agentTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'agtConfig'
--

CREATE TABLE agtConfig (
  agentID int(11) NOT NULL default '0',
  k varchar(50) collate utf8_unicode_ci NOT NULL default '',
  v text collate utf8_unicode_ci,
  PRIMARY KEY  (agentID,k),
  KEY agtConfig_INDX1 (agentID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'chrBloodlines'
--

CREATE TABLE chrBloodlines (
  bloodlineID int(11) NOT NULL default '0',
  bloodlineName varchar(100) collate utf8_unicode_ci default NULL,
  raceID int(11) default NULL,
  description text collate utf8_unicode_ci,
  maleDescription text collate utf8_unicode_ci,
  femaleDescription text collate utf8_unicode_ci,
  shipTypeID int(11) default NULL,
  corporationID int(11) default NULL,
  perception int(11) default NULL,
  willpower int(11) default NULL,
  charisma int(11) default NULL,
  memory int(11) default NULL,
  intelligence int(11) default NULL,
  bonusTypeID int(11) default NULL,
  skillTypeID1 int(11) default NULL,
  skillTypeID2 int(11) default NULL,
  graphicID int(11) default NULL,
  PRIMARY KEY  (bloodlineID),
  KEY chrBloodlines_INDX1 (raceID),
  KEY chrBloodlines_INDX2 (shipTypeID),
  KEY chrBloodlines_INDX3 (corporationID),
  KEY chrBloodlines_INDX4 (bonusTypeID),
  KEY chrBloodlines_INDX5 (skillTypeID1),
  KEY chrBloodlines_INDX6 (skillTypeID2),
  KEY chrBloodlines_INDX7 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'chrFactions'
--

CREATE TABLE chrFactions (
  factionID int(11) NOT NULL default '0',
  factionName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  raceIDs int(11) default NULL,
  solarSystemID int(11) default NULL,
  corporationID int(11) default NULL,
  sizeFactor double default NULL,
  stationCount int(11) default NULL,
  stationSystemCount int(11) default NULL,
  PRIMARY KEY  (factionID),
  KEY chrFactions_INDX1 (solarSystemID),
  KEY chrFactions_INDX2 (corporationID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'chrMinerals'
--

CREATE TABLE chrMinerals (
  charID int(11) NOT NULL default '0',
  charName varchar(100) collate utf8_unicode_ci default NULL,
  typeID int(11) default NULL,
  typeQuantity int(11) default NULL,
  KEY chrMinerals_INDX1 (charName),
  KEY chrMinerals_INDX2 (typeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'chrRaces'
--

CREATE TABLE chrRaces (
  raceID int(11) NOT NULL default '0',
  raceName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  skillTypeID1 int(11) default NULL,
  typeID int(11) default NULL,
  typeQuantity int(11) default NULL,
  graphicID int(11) default NULL,
  PRIMARY KEY  (raceID),
  KEY chrRaces_INDX1 (skillTypeID1),
  KEY chrRaces_INDX2 (typeID),
  KEY chrRaces_INDX3 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'chrSchools'
--

CREATE TABLE chrSchools (
  raceID int(11) default NULL,
  schoolID int(11) NOT NULL default '0',
  schoolName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  corporationID int(11) default NULL,
  agentID int(11) default NULL,
  newAgentID int(11) default NULL,
  PRIMARY KEY  (schoolID),
  KEY chrSchools_INDX1 (raceID),
  KEY chrSchools_INDX2 (graphicID),
  KEY chrSchools_INDX3 (corporationID),
  KEY chrSchools_INDX4 (agentID),
  KEY chrSchools_INDX5 (newAgentID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'crpNPCCorporationActivityTypes'
--

CREATE TABLE crpNPCCorporationActivityTypes (
  activity int(11) NOT NULL default '0',
  description char(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (activity)
);

-- --------------------------------------------------------

--
-- Table structure for table 'crpNPCCorporationDivisions'
--

CREATE TABLE crpNPCCorporationDivisions (
  corporationID int(11) NOT NULL default '0',
  divisionID int(11) NOT NULL default '0',
  divisionNumber int(11) default NULL,
  size int(11) default NULL,
  leaderID int(11) default NULL,
  PRIMARY KEY  (corporationID,divisionID),
  KEY crpNPCCorporationDivisions_INDX1 (corporationID),
  KEY crpNPCCorporationDivisions_INDX2 (divisionID),
  KEY crpNPCCorporationDivisions_INDX3 (divisionNumber),
  KEY crpNPCCorporationDivisions_INDX4 (leaderID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'crpNPCCorporations'
--

CREATE TABLE crpNPCCorporations (
  corporationID int(11) NOT NULL default '0',
  mainActivityID int(11) default NULL,
  secondaryActivityID int(11) default NULL,
  size char(1) collate utf8_unicode_ci default NULL,
  extent char(1) collate utf8_unicode_ci default NULL,
  solarSystemID int(11) default NULL,
  investorID1 int(11) default NULL,
  investorShares1 int(11) default NULL,
  investorID2 int(11) default NULL,
  investorShares2 int(11) default NULL,
  investorID3 int(11) default NULL,
  investorShares3 int(11) default NULL,
  investorID4 int(11) default NULL,
  investorShares4 int(11) default NULL,
  friendID int(11) default NULL,
  enemyID int(11) default NULL,
  publicShares int(11) default NULL,
  initialPrice int(11) default NULL,
  minSecurity double default NULL,
  scattered int(11) default NULL,
  fringe int(11) default NULL,
  corridor int(11) default NULL,
  hub int(11) default NULL,
  border int(11) default NULL,
  factionID int(11) default NULL,
  sizeFactor double default NULL,
  stationCount int(11) default NULL,
  stationSystemCount int(11) default NULL,
  PRIMARY KEY  (corporationID),
  KEY crpNPCCorporations_INDX1 (mainActivityID),
  KEY crpNPCCorporations_INDX2 (secondaryActivityID),
  KEY crpNPCCorporations_INDX3 (solarSystemID),
  KEY crpNPCCorporations_INDX4 (factionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'crpNPCDivisions'
--

CREATE TABLE crpNPCDivisions (
  divisionID int(11) NOT NULL default '0',
  divisionName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  leaderType varchar(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (divisionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'dgmAttributeTypes'
--

CREATE TABLE dgmAttributeTypes (
  attributeID int(11) NOT NULL default '0',
  attributeName varchar(100) collate utf8_unicode_ci default NULL,
  attributeCategory int(11) default NULL,
  description text collate utf8_unicode_ci,
  maxAttributeID int(11) default NULL,
  attributeIdx int(11) default NULL,
  graphicID int(11) default NULL,
  chargeRechargeTimeID int(11) default NULL,
  defaultValue int(11) default NULL,
  published int(11) default NULL,
  displayName varchar(100) collate utf8_unicode_ci default NULL,
  unitID int(11) default NULL,
  stackable int(11) default NULL,
  highIsGood int(11) default NULL,
  PRIMARY KEY  (attributeID),
  KEY dgmAttributeTypes_INDX3 (graphicID),
  KEY dgmAttributeTypes_INDX4 (unitID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'dgmEffects'
--

CREATE TABLE dgmEffects (
  effectID int(11) NOT NULL default '0',
  effectName text collate utf8_unicode_ci,
  effectCategory int(11) default NULL,
  preExpression int(11) default NULL,
  postExpression int(11) default NULL,
  description text collate utf8_unicode_ci,
  guid varchar(60) collate utf8_unicode_ci default NULL,
  graphicID int(11) default NULL,
  isOffensive int(11) default NULL,
  isAssistance int(11) default NULL,
  durationAttributeID int(11) default NULL,
  trackingSpeedAttributeID int(11) default NULL,
  dischargeAttributeID int(11) default NULL,
  rangeAttributeID int(11) default NULL,
  falloffAttributeID int(11) default NULL,
  disallowAutoRepeat int(11) default NULL,
  published int(11) default NULL,
  displayName varchar(100) collate utf8_unicode_ci default NULL,
  isWarpSafe int(11) default NULL,
  rangeChance int(11) default NULL,
  electronicChance int(11) default NULL,
  propulsionChance int(11) default NULL,
  distribution int(11) default NULL,
  sfxName varchar(20) collate utf8_unicode_ci default NULL,
  npcUsageChanceAttributeID int(11) default NULL,
  npcActivationChanceAttributeID int(11) default NULL,
  fittingUsageChanceAttributeID int(11) default NULL,
  PRIMARY KEY  (effectID),
  KEY dgmEffects_INDX4 (graphicID),
  KEY dgmEffects_INDX5 (durationAttributeID),
  KEY dgmEffects_INDX6 (trackingSpeedAttributeID),
  KEY dgmEffects_INDX7 (dischargeAttributeID),
  KEY dgmEffects_INDX8 (rangeAttributeID),
  KEY dgmEffects_INDX9 (falloffAttributeID),
  KEY dgmEffects_INDX10 (npcUsageChanceAttributeID),
  KEY dgmEffects_INDX11 (npcActivationChanceAttributeID),
  KEY dgmEffects_INDX12 (fittingUsageChanceAttributeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'dgmTypeAttributes'
--

CREATE TABLE dgmTypeAttributes (
  typeID int(11) NOT NULL default '0',
  attributeID int(11) NOT NULL default '0',
  valueInt int(11) default NULL,
  valueFloat double default NULL,
  PRIMARY KEY  (typeID,attributeID),
  KEY dgmTypeAttributes_INDX1 (typeID),
  KEY dgmTypeAttributes_INDX2 (attributeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'dgmTypeEffects'
--

CREATE TABLE dgmTypeEffects (
  typeID int(11) NOT NULL default '0',
  effectID int(11) NOT NULL default '0',
  isDefault int(11) default NULL,
  PRIMARY KEY  (typeID,effectID),
  KEY dgmTypeEffects_INDX1 (typeID),
  KEY dgmTypeEffects_INDX2 (effectID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'eveGraphics'
--

CREATE TABLE eveGraphics (
  graphicID int(11) NOT NULL default '0',
  url3D varchar(100) collate utf8_unicode_ci default NULL,
  urlWeb varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  published int(11) default NULL,
  obsolete int(11) default NULL,
  icon varchar(100) collate utf8_unicode_ci default NULL,
  urlSound varchar(100) collate utf8_unicode_ci default NULL,
  explosionID int(11) default NULL,
  PRIMARY KEY  (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'eveNames'
--

CREATE TABLE eveNames (
  itemID int(11) NOT NULL default '0',
  itemName char(100) collate utf8_unicode_ci default NULL,
  categoryID int(11) default NULL,
  groupID int(11) default NULL,
  typeID int(11) default NULL,
  PRIMARY KEY  (itemID),
  KEY eveNames_INDX1 (categoryID),
  KEY eveNames_INDX2 (groupID),
  KEY eveNames_INDX3 (typeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'eveUnits'
--

CREATE TABLE eveUnits (
  unitID int(11) NOT NULL default '0',
  unitName varchar(100) collate utf8_unicode_ci default NULL,
  displayName varchar(20) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  PRIMARY KEY  (unitID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invBlueprintTypes'
--

CREATE TABLE invBlueprintTypes (
  blueprintTypeID int(11) NOT NULL default '0',
  parentBlueprintTypeID int(11) default NULL,
  productTypeID int(11) default NULL,
  productionTime int(11) default NULL,
  techLevel int(11) default NULL,
  researchProductivityTime int(11) default NULL,
  researchMaterialTime int(11) default NULL,
  researchCopyTime int(11) default NULL,
  researchTechTime int(11) default NULL,
  productivityModifier int(11) default NULL,
  materialModifier int(11) default NULL,
  wasteFactor int(11) default NULL,
  chanceOfReverseEngineering double default NULL,
  maxProductionLimit int(11) default NULL,
  PRIMARY KEY  (blueprintTypeID),
  KEY invBlueprintTypes_INDX1 (productTypeID),
  KEY invBlueprintTypes_INDX2 (parentBlueprintTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invCategories'
--

CREATE TABLE invCategories (
  categoryID int(11) NOT NULL default '0',
  categoryName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  PRIMARY KEY  (categoryID),
  KEY invCategories_INDX1 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invContrabandTypes'
--

CREATE TABLE invContrabandTypes (
  factionID int(11) NOT NULL default '0',
  typeID int(11) NOT NULL default '0',
  standingLoss double default NULL,
  confiscateMinSec double default NULL,
  fineByValue double default NULL,
  attackMinSec double default NULL,
  PRIMARY KEY  (factionID,typeID),
  KEY invContrabandTypes_INDX1 (factionID),
  KEY invContrabandTypes_INDX2 (typeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invControlTowerResourcePurposes'
--

CREATE TABLE invControlTowerResourcePurposes (
  purpose int(11) NOT NULL default '0',
  purposeText char(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (purpose)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invControlTowerResources'
--

CREATE TABLE invControlTowerResources (
  controlTowerTypeID int(11) NOT NULL default '0',
  resourceTypeID int(11) NOT NULL default '0',
  purpose int(11) default NULL,
  quantity int(11) default NULL,
  minSecurityLevel double default NULL,
  factionID int(11) default NULL,
  PRIMARY KEY  (controlTowerTypeID,resourceTypeID),
  KEY invControlTowerResources_INDX1 (controlTowerTypeID),
  KEY invControlTowerResources_INDX2 (resourceTypeID),
  KEY invControlTowerResources_INDX3 (factionID),
  KEY invControlTowerResources_INDX4 (purpose)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invGroups'
--

CREATE TABLE invGroups (
  groupID int(11) NOT NULL default '0',
  categoryID int(11) default NULL,
  groupName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  useBasePrice int(11) default NULL,
  allowManufacture int(11) default NULL,
  allowRecycler int(11) default NULL,
  anchored int(11) default NULL,
  anchorable int(11) default NULL,
  fittableNonSingleton int(11) default NULL,
  PRIMARY KEY  (groupID),
  KEY invGroups_INDX1 (categoryID),
  KEY invGroups_INDX2 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invMarketGroups'
--

CREATE TABLE invMarketGroups (
  marketGroupID int(11) NOT NULL default '0',
  parentGroupID int(11) default NULL,
  marketGroupName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  hasTypes int(11) default NULL,
  PRIMARY KEY  (marketGroupID),
  KEY invMarketGroups_INDX1 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invMetaGroups'
--

CREATE TABLE invMetaGroups (
  metaGroupID int(11) NOT NULL default '0',
  metaGroupName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  PRIMARY KEY  (metaGroupID),
  KEY invMetaGroups_INDX1 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invMetaTypes'
--

CREATE TABLE invMetaTypes (
  typeID int(11) NOT NULL default '0',
  parentTypeID int(11) default NULL,
  metaGroupID int(11) default NULL,
  PRIMARY KEY  (typeID),
  KEY invMetaTypes_INDX1 (typeID),
  KEY invMetaTypes_INDX2 (parentTypeID),
  KEY invMetaTypes_INDX3 (metaGroupID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'invTypes'
--

CREATE TABLE invTypes (
  typeID int(11) NOT NULL default '0',
  groupID int(11) default NULL,
  typeName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  graphicID int(11) default NULL,
  radius double default NULL,
  mass double default NULL,
  volume double default NULL,
  capacity double default NULL,
  portionSize int(11) default NULL,
  raceID int(11) default NULL,
  basePrice double default NULL,
  published int(11) default NULL,
  marketGroupID int(11) default NULL,
  chanceOfDuplicating double default NULL,
  PRIMARY KEY  (typeID),
  KEY invTypes_INDX1 (groupID),
  KEY invTypes_INDX2 (graphicID),
  KEY invTypes_INDX3 (raceID),
  KEY invTypes_INDX4 (marketGroupID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapConstellationJumps'
--

CREATE TABLE mapConstellationJumps (
  fromRegionID int(11) default NULL,
  fromConstellationID int(11) NOT NULL default '0',
  toConstellationID int(11) NOT NULL default '0',
  toRegionID int(11) default NULL,
  PRIMARY KEY  (fromConstellationID,toConstellationID),
  KEY mapConstellationJumps_INDX1 (fromRegionID),
  KEY mapConstellationJumps_INDX2 (fromConstellationID),
  KEY mapConstellationJumps_INDX3 (toConstellationID),
  KEY mapConstellationJumps_INDX4 (toRegionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapConstellations'
--

CREATE TABLE mapConstellations (
  regionID int(11) default NULL,
  constellationID int(11) NOT NULL default '0',
  constellationName char(100) collate utf8_unicode_ci default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  xMin double default NULL,
  xMax double default NULL,
  yMin double default NULL,
  yMax double default NULL,
  zMin double default NULL,
  zMax double default NULL,
  factionID int(11) default NULL,
  radius double default NULL,
  PRIMARY KEY  (constellationID),
  KEY mapConstellations_INDX1 (regionID),
  KEY mapConstellations_INDX2 (factionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapDenormalize'
--

CREATE TABLE mapDenormalize (
  itemID int(11) NOT NULL default '0',
  typeID int(11) default NULL,
  groupID int(11) default NULL,
  solarSystemID int(11) default NULL,
  constellationID int(11) default NULL,
  regionID int(11) default NULL,
  orbitID int(11) default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  radius double default NULL,
  itemName char(100) collate utf8_unicode_ci default NULL,
  security double default NULL,
  PRIMARY KEY  (itemID),
  KEY mapDenormalize_INDX2 (typeID),
  KEY mapDenormalize_INDX3 (groupID),
  KEY mapDenormalize_INDX4 (solarSystemID),
  KEY mapDenormalize_INDX5 (constellationID),
  KEY mapDenormalize_INDX6 (regionID),
  KEY mapDenormalize_INDX7 (orbitID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapJumps'
--

CREATE TABLE mapJumps (
  stargateID int(11) NOT NULL default '0',
  celestialID int(11) NOT NULL default '0',
  PRIMARY KEY  (stargateID,celestialID),
  KEY mapJumps_INDX1 (stargateID),
  KEY mapJumps_INDX2 (celestialID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapLandmarks'
--

CREATE TABLE mapLandmarks (
  landmarkID int(11) NOT NULL default '0',
  landmarkName varchar(100) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  locationID int(11) default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  radius double default NULL,
  graphicID int(11) default NULL,
  importance int(11) default NULL,
  url2d varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (landmarkID),
  KEY mapLandmarks_INDX2 (graphicID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapRegionJumps'
--

CREATE TABLE mapRegionJumps (
  fromRegionID int(11) NOT NULL default '0',
  toRegionID int(11) NOT NULL default '0',
  PRIMARY KEY  (fromRegionID,toRegionID),
  KEY mapRegionJumps_INDX1 (fromRegionID),
  KEY mapRegionJumps_INDX2 (fromRegionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapRegions'
--

CREATE TABLE mapRegions (
  regionID int(11) NOT NULL default '0',
  regionName char(100) collate utf8_unicode_ci default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  xMin double default NULL,
  xMax double default NULL,
  yMin double default NULL,
  yMax double default NULL,
  zMin double default NULL,
  zMax double default NULL,
  factionID int(11) default NULL,
  radius double default NULL,
  PRIMARY KEY  (regionID),
  KEY mapRegions_INDX1 (factionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapSolarSystemJumps'
--

CREATE TABLE mapSolarSystemJumps (
  fromRegionID int(11) default NULL,
  fromConstellationID int(11) default NULL,
  fromSolarSystemID int(11) NOT NULL default '0',
  toSolarSystemID int(11) NOT NULL default '0',
  toConstellationID int(11) default NULL,
  toRegionID int(11) default NULL,
  PRIMARY KEY  (fromSolarSystemID,toSolarSystemID),
  KEY mapSolarSystemJumps_INDX1 (fromRegionID),
  KEY mapSolarSystemJumps_INDX2 (fromConstellationID),
  KEY mapSolarSystemJumps_INDX3 (fromSolarSystemID),
  KEY mapSolarSystemJumps_INDX4 (toSolarSystemID),
  KEY mapSolarSystemJumps_INDX5 (toConstellationID),
  KEY mapSolarSystemJumps_INDX6 (toRegionID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapSolarSystems'
--

CREATE TABLE mapSolarSystems (
  regionID int(11) default NULL,
  constellationID int(11) default NULL,
  solarSystemID int(11) NOT NULL default '0',
  solarSystemName char(100) collate utf8_unicode_ci default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  xMin double default NULL,
  xMax double default NULL,
  yMin double default NULL,
  yMax double default NULL,
  zMin double default NULL,
  zMax double default NULL,
  luminosity double default NULL,
  border int(11) default NULL,
  fringe int(11) default NULL,
  corridor int(11) default NULL,
  hub int(11) default NULL,
  international int(11) default NULL,
  regional int(11) default NULL,
  constellation int(11) default NULL,
  security double default NULL,
  factionID int(11) default NULL,
  radius double default NULL,
  sunTypeID int(11) default NULL,
  securityClass char(2) collate utf8_unicode_ci default NULL,
  allianceID int(11) default NULL,
  PRIMARY KEY  (solarSystemID),
  KEY mapSolarSystems_INDX1 (regionID),
  KEY mapSolarSystems_INDX2 (constellationID),
  KEY mapSolarSystems_INDX3 (factionID),
  KEY mapSolarSystems_INDX4 (sunTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'mapUniverse'
--

CREATE TABLE mapUniverse (
  universeID int(11) NOT NULL default '0',
  universeName char(100) collate utf8_unicode_ci default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  xMin double default NULL,
  xMax double default NULL,
  yMin double default NULL,
  yMax double default NULL,
  zMin double default NULL,
  zMax double default NULL,
  radius double default NULL,
  PRIMARY KEY  (universeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'matActivityTypes'
--

CREATE TABLE matActivityTypes (
  activity int(11) NOT NULL default '0',
  description char(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (activity)
);

-- --------------------------------------------------------

--
-- Table structure for table 'staOperationServices'
--

CREATE TABLE staOperationServices (
  operationID int(11) NOT NULL default '0',
  serviceID int(11) NOT NULL default '0',
  PRIMARY KEY  (operationID,serviceID),
  KEY staOperationServices_INDX1 (operationID),
  KEY staOperationServices_INDX2 (serviceID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'staOperations'
--

CREATE TABLE staOperations (
  activityID int(11) default NULL,
  operationID int(11) NOT NULL default '0',
  operationName varchar(255) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  fringe int(11) default NULL,
  corridor int(11) default NULL,
  hub int(11) default NULL,
  border int(11) default NULL,
  ratio int(11) default NULL,
  caldariStationTypeID int(11) default NULL,
  minmatarStationTypeID int(11) default NULL,
  amarrStationTypeID int(11) default NULL,
  gallenteStationTypeID int(11) default NULL,
  joveStationTypeID int(11) default NULL,
  PRIMARY KEY  (operationID),
  KEY staOperations_INDX1 (activityID),
  KEY staOperations_INDX2 (caldariStationTypeID),
  KEY staOperations_INDX3 (minmatarStationTypeID),
  KEY staOperations_INDX4 (amarrStationTypeID),
  KEY staOperations_INDX5 (gallenteStationTypeID),
  KEY staOperations_INDX6 (joveStationTypeID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'staServices'
--

CREATE TABLE staServices (
  serviceID int(11) NOT NULL default '0',
  serviceName varchar(255) collate utf8_unicode_ci default NULL,
  description text collate utf8_unicode_ci,
  PRIMARY KEY  (serviceID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'staStationTypes'
--

CREATE TABLE staStationTypes (
  stationTypeID int(11) NOT NULL default '0',
  dockingBayGraphicID int(11) default NULL,
  hangarGraphicID int(11) default NULL,
  dockEntryX int(11) default NULL,
  dockEntryY int(11) default NULL,
  dockEntryZ int(11) default NULL,
  dockOrientationX int(11) default NULL,
  dockOrientationY int(11) default NULL,
  dockOrientationZ int(11) default NULL,
  operationID int(11) default NULL,
  officeSlots int(11) default NULL,
  reprocessingEfficiency double default NULL,
  conquerable tinyint(1) default NULL,
  PRIMARY KEY  (stationTypeID),
  KEY staStationTypes_INDX1 (dockingBayGraphicID),
  KEY staStationTypes_INDX2 (hangarGraphicID),
  KEY staStationTypes_INDX3 (operationID)
);

-- --------------------------------------------------------

--
-- Table structure for table 'staStations'
--

CREATE TABLE staStations (
  stationID int(11) NOT NULL default '0',
  security int(11) default NULL,
  dockingCostPerVolume int(11) default NULL,
  maxShipVolumeDockable int(11) default NULL,
  officeRentalCost int(11) default NULL,
  operationID int(11) default NULL,
  stationTypeID int(11) default NULL,
  corporationID int(11) default NULL,
  solarSystemID int(11) default NULL,
  constellationID int(11) default NULL,
  regionID int(11) default NULL,
  stationName char(255) collate utf8_unicode_ci default NULL,
  x double default NULL,
  y double default NULL,
  z double default NULL,
  reprocessingEfficiency double default NULL,
  reprocessingStationsTake double default NULL,
  reprocessingHangarFlag int(11) default NULL,
  PRIMARY KEY  (stationID),
  KEY staStations_INDX1 (operationID),
  KEY staStations_INDX2 (stationTypeID),
  KEY staStations_INDX3 (corporationID),
  KEY staStations_INDX4 (solarSystemID),
  KEY staStations_INDX5 (constellationID),
  KEY staStations_INDX6 (regionID)
);
Start Free Trial