From 2a16f8ab8169da7d32c0d192756b6aff441a4644 Mon Sep 17 00:00:00 2001 From: aurynn_cmd Date: Tue, 10 Jul 2007 21:27:44 +0000 Subject: Changes to the comments on entity_metadata, which does not exist, to refer to entity_credit account. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1374 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index a5cb9e31..131ad2b6 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -409,10 +409,10 @@ CREATE VIEW vendor AS 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; -- cgit v1.2.3