/trunk/includes/db_updates/update1001.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_1001(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
// Change collation so that objects like FourCC can be case-sensitive |
if ($db->getSlang()->id() == 'mysql') { |
$db->query("ALTER TABLE ###asn1id CHANGE `oid` `oid` varchar(255) NOT NULL COLLATE utf8_bin;"); |
64,6 → 64,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update1002.inc.php |
---|
89,7 → 89,7 |
*/ |
function oidplus_dbupdate_1002(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
if ($db->getSlang()->id() == 'mssql') { |
$db->query("alter table ###ra alter column [authkey] [varchar](250) NULL;"); |
oidplus_dbupdate_1002_migrate_ra_passwords($db); |
145,6 → 145,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update200.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_200(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
$db->query("ALTER TABLE ###objects ADD comment varchar(255) NULL"); |
$version = 201; |
34,6 → 34,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update201.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_201(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
// Change bit(1) types to boolean/tinyint(1) |
if ($db->getSlang()->id() == 'pgsql') { |
$db->query("alter table ###config alter protected drop default"); |
81,6 → 81,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update202.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_202(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
if ($db->getSlang()->id() == 'mssql') { |
// (Function "getOidArc" has been removed 6 April 2023) |
} |
36,6 → 36,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update203.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_203(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
if ($db->getSlang()->id() == 'mssql') { |
$db->query("ALTER TABLE ###log_object ADD severity [int]"); |
$db->query("ALTER TABLE ###log_user ADD severity [int]"); |
49,6 → 49,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |
/trunk/includes/db_updates/update204.inc.php |
---|
27,7 → 27,7 |
*/ |
function oidplus_dbupdate_204(OIDplusDatabaseConnection $db): int { |
if ($db->transaction_supported()) $db->transaction_begin(); |
try { |
if ($db->getSlang()->id() == 'mssql') { |
$db->query("alter table ###ra alter column [ra_name] [varchar](100) NULL;"); |
$db->query("alter table ###ra alter column [personal_name] [varchar](100) NULL;"); |
125,6 → 125,10 |
$db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
if ($db->transaction_supported()) $db->transaction_commit(); |
} catch (\Exception $e) { |
if ($db->transaction_supported()) $db->transaction_rollback(); |
throw new $e; |
} |
return $version; |
} |