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

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (+6 lines)
Lines 85-90 if ( CheckVersion($DBversion) ) { Link Here
85
          }
85
          }
86
    );
86
    );
87
87
88
    $dbh->do(
89
        qq{
90
        ALTER TABLE accountlines ADD CONSTRAINT `accountlines_check_type` CHECK (accounttype IS NOT NULL OR debit_type IS NOT NULL)
91
        }
92
    );
93
88
    # Add new permission
94
    # Add new permission
89
    $dbh->do(
95
    $dbh->do(
90
        q{
96
        q{
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2677-2682 CREATE TABLE `accountlines` ( Link Here
2677
  KEY `itemnumber` (`itemnumber`),
2677
  KEY `itemnumber` (`itemnumber`),
2678
  KEY `branchcode` (`branchcode`),
2678
  KEY `branchcode` (`branchcode`),
2679
  KEY `manager_id` (`manager_id`),
2679
  KEY `manager_id` (`manager_id`),
2680
  CONSTRAINT `accountlines_check_type` CHECK (accounttype IS NOT NULL OR debit_type IS NOT NULL),
2680
  CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2681
  CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2681
  CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2682
  CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2682
  CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2683
  CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
2683
- 

Return to bug 23049