okayapi_openant_order

-- MySQL Table okayapi_openant_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_id` int(11) NOT NULL COMMENT '',
    `invoice_no` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `invoice_prefix` varchar(26) NOT NULL COMMENT '',
    `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `user_class_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `firstname` varchar(32) NOT NULL COMMENT '',
    `lastname` varchar(32) NOT NULL COMMENT '',
    `email` varchar(96) NOT NULL COMMENT '',
    `telephone` varchar(32) NOT NULL COMMENT '',
    `payment_firstname` varchar(32) NOT NULL COMMENT '',
    `payment_lastname` varchar(32) NOT NULL COMMENT '',
    `payment_address` varchar(128) NOT NULL COMMENT '',
    `payment_city` varchar(128) NOT NULL COMMENT '',
    `payment_postcode` varchar(10) NOT NULL COMMENT '',
    `payment_country` varchar(128) NOT NULL COMMENT '',
    `payment_country_id` int(11) NOT NULL COMMENT '',
    `payment_zone` varchar(128) NOT NULL COMMENT '',
    `payment_zone_id` int(11) NOT NULL COMMENT '',
    `payment_address_format` text NOT NULL COMMENT '',
    `payment_method` varchar(128) NOT NULL COMMENT '',
    `payment_code` varchar(128) NOT NULL COMMENT '',
    `shipping_firstname` varchar(32) NOT NULL COMMENT '',
    `shipping_lastname` varchar(32) NOT NULL COMMENT '',
    `shipping_address` varchar(128) NOT NULL COMMENT '',
    `shipping_city` varchar(128) NOT NULL COMMENT '',
    `shipping_postcode` varchar(10) NOT NULL COMMENT '',
    `shipping_country` varchar(128) NOT NULL COMMENT '',
    `shipping_country_id` int(11) NOT NULL COMMENT '',
    `shipping_zone` varchar(128) NOT NULL COMMENT '',
    `shipping_zone_id` int(11) NOT NULL COMMENT '',
    `shipping_address_format` text NOT NULL COMMENT '',
    `shipping_method` varchar(128) NOT NULL COMMENT '',
    `shipping_code` varchar(128) NOT NULL COMMENT '',
    `okayapi_openant_order_comment` text NOT NULL COMMENT '',
    `total` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `order_status_id` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `affiliate_id` int(11) NOT NULL COMMENT '',
    `commission` decimal(15,4) NOT NULL COMMENT '',
    `marketing_id` int(11) NOT NULL COMMENT '',
    `tracking` varchar(64) NOT NULL COMMENT '',
    `language_id` int(11) NOT NULL COMMENT '',
    `currency_id` int(11) NOT NULL COMMENT '',
    `currency_code` varchar(3) NOT NULL COMMENT '',
    `currency_value` decimal(15,8) NOT NULL DEFAULT '1.00000000' COMMENT '',
    `ip` varchar(40) NOT NULL COMMENT '',
    `forwarded_ip` varchar(40) NOT NULL COMMENT '',
    `user_agent` varchar(255) NOT NULL COMMENT '',
    `accept_language` varchar(255) NOT NULL COMMENT '',
    `logistic` varchar(28) NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    KEY `order_id` (`order_id`),
    KEY `invoice_no` (`invoice_no`),
    KEY `invoice_prefix` (`invoice_prefix`),
    KEY `store_id` (`store_id`),
    KEY `user_id` (`user_id`),
    KEY `user_class_id` (`user_class_id`),
    KEY `firstname` (`firstname`),
    KEY `lastname` (`lastname`),
    KEY `email` (`email`),
    KEY `telephone` (`telephone`),
    KEY `payment_firstname` (`payment_firstname`),
    KEY `payment_lastname` (`payment_lastname`),
    KEY `payment_address` (`payment_address`),
    KEY `payment_city` (`payment_city`),
    KEY `payment_postcode` (`payment_postcode`),
    KEY `payment_country` (`payment_country`),
    KEY `payment_country_id` (`payment_country_id`),
    KEY `payment_zone` (`payment_zone`),
    KEY `payment_zone_id` (`payment_zone_id`),
    KEY `payment_address_format` (`payment_address_format`),
    KEY `payment_method` (`payment_method`),
    KEY `payment_code` (`payment_code`),
    KEY `shipping_firstname` (`shipping_firstname`),
    KEY `shipping_lastname` (`shipping_lastname`),
    KEY `shipping_address` (`shipping_address`),
    KEY `shipping_city` (`shipping_city`),
    KEY `shipping_postcode` (`shipping_postcode`),
    KEY `shipping_country` (`shipping_country`),
    KEY `shipping_country_id` (`shipping_country_id`),
    KEY `shipping_zone` (`shipping_zone`),
    KEY `shipping_zone_id` (`shipping_zone_id`),
    KEY `shipping_address_format` (`shipping_address_format`),
    KEY `shipping_method` (`shipping_method`),
    KEY `shipping_code` (`shipping_code`),
    KEY `okayapi_openant_order_comment` (`okayapi_openant_order_comment`),
    KEY `total` (`total`),
    KEY `order_status_id` (`order_status_id`),
    KEY `affiliate_id` (`affiliate_id`),
    KEY `commission` (`commission`),
    KEY `marketing_id` (`marketing_id`),
    KEY `tracking` (`tracking`),
    KEY `language_id` (`language_id`),
    KEY `currency_id` (`currency_id`),
    KEY `currency_code` (`currency_code`),
    KEY `currency_value` (`currency_value`),
    KEY `ip` (`ip`),
    KEY `forwarded_ip` (`forwarded_ip`),
    KEY `user_agent` (`user_agent`),
    KEY `accept_language` (`accept_language`),
    KEY `logistic` (`logistic`),
    KEY `date_added` (`date_added`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-订单';

After replication, you can go to the database to create the database table.