| 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 2734-2783
          CREATE TABLE `messages` ( -- circulation messages left via the patron's check ou
      
      
        Link Here | 
        
          | 2734 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 2735 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 
        
          | 2735 |  | 2736 |  | 
        
          | 2736 | -- | 2737 | -- | 
            
              | 2737 | -- Table structure for table `accountlines` |  |  | 
            
              | 2738 | -- | 
            
              | 2739 |  | 
            
              | 2740 | DROP TABLE IF EXISTS `accountlines`; | 
            
              | 2741 | CREATE TABLE `accountlines` ( | 
            
              | 2742 |   `accountlines_id` int(11) NOT NULL AUTO_INCREMENT, | 
            
              | 2743 |   `borrowernumber` int(11) NOT NULL default 0, | 
            
              | 2744 |   `accountno` smallint(6) NOT NULL default 0, | 
            
              | 2745 |   `itemnumber` int(11) default NULL, | 
            
              | 2746 |   `date` date default NULL, | 
            
              | 2747 |   `amount` decimal(28,6) default NULL, | 
            
              | 2748 |   `description` mediumtext, | 
            
              | 2749 |   `dispute` mediumtext, | 
            
              | 2750 |   `accounttype` varchar(5) default NULL, | 
            
              | 2751 |   `amountoutstanding` decimal(28,6) default NULL, | 
            
              | 2752 |   `lastincrement` decimal(28,6) default NULL, | 
            
              | 2753 |   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | 
            
              | 2754 |   `notify_id` int(11) NOT NULL default 0, | 
            
              | 2755 |   `notify_level` int(2) NOT NULL default 0, | 
            
              | 2756 |   `note` text NULL default NULL, | 
            
              | 2757 |   `manager_id` int(11) NULL, | 
            
              | 2758 |   PRIMARY KEY (`accountlines_id`), | 
            
              | 2759 |   KEY `acctsborridx` (`borrowernumber`), | 
            
              | 2760 |   KEY `timeidx` (`timestamp`), | 
            
              | 2761 |   KEY `itemnumber` (`itemnumber`), | 
            
              | 2762 |   CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 2763 |   CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL | 
            
              | 2764 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 
            
              | 2765 |  | 
            
              | 2766 | -- | 
            
              | 2767 | -- Table structure for table `accountoffsets` | 
            
              | 2768 | -- | 
            
              | 2769 |  | 
            
              | 2770 | DROP TABLE IF EXISTS `accountoffsets`; | 
            
              | 2771 | CREATE TABLE `accountoffsets` ( | 
            
              | 2772 |   `borrowernumber` int(11) NOT NULL default 0, | 
            
              | 2773 |   `accountno` smallint(6) NOT NULL default 0, | 
            
              | 2774 |   `offsetaccount` smallint(6) NOT NULL default 0, | 
            
              | 2775 |   `offsetamount` decimal(28,6) default NULL, | 
            
              | 2776 |   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | 
            
              | 2777 |   CONSTRAINT `accountoffsets_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE | 
            
              | 2778 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 
            
              | 2779 |  | 
            
              | 2780 | -- | 
        
          | 2781 | -- Table structure for table `action_logs` | 2738 | -- Table structure for table `action_logs` | 
        
          | 2782 | -- | 2739 | -- | 
        
          | 2783 |  | 2740 |  | 
  
    | Lines 3502-3507
          CREATE TABLE items_search_fields (
      
      
        Link Here | 
        
          | 3502 |     ON DELETE SET NULL ON UPDATE CASCADE | 3459 |     ON DELETE SET NULL ON UPDATE CASCADE | 
        
          | 3503 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 3460 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 
        
          | 3504 |  | 3461 |  | 
            
              |  |  | 3462 | -- | 
            
              | 3463 | -- Table structure for table 'account_credits' | 
            
              | 3464 | -- | 
            
              | 3465 | DROP TABLE IF EXISTS account_credits; | 
            
              | 3466 | CREATE TABLE IF account_credits ( | 
            
              | 3467 |     credit_id int(11) NOT NULL AUTO_INCREMENT,     -- The unique id for this credit | 
            
              | 3468 |     borrowernumber int(11) NOT NULL,               -- The borrower this credit applies to | 
            
              | 3469 |     `type` varchar(255) NOT NULL,                  -- The type of credit this is ( defined by Koha::Accounts::CreditTypes ) | 
            
              | 3470 |     amount_received decimal(28,6) DEFAULT NULL,    -- If this was a cash payment, the amount of money given | 
            
              | 3471 |     amount_paid decimal(28,6) NOT NULL,            -- The actual ammount paid, if less than amount_recieved, change was given back | 
            
              | 3472 |     amount_remaining decimal(28,6) NOT NULL,       -- The amount of this credit that has not been applied to outstanding debits | 
            
              | 3473 |     amount_voided decimal(28,6) NULL DEFAULT NULL, -- The amount of this credit was for before it was voided | 
            
              | 3474 |     notes text,                                    -- Misc notes for this credit | 
            
              | 3475 |     branchcode VARCHAR( 10 ) NULL DEFAULT NULL,    -- Branchcode where the credit was created ( if any ) | 
            
              | 3476 |     manager_id int(11) DEFAULT NULL,               -- The borrowernumber of the user who created this credit ( if any ) | 
            
              | 3477 |     created_on timestamp NULL DEFAULT NULL,        -- Timestamp for when this credit was created | 
            
              | 3478 |     updated_on timestamp NULL DEFAULT NULL,        -- Timestamp for when this credit was last modified | 
            
              | 3479 |     PRIMARY KEY (credit_id), | 
            
              | 3480 |     KEY borrowernumber (borrowernumber), | 
            
              | 3481 |     KEY branchcode (branchcode) | 
            
              | 3482 | ) ENGINE=InnoDB  DEFAULT CHARSET=utf8; | 
            
              | 3483 |  | 
            
              | 3484 | -- | 
            
              | 3485 | -- Constraints for table `account_credits` | 
            
              | 3486 | -- | 
            
              | 3487 | ALTER TABLE `account_credits` | 
            
              | 3488 |   ADD CONSTRAINT account_credits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 3489 |   ADD CONSTRAINT account_credits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; | 
            
              | 3490 |  | 
            
              | 3491 | -- | 
            
              | 3492 | -- Table structure for table 'account_debits' | 
            
              | 3493 | -- | 
            
              | 3494 |  | 
            
              | 3495 | DROP TABLE IF EXISTS account_debits; | 
            
              | 3496 | CREATE TABLE account_debits ( | 
            
              | 3497 |     debit_id int(11) NOT NULL AUTO_INCREMENT,           -- The unique id for this debit | 
            
              | 3498 |     borrowernumber int(11) NOT NULL DEFAULT '0',        -- The borrower this debit applies to | 
            
              | 3499 |     itemnumber int(11) DEFAULT NULL,                    -- The item related to this debit ( for fines, lost fees, etc ) | 
            
              | 3500 |     issue_id int(11) DEFAULT NULL,                      -- The checkout this debit is related to ( again, for fines, lost fees, etc ) | 
            
              | 3501 |     `type` varchar(255) NOT NULL,                       -- The type of debit this is ( defined by Koha::Accounts::DebitTypes ) | 
            
              | 3502 |     accruing tinyint(1) NOT NULL DEFAULT '0',           -- Boolean flag, tells of if this is a fine that is still accruing | 
            
              | 3503 |     amount_original decimal(28,6) DEFAULT NULL,         -- The total amount of this debit | 
            
              | 3504 |     amount_outstanding decimal(28,6) DEFAULT NULL,      -- The amount still owed on this debit | 
            
              | 3505 |     amount_last_increment decimal(28,6) DEFAULT NULL,   -- The amount by which this debit last changed | 
            
              | 3506 |     description mediumtext,                             -- The description for this debit | 
            
              | 3507 |     notes text,                                         -- Misc notes for this debit | 
            
              | 3508 |     branchcode VARCHAR( 10 ) NULL DEFAULT NULL,         -- Branchcode where the debit was created ( if any ) | 
            
              | 3509 |     manager_id int(11) DEFAULT NULL,                    -- The borrowernumber of the user who created this debit ( if any ) | 
            
              | 3510 |     created_on timestamp NULL DEFAULT NULL,             -- Timestamp for when this credit was created | 
            
              | 3511 |     updated_on timestamp NULL DEFAULT NULL,             -- Timestamp for when this credit was last modified | 
            
              | 3512 |     PRIMARY KEY (debit_id), | 
            
              | 3513 |     KEY acctsborridx (borrowernumber), | 
            
              | 3514 |     KEY itemnumber (itemnumber), | 
            
              | 3515 |     KEY borrowernumber (borrowernumber), | 
            
              | 3516 |     KEY issue_id (issue_id), | 
            
              | 3517 |     KEY branchcode (branchcode) | 
            
              | 3518 | ) ENGINE=InnoDB  DEFAULT CHARSET=utf8; | 
            
              | 3519 |  | 
            
              | 3520 | -- | 
            
              | 3521 | -- Constraints for table `account_debits` | 
            
              | 3522 | -- | 
            
              | 3523 | ALTER TABLE `account_debits` | 
            
              | 3524 |     ADD CONSTRAINT account_debits_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 3525 |     ADD CONSTRAINT account_debits_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE; | 
            
              | 3526 |  | 
            
              | 3527 | -- | 
            
              | 3528 | -- Table structure for table 'account_offsets' | 
            
              | 3529 | -- | 
            
              | 3530 |  | 
            
              | 3531 | DROP TABLE IF EXISTS account_offsets; | 
            
              | 3532 | CREATE TABLE account_offsets ( | 
            
              | 3533 |     offset_id int(11) NOT NULL AUTO_INCREMENT,                                              -- Unique id for this offset | 
            
              | 3534 |     debit_id int(11) DEFAULT NULL,                                                          -- Related debit | 
            
              | 3535 |     credit_id int(11) DEFAULT NULL,                                                         -- Related credit ( if any ) | 
            
              | 3536 |     `type` varchar(255) DEFAULT NULL,                                                       -- The type of this offset ( defined by Koha::Accounts::OffsetTypes ), if any | 
            
              | 3537 |     amount decimal(28,6) NOT NULL,                                                          -- The amount of the offset, positive means patron owes more, negative means patron owes less | 
            
              | 3538 |     created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,    -- Timestamp for when this offset was created | 
            
              | 3539 |     PRIMARY KEY (offset_id), | 
            
              | 3540 |     KEY fee_id (debit_id), | 
            
              | 3541 |     KEY payment_id (credit_id) | 
            
              | 3542 | ) ENGINE=InnoDB  DEFAULT CHARSET=utf8; | 
            
              | 3543 |  | 
            
              | 3544 | -- | 
            
              | 3545 | -- Constraints for table `account_offsets` | 
            
              | 3546 | -- | 
            
              | 3547 | ALTER TABLE `account_offsets` | 
            
              | 3548 |     ADD CONSTRAINT account_offsets_ibfk_1 FOREIGN KEY (debit_id) REFERENCES account_debits (debit_id) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 3549 |     ADD CONSTRAINT account_offsets_ibfk_2 FOREIGN KEY (credit_id) REFERENCES account_credits (credit_id) ON DELETE CASCADE ON UPDATE CASCADE; | 
            
              | 3550 |  | 
        
          | 3505 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; | 3551 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; | 
        
          | 3506 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; | 3552 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; | 
        
          | 3507 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; | 3553 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |