|
Lines 448-454
CREATE TABLE collections_tracking (
Link Here
|
| 448 |
transferred tinyint(1) DEFAULT '0', |
448 |
transferred tinyint(1) DEFAULT '0', |
| 449 |
date_added datetime DEFAULT NULL, |
449 |
date_added datetime DEFAULT NULL, |
| 450 |
timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
450 |
timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 451 |
PRIMARY KEY (collections_tracking_id) |
451 |
PRIMARY KEY (collections_tracking_id), |
|
|
452 |
CONSTRAINT `coltra-fk-items` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) |
| 453 |
ON DELETE CASCADE ON UPDATE CASCADE |
| 452 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
454 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 453 |
|
455 |
|
| 454 |
-- |
456 |
-- |
| 455 |
- |
|
|