/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('channel_url_trackables')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\TrackableRepository')->addIndex(['channel', 'channel_id'], 'channel_url_trackable_search');
$builder->createManyToOne('redirect', 'Mautic\\PageBundle\\Entity\\Redirect')->addJoinColumn('redirect_id', 'id', true, false, 'CASCADE')->cascadePersist()->inversedBy('trackables')->isPrimaryKey()->build();
$builder->createField('channelId', 'integer')->columnName('channel_id')->isPrimaryKey()->build();
$builder->addField('channel', 'string');
$builder->addField('hits', 'integer');
$builder->addNamedField('uniqueHits', 'integer', 'unique_hits');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_lists')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\LeadListRepository');
$builder->addIdColumns();
$builder->addField('alias', 'string');
$builder->addField('filters', 'array');
$builder->createField('isGlobal', 'boolean')->columnName('is_global')->build();
$builder->createOneToMany('leads', 'ListLead')->setIndexBy('id')->mappedBy('list')->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('oauth1_access_tokens')->addIndex(array('token'), 'oauth1_access_token_search');
$builder->createField('id', 'integer')->isPrimaryKey()->generatedValue()->build();
$builder->createManyToOne('consumer', 'Consumer')->inversedBy('accessTokens')->addJoinColumn('consumer_id', 'id', false, false, 'CASCADE')->build();
$builder->createManyToOne('user', 'Mautic\\UserBundle\\Entity\\User')->addJoinColumn('user_id', 'id', false, false, 'CASCADE')->build();
$builder->addField('token', 'string');
$builder->addField('secret', 'string');
$builder->createField('expiresAt', 'bigint')->columnName('expires_at')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('page_redirects')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\RedirectRepository');
$builder->addId();
$builder->createField('redirectId', 'string')->columnName('redirect_id')->length(25)->build();
$builder->addField('url', 'text');
$builder->addField('hits', 'integer');
$builder->createField('uniqueHits', 'integer')->columnName('unique_hits')->build();
$builder->createOneToMany('trackables', 'Trackable')->mappedBy('redirect')->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('page_redirects')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\RedirectRepository');
$builder->addId();
$builder->createField('redirectId', 'string')->columnName('redirect_id')->length(25)->build();
$builder->addField('url', 'text');
$builder->addField('hits', 'integer');
$builder->createField('uniqueHits', 'integer')->columnName('unique_hits')->build();
$builder->createManyToOne('email', 'Mautic\\EmailBundle\\Entity\\Email')->addJoinColumn('email_id', 'id', true, false, 'SET NULL')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('reports')->setCustomRepositoryClass('Mautic\\ReportBundle\\Entity\\ReportRepository');
$builder->addIdColumns();
$builder->addField('system', 'boolean');
$builder->addField('source', 'string');
$builder->createField('columns', 'array')->nullable()->build();
$builder->createField('filters', 'array')->nullable()->build();
$builder->createField('tableOrder', 'array')->columnName('table_order')->nullable()->build();
$builder->createField('graphs', 'array')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('email_donotemail')->setCustomRepositoryClass('Mautic\\CoreBundle\\Entity\\NotificationRepository')->addIndex(array('address'), 'dnc_search');
$builder->addId();
$builder->createManyToOne('email', 'Email')->addJoinColumn('email_id', 'id', true, false, 'SET NULL')->build();
$builder->createField('emailAddress', 'string')->columnName('address')->build();
$builder->addLead(true, 'CASCADE', false, 'doNotEmail');
$builder->addDateAdded();
$builder->addField('unsubscribed', 'boolean');
$builder->addField('bounced', 'boolean');
$builder->addNullableField('manual', 'boolean');
$builder->createField('comments', 'text')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('oauth1_nonces')->setCustomRepositoryClass('Mautic\\ApiBundle\\Entity\\oAuth1\\NonceRepository');
$builder->createField('nonce', 'string')->isPrimaryKey()->build();
$builder->addField('timestamp', 'string');
}
/**
* @param ClassMetadata $metadata
*/
public static function loadMetadata(ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_tags')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\TagRepository')->addIndex(array('tag'), 'lead_tag_search');
$builder->addId();
$builder->addField('tag', 'string');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('categories')->setCustomRepositoryClass('Mautic\\CategoryBundle\\Entity\\CategoryRepository')->addIndex(['alias'], 'category_alias_search');
$builder->addIdColumns('title');
$builder->addField('alias', 'string');
$builder->createField('color', 'string')->nullable()->length(7)->build();
$builder->createField('bundle', 'string')->length(50)->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('form_actions')->setCustomRepositoryClass('Mautic\\FormBundle\\Entity\\ActionRepository')->addIndex(array('type'), 'form_action_type_search');
$builder->addIdColumns();
$builder->createField('type', 'string')->length(50)->build();
$builder->createField('order', 'integer')->columnName('action_order')->build();
$builder->addField('properties', 'array');
$builder->createManyToOne('form', 'Form')->inversedBy('actions')->addJoinColumn('form_id', 'id', false, false, 'CASCADE')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('permissions')->setCustomRepositoryClass('Mautic\\UserBundle\\Entity\\PermissionRepository')->addUniqueConstraint(['bundle', 'name', 'role_id'], 'unique_perm');
$builder->addId();
$builder->createField('bundle', 'string')->length(50)->build();
$builder->createField('name', 'string')->length(50)->build();
$builder->createManyToOne('role', 'Role')->inversedBy('permissions')->addJoinColumn('role_id', 'id', false, false, 'CASCADE')->build();
$builder->addField('bitwise', 'integer');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('oauth1_consumers')->setCustomRepositoryClass('Mautic\\ApiBundle\\Entity\\oAuth1\\ConsumerRepository')->addLifecycleEvent('createConsumerKeys', 'prePersist')->addIndex(array('consumer_key'), 'consumer_search');
$builder->addIdColumns('name', false);
$builder->createField('consumerKey', 'string')->columnName('consumer_key')->build();
$builder->createField('consumerSecret', 'string')->columnName('consumer_secret')->build();
$builder->addField('callback', 'string');
$builder->createOneToMany('accessTokens', 'AccessToken')->setIndexBy('id')->mappedBy('consumer')->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_notes')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\LeadNoteRepository');
$builder->addId();
$builder->addLead(false, 'CASCADE', false, 'notes');
$builder->addField('text', 'text');
$builder->createField('type', 'string')->length(50)->nullable()->build();
$builder->createField('dateTime', 'datetime')->columnName('date_time')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('focus_stats')->setCustomRepositoryClass('MauticPlugin\\MauticFocusBundle\\Entity\\StatRepository')->addIndex(['type'], 'focus_type')->addIndex(['type', 'type_id'], 'focus_type_id')->addIndex(['date_added'], 'focus_date_added');
$builder->addId();
$builder->createManyToOne('focus', 'Focus')->addJoinColumn('focus_id', 'id', false, false, 'CASCADE')->build();
$builder->addField('type', 'string');
$builder->addNamedField('typeId', 'integer', 'type_id', true);
$builder->addNamedField('dateAdded', 'datetime', 'date_added');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('oauth2_clients')->setCustomRepositoryClass('Mautic\\ApiBundle\\Entity\\oAuth2\\ClientRepository')->addIndex(array('random_id'), 'client_id_search');
$builder->addIdColumns('name', false);
$builder->createManyToMany('users', 'Mautic\\UserBundle\\Entity\\User')->setJoinTable('oauth2_user_client_xref')->addInverseJoinColumn('user_id', 'id', false, false, 'CASCADE')->addJoinColumn('client_id', 'id', false, false, 'CASCADE')->fetchExtraLazy()->build();
$builder->createField('randomId', 'string')->columnName('random_id')->build();
$builder->addField('secret', 'string');
$builder->createField('redirectUris', 'array')->columnName('redirect_uris')->build();
$builder->createField('allowedGrantTypes', 'array')->columnName('allowed_grant_types')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('point_trigger_events')->setCustomRepositoryClass('Mautic\\PointBundle\\Entity\\TriggerEventRepository')->addIndex(['type'], 'trigger_type_search');
$builder->addIdColumns();
$builder->createField('type', 'string')->length(50)->build();
$builder->createField('order', 'integer')->columnName('action_order')->build();
$builder->addField('properties', 'array');
$builder->createManyToOne('trigger', 'Trigger')->inversedBy('events')->addJoinColumn('trigger_id', 'id', false, false, 'CASCADE')->build();
$builder->createOneToMany('log', 'LeadTriggerLog')->mappedBy('event')->cascadePersist()->cascadeRemove()->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('point_triggers')->setCustomRepositoryClass('Mautic\\PointBundle\\Entity\\TriggerRepository');
$builder->addIdColumns();
$builder->addPublishDates();
$builder->addField('points', 'integer');
$builder->createField('color', 'string')->length(7)->build();
$builder->createField('triggerExistingLeads', 'boolean')->columnName('trigger_existing_leads')->build();
$builder->addCategory();
$builder->createOneToMany('events', 'TriggerEvent')->setIndexBy('id')->setOrderBy(['order' => 'ASC'])->mappedBy('trigger')->cascadeAll()->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('plugin_integration_settings')->setCustomRepositoryClass('Mautic\\PluginBundle\\Entity\\IntegrationRepository');
$builder->createField('id', 'integer')->isPrimaryKey()->generatedValue()->build();
$builder->createManyToOne('plugin', 'Plugin')->inversedBy('integrations')->addJoinColumn('plugin_id', 'id', true, false, 'CASCADE')->build();
$builder->addField('name', 'string');
$builder->createField('isPublished', 'boolean')->columnName('is_published')->build();
$builder->createField('supportedFeatures', 'array')->columnName('supported_features')->nullable()->build();
$builder->createField('apiKeys', 'array')->columnName('api_keys')->build();
$builder->createField('featureSettings', 'array')->columnName('feature_settings')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('monitoring')->setCustomRepositoryClass('MauticPlugin\\MauticSocialBundle\\Entity\\MonitoringRepository')->addLifecycleEvent('cleanMonitorData', 'preUpdate')->addLifecycleEvent('cleanMonitorData', 'prePersist');
$builder->addCategory();
$builder->addIdColumns('title');
$builder->addNullableField('lists', 'array');
$builder->addNamedField('networkType', 'string', 'network_type', true);
$builder->addField('revision', 'integer');
$builder->addNullableField('stats', 'array');
$builder->addNullableField('properties', 'array');
$builder->addPublishDates();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_points_change_log')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\PointsChangeLogRepository')->addIndex(['date_added'], 'point_date_added');
$builder->addId();
$builder->addLead(false, 'CASCADE', false, 'pointsChangeLog');
$builder->addIpAddress();
$builder->createField('type', 'text')->length(50)->build();
$builder->createField('eventName', 'string')->columnName('event_name')->build();
$builder->createField('actionName', 'string')->columnName('action_name')->build();
$builder->addField('delta', 'integer');
$builder->addDateAdded();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('notifications')->setCustomRepositoryClass('Mautic\\CoreBundle\\Entity\\NotificationRepository')->addIndex(['is_read'], 'notification_read_status')->addIndex(['type'], 'notification_type')->addIndex(['is_read', 'user_id'], 'notification_user_read_status');
$builder->addId();
$builder->createManyToOne('user', 'Mautic\\UserBundle\\Entity\\User')->addJoinColumn('user_id', 'id', false, false, 'CASCADE')->build();
$builder->createField('type', 'string')->nullable()->length(25)->build();
$builder->createField('header', 'string')->nullable()->build();
$builder->addField('message', 'text');
$builder->addDateAdded();
$builder->createField('iconClass', 'string')->columnName('icon_class')->nullable()->build();
$builder->createField('isRead', 'boolean')->columnName('is_read')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('form_submissions')->setCustomRepositoryClass('Mautic\\FormBundle\\Entity\\SubmissionRepository')->addIndex(['tracking_id'], 'form_submission_tracking_search')->addIndex(['date_submitted'], 'form_date_submitted');
$builder->addId();
$builder->createManyToOne('form', 'Form')->inversedBy('submissions')->addJoinColumn('form_id', 'id', false, false, 'CASCADE')->build();
$builder->addIpAddress();
$builder->addLead(true, 'SET NULL');
$builder->createField('trackingId', 'string')->columnName('tracking_id')->nullable()->build();
$builder->createField('dateSubmitted', 'datetime')->columnName('date_submitted')->build();
$builder->addField('referer', 'text');
$builder->createManyToOne('page', 'Mautic\\PageBundle\\Entity\\Page')->addJoinColumn('page_id', 'id', true, false, 'SET NULL')->fetchExtraLazy()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('asset_downloads')->setCustomRepositoryClass('Mautic\\AssetBundle\\Entity\\DownloadRepository')->addIndex(['tracking_id'], 'download_tracking_search')->addIndex(['source', 'source_id'], 'download_source_search')->addIndex(['date_download'], 'asset_date_download');
$builder->createField('id', 'integer')->isPrimaryKey()->generatedValue()->build();
$builder->createField('dateDownload', 'datetime')->columnName('date_download')->build();
$builder->createManyToOne('asset', 'Asset')->addJoinColumn('asset_id', 'id', true, false, 'CASCADE')->build();
$builder->addIpAddress();
$builder->addLead(true, 'SET NULL');
$builder->addField('code', 'integer');
$builder->createField('referer', 'string')->nullable()->build();
$builder->createField('trackingId', 'string')->columnName('tracking_id')->build();
$builder->createField('source', 'string')->nullable()->build();
$builder->createField('sourceId', 'integer')->columnName('source_id')->nullable()->build();
$builder->createManyToOne('email', 'Mautic\\EmailBundle\\Entity\\Email')->addJoinColumn('email_id', 'id', true, false, 'SET NULL')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_fields')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\LeadFieldRepository');
$builder->addId();
$builder->addField('label', 'string');
$builder->addField('alias', 'string');
$builder->createField('type', 'string')->length(50)->build();
$builder->createField('group', 'string')->columnName('field_group')->nullable()->build();
$builder->createField('defaultValue', 'string')->columnName('default_value')->nullable()->build();
$builder->createField('isRequired', 'boolean')->columnName('is_required')->build();
$builder->createField('isFixed', 'boolean')->columnName('is_fixed')->build();
$builder->createField('isVisible', 'boolean')->columnName('is_visible')->build();
$builder->createField('isShortVisible', 'boolean')->columnName('is_short_visible')->build();
$builder->createField('isListable', 'boolean')->columnName('is_listable')->build();
$builder->createField('isPubliclyUpdatable', 'boolean')->columnName('is_publicly_updatable')->build();
$builder->addNullableField('isUniqueIdentifer', 'boolean', 'is_unique_identifer');
$builder->createField('order', 'integer')->columnName('field_order')->nullable()->build();
$builder->createField('properties', 'array')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('form_fields')->setCustomRepositoryClass('Mautic\\FormBundle\\Entity\\FieldRepository')->addIndex(array('type'), 'form_field_type_search');
$builder->addId();
$builder->addField('label', 'text');
$builder->createField('showLabel', 'boolean')->columnName('show_label')->nullable()->build();
$builder->addField('alias', 'string');
$builder->addField('type', 'string');
$builder->createField('isCustom', 'boolean')->columnName('is_custom')->build();
$builder->createField('customParameters', 'array')->columnName('custom_parameters')->nullable()->build();
$builder->createField('defaultValue', 'text')->columnName('default_value')->nullable()->build();
$builder->createField('isRequired', 'boolean')->columnName('is_required')->build();
$builder->createField('validationMessage', 'text')->columnName('validation_message')->nullable()->build();
$builder->createField('helpMessage', 'text')->columnName('help_message')->nullable()->build();
$builder->createField('order', 'integer')->columnName('field_order')->nullable()->build();
$builder->createField('properties', 'array')->nullable()->build();
$builder->createManyToOne('form', 'Form')->inversedBy('fields')->addJoinColumn('form_id', 'id', false, false, 'CASCADE')->build();
$builder->addNullableField('labelAttributes', 'string', 'label_attr');
$builder->addNullableField('inputAttributes', 'string', 'input_attr');
$builder->addNullableField('containerAttributes', 'string', 'container_attr');
$builder->addNullableField('leadField', 'string', 'lead_field');
$builder->addNullableField('saveResult', 'boolean', 'save_result');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('assets')->setCustomRepositoryClass('Mautic\\AssetBundle\\Entity\\AssetRepository')->addIndex(array('alias'), 'asset_alias_search');
$builder->addIdColumns('title');
$builder->addField('alias', 'string');
$builder->createField('storageLocation', 'string')->columnName('storage_location')->nullable()->build();
$builder->createField('path', 'string')->nullable()->build();
$builder->createField('remotePath', 'string')->columnName('remote_path')->nullable()->build();
$builder->createField('originalFileName', 'string')->columnName('original_file_name')->nullable()->build();
$builder->createField('language', 'string')->columnName('lang')->build();
$builder->addPublishDates();
$builder->createField('downloadCount', 'integer')->columnName('download_count')->build();
$builder->createField('uniqueDownloadCount', 'integer')->columnName('unique_download_count')->build();
$builder->addField('revision', 'integer');
$builder->addCategory();
$builder->createField('extension', 'string')->nullable()->build();
$builder->createField('mime', 'string')->nullable()->build();
$builder->createField('size', 'integer')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('points')->setCustomRepositoryClass('Mautic\\PointBundle\\Entity\\PointRepository')->addIndex(array('type'), 'point_type_search');
$builder->addIdColumns();
$builder->createField('type', 'string')->length(50)->build();
$builder->addPublishDates();
$builder->addField('delta', 'integer');
$builder->addField('properties', 'array');
$builder->createOneToMany('log', 'LeadPointLog')->mappedBy('point')->cascadePersist()->cascadeRemove()->fetchExtraLazy()->build();
$builder->addCategory();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('page_hits')->setCustomRepositoryClass('Mautic\\PageBundle\\Entity\\HitRepository')->addIndex(array('ip_id'), 'page_hit_ip_search')->addIndex(array('tracking_id'), 'page_hit_tracking_search')->addIndex(array('code'), 'page_hit_code_search')->addIndex(array('source', 'source_id'), 'page_hit_source_search');
$builder->addId();
$builder->createField('dateHit', 'datetime')->columnName('date_hit')->build();
$builder->createField('dateLeft', 'datetime')->columnName('date_left')->nullable()->build();
$builder->createManyToOne('page', 'Page')->addJoinColumn('page_id', 'id', true, false, 'SET NULL')->build();
$builder->createManyToOne('redirect', 'Redirect')->addJoinColumn('redirect_id', 'id', true, false, 'SET NULL')->build();
$builder->createManyToOne('email', 'Mautic\\EmailBundle\\Entity\\Email')->addJoinColumn('email_id', 'id', true, false, 'SET NULL')->build();
$builder->addLead(true, 'SET NULL');
$builder->addIpAddress();
$builder->createField('country', 'string')->nullable()->build();
$builder->createField('region', 'string')->nullable()->build();
$builder->createField('city', 'string')->nullable()->build();
$builder->createField('isp', 'string')->nullable()->build();
$builder->createField('organization', 'string')->nullable()->build();
$builder->addField('code', 'integer');
$builder->createField('referer', 'text')->nullable()->build();
$builder->createField('url', 'text')->nullable()->build();
$builder->createField('urlTitle', 'string')->columnName('url_title')->nullable()->build();
$builder->createField('userAgent', 'text')->columnName('user_agent')->nullable()->build();
$builder->createField('remoteHost', 'string')->columnName('remote_host')->nullable()->build();
$builder->createField('pageLanguage', 'string')->columnName('page_language')->nullable()->build();
$builder->createField('browserLanguages', 'array')->columnName('browser_languages')->nullable()->build();
$builder->createField('trackingId', 'string')->columnName('tracking_id')->build();
$builder->createField('source', 'string')->nullable()->build();
$builder->createField('sourceId', 'integer')->columnName('source_id')->nullable()->build();
$builder->addNullableField('query', 'array');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('campaign_events')->setCustomRepositoryClass('Mautic\\CampaignBundle\\Entity\\EventRepository')->addIndex(array('type', 'event_type'), 'campaign_event_type_search');
$builder->addIdColumns();
$builder->createField('type', 'string')->length(50)->build();
$builder->createField('eventType', 'string')->columnName('event_type')->length(50)->build();
$builder->createField('order', 'integer')->columnName('event_order')->build();
$builder->addField('properties', 'array');
$builder->createField('triggerDate', 'datetime')->columnName('trigger_date')->nullable()->build();
$builder->createField('triggerInterval', 'integer')->columnName('trigger_interval')->nullable()->build();
$builder->createField('triggerIntervalUnit', 'string')->columnName('trigger_interval_unit')->length(1)->nullable()->build();
$builder->createField('triggerMode', 'string')->columnName('trigger_mode')->length(10)->nullable()->build();
$builder->createManyToOne('campaign', 'Campaign')->inversedBy('events')->addJoinColumn('campaign_id', 'id', false, false, 'CASCADE')->build();
$builder->createOneToMany('children', 'Event')->setIndexBy('id')->setOrderBy(array('order' => 'ASC'))->mappedBy('parent')->build();
$builder->createManyToOne('parent', 'Event')->inversedBy('children')->cascadePersist()->addJoinColumn('parent_id', 'id')->build();
$builder->createField('decisionPath', 'string')->columnName('decision_path')->nullable()->build();
$builder->createField('tempId', 'string')->columnName('temp_id')->nullable()->build();
$builder->createOneToMany('log', 'LeadEventLog')->mappedBy('event')->cascadePersist()->cascadeRemove()->fetchExtraLazy()->build();
}
