|
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 / dev2.destoffenstraat.com / app / code / SendCloud / SendCloud / etc / |
| Filename | /home/dev2.destoffenstraat.com/app/code/SendCloud/SendCloud/etc/db_schema.xml |
| Size | 9.52 kb |
| Permission | rwxrwxrwx |
| Owner | root : root |
| Create time | 17-Aug-2025 10:26 |
| Last modified | 11-Feb-2023 11:04 |
| Last accessed | 22-Aug-2025 18:26 |
| 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="sendcloud_servicepointrate" resource="default" engine="innodb"
comment="Shipping SendCloud Servicepoint Rates">
<column xsi:type="int" name="pk" unsigned="true" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="website_id" unsigned="false" nullable="false" identity="false"
default="0" comment="Website ID"/>
<column xsi:type="varchar" name="dest_country_id" nullable="false" length="4" default="0"
comment="Destination coutry ISO/2 or ISO/3 code"/>
<column xsi:type="int" name="dest_region_id" unsigned="false" nullable="false" identity="false"
default="0" comment="Destination Region ID"/>
<column xsi:type="varchar" name="dest_zip" nullable="false" length="10" default="*"
comment="Destination Post Code (Zip)"/>
<column xsi:type="varchar" name="condition_name" nullable="false" length="64" comment="Rate Condition name"
onCreate="migrateDataFrom(sen_condition_name)"/>
<column xsi:type="varchar" name="sen_condition_name" nullable="false" length="64" comment="Rate Condition name"/>
<column xsi:type="decimal" name="condition_value" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Rate condition value"/>
<column xsi:type="decimal" name="price" scale="4" precision="12" unsigned="false" nullable="false" default="0"
comment="Price"/>
<column xsi:type="decimal" name="cost" scale="4" precision="12" unsigned="false" nullable="false" default="0"
comment="Cost"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="pk"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_C0DB67076EAA5EA868F15196691297E7">
<column name="website_id"/>
<column name="dest_country_id"/>
<column name="dest_region_id"/>
<column name="dest_zip"/>
<column name="condition_name"/>
<column name="condition_value"/>
</constraint>
</table>
<table name="sales_order" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_data" nullable="true"
comment="Sendcloud checkout data"/>
</table>
<table name="sales_order_grid" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_data" nullable="true"
comment="Sendcloud checkout data"/>
</table>
<table name="quote" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_checkout_data" nullable="true"
comment="Sendcloud checkout data"/>
<column xsi:type="longtext" name="sendcloud_multishipping_data" nullable="true"
comment="Sendcloud multishipping checkout data"/>
</table>
<table name="sendcloud_shipping_zones" resource="default" engine="innodb"
comment="SendCloud Shipping Zones">
<column xsi:type="int" name="id" unsigned="false" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="store_view_id" unsigned="false" nullable="false" identity="false"
comment="Store view ID"/>
<column xsi:type="varchar" name="external_id" nullable="false" length="64"
comment="External id"/>
<column xsi:type="longtext" name="data" nullable="true"
comment="Shipping zone data"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_EXT_ZON7076EAA5EA868F151SA297E8">
<column name="external_id"/>
</constraint>
</table>
<table name="sendcloud_shipping_methods" resource="default" engine="innodb"
comment="SendCloud Shipping Methods">
<column xsi:type="int" name="id" unsigned="false" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="store_view_id" unsigned="false" nullable="false" identity="false"
comment="Store view ID"/>
<column xsi:type="varchar" name="external_id" nullable="false" length="255"
comment="External id"/>
<column xsi:type="varchar" name="delivery_zone_id" nullable="false" length="64"
comment="Delivery zone id"/>
<column xsi:type="longtext" name="data" nullable="true"
comment="Shipping method data"/>
<column xsi:type="varchar" length="100" name="country" nullable="false"
comment="Shipping method country"/>
<column xsi:type="varchar" length="255" name="internal_title" nullable="false"
comment="Shipping method internal title"/>
<column xsi:type="varchar" length="255" name="external_title" nullable="false"
comment="Shipping method external title"/>
<column xsi:type="varchar" length="300" name="shipping_product" nullable="false"
comment="Shipping method shipping product"/>
<column xsi:type="tinyint" name="rates_enabled" nullable="false"
comment="Shipping method rates enabled"/>
<column xsi:type="varchar" length="100" name="delivery_method" nullable="false"
comment="Shipping delivery method"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_EXT_SHIP7AR2QA1SQ5WR1SA297E8">
<column name="external_id"/>
</constraint>
<index referenceId="fulltext" indexType="fulltext">
<column name="external_title"/>
<column name="internal_title"/>
</index>
</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="sendcloud_servicepointrate" resource="default" engine="innodb"
comment="Shipping SendCloud Servicepoint Rates">
<column xsi:type="int" name="pk" unsigned="true" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="website_id" unsigned="false" nullable="false" identity="false"
default="0" comment="Website ID"/>
<column xsi:type="varchar" name="dest_country_id" nullable="false" length="4" default="0"
comment="Destination coutry ISO/2 or ISO/3 code"/>
<column xsi:type="int" name="dest_region_id" unsigned="false" nullable="false" identity="false"
default="0" comment="Destination Region ID"/>
<column xsi:type="varchar" name="dest_zip" nullable="false" length="10" default="*"
comment="Destination Post Code (Zip)"/>
<column xsi:type="varchar" name="condition_name" nullable="false" length="64" comment="Rate Condition name"
onCreate="migrateDataFrom(sen_condition_name)"/>
<column xsi:type="varchar" name="sen_condition_name" nullable="false" length="64" comment="Rate Condition name"/>
<column xsi:type="decimal" name="condition_value" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Rate condition value"/>
<column xsi:type="decimal" name="price" scale="4" precision="12" unsigned="false" nullable="false" default="0"
comment="Price"/>
<column xsi:type="decimal" name="cost" scale="4" precision="12" unsigned="false" nullable="false" default="0"
comment="Cost"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="pk"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_C0DB67076EAA5EA868F15196691297E7">
<column name="website_id"/>
<column name="dest_country_id"/>
<column name="dest_region_id"/>
<column name="dest_zip"/>
<column name="condition_name"/>
<column name="condition_value"/>
</constraint>
</table>
<table name="sales_order" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_data" nullable="true"
comment="Sendcloud checkout data"/>
</table>
<table name="sales_order_grid" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_data" nullable="true"
comment="Sendcloud checkout data"/>
</table>
<table name="quote" resource="default" engine="innodb">
<column xsi:type="int" name="sendcloud_service_point_id" nullable="true"
comment="service point id"/>
<column xsi:type="varchar" name="sendcloud_service_point_name" length="255" nullable="true"
comment="service point name"/>
<column xsi:type="varchar" name="sendcloud_service_point_street" length="255" nullable="true"
comment="service point street"/>
<column xsi:type="varchar" name="sendcloud_service_point_house_number" length="255" nullable="true"
comment="service point house number"/>
<column xsi:type="varchar" name="sendcloud_service_point_zip_code" length="255" nullable="true"
comment="service point zip code"/>
<column xsi:type="varchar" name="sendcloud_service_point_city" length="255" nullable="true"
comment="service point city"/>
<column xsi:type="varchar" name="sendcloud_service_point_country" length="255" nullable="true"
comment="service point country"/>
<column xsi:type="varchar" name="sendcloud_service_point_postnumber" length="255" nullable="true"
comment="service point post number"/>
<column xsi:type="longtext" name="sendcloud_checkout_data" nullable="true"
comment="Sendcloud checkout data"/>
<column xsi:type="longtext" name="sendcloud_multishipping_data" nullable="true"
comment="Sendcloud multishipping checkout data"/>
</table>
<table name="sendcloud_shipping_zones" resource="default" engine="innodb"
comment="SendCloud Shipping Zones">
<column xsi:type="int" name="id" unsigned="false" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="store_view_id" unsigned="false" nullable="false" identity="false"
comment="Store view ID"/>
<column xsi:type="varchar" name="external_id" nullable="false" length="64"
comment="External id"/>
<column xsi:type="longtext" name="data" nullable="true"
comment="Shipping zone data"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_EXT_ZON7076EAA5EA868F151SA297E8">
<column name="external_id"/>
</constraint>
</table>
<table name="sendcloud_shipping_methods" resource="default" engine="innodb"
comment="SendCloud Shipping Methods">
<column xsi:type="int" name="id" unsigned="false" nullable="false" identity="true"
comment="Primary key"/>
<column xsi:type="int" name="store_view_id" unsigned="false" nullable="false" identity="false"
comment="Store view ID"/>
<column xsi:type="varchar" name="external_id" nullable="false" length="255"
comment="External id"/>
<column xsi:type="varchar" name="delivery_zone_id" nullable="false" length="64"
comment="Delivery zone id"/>
<column xsi:type="longtext" name="data" nullable="true"
comment="Shipping method data"/>
<column xsi:type="varchar" length="100" name="country" nullable="false"
comment="Shipping method country"/>
<column xsi:type="varchar" length="255" name="internal_title" nullable="false"
comment="Shipping method internal title"/>
<column xsi:type="varchar" length="255" name="external_title" nullable="false"
comment="Shipping method external title"/>
<column xsi:type="varchar" length="300" name="shipping_product" nullable="false"
comment="Shipping method shipping product"/>
<column xsi:type="tinyint" name="rates_enabled" nullable="false"
comment="Shipping method rates enabled"/>
<column xsi:type="varchar" length="100" name="delivery_method" nullable="false"
comment="Shipping delivery method"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="unique" referenceId="UNQ_EXT_SHIP7AR2QA1SQ5WR1SA297E8">
<column name="external_id"/>
</constraint>
<index referenceId="fulltext" indexType="fulltext">
<column name="external_title"/>
<column name="internal_title"/>
</index>
</table>
</schema>