/**
* @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('ip_addresses')->setCustomRepositoryClass('Mautic\\CoreBundle\\Entity\\IpAddressRepository')->addIndex(['ip_address'], 'ip_search');
$builder->addId();
$builder->createField('ipAddress', 'string')->columnName('ip_address')->length(45)->build();
$builder->createField('ipDetails', 'array')->columnName('ip_details')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('monitor_post_count')->setCustomRepositoryClass('MauticPlugin\\MauticSocialBundle\\Entity\\PostCountRepository');
$builder->addId();
$builder->createManyToOne('monitor', 'Monitoring')->addJoinColumn('monitor_id', 'id', true, false, 'CASCADE')->build();
$builder->addNamedField('postDate', 'date', 'post_date');
$builder->addNamedField('postCount', 'integer', 'post_count');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('email_stats_devices')->setCustomRepositoryClass('Mautic\\EmailBundle\\Entity\\StatDeviceRepository')->addIndex(['date_opened'], 'date_opened_search');
$builder->addId();
$builder->createManyToOne('device', 'Mautic\\LeadBundle\\Entity\\LeadDevice')->addJoinColumn('device_id', 'id', true, false, 'CASCADE')->build();
$builder->createManyToOne('stat', 'Stat')->addJoinColumn('stat_id', 'id', true, false, 'CASCADE')->build();
$builder->addIpAddress(true);
$builder->createField('dateOpened', 'datetime')->columnName('date_opened')->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('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('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('lead_frequencyrules')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\FrequencyRuleRepository')->addIndex(['channel'], 'channel_frequency');
$builder->addId();
$builder->addLead(false, 'CASCADE', false, 'frequencyRules');
$builder->addDateAdded();
$builder->addNamedField('frequencyNumber', 'smallint', 'frequency_number');
$builder->createField('frequencyTime', 'string')->columnName('frequency_time')->length(25)->build();
$builder->createField('channel', 'string')->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('lead_stages_change_log')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\StagesChangeLogRepository');
$builder->addId();
$builder->addLead(false, 'CASCADE', false, 'stageChangeLog');
$builder->createField('eventName', 'string')->columnName('event_name')->build();
$builder->createField('actionName', 'string')->columnName('action_name')->build();
$builder->createManyToOne('stage', 'Mautic\\StageBundle\\Entity\\Stage')->inversedBy('stageChangeLog')->addJoinColumn('stage_id', 'id', true, false, 'CASCADE')->build();
$builder->addDateAdded();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_donotcontact')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\DoNotContactRepository')->addIndex(['reason'], 'dnc_reason_search');
$builder->addId();
$builder->addLead(true, 'CASCADE', false, 'doNotContact');
$builder->addDateAdded();
$builder->createField('reason', 'smallint')->build();
$builder->createField('channel', 'string')->build();
$builder->addNamedField('channelId', 'integer', 'channel_id', true);
$builder->createField('comments', 'text')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_companies_change_log')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\CompanyChangeLogRepository')->addIndex(['date_added'], 'company_date_added');
$builder->addId();
$builder->addLead(false, 'CASCADE', false, 'companyChangeLog');
$builder->createField('type', 'text')->length(50)->build();
$builder->createField('eventName', 'string')->columnName('event_name')->build();
$builder->createField('actionName', 'string')->columnName('action_name')->build();
$builder->createField('company', 'integer')->columnName('company_id')->build();
$builder->addDateAdded();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('webhook_logs')->setCustomRepositoryClass('Mautic\\WebhookBundle\\Entity\\LogRepository');
// id columns
$builder->addId();
// M:1 for webhook
$builder->createManyToOne('webhook', 'Webhook')->inversedBy('logs')->addJoinColumn('webhook_id', 'id', false, false, 'CASCADE')->build();
// status code
$builder->createField('statusCode', 'string')->columnName('status_code')->length(50)->build();
// date added
$builder->createField('dateAdded', 'datetime')->columnName('date_added')->nullable()->build();
}
/**
* @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');
$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('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('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('webhook_events')->setCustomRepositoryClass('Mautic\\WebhookBundle\\Entity\\EventRepository');
// id columns
$builder->addId();
// M:1 for webhook
$builder->createManyToOne('webhook', 'Webhook')->inversedBy('events')->addJoinColumn('webhook_id', 'id', false, false, 'CASCADE')->build();
// 1:M for queues
$builder->createOneToMany('queues', 'WebhookQueue')->mappedBy('event')->build();
// event type field
$builder->createField('event_type', 'string')->columnName('event_type')->length(50)->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('integration_entity')->setCustomRepositoryClass('Mautic\\PluginBundle\\Entity\\IntegrationEntityRepository')->addIndex(['integration', 'integration_entity', 'integration_entity_id'], 'integration_external_entity')->addIndex(['integration', 'internal_entity', 'internal_entity_id'], 'integration_internal_entity')->addIndex(['integration', 'internal_entity', 'integration_entity'], 'integration_entity_match')->addIndex(['integration', 'last_sync_date'], 'integration_last_sync_date');
$builder->addId();
$builder->addDateAdded();
$builder->addNullableField('integration', 'string');
$builder->createField('integrationEntity', 'string')->columnName('integration_entity')->nullable()->build();
$builder->createField('integrationEntityId', 'string')->columnName('integration_entity_id')->nullable()->build();
$builder->createField('internalEntity', 'string')->columnName('internal_entity')->nullable()->build();
$builder->createField('internalEntityId', 'integer')->columnName('internal_entity_id')->nullable()->build();
$builder->createField('lastSyncDate', 'datetime')->columnName('last_sync_date')->nullable()->build();
$builder->addNullableField('internal', 'array');
}
/**
* @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('webhook_queue')->setCustomRepositoryClass('Mautic\\WebhookBundle\\Entity\\WebhookQueueRepository');
$builder->addId();
// M:1 for webhook
$builder->createManyToOne('webhook', 'Webhook')->inversedBy('queues')->addJoinColumn('webhook_id', 'id', false, false, 'CASCADE')->build();
// date added
$builder->createField('dateAdded', 'datetime')->columnName('date_added')->nullable()->build();
// payload
$builder->createField('payload', 'text')->columnName('payload')->build();
// M:1 for event
$builder->createManyToOne('event', 'Event')->inversedBy('queues')->addJoinColumn('event_id', 'id', false, false, 'CASCADE')->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('sms_message_stats')->setCustomRepositoryClass('Mautic\\SmsBundle\\Entity\\StatRepository')->addIndex(['sms_id', 'lead_id'], 'stat_sms_search')->addIndex(['tracking_hash'], 'stat_sms_hash_search')->addIndex(['source', 'source_id'], 'stat_sms_source_search');
$builder->addId();
$builder->createManyToOne('sms', 'Sms')->inversedBy('stats')->addJoinColumn('sms_id', 'id', true, false, 'SET NULL')->build();
$builder->addLead(true, 'SET NULL');
$builder->createManyToOne('list', 'Mautic\\LeadBundle\\Entity\\LeadList')->addJoinColumn('list_id', 'id', true, false, 'SET NULL')->build();
$builder->addIpAddress(true);
$builder->createField('dateSent', 'datetime')->columnName('date_sent')->build();
$builder->createField('trackingHash', 'string')->columnName('tracking_hash')->nullable()->build();
$builder->createField('source', 'string')->nullable()->build();
$builder->createField('sourceId', 'integer')->columnName('source_id')->nullable()->build();
$builder->createField('tokens', 'array')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('dynamic_content_stats')->setCustomRepositoryClass('Mautic\\DynamicContentBundle\\Entity\\StatRepository')->addIndex(['dynamic_content_id', 'lead_id'], 'stat_dynamic_content_search')->addIndex(['source', 'source_id'], 'stat_dynamic_content_source_search');
$builder->addId();
$builder->createManyToOne('dynamicContent', 'DynamicContent')->inversedBy('stats')->addJoinColumn('dynamic_content_id', 'id', true, false, 'SET NULL')->build();
$builder->addLead(true, 'SET NULL');
$builder->createField('dateSent', 'datetime')->columnName('date_sent')->build();
$builder->createField('source', 'string')->nullable()->build();
$builder->createField('sourceId', 'integer')->columnName('source_id')->nullable()->build();
$builder->createField('tokens', 'array')->nullable()->build();
$builder->addNullableField('sentCount', 'integer', 'sent_count');
$builder->addNullableField('lastSent', 'datetime', 'last_sent');
$builder->addNullableField('sentDetails', 'array', 'sent_details');
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('audit_log')->setCustomRepositoryClass('Mautic\\CoreBundle\\Entity\\AuditLogRepository')->addIndex(['object', 'object_id'], 'object_search')->addIndex(['bundle', 'object', 'action', 'object_id'], 'timeline_search');
$builder->addId();
$builder->createField('userId', 'integer')->columnName('user_id')->build();
$builder->createField('userName', 'string')->columnName('user_name')->build();
$builder->createField('bundle', 'string')->length(50)->build();
$builder->createField('object', 'string')->length(50)->build();
$builder->createField('objectId', 'integer')->columnName('object_id')->build();
$builder->createField('action', 'string')->length(50)->build();
$builder->createField('details', 'array')->nullable()->build();
$builder->addDateAdded();
$builder->createField('ipAddress', 'string')->columnName('ip_address')->length(45)->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_devices')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\LeadDeviceRepository')->addIndex(['date_added'], 'date_added_search')->addIndex(['device'], 'device_search')->addIndex(['device_os_name'], 'device_os_name_search')->addIndex(['device_os_shortname'], 'device_os_shortname_search')->addIndex(['device_os_version'], 'device_os_version_search')->addIndex(['device_os_platform'], 'device_os_platform_search')->addIndex(['device_brand'], 'device_brand_search')->addIndex(['device_model'], 'device_model_search');
$builder->addId();
$builder->addLead(false, 'CASCADE');
$builder->addDateAdded();
$builder->createField('clientInfo', 'array')->columnName('client_info')->nullable()->build();
$builder->addNullableField('device', 'string');
$builder->createField('deviceOsName', 'string')->columnName('device_os_name')->nullable()->build();
$builder->createField('deviceOsShortName', 'string')->columnName('device_os_shortname')->nullable()->build();
$builder->createField('deviceOsVersion', 'string')->columnName('device_os_version')->nullable()->build();
$builder->createField('deviceOsPlatform', 'string')->columnName('device_os_platform')->nullable()->build();
$builder->createField('deviceBrand', 'string')->columnName('device_brand')->nullable()->build();
$builder->createField('deviceModel', 'string')->columnName('device_model')->nullable()->build();
}
/**
* @param ORM\ClassMetadata $metadata
*/
public static function loadMetadata(ORM\ClassMetadata $metadata)
{
$builder = new ClassMetadataBuilder($metadata);
$builder->setTable('lead_utmtags')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\UtmTagRepository');
$builder->addId();
$builder->addDateAdded();
$builder->addLead(false, 'CASCADE', false, 'utmtags');
$builder->addNullableField('query', 'array');
$builder->addNullableField('referer', 'string');
$builder->addNullableField('remoteHost', 'string', 'remote_host');
$builder->addNullableField('url', 'string');
$builder->addNullableField('userAgent', 'text', 'user_agent');
$builder->addNullableField('utmCampaign', 'string', 'utm_campaign');
$builder->addNullableField('utmContent', 'string', 'utm_content');
$builder->addNullableField('utmMedium', 'string', 'utm_medium');
$builder->addNullableField('utmSource', 'string', 'utm_source');
$builder->addNullableField('utmTerm', 'string', 'utm_term');
}
/**
* @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('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('users')->setCustomRepositoryClass('Mautic\\UserBundle\\Entity\\UserRepository');
$builder->addId();
$builder->createField('username', 'string')->length(255)->unique()->build();
$builder->createField('password', 'string')->length(64)->build();
$builder->createField('firstName', 'string')->columnName('first_name')->length(255)->build();
$builder->createField('lastName', 'string')->columnName('last_name')->length(255)->build();
$builder->createField('email', 'string')->length(255)->unique()->build();
$builder->createField('position', 'string')->length(255)->nullable()->build();
$builder->createManyToOne('role', 'Role')->inversedBy('users')->addJoinColumn('role_id', 'id', false)->build();
$builder->createField('timezone', 'string')->nullable()->build();
$builder->createField('locale', 'string')->nullable()->build();
$builder->createField('lastLogin', 'datetime')->columnName('last_login')->nullable()->build();
$builder->createField('lastActive', 'datetime')->columnName('last_active')->nullable()->build();
$builder->createField('onlineStatus', 'string')->columnName('online_status')->nullable()->build();
$builder->createField('preferences', 'array')->nullable()->build();
}
