Mautic Community Forums

Database construct

Could someone help with a Sql dump of _campaign_events table? I have nothing to compare with as I have only one instance of Mautic and there appears to be a problem with my database in this area as it will not upgrade. If I could see another instance I may be able to identify where the problem lies eg a missing column.

Mine is as below:

Code:
CREATE TABLE IF NOT EXISTS `mauyu_campaign_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `parent_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` longtext COLLATE utf8_unicode_ci, `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `event_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `event_order` int(11) NOT NULL, `properties` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `trigger_date` datetime DEFAULT NULL, `trigger_interval` int(11) DEFAULT NULL, `trigger_interval_unit` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL, `trigger_mode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `decision_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `temp_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_25BBE925F639F774` (`campaign_id`), KEY `IDX_25BBE925727ACA70` (`parent_id`), KEY `mauyu_campaign_event_type_search` (`type`,`event_type`), KEY `mauyu_event_type` (`event_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Thanks

Could someone help with a Sql dump of _campaign_events table? I have nothing to compare with as I have only one instance of Mautic and there appears to be a problem with my database in this area as it will not upgrade. If I could see another instance I may be able to identify where the problem lies eg a missing column.
Mine is as below:

[code]CREATE TABLE IF NOT EXISTS mauyu_campaign_events (
id int(11) NOT NULL AUTO_INCREMENT,
campaign_id int(11) NOT NULL,
parent_id int(11) DEFAULT NULL,
name varchar(255) COLLATE utf8_unicode_ci NOT NULL,
description longtext COLLATE utf8_unicode_ci,
type varchar(50) COLLATE utf8_unicode_ci NOT NULL,
event_type varchar(50) COLLATE utf8_unicode_ci NOT NULL,
event_order int(11) NOT NULL,
properties longtext COLLATE utf8_unicode_ci NOT NULL COMMENT ‘(DC2Type:array)’,
trigger_date datetime DEFAULT NULL,
trigger_interval int(11) DEFAULT NULL,
trigger_interval_unit varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
trigger_mode varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
decision_path varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
temp_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id),
KEY IDX_25BBE925F639F774 (campaign_id),
KEY IDX_25BBE925727ACA70 (parent_id),
KEY mauyu_campaign_event_type_search (type,event_type),
KEY mauyu_event_type (event_type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

[/code]

Thanks