<?xml version="1.0"?>
<!--
/**
 * Copyright © Magento, Inc. All rights reserved.
 * See COPYING.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="directory_country" resource="default" engine="innodb" comment="Directory Country">
        <column xsi:type="varchar" name="country_id" nullable="false" length="2" comment="Country ID in ISO-2"/>
        <column xsi:type="varchar" name="iso2_code" nullable="true" length="2" comment="Country ISO-2 format"/>
        <column xsi:type="varchar" name="iso3_code" nullable="true" length="3" comment="Country ISO-3"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="country_id"/>
        </constraint>
    </table>
    <table name="directory_country_format" resource="default" engine="innodb" comment="Directory Country Format">
        <column xsi:type="int" name="country_format_id" unsigned="true" nullable="false" identity="true"
                comment="Country Format ID"/>
        <column xsi:type="varchar" name="country_id" nullable="true" length="2" comment="Country ID in ISO-2"/>
        <column xsi:type="varchar" name="type" nullable="true" length="30" comment="Country Format Type"/>
        <column xsi:type="text" name="format" nullable="false" comment="Country Format"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="country_format_id"/>
        </constraint>
        <constraint xsi:type="unique" referenceId="DIRECTORY_COUNTRY_FORMAT_COUNTRY_ID_TYPE">
            <column name="country_id"/>
            <column name="type"/>
        </constraint>
    </table>
    <table name="directory_country_region" resource="default" engine="innodb" comment="Directory Country Region">
        <column xsi:type="int" name="region_id" unsigned="true" nullable="false" identity="true"
                comment="Region ID"/>
        <column xsi:type="varchar" name="country_id" nullable="false" length="4" default="0"
                comment="Country ID in ISO-2"/>
        <column xsi:type="varchar" name="code" nullable="true" length="32" comment="Region code"/>
        <column xsi:type="varchar" name="default_name" nullable="true" length="255" comment="Region Name"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="region_id"/>
        </constraint>
        <index referenceId="DIRECTORY_COUNTRY_REGION_COUNTRY_ID" indexType="btree">
            <column name="country_id"/>
        </index>
    </table>
    <table name="directory_country_region_name" resource="default" engine="innodb"
           comment="Directory Country Region Name">
        <column xsi:type="varchar" name="locale" nullable="false" length="16" comment="Locale"/>
        <column xsi:type="int" name="region_id" unsigned="true" nullable="false" identity="false"
                default="0" comment="Region ID"/>
        <column xsi:type="varchar" name="name" nullable="true" length="255" comment="Region Name"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="locale"/>
            <column name="region_id"/>
        </constraint>
        <constraint xsi:type="foreign" referenceId="DIR_COUNTRY_REGION_NAME_REGION_ID_DIR_COUNTRY_REGION_REGION_ID"
                    table="directory_country_region_name" column="region_id" referenceTable="directory_country_region"
                    referenceColumn="region_id" onDelete="CASCADE"/>
        <index referenceId="DIRECTORY_COUNTRY_REGION_NAME_REGION_ID" indexType="btree">
            <column name="region_id"/>
        </index>
    </table>
    <table name="directory_currency_rate" resource="default" engine="innodb" comment="Directory Currency Rate">
        <column xsi:type="varchar" name="currency_from" nullable="false" length="3"
                comment="Currency Code Convert From"/>
        <column xsi:type="varchar" name="currency_to" nullable="false" length="3" comment="Currency Code Convert To"/>
        <column xsi:type="decimal" name="rate" scale="12" precision="24" unsigned="false" nullable="false" default="0"
                comment="Currency Conversion Rate"/>
        <constraint xsi:type="primary" referenceId="PRIMARY">
            <column name="currency_from"/>
            <column name="currency_to"/>
        </constraint>
        <index referenceId="DIRECTORY_CURRENCY_RATE_CURRENCY_TO" indexType="btree">
            <column name="currency_to"/>
        </index>
    </table>
</schema>