From 25b8b70de5e956820baba47887c6534436baa26e Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Fri, 27 Jan 2006 16:18:31 +0000
Subject: [PATCH] bucket cleanup

git-svn-id: svn://svn.open-ils.org/ILS/trunk@2856 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/005.schema.actors.sql    | 28 ++++++++++++++++++++
 Open-ILS/src/sql/Pg/070.schema.container.sql | 28 +++++++++++++-------
 2 files changed, 46 insertions(+), 10 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql
index 6eccb97b23..732e60ef8b 100644
--- a/Open-ILS/src/sql/Pg/005.schema.actors.sql
+++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql
@@ -133,6 +133,34 @@ INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family
 	VALUES ( 1, 1,'admin', 'open-ils', 'Administrator', 'System Account', '1979-01-22', TRUE, TRUE, 1, 'identification', 1 );
 
 
+CREATE TABLE actor.usr_standing_penalty (
+	id		SERIAL	PRIMARY KEY,
+	usr		INT	NOT NULL REFERENCES actor.usr ON DELETE CASCADE,
+	penalty_type	TEXT	NOT NULL
+);
+COMMENT ON TABLE actor.usr_standing_penalty IS $$
+/*
+ * Copyright (C) 2005  Georgia Public Library Service 
+ * Mike Rylander <mrylander@gmail.com>
+ *
+ * User standing penalties
+ *
+ * ****
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ */
+$$;
+
+CREATE INDEX actor_usr_standing_penalty_usr_idx ON actor.usr_standing_penalty (usr);
+
 CREATE TABLE actor.usr_setting (
 	id	BIGSERIAL	PRIMARY KEY,
 	usr	INT		NOT NULL REFERENCES actor.usr ON DELETE CASCADE,
diff --git a/Open-ILS/src/sql/Pg/070.schema.container.sql b/Open-ILS/src/sql/Pg/070.schema.container.sql
index 3df61e1112..ca011cad85 100644
--- a/Open-ILS/src/sql/Pg/070.schema.container.sql
+++ b/Open-ILS/src/sql/Pg/070.schema.container.sql
@@ -4,16 +4,17 @@ BEGIN;
 CREATE SCHEMA container;
 
 CREATE TABLE container.copy_bucket (
-	id	SERIAL	PRIMARY KEY,
-	owner	INT	NOT NULL
-			REFERENCES actor.usr (id)
-				ON DELETE CASCADE
-				ON UPDATE CASCADE
-				DEFERRABLE
-				INITIALLY DEFERRED,
-	name	TEXT	NOT NULL,
-	btype	TEXT	NOT NULL DEFAULT 'misc',
-	public	BOOL	NOT NULL DEFAULT FALSE,
+	id		SERIAL				PRIMARY KEY,
+	owner		INT				NOT NULL
+							REFERENCES actor.usr (id)
+								ON DELETE CASCADE
+								ON UPDATE CASCADE
+								DEFERRABLE
+								INITIALLY DEFERRED,
+	name		TEXT				NOT NULL,
+	btype		TEXT				NOT NULL DEFAULT 'misc',
+	public		BOOL				NOT NULL DEFAULT FALSE,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT cb_name_once_per_owner UNIQUE (owner,name,btype)
 );
 
@@ -31,6 +32,7 @@ CREATE TABLE container.copy_bucket_item (
 					ON UPDATE CASCADE
 					DEFERRABLE
 					INITIALLY DEFERRED,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT cb_cb_item_once_per_bucket UNIQUE (bucket,target_copy)
 );
 
@@ -48,6 +50,7 @@ CREATE TABLE container.call_number_bucket (
 	name	TEXT	NOT NULL,
 	btype	TEXT	NOT NULL DEFAULT 'misc',
 	public	BOOL	NOT NULL DEFAULT FALSE,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT cnb_name_once_per_owner UNIQUE (owner,name,btype)
 );
 
@@ -65,6 +68,7 @@ CREATE TABLE container.call_number_bucket_item (
 					ON UPDATE CASCADE
 					DEFERRABLE
 					INITIALLY DEFERRED,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT cnb_item_once_per_bucket UNIQUE (bucket,target_call_number)
 );
 
@@ -82,6 +86,7 @@ CREATE TABLE container.biblio_record_entry_bucket (
 	name	TEXT	NOT NULL,
 	btype	TEXT	NOT NULL DEFAULT 'misc',
 	public	BOOL	NOT NULL DEFAULT FALSE,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT breb_name_once_per_owner UNIQUE (owner,name,btype)
 );
 
@@ -99,6 +104,7 @@ CREATE TABLE container.biblio_record_entry_bucket_item (
 							ON UPDATE CASCADE
 							DEFERRABLE
 							INITIALLY DEFERRED,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT breb_item_once_per_bucket UNIQUE (bucket,target_biblio_record_entry)
 );
 
@@ -116,6 +122,7 @@ CREATE TABLE container.user_bucket (
 	name	TEXT	NOT NULL,
 	btype	TEXT	NOT NULL DEFAULT 'misc',
 	public	BOOL	NOT NULL DEFAULT FALSE,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT ub_name_once_per_owner UNIQUE (owner,name,btype)
 );
 
@@ -133,6 +140,7 @@ CREATE TABLE container.user_bucket_item (
 					ON UPDATE CASCADE
 					DEFERRABLE
 					INITIALLY DEFERRED,
+	create_time	TIMESTAMP WITH TIME ZONE	NOT NULL DEFAULT NOW(),
 	CONSTRAINT ub_item_once_per_bucket UNIQUE (bucket,target_user)
 );
 
-- 
2.43.2