diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-25 18:27:28 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-05-25 18:27:28 +0000 |
| commit | dd779e7ff888ad90d0cefff239b5e77fc80d991e (patch) | |
| tree | 4cea8b5691ba1bccbdbe092f1cec15527b42cefa /sql | |
| parent | 6bff0e985bd6e56bf31184df4d5ca460d5545f34 (diff) | |
Fixes to per-transaction separation of duties
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2155 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index fc8e79a1..c9f2bea3 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -139,7 +139,7 @@ CREATE TABLE location ( line_two text, line_three text, city text check (city ~ '[[:alnum:]_]') NOT NULL, - state text check(state ~ '[[:alnum:]_]') NOT NULL, + state text check(state ~ '[[:alnum:]_]'), country_id integer not null REFERENCES country(id), mail_code text not null check (mail_code ~ '[[:alnum:]_]'), created date not null, |