Attachment 53258 Details for Bug 10662 – Bug 10662 - kohastructure.sql changes

[patch] Bug 10662 - kohastructure.sql changes

Bug-10662---kohastructuresql-changes.patch (text/plain), 1.99 KB, created by David Cook on 2016-07-11 05:41:23 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Cook

Created: 2016-07-11 05:41:23 UTC

Size: 1.99 KB

patch

obsolete

>From 0f46338a6eeae35622ee789fdbf2489e2b557cf0 Mon Sep 17 00:00:00 2001
>From: David Cook <dcook@prosentient.com.au>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 10662: 20757 | 20758 | 21954 | 42446 | 42447 | 42448 | 44792 | 44793 | 47675 | 48096 | 49832 | 50254 | 50980 | 51510 | 51511 | 51512 | 51514 | 51562 | 51563 | 51564 | 51565 | 51705 | 53258 | 53259 | 53260 | 53361 | 53362 | 64444 | 64445 | 64446 | 64479 | 64480 | 64481 | 65016 | 65017 | 65018 | 65019 | 68508 | 71008 | 71009 | 71010 | 71011 | 71012 | 71013 | 71014 | 71015 | 78569 | 78570 | 78571 | 78572 | 78573 | 78574 | 78575 | 78576 | 78577 | 78583 | 78601 | 78617 | 78754 | 78756 | 78758 | 78760 | 78762 | 78764 | 78767 | 78769 | 78771 | 78859 | 78860 | 78914 | 78956 | 79039 | 79045 | 81783 | 81784 | 81786 | 81789 | 81790 | 81855 | 81856 | 81861 | 81862 | 81863 | 81864 | 81902 | 82219 | 84318 | 84319 | 84320 | 84321 | 84322 | 85152 | 85224 | 85225 | 85226 | 85227 | 85228 | 85229 | 99739 | 99740 | 99741 | 99742 | 99743 | 99744 | 99745