Fix more validation errors.

[pr0n] / sql / pr0n.sql

diff --git a/sql/pr0n.sql b/sql/pr0n.sql
index 5407ce812b1f043628044f760cdb8350dac15d79..9d1f9374d3bae4e86a9fbd92dfa288d17cfb8c77 100644 (file)
--- a/sql/pr0n.sql
+++ b/sql/pr0n.sql
@@ -2,12 +2,17 @@ CREATE TABLE events (
     id character varying NOT NULL PRIMARY KEY,
     date character varying NOT NULL,
     name character varying NOT NULL,
     id character varying NOT NULL PRIMARY KEY,
     date character varying NOT NULL,
     name character varying NOT NULL,

-    vhost character varying NOT NULL,
-    last_picture timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
+    vhost character varying NOT NULL
+);
+
+-- In a separate table to avoid deadlocks.
+CREATE TABLE last_picture_cache ( 
+   event varchar PRIMARY KEY references events ( id ),
+   last_picture timestamp without time zone

 );
 
 CREATE TABLE images (
 );
 
 CREATE TABLE images (

-    id integer serial NOT NULL PRIMARY KEY REFERENCES events(id),
+    id serial NOT NULL PRIMARY KEY REFERENCES events(id),

     event character varying NOT NULL,
     filename character varying NOT NULL,
     width integer DEFAULT -1 NOT NULL,
     event character varying NOT NULL,
     filename character varying NOT NULL,
     width integer DEFAULT -1 NOT NULL,