WordPress.org
Get WordPress

Plugin Directory

Changeset 429283


Ignore:
Timestamp:
08/27/2011 12:34:15 AM (15 years ago)
Author:
hawk__
Message:

Improved SHOW INDEX for upgrades to detect indices correctly and so don't try to recreate them

File:
1 edited

Legend:

Unmodified
Added
Removed

  • postgresql-for-wordpress/trunk/pg4wp/driver_pgsql_install.php

    r429262 r429283  
    3030    function pg4wp_installing( $sql, &$logto)
    3131    {
    32         global $table_prefix;
     32        global $wpdb;
    3333       
    3434        // SHOW INDEX emulation
    … …  
    4141$sql = 'SELECT bc.relname AS "Table",
    4242    CASE WHEN i.indisunique THEN \'0\' ELSE \'1\' END AS "Non_unique",
    43     CASE WHEN i.indisprimary THEN \'PRIMARY\' WHEN bc.relname LIKE \'%usermeta\' AND ic.relname = \'umeta_key\' THEN \'meta_key\' ELSE ic.relname END AS "Key_name",
     43    CASE WHEN i.indisprimary THEN \'PRIMARY\' WHEN bc.relname LIKE \'%usermeta\' AND ic.relname = \'umeta_key\'
     44        THEN \'meta_key\' ELSE REPLACE( ic.relname, \''.$table.'_\', \'\') END AS "Key_name",
    4445    a.attname AS "Column_name",
    4546    NULL AS "Sub_part"
Note: See TracChangeset for help on using the changeset viewer.