SF.net SVN: ledger-smb:[2657] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 2657
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2657&view=rev
Author:   einhverfr
Date:     2009-06-12 16:42:23 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
Fixing broken Pg-database.sql

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2009-06-12 16:14:23 UTC (rev 2656)
+++ trunk/sql/Pg-database.sql	2009-06-12 16:42:23 UTC (rev 2657)
@@ -137,32 +137,6 @@
 declare
    locked int;
 begin
-
-CREATE TABLE open_forms (
-id SERIAL PRIMARY KEY,
-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,
-  approved_by int references entity (id),
-  approved_at timestamp
-);
-
-COMMENT on TABLE transactions IS 
-$$ This table tracks basic transactions across AR, AP, and GL related tables.  
-It provies a referential integrity enforcement mechanism for the financial data
-and also some common features such as discretionary (and pessimistic) locking 
-for long batch workflows. $$;
-
-CREATE OR REPLACE FUNCTION lock_record (int, int) returns bool as 
-$$
-declare
-   locked int;
-begin
    SELECT locked_by into locked from transactions where id = $1;
    IF NOT FOUND THEN
 	RETURN FALSE;
@@ -1242,12 +1216,6 @@
 --
 create index assembly_id_key on assembly (id);
 --
-create index chart_id_key on chart (id);
-create unique index chart_accno_key on chart (accno);
-create index chart_category_key on chart (category);
-create index chart_link_key on chart (link);
-create index chart_gifi_accno_key on chart (gifi_accno);
---
 create index customer_customer_id_key on customertax (customer_id);
 --
 create index exchangerate_ct_key on exchangerate (curr, transdate);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.