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

[..hidden..]

Revision: 1468
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1468&view=rev
Author:   einhverfr
Date:     2007-08-26 22:04:14 -0700 (Sun, 26 Aug 2007)

Log Message:
-----------
Applying patch 1780397

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-08-27 05:01:26 UTC (rev 1467)
+++ trunk/sql/Pg-database.sql	2007-08-27 05:04:14 UTC (rev 1468)
@@ -94,7 +94,7 @@
 $$
 declare
    locked int;
-begin;
+begin
    SELECT locked_by into locked from transactions where id = $1;
    IF NOT FOUND THEN
 	RETURN FALSE;
@@ -430,6 +430,12 @@
 
 --
 
+-- pricegroup added here due to references
+CREATE TABLE pricegroup (
+  id serial PRIMARY KEY,
+  pricegroup text
+);
+
 CREATE TABLE entity_credit_account (
   id serial not null unique,
   entity_id int not null references entity(id) ON DELETE CASCADE,
@@ -897,11 +903,6 @@
   entry_id SERIAL PRIMARY KEY
 );
 --
-CREATE TABLE pricegroup (
-  id serial PRIMARY KEY,
-  pricegroup text
-);
---
 CREATE TABLE partscustomer (
   parts_id int,
   customer_id int not null references entity_credit_account(id) on delete cascade,


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