Lines 119-124
DROP TABLE IF EXISTS `accountlines`;
Link Here
|
119 |
CREATE TABLE `accountlines` ( |
119 |
CREATE TABLE `accountlines` ( |
120 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
120 |
`accountlines_id` int(11) NOT NULL AUTO_INCREMENT, |
121 |
`issue_id` int(11) DEFAULT NULL, |
121 |
`issue_id` int(11) DEFAULT NULL, |
|
|
122 |
`old_issue_id` int(11) DEFAULT NULL, |
122 |
`borrowernumber` int(11) DEFAULT NULL, |
123 |
`borrowernumber` int(11) DEFAULT NULL, |
123 |
`itemnumber` int(11) DEFAULT NULL, |
124 |
`itemnumber` int(11) DEFAULT NULL, |
124 |
`date` timestamp NULL DEFAULT NULL, |
125 |
`date` timestamp NULL DEFAULT NULL, |
Lines 143-148
CREATE TABLE `accountlines` (
Link Here
|
143 |
KEY `debit_type_code` (`debit_type_code`), |
144 |
KEY `debit_type_code` (`debit_type_code`), |
144 |
KEY `itemnumber` (`itemnumber`), |
145 |
KEY `itemnumber` (`itemnumber`), |
145 |
KEY `branchcode` (`branchcode`), |
146 |
KEY `branchcode` (`branchcode`), |
|
|
147 |
KEY `issue_id` (`issue_id`), |
148 |
KEY `old_issue_id` (`old_issue_id`), |
146 |
KEY `manager_id` (`manager_id`), |
149 |
KEY `manager_id` (`manager_id`), |
147 |
KEY `accountlines_ibfk_registers` (`register_id`), |
150 |
KEY `accountlines_ibfk_registers` (`register_id`), |
148 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
151 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
Lines 150-160
CREATE TABLE `accountlines` (
Link Here
|
150 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
153 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
151 |
CONSTRAINT `accountlines_ibfk_credit_type` FOREIGN KEY (`credit_type_code`) REFERENCES `account_credit_types` (`code`) ON UPDATE CASCADE, |
154 |
CONSTRAINT `accountlines_ibfk_credit_type` FOREIGN KEY (`credit_type_code`) REFERENCES `account_credit_types` (`code`) ON UPDATE CASCADE, |
152 |
CONSTRAINT `accountlines_ibfk_debit_type` FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON UPDATE CASCADE, |
155 |
CONSTRAINT `accountlines_ibfk_debit_type` FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON UPDATE CASCADE, |
|
|
156 |
CONSTRAINT `accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
153 |
CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
157 |
CONSTRAINT `accountlines_ibfk_items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
158 |
CONSTRAINT `accountlines_ibfk_old_issues` FOREIGN KEY (`old_issue_id`) REFERENCES `old_issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
154 |
CONSTRAINT `accountlines_ibfk_registers` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
159 |
CONSTRAINT `accountlines_ibfk_registers` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
155 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
160 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
156 |
/*!40101 SET character_set_client = @saved_cs_client */; |
161 |
/*!40101 SET character_set_client = @saved_cs_client */; |
157 |
|
162 |
|
|
|
163 |
|
158 |
-- |
164 |
-- |
159 |
-- Table structure for table `action_logs` |
165 |
-- Table structure for table `action_logs` |
160 |
-- |
166 |
-- |
161 |
- |
|
|