Rev 558 | Rev 1050 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 558 | Rev 830 | ||
|---|---|---|---|
| Line 18... | Line 18... | ||
| 18 | */ |
18 | */ |
| 19 | 19 | ||
| 20 | /** |
20 | /** |
| 21 | * This function will be called by OIDplusDatabaseConnection.class.php at method afterConnect(). |
21 | * This function will be called by OIDplusDatabaseConnection.class.php at method afterConnect(). |
| 22 | * @param OIDplusDatabaseConnection $db is the OIDplusDatabaseConnection class |
22 | * @param OIDplusDatabaseConnection $db is the OIDplusDatabaseConnection class |
| 23 | * @param string $version is the current version (this script MUST increase the number by 1 when it is done) |
23 | * @return int new version set |
| 24 | * @throws OIDplusException |
24 | * @throws OIDplusException |
| 25 | */ |
25 | */ |
| 26 | function oidplus_dbupdate_202_203(OIDplusDatabaseConnection $db, string &$version) { |
26 | function oidplus_dbupdate_202(OIDplusDatabaseConnection $db) { |
| 27 | if ($db->transaction_supported()) $db->transaction_begin(); |
27 | if ($db->transaction_supported()) $db->transaction_begin(); |
| 28 | 28 | ||
| 29 | if ($db->getSlang()->id() == 'mssql') { |
29 | if ($db->getSlang()->id() == 'mssql') { |
| 30 | $db->query("CREATE FUNCTION [dbo].[getOidArc] (@strList varchar(512), @maxArcLen int, @occurence int) |
30 | $db->query("CREATE FUNCTION [dbo].[getOidArc] (@strList varchar(512), @maxArcLen int, @occurence int) |
| 31 | RETURNS varchar(512) AS |
31 | RETURNS varchar(512) AS |
| Line 68... | Line 68... | ||
| 68 | 68 | ||
| 69 | $version = 203; |
69 | $version = 203; |
| 70 | $db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array($version)); |
70 | $db->query("UPDATE ###config SET value = ? WHERE name = 'database_version'", array($version)); |
| 71 | 71 | ||
| 72 | if ($db->transaction_supported()) $db->transaction_commit(); |
72 | if ($db->transaction_supported()) $db->transaction_commit(); |
| - | 73 | ||
| - | 74 | return $version; |
|
| 73 | } |
75 | } |
| 74 | 76 | ||