Changeset 9c3918a503ac0e821f5745c6e2d66e28ba9e5773
- Timestamp:
- 03/17/07 14:47:02
(1 year ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1174139222 +0100
- git-parent:
[39cd21147f344ca0c9adfd5c445b7ade0279ea3d]
- git-author:
- Christopher Jung <bktheg@web.de> 1174139222 +0100
- Message:
FK-Constraint offiziere.userid eingebaut
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r425acaa |
r9c3918a |
|
| 1 | 1 | CREATE TABLE `offiziere` ( |
|---|
| 2 | 2 | `id` int(11) NOT NULL auto_increment, |
|---|
| 3 | | `userid` mediumint(9) NOT NULL default '0', |
|---|
| | 3 | `userid` int(11) NOT NULL default '0', |
|---|
| 4 | 4 | `name` varchar(60) NOT NULL default 'noname', |
|---|
| 5 | 5 | `rang` tinyint(4) NOT NULL default '0', |
|---|
| … | … | |
| 20 | 20 | KEY `userid` (`userid`) |
|---|
| 21 | 21 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 22 | | |
|---|
| | 22 | |
|---|
| | 23 | ALTER TABLE offiziere ADD CONSTRAINT offiziere_fk_users FOREIGN KEY (userid) REFERENCES users(id); |
|---|
| r39cd211 |
r9c3918a |
|
| 179 | 179 | ALTER TABLE jumps CHANGE shipid shipid INT NOT NULL DEFAULT '0'; |
|---|
| 180 | 180 | ALTER TABLE jumps ADD CONSTRAINT jumps_fk_ships FOREIGN KEY (shipid) REFERENCES ships(id); |
|---|
| | 181 | ALTER TABLE offiziere CHANGE userid userid INT NOT NULL DEFAULT '0'; |
|---|
| | 182 | ALTER TABLE offiziere ADD CONSTRAINT offiziere_fk_users FOREIGN KEY (userid) REFERENCES users(id); |
|---|
| 181 | 183 | ]]></update> |
|---|
| 182 | 184 | </updates> |
|---|
