|
Lines 4576-4581
CREATE TABLE advanced_editor_macros (
Link Here
|
| 4576 |
CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE |
4576 |
CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE |
| 4577 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4577 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4578 |
|
4578 |
|
|
|
4579 |
-- |
| 4580 |
-- Table structure for table background_jobs |
| 4581 |
-- |
| 4582 |
|
| 4583 |
DROP TABLE IF EXISTS `background_jobs`; |
| 4584 |
CREATE TABLE background_jobs ( |
| 4585 |
id INT(11) NOT NULL AUTO_INCREMENT, |
| 4586 |
status VARCHAR(32), |
| 4587 |
progress INT(11), |
| 4588 |
size INT(11), |
| 4589 |
borrowernumber INT(11), |
| 4590 |
type VARCHAR(64), |
| 4591 |
data TEXT, |
| 4592 |
enqueued_on DATETIME DEFAULT NULL, |
| 4593 |
started_on DATETIME DEFAULT NULL, |
| 4594 |
ended_on DATETIME DEFAULT NULL, |
| 4595 |
PRIMARY KEY (id) |
| 4596 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4597 |
|
| 4579 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4598 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 4580 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4599 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 4581 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4600 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 4582 |
- |
|
|