PHP sql_index_exists Exemples

Exemple #1

Fichier : dbsv-update.php Projet : harrieklomp/oc-server3

function dbv_138()
{
    if (!sql_index_exists('cache_reports', 'cacheid')) {
        sql("ALTER TABLE `cache_reports` ADD INDEX `cacheid` (`cacheid`)");
    }
    if (!sql_index_exists('cache_adoptions', 'from_user_id')) {
        sql("ALTER TABLE `cache_adoptions` ADD INDEX `from_user_id` (`from_user_id`)");
    }
    if (!sql_index_exists('cache_adoptions', 'to_user_id')) {
        sql("ALTER TABLE `cache_adoptions` ADD INDEX `to_user_id` (`to_user_id`)");
    }
    if (!sql_index_exists('cache_watches', 'user_id')) {
        sql("ALTER TABLE `cache_watches` ADD INDEX `user_id` (`user_id`)");
    }
    if (!sql_index_exists('notify_waiting', 'user_id')) {
        sql("ALTER TABLE `notify_waiting` ADD INDEX `user_id` (`user_id`)");
    }
    if (!sql_index_exists('stat_cache_logs', 'user_id')) {
        sql("ALTER TABLE `stat_cache_logs` ADD INDEX `user_id` (`user_id`)");
    }
    if (!sql_index_exists('watches_logqueue', 'user_id')) {
        sql("ALTER TABLE `watches_logqueue` ADD INDEX `user_id` (`user_id`)");
    }
}

Exemple #2

Fichier : dbsv-update.php Projet : kratenko/oc-server3

function dbv_151()
{
    if (!sql_field_exists('cache_logs', 'order_date')) {
        sql("ALTER TABLE `cache_logs` ADD COLUMN `order_date` DATETIME NOT NULL AFTER `date`");
        sql("UPDATE `cache_logs`\n             SET `order_date` =\n                IF(RIGHT(`date`, 8) <> '00:00:00' OR `date` > `date_created`, `date`,\n                   IF(LEFT(`date_created`, 10) = LEFT(`date`, 10), `date_created`,\n                      CONCAT(LEFT(`date`, 11), '23:59:58')\n                   )\n                )");
    }
    if (!sql_index_exists('cache_logs', 'order_date')) {
        sql("ALTER TABLE `cache_logs` ADD INDEX `order_date` (`cache_id`,`order_date`,`date_created`,`id`)");
    }
    if (!sql_field_exists('cache_logs_archived', 'order_date')) {
        sql("ALTER TABLE `cache_logs_archived` ADD COLUMN `order_date` DATETIME NOT NULL AFTER `date`");
        sql("UPDATE `cache_logs_archived`\n             SET `order_date` =\n                IF(RIGHT(`date`, 8) <> '00:00:00' OR `date` > `date_created`, `date`,\n                   IF(LEFT(`date_created`, 10) = LEFT(`date`, 10), `date_created`,\n                      CONCAT(LEFT(`date`, 11), '23:59:58')\n                   )\n                )");
    }
}

Exemple #3

Fichier : dbsv-update.php Projet : 4Vs/oc-server3

function dbv_112()
{
    if (!sql_field_exists('caches', 'wp_gc_maintained')) {
        sql("ALTER TABLE `caches` ADD COLUMN `wp_gc_maintained` varchar(7) NOT NULL AFTER `wp_gc`");
        sql("UPDATE `caches` SET `wp_gc_maintained`=UCASE(TRIM(`wp_gc`)) WHERE SUBSTR(TRIM(`wp_gc`),1,2)='GC'");
    }
    if (!sql_index_exists('caches', 'wp_gc_maintained')) {
        sql("ALTER TABLE `caches` ADD INDEX `wp_gc_maintained` (`wp_gc_maintained`)");
    }
}