|
Lines 318-323
CREATE TABLE collections (
Link Here
|
| 318 |
colTitle varchar(100) NOT NULL DEFAULT '', |
318 |
colTitle varchar(100) NOT NULL DEFAULT '', |
| 319 |
colDesc MEDIUMTEXT NOT NULL, |
319 |
colDesc MEDIUMTEXT NOT NULL, |
| 320 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
320 |
colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.' |
|
|
321 |
createdBy int(11) default NULL, |
| 322 |
createdOn datetime default NULL, |
| 323 |
lastTransferredOn datetime default NULL, |
| 321 |
PRIMARY KEY (colId) |
324 |
PRIMARY KEY (colId) |
| 322 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
325 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 323 |
|
326 |
|
|
Lines 327-332
CREATE TABLE collections (
Link Here
|
| 327 |
ALTER TABLE `collections` |
330 |
ALTER TABLE `collections` |
| 328 |
ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE; |
331 |
ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE; |
| 329 |
|
332 |
|
|
|
333 |
ALTER TABLE `collections` |
| 334 |
ADD CONSTRAINT `collections_ibfk_2` FOREIGN KEY (`createdBy`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE; |
| 335 |
|
| 330 |
-- |
336 |
-- |
| 331 |
-- Table structure for table `branch_borrower_circ_rules` |
337 |
-- Table structure for table `branch_borrower_circ_rules` |
| 332 |
-- |
338 |
-- |
| 333 |
- |
|
|