Open-ILS/src/sql/Pg/upgrade/0166.schema.acq_edi_message.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0166');
   4
   5 CREATE TABLE acq.edi_message (
   6     id               SERIAL          PRIMARY KEY,
   7     account          INTEGER         REFERENCES acq.edi_account(id)
   8                                      DEFERRABLE INITIALLY DEFERRED,
   9     remote_file      TEXT,
  10     create_time      TIMESTAMPTZ     NOT NULL DEFAULT now(),
  11     translate_time   TIMESTAMPTZ,
  12     process_time     TIMESTAMPTZ,
  13     error_time       TIMESTAMPTZ,
  14     status           TEXT            NOT NULL DEFAULT 'new'
  15                                      CONSTRAINT status_value CHECK
  16                                      ( status IN (
  17                                         'new',          -- needs to be translated
  18                                         'translated',   -- needs to be processed
  19                                         'trans_error',  -- error in translation step
  20                                         'processed',    -- needs to have remote_file deleted
  21                                         'proc_error',   -- error in processing step
  22                                         'delete_error', -- error in deletion
  23                                         'complete'      -- done
  24                                      )),
  25     edi              TEXT,
  26     jedi             TEXT,
  27     error            TEXT
  28 );
  29
  30 ALTER TABLE actor.org_address ADD COLUMN san TEXT;
  31
  32 COMMIT;