|
Lines 3790-3795
CREATE TABLE `hold_fill_targets` (
Link Here
|
| 3790 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
3790 |
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3791 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3791 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3792 |
|
3792 |
|
|
|
3793 |
-- |
| 3794 |
-- Table structure for table 'import_oai' |
| 3795 |
-- |
| 3796 |
|
| 3797 |
DROP TABLE IF EXISTS import_oai; |
| 3798 |
CREATE TABLE import_oai ( |
| 3799 |
import_oai_id int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 3800 |
header_identifier varchar(45) NOT NULL, |
| 3801 |
header_datestamp datetime NOT NULL, |
| 3802 |
header_status varchar(45) DEFAULT NULL, |
| 3803 |
record longtext NOT NULL, |
| 3804 |
upload_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 3805 |
status varchar(45) NOT NULL, |
| 3806 |
import_batch_id int(11) NOT NULL, |
| 3807 |
filter text NOT NULL, |
| 3808 |
PRIMARY KEY (import_oai_id), |
| 3809 |
KEY FK_import_oai_1 (import_batch_id) |
| 3810 |
CONSTRAINT FK_import_oai_1 FOREIGN KEY (import_batch_id) REFERENCES import_batches (import_batch_id) |
| 3811 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3812 |
|
| 3813 |
-- |
| 3814 |
-- Table structure for table 'saved_tasks' |
| 3815 |
-- |
| 3816 |
|
| 3817 |
DROP TABLE IF EXISTS saved_tasks; |
| 3818 |
CREATE TABLE saved_tasks ( |
| 3819 |
task_id int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 3820 |
start_time datetime NOT NULL, |
| 3821 |
repeat_interval int(10) unsigned NOT NULL, |
| 3822 |
task_type varchar(255) NOT NULL, |
| 3823 |
params text NOT NULL, |
| 3824 |
PRIMARY KEY (task_id) USING BTREE |
| 3825 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3826 |
|
| 3793 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3827 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 3794 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3828 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 3795 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3829 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
| 3796 |
- |
|
|