[Toolserver-l] No keys/indexes on wiki databases?

Hi. I've notice that there are no keys and so probably no indexes on toolserver databases. Is this intentional? I've used below queries - both show no keys/indexes on revision table: SHOW COLUMNS FROMplwiki_p.revision; SHOW INDEX FROM plwiki_p.revision; I've also exported the whole schema

Re: [Toolserver-l] No keys/indexes on wiki databases?

You are only seeing views, not the actual tables. There are the standard index plus a few TS specific indexes On Saturday, March 16, 2013, Maciej Jaros wrote: Hi. I've notice that there are no keys and so probably no indexes on toolserver databases. Is this intentional? I've used below

Re: [Toolserver-l] No keys/indexes on wiki databases?

Maciej Jaros e...@wp.pl wrote: I've notice that there are no keys and so probably no indexes on toolserver databases. Is this intentional? I've used below queries - both show no keys/indexes on revision table: SHOW COLUMNS FROMplwiki_p.revision; SHOW INDEX FROM plwiki_p.revision; I've

Re: [Toolserver-l] No keys/indexes on wiki databases?

If you wonder what the standard indexes are, there's a link to the SVN source on https://wiki.toolserver.org/view/Database_access#Database_schema Regards, Morten On 16 March 2013 12:20, Tim Landscheidt t...@tim-landscheidt.de wrote: Maciej Jaros e...@wp.pl wrote: I've notice that there