From f4f13166f712153b704329804be5508d78437cdd Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Tue, 11 Aug 2009 09:38:17 +1200
Subject: Revert "change file.url to from a varchar(255) to varchar(2047)"

This reverts commit 002cc755b2a521486b0216e2d6f8a3952bda0bae.

mysql doesn't allow varchar > 255 chars
reverting until have a working solution
---
 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 59300c8ca..b5626d3f4 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(2047) unique, 
+    url varchar(255) unique, 
     mimetype varchar(50), 
     size integer, 
     title varchar(255), 
-- 
cgit v1.2.3-54-g00ecf

