summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
diff options
context:
space:
mode:
authoraurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46>2007-07-10 21:27:44 +0000
committeraurynn_cmd <aurynn_cmd@4979c152-3d1c-0410-bac9-87ea11338e46>2007-07-10 21:27:44 +0000
commit2a16f8ab8169da7d32c0d192756b6aff441a4644 (patch)
treea698dad1a197879b73f96b2a363e75085b888c74 /sql/Pg-database.sql
parent601652599b9a439c3bf3c4b2b25534ca88f9ca59 (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/Pg-database.sql')
-rw-r--r--sql/Pg-database.sql6
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;