Einvoice Turnkey MySQL Migration

init.sql

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table from_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `from_config`;

CREATE TABLE `from_config` (
  `transport_id` varchar(10) DEFAULT '',
  `transport_password` varchar(45) DEFAULT NULL,
  `party_id` varchar(10) NOT NULL DEFAULT '',
  `party_description` varchar(200) DEFAULT NULL,
  `routing_id` varchar(39) DEFAULT NULL,
  `routing_description` varchar(200) DEFAULT NULL,
  `sign_id` varchar(4) DEFAULT NULL,
  `substitute_party_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`party_id`),
  UNIQUE KEY `substitute_party_id` (`substitute_party_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table schedule_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `schedule_config`;

CREATE TABLE `schedule_config` (
  `task` varchar(30) NOT NULL DEFAULT '',
  `enable` varchar(1) DEFAULT NULL,
  `schedule_type` varchar(10) DEFAULT NULL,
  `schedule_week` varchar(15) DEFAULT NULL,
  `schedule_time` varchar(50) DEFAULT NULL,
  `schedule_period` varchar(10) DEFAULT NULL,
  `schedule_range` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`task`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table sign_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sign_config`;

CREATE TABLE `sign_config` (
  `sign_id` varchar(4) NOT NULL DEFAULT '',
  `sign_type` varchar(10) DEFAULT NULL,
  `pfx_path` varchar(100) DEFAULT NULL,
  `sign_password` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`sign_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table task_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_config`;

CREATE TABLE `task_config` (
  `categroy_type` varchar(5) NOT NULL DEFAULT '',
  `process_type` varchar(10) NOT NULL DEFAULT '',
  `task` varchar(15) NOT NULL DEFAULT '',
  `src_path` varchar(200) DEFAULT NULL,
  `target_path` varchar(200) DEFAULT NULL,
  `file_format` varchar(20) DEFAULT NULL,
  `version` varchar(5) DEFAULT NULL,
  `encoding` varchar(15) DEFAULT NULL,
  `trans_chinese_date` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`categroy_type`,`process_type`,`task`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table to_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `to_config`;

CREATE TABLE `to_config` (
  `party_id` varchar(10) NOT NULL DEFAULT '',
  `party_description` varchar(200) DEFAULT NULL,
  `routing_id` varchar(39) DEFAULT NULL,
  `routing_description` varchar(200) DEFAULT NULL,
  `from_party_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`party_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_message_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_message_log`;

CREATE TABLE `turnkey_message_log` (
  `seqno` varchar(8) NOT NULL DEFAULT '',
  `subseqno` varchar(5) NOT NULL DEFAULT '',
  `uuid` varchar(40) DEFAULT NULL,
  `message_type` varchar(10) DEFAULT NULL,
  `category_type` varchar(5) DEFAULT NULL,
  `process_type` varchar(10) DEFAULT NULL,
  `from_party_id` varchar(10) DEFAULT NULL,
  `to_party_id` varchar(10) DEFAULT NULL,
  `message_dts` varchar(17) DEFAULT NULL,
  `character_count` varchar(10) DEFAULT NULL,
  `status` varchar(5) DEFAULT NULL,
  `in_out_bound` varchar(1) DEFAULT NULL,
  `from_routing_id` varchar(39) DEFAULT NULL,
  `to_routing_id` varchar(39) DEFAULT NULL,
  `invoice_identifier` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`seqno`,`subseqno`),
  KEY `message_dts` (`message_dts`),
  KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_message_log_detail
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_message_log_detail`;

CREATE TABLE `turnkey_message_log_detail` (
  `seqno` varchar(8) NOT NULL DEFAULT '',
  `subseqno` varchar(5) NOT NULL DEFAULT '',
  `process_dts` varchar(17) DEFAULT '',
  `task` varchar(30) NOT NULL DEFAULT '',
  `status` varchar(5) DEFAULT NULL,
  `filename` varchar(300) DEFAULT NULL,
  `uuid` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`seqno`,`subseqno`,`task`),
  KEY `filename` (`filename`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_sequence
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_sequence`;

CREATE TABLE `turnkey_sequence` (
  `sequence` varchar(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_sysevent_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_sysevent_log`;

CREATE TABLE `turnkey_sysevent_log` (
  `eventdts` varchar(17) NOT NULL DEFAULT '',
  `party_id` varchar(10) DEFAULT NULL,
  `seqno` varchar(8) DEFAULT NULL,
  `subseqno` varchar(5) DEFAULT NULL,
  `errorcode` varchar(4) DEFAULT NULL,
  `uuid` varchar(40) DEFAULT '',
  `information1` varchar(100) DEFAULT NULL,
  `information2` varchar(100) DEFAULT NULL,
  `information3` varchar(100) DEFAULT NULL,
  `message1` varchar(100) DEFAULT NULL,
  `message2` varchar(100) DEFAULT NULL,
  `message3` varchar(100) DEFAULT NULL,
  `message4` varchar(100) DEFAULT NULL,
  `message5` varchar(100) DEFAULT NULL,
  `message6` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`eventdts`),
  KEY `seqno` (`seqno`,`subseqno`),
  KEY `uuid` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_transport_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_transport_config`;

CREATE TABLE `turnkey_transport_config` (
  `transport_id` varchar(10) NOT NULL DEFAULT '',
  `transport_password` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`transport_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table turnkey_user_profile
# ------------------------------------------------------------

DROP TABLE IF EXISTS `turnkey_user_profile`;

CREATE TABLE `turnkey_user_profile` (
  `user_id` varchar(10) NOT NULL DEFAULT '',
  `user_password` varchar(100) NOT NULL DEFAULT '',
  `user_role` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `turnkey_user_profile` WRITE;
/*!40000 ALTER TABLE `turnkey_user_profile` DISABLE KEYS */;

INSERT INTO `turnkey_user_profile` (`user_id`, `user_password`, `user_role`)
VALUES
	('ADMIN','ADMIN','0');

/*!40000 ALTER TABLE `turnkey_user_profile` ENABLE KEYS */;
UNLOCK TABLES;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;