From 0cf9f3628d34dcc511f19a30f9c5edb75b5a106d Mon Sep 17 00:00:00 2001 From: erickson Date: Wed, 28 Sep 2005 14:38:10 +0000 Subject: [PATCH] removing stage1 from the db git-svn-id: svn://svn.open-ils.org/ILS/trunk@1878 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/reporter/config.sql | 22 +++------------------- 1 file changed, 3 insertions(+), 19 deletions(-) diff --git a/Open-ILS/src/reporter/config.sql b/Open-ILS/src/reporter/config.sql index 4c08b26ece..788c92082b 100644 --- a/Open-ILS/src/reporter/config.sql +++ b/Open-ILS/src/reporter/config.sql @@ -4,26 +4,10 @@ CREATE SCHEMA reporter; BEGIN; -CREATE TABLE reporter.stage1 ( - id serial primary key, - filename text not null, - owner int not null, - pub bool not null - default true, - create_date timestamp with time zone not null - default now(), - edit_date timestamp with time zone not null - default now() -); - CREATE TABLE reporter.stage2 ( id serial primary key, - stage1 int not null - references reporter.stage1 (id) - on delete restrict - deferrable - initially deferred, - filename text not null, + stage1 text not null, + params text not null, owner int not null, pub bool not null default false, @@ -52,7 +36,7 @@ CREATE TABLE reporter.stage3 ( on delete restrict deferrable initially deferred, - filename text not null, + params text not null, owner int not null, pub bool not null default false, -- 2.43.2