diff options
| author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-07 04:18:40 +0000 |
|---|---|---|
| committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-07 04:18:40 +0000 |
| commit | d754d03721aada2751ae0b5e3def08f979c1318a (patch) | |
| tree | 8a535d9cc4aad5207096d423b8a05c6ce38cac54 /sql | |
| parent | 300d8cd96f107bb962cf807005784c96197baa1f (diff) | |
fix uniqueness on entity names
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1260 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 51589212..6bf5d0e9 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -23,7 +23,7 @@ CREATE TABLE entity_class ( COMMENT ON TABLE entity_class IS $$ Defines the class type such as vendor, customer, contact, employee $$; COMMENT ON COLUMN entity_class.id IS $$ The first 7 values are reserved and permanent $$; -CREATE UNIQUE index entity_class_unique_idx ON entity_class(lower(class)); +CREATE index entity_class_idx ON entity_class(lower(class)); COMMENT ON INDEX entity_class_unique_idx IS $$ Helps truly define unique. Which we could do that with Primary Keys $$; @@ -210,6 +210,7 @@ CREATE INDEX invoice_note_id_idx ON invoice_note(id); CREATE UNIQUE INDEX invoice_note_class_idx ON note_class(lower(class)); CREATE INDEX invoice_note_vectors_idx ON invoice_note USING gist(vector); ALTER TABLE invoice_note ADD CHECK (id = 2); + -- END entity -- |