orocrm / crm

     *

     * @param Schema $schema

     */

    protected function createOrocrmChannelLifetimeHistTable(Schema $schema)

    {

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

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

        $table->addColumn('status', 'boolean', ['notnull' => true]);

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

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

        $table->addColumn(

            'amount',

            'money',

            ['notnull' => true, 'precision' => 19, 'scale' => 4, 'comment' => '(DC2Type:money)']

        );

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

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

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

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

        $table->addIndex(['account_id', 'data_channel_id', 'status'], 'orocrm_chl_ltv_hist_idx');

        $table->addIndex(['status'], 'orocrm_chl_ltv_hist_status_idx');

    }

    /**

     * Add orocrm_channel_lifetime_hist foreign keys.

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoStoreTable(Schema $schema)

    {

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

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

        $table->addColumn('website_id', 'integer', []);

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

        $table->addColumn('store_code', 'string', ['length' => 32, 'precision' => 0]);

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

        $table->addColumn('origin_id', 'integer', ['notnull' => false, 'precision' => 0, 'unsigned' => true]);

        $table->addIndex(['website_id'], 'IDX_477738EA18F45C82', []);

        $table->addIndex(['channel_id'], 'IDX_477738EA72F5A1AA', []);

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

        $table->addUniqueIndex(['store_code', 'channel_id'], 'unq_code_channel_id');

    }

    /**

     * Create orocrm_magento_cart_status table