From 91f3ddca55ae3ea32aeeb75c797e6c81bb9fd1a0 Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Wed, 22 Jul 2009 21:33:59 +1200
Subject: fixes file_redirection table to match mysql schema change in commit
 05e51228020fecaa894523b5159bc412d48e5b19

---
 db/laconica_pg.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'db/laconica_pg.sql')

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
-- 
cgit v1.2.3-54-g00ecf

