Lines 120-125
CREATE TABLE `accountlines` (
Link Here
|
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 |
`old_issue_id` int(11) DEFAULT NULL, |
|
|
123 |
`reserve_id` int(11) DEFAULT NULL, |
124 |
`old_reserve_id` int(11) DEFAULT NULL, |
123 |
`borrowernumber` int(11) DEFAULT NULL, |
125 |
`borrowernumber` int(11) DEFAULT NULL, |
124 |
`itemnumber` int(11) DEFAULT NULL, |
126 |
`itemnumber` int(11) DEFAULT NULL, |
125 |
`date` timestamp NULL DEFAULT NULL, |
127 |
`date` timestamp NULL DEFAULT NULL, |
Lines 148-153
CREATE TABLE `accountlines` (
Link Here
|
148 |
KEY `accountlines_ibfk_registers` (`register_id`), |
150 |
KEY `accountlines_ibfk_registers` (`register_id`), |
149 |
KEY `accountlines_ibfk_old_issues` (`old_issue_id`), |
151 |
KEY `accountlines_ibfk_old_issues` (`old_issue_id`), |
150 |
KEY `accountlines_ibfk_issues` (`issue_id`), |
152 |
KEY `accountlines_ibfk_issues` (`issue_id`), |
|
|
153 |
KEY `accountlines_ibfk_reserves` (`reserve_id`), |
154 |
KEY `accountlines_ibfk_old_reserves` (`old_reserve_id`), |
151 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
155 |
CONSTRAINT `accountlines_ibfk_borrowers` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
152 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
156 |
CONSTRAINT `accountlines_ibfk_borrowers_2` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) 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, |
157 |
CONSTRAINT `accountlines_ibfk_branches` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, |
Lines 156-162
CREATE TABLE `accountlines` (
Link Here
|
156 |
CONSTRAINT `accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
160 |
CONSTRAINT `accountlines_ibfk_issues` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) 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, |
161 |
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, |
162 |
CONSTRAINT `accountlines_ibfk_old_issues` FOREIGN KEY (`old_issue_id`) REFERENCES `old_issues` (`issue_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 |
163 |
CONSTRAINT `accountlines_ibfk_registers` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, |
|
|
164 |
CONSTRAINT `accountlines_ibfk_reserves` FOREIGN KEY (`reserve_id`) REFERENCES `reserves` (`reserve_id`) ON DELETE SET NULL ON UPDATE CASCADE, |
165 |
CONSTRAINT `accountlines_ibfk_old_reserves` FOREIGN KEY (`old_reserve_id`) REFERENCES `old_reserves` (`reserve_id`) ON DELETE SET NULL ON UPDATE CASCADE |
160 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
166 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
161 |
/*!40101 SET character_set_client = @saved_cs_client */; |
167 |
/*!40101 SET character_set_client = @saved_cs_client */; |
162 |
|
168 |
|
163 |
- |
|
|