From 7d9c476406d719b901613e11248030f6b2c2eec9 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 1 Apr 2009 11:08:08 +0000 Subject: [PATCH] reordering table due to fkey git-svn-id: svn://svn.open-ils.org/ILS/trunk@12747 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/400.schema.action_trigger.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql b/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql index 940928516b..75f735962a 100644 --- a/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql +++ b/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql @@ -120,6 +120,12 @@ CREATE TABLE action_trigger.environment ( CONSTRAINT env_event_label_once UNIQUE (event_def,label) ); +CREATE TABLE action_trigger.event_output ( + id BIGSERIAL PRIMARY KEY, + create_time TIMESTAMPTZ NOT NULL DEFAULT NOW(), + data TEXT NOT NULL +); + CREATE TABLE action_trigger.event ( id BIGSERIAL PRIMARY KEY, target BIGINT NOT NULL, -- points at the id from class defined by event_def.hook.core_type @@ -135,12 +141,6 @@ CREATE TABLE action_trigger.event ( error_output TEXT ); -CREATE TABLE action_trigger.event_output ( - id BIGSERIAL PRIMARY KEY, - create_time TIMESTAMPTZ NOT NULL DEFAULT NOW(), - data TEXT NOT NULL -); - CREATE TABLE action_trigger.event_params ( id BIGSERIAL PRIMARY KEY, event_def INT NOT NULL REFERENCES action_trigger.event_definition (id) DEFERRABLE INITIALLY DEFERRED, -- 2.11.0