/** * Generate table orocrm_sales_lead * * @param Schema $schema * @param ExtendExtension $extendExtension */ public static function orocrmSalesLeadTable(Schema $schema, ExtendExtension $extendExtension) { /** Generate table orocrm_sales_lead **/ $table = $schema->createTable('orocrm_sales_lead'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('workflow_step_id', 'integer', ['notnull' => false]); $table->addColumn('workflow_item_id', 'integer', ['notnull' => false]); $table->addColumn('status_name', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('account_id', 'integer', ['notnull' => false]); $table->addColumn('user_owner_id', 'integer', ['notnull' => false]); $table->addColumn('contact_id', 'integer', ['notnull' => false]); $table->addColumn('address_id', 'integer', ['notnull' => false]); $table->addColumn('name', 'string', ['length' => 255]); $table->addColumn('name_prefix', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('first_name', 'string', ['length' => 255]); $table->addColumn('middle_name', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('last_name', 'string', ['length' => 255]); $table->addColumn('name_suffix', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('job_title', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('phone_number', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('email', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('company_name', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('website', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('number_of_employees', 'integer', ['notnull' => false]); $table->addColumn('industry', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('createdAt', 'datetime', []); $table->addColumn('updatedAt', 'datetime', ['notnull' => false]); $table->addColumn('notes', 'text', ['notnull' => false]); $extendExtension->addOptionSet($schema, $table, 'extend_source', ['extend' => ['set_expanded' => false]]); $table->setPrimaryKey(['id']); $table->addUniqueIndex(['workflow_item_id'], 'UNIQ_73DB46331023C4EE'); $table->addIndex(['status_name'], 'IDX_73DB46336625D392', []); $table->addIndex(['contact_id'], 'IDX_73DB4633E7A1254A', []); $table->addIndex(['account_id'], 'IDX_73DB46339B6B5FBA', []); $table->addIndex(['address_id'], 'IDX_73DB4633F5B7AF75', []); $table->addIndex(['user_owner_id'], 'IDX_73DB46339EB185F9', []); $table->addIndex(['workflow_step_id'], 'IDX_73DB463371FE882C', []); /** End of generate table orocrm_sales_lead **/ }