diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-06 09:13:56 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-06 09:13:56 +0100 |
| commit | aed33e90f6628b281cd1c8ae09f9bed38960a333 (patch) | |
| tree | 40bf3196945406df0fda348a7106acde704a2539 | |
| parent | f69262a6dc9a21e137b697df8ef353626bd0555d (diff) | |
| download | liberty-aed33e90f6628b281cd1c8ae09f9bed38960a333.tar.gz liberty-aed33e90f6628b281cd1c8ae09f9bed38960a333.tar.bz2 liberty-aed33e90f6628b281cd1c8ae09f9bed38960a333.zip | |
liberty_xref.xorder: add DEFAULT 0 NOTNULL constraint
Prevents NULL xorder from import paths that omit the column, which
causes the CASE expression building xref_title to return NULL.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
| -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 19d1182..fd0968e 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -245,7 +245,7 @@ $tables = [ xref_id I8 PRIMARY, content_id I8 NOTNULL, item C(20), - xorder I2, + xorder I2 DEFAULT 0 NOTNULL, xref I8, xkey C(32), xkey_ext C(250), |