| 1 |
CREATE TABLE `battles` ( |
|---|
| 2 |
`id` smallint(5) unsigned NOT NULL auto_increment, |
|---|
| 3 |
`x` smallint(6) NOT NULL default '1', |
|---|
| 4 |
`y` smallint(6) NOT NULL default '1', |
|---|
| 5 |
`system` smallint(6) NOT NULL default '1', |
|---|
| 6 |
`ally1` smallint(6) NOT NULL default '0', |
|---|
| 7 |
`ally2` smallint(6) NOT NULL default '0', |
|---|
| 8 |
`commander1` int(11) NOT NULL default '0', |
|---|
| 9 |
`com1Points` smallint(6) NOT NULL default '0', |
|---|
| 10 |
`commander2` int(11) NOT NULL default '0', |
|---|
| 11 |
`com2Points` smallint(6) NOT NULL default '0', |
|---|
| 12 |
`ready1` tinyint(1) unsigned NOT NULL default '0', |
|---|
| 13 |
`ready2` tinyint(1) unsigned NOT NULL default '0', |
|---|
| 14 |
`com1Msg` longtext character set latin1 NOT NULL, |
|---|
| 15 |
`com2Msg` longtext character set latin1 NOT NULL, |
|---|
| 16 |
`com1BETAK` tinyint(1) unsigned NOT NULL default '1', |
|---|
| 17 |
`com2BETAK` tinyint(1) unsigned NOT NULL default '1', |
|---|
| 18 |
`takeCommand1` mediumint(9) NOT NULL default '0', |
|---|
| 19 |
`takeCommand2` mediumint(9) NOT NULL default '0', |
|---|
| 20 |
`lastaction` int(10) unsigned NOT NULL default '0', |
|---|
| 21 |
`blockcount` tinyint(3) NOT NULL default '2', |
|---|
| 22 |
`lastturn` int(10) unsigned NOT NULL default '0', |
|---|
| 23 |
`flags` int(11) NOT NULL default '0', |
|---|
| 24 |
`inakt` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 25 |
`onend` text character set latin1, |
|---|
| 26 |
`visibility` text character set latin1, |
|---|
| 27 |
`quest` int(10) unsigned default NULL, |
|---|
| 28 |
`version` int(10) unsigned not null default '0', |
|---|
| 29 |
PRIMARY KEY (`id`), |
|---|
| 30 |
KEY `coords` (`x`,`y`,`system`) |
|---|
| 31 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Aktuelle Schlachten'; |
|---|
