View | Details | Raw Unified | Return to bug 10662
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +34 lines)
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
- 

Return to bug 10662