@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3790,6 +3790,40 @@ CREATE TABLE `hold_fill_targets` ( REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +-- +-- Table structure for table 'import_oai' +-- + +DROP TABLE IF EXISTS import_oai; +CREATE TABLE import_oai ( + import_oai_id int(10) unsigned NOT NULL AUTO_INCREMENT, + header_identifier varchar(45) NOT NULL, + header_datestamp datetime NOT NULL, + header_status varchar(45) DEFAULT NULL, + record longtext NOT NULL, + upload_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + status varchar(45) NOT NULL, + import_batch_id int(11) NOT NULL, + filter text NOT NULL, + PRIMARY KEY (import_oai_id), + KEY FK_import_oai_1 (import_batch_id) + CONSTRAINT FK_import_oai_1 FOREIGN KEY (import_batch_id) REFERENCES import_batches (import_batch_id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +-- +-- Table structure for table 'saved_tasks' +-- + +DROP TABLE IF EXISTS saved_tasks; +CREATE TABLE saved_tasks ( + task_id int(10) unsigned NOT NULL AUTO_INCREMENT, + start_time datetime NOT NULL, + repeat_interval int(10) unsigned NOT NULL, + task_type varchar(255) NOT NULL, + params text NOT NULL, + PRIMARY KEY (task_id) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; --