summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-08-11 14:41:48 +1200
committerBrenda Wallace <shiny@cpan.org>2009-08-11 14:41:48 +1200
commitf2cd83dd51e856022e75b0e3c5bffb333bf10c8e (patch)
treeb689c14f5382b32ba6ca21bcb35a287d4282f00d
parentbbf10e5bdf3ee0dfa372b170da6e25bee859b3c5 (diff)
Revert "changed file.url column type from varcahr(255) to varchar(2047)"
This reverts commit c1b19929f6234c4b9e30e16bae419c89c38c1169.
-rw-r--r--db/074to080.sql2
-rw-r--r--db/074to080_pg.sql2
-rw-r--r--db/laconica.sql2
-rw-r--r--db/laconica_pg.sql2
4 files changed, 4 insertions, 4 deletions
diff --git a/db/074to080.sql b/db/074to080.sql
index e667798eb..ff0819159 100644
--- a/db/074to080.sql
+++ b/db/074to080.sql
@@ -17,7 +17,7 @@ alter table user_group
create table file (
id integer primary key auto_increment,
- url varchar(2047) comment 'destination URL after following redirections',
+ url varchar(255) comment 'destination URL after following redirections',
mimetype varchar(50) comment 'mime type of resource',
size integer comment 'size of resource when available',
title varchar(255) comment 'title of resource when available',
diff --git a/db/074to080_pg.sql b/db/074to080_pg.sql
index e1cb92c7f..0a7171ae5 100644
--- a/db/074to080_pg.sql
+++ b/db/074to080_pg.sql
@@ -36,7 +36,7 @@ alter table user_group
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),
diff --git a/db/laconica.sql b/db/laconica.sql
index c1b76d1fa..2c04f680a 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -433,7 +433,7 @@ create table group_inbox (
create table file (
id integer primary key auto_increment,
- url varchar(2047) comment 'destination URL after following redirections',
+ url varchar(255) comment 'destination URL after following redirections',
mimetype varchar(50) comment 'mime type of resource',
size integer comment 'size of resource when available',
title varchar(255) comment 'title of resource when available',
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index 4fe223380..ad34720a2 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),