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/Cnc/Catalog/etc/ |
<?xml version="1.0"?>
<!--
/**
* Copyright (c) 2020 Kaliop Digital Commerce (https://digitalcommerce.kaliop.com) All Rights Reserved.
* https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
* Cnc
* Radosław Stępień <[email protected]> <[email protected]>
*/
-->
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<!--Guarantee duration table-->
<table name="cnc_guarantee_duration" resource="default">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Guarantee duration ID"/>
<column xsi:type="varchar" name="name" nullable="false" length="255"
comment="Guarantee duration name"/>
<column xsi:type="varchar" name="image" nullable="true" length="255"
comment="Guarantee duration image"/>
<column xsi:type="timestamp" name="created_at" nullable="false"
comment="Guarantee duration created date"/>
<column xsi:type="timestamp" name="last_update" nullable="true"
comment="Guarantee duration last update date"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="CNC_GUARANTEE_DURATION_ENTITY_ID">
<column name="entity_id"/>
</constraint>
<index referenceId="CNC_GUARANTEE_DURATION_NAME" indexType="btree">
<column name="name"/>
</index>
</table>
<!--Guarantee type table-->
<table name="cnc_guarantee_type" resource="default">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Guarantee type ID"/>
<column xsi:type="varchar" name="name" nullable="false" length="255"
comment="Guarantee type name"/>
<column xsi:type="varchar" name="image" nullable="true" length="255"
comment="Guarantee type image"/>
<column xsi:type="timestamp" name="created_at" nullable="false"
comment="Guarantee type created date"/>
<column xsi:type="timestamp" name="last_update" nullable="true"
comment="Guarantee type last update date"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="CNC_GUARANTEE_TYPE_ENTITY_ID">
<column name="entity_id"/>
</constraint>
<index referenceId="CNC_GUARANTEE_TYPE_NAME" indexType="btree">
<column name="name"/>
</index>
</table>
<!--Manufacturer table-->
<table name="cnc_manufacturer" resource="default">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Manufacturer ID"/>
<column xsi:type="varchar" name="name" nullable="false" length="255"
comment="Manufacturer name"/>
<column xsi:type="varchar" name="image" nullable="true" length="255"
comment="Manufacturer image"/>
<column xsi:type="varchar" name="country" nullable="false" length="255"
comment="Manufacturer country"/>
<column xsi:type="timestamp" name="created_at" nullable="false"
comment="Manufacturer created date"/>
<column xsi:type="timestamp" name="last_update" nullable="true"
comment="Manufacturer last update date"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="CNC_MANUFACTURER_ENTITY_ID">
<column name="entity_id"/>
</constraint>
<index referenceId="CNC_MANUFACTURER_NAME" indexType="btree">
<column name="name"/>
</index>
</table>
<!--State of wear table-->
<table name="cnc_state_of_wear" resource="default">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="State ID"/>
<column xsi:type="varchar" name="name" nullable="false" length="255"
comment="State name"/>
<column xsi:type="varchar" name="image" nullable="true" length="255"
comment="State image"/>
<column xsi:type="timestamp" name="created_at" nullable="false"
comment="State created date"/>
<column xsi:type="timestamp" name="last_update" nullable="true"
comment="State last update date"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="CNC_STATE_OF_WEAR_ENTITY_ID">
<column name="entity_id"/>
</constraint>
<index referenceId="CNC_STATE_OF_WEAR_ENTITY_NAME" indexType="btree">
<column name="name"/>
</index>
</table>
<table name="cnc_stock_import" resource="default" engine="innodb"
comment="CNC Stock Import temp table">
<column xsi:type="int" name="cnc_stock_id" unsigned="true" nullable="false" identity="true" comment="StockItem ID"/>
<column xsi:type="varchar" name="source_code" nullable="false" length="50"
default="0" comment="Stock Source code"/>
<column xsi:type="varchar" name="sku" nullable="false" length="150"
comment="Item SKU"/>
<column xsi:type="smallint" name="qty" unsigned="true" nullable="false" identity="false"
default="0" comment="Qty"/>
<column xsi:type="smallint" name="is_imported" unsigned="true" nullable="false" identity="false"
default="0" comment="If was imported"/>
<column xsi:type="timestamp" name="import_date" nullable="true"
default="NULL" comment="When was imported"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="cnc_stock_id"/>
</constraint>
</table>
</schema>