From 063d52183edfcd6d2a766bd6c9de0642d1731c13 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Mon, 12 May 2008 19:13:22 +0000
Subject: Merging in fix for 1870069

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2137 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'sql')

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index b93f47f4..26f5f29e 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -77,7 +77,9 @@ session_id int REFERENCES session(session_id) ON DELETE CASCADE
 CREATE TABLE transactions (
   id int PRIMARY KEY,
   table_name text,
-  locked_by int references "session" (session_id) ON DELETE SET NULL
+  locked_by int references "session" (session_id) ON DELETE SET NULL,
+  approved_by int references "users" (entity_id),
+  approved_at timestamp
 );
 
 COMMENT on TABLE transactions IS 
@@ -357,12 +359,14 @@ glnumber|1
 projectnumber|1
 queue_payments|0
 poll_frequency|1
+separate_duties|1
 \.
 
 COMMENT ON TABLE defaults IS $$
 Note that poll_frequency is in seconds.  poll_frequency and queue_payments 
 are not exposed via the admin interface as they are advanced features best
-handled via DBAs.  $$;
+handled via DBAs.  Also, separate_duties is not yet included in the admin 
+interface.$$;
 -- */
 -- batch stuff
 
-- 
cgit v1.2.3