diff options
| -rw-r--r-- | sql/Pg-database.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index cab04b00..bd710576 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -77,8 +77,11 @@ CREATE TABLE location ( line_three text, city_province text check (city_province ~ '[[:alnum:]_]') NOT NULL, country_id integer not null REFERENCES country(id), - mail_code text not null check (mail_code ~ '[[:alnum:]_]')); - + mail_code text not null check (mail_code ~ '[[:alnum:]_]'), + created date not null, + active boolean not null default TRUE, + inactive_date date default null, + ); CREATE INDEX location_unique_class_idx ON location (id,location_class); CREATE TABLE company ( |