Override id sequence name, since later Postgres versions have changed the naming.
authorSteinar H. Gunderson <sgunderson@bigfoot.com>
Sun, 5 May 2013 11:21:52 +0000 (13:21 +0200)
committerSteinar H. Gunderson <sgunderson@bigfoot.com>
Sun, 5 May 2013 11:21:52 +0000 (13:21 +0200)
sql/pr0n.sql

index fe749b9e6ed116717b796f24f8e558247d75cb5e..b8fcf86d0b46e44e0f739557ea45f9d12711a302 100644 (file)
@@ -18,8 +18,10 @@ CREATE TABLE last_picture_cache (
    FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)
 );
 
    FOREIGN KEY (vhost,event) REFERENCES events(vhost,event)
 );
 
+CREATE SEQUENCE imageid_seq;
+
 CREATE TABLE images (
 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,
     vhost character varying NOT NULL,
     event character varying NOT NULL,
     filename character varying NOT NULL,