[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [1374] trunk/sql/Pg-database.sql
- Subject: SF.net SVN: ledger-smb: [1374] trunk/sql/Pg-database.sql
- From: ..hidden..
- Date: Tue, 10 Jul 2007 14:27:44 -0700
Revision: 1374
http://svn.sourceforge.net/ledger-smb/?rev=1374&view=rev
Author: aurynn_cmd
Date: 2007-07-10 14:27:44 -0700 (Tue, 10 Jul 2007)
Log Message:
-----------
Changes to the comments on entity_metadata, which does not exist, to refer to entity_credit account.
Modified Paths:
--------------
trunk/sql/Pg-database.sql
Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql 2007-07-10 21:16:16 UTC (rev 1373)
+++ trunk/sql/Pg-database.sql 2007-07-10 21:27:44 UTC (rev 1374)
@@ -409,10 +409,10 @@
join entity_invoice_notes ein on ein.entity_id = emd.entity_id
where emd.entity_class = 1;
-COMMENT ON TABLE entity_metadata IS $$ This is a metadata table for ALL entities in LSMB; it deprecates the use of customer and vendor specific tables (which were nearly identical and largely redundant), and replaces it with a single point of metadata. $$;
+COMMENT ON TABLE entity_credit_account IS $$ This is a metadata table for ALL entities in LSMB; it deprecates the use of customer and vendor specific tables (which were nearly identical and largely redundant), and replaces it with a single point of metadata. $$;
-COMMENT ON COLUMN entity_metadata.entity_id IS $$ This is the relationship between entities and their metadata. $$;
-COMMENT ON COLUMN entity_metadata.entity_class IS $$ A reference to entity_class, requiring that entity_metadata only apply to vendors and customers, using the entity_class table as the Point Of Truth. $$;
+COMMENT ON COLUMN entity_credit_account.entity_id IS $$ This is the relationship between entities and their metadata. $$;
+COMMENT ON COLUMN entity_credit_account.entity_class IS $$ A reference to entity_class, requiring that entity_credit_account only apply to vendors and customers, using the entity_class table as the Point Of Truth. $$;
ALTER TABLE company ADD COLUMN sic_code varchar;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.