From 002cc755b2a521486b0216e2d6f8a3952bda0bae Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Tue, 11 Aug 2009 09:25:13 +1200
Subject: change file.url to from a varchar(255) to varchar(2047) because urls
 get translated from tinyurl.com etc into their originals before saving and
 urls can be that long

---
 db/laconica_pg.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'db/laconica_pg.sql')

diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index b5626d3f4..59300c8ca 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -450,7 +450,7 @@ create index group_inbox_created_idx on group_inbox using btree(created);
 create sequence file_seq;
 create table file (
     id bigint default nextval('file_seq') primary key /* comment 'unique identifier' */,
-    url varchar(255) unique, 
+    url varchar(2047) unique, 
     mimetype varchar(50), 
     size integer, 
     title varchar(255), 
-- 
cgit v1.2.3-54-g00ecf

