|
Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 1.0 kB
(checked in by Christopher Jung <bktheg@web.de>, 6 months ago)
|
[ref] SQL-Skripte aufgetrennt in seperate CREATE, ALTER und INSERT Teile.
|
- Property mode set to
100644
|
| Line | |
|---|
| 1 |
CREATE TABLE `ally` ( |
|---|
| 2 |
`id` int(11) NOT NULL auto_increment, |
|---|
| 3 |
`name` text NOT NULL, |
|---|
| 4 |
`plainname` varchar(255) NOT NULL default '', |
|---|
| 5 |
`founded` datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 6 |
`tick` int(11) NOT NULL default '0', |
|---|
| 7 |
`president` int(11) NOT NULL default '0', |
|---|
| 8 |
`description` text NOT NULL, |
|---|
| 9 |
`hp` text NOT NULL, |
|---|
| 10 |
`allytag` varchar(120) NOT NULL default '[name]', |
|---|
| 11 |
`showastis` tinyint(1) unsigned NOT NULL default '1', |
|---|
| 12 |
`showGtuBieter` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 13 |
`showlrs` tinyint(3) unsigned NOT NULL default '1', |
|---|
| 14 |
`pname` varchar(100) NOT NULL default 'Präsident', |
|---|
| 15 |
`items` text NOT NULL, |
|---|
| 16 |
`lostBattles` smallint(5) unsigned NOT NULL default '0', |
|---|
| 17 |
`wonBattles` smallint(5) unsigned NOT NULL default '0', |
|---|
| 18 |
`destroyedShips` int(10) unsigned NOT NULL default '0', |
|---|
| 19 |
`lostShips` int(10) unsigned NOT NULL default '0', |
|---|
| 20 |
`version` int(10) unsigned not null default '0', |
|---|
| 21 |
PRIMARY KEY (`id`) |
|---|
| 22 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
