PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.19_rename_geocode_cache.sql   Download  
File: database/migrations/v1.11.0.19_rename_geocode_cache.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 314 bytes
 

Contents

Class file image Download 
-- Rename bbs_directory_geocode_cache to geocode_cache so it serves as a
-- shared geocoding service for both the BBS Directory and the Nodelist map.

ALTER TABLE bbs_directory_geocode_cache RENAME TO geocode_cache;

ALTER INDEX idx_bbs_directory_geocode_cache_cached_at
    RENAME TO idx_geocode_cache_cached_at;