# - #4 : the developer version. The 4th number is the database subversion.
# used by developers when the database changes. updatedatabase take care of the changes itself
# and is automatically called by Auth.pm when needed.
-$VERSION = "18.12.00.038";
+$VERSION = "18.12.00.039";
sub version {
return $VERSION;
+++ /dev/null
-$DBversion = 'XXX'; # will be replaced by the RM
-if ( CheckVersion($DBversion) ) {
-
- if ( !column_exists( 'accountlines', 'interface' ) ) {
- $dbh->do(
- qq{
- ALTER TABLE `accountlines`
- ADD
- `interface` varchar(16)
- AFTER
- `manager_id`;
- }
- );
- }
-
- $dbh->do(qq{
- UPDATE
- `accountlines`
- SET
- interface = 'opac'
- WHERE
- borrowernumber = manager_id;
- });
-
- $dbh->do(qq{
- UPDATE
- `accountlines`
- SET
- interface = 'cron'
- WHERE
- manager_id IS NULL
- AND
- branchcode IS NULL;
- });
-
- $dbh->do(qq{
- UPDATE
- `accountlines`
- SET
- interface = 'intranet'
- WHERE
- interface IS NULL;
- });
-
- $dbh->do(qq{
- ALTER TABLE `accountlines`
- MODIFY COLUMN `interface` varchar(16) NOT NULL;
- });
-
- SetVersion($DBversion);
- print "Upgrade to $DBversion done (Bug 22600 - Add interface to accountlines)\n";
-}
print "Upgrade to $DBversion done (Bug 22512 - Add status to accountlines)\n";
}
+$DBversion = '18.12.00.039';
+if ( CheckVersion($DBversion) ) {
+
+ if ( !column_exists( 'accountlines', 'interface' ) ) {
+ $dbh->do(
+ qq{
+ ALTER TABLE `accountlines`
+ ADD
+ `interface` varchar(16)
+ AFTER
+ `manager_id`;
+ }
+ );
+ }
+
+ $dbh->do(qq{
+ UPDATE
+ `accountlines`
+ SET
+ interface = 'opac'
+ WHERE
+ borrowernumber = manager_id;
+ });
+
+ $dbh->do(qq{
+ UPDATE
+ `accountlines`
+ SET
+ interface = 'cron'
+ WHERE
+ manager_id IS NULL
+ AND
+ branchcode IS NULL;
+ });
+
+ $dbh->do(qq{
+ UPDATE
+ `accountlines`
+ SET
+ interface = 'intranet'
+ WHERE
+ interface IS NULL;
+ });
+
+ $dbh->do(qq{
+ ALTER TABLE `accountlines`
+ MODIFY COLUMN `interface` varchar(16) NOT NULL;
+ });
+
+ SetVersion($DBversion);
+ print "Upgrade to $DBversion done (Bug 22600 - Add interface to accountlines)\n";
+}
+
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.