diff options
| author | Brenda Wallace <shiny@cpan.org> | 2009-08-10 09:41:07 +1200 |
|---|---|---|
| committer | Brenda Wallace <shiny@cpan.org> | 2009-08-10 09:42:53 +1200 |
| commit | c1b19929f6234c4b9e30e16bae419c89c38c1169 (patch) | |
| tree | f5611d8fb21eea0f5ca4399284ad180440dbfe91 | |
| parent | 4a0a6c96ceeb1fe236c94dcc35be804abf1b5f84 (diff) | |
changed file.url column type from varcahr(255) to varchar(2047)
| -rw-r--r-- | db/074to080.sql | 2 | ||||
| -rw-r--r-- | db/074to080_pg.sql | 2 | ||||
| -rw-r--r-- | db/laconica.sql | 2 | ||||
| -rw-r--r-- | db/laconica_pg.sql | 2 |
4 files changed, 4 insertions, 4 deletions
diff --git a/db/074to080.sql b/db/074to080.sql index ff0819159..e667798eb 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(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/074to080_pg.sql b/db/074to080_pg.sql index 0a7171ae5..e1cb92c7f 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(255) unique, + url varchar(2047) unique, mimetype varchar(50), size integer, title varchar(255), diff --git a/db/laconica.sql b/db/laconica.sql index 2c04f680a..c1b76d1fa 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 ad34720a2..4fe223380 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), |