|
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 |
- |
|
|