diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-02 12:40:56 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-02 12:40:56 +0100 |
| commit | a22f284399206b1faf3e75ba8b9aa1dd343fd476 (patch) | |
| tree | 2f56e0b6d35bcb7044b1ebd2c72f7d49c521861d /admin | |
| parent | a6d77d28625efe86fe16228cbfdce49d6a5bf6e2 (diff) | |
| download | contact-a22f284399206b1faf3e75ba8b9aa1dd343fd476.tar.gz contact-a22f284399206b1faf3e75ba8b9aa1dd343fd476.tar.bz2 contact-a22f284399206b1faf3e75ba8b9aa1dd343fd476.zip | |
Use DEFTIMESTAMP for contact_address.last_update_date
DEFTIMESTAMP uses sysTimeStamp (now LOCALTIMESTAMP for Firebird 4+) rather
than DEFAULT LOCALTIMESTAMP which adodb-datadict was mangling into a literal
time value via DBTimeStamp(), causing Firebird SQLSTATE 22009 on INSERT.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Diffstat (limited to 'admin')
| -rwxr-xr-x | admin/schema_inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 7cc477b..ab46075 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -24,7 +24,7 @@ $tables = [ zone_id I4, country C(80), country_id I4, - last_update_date T DEFAULT LOCALTIMESTAMP, + last_update_date T DEFTIMESTAMP, cltype I2 ", |