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

[..hidden..]

Revision: 4922
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4922&view=rev
Author:   einhverfr
Date:     2012-06-19 13:15:49 +0000 (Tue, 19 Jun 2012)
Log Message:
-----------
Making pricegroups nestable in db

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2012-06-19 09:54:09 UTC (rev 4921)
+++ trunk/sql/Pg-database.sql	2012-06-19 13:15:49 UTC (rev 4922)
@@ -2031,8 +2031,9 @@
 $$ Job costing/manufacturing here not implemented.$$;
 --
 CREATE TABLE partsgroup (
-  id serial PRIMARY KEY,
-  partsgroup text
+  id serial primary key,
+  partsgroup text,
+  parent int references partsgroup(id)
 );
 
 COMMENT ON TABLE partsgroup is $$ Groups of parts for Point of Sale screen.$$;

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