diff options
author | aurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-10 21:27:44 +0000 |
---|---|---|
committer | aurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-07-10 21:27:44 +0000 |
commit | 2a16f8ab8169da7d32c0d192756b6aff441a4644 (patch) | |
tree | a698dad1a197879b73f96b2a363e75085b888c74 /sql | |
parent | 601652599b9a439c3bf3c4b2b25534ca88f9ca59 (diff) |
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
Diffstat (limited to 'sql')
-rw-r--r-- | sql/Pg-database.sql | 6 |
1 files changed, 3 insertions, 3 deletions
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; |