Rev 1219 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
Rev 1219 | Rev 1231 | ||
---|---|---|---|
Line 25... | Line 25... | ||
25 | * @return int new version set |
25 | * @return int new version set |
26 | * @throws \ViaThinkSoft\OIDplus\OIDplusException |
26 | * @throws \ViaThinkSoft\OIDplus\OIDplusException |
27 | */ |
27 | */ |
28 | function oidplus_dbupdate_204(OIDplusDatabaseConnection $db): int { |
28 | function oidplus_dbupdate_204(OIDplusDatabaseConnection $db): int { |
29 | if ($db->transaction_supported()) $db->transaction_begin(); |
29 | if ($db->transaction_supported()) $db->transaction_begin(); |
30 | 30 | try { |
|
31 | if ($db->getSlang()->id() == 'mssql') { |
31 | if ($db->getSlang()->id() == 'mssql') { |
32 | $db->query("alter table ###ra alter column [ra_name] [varchar](100) NULL;"); |
32 | $db->query("alter table ###ra alter column [ra_name] [varchar](100) NULL;"); |
33 | $db->query("alter table ###ra alter column [personal_name] [varchar](100) NULL;"); |
33 | $db->query("alter table ###ra alter column [personal_name] [varchar](100) NULL;"); |
34 | $db->query("alter table ###ra alter column [organization] [varchar](100) NULL;"); |
34 | $db->query("alter table ###ra alter column [organization] [varchar](100) NULL;"); |
35 | $db->query("alter table ###ra alter column [office] [varchar](100) NULL;"); |
35 | $db->query("alter table ###ra alter column [office] [varchar](100) NULL;"); |
Line 123... | Line 123... | ||
123 | 123 | ||
124 | $version = 205; |
124 | $version = 205; |
125 | $db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
125 | $db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array("$version")); |
126 | 126 | ||
127 | if ($db->transaction_supported()) $db->transaction_commit(); |
127 | if ($db->transaction_supported()) $db->transaction_commit(); |
- | 128 | } catch (\Exception $e) { |
|
- | 129 | if ($db->transaction_supported()) $db->transaction_rollback(); |
|
- | 130 | throw new $e; |
|
- | 131 | } |
|
128 | 132 | ||
129 | return $version; |
133 | return $version; |
130 | } |
134 | } |