diff options
| author | Brenda Wallace <shiny@cpan.org> | 2009-08-11 09:25:13 +1200 |
|---|---|---|
| committer | Brenda Wallace <shiny@cpan.org> | 2009-08-11 09:25:13 +1200 |
| commit | 002cc755b2a521486b0216e2d6f8a3952bda0bae (patch) | |
| tree | 2ac330eec7f5f177bc5530a57f82c9504b8d95da | |
| parent | 91399d89dd6f1bd4447690fc6e87c2ffba81f2b4 (diff) | |
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
| -rw-r--r-- | db/laconica.sql | 2 | ||||
| -rw-r--r-- | db/laconica_pg.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/db/laconica.sql b/db/laconica.sql index f01107176..ff8c4c13e 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(255) comment 'destination URL after following redirections', + url varchar(2047) 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 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), |