/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('dynamic_content_lead_data'); $builder->addIdColumns(false, false); $builder->addDateAdded(true); $builder->createManyToOne('lead', 'Mautic\\LeadBundle\\Entity\\Lead')->inversedBy('id')->addJoinColumn('lead_id', 'id')->build(); $builder->createManyToOne('dynamicContent', 'DynamicContent')->inversedBy('id')->addJoinColumn('dynamic_content_id', 'id')->build(); $builder->createField('slot', 'text')->columnName('slot')->build(); }
/** * @param ORM\ClassMetadata $metadata */ public static function loadMetadata(ORM\ClassMetadata $metadata) { $builder = new ClassMetadataBuilder($metadata); $builder->setTable('companies_leads')->setCustomRepositoryClass('Mautic\\LeadBundle\\Entity\\CompanyLeadRepository'); $builder->createManyToOne('company', 'Company')->isPrimaryKey()->inversedBy('leads')->addJoinColumn('company_id', 'id', false, false, 'CASCADE')->build(); $builder->addLead(false, 'CASCADE', true); $builder->addDateAdded(); $builder->createField('manuallyRemoved', 'boolean')->columnName('manually_removed')->build(); $builder->createField('manuallyAdded', 'boolean')->columnName('manually_added')->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('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('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('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('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->setMappedSuperClass(); $builder->createField('isPublished', 'boolean')->columnName('is_published')->build(); $builder->addDateAdded(true); $builder->createField('createdBy', 'integer')->columnName('created_by')->nullable()->build(); $builder->createField('createdByUser', 'string')->columnName('created_by_user')->nullable()->build(); $builder->createField('dateModified', 'datetime')->columnName('date_modified')->nullable()->build(); $builder->createField('modifiedBy', 'integer')->columnName('modified_by')->nullable()->build(); $builder->createField('modifiedByUser', 'string')->columnName('modified_by_user')->nullable()->build(); $builder->createField('checkedOut', 'datetime')->columnName('checked_out')->nullable()->build(); $builder->createField('checkedOutBy', 'integer')->columnName('checked_out_by')->nullable()->build(); $builder->createField('checkedOutByUser', 'string')->columnName('checked_out_by_user')->nullable()->build(); }
/** * @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'); }