orocrm / crm

     *

     * @param Schema $schema

     */

    protected function createOrocrmChannelTable(Schema $schema)

    {

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

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

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

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

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

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

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

        $table->addColumn('data', Type::JSON_ARRAY, ['notnull' => false]);

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

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

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

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

        $table->addUniqueIndex(['data_source_id'], 'UNIQ_AEA90B921A935C57');

        $table->addIndex(['organization_owner_id'], 'IDX_AEA90B929124A35B', []);

        $table->addIndex(['name'], 'crm_channel_name_idx', []);

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

        $table->addIndex(['channel_type'], 'crm_channel_channel_type_idx', []);

    }

    /**

     * Create orocrm_channel_cust_identity table

     *

     * @param Schema $schema

     */

    public static function orocrmSalesFunnelTable(Schema $schema)

    {

        /** Generate table orocrm_sales_funnel **/

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

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

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

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

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

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

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

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

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

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

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

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

        $table->addUniqueIndex(['workflow_item_id'], 'UNIQ_E20C73441023C4EE');

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

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

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

        $table->addIndex(['workflow_step_id'], 'IDX_E20C734471FE882C', []);

        /** End of generate table orocrm_sales_funnel **/

    }

    /**

     * Generate foreign keys for table orocrm_sales_lead

     *

     * @param Schema $schema

     */

    public static function createOrocrmCaseCommentTranslationTable(Schema $schema)

    {

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

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

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

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

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

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

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

        $table->addColumn('message', 'text', []);

        $table->addColumn('public', 'boolean', ['default' => '0']);

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

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

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

        $table->addIndex(['case_id'], 'IDX_604C70FBCF10D4F5', []);

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

        $table->addIndex(['updated_by_id'], 'FK_604C70FB896DBBDE', []);

        $table->addIndex(['owner_id'], 'IDX_604C70FB7E3C61F9', []);

        $table->addIndex(['organization_id'], 'IDX_604C70FB32C8A3DE', []);

    }

    /**

     * Add orocrm_case foreign keys.