moving purpose to record instead of queue
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 14 May 2008 16:58:12 +0000 (16:58 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 14 May 2008 16:58:12 +0000 (16:58 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@9601 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/sql/Pg/012.schema.vandelay.sql

index 5cdb1ce..3475e19 100644 (file)
@@ -17,7 +17,7 @@ CREATE TABLE vandelay.queued_record (
     id                 BIGSERIAL                   PRIMARY KEY,
     create_time        TIMESTAMP WITH TIME ZONE    NOT NULL DEFAULT NOW(),
     import_time        TIMESTAMP WITH TIME ZONE,
-       purpose         TEXT                                            NOT NULL DEFAULT 'import' CHECK (queue_purpose IN ('import','overlay')),
+       purpose         TEXT                                            NOT NULL DEFAULT 'import' CHECK (purpose IN ('import','overlay')),
     marc               TEXT                        NOT NULL
 );