removing stage1 from the db
authorerickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 28 Sep 2005 14:38:10 +0000 (14:38 +0000)
committererickson <erickson@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 28 Sep 2005 14:38:10 +0000 (14:38 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@1878 dcc99617-32d9-48b4-a31d-7c20da2025e4

Open-ILS/src/reporter/config.sql

index 4c08b26..788c920 100644 (file)
@@ -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,