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/SerialNumber/etc/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?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)
 * Krzysztof Majkowski <[email protected]>
 */
-->
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
    <table name="cnc_serial_number" resource="default" engine="innodb"
           comment="CNC Serial Number table">
        <column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true" comment="Serial number ID"/>
        <column xsi:type="varchar" name="serial_number" nullable="false" length="128"
                default="" comment="Serial number"/>
        <column xsi:type="varchar" name="source_code" nullable="false" length="50"
                default="" comment="Stock Source code"/>
        <column xsi:type="varchar" name="sku" nullable="false" length="150"
                comment="Item SKU"/>
        <column xsi:type="varchar" name="origin" nullable="true" length="150"
                comment="Origin"/>
        <column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
                comment="Created at"/>
        <column xsi:type="int" name="admin_user_id" unsigned="true" nullable="true" default="0"
                comment="Admin user id"/>
        <column xsi:type="smallint" name="status" unsigned="true" nullable="false" identity="false"
                default="0" comment="Status"/>
        <column xsi:type="boolean" name="is_exported" nullable="false" default="false"/>
        <column xsi:type="varchar" name="order_increment_id" nullable="true" length="32"
                comment="Order Increment ID"/>
        <column xsi:type="timestamp" name="order_created_at" nullable="true"
                comment="Order Created At"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="entity_id"/>
        </constraint>
        <index referenceId="CNC_SERIAL_NUMBER_SERIAL_NUMBER" indexType="btree">
            <column name="serial_number"/>
        </index>
    </table>

    <table name="cnc_serial_number_index" resource="default" engine="innodb"
           comment="CNC Serial Number index table">
        <column xsi:type="int" name="product_id" unsigned="true" nullable="true" default="0"
                comment="Product ID"/>
        <column xsi:type="varchar" name="source_code" nullable="false" length="50"
                default="" comment="Stock Source code"/>
        <column xsi:type="int" name="version" unsigned="true" nullable="true" default="1"
                comment="Last version"/>
        <constraint xsi:type="unique" referenceId="CNC_SERIAL_NUMBER_SERIAL_NUMBER_INDEX">
            <column name="product_id"/>
            <column name="source_code"/>
        </constraint>
    </table>
</schema>