X-Git-Url: https://dev.renevier.net/?p=syj.git;a=blobdiff_plain;f=scripts%2Fschema.postgres.sql;fp=scripts%2Fschema.postgres.sql;h=bcbfef3e07c364f34854338fc2718d7113c8f189;hp=ea8777d1b07e23a2a4ddfd39d037762247c79ed7;hb=aad2e1cbf0a34d096c28388457aabfb8c307221b;hpb=a0c085f9492929c7b2bd6ada5cd1186d3133a44e

diff --git a/scripts/schema.postgres.sql b/scripts/schema.postgres.sql
index ea8777d..bcbfef3 100644
--- a/scripts/schema.postgres.sql
+++ b/scripts/schema.postgres.sql
@@ -102,7 +102,7 @@ CREATE TABLE paths (
     geom GEOGRAPHY (LINESTRING, 4326) NOT NULL,
     creator INTEGER REFERENCES users ON DELETE SET NULL,
     creator_ip INET NOT NULL,
-    title VARCHAR(40),
+    title VARCHAR(160),
     last_update TIMESTAMP NOT NULL DEFAULT NOW(),
     urlcomp VARCHAR(20) UNIQUE CHECK (urlcomp ~ '^[a-z][a-zA-Z0-9_]*$') -- ~: matches regular expression; case sensitive
 );