CREATE TABLE `fleets` (
  `ID` varchar(150) NOT NULL default '0',
  `BaseID` varchar(150) NOT NULL default '0',
  `fleet` tinyint(1) NOT NULL default '1',
  `S0` int(11) unsigned NOT NULL default '0',
  `S1` int(11) unsigned NOT NULL default '0',
  `S2` int(11) unsigned NOT NULL default '0',
  `S3` int(11) unsigned NOT NULL default '0',
  `S4` int(11) unsigned NOT NULL default '0',
  `S5` int(11) unsigned NOT NULL default '0',
  `S6` int(11) unsigned NOT NULL default '0',
  `S7` int(11) unsigned NOT NULL default '0',
  `S8` int(11) unsigned NOT NULL default '0',
  `S9` int(11) unsigned NOT NULL default '0',
  `S10` int(11) unsigned NOT NULL default '0',
  `S11` int(11) unsigned NOT NULL default '0',
  `S12` int(11) unsigned NOT NULL default '0',
  `S13` int(11) unsigned NOT NULL default '0',
  `S14` int(11) unsigned NOT NULL default '0',
  `S15` int(11) unsigned NOT NULL default '0',
  `S16` int(11) unsigned NOT NULL default '0',
  `S17` int(11) unsigned NOT NULL default '0',
  `S18` int(11) unsigned NOT NULL default '0',
  `S19` int(11) unsigned NOT NULL default '0',
  `S20` int(11) unsigned NOT NULL default '0',
  `S21` int(11) unsigned NOT NULL default '0',
  `S22` int(11) unsigned NOT NULL default '0',
  `S23` int(11) unsigned NOT NULL default '0',
  `S24` int(11) unsigned NOT NULL default '0',
  `S25` int(11) unsigned NOT NULL default '0',
  `S26` int(11) unsigned NOT NULL default '0',
  `S27` int(11) unsigned NOT NULL default '0',
  `S28` int(11) unsigned NOT NULL default '0',
  `S29` int(11) unsigned NOT NULL default '0',
  `S30` int(11) unsigned NOT NULL default '0',
  `S31` int(11) unsigned NOT NULL default '0',
  `S32` int(11) unsigned NOT NULL default '0',
  `S33` int(11) unsigned NOT NULL default '0',
  `S34` int(11) unsigned NOT NULL default '0',
  `S35` int(11) unsigned NOT NULL default '0',
  `S36` int(11) unsigned NOT NULL default '0',
  `S37` int(11) unsigned NOT NULL default '0',
  `S38` int(11) unsigned NOT NULL default '0',
  `S39` int(11) unsigned NOT NULL default '0',
  `S40` int(11) unsigned NOT NULL default '0',
  `Mission` tinyint(2) unsigned NOT NULL default '0',
  `TargetID` varchar(150) NOT NULL default '',
  `TargetBaseID` varchar(150) NOT NULL default '',
  `ETA` tinyint(2) NOT NULL default '0',
  `ReturnETA` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`,`baseid`,`fleet`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
  `ID` varchar(150) NOT NULL default '',
  `BaseID` varchar(150) NOT NULL default '0',
  `x` int(11) unsigned NOT NULL,
  `y` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`id`,`baseid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Dygr6-Fc5rb-vY9b5-8q2jG-EVLPq-F4c4V-792cN-28P9X-G41Gn-5G1b9', 'moo', 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 1, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Dygr6-Fc5rb-vY9b5-8q2jG-EVLPq-F4c4V-792cN-28P9X-G41Gn-5G1b9', 'moo', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Dygr6-Fc5rb-vY9b5-8q2jG-EVLPq-F4c4V-792cN-28P9X-G41Gn-5G1b9', 'moo', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Dygr6-Fc5rb-vY9b5-8q2jG-EVLPq-F4c4V-792cN-28P9X-G41Gn-5G1b9', 'moo', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('nd562-66342-4F29m-q9B0s-X17Hm-k6441-43719-62909-jQ173-6kXns', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('nd562-66342-4F29m-q9B0s-X17Hm-k6441-43719-62909-jQ173-6kXns', '0', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('nd562-66342-4F29m-q9B0s-X17Hm-k6441-43719-62909-jQ173-6kXns', '0', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('nd562-66342-4F29m-q9B0s-X17Hm-k6441-43719-62909-jQ173-6kXns', '0', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 0, 1234, 0, 0, 0, 0, '', '', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0);
INSERT INTO `fleets` (`ID`, `BaseID`, `fleet`, `S0`, `S1`, `S2`, `S3`, `S4`, `S5`, `S6`, `S7`, `S8`, `S9`, `S10`, `S11`, `S12`, `S13`, `S14`, `S15`, `S16`, `S17`, `S18`, `S19`, `S20`, `S21`, `S22`, `S23`, `S24`, `S25`, `S26`, `S27`, `S28`, `S29`, `S30`, `S31`, `S32`, `S33`, `S34`, `S35`, `S36`, `S37`, `S38`, `S39`, `S40`, `Mission`, `TargetID`, `TargetBaseID`, `ETA`, `ReturnETA`) VALUES ('Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0);

INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('AllianceMailer', '0', 1, 1);
INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('nd562-66342-4F29m-q9B0s-X17Hm-k6441-43719-62909-jQ173-6kXns', '0', 5, 9);
INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('Z1N1g-PVR0p-3ZB1P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 1, 2);
INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('Z4N1g-PVR0p-3ZB1P-6h9t8-7x12b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 1, 2);
INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('Z4N1g-PVR0p-3ZB1P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 1, 2);
INSERT INTO `users` (`ID`, `BaseID`, `x`, `y`) VALUES ('Z4N4g-PVR0p-3ZB3P-6h9t8-7x22b-iC9h3-09225-5xY81-ptc2t-ZdN53', '0', 1, 2);