diff options
| author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-21 21:16:03 +0000 |
|---|---|---|
| committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-06-21 21:16:03 +0000 |
| commit | be42a637e05b5679d0ddb2350ec031139d19b3bc (patch) | |
| tree | 687feaeb1972f8242747deede759647b56ae8886 /sql/Pg-database.sql | |
| parent | a3363055beabd86c43c7e205f31ccf596ef441df (diff) | |
minor date style change
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1296 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/Pg-database.sql')
| -rw-r--r-- | sql/Pg-database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index bd710576..0a54c86f 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -79,8 +79,8 @@ CREATE TABLE location ( country_id integer not null REFERENCES country(id), mail_code text not null check (mail_code ~ '[[:alnum:]_]'), created date not null, - active boolean not null default TRUE, - inactive_date date default null, + inactive_date timestamp default null, + active boolean not null default TRUE ); CREATE INDEX location_unique_class_idx ON location (id,location_class); |