| @@ 905-916 (lines=12) @@ | ||
| 902 | * |
|
| 903 | * @param Schema $schema |
|
| 904 | */ |
|
| 905 | public static function orocrmMagentoCustomerGroupForeignKeys(Schema $schema) |
|
| 906 | { |
|
| 907 | /** Generate foreign keys for table orocrm_magento_customer_group **/ |
|
| 908 | $table = $schema->getTable('orocrm_magento_customer_group'); |
|
| 909 | $table->addForeignKeyConstraint( |
|
| 910 | $schema->getTable('oro_integration_channel'), |
|
| 911 | ['channel_id'], |
|
| 912 | ['id'], |
|
| 913 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 914 | ); |
|
| 915 | /** End of generate foreign keys for table orocrm_magento_customer_group **/ |
|
| 916 | } |
|
| 917 | ||
| 918 | /** |
|
| 919 | * Generate foreign keys for table orocrm_magento_order |
|
| @@ 1091-1102 (lines=12) @@ | ||
| 1088 | * |
|
| 1089 | * @param Schema $schema |
|
| 1090 | */ |
|
| 1091 | public static function orocrmMagentoProductForeignKeys(Schema $schema) |
|
| 1092 | { |
|
| 1093 | /** Generate foreign keys for table orocrm_magento_product **/ |
|
| 1094 | $table = $schema->getTable('orocrm_magento_product'); |
|
| 1095 | $table->addForeignKeyConstraint( |
|
| 1096 | $schema->getTable('oro_integration_channel'), |
|
| 1097 | ['channel_id'], |
|
| 1098 | ['id'], |
|
| 1099 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 1100 | ); |
|
| 1101 | /** End of generate foreign keys for table orocrm_magento_product **/ |
|
| 1102 | } |
|
| 1103 | ||
| 1104 | /** |
|
| 1105 | * Generate foreign keys for table orocrm_magento_product_to_website |
|
| @@ 1158-1169 (lines=12) @@ | ||
| 1155 | * |
|
| 1156 | * @param Schema $schema |
|
| 1157 | */ |
|
| 1158 | public static function orocrmMagentoWebsiteForeignKeys(Schema $schema) |
|
| 1159 | { |
|
| 1160 | /** Generate foreign keys for table orocrm_magento_website **/ |
|
| 1161 | $table = $schema->getTable('orocrm_magento_website'); |
|
| 1162 | $table->addForeignKeyConstraint( |
|
| 1163 | $schema->getTable('oro_integration_channel'), |
|
| 1164 | ['channel_id'], |
|
| 1165 | ['id'], |
|
| 1166 | ['onDelete' => 'SET NULL', 'onUpdate' => null] |
|
| 1167 | ); |
|
| 1168 | /** End of generate foreign keys for table orocrm_magento_website **/ |
|
| 1169 | } |
|
| 1170 | } |
|
| 1171 | ||
| @@ 961-970 (lines=10) @@ | ||
| 958 | * |
|
| 959 | * @param Schema $schema |
|
| 960 | */ |
|
| 961 | protected function addOrocrmMagentoCustomerGroupForeignKeys(Schema $schema) |
|
| 962 | { |
|
| 963 | $table = $schema->getTable('orocrm_magento_customer_group'); |
|
| 964 | $table->addForeignKeyConstraint( |
|
| 965 | $schema->getTable('oro_integration_channel'), |
|
| 966 | ['channel_id'], |
|
| 967 | ['id'], |
|
| 968 | ['onDelete' => 'SET NULL'] |
|
| 969 | ); |
|
| 970 | } |
|
| 971 | ||
| 972 | /** |
|
| 973 | * Add orocrm_magento_customer foreign keys. |
|
| @@ 1197-1206 (lines=10) @@ | ||
| 1194 | * |
|
| 1195 | * @param Schema $schema |
|
| 1196 | */ |
|
| 1197 | protected function addOrocrmMagentoProductForeignKeys(Schema $schema) |
|
| 1198 | { |
|
| 1199 | $table = $schema->getTable('orocrm_magento_product'); |
|
| 1200 | $table->addForeignKeyConstraint( |
|
| 1201 | $schema->getTable('oro_integration_channel'), |
|
| 1202 | ['channel_id'], |
|
| 1203 | ['id'], |
|
| 1204 | ['onDelete' => 'SET NULL'] |
|
| 1205 | ); |
|
| 1206 | } |
|
| 1207 | ||
| 1208 | /** |
|
| 1209 | * Add orocrm_magento_prod_to_website foreign keys. |
|
| @@ 1235-1244 (lines=10) @@ | ||
| 1232 | * |
|
| 1233 | * @param Schema $schema |
|
| 1234 | */ |
|
| 1235 | protected function addOrocrmMagentoWebsiteForeignKeys(Schema $schema) |
|
| 1236 | { |
|
| 1237 | $table = $schema->getTable('orocrm_magento_website'); |
|
| 1238 | $table->addForeignKeyConstraint( |
|
| 1239 | $schema->getTable('oro_integration_channel'), |
|
| 1240 | ['channel_id'], |
|
| 1241 | ['id'], |
|
| 1242 | ['onDelete' => 'SET NULL'] |
|
| 1243 | ); |
|
| 1244 | } |
|
| 1245 | ||
| 1246 | /** |
|
| 1247 | * Add orocrm_magento_cart foreign keys. |
|