From a67be0b630867f7b14cf9e7593c89889a58eef2c Mon Sep 17 00:00:00 2001 From: Matt Selsky Date: Mon, 9 Nov 2009 23:02:39 -0500 Subject: [PATCH] Add missing image_location field. Make sure datatypes are capitalized and blank lines are prefixed with comment characters. --- ansel/scripts/sql/ansel.pgsql.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/ansel/scripts/sql/ansel.pgsql.sql b/ansel/scripts/sql/ansel.pgsql.sql index b9ff50f01..b54006bb3 100644 --- a/ansel/scripts/sql/ansel.pgsql.sql +++ b/ansel/scripts/sql/ansel.pgsql.sql @@ -128,9 +128,10 @@ CREATE TABLE ansel_images_tags ( CREATE TABLE ansel_images_geolocation ( image_id INT NOT NULL, - image_latitude varchar(32), - image_longitude varchar(32), - + image_latitude VARCHAR(32), + image_longitude VARCHAR(32), + image_location VARCHAR(255), +-- PRIMARY KEY (image_id) ); -- 2.11.0