|
Apache/2.4.41 (Ubuntu) Linux vmi616275.contaboserver.net 5.4.0-84-generic #94-Ubuntu SMP Thu Aug 26 20:27:37 UTC 2021 x86_64 uid=33(www-data) gid=33(www-data) groups=33(www-data) server ip : 62.171.164.128 | your ip : 127.0.0.1 safemode OFF > / home / a / home / dev2.destoffenstraat.com / app / code / Swissup / AddressFieldManager / etc / |
Filename | /home/a/home/dev2.destoffenstraat.com/app/code/Swissup/AddressFieldManager/etc/db_schema.xml |
Size | 1.43 kb |
Permission | rwxrwxrwx |
Owner | root : root |
Create time | 21-Aug-2025 12:26 |
Last modified | 15-Apr-2022 18:01 |
Last accessed | 22-Aug-2025 19:47 |
Actions | edit | rename | delete | download (gzip) |
View | text | code | image |
<?xml version="1.0"?>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="swissup_afm_order_address" resource="default" engine="innodb" comment="Swissup Address Field Manager Order Address">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="false" default="0" comment="Entity Id"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SWISSUP_AFM_ORDER_ADDR_ENTT_ID_SALES_ORDER_ADDR_ENTT_ID" table="swissup_afm_order_address" column="entity_id" referenceTable="sales_order_address" referenceColumn="entity_id" onDelete="CASCADE"/>
</table>
<table name="swissup_afm_quote_address" resource="default" engine="innodb" comment="Swissup Address Field Manager Quote Address">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="false" default="0" comment="Entity Id"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SWISSUP_AFM_QUOTE_ADDRESS_ENTITY_ID_QUOTE_ADDRESS_ADDRESS_ID" table="swissup_afm_quote_address" column="entity_id" referenceTable="quote_address" referenceColumn="address_id" onDelete="CASCADE"/>
</table>
</schema>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="swissup_afm_order_address" resource="default" engine="innodb" comment="Swissup Address Field Manager Order Address">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="false" default="0" comment="Entity Id"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SWISSUP_AFM_ORDER_ADDR_ENTT_ID_SALES_ORDER_ADDR_ENTT_ID" table="swissup_afm_order_address" column="entity_id" referenceTable="sales_order_address" referenceColumn="entity_id" onDelete="CASCADE"/>
</table>
<table name="swissup_afm_quote_address" resource="default" engine="innodb" comment="Swissup Address Field Manager Quote Address">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="false" default="0" comment="Entity Id"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SWISSUP_AFM_QUOTE_ADDRESS_ENTITY_ID_QUOTE_ADDRESS_ADDRESS_ID" table="swissup_afm_quote_address" column="entity_id" referenceTable="quote_address" referenceColumn="address_id" onDelete="CASCADE"/>
</table>
</schema>