3 INSERT INTO config.upgrade_log (version) VALUES ('0166');
5 CREATE TABLE acq.edi_message (
7 account INTEGER REFERENCES acq.edi_account(id)
8 DEFERRABLE INITIALLY DEFERRED,
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
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
30 ALTER TABLE actor.org_address ADD COLUMN san TEXT;