diff options
Diffstat (limited to 'sql/Pg-database.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 e81ee254..3373b01b 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -156,7 +156,7 @@ CREATE TABLE location ( 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, + created date not null default now(), inactive_date timestamp default null, active boolean not null default TRUE ); |