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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +31 lines)
Lines 3776-3781 CREATE TABLE IF NOT EXISTS edifact_ean ( Link Here
3776
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3776
  CONSTRAINT efk_branchcode FOREIGN KEY ( branchcode ) REFERENCES branches ( branchcode )
3777
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3777
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3778
3778
3779
--
3780
-- Table structure for table 'import_oai'
3781
--
3782
3783
DROP TABLE IF EXISTS import_oai;
3784
CREATE TABLE  import_oai (
3785
  import_oai_id int(10) unsigned NOT NULL AUTO_INCREMENT,
3786
  header_identifier varchar(45) CHARACTER SET utf8 NOT NULL,
3787
  header_datestamp datetime NOT NULL,
3788
  header_status varchar(45) CHARACTER SET utf8 DEFAULT NULL,
3789
  metadata longtext CHARACTER SET utf8 NOT NULL,
3790
  last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3791
  status varchar(45) CHARACTER SET utf8 NOT NULL,
3792
  PRIMARY KEY (import_oai_id)
3793
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3794
3795
--
3796
-- Table structure for table 'saved_tasks'
3797
--
3798
3799
DROP TABLE IF EXISTS saved_tasks;
3800
CREATE TABLE  saved_tasks (
3801
  task_id int(10) unsigned NOT NULL AUTO_INCREMENT,
3802
  start_time datetime NOT NULL,
3803
  repeat_interval int(10) unsigned NOT NULL,
3804
  task_type varchar(255) CHARACTER SET utf8 NOT NULL,
3805
  params text CHARACTER SET utf8 NOT NULL,
3806
  PRIMARY KEY (task_id) USING BTREE
3807
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3808
3809
3779
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3810
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3780
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3811
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3781
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3812
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3782
- 

Return to bug 10662