removing stage1 from the db

git-svn-id: svn://svn.open-ils.org/ILS/trunk@1878 dcc99617-32d9-48b4-a31d-7c20da2025e4

diff --git a/Open-ILS/src/reporter/config.sql b/Open-ILS/src/reporter/config.sql
index 4c08b26ecea1cad8897f20171d674bc116b1b1fa..788c92082baa7de8444b32063a056e6cb90f363f 100644 (file)
--- a/Open-ILS/src/reporter/config.sql
+++ b/Open-ILS/src/reporter/config.sql
@@ -4,26 +4,10 @@ CREATE SCHEMA reporter;
 
 BEGIN;
 
 
 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,
 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,
        owner           int                             not null,
        pub             bool                            not null
                                                        default false,


@@ -52,7 +36,7 @@ CREATE TABLE reporter.stage3 (
                                                                on delete restrict
                                                                deferrable
                                                                initially deferred,
                                                                on delete restrict
                                                                deferrable
                                                                initially deferred,

-       filename        text                            not null,
+       params          text                            not null,

        owner           int                             not null,
        pub             bool                            not null
                                                        default false,
        owner           int                             not null,
        pub             bool                            not null
                                                        default false,