View | Details | Raw Unified | Return to bug 6427
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-44 / +90 lines)
Lines 265-270 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
265
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
265
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
268
  `account_balance` decimal(28,6) NOT NULL,
268
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  KEY `categorycode` (`categorycode`),
271
  KEY `categorycode` (`categorycode`),
Lines 2719-2768 CREATE TABLE `messages` ( -- circulation messages left via the patron's check ou Link Here
2719
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2720
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2720
2721
2721
--
2722
--
2722
-- Table structure for table `accountlines`
2723
--
2724
2725
DROP TABLE IF EXISTS `accountlines`;
2726
CREATE TABLE `accountlines` (
2727
  `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,
2728
  `borrowernumber` int(11) NOT NULL default 0,
2729
  `accountno` smallint(6) NOT NULL default 0,
2730
  `itemnumber` int(11) default NULL,
2731
  `date` date default NULL,
2732
  `amount` decimal(28,6) default NULL,
2733
  `description` mediumtext,
2734
  `dispute` mediumtext,
2735
  `accounttype` varchar(5) default NULL,
2736
  `amountoutstanding` decimal(28,6) default NULL,
2737
  `lastincrement` decimal(28,6) default NULL,
2738
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2739
  `notify_id` int(11) NOT NULL default 0,
2740
  `notify_level` int(2) NOT NULL default 0,
2741
  `note` text NULL default NULL,
2742
  `manager_id` int(11) NULL,
2743
  PRIMARY KEY (`accountlines_id`),
2744
  KEY `acctsborridx` (`borrowernumber`),
2745
  KEY `timeidx` (`timestamp`),
2746
  KEY `itemnumber` (`itemnumber`),
2747
  CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2748
  CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL
2749
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2750
2751
--
2752
-- Table structure for table `accountoffsets`
2753
--
2754
2755
DROP TABLE IF EXISTS `accountoffsets`;
2756
CREATE TABLE `accountoffsets` (
2757
  `borrowernumber` int(11) NOT NULL default 0,
2758
  `accountno` smallint(6) NOT NULL default 0,
2759
  `offsetaccount` smallint(6) NOT NULL default 0,
2760
  `offsetamount` decimal(28,6) default NULL,
2761
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2762
  CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
2763
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2764
2765
--
2766
-- Table structure for table `action_logs`
2723
-- Table structure for table `action_logs`
2767
--
2724
--
2768
2725
Lines 3499-3504 CREATE TABLE items_search_fields ( Link Here
3499
    ON DELETE SET NULL ON UPDATE CASCADE
3456
    ON DELETE SET NULL ON UPDATE CASCADE
3500
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3457
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3501
3458
3459
--
3460
-- Table structure for table 'account_credits'
3461
--
3462
DROP TABLE IF EXISTS account_credits;
3463
CREATE TABLE IF account_credits (
3464
    credit_id int(11) NOT NULL AUTO_INCREMENT,     -- The unique id for this credit
3465
    borrowernumber int(11) NOT NULL,               -- The borrower this credit applies to
3466
    `type` varchar(255) NOT NULL,                  -- The type of credit this is ( defined by Koha::Accounts::CreditTypes )
3467
    amount_received decimal(28,6) DEFAULT NULL,    -- If this was a cash payment, the amount of money given
3468
    amount_paid decimal(28,6) NOT NULL,            -- The actual ammount paid, if less than amount_recieved, change was given back
3469
    amount_remaining decimal(28,6) NOT NULL,       -- The amount of this credit that has not been applied to outstanding debits
3470
    amount_voided decimal(28,6) NULL DEFAULT NULL, -- The amount of this credit was for before it was voided
3471
    notes text,                                    -- Misc notes for this credit
3472
    branchcode VARCHAR( 10 ) NULL DEFAULT NULL,    -- Branchcode where the credit was created ( if any )
3473
    manager_id int(11) DEFAULT NULL,               -- The borrowernumber of the user who created this credit ( if any )
3474
    created_on timestamp NULL DEFAULT NULL,        -- Timestamp for when this credit was created
3475
    updated_on timestamp NULL DEFAULT NULL,        -- Timestamp for when this credit was last modified
3476
    PRIMARY KEY (credit_id),
3477
    KEY borrowernumber (borrowernumber),
3478
    KEY branchcode (branchcode)
3479
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
3480
3481
--
3482
-- Constraints for table `account_credits`
3483
--
3484
ALTER TABLE `account_credits`
3485
  ADD CONSTRAINT account_credits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3486
  ADD CONSTRAINT account_credits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE;
3487
3488
--
3489
-- Table structure for table 'account_debits'
3490
--
3491
3492
DROP TABLE IF EXISTS account_debits;
3493
CREATE TABLE account_debits (
3494
    debit_id int(11) NOT NULL AUTO_INCREMENT,           -- The unique id for this debit
3495
    borrowernumber int(11) NOT NULL DEFAULT '0',        -- The borrower this debit applies to
3496
    itemnumber int(11) DEFAULT NULL,                    -- The item related to this debit ( for fines, lost fees, etc )
3497
    issue_id int(11) DEFAULT NULL,                      -- The checkout this debit is related to ( again, for fines, lost fees, etc )
3498
    `type` varchar(255) NOT NULL,                       -- The type of debit this is ( defined by Koha::Accounts::DebitTypes )
3499
    accruing tinyint(1) NOT NULL DEFAULT '0',           -- Boolean flag, tells of if this is a fine that is still accruing
3500
    amount_original decimal(28,6) DEFAULT NULL,         -- The total amount of this debit
3501
    amount_outstanding decimal(28,6) DEFAULT NULL,      -- The amount still owed on this debit
3502
    amount_last_increment decimal(28,6) DEFAULT NULL,   -- The amount by which this debit last changed
3503
    description mediumtext,                             -- The description for this debit
3504
    notes text,                                         -- Misc notes for this debit
3505
    branchcode VARCHAR( 10 ) NULL DEFAULT NULL,         -- Branchcode where the debit was created ( if any )
3506
    manager_id int(11) DEFAULT NULL,                    -- The borrowernumber of the user who created this debit ( if any )
3507
    created_on timestamp NULL DEFAULT NULL,             -- Timestamp for when this credit was created
3508
    updated_on timestamp NULL DEFAULT NULL,             -- Timestamp for when this credit was last modified
3509
    PRIMARY KEY (debit_id),
3510
    KEY acctsborridx (borrowernumber),
3511
    KEY itemnumber (itemnumber),
3512
    KEY borrowernumber (borrowernumber),
3513
    KEY issue_id (issue_id),
3514
    KEY branchcode (branchcode)
3515
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
3516
3517
--
3518
-- Constraints for table `account_debits`
3519
--
3520
ALTER TABLE `account_debits`
3521
    ADD CONSTRAINT account_debits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3522
    ADD CONSTRAINT account_debits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE;
3523
3524
--
3525
-- Table structure for table 'account_offsets'
3526
--
3527
3528
DROP TABLE IF EXISTS account_offsets;
3529
CREATE TABLE account_offsets (
3530
    offset_id int(11) NOT NULL AUTO_INCREMENT,                                              -- Unique id for this offset
3531
    debit_id int(11) DEFAULT NULL,                                                          -- Related debit
3532
    credit_id int(11) DEFAULT NULL,                                                         -- Related credit ( if any )
3533
    `type` varchar(255) DEFAULT NULL,                                                       -- The type of this offset ( defined by Koha::Accounts::OffsetTypes ), if any
3534
    amount decimal(28,6) NOT NULL,                                                          -- The amount of the offset, positive means patron owes more, negative means patron owes less
3535
    created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,    -- Timestamp for when this offset was created
3536
    PRIMARY KEY (offset_id),
3537
    KEY fee_id (debit_id),
3538
    KEY payment_id (credit_id)
3539
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
3540
3541
--
3542
-- Constraints for table `account_offsets`
3543
--
3544
ALTER TABLE `account_offsets`
3545
    ADD CONSTRAINT account_offsets_ibfk_1 FOREIGN KEY (debit_id) REFERENCES account_debits (debit_id) ON DELETE CASCADE ON UPDATE CASCADE,
3546
    ADD CONSTRAINT account_offsets_ibfk_2 FOREIGN KEY (credit_id) REFERENCES account_credits (credit_id) ON DELETE CASCADE ON UPDATE CASCADE;
3547
3502
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3548
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3503
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3549
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3504
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3550
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +189 lines)
Lines 37-42 use Getopt::Long; Link Here
37
use C4::Context;
37
use C4::Context;
38
use C4::Installer;
38
use C4::Installer;
39
use C4::Dates;
39
use C4::Dates;
40
use Koha::Database;
40
41
41
use MARC::Record;
42
use MARC::Record;
42
use MARC::File::XML ( BinaryEncoding => 'utf8' );
43
use MARC::File::XML ( BinaryEncoding => 'utf8' );
Lines 7299-7304 if ( CheckVersion($DBversion) ) { Link Here
7299
7300
7300
    $dbh->{AutoCommit} = 1;
7301
    $dbh->{AutoCommit} = 1;
7301
    $dbh->{RaiseError} = 0;
7302
    $dbh->{RaiseError} = 0;
7303
   SetVersion ($DBversion);
7302
}
7304
}
7303
7305
7304
$DBversion = "3.13.00.031";
7306
$DBversion = "3.13.00.031";
Lines 8856-8862 if ( CheckVersion($DBversion) ) { Link Here
8856
    $dbh->do("ALTER TABLE  `biblioitems` CHANGE  `cn_sort`  `cn_sort` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
8858
    $dbh->do("ALTER TABLE  `biblioitems` CHANGE  `cn_sort`  `cn_sort` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
8857
    $dbh->do("ALTER TABLE  `deletedbiblioitems` CHANGE  `cn_sort`  `cn_sort` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
8859
    $dbh->do("ALTER TABLE  `deletedbiblioitems` CHANGE  `cn_sort`  `cn_sort` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL");
8858
    print "Upgrade to $DBversion done (Bug 12424 - ddc sorting of call numbers truncates long Cutter parts)\n";
8860
    print "Upgrade to $DBversion done (Bug 12424 - ddc sorting of call numbers truncates long Cutter parts)\n";
8859
    SetVersion ($DBversion);
8861
    SetVersion($DBversion);
8860
}
8862
}
8861
8863
8862
$DBversion = "3.17.00.030";
8864
$DBversion = "3.17.00.030";
Lines 10142-10147 if(CheckVersion($DBversion)) { Link Here
10142
    SetVersion($DBversion);
10144
    SetVersion($DBversion);
10143
}
10145
}
10144
10146
10147
$DBversion = "XXX";
10148
if ( CheckVersion($DBversion) ) {
10149
    $dbh->do(q{
10150
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
10151
    });
10152
    $dbh->do(q{
10153
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
10154
    });
10155
    $dbh->do(q{
10156
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
10157
    });
10158
10159
    $dbh->do(q{
10160
        UPDATE accountlines a LEFT JOIN issues i USING ( borrowernumber, itemnumber ) SET accounttype = 'F' WHERE i.issue_id IS NULL
10161
    });
10162
10163
    $dbh->do("
10164
        CREATE TABLE IF NOT EXISTS account_credits (
10165
            credit_id int(11) NOT NULL AUTO_INCREMENT,
10166
            borrowernumber int(11) NOT NULL,
10167
            `type` varchar(255) NOT NULL,
10168
            amount_received decimal(28,6) DEFAULT NULL,
10169
            amount_paid decimal(28,6) NOT NULL,
10170
            amount_remaining decimal(28,6) NOT NULL,
10171
            amount_voided decimal(28,6) NULL DEFAULT NULL,
10172
            notes text,
10173
            branchcode VARCHAR( 10 ) NULL DEFAULT NULL,
10174
            manager_id int(11) DEFAULT NULL,
10175
            created_on timestamp NULL DEFAULT NULL,
10176
            updated_on timestamp NULL DEFAULT NULL,
10177
            PRIMARY KEY (credit_id),
10178
            KEY borrowernumber (borrowernumber),
10179
            KEY branchcode (branchcode)
10180
        ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
10181
    ");
10182
    $dbh->do("
10183
        CREATE TABLE IF NOT EXISTS account_debits (
10184
            debit_id int(11) NOT NULL AUTO_INCREMENT,
10185
            borrowernumber int(11) NOT NULL DEFAULT '0',
10186
            itemnumber int(11) DEFAULT NULL,
10187
            issue_id int(11) DEFAULT NULL,
10188
            `type` varchar(255) NOT NULL,
10189
            accruing tinyint(1) NOT NULL DEFAULT '0',
10190
            amount_original decimal(28,6) DEFAULT NULL,
10191
            amount_outstanding decimal(28,6) DEFAULT NULL,
10192
            amount_last_increment decimal(28,6) DEFAULT NULL,
10193
            description mediumtext,
10194
            notes text,
10195
            branchcode VARCHAR( 10 ) NULL DEFAULT NULL,
10196
            manager_id int(11) DEFAULT NULL,
10197
            created_on timestamp NULL DEFAULT NULL,
10198
            updated_on timestamp NULL DEFAULT NULL,
10199
            PRIMARY KEY (debit_id),
10200
            KEY acctsborridx (borrowernumber),
10201
            KEY itemnumber (itemnumber),
10202
            KEY borrowernumber (borrowernumber),
10203
            KEY issue_id (issue_id),
10204
            KEY branchcode (branchcode)
10205
        ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
10206
    ");
10207
10208
    $dbh->do("
10209
        CREATE TABLE account_offsets (
10210
            offset_id int(11) NOT NULL AUTO_INCREMENT,
10211
            debit_id int(11) DEFAULT NULL,
10212
            credit_id int(11) DEFAULT NULL,
10213
            `type` varchar(255) DEFAULT NULL,
10214
            amount decimal(28,6) NOT NULL COMMENT 'A positive number here represents a payment, a negative is a increase in a fine.',
10215
            created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10216
            PRIMARY KEY (offset_id),
10217
            KEY fee_id (debit_id),
10218
            KEY payment_id (credit_id)
10219
        ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
10220
    ");
10221
10222
    $dbh->do("
10223
        ALTER TABLE `account_credits`
10224
          ADD CONSTRAINT account_credits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
10225
          ADD CONSTRAINT account_credits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE;
10226
    ");
10227
    $dbh->do("
10228
        ALTER TABLE `account_debits`
10229
          ADD CONSTRAINT account_debits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
10230
          ADD CONSTRAINT account_debits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE;
10231
    ");
10232
    $dbh->do("
10233
        ALTER TABLE `account_offsets`
10234
          ADD CONSTRAINT account_offsets_ibfk_1 FOREIGN KEY (debit_id) REFERENCES account_debits (debit_id) ON DELETE CASCADE ON UPDATE CASCADE,
10235
          ADD CONSTRAINT account_offsets_ibfk_2 FOREIGN KEY (credit_id) REFERENCES account_credits (credit_id) ON DELETE CASCADE ON UPDATE CASCADE;
10236
    ");
10237
10238
    $dbh->do("
10239
        ALTER TABLE borrowers ADD account_balance DECIMAL( 28, 6 ) NOT NULL;
10240
    ");
10241
10242
    my $schema = Koha::Database->new()->schema;
10243
    my $debit_rs = $schema->resultset('AccountDebit');
10244
    my $credit_rs = $schema->resultset('AccountCredit');
10245
    my $issues_rs = $schema->resultset('Issue');
10246
10247
    use Koha::Accounts::DebitTypes;
10248
    use Koha::Accounts::CreditTypes;
10249
10250
    my $debit_types_map = {
10251
        'A'    => Koha::Accounts::DebitTypes::AccountManagementFee,
10252
        'F'    => Koha::Accounts::DebitTypes::Fine,
10253
        'FU'   => Koha::Accounts::DebitTypes::Fine,
10254
        'L'    => Koha::Accounts::DebitTypes::Lost,
10255
        'M'    => Koha::Accounts::DebitTypes::Sundry,
10256
        'N'    => Koha::Accounts::DebitTypes::NewCard,
10257
        'Rent' => Koha::Accounts::DebitTypes::Rental,
10258
    };
10259
10260
    my $credit_types_map = {
10261
        'FOR' => Koha::Accounts::CreditTypes::Forgiven,
10262
        'LR'  => Koha::Accounts::CreditTypes::Found,
10263
        'Pay' => Koha::Accounts::CreditTypes::Payment,
10264
        'PAY' => Koha::Accounts::CreditTypes::Payment,
10265
        'WO'  => Koha::Accounts::CreditTypes::WriteOff,
10266
        'W'   => Koha::Accounts::CreditTypes::WriteOff,
10267
        'C'   => Koha::Accounts::CreditTypes::Credit,
10268
        'CR'  => Koha::Accounts::CreditTypes::Credit,
10269
    };
10270
10271
    my $sth = $dbh->prepare("SELECT * FROM accountlines");
10272
    $sth->execute();
10273
    while ( my $a = $sth->fetchrow_hashref() ) {
10274
        if ( $debit_types_map->{ $a->{accounttype} } ) {
10275
            $debit_rs->create(
10276
                {
10277
                    borrowernumber     => $a->{borrowernumber},
10278
                    itemnumber         => $a->{itemnumber},
10279
                    amount_original    => $a->{amount},
10280
                    amount_outstanding => $a->{amountoutstanding},
10281
                    created_on         => $a->{timestamp},
10282
                    description        => $a->{description},
10283
                    notes              => $a->{note},
10284
                    manager_id         => $a->{manager_id},
10285
                    accruing           => $a->{accounttype} eq 'FU',
10286
                    type     => $debit_types_map->{ $a->{accounttype} },
10287
                    issue_id => $a->{accounttype} eq 'FU'
10288
                    ? $issues_rs->single(
10289
                        {
10290
                            borrowernumber => $a->{borrowernumber},
10291
                            itemnumber     => $a->{itemnumber},
10292
                        }
10293
                      )->issue_id()
10294
                    : undef,
10295
                }
10296
            );
10297
        }
10298
        elsif ( $credit_types_map->{ $a->{accounttype} } ) {
10299
            $credit_rs->create(
10300
                {
10301
                    borrowernumber   => $a->{borrowernumber},
10302
                    amount_paid      => $a->{amount} * -1,
10303
                    amount_remaining => $a->{amountoutstanding} * -1,
10304
                    created_on       => $a->{timestamp},
10305
                    notes            => $a->{note},
10306
                    manager_id       => $a->{manager_id},
10307
                    type => $credit_types_map->{ $a->{accounttype} },
10308
                }
10309
            );
10310
        }
10311
        else {
10312
            # Everything else must be a MANUAL_INV
10313
            $debit_rs->create(
10314
                {
10315
                    borrowernumber     => $a->{borrowernumber},
10316
                    itemnumber         => $a->{itemnumber},
10317
                    amount_original    => $a->{amount},
10318
                    amount_outstanding => $a->{amountoutstanding},
10319
                    created_on         => $a->{timestamp},
10320
                    description        => $a->{description},
10321
                    notes              => $a->{note},
10322
                    manager_id         => $a->{manager_id},
10323
                    type               => Koha::Accounts::DebitTypes::Sundry,
10324
                }
10325
            );
10326
        }
10327
    }
10328
10329
    print "Upgrade to $DBversion done ( Bug 6427 - Rewrite of the accounts system )\n";
10330
    SetVersion ($DBversion);
10331
}
10332
10145
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10333
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10146
# SEE bug 13068
10334
# SEE bug 13068
10147
# if there is anything in the atomicupdate, read and execute it.
10335
# if there is anything in the atomicupdate, read and execute it.
10148
- 

Return to bug 6427