Changeset 164 for trunk/doc/schema-postgres.sql

Timestamp:

05/13/09 21:17:02 (7 months ago)

Author:

miyagawa

Message:

PostgreSQL patch from clkao

Files:

• trunk/doc/schema-postgres.sql (modified) (1 diff)

trunk/doc/schema-postgres.sql

@@ -32 +32 @@
         grabbed_until   INTEGER NOT NULL,
         priority        SMALLINT,
-        coalesce        VARCHAR(255),
-        UNIQUE(funcid, uniqkey)
+        coalesce        VARCHAR(255)
 );
+
+CREATE UNIQUE INDEX job_funcid_uniqkey ON job (funcid, uniqkey);
 
 CREATE INDEX job_funcid_runafter ON job (funcid, run_after);