From f104d311cd2e22aa6d09911de9d0facb79cbd055 Mon Sep 17 00:00:00 2001 From: Matt Selsky Date: Mon, 9 Nov 2009 22:57:20 -0500 Subject: [PATCH] Use varchar 255 to be consistent (and 255 is max size for older versions of mysql, etc) Bug: 8689 --- ansel/scripts/sql/ansel.pgsql.sql | 2 +- ansel/scripts/sql/ansel.sql | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/ansel/scripts/sql/ansel.pgsql.sql b/ansel/scripts/sql/ansel.pgsql.sql index 7679857cd..b9ff50f01 100644 --- a/ansel/scripts/sql/ansel.pgsql.sql +++ b/ansel/scripts/sql/ansel.pgsql.sql @@ -10,7 +10,7 @@ CREATE TABLE ansel_images ( image_original_date INT NOT NULL, image_latitude VARCHAR(32), image_longitude VARCHAR(32), - image_location VARCHAR(256), + image_location VARCHAR(255), image_geotag_date INT, -- PRIMARY KEY (image_id) diff --git a/ansel/scripts/sql/ansel.sql b/ansel/scripts/sql/ansel.sql index af7444a9c..2d6f29299 100644 --- a/ansel/scripts/sql/ansel.sql +++ b/ansel/scripts/sql/ansel.sql @@ -10,7 +10,7 @@ CREATE TABLE ansel_images ( image_original_date INT NOT NULL, image_latitude VARCHAR(32), image_longitude VARCHAR(32), - image_location VARCHAR(256), + image_location VARCHAR(255), image_geotag_date INT, -- PRIMARY KEY (image_id) @@ -133,7 +133,7 @@ CREATE TABLE ansel_images_geolocation ( image_id INT NOT NULL, image_latitude VARCHAR(32), image_longitude VARCHAR(32), - image_location VARCHAR(256), + image_location VARCHAR(255), -- PRIMARY KEY (image_id) ); -- 2.11.0