| | 73 | <update type="structure" datum="2007-01-06"><![CDATA[ |
|---|
| | 74 | CREATE TABLE `config_felsbrocken_systems` ( |
|---|
| | 75 | `system` tinyint(4) NOT NULL default '1', |
|---|
| | 76 | `count` int(11) NOT NULL default '1', |
|---|
| | 77 | PRIMARY KEY (`system`) |
|---|
| | 78 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| | 79 | |
|---|
| | 80 | INSERT INTO `config_felsbrocken_systems` (`system`, `count`) VALUES (7, 130); |
|---|
| | 81 | |
|---|
| | 82 | CREATE TABLE `config_felsbrocken` ( |
|---|
| | 83 | `id` int(11) NOT NULL auto_increment, |
|---|
| | 84 | `shiptype` int(11) NOT NULL default '0', |
|---|
| | 85 | `system` tinyint(4) NOT NULL default '1', |
|---|
| | 86 | `chance` tinyint(4) NOT NULL default '1', |
|---|
| | 87 | `cargo` varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', |
|---|
| | 88 | PRIMARY KEY (`id`), |
|---|
| | 89 | KEY `system` (`system`), |
|---|
| | 90 | KEY `fk_config_felsbrocken_shiptype` (`shiptype`) |
|---|
| | 91 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die verschiedenen Felsbrockenbestueckungen'; |
|---|
| | 92 | |
|---|
| | 93 | INSERT INTO `config_felsbrocken` (`id`, `shiptype`, `system`, `chance`, `cargo`) VALUES (1, 77, 7, 55, '0,0,0,0,0,0,0,0,0,4,0,0,0,0,7,0,0,0,'), |
|---|
| | 94 | (2, 77, 7, 28, '0,0,0,3,0,0,0,0,0,0,0,0,0,0,3,0,0,0,'), |
|---|
| | 95 | (3, 77, 7, 15, '0,0,0,0,0,0,0,6,0,0,0,0,0,0,20,0,0,0,'), |
|---|
| | 96 | (4, 77, 7, 2, '0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,1,0,0,'); |
|---|
| | 97 | |
|---|
| | 98 | ALTER TABLE `config_felsbrocken` |
|---|
| | 99 | ADD CONSTRAINT `fk_config_felsbrocken_system` FOREIGN KEY (`system`) REFERENCES `config_felsbrocken_systems` (`system`) ON DELETE NO ACTION ON UPDATE NO ACTION, |
|---|
| | 100 | ADD CONSTRAINT `fk_config_felsbrocken_shiptype` FOREIGN KEY (`shiptype`) REFERENCES `ship_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; |
|---|
| | 101 | ]]></update> |
|---|
