Changeset 9e9a5b976c6ab24550e6a9cc780287024f55111d
- Timestamp:
- 03/17/07 14:19:46
(2 years ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1174137586 +0100
- git-parent:
[59f888b22dd5f4173222dfb1d40720aae122d1b2]
- git-author:
- Christopher Jung <bktheg@web.de> 1174137586 +0100
- Message:
FK-Constraint fz.col eingebaut
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r425acaa |
r9e9a5b9 |
|
| 7 | 7 | PRIMARY KEY (`id`), |
|---|
| 8 | 8 | KEY `col` (`col`) |
|---|
| 9 | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| | 9 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| | 10 | |
|---|
| | 11 | ALTER TABLE fz ADD CONSTRAINT fz_fk_bases FOREIGN KEY (col) REFERENCES bases(id); |
|---|
| r59f888b |
r9e9a5b9 |
|
| 171 | 171 | ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_factions_shop_entries FOREIGN KEY (shopentry_id) REFERENCES factions_shop_entries(id); |
|---|
| 172 | 172 | ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_users FOREIGN KEY (user_id) REFERENCES users(id); |
|---|
| | 173 | ALTER TABLE fz ADD CONSTRAINT fz_fk_bases FOREIGN KEY (col) REFERENCES bases(id); |
|---|
| 173 | 174 | ]]></update> |
|---|
| 174 | 175 | </updates> |
|---|
