X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fpr0n.sql;h=b8fcf86d0b46e44e0f739557ea45f9d12711a302;hp=fe749b9e6ed116717b796f24f8e558247d75cb5e;hb=8aa705cea40dddfcab6a6e5f151b4e66b9a88814;hpb=be4a3b9a54829a9fcea77f9c5eb5ea21ed34c0d0;ds=sidebyside

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,