From 0f46338a6eeae35622ee789fdbf2489e2b557cf0 Mon Sep 17 00:00:00 2001 From: David Cook Date: Mon, 16 May 2016 16:07:08 +1000 Subject: [PATCH] Bug 10662 - kohastructure.sql changes --- installer/data/mysql/kohastructure.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ded442c..c2c5546 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/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 */; -- 2.1.4