diff options
| -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 22e87fca..b9205b37 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -63,7 +63,8 @@ CREATE TABLE location ( line_two text, line_three text, city_province text check (city_province ~ '[[:alnum:]_]') NOT NULL, - country_id integer not null REFERENCES country(id)); + country_id integer not null REFERENCES country(id) + mail_code text not null check (mail_code ~ '[[:alnum:]_]')); CREATE TABLE company ( id serial UNIQUE, |