| 1 |
CREATE TABLE `ammo` ( |
|---|
| 2 |
`id` int(11) unsigned NOT NULL auto_increment, |
|---|
| 3 |
`name` varchar(30) NOT NULL default '', |
|---|
| 4 |
`description` tinytext NOT NULL, |
|---|
| 5 |
`replaces` int(11) unsigned default NULL, |
|---|
| 6 |
`res1` int(11) NOT NULL default '0', |
|---|
| 7 |
`res2` int(11) NOT NULL default '0', |
|---|
| 8 |
`res3` int(11) NOT NULL default '0', |
|---|
| 9 |
`type` varchar(10) NOT NULL default 'rak', |
|---|
| 10 |
`damage` smallint(6) unsigned NOT NULL default '0', |
|---|
| 11 |
`shielddamage` smallint(6) unsigned NOT NULL default '0', |
|---|
| 12 |
`subdamage` smallint(5) unsigned NOT NULL default '0', |
|---|
| 13 |
`trefferws` smallint(6) unsigned NOT NULL default '0', |
|---|
| 14 |
`smalltrefferws` tinyint(3) unsigned NOT NULL default '50', |
|---|
| 15 |
`torptrefferws` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 16 |
`subws` smallint(5) unsigned NOT NULL default '0', |
|---|
| 17 |
`shotspershot` tinyint(3) unsigned NOT NULL default '1', |
|---|
| 18 |
`areadamage` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 19 |
`destroyable` float(3,2) unsigned NOT NULL default '0.00', |
|---|
| 20 |
`flags` int(10) unsigned NOT NULL default '0', |
|---|
| 21 |
`itemid` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 22 |
`dauer` float NOT NULL default '0.01', |
|---|
| 23 |
`buildcosts` varchar(120) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', |
|---|
| 24 |
`picture` varchar(20) NOT NULL default '', |
|---|
| 25 |
PRIMARY KEY (`id`) |
|---|
| 26 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Raketen, Flak, Torpedomunition'; |
|---|
