diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-05-18 09:37:30 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-05-18 09:37:30 +0100 |
| commit | f3233190e72af1a64f4a345c96611925872bfe26 (patch) | |
| tree | 876bcbb037dde6e26b2dfda8edd7166e0555edb8 | |
| parent | bc9b9df93192b0c3bc62bf701864b97681c38977 (diff) | |
| download | contact-f3233190e72af1a64f4a345c96611925872bfe26.tar.gz contact-f3233190e72af1a64f4a345c96611925872bfe26.tar.bz2 contact-f3233190e72af1a64f4a345c96611925872bfe26.zip | |
Tidy mistakes in schema, but contact_xref_seq needs checking after a new install
| -rwxr-xr-x | admin/schema_inc.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index d305cbb..38223d3 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -13,7 +13,7 @@ $tables = [ xref_id I8 PRIMARY, content_id I8 NOTNULL, source C(20) PRIMARY, - xorder I2 + xorder I2, xref I8, xkey C(32), xkey_ext C(250), @@ -85,7 +85,7 @@ $gBitInstaller->registerSchemaIndexes( CONTACT_PKG_NAME, $indices ); // ### Sequences $sequences = [ - 'contact_xref_seq' => [ 'start' => 1 ], +// 'contact_xref_seq' => [ 'start' => 1 ], ]; $gBitInstaller->registerSchemaSequences( CONTACT_PKG_NAME, $sequences ); @@ -131,7 +131,6 @@ $gBitInstaller->registerSchemaDefault( CONTACT_PKG_NAME, [ "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#C', 'Contact Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)", "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#E', 'eMail Address', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)", "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#F', 'Fax', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)", - "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#E', 'eMail Address', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)", "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#I', 'Invoice Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)", "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#P', 'Telephone', '1', '1', '3', '../contact/?contact_id=', 'phone', NULL)", "INSERT INTO `" . BIT_DB_PREFIX . "contact_xref_source` VALUES ('#R', 'Residential Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)", |