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/vendor/extmag/shiplab/etc/ |
<?xml version="1.0"?>
<!--
/**
* Copyright © Extmag. All rights reserved.
*/
-->
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="extmag_labels" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="20"/>
<column xsi:type="int" name="store_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="varchar" name="order_increment_id" nullable="false" length="255"/>
<column xsi:type="varchar" name="order_sub_type" nullable="false" length="20"/>
<column xsi:type="int" name="order_sub_id" padding="10" unsigned="true" nullable="false" identity="false" comment="shipment, refund"/>
<column xsi:type="varchar" name="order_sub_increment_id" nullable="false" length="255"/>
<column xsi:type="varchar" name="type_direction" nullable="false" length="20" default="shipment"/>
<column xsi:type="varchar" name="master_id" nullable="false" length="255" default=""
comment="Shipment Identification"/>
<column xsi:type="text" name="tracking_number" nullable="false"/>
<column xsi:type="varchar" name="extension" nullable="false" length="11" default=""/>
<column xsi:type="int" name="status" padding="11" unsigned="false" nullable="false" identity="false"
default="0"/>
<column xsi:type="int" name="is_printed" padding="11" unsigned="false" nullable="false" identity="false"
default="0"/>
<column xsi:type="decimal" name="price" scale="2" precision="7" unsigned="false" nullable="false" default="0"/>
<column xsi:type="varchar" name="currency" nullable="false" length="3" default=""/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="mediumtext" name="request" nullable="false"/>
<column xsi:type="mediumtext" name="response" nullable="false"/>
<column xsi:type="mediumtext" name="link" nullable="false"/>
<column xsi:type="smallint" name="is_pickup" padding="2" unsigned="false" nullable="false" identity="false"
default="0"/>
<column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="false" identity="false"
default="0"/>
<column xsi:type="int" name="track_status" padding="10" unsigned="true" nullable="false" identity="false"
default="0" comment="0-not allowed using yet, 1- allow using, 2- complete and stop using"/>
<column xsi:type="mediumtext" name="track_response" nullable="false"/>
<column xsi:type="timestamp" name="track_first_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="track_last_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<index referenceId="EXTMAG_LABELS_BTREE_STATUS" indexType="btree">
<column name="status"/>
</index>
<index referenceId="EXTMAG_LABELS_BTREE_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="EXTMAG_LABELS_BTREE_TRACK_STATUS" indexType="btree">
<column name="track_status"/>
</index>
<index referenceId="EXTMAG_LABELS_BTREE_IS_PICKUP" indexType="btree">
<column name="is_pickup"/>
</index>
</table>
<table name="extmag_logs" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="mode" nullable="false" length="20" comment="error, info, warning"/>
<column xsi:type="varchar" name="type" nullable="false" length="20"
comment="rate, ship, pickup, void, tracking"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="20" default="overall"/>
<column xsi:type="text" name="title" nullable="false"/>
<column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"
default="0"/>
<column xsi:type="varchar" name="type_direction" nullable="false" length="20" default=""
comment="shipment, refund, inverse"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="mediumtext" name="request" nullable="false"/>
<column xsi:type="mediumtext" name="response" nullable="false"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
</table>
<table name="extmag_address" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="200"/>
<column xsi:type="varchar" name="company_name" nullable="false" length="200"/>
<column xsi:type="varchar" name="attention_name" nullable="false" length="200"/>
<column xsi:type="varchar" name="phone" nullable="false" length="30"/>
<column xsi:type="varchar" name="country_id" nullable="false" length="2"/>
<column xsi:type="varchar" name="postal_code" nullable="false" length="15" default=""/>
<column xsi:type="varchar" name="region" nullable="false" length="15" default=""/>
<column xsi:type="varchar" name="city" nullable="false" length="50"/>
<column xsi:type="varchar" name="urbanization" nullable="false" length="50" default=""/>
<column xsi:type="varchar" name="address_line_1" nullable="false" length="50"/>
<column xsi:type="varchar" name="address_line_2" nullable="false" length="50" default=""/>
<column xsi:type="varchar" name="address_line_3" nullable="false" length="50" default=""/>
<column xsi:type="varchar" name="floor" nullable="false" length="10" default=""/>
<column xsi:type="varchar" name="room" nullable="false" length="10" default=""/>
<column xsi:type="varchar" name="pickup_point" nullable="false" length="50" default=""/>
<column xsi:type="varchar" name="tax_number" nullable="false" length="100" default=""/>
<column xsi:type="varchar" name="tax_type" nullable="false" length="100" default=""/>
<column xsi:type="varchar" name="tax_usage" nullable="false" length="100" default=""/>
<column xsi:type="varchar" name="export_compliance_statement" nullable="false" length="100" default=""/>
<column xsi:type="varchar" name="eori_number" nullable="false" length="100" default=""/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="varchar" name="region_id" nullable="false" length="20"/>
<column xsi:type="varchar" name="destination_type" nullable="false" length="15"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_ADDRESS_TITLE">
<column name="title"/>
</constraint>
<index referenceId="address_fulltext" indexType="fulltext">
<column name="title"/>
<column name="company_name"/>
<column name="attention_name"/>
<column name="phone"/>
<column name="region"/>
<column name="city"/>
<column name="postal_code"/>
<column name="address_line_1"/>
<column name="address_line_2"/>
</index>
</table>
<table name="extmag_shipper_account" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="200"/>
<column xsi:type="varchar" name="license" nullable="false" length="30"/>
<column xsi:type="varchar" name="user_id" nullable="false" length="100"/>
<column xsi:type="varchar" name="password" nullable="false" length="100"/>
<column xsi:type="varchar" name="shipper_number" nullable="false" length="30"/>
<column xsi:type="varchar" name="country_id" nullable="false" length="100" default=""/>
<column xsi:type="varchar" name="timezone" nullable="false" length="100" default=""/>
<column xsi:type="text" name="logo" nullable="false"/>
<column xsi:type="text" name="signature" nullable="false"/>
<column xsi:type="tinyint" name="mode" nullable="false" padding="2" unsigned="true" default="0" identity="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="20"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_UPS_ACCOUNT_TITLE">
<column name="title"/>
</constraint>
</table>
<table name="extmag_third_party" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="200"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="10"/>
<column xsi:type="varchar" name="account_number" nullable="false" length="32"/>
<column xsi:type="int" name="address_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_THIRD_PARTY_CARRIER_CODE_ACCOUNT_NUMBER_ADDRESS_ID">
<column name="carrier_code"/>
<column name="account_number"/>
<column name="address_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="EXTMAG_THIRD_PARTY_ADDRESS_ID_EXTMAG_ADDRESS_ENTITY_ID"
table="extmag_third_party" column="address_id" referenceTable="extmag_address"
referenceColumn="entity_id" onDelete="NO ACTION"/>
</table>
<table name="extmag_configuration_scope" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="int" name="store" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="int" name="direction" padding="10" unsigned="true" nullable="true" identity="false"/>
<column xsi:type="int" name="country" padding="10" unsigned="true" nullable="true" identity="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CONFIGURATION_SCOPE_STORE_DIRECTION_COUNTRY">
<column name="store"/>
<column name="direction"/>
<column name="country"/>
</constraint>
<constraint xsi:type="foreign" referenceId="FK_EC90477C63C18D9283DD819B755408F3"
table="extmag_configuration_scope" column="store" referenceTable="extmag_configuration_store"
referenceColumn="entity_id" onDelete="NO ACTION"/>
<constraint xsi:type="foreign" referenceId="FK_1AAE068A128238E852B2C344CD82CA39"
table="extmag_configuration_scope" column="direction"
referenceTable="extmag_configuration_direction" referenceColumn="entity_id" onDelete="NO ACTION"/>
<constraint xsi:type="foreign" referenceId="FK_099F897A2AAF9B2159162846401D8284"
table="extmag_configuration_scope" column="country" referenceTable="extmag_configuration_country"
referenceColumn="entity_id" onDelete="NO ACTION"/>
</table>
<table name="extmag_configuration_store" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="250"/>
<column xsi:type="text" name="stores_ids" nullable="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CONFIGURATION_STORE_TITLE">
<column name="title"/>
</constraint>
</table>
<table name="extmag_configuration_direction" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="250"/>
<column xsi:type="int" name="store_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="text" name="directions_ids" nullable="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CONFIGURATION_DIRECTION_TITLE">
<column name="title"/>
<column name="store_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="FK_BF9946877777A80C73E7EE68A2B88654"
table="extmag_configuration_direction" column="store_id" referenceTable="extmag_configuration_store"
referenceColumn="entity_id" onDelete="NO ACTION"/>
</table>
<table name="extmag_configuration_country" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="250"/>
<column xsi:type="int" name="direction_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="text" name="countries_ids" nullable="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CONFIGURATION_COUNTRY_TITLE">
<column name="title"/>
<column name="direction_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="FK_E385DB4313CB5ABBBB4E6E1E9AE1ABC9"
table="extmag_configuration_country" column="direction_id"
referenceTable="extmag_configuration_direction" referenceColumn="entity_id" onDelete="NO ACTION"/>
</table>
<table name="extmag_configuration" resource="default" engine="innodb">
<column xsi:type="int" name="config_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="scope" nullable="false" length="16" default="default"/>
<column xsi:type="int" name="scope_id" padding="10" unsigned="true" nullable="false" identity="false"
default="0"/>
<column xsi:type="varchar" name="path" nullable="false" length="255" default="general"/>
<column xsi:type="text" name="value" nullable="true"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="config_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CONFIGURATION_SCOPE_SCOPE_ID_PATH">
<column name="scope"/>
<column name="scope_id"/>
<column name="path"/>
</constraint>
</table>
<table name="extmag_dimension_box" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="250"/>
<column xsi:type="varchar" name="unit_weight" nullable="false" length="3"/>
<column xsi:type="varchar" name="unit_dimension" nullable="false" length="3"/>
<column xsi:type="decimal" name="max_weight" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="empty_weight" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="width" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="length" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="height" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="outer_width" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="outer_length" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="decimal" name="outer_height" scale="2" precision="7" unsigned="false" nullable="false"/>
<column xsi:type="tinyint" name="is_used_dimensions" padding="2" unsigned="true" nullable="false" identity="false"
default="0"/>
<column xsi:type="int" name="qty" padding="10" unsigned="true" nullable="false" identity="false"
default="99999999"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_DIMENSION_BOX_TITLE">
<column name="title"/>
</constraint>
</table>
<table name="extmag_create_label_cron" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="varchar" name="order_status" nullable="false" length="255" default="pending"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_CREATE_LABEL_CRON_ORDER_ID">
<column name="order_id"/>
</constraint>
</table>
<table name="extmag_pickup" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="25"/>
<column xsi:type="varchar" name="master_id" nullable="false" length="255" default=""
comment="Pickup Identification"/>
<column xsi:type="text" name="label_ids" nullable="false"/>
<column xsi:type="text" name="request" nullable="false"/>
<column xsi:type="text" name="response" nullable="false"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
</table>
<table name="extmag_shipping_methods" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="admin_title" nullable="false" length="255"/>
<column xsi:type="varchar" name="carrier" nullable="false" length="255"/><!-- ups, dhl, fedex, tnt -->
<column xsi:type="varchar" name="carrier_title" nullable="false" length="255" default=""/>
<column xsi:type="varchar" name="carrier_methods_type" nullable="false" length="255"/><!-- minprice, maxprice, specific, all -->
<column xsi:type="varchar" name="price" nullable="false"/>
<column xsi:type="text" name="carrier_methods" nullable="false"/>
<column xsi:type="mediumtext" name="conditions_serialized" nullable="false"/>
<column xsi:type="mediumtext" name="actions_serialized" nullable="false"/>
<column xsi:type="int" name="status" padding="2" unsigned="true" nullable="false" identity="false" default="0"/>
<column xsi:type="int" name="free_shipping" padding="2" unsigned="true" nullable="false" identity="false" default="0"/>
<column xsi:type="varchar" name="website_type" nullable="false" length="255" default="specific" comment="Website Type"/>
<column xsi:type="text" name="website_ids" nullable="false" comment="Website Ids"/>
<column xsi:type="varchar" name="customer_group_type" nullable="false" length="255" default="specific" comment="Customer Group Type"/>
<column xsi:type="text" name="customer_group_ids" nullable="false" comment="Customer Group Ids"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="int" name="carrier_discount" padding="2" unsigned="true" nullable="false" identity="false" default="0"/>
<column xsi:type="int" name="access_point" padding="2" unsigned="true" nullable="false" identity="false" default="0"/>
<column xsi:type="int" name="is_tit" padding="2" unsigned="true" nullable="false" identity="false" default="0"/><!-- is time in transit -->
<column xsi:type="varchar" name="tit_format" nullable="false" length="255"/><!-- Y.m.d H:i:s -->
<column xsi:type="varchar" name="tit_prefix" nullable="false" length="255"/>
<column xsi:type="varchar" name="tit_suffix" nullable="false" length="255"/>
<column xsi:type="varchar" name="area" nullable="false" default="all" length="50"/>
<column xsi:type="varchar" name="frequency" nullable="false" default="" length="50" comment="Frequency"/>
<column xsi:type="varchar" name="day_week" nullable="false" default="" length="90" comment="Days of Week"/>
<column xsi:type="timestamp" name="date_from" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="date_to" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"/>
<column xsi:type="text" name="logo" nullable="false"/>
<column xsi:type="mediumtext" name="price_rule_ids" nullable="false"/>
<column xsi:type="mediumtext" name="methods_names_mapping" nullable="false"/>
<column xsi:type="varchar" name="price_rules_apply" nullable="false" default="" length="50" comment="Apply Rules Types"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_SHIPPING_METHODS_UNIQUE_ADMIN_TITLE">
<column name="admin_title"/>
</constraint>
</table>
<table name="extmag_access_point" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"/>
<column xsi:type="varchar" name="order_increment_id" nullable="false" length="255"/>
<column xsi:type="varchar" name="name" nullable="false" length="255"/>
<column xsi:type="varchar" name="appuId" nullable="false" length="255"/>
<column xsi:type="varchar" name="carrier_code" nullable="false" length="50" default=""/>
<column xsi:type="varchar" name="addLine1" nullable="false" length="255"/>
<column xsi:type="varchar" name="addLine2" nullable="false" length="255"/>
<column xsi:type="varchar" name="addLine3" nullable="false" length="255"/>
<column xsi:type="varchar" name="city" nullable="false" length="255"/>
<column xsi:type="varchar" name="postal" nullable="false" length="255"/>
<column xsi:type="varchar" name="country" nullable="false" length="255"/>
<column xsi:type="varchar" name="state" nullable="false" length="255"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_ACCESS_POINT_ORDER_ID">
<column name="order_id"/>
</constraint>
</table>
<table name="extmag_shiplab_price_rules" resource="default" engine="innodb">
<column xsi:type="int" name="entity_id" padding="10" unsigned="true" nullable="false" identity="true"/>
<column xsi:type="varchar" name="title" nullable="false" length="255" default=""
comment="Title"/>
<column xsi:type="int" name="status" padding="11" unsigned="false" nullable="false" identity="false"
default="0"/>
<column xsi:type="mediumtext" name="conditions_serialized" nullable="false"/>
<column xsi:type="varchar" name="price" length="50" nullable="false" default=""/>
<column xsi:type="varchar" name="frequency" nullable="false" default="" length="50" comment="Frequency"/>
<column xsi:type="varchar" name="day_week" nullable="false" default="" length="90" comment="Days of Week"/>
<column xsi:type="timestamp" name="date_from" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="date_to" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="created_time" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP"/>
<column xsi:type="timestamp" name="updated_time" on_update="true" nullable="false"
default="CURRENT_TIMESTAMP"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="EXTMAG_SHIPLAB_PRICE_RULES_UNIQUE_TITLE">
<column name="title"/>
</constraint>
</table>
</schema>