Changeset ec292509a8750e87e13b68e2fa236ac7706bea91
- Timestamp:
- 03/17/07 14:03:54
(2 years ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1174136634 +0100
- git-parent:
[12676585ba100d724ee89e914e7a954fce69068a]
- git-author:
- Christopher Jung <bktheg@web.de> 1174136634 +0100
- Message:
SQL gefixt
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r1518810 |
rec29250 |
|
| 1 | 1 | CREATE TABLE `battles` ( |
|---|
| 2 | | `id` smallint(6) unsigned NOT NULL auto_increment, |
|---|
| | 2 | `id` int(11) NOT NULL auto_increment, |
|---|
| 3 | 3 | `x` smallint(6) NOT NULL default '1', |
|---|
| 4 | 4 | `y` smallint(6) NOT NULL default '1', |
|---|
| … | … | |
| 29 | 29 | KEY `coords` (`x`,`y`,`system`) |
|---|
| 30 | 30 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Aktuelle Schlachten'; |
|---|
| 31 | | |
|---|
| 32 | | ALTER TABLE battles_ships ADD CONSTRAINT battles_ships_fk_battles FOREIGN KEY (battleid) REFERENCES battles(id); |
|---|
