PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.18_nodelist_coordinates.sql   Download  
File: database/migrations/v1.11.0.18_nodelist_coordinates.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: 1 month ago
Size: 360 bytes
 

Contents

Class file image Download 
-- Migration: v1.11.0.18 - Add geocoding coordinates to nodelist table

ALTER TABLE nodelist
    ADD COLUMN IF NOT EXISTS latitude  DECIMAL(10,6) NULL,
    ADD COLUMN IF NOT EXISTS longitude DECIMAL(10,6) NULL;

CREATE INDEX IF NOT EXISTS idx_nodelist_coordinates
    ON nodelist (latitude, longitude)
    WHERE latitude IS NOT NULL AND longitude IS NOT NULL;