# Database construct

**URL:** https://forum.mautic.org/t/database-construct/7873
**Category:** General Discussion
**Created:** [March 10, 2017, 3:37am UTC](https://forum.mautic.org/t/database-construct/7873 "2017-03-10T03:37:59Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 10, 2017, 3:37am UTC](https://forum.mautic.org/t/database-construct/7873/1 "2017-03-10T03:37:59Z")

</div>

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

---

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 10, 2017, 3:37am UTC](https://forum.mautic.org/t/database-construct/7873/2 "2017-03-10T03:37:59Z")

</div>

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