| @@ 797-838 (lines=42) @@ | ||
| 794 | * |
|
| 795 | * @param Schema $schema |
|
| 796 | */ |
|
| 797 | public static function orocrmMagentoCustomerForeignKeys(Schema $schema) |
|
| 798 | { |
|
| 799 | /** Generate foreign keys for table orocrm_magento_customer **/ |
|
| 800 | $table = $schema->getTable('orocrm_magento_customer'); |
|
| 801 | $table->addForeignKeyConstraint( |
|
| 802 | $schema->getTable('oro_integration_channel'), |
|
| 803 | ['channel_id'], |
|
| 804 | ['id'], |
|
| 805 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 806 | ); |
|
| 807 | $table->addForeignKeyConstraint( |
|
| 808 | $schema->getTable('orocrm_magento_website'), |
|
| 809 | ['website_id'], |
|
| 810 | ['id'], |
|
| 811 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 812 | ); |
|
| 813 | $table->addForeignKeyConstraint( |
|
| 814 | $schema->getTable('orocrm_account'), |
|
| 815 | ['account_id'], |
|
| 816 | ['id'], |
|
| 817 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 818 | ); |
|
| 819 | $table->addForeignKeyConstraint( |
|
| 820 | $schema->getTable('orocrm_magento_store'), |
|
| 821 | ['store_id'], |
|
| 822 | ['id'], |
|
| 823 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 824 | ); |
|
| 825 | $table->addForeignKeyConstraint( |
|
| 826 | $schema->getTable('orocrm_magento_customer_group'), |
|
| 827 | ['customer_group_id'], |
|
| 828 | ['id'], |
|
| 829 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 830 | ); |
|
| 831 | $table->addForeignKeyConstraint( |
|
| 832 | $schema->getTable('orocrm_contact'), |
|
| 833 | ['contact_id'], |
|
| 834 | ['id'], |
|
| 835 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 836 | ); |
|
| 837 | /** End of generate foreign keys for table orocrm_magento_customer **/ |
|
| 838 | } |
|
| 839 | ||
| 840 | /** |
|
| 841 | * Generate foreign keys for table orocrm_magento_customer_address |
|
| @@ 923-964 (lines=42) @@ | ||
| 920 | * |
|
| 921 | * @param Schema $schema |
|
| 922 | */ |
|
| 923 | public static function orocrmMagentoOrderForeignKeys(Schema $schema) |
|
| 924 | { |
|
| 925 | /** Generate foreign keys for table orocrm_magento_order **/ |
|
| 926 | $table = $schema->getTable('orocrm_magento_order'); |
|
| 927 | $table->addForeignKeyConstraint( |
|
| 928 | $schema->getTable('oro_integration_channel'), |
|
| 929 | ['channel_id'], |
|
| 930 | ['id'], |
|
| 931 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 932 | ); |
|
| 933 | $table->addForeignKeyConstraint( |
|
| 934 | $schema->getTable('oro_workflow_item'), |
|
| 935 | ['workflow_item_id'], |
|
| 936 | ['id'], |
|
| 937 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 938 | ); |
|
| 939 | $table->addForeignKeyConstraint( |
|
| 940 | $schema->getTable('orocrm_magento_cart'), |
|
| 941 | ['cart_id'], |
|
| 942 | ['id'], |
|
| 943 | ['onDelete' => null, 'onUpdate' => null] |
|
| 944 | ); |
|
| 945 | $table->addForeignKeyConstraint( |
|
| 946 | $schema->getTable('oro_workflow_step'), |
|
| 947 | ['workflow_step_id'], |
|
| 948 | ['id'], |
|
| 949 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 950 | ); |
|
| 951 | $table->addForeignKeyConstraint( |
|
| 952 | $schema->getTable('orocrm_magento_customer'), |
|
| 953 | ['customer_id'], |
|
| 954 | ['id'], |
|
| 955 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 956 | ); |
|
| 957 | $table->addForeignKeyConstraint( |
|
| 958 | $schema->getTable('orocrm_magento_store'), |
|
| 959 | ['store_id'], |
|
| 960 | ['id'], |
|
| 961 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 962 | ); |
|
| 963 | /** End of generate foreign keys for table orocrm_magento_order **/ |
|
| 964 | } |
|
| 965 | ||
| 966 | /** |
|
| 967 | * Generate foreign keys for table orocrm_magento_order_address |
|
| @@ 81-120 (lines=40) @@ | ||
| 78 | * |
|
| 79 | * @param Schema $schema |
|
| 80 | */ |
|
| 81 | protected function addOrocrmMagentoNewslSubscrForeignKeys(Schema $schema) |
|
| 82 | { |
|
| 83 | $table = $schema->getTable('orocrm_magento_newsl_subscr'); |
|
| 84 | $table->addForeignKeyConstraint( |
|
| 85 | $schema->getTable('oro_organization'), |
|
| 86 | ['organization_id'], |
|
| 87 | ['id'], |
|
| 88 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 89 | ); |
|
| 90 | $table->addForeignKeyConstraint( |
|
| 91 | $schema->getTable('oro_user'), |
|
| 92 | ['owner_id'], |
|
| 93 | ['id'], |
|
| 94 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 95 | ); |
|
| 96 | $table->addForeignKeyConstraint( |
|
| 97 | $schema->getTable('orocrm_magento_customer'), |
|
| 98 | ['customer_id'], |
|
| 99 | ['id'], |
|
| 100 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 101 | ); |
|
| 102 | $table->addForeignKeyConstraint( |
|
| 103 | $schema->getTable('orocrm_magento_store'), |
|
| 104 | ['store_id'], |
|
| 105 | ['id'], |
|
| 106 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 107 | ); |
|
| 108 | $table->addForeignKeyConstraint( |
|
| 109 | $schema->getTable('oro_integration_channel'), |
|
| 110 | ['channel_id'], |
|
| 111 | ['id'], |
|
| 112 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 113 | ); |
|
| 114 | $table->addForeignKeyConstraint( |
|
| 115 | $schema->getTable('orocrm_channel'), |
|
| 116 | ['data_channel_id'], |
|
| 117 | ['id'], |
|
| 118 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 119 | ); |
|
| 120 | } |
|
| 121 | } |
|
| 122 | ||
| @@ 123-162 (lines=40) @@ | ||
| 120 | * |
|
| 121 | * @param Schema $schema |
|
| 122 | */ |
|
| 123 | protected function addOrocrmSalesB2bCustomerForeignKeys(Schema $schema) |
|
| 124 | { |
|
| 125 | $table = $schema->getTable('orocrm_sales_b2bcustomer'); |
|
| 126 | $table->addForeignKeyConstraint( |
|
| 127 | $schema->getTable('oro_user'), |
|
| 128 | ['user_owner_id'], |
|
| 129 | ['id'], |
|
| 130 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 131 | ); |
|
| 132 | $table->addForeignKeyConstraint( |
|
| 133 | $schema->getTable('oro_address'), |
|
| 134 | ['shipping_address_id'], |
|
| 135 | ['id'], |
|
| 136 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 137 | ); |
|
| 138 | $table->addForeignKeyConstraint( |
|
| 139 | $schema->getTable('orocrm_channel'), |
|
| 140 | ['data_channel_id'], |
|
| 141 | ['id'], |
|
| 142 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 143 | ); |
|
| 144 | $table->addForeignKeyConstraint( |
|
| 145 | $schema->getTable('oro_address'), |
|
| 146 | ['billing_address_id'], |
|
| 147 | ['id'], |
|
| 148 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 149 | ); |
|
| 150 | $table->addForeignKeyConstraint( |
|
| 151 | $schema->getTable('orocrm_account'), |
|
| 152 | ['account_id'], |
|
| 153 | ['id'], |
|
| 154 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 155 | ); |
|
| 156 | $table->addForeignKeyConstraint( |
|
| 157 | $schema->getTable('orocrm_contact'), |
|
| 158 | ['contact_id'], |
|
| 159 | ['id'], |
|
| 160 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 161 | ); |
|
| 162 | } |
|
| 163 | } |
|
| 164 | ||
| @@ 1397-1436 (lines=40) @@ | ||
| 1394 | * |
|
| 1395 | * @param Schema $schema |
|
| 1396 | */ |
|
| 1397 | protected function addOrocrmMagentoNewslSubscrForeignKeys(Schema $schema) |
|
| 1398 | { |
|
| 1399 | $table = $schema->getTable('orocrm_magento_newsl_subscr'); |
|
| 1400 | $table->addForeignKeyConstraint( |
|
| 1401 | $schema->getTable('oro_organization'), |
|
| 1402 | ['organization_id'], |
|
| 1403 | ['id'], |
|
| 1404 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1405 | ); |
|
| 1406 | $table->addForeignKeyConstraint( |
|
| 1407 | $schema->getTable('oro_user'), |
|
| 1408 | ['owner_id'], |
|
| 1409 | ['id'], |
|
| 1410 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1411 | ); |
|
| 1412 | $table->addForeignKeyConstraint( |
|
| 1413 | $schema->getTable('orocrm_magento_customer'), |
|
| 1414 | ['customer_id'], |
|
| 1415 | ['id'], |
|
| 1416 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1417 | ); |
|
| 1418 | $table->addForeignKeyConstraint( |
|
| 1419 | $schema->getTable('orocrm_magento_store'), |
|
| 1420 | ['store_id'], |
|
| 1421 | ['id'], |
|
| 1422 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1423 | ); |
|
| 1424 | $table->addForeignKeyConstraint( |
|
| 1425 | $schema->getTable('oro_integration_channel'), |
|
| 1426 | ['channel_id'], |
|
| 1427 | ['id'], |
|
| 1428 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1429 | ); |
|
| 1430 | $table->addForeignKeyConstraint( |
|
| 1431 | $schema->getTable('orocrm_channel'), |
|
| 1432 | ['data_channel_id'], |
|
| 1433 | ['id'], |
|
| 1434 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 1435 | ); |
|
| 1436 | } |
|
| 1437 | ||
| 1438 | /** |
|
| 1439 | * Enable activities |
|
| @@ 512-552 (lines=41) @@ | ||
| 509 | * |
|
| 510 | * @param Schema $schema |
|
| 511 | */ |
|
| 512 | protected function addOrocrmSalesOpportunityForeignKeys(Schema $schema) |
|
| 513 | { |
|
| 514 | $table = $schema->getTable('orocrm_sales_opportunity'); |
|
| 515 | $table->addForeignKeyConstraint( |
|
| 516 | $schema->getTable('orocrm_contact'), |
|
| 517 | ['contact_id'], |
|
| 518 | ['id'], |
|
| 519 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 520 | ); |
|
| 521 | $table->addForeignKeyConstraint( |
|
| 522 | $schema->getTable('orocrm_sales_opport_close_rsn'), |
|
| 523 | ['close_reason_name'], |
|
| 524 | ['name'], |
|
| 525 | ['onUpdate' => null, 'onDelete' => null] |
|
| 526 | ); |
|
| 527 | $table->addForeignKeyConstraint( |
|
| 528 | $schema->getTable('oro_user'), |
|
| 529 | ['user_owner_id'], |
|
| 530 | ['id'], |
|
| 531 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 532 | ); |
|
| 533 | $table->addForeignKeyConstraint( |
|
| 534 | $schema->getTable('orocrm_sales_b2bcustomer'), |
|
| 535 | ['customer_id'], |
|
| 536 | ['id'], |
|
| 537 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 538 | ); |
|
| 539 | $table->addForeignKeyConstraint( |
|
| 540 | $schema->getTable('orocrm_channel'), |
|
| 541 | ['data_channel_id'], |
|
| 542 | ['id'], |
|
| 543 | ['onDelete' => 'SET NULL', 'onUpdate' => null], |
|
| 544 | 'FK_C0FE4AACBDC09B73' |
|
| 545 | ); |
|
| 546 | $table->addForeignKeyConstraint( |
|
| 547 | $schema->getTable('orocrm_sales_lead'), |
|
| 548 | ['lead_id'], |
|
| 549 | ['id'], |
|
| 550 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 551 | ); |
|
| 552 | } |
|
| 553 | ||
| 554 | /** |
|
| 555 | * Add orocrm_sales_funnel foreign keys. |
|
| @@ 594-634 (lines=41) @@ | ||
| 591 | * |
|
| 592 | * @param Schema $schema |
|
| 593 | */ |
|
| 594 | protected function addOrocrmSalesLeadForeignKeys(Schema $schema) |
|
| 595 | { |
|
| 596 | $table = $schema->getTable('orocrm_sales_lead'); |
|
| 597 | $table->addForeignKeyConstraint( |
|
| 598 | $schema->getTable('orocrm_campaign'), |
|
| 599 | ['campaign_id'], |
|
| 600 | ['id'], |
|
| 601 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 602 | ); |
|
| 603 | $table->addForeignKeyConstraint( |
|
| 604 | $schema->getTable('oro_address'), |
|
| 605 | ['address_id'], |
|
| 606 | ['id'], |
|
| 607 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 608 | ); |
|
| 609 | $table->addForeignKeyConstraint( |
|
| 610 | $schema->getTable('orocrm_contact'), |
|
| 611 | ['contact_id'], |
|
| 612 | ['id'], |
|
| 613 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 614 | ); |
|
| 615 | $table->addForeignKeyConstraint( |
|
| 616 | $schema->getTable('oro_user'), |
|
| 617 | ['user_owner_id'], |
|
| 618 | ['id'], |
|
| 619 | ['onUpdate' => null, 'onDelete' => 'SET NULL'] |
|
| 620 | ); |
|
| 621 | $table->addForeignKeyConstraint( |
|
| 622 | $schema->getTable('orocrm_sales_b2bcustomer'), |
|
| 623 | ['customer_id'], |
|
| 624 | ['id'], |
|
| 625 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 626 | ); |
|
| 627 | $table->addForeignKeyConstraint( |
|
| 628 | $schema->getTable('orocrm_channel'), |
|
| 629 | ['data_channel_id'], |
|
| 630 | ['id'], |
|
| 631 | ['onDelete' => 'SET NULL', 'onUpdate' => null], |
|
| 632 | 'FK_73DB4633BDC09B73' |
|
| 633 | ); |
|
| 634 | } |
|
| 635 | ||
| 636 | /** |
|
| 637 | * Add orocrm_sales_b2bcustomer foreign keys. |
|
| @@ 641-680 (lines=40) @@ | ||
| 638 | * |
|
| 639 | * @param Schema $schema |
|
| 640 | */ |
|
| 641 | protected function addOrocrmSalesB2bCustomerForeignKeys(Schema $schema) |
|
| 642 | { |
|
| 643 | $table = $schema->getTable('orocrm_sales_b2bcustomer'); |
|
| 644 | $table->addForeignKeyConstraint( |
|
| 645 | $schema->getTable('oro_user'), |
|
| 646 | ['user_owner_id'], |
|
| 647 | ['id'], |
|
| 648 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 649 | ); |
|
| 650 | $table->addForeignKeyConstraint( |
|
| 651 | $schema->getTable('oro_address'), |
|
| 652 | ['shipping_address_id'], |
|
| 653 | ['id'], |
|
| 654 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 655 | ); |
|
| 656 | $table->addForeignKeyConstraint( |
|
| 657 | $schema->getTable('orocrm_channel'), |
|
| 658 | ['data_channel_id'], |
|
| 659 | ['id'], |
|
| 660 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 661 | ); |
|
| 662 | $table->addForeignKeyConstraint( |
|
| 663 | $schema->getTable('oro_address'), |
|
| 664 | ['billing_address_id'], |
|
| 665 | ['id'], |
|
| 666 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 667 | ); |
|
| 668 | $table->addForeignKeyConstraint( |
|
| 669 | $schema->getTable('orocrm_account'), |
|
| 670 | ['account_id'], |
|
| 671 | ['id'], |
|
| 672 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 673 | ); |
|
| 674 | $table->addForeignKeyConstraint( |
|
| 675 | $schema->getTable('orocrm_contact'), |
|
| 676 | ['contact_id'], |
|
| 677 | ['id'], |
|
| 678 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 679 | ); |
|
| 680 | } |
|
| 681 | ||
| 682 | /** |
|
| 683 | * Add opportunity status Enum field and initialize default enum values |
|