From 17e3d3a0db7d6c3ecee7266440e72016fce7e44e Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Wed, 21 Sep 2005 21:21:48 +0000
Subject: [PATCH] adding stage1 table

git-svn-id: svn://svn.open-ils.org/ILS/trunk@1851 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/reporter/config.sql | 21 +++++++++++++++++++--
 1 file changed, 19 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/src/reporter/config.sql b/Open-ILS/src/reporter/config.sql
index 52116928bf..4c08b26ece 100644
--- a/Open-ILS/src/reporter/config.sql
+++ b/Open-ILS/src/reporter/config.sql
@@ -1,11 +1,28 @@
-DROP SCEMA reporter CASCADE;
+DROP SCHEMA reporter CASCADE;
+
 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		text				not null,
+	stage1		int				not null 
+							references reporter.stage1 (id)
+								on delete restrict
+								deferrable
+								initially deferred,
 	filename	text				not null,
 	owner		int				not null,
 	pub		bool				not null
-- 
2.43.2