PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.10_bbs_geocode_cache.sql   Download  
File: database/migrations/v1.11.0.10_bbs_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: 473 bytes
 

Contents

Class file image Download 
-- Migration: 1.11.0.10 - Add BBS directory geocode cache

CREATE TABLE IF NOT EXISTS bbs_directory_geocode_cache (
    id SERIAL PRIMARY KEY,
    location_key VARCHAR(64) NOT NULL UNIQUE,
    normalized_location VARCHAR(255) NOT NULL,
    latitude DECIMAL(10,6) NULL,
    longitude DECIMAL(10,6) NULL,
    cached_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_bbs_directory_geocode_cache_cached_at
    ON bbs_directory_geocode_cache (cached_at);