Lines 2621-2626
CREATE TABLE `cash_registers` (
Link Here
|
2621 |
CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE |
2621 |
CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE |
2622 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
2622 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
2623 |
|
2623 |
|
|
|
2624 |
-- |
2625 |
-- Table structure for table `account_credit_types` |
2626 |
-- |
2627 |
|
2628 |
DROP TABLE IF EXISTS `account_credit_types`; |
2629 |
CREATE TABLE `account_credit_types` ( |
2630 |
`code` varchar(80) NOT NULL, |
2631 |
`description` varchar(200) DEFAULT NULL, |
2632 |
`can_be_added_manually` tinyint(4) NOT NULL DEFAULT 1, |
2633 |
`is_system` tinyint(1) NOT NULL DEFAULT 0, |
2634 |
PRIMARY KEY (`code`) |
2635 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2636 |
|
2637 |
-- |
2638 |
-- Table structure for table `account_credit_types_branches` |
2639 |
-- |
2640 |
|
2641 |
DROP TABLE IF EXISTS `account_credit_types_branches`; |
2642 |
CREATE TABLE `account_credit_types_branches` ( |
2643 |
`credit_type_code` VARCHAR(80), |
2644 |
`branchcode` VARCHAR(10), |
2645 |
FOREIGN KEY (`credit_type_code`) REFERENCES `account_credit_types` (`code`) ON DELETE CASCADE, |
2646 |
FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE |
2647 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2648 |
|
2624 |
-- |
2649 |
-- |
2625 |
-- Table structure for table `account_debit_types` |
2650 |
-- Table structure for table `account_debit_types` |
2626 |
-- |
2651 |
-- |
Lines 2660-2666
CREATE TABLE `accountlines` (
Link Here
|
2660 |
`date` date default NULL, |
2685 |
`date` date default NULL, |
2661 |
`amount` decimal(28,6) default NULL, |
2686 |
`amount` decimal(28,6) default NULL, |
2662 |
`description` LONGTEXT, |
2687 |
`description` LONGTEXT, |
2663 |
`accounttype` varchar(80) default NULL, |
2688 |
`credit_type_code` varchar(80) default NULL, |
2664 |
`debit_type_code` varchar(80) default NULL, |
2689 |
`debit_type_code` varchar(80) default NULL, |
2665 |
`status` varchar(16) default NULL, |
2690 |
`status` varchar(16) default NULL, |
2666 |
`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE |
2691 |
`payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE |
Lines 2674-2679
CREATE TABLE `accountlines` (
Link Here
|
2674 |
PRIMARY KEY (`accountlines_id`), |
2699 |
PRIMARY KEY (`accountlines_id`), |
2675 |
KEY `acctsborridx` (`borrowernumber`), |
2700 |
KEY `acctsborridx` (`borrowernumber`), |
2676 |
KEY `timeidx` (`timestamp`), |
2701 |
KEY `timeidx` (`timestamp`), |
|
|
2702 |
KEY `credit_type_code` (`credit_type_code`), |
2677 |
KEY `debit_type_code` (`debit_type_code`), |
2703 |
KEY `debit_type_code` (`debit_type_code`), |
2678 |
KEY `itemnumber` (`itemnumber`), |
2704 |
KEY `itemnumber` (`itemnumber`), |
2679 |
KEY `branchcode` (`branchcode`), |
2705 |
KEY `branchcode` (`branchcode`), |
Lines 2684-2689
CREATE TABLE `accountlines` (
Link Here
|
2684 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2710 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
2685 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
2711 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
2686 |
CONSTRAINT `accountlines_ibfk_registers` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, |
2712 |
CONSTRAINT `accountlines_ibfk_registers` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
2713 |
CONSTRAINT `accountlines_ibfk_credit_type` FOREIGN KEY (`credit_type_code`) REFERENCES `account_credit_types` (`code`) ON DELETE SET NULL ON UPDATE CASCADE, |
2687 |
CONSTRAINT `accountlines_ibfk_debit_type` FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE SET NULL ON UPDATE CASCADE |
2714 |
CONSTRAINT `accountlines_ibfk_debit_type` FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE SET NULL ON UPDATE CASCADE |
2688 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2715 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2689 |
|
2716 |
|
2690 |
- |
|
|