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`)"); } }
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 )"); } }
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`)"); } }