Changeset 5189e17e5be09531fd632abb60c1d4975cac20fa
- Timestamp:
- 04/29/07 10:25:23
(1 year ago)
- Author:
- Christopher Jung <bktheg@web.de>
- git-committer:
- Christopher Jung <bktheg@web.de> 1177835123 +0200
- git-parent:
[998c2a2c0cc046f998ad501025d42bd941b059c3]
- git-author:
- Christopher Jung <bktheg@web.de> 1177835123 +0200
- Message:
Ein paar DB-Updates im Zuge des Syncs mit der rds-DB
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r425acaa |
r5189e17 |
|
| 12 | 12 | `hidden` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 13 | 13 | PRIMARY KEY (`id`), |
|---|
| 14 | | KEY `x` (`x`), |
|---|
| 15 | | KEY `y` (`y`), |
|---|
| 16 | | KEY `system` (`system`) |
|---|
| | 14 | KEY `coords` (`x`,`y`,`system`) |
|---|
| 17 | 15 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 18 | 16 | |
|---|
| rb139234 |
r5189e17 |
|
| 1 | 1 | CREATE TABLE `sessions` ( |
|---|
| 2 | 2 | `id` int(11) NOT NULL default '0', |
|---|
| 3 | | `session` varchar(36) default NULL, |
|---|
| | 3 | `session` varchar(36) NOT NULL default '', |
|---|
| 4 | 4 | `ip` text NOT NULL, |
|---|
| 5 | 5 | `lastaction` int(10) unsigned NOT NULL default '0', |
|---|
| … | … | |
| 8 | 8 | `tick` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 9 | 9 | `attach` varchar(36) default NULL, |
|---|
| 10 | | KEY `session` (`session`) |
|---|
| | 10 | PRIMARY KEY (`session`) |
|---|
| 11 | 11 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
| 12 | 12 | |
|---|
| rf7d0517 |
r5189e17 |
|
| 29 | 29 | `battle` int(11) NOT NULL default '0', |
|---|
| 30 | 30 | `battleAction` tinyint(1) unsigned NOT NULL default '0', |
|---|
| 31 | | `jumptarget` varchar(11) NOT NULL default '', |
|---|
| | 31 | `jumptarget` varchar(100) NOT NULL default '', |
|---|
| 32 | 32 | `autodeut` tinyint(3) unsigned NOT NULL default '1', |
|---|
| 33 | 33 | `history` text NOT NULL, |
|---|
| rade629d |
r5189e17 |
|
| 9 | 9 | `allypic` int(11) NOT NULL default '0', |
|---|
| 10 | 10 | `tick` mediumint(8) unsigned NOT NULL default '0', |
|---|
| 11 | | `channel` tinyint(3) unsigned NOT NULL default '1', |
|---|
| | 11 | `channel` int(10) unsigned NOT NULL default '1', |
|---|
| 12 | 12 | PRIMARY KEY (`post`), |
|---|
| 13 | 13 | KEY `channel` (`channel`) |
|---|
| ra2ac3f9 |
r5189e17 |
|
| 193 | 193 | ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_users FOREIGN KEY (user) REFERENCES users(id); |
|---|
| 194 | 194 | ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id); |
|---|
| 195 | | ALTER TABLE skn ADD CONSTRAINT skn_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id); |
|---|
| 196 | 195 | ALTER TABLE skn ADD CONSTRAINT skn_fk_users FOREIGN KEY (userid) REFERENCES users(id); |
|---|
| 197 | 196 | ALTER TABLE stats_module_locations ADD CONSTRAINT stats_module_locations_fk_user_id FOREIGN KEY (user_id) REFERENCES users(id); |
|---|
| … | … | |
| 229 | 228 | ALTER TABLE quests_quick CHANGE target target VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; |
|---|
| 230 | 229 | ]]></update> |
|---|
| | 230 | <update type="structure" datum="2007-04-28"><![CDATA[ |
|---|
| | 231 | ALTER TABLE skn CHANGE channel channel int(10) unsigned NOT NULL DEFAULT '1'; |
|---|
| | 232 | ALTER TABLE skn ADD CONSTRAINT skn_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id); |
|---|
| | 233 | ALTER TABLE `jumpnodes` DROP INDEX `system`; |
|---|
| | 234 | ALTER TABLE `jumpnodes` DROP INDEX `x`; |
|---|
| | 235 | ALTER TABLE `jumpnodes` DROP INDEX `y`; |
|---|
| | 236 | ALTER TABLE `jumpnodes` ADD INDEX `coords` ( `x` , `y` , `system` ); |
|---|
| | 237 | ALTER TABLE `sessions` ADD PRIMARY KEY ( `session` ); |
|---|
| | 238 | ALTER TABLE `sessions` DROP INDEX `session`; |
|---|
| | 239 | ALTER TABLE `ships` CHANGE `jumptarget` `jumptarget` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; |
|---|
| | 240 | ]]></update> |
|---|
| 231 | 241 | </updates> |
|---|
