From: Steinar H. Gunderson <sgunderson@bigfoot.com>
Date: Sun, 5 May 2013 11:21:52 +0000 (+0200)
Subject: Override id sequence name, since later Postgres versions have changed the naming.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=8aa705cea40dddfcab6a6e5f151b4e66b9a88814;hp=be4a3b9a54829a9fcea77f9c5eb5ea21ed34c0d0

Override id sequence name, since later Postgres versions have changed the naming.
---

diff --git a/sql/pr0n.sql b/sql/pr0n.sql
index fe749b9..b8fcf86 100644
--- a/sql/pr0n.sql
+++ b/sql/pr0n.sql
@@ -18,8 +18,10 @@ CREATE TABLE last_picture_cache (
    FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)
 );
 
+CREATE SEQUENCE imageid_seq;
+
 CREATE TABLE images (
-    id serial NOT NULL PRIMARY KEY,
+    id integer DEFAULT nextval('imageid_seq') NOT NULL PRIMARY KEY,
     vhost character varying NOT NULL,
     event character varying NOT NULL,
     filename character varying NOT NULL,