Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 1230 → Rev 1231

/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;
}