summaryrefslogtreecommitdiff
path: root/db/laconica_pg.sql
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-07-22 21:33:59 +1200
committerBrenda Wallace <shiny@cpan.org>2009-07-22 21:33:59 +1200
commit91f3ddca55ae3ea32aeeb75c797e6c81bb9fd1a0 (patch)
tree83d3f9aead78b1d1b6a3380f02d7c6498a06bcce /db/laconica_pg.sql
parent6eaa91db1c80afa0811c0f465a18250ee63b490a (diff)
fixes file_redirection table to match mysql schema change in commit 05e51228020fecaa894523b5159bc412d48e5b19
Diffstat (limited to 'db/laconica_pg.sql')
-rw-r--r--db/laconica_pg.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql
index f0a0aef4a..de4fab03e 100644
--- a/db/laconica_pg.sql
+++ b/db/laconica_pg.sql
@@ -480,8 +480,7 @@ create table file_oembed (
create sequence file_redirection_seq;
create table file_redirection (
- id bigint default nextval('file_redirection_seq') primary key /* comment 'unique identifier' */,
- url varchar(255) unique,
+ url varchar(255) primary key,
file_id bigint,
redirections integer,
httpcode integer