root/sovereignty/tables.sql @ 247

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. Oktober 2007 um 07:12
-- Server Version: 4.1.20
-- PHP-Version: 5.2.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `evedev_sov`
--

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

--
-- Tabellenstruktur für Tabelle `alliances`
--

CREATE TABLE IF NOT EXISTS `alliances` (
  `name` varchar(200) NOT NULL default '',
  `shortName` varchar(20) NOT NULL default '',
  `allianceID` int(11) NOT NULL default '0',
  `executorCorpID` int(11) NOT NULL default '0',
  `memberCount` int(11) NOT NULL default '0',
  `startDate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`allianceID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapalliancecolors`
--

CREATE TABLE IF NOT EXISTS `mapalliancecolors` (
  `allianceID` int(11) NOT NULL default '0',
  `allianceColor` char(6) NOT NULL default '',
  PRIMARY KEY  (`allianceID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapinfluenceinject`
--

CREATE TABLE IF NOT EXISTS `mapinfluenceinject` (
  `solarSystemID` int(11) NOT NULL default '0',
  `influence` int(11) NOT NULL default '0',
  PRIMARY KEY  (`solarSystemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapoutposts`
--

CREATE TABLE IF NOT EXISTS `mapoutposts` (
  `added` date NOT NULL default '0000-00-00',
  `solarSystemID` int(11) NOT NULL default '0',
  `allianceID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`solarSystemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapregions`
--

CREATE TABLE IF NOT EXISTS `mapregions` (
  `regionID` int(11) NOT NULL default '0',
  `regionName` varchar(100) NOT NULL default '',
  `x` double NOT NULL default '0',
  `y` double NOT NULL default '0',
  `z` double NOT NULL default '0',
  `xMin` double NOT NULL default '0',
  `xMax` double NOT NULL default '0',
  `yMin` double NOT NULL default '0',
  `yMax` double NOT NULL default '0',
  `zMin` double NOT NULL default '0',
  `zMax` double NOT NULL default '0',
  `factionID` int(11) default NULL,
  `radius` double NOT NULL default '0',
  PRIMARY KEY  (`regionID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `maprendertarget`
--

CREATE TABLE IF NOT EXISTS `maprendertarget` (
  `id` int(11) NOT NULL auto_increment,
  `date1` date NOT NULL default '0000-00-00',
  `date2` date NOT NULL default '0000-00-00',
  `options` varchar(60) NOT NULL default '',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `prio` tinyint(1) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `lastupdate` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;

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

--
-- Tabellenstruktur für Tabelle `mapsolarsystemjumps`
--

CREATE TABLE IF NOT EXISTS `mapsolarsystemjumps` (
  `fromRegionID` int(11) NOT NULL default '0',
  `fromConstellationID` int(11) NOT NULL default '0',
  `fromSolarSystemID` int(11) NOT NULL default '0',
  `toSolarSystemID` int(11) NOT NULL default '0',
  `toConstellationID` int(11) NOT NULL default '0',
  `toRegionID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fromSolarSystemID`,`toSolarSystemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapsolarsystems`
--

CREATE TABLE IF NOT EXISTS `mapsolarsystems` (
  `regionID` int(11) NOT NULL default '0',
  `constellationID` int(11) NOT NULL default '0',
  `solarSystemID` int(11) NOT NULL default '0',
  `solarSystemName` varchar(100) NOT NULL default '',
  `x` double NOT NULL default '0',
  `y` double NOT NULL default '0',
  `z` double NOT NULL default '0',
  `xMin` double NOT NULL default '0',
  `xMax` double NOT NULL default '0',
  `yMin` double NOT NULL default '0',
  `yMax` double NOT NULL default '0',
  `zMin` double NOT NULL default '0',
  `zMax` double NOT NULL default '0',
  `luminosity` double NOT NULL default '0',
  `border` tinyint(1) NOT NULL default '0',
  `fringe` tinyint(1) NOT NULL default '0',
  `corridor` tinyint(1) NOT NULL default '0',
  `hub` tinyint(1) NOT NULL default '0',
  `international` tinyint(1) NOT NULL default '0',
  `regional` tinyint(1) NOT NULL default '0',
  `constellation` tinyint(1) NOT NULL default '0',
  `security` double NOT NULL default '0',
  `factionID` int(11) default NULL,
  `radius` double NOT NULL default '0',
  `sunTypeID` smallint(6) default NULL,
  `securityClass` char(2) default NULL,
  `allianceID` int(11) default NULL,
  PRIMARY KEY  (`solarSystemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `mapsovdates`
--

CREATE TABLE IF NOT EXISTS `mapsovdates` (
  `date` date NOT NULL default '0000-00-00',
  UNIQUE KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Tabellenstruktur für Tabelle `mapsovereignty`
--

CREATE TABLE IF NOT EXISTS `mapsovereignty` (
  `date` date NOT NULL default '0000-00-00',
  `solarSystemID` int(11) NOT NULL default '0',
  `allianceID` int(11) NOT NULL default '0',
  `constellationSovereignty` tinyint(4) NOT NULL default '0',
  `sovereigntyLevel` tinyint(4) NOT NULL default '0',
  `factionID` int(11) NOT NULL default '0',
  `solarSystemName` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`date`,`solarSystemID`),
  KEY `allianceID` (`allianceID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;