orocrm / crm

     *

     * @param Schema $schema

     */

    protected function createOrocrmChannelCustIdentityTable(Schema $schema)

    {

        $table = $schema->createTable('orocrm_channel_cust_identity');

        $table->addColumn('id', 'integer', ['autoincrement' => true]);

        $table->addColumn('data_channel_id', 'integer', ['notnull' => false]);

        $table->addColumn('account_id', 'integer', ['notnull' => false]);

        $table->addColumn('user_owner_id', 'integer', ['notnull' => false]);

        $table->addColumn('contact_id', 'integer', ['notnull' => false]);

        $table->addColumn('name', 'string', ['length' => 255]);

        $table->addColumn('createdAt', 'datetime', []);

        $table->addColumn('updatedAt', 'datetime', ['notnull' => false]);

        $table->setPrimaryKey(['id']);

        $table->addIndex(['account_id'], 'IDX_30F858859B6B5FBA', []);

        $table->addIndex(['contact_id'], 'IDX_30F85885E7A1254A', []);

        $table->addIndex(['user_owner_id'], 'IDX_30F858859EB185F9', []);

        $table->addIndex(['data_channel_id'], 'IDX_30F8588572F5A1AA', []);

    }

    /**

     * Add orocrm_channel foreign keys.

     *

     * @param Schema $schema

     */

    protected function createOrocrmChannelCustIdentityTable(Schema $schema)

    {

        $table = $schema->createTable('orocrm_channel_cust_identity');

        $table->addColumn('id', 'integer', ['autoincrement' => true]);

        $table->addColumn('contact_id', 'integer', ['notnull' => false]);

        $table->addColumn('account_id', 'integer', ['notnull' => false]);

        $table->addColumn('user_owner_id', 'integer', ['notnull' => false]);

        $table->addColumn('data_channel_id', 'integer', ['notnull' => false]);

        $table->addColumn('name', 'string', ['length' => 255]);

        $table->addColumn('createdAt', 'datetime', []);

        $table->addColumn('updatedAt', 'datetime', ['notnull' => false]);

        $table->setPrimaryKey(['id']);

        $table->addIndex(['account_id'], 'IDX_30F858859B6B5FBA', []);

        $table->addIndex(['contact_id'], 'IDX_30F85885E7A1254A', []);

        $table->addIndex(['user_owner_id'], 'IDX_30F858859EB185F9', []);

        $table->addIndex(['data_channel_id'], 'IDX_30F8588572F5A1AA', []);

    }

    /**

     * Create orocrm_channel_entity_name table

     *

     * @param Schema $schema

     */

    protected function createOrocrmSalesFunnelTable(Schema $schema)

    {

        $table = $schema->createTable('orocrm_sales_funnel');

        $table->addColumn('id', 'integer', ['autoincrement' => true]);

        $table->addColumn('user_owner_id', 'integer', ['notnull' => false]);

        $table->addColumn('opportunity_id', 'integer', ['notnull' => false]);

        $table->addColumn('lead_id', 'integer', ['notnull' => false]);

        $table->addColumn('data_channel_id', 'integer', ['notnull' => false]);

        $table->addColumn('startdate', 'date', []);

        $table->addColumn('createdat', 'datetime', []);

        $table->addColumn('updatedat', 'datetime', ['notnull' => false]);

        $table->addIndex(['opportunity_id'], 'idx_e20c73449a34590f', []);

        $table->addIndex(['lead_id'], 'idx_e20c734455458d', []);

        $table->addIndex(['startdate'], 'sales_start_idx', []);

        $table->setPrimaryKey(['id']);

        $table->addIndex(['user_owner_id'], 'idx_e20c73449eb185f9', []);

        $table->addIndex(['data_channel_id'], 'IDX_E20C7344BDC09B73', []);

    }

    /**

     * Create orocrm_sales_opport_status table