orocrm / crm

     *

     * @param Schema $schema

     */

    protected function createOrocrmContactAdrToAdrTypeTable(Schema $schema)

    {

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

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->setPrimaryKey(['contact_address_id', 'type_name']);

        $table->addIndex(['contact_address_id'], 'IDX_3FBCDDC6320EF6E2', []);

        $table->addIndex(['type_name'], 'IDX_3FBCDDC6892CBB0E', []);

    }

    /**

     * Create orocrm_contact_email table

     *

     * @param Schema $schema

     */

    protected function createOrocrmContactToContactGrpTable(Schema $schema)

    {

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

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

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

        $table->setPrimaryKey(['contact_id', 'contact_group_id']);

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

        $table->addIndex(['contact_group_id'], 'IDX_885CCB12647145D0', []);

    }

    /**

     * Add orocrm_contact foreign keys.

     * @param Schema $schema

     * @param string $tableName

     */

    public static function orocrmContactAddressToAddressTypeTable(Schema $schema, $tableName = null)

    {

        /** Generate table orocrm_contact_address_to_address_type **/

        $table = $schema->createTable($tableName ?: 'orocrm_contact_address_to_address_type');

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->setPrimaryKey(['contact_address_id', 'type_name']);

        $table->addIndex(['contact_address_id'], 'IDX_3FBCDDC6320EF6E2', []);

        $table->addIndex(['type_name'], 'IDX_3FBCDDC6892CBB0E', []);

        /** End of generate table orocrm_contact_address_to_address_type **/

    }

    /**

     * Generate table orocrm_contact_email

     * @param Schema $schema

     * @param string $tableName

     */

    public static function orocrmContactToContactGroupTable(Schema $schema, $tableName = null)

    {

        /** Generate table orocrm_contact_to_contact_group **/

        $table = $schema->createTable($tableName ?: 'orocrm_contact_to_contact_group');

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

        $table->addColumn('contact_group_id', 'smallint', []);

        $table->setPrimaryKey(['contact_id', 'contact_group_id']);

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

        $table->addIndex(['contact_group_id'], 'IDX_885CCB12647145D0', []);

        /** End of generate table orocrm_contact_to_contact_group **/

    }

    /**

     * Generate foreign keys for table orocrm_contact

     *

     * @param Schema $schema

     */

    protected function createOrocrmContactusReqEmailsTable(Schema $schema)

    {

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

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

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

        $table->setPrimaryKey(['request_id', 'email_id']);

        $table->addIndex(['request_id'], 'IDX_E494F7AE427EB8A5', []);

        $table->addIndex(['email_id'], 'IDX_E494F7AEA832C1C9', []);

    }

    /**

     * Create orocrm_contactus_request table

     *

     * @param Schema $schema

     */

    public static function orocrmContactusRequestCallsTable(Schema $schema)

    {

        /** Generate table orocrm_contactus_request_calls **/

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

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

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

        $table->setPrimaryKey(['request_id', 'call_id']);

        $table->addIndex(['request_id'], 'IDX_6F7A50CE427EB8A5', []);

        $table->addIndex(['call_id'], 'IDX_6F7A50CE50A89B2C', []);

        /** End of generate table orocrm_contactus_request_calls **/

    }

    /**

     * Generate table orocrm_contactus_request_emails

     * @param Schema $schema

     * @param string $tableName

     */

    public static function orocrmContactusRequestEmailsTable(Schema $schema, $tableName = null)

    {

        /** Generate table orocrm_contactus_request_emails **/

        $table = $schema->createTable($tableName ?: 'orocrm_contactus_request_emails');

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

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

        $table->setPrimaryKey(['request_id', 'email_id']);

        $table->addIndex(['request_id'], 'IDX_4DEF4058427EB8A5', []);

        $table->addIndex(['email_id'], 'IDX_4DEF4058A832C1C9', []);

        /** End of generate table orocrm_contactus_request_emails **/

    }

    /**

     * Generate foreign keys for table orocrm_contactus_request

     *

     * @param Schema $schema

     */

    public static function orocrmMagentoCartCallsTable(Schema $schema)

    {

        /** Generate table orocrm_magento_cart_calls **/

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

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

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

        $table->setPrimaryKey(['cart_id', 'call_id']);

        $table->addIndex(['cart_id'], 'IDX_83A847751AD5CDBF', []);

        $table->addIndex(['call_id'], 'IDX_83A8477550A89B2C', []);

        /** End of generate table orocrm_magento_cart_calls **/

    }

    /**

     * Generate table orocrm_magento_cart_emails

     *

     * @param Schema $schema

     */

    public static function orocrmMagentoCartEmailsTable(Schema $schema)

    {

        /** Generate table orocrm_magento_cart_emails **/

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

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

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

        $table->setPrimaryKey(['cart_id', 'email_id']);

        $table->addIndex(['cart_id'], 'IDX_11B0F84B1AD5CDBF', []);

        $table->addIndex(['email_id'], 'IDX_11B0F84BA832C1C9', []);

        /** End of generate table orocrm_magento_cart_emails **/

    }

    /**

     * Generate table orocrm_magento_cart_item

     * @param Schema $schema

     * @param string $tableName

     */

    public static function orocrmMagentoCustomerAddressToAddressTypeTable(Schema $schema, $tableName = null)

    {

        /** Generate table orocrm_magento_customer_address_to_address_type **/

        $table = $schema->createTable($tableName ?: 'orocrm_magento_customer_address_to_address_type');

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->setPrimaryKey(['customer_address_id', 'type_name']);

        $table->addIndex(['customer_address_id'], 'IDX_65B2C97487EABF7', []);

        $table->addIndex(['type_name'], 'IDX_65B2C974892CBB0E', []);

        /** End of generate table orocrm_magento_customer_address_to_address_type **/

    }

    /**

     * Generate table orocrm_magento_customer_group

     *

     * @param Schema $schema

     */

    public static function orocrmMagentoOrderAddrTypeTable(Schema $schema)

    {

        /** Generate table orocrm_magento_order_addr_type **/

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

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->setPrimaryKey(['order_address_id', 'type_name']);

        $table->addIndex(['order_address_id'], 'IDX_7B667960466D5220', []);

        $table->addIndex(['type_name'], 'IDX_7B667960892CBB0E', []);

        /** End of generate table orocrm_magento_order_addr_type **/

    }

    /**

     * Generate table orocrm_magento_order_calls

     *

     * @param Schema $schema

     */

    public static function orocrmMagentoOrderCallsTable(Schema $schema)

    {

        /** Generate table orocrm_magento_order_calls **/

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

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

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

        $table->setPrimaryKey(['order_id', 'call_id']);

        $table->addIndex(['order_id'], 'IDX_A885A348D9F6D38', []);

        $table->addIndex(['call_id'], 'IDX_A885A3450A89B2C', []);

        /** End of generate table orocrm_magento_order_calls **/

    }

    /**

     * Generate table orocrm_magento_order_emails

     *

     * @param Schema $schema

     */

    public static function orocrmMagentoOrderEmailsTable(Schema $schema)

    {

        /** Generate table orocrm_magento_order_emails **/

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

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

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

        $table->setPrimaryKey(['order_id', 'email_id']);

        $table->addIndex(['order_id'], 'IDX_10E2A9508D9F6D38', []);

        $table->addIndex(['email_id'], 'IDX_10E2A950A832C1C9', []);

        /** End of generate table orocrm_magento_order_emails **/

    }

    /**

     * Generate table orocrm_magento_order_items

     * @param Schema $schema

     * @param string $tableName

     */

    public static function orocrmMagentoProductToWebsiteTable(Schema $schema, $tableName = null)

    {

        /** Generate table orocrm_magento_product_to_website **/

        $table = $schema->createTable($tableName ?: 'orocrm_magento_product_to_website');

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

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

        $table->setPrimaryKey(['product_id', 'website_id']);

        $table->addIndex(['product_id'], 'IDX_3A3EF4984584665A', []);

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

        /** End of generate table orocrm_magento_product_to_website **/

    }

    /**

     * Generate table orocrm_magento_region

     *

     * @param Schema $schema

     */

    protected function createOrocrmAccountToContactTable(Schema $schema)

    {

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

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

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

        $table->setPrimaryKey(['account_id', 'contact_id']);

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

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

    }

    /**

     * Add orocrm_account foreign keys.

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoOrderEmailsTable(Schema $schema)

    {

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

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

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

        $table->addIndex(['order_id'], 'IDX_10E2A9508D9F6D38', []);

        $table->addIndex(['email_id'], 'IDX_10E2A950A832C1C9', []);

        $table->setPrimaryKey(['order_id', 'email_id']);

    }

    /**

     * Create orocrm_magento_customer_group table

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoCustAddrTypeTable(Schema $schema)

    {

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

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->addIndex(['customer_address_id'], 'IDX_308A31F187EABF7', []);

        $table->addIndex(['type_name'], 'IDX_308A31F1892CBB0E', []);

        $table->setPrimaryKey(['customer_address_id', 'type_name']);

    }

    /**

     * Create orocrm_magento_order_address table

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoOrderAddrTypeTable(Schema $schema)

    {

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

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

        $table->addColumn('type_name', 'string', ['length' => 16]);

        $table->addIndex(['order_address_id'], 'IDX_E927A18F466D5220', []);

        $table->addIndex(['type_name'], 'IDX_E927A18F892CBB0E', []);

        $table->setPrimaryKey(['order_address_id', 'type_name']);

    }

    /**

     * Create orocrm_magento_product table

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoProdToWebsiteTable(Schema $schema)

    {

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

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

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

        $table->addIndex(['product_id'], 'IDX_9BB836554584665A', []);

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

        $table->setPrimaryKey(['product_id', 'website_id']);

    }

    /**

     * Create orocrm_magento_website table

     *

     * @param Schema $schema

     */

    protected function createOrocrmMagentoCartEmailsTable(Schema $schema)

    {

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

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

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

        $table->addIndex(['cart_id'], 'IDX_11B0F84B1AD5CDBF', []);

        $table->addIndex(['email_id'], 'IDX_11B0F84BA832C1C9', []);

        $table->setPrimaryKey(['cart_id', 'email_id']);

    }

    /**

     * Create orocrm_magento_store table