Issue:

Ephesoft Startup/Installation to EXTERNAL MySQL fails to CREATE regex pattern TABLE

Solution:

Manually create the table, by applying to your ephesoft database

USE database;
CREATE TABLE IF NOT EXISTS `regex_pattern` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_date` datetime NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `pattern` varchar(255) DEFAULT NULL,
  `regex_group_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK65E94B98702F4B10` (`regex_group_id`),
  CONSTRAINT `FK65E94B98702F4B10` FOREIGN KEY (`regex_group_id`) REFERENCES `regex_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

 

Was this article helpful to you?

Walter Lee