Changeset 6af2de02a48bb6019f3271f65ae9d3016bb64456

Show
Ignore:
Timestamp:
05/01/07 11:29:15 (1 year ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1178011755 +0200
git-parent:

[fa8859f476b8460635b5023299a960e0159a6f14]

git-author:
Christopher Jung <bktheg@web.de> 1178011755 +0200
Message:

Indices modifiziert

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • db/tables/bases.sql

    r20fd726 r6af2de0  
    2424  `autogtuacts` text NOT NULL, 
    2525  PRIMARY KEY  (`id`), 
    26   KEY `owner` (`owner`), 
     26  KEY `owner` (`owner`,`id`), 
    2727  KEY `coords` (`x`,`y`,`system`) 
    2828) ENGINE=InnoDB DEFAULT CHARSET=utf8;  

  • db/tables/ships.sql

    rb831c9f r6af2de0  
    4141  PRIMARY KEY  (`id`), 
    4242  KEY `coords` (`x`,`y`,`system`), 
    43   KEY `owner` (`owner`), 
     43  KEY `owner` (`owner`,`id`), 
    4444  KEY `battle` (`battle`), 
    4545  KEY `status` (`status`), 

  • db/updates.xml

    rb831c9f r6af2de0  
    246246                ALTER TABLE `ships` CHANGE `destcom` `destcom` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; 
    247247        ]]></update> 
     248        <update type="structure" datum="2007-05-01"><![CDATA[ 
     249                ALTER TABLE ships DROP INDEX owner, ADD INDEX owner ( owner , id ); 
     250                ALTER TABLE bases DROP INDEX owner, ADD INDEX owner ( owner , id ); 
     251        ]]></update> 
    248252</updates>