Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/app/code/Ecombricks/InventoryCustomerSourceSelection/etc/ |
<?xml version="1.0"?>
<!--
/**
* Copyright © eComBricks. All rights reserved.
* See LICENSE.txt for license details.
*/
-->
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="ecombricks_inventory__catalog_product_index_price_source_idx" resource="default" engine="innodb" comment="Product Index Price Source Index">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" comment="Entity ID"/>
<column xsi:type="smallint" name="website_id" unsigned="true" nullable="false" comment="Website ID"/>
<column xsi:type="decimal" name="min_price" scale="6" precision="20" nullable="true" comment="Min Price"/>
<column xsi:type="decimal" name="max_price" scale="6" precision="20" nullable="true" comment="Max Price"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
<column name="website_id"/>
</constraint>
</table>
<table name="ecombricks_inventory__catalog_product_index_price_source_tmp" resource="default" engine="innodb" comment="Product Index Price Source Temp">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" comment="Entity ID"/>
<column xsi:type="smallint" name="website_id" unsigned="true" nullable="false" comment="Website ID"/>
<column xsi:type="decimal" name="min_price" scale="6" precision="20" nullable="true" comment="Min Price"/>
<column xsi:type="decimal" name="max_price" scale="6" precision="20" nullable="true" comment="Max Price"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
<column name="website_id"/>
</constraint>
</table>
<table name="ecombricks_inventory__inventory_source_item_price" resource="default" engine="innodb" comment="Inventory Source Item Price">
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="sku" nullable="false" length="64" comment="SKU"/>
<column xsi:type="decimal" name="value" scale="6" precision="20" unsigned="false" nullable="true" comment="Value"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="source_code"/>
<column name="sku"/>
</constraint>
</table>
<table name="ecombricks_inventory__inventory_source_item_tax_class" resource="default" engine="innodb" comment="Inventory Source Item Tax Class">
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="sku" nullable="false" length="64" comment="SKU"/>
<column xsi:type="smallint" name="value" unsigned="false" nullable="true" comment="Value"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="source_code"/>
<column name="sku"/>
</constraint>
</table>
<table name="ecombricks_inventory__quote_item_source" resource="default" engine="innodb" comment="Quote Item Source">
<column xsi:type="int" name="item_id" padding="10" unsigned="true" nullable="false" comment="Item ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<index referenceId="ECOMBRICKS_INVENTORY__QUOTE_ITEM_SOURCE_SOURCE_CODE" indexType="btree">
<column name="source_code"/>
</index>
<constraint xsi:type="unique" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ITEM_SOURCE_ITEM_ID">
<column name="item_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ITEM_SOURCE_ITEM_ID_QUOTE_ITEM_ITEM_ID"
table="ecombricks_inventory__quote_item_source" column="item_id"
referenceTable="quote_item" referenceColumn="item_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ITEM_SOURCE_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__quote_item_source" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__sales_order_item_source" resource="default" engine="innodb" comment="Sales Order Item Source">
<column xsi:type="int" name="item_id" padding="10" unsigned="true" nullable="false" comment="Item ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<index referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_ITEM_SOURCE_SOURCE_CODE" indexType="btree">
<column name="source_code"/>
</index>
<constraint xsi:type="unique" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_ITEM_SOURCE_ITEM_ID">
<column name="item_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_ITEM_SOURCE_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID"
table="ecombricks_inventory__sales_order_item_source" column="item_id"
referenceTable="sales_order_item" referenceColumn="item_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_ITEM_SOURCE_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__sales_order_item_source" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__source_core_config_data" resource="default" engine="innodb" comment="Source Config Data">
<column xsi:type="int" name="config_id" unsigned="true" nullable="false" identity="true" comment="Config ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="scope" nullable="false" length="8" default="default" comment="Scope"/>
<column xsi:type="int" name="scope_id" unsigned="false" nullable="false" identity="false" default="0" comment="Scope ID"/>
<column xsi:type="varchar" name="path" nullable="false" length="255" default="general" comment="Path"/>
<column xsi:type="text" name="value" nullable="true" comment="Value"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Updated At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="config_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="ECOMBRICKS_SOURCE_CORE_CONFIG_DATA_SOURCE_CODE_SCOPE_SCOPE_ID_PATH">
<column name="source_code"/>
<column name="scope"/>
<column name="scope_id"/>
<column name="path"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_SOURCE_CORE_CONFIG_DATA_INVENTORY_SOURCE_SOURCE_CODE"
table="core_config_data" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__source_inventory_reservation" resource="default" engine="innodb" comment="Source Inventory Reservation">
<column xsi:type="int" name="reservation_id" unsigned="true" nullable="false" identity="true" comment="Reservation ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="sku" nullable="false" length="64" comment="SKU"/>
<column xsi:type="decimal" name="quantity" scale="4" precision="10" unsigned="false" nullable="false" default="0" comment="Quantity"/>
<column xsi:type="varchar" name="metadata" nullable="true" length="255" comment="Metadata"/>
<index referenceId="ECOMBRICKS_INVENTORY__SOURCE_INVENTORY_RESERVATION_SOURCE_CODE_SKU_QUANTITY" indexType="btree">
<column name="source_code"/>
<column name="sku"/>
<column name="quantity"/>
</index>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="reservation_id"/>
</constraint>
</table>
<table name="ecombricks_inventory__quote_address_source_shipping_method" resource="default" engine="innodb" comment="Quote Address Source Shipping Method">
<column xsi:type="int" name="address_id" padding="10" unsigned="true" nullable="false" comment="Address ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="value" nullable="false" length="120" comment="Value"/>
<index referenceId="ECOMBRICKS_INVENTORY__QUOTE_ADDRESS_SOURCE_SHIPPING_METHOD_ADDRESS_ID" indexType="btree">
<column name="address_id"/>
</index>
<index referenceId="ECOMBRICKS_INVENTORY__QUOTE_ADDRESS_SOURCE_SHIPPING_METHOD_SOURCE_CODE" indexType="btree">
<column name="source_code"/>
</index>
<constraint xsi:type="unique" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ADDRESS_SOURCE_SHIPPING_METHOD_ADDRESS_ID_SOURCE_CODE">
<column name="address_id"/>
<column name="source_code"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ADDRESS_SOURCE_SHIPPING_METHOD_ADDRESS_ID_QUOTE_ADDRESS_ADDRESS_ID"
table="ecombricks_inventory__quote_address_source_shipping_method" column="address_id"
referenceTable="quote_address" referenceColumn="address_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__QUOTE_ADDRESS_SOURCE_SHIPPING_METHOD_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__quote_address_source_shipping_method" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__source_quote_shipping_rate" resource="default" engine="innodb" comment="Source Quote Shipping Rate">
<column xsi:type="int" name="rate_id" unsigned="true" nullable="false" identity="true" comment="Rate ID"/>
<column xsi:type="int" name="address_id" padding="10" unsigned="true" nullable="false" identity="false" default="0" comment="Address ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="carrier" nullable="true" length="255" comment="Carrier"/>
<column xsi:type="varchar" name="carrier_title" nullable="true" length="255" comment="Carrier Title"/>
<column xsi:type="varchar" name="code" nullable="true" length="255" comment="Code"/>
<column xsi:type="varchar" name="method" nullable="true" length="255" comment="Method"/>
<column xsi:type="text" name="method_description" nullable="true" comment="Method Description"/>
<column xsi:type="decimal" name="price" scale="4" precision="20" unsigned="false" nullable="false" default="0" comment="Price"/>
<column xsi:type="text" name="error_message" nullable="true" comment="Error Message"/>
<column xsi:type="text" name="method_title" nullable="true" comment="Method Title"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="Updated At"/>
<index referenceId="ECOMBRICKS_INVENTORY__SOURCE_QUOTE_SHIPPING_RATE_ADDRESS_ID" indexType="btree">
<column name="address_id"/>
</index>
<index referenceId="ECOMBRICKS_INVENTORY__SOURCE_QUOTE_SHIPPING_RATE_SOURCE_CODE" indexType="btree">
<column name="source_code"/>
</index>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="rate_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SOURCE_QUOTE_SHIPPING_RATE_ADDRESS_ID_QUOTE_SHIPPING_RATE_ADDRESS_ID"
table="ecombricks_inventory__source_quote_shipping_rate" column="address_id"
referenceTable="quote_address" referenceColumn="address_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SOURCE_QUOTE_SHIPPING_RATE_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__source_quote_shipping_rate" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__sales_order_source_shipping_method" resource="default" engine="innodb" comment="Order Source Shipping Method">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" comment="Entity ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="255" comment="Source Code"/>
<column xsi:type="varchar" name="value" nullable="false" length="120" comment="Value"/>
<index referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_SOURCE_SHIPPING_METHOD_ENTITY_ID" indexType="btree">
<column name="entity_id"/>
</index>
<index referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_SOURCE_SHIPPING_METHOD_SOURCE_CODE" indexType="btree">
<column name="source_code"/>
</index>
<constraint xsi:type="unique" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_SOURCE_SHIPPING_METHOD_ENTITY_ID_SOURCE_CODE">
<column name="entity_id"/>
<column name="source_code"/>
</constraint>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_SOURCE_SHIPPING_METHOD_ENTITY_ID_SALES_ORDER_ENTITY_ID"
table="ecombricks_inventory__sales_order_source_shipping_method" column="entity_id"
referenceTable="sales_order" referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SALES_ORDER_SOURCE_SHIPPING_METHOD_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__sales_order_source_shipping_method" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
<table name="ecombricks_inventory__source_shipping_tablerate" resource="default" engine="innodb" comment="Source Shipping Tablerate">
<column xsi:type="int" name="pk" unsigned="true" nullable="false" identity="true" comment="Primary key"/>
<column xsi:type="varchar" name="source_code" nullable="true" length="255" comment="Source Code"/>
<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="30" 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="ECOMBRICKS_INVENTORY__SOURCE_SHIPPING_TABLERATE_SOURCE_CODE_WEBSITE_ID_DEST_COUNTRY_ID_DEST_REGION_ID_DEST_ZIP_CONDITION_NAME_CONDITION_VALUE">
<column name="source_code"/>
<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>
<constraint xsi:type="foreign" referenceId="ECOMBRICKS_INVENTORY__SOURCE_SHIPPING_TABLERATE_SOURCE_CODE_INVENTORY_SOURCE_SOURCE_CODE"
table="ecombricks_inventory__source_shipping_tablerate" column="source_code"
referenceTable="inventory_source" referenceColumn="source_code" onDelete="CASCADE"/>
</table>
</schema>