okayapi_opentrip_travel_product

-- MySQL Table okayapi_opentrip_travel_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_opentrip_travel_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `plan1_name` varchar(45) NULL COMMENT '',
    `plan1_price` int(11) NULL COMMENT '',
    `plan2_name` varchar(45) NULL COMMENT '',
    `plan2_price` int(11) NULL COMMENT '',
    `plan3_name` varchar(45) NULL COMMENT '',
    `plan3_price` int(11) NULL COMMENT '',
    `plan4_name` varchar(45) NULL COMMENT '',
    `plan4_price` int(11) NULL COMMENT '',
    `plan5_name` varchar(45) NULL COMMENT '',
    `plan5_price` int(11) NULL COMMENT '',
    `plan6_name` varchar(45) NULL COMMENT '',
    `plan6_price` int(11) NULL COMMENT '',
    `info_fee` int(11) NULL DEFAULT '0' COMMENT '信息费%',
    `discount` int(11) NULL DEFAULT '0' COMMENT '优惠额%',
    `category_id` int(10) NULL COMMENT '所属分类ID',
    `admin_id` int(10) NULL DEFAULT '1' COMMENT '管理员id',
    `sn` varchar(25) NULL COMMENT '商品编号',
    `okayapi_opentrip_travel_product_name` varchar(40) NULL COMMENT '商品名',
    `price` int(11) NULL COMMENT '价格',
    `stock` int(10) NULL COMMENT '库存量',
    `thumb` varchar(150) NULL COMMENT '预览图',
    `pic1` varchar(150) NULL COMMENT '',
    `pic2` varchar(150) NULL COMMENT '',
    `pic3` varchar(150) NULL COMMENT '',
    `pic4` varchar(150) NULL COMMENT '',
    `pic5` varchar(150) NULL COMMENT '',
    `on_sale` enum('yes','no') NULL DEFAULT 'no' COMMENT '是否上架',
    `recommend` enum('yes','no') NULL DEFAULT 'no' COMMENT '是否推荐',
    `okayapi_opentrip_travel_product_desc` text NULL COMMENT '产品详情',
    `travel_ref` text NULL COMMENT '行程参考',
    `cost_desc` text NULL COMMENT '费用说明',
    `reserve_notice` text NULL COMMENT '预定须知',
    `okayapi_opentrip_travel_product_restrict` text NULL COMMENT '改退规定',
    `info` text NULL COMMENT '问题咨询',
    `recycle` enum('yes','no') NULL DEFAULT 'no' COMMENT '是否删除',
    `highlight1` varchar(45) NULL COMMENT '亮点',
    `highlight2` varchar(45) NULL COMMENT '',
    `highlight3` varchar(45) NULL COMMENT '',
    `confirm` enum('yes','no') NULL DEFAULT 'yes' COMMENT '二次确认',
    `okayapi_opentrip_travel_product_language` varchar(45) NULL COMMENT '服务语言',
    `continent` varchar(45) NULL COMMENT '洲',
    `country` varchar(45) NULL COMMENT '',
    `city` varchar(45) NULL COMMENT '',
    `okayapi_opentrip_travel_product_start` varchar(45) NULL COMMENT '出发地',
    `path` varchar(45) NULL COMMENT '途径',
    `okayapi_opentrip_travel_product_end` varchar(45) NULL COMMENT '目的地',
    `detail_property` varchar(45) NULL COMMENT '细分属性',
    `market_price` varchar(45) NULL COMMENT '市场价，门市价',
    `child_price` varchar(45) NULL COMMENT '',
    `deposit` varchar(45) NULL COMMENT '定金',
    `promotion` varchar(45) NULL COMMENT '促销活动',
    `start_time` varchar(45) NULL COMMENT '出游日期',
    `people` varchar(45) NULL COMMENT '出游人群',
    `days` varchar(45) NULL COMMENT '行程天数',
    `place_of_issue` varchar(45) NULL COMMENT '签发地（签证专用）',
    `visa_type` varchar(45) NULL COMMENT '签证类型',
    `sent_visa_place` varchar(45) NULL COMMENT '送签地',
    `ship_depart_city` varchar(45) NULL COMMENT '邮轮出发城市',
    `ship_route` varchar(45) NULL COMMENT '邮轮航线',
    `ship_company` varchar(45) NULL COMMENT '邮轮公司',
    `ship_name` varchar(45) NULL COMMENT '船名',
    `ship_depart_time` varchar(45) NULL COMMENT '邮轮出发日期',
    KEY `plan1_name` (`plan1_name`),
    KEY `plan1_price` (`plan1_price`),
    KEY `plan2_name` (`plan2_name`),
    KEY `plan2_price` (`plan2_price`),
    KEY `plan3_name` (`plan3_name`),
    KEY `plan3_price` (`plan3_price`),
    KEY `plan4_name` (`plan4_name`),
    KEY `plan4_price` (`plan4_price`),
    KEY `plan5_name` (`plan5_name`),
    KEY `plan5_price` (`plan5_price`),
    KEY `plan6_name` (`plan6_name`),
    KEY `plan6_price` (`plan6_price`),
    KEY `info_fee` (`info_fee`),
    KEY `discount` (`discount`),
    KEY `category_id` (`category_id`),
    KEY `admin_id` (`admin_id`),
    KEY `sn` (`sn`),
    KEY `okayapi_opentrip_travel_product_name` (`okayapi_opentrip_travel_product_name`),
    KEY `price` (`price`),
    KEY `stock` (`stock`),
    KEY `thumb` (`thumb`),
    KEY `pic1` (`pic1`),
    KEY `pic2` (`pic2`),
    KEY `pic3` (`pic3`),
    KEY `pic4` (`pic4`),
    KEY `pic5` (`pic5`),
    KEY `on_sale` (`on_sale`),
    KEY `recommend` (`recommend`),
    KEY `okayapi_opentrip_travel_product_desc` (`okayapi_opentrip_travel_product_desc`),
    KEY `travel_ref` (`travel_ref`),
    KEY `cost_desc` (`cost_desc`),
    KEY `reserve_notice` (`reserve_notice`),
    KEY `okayapi_opentrip_travel_product_restrict` (`okayapi_opentrip_travel_product_restrict`),
    KEY `info` (`info`),
    KEY `recycle` (`recycle`),
    KEY `highlight1` (`highlight1`),
    KEY `highlight2` (`highlight2`),
    KEY `highlight3` (`highlight3`),
    KEY `confirm` (`confirm`),
    KEY `okayapi_opentrip_travel_product_language` (`okayapi_opentrip_travel_product_language`),
    KEY `continent` (`continent`),
    KEY `country` (`country`),
    KEY `city` (`city`),
    KEY `okayapi_opentrip_travel_product_start` (`okayapi_opentrip_travel_product_start`),
    KEY `path` (`path`),
    KEY `okayapi_opentrip_travel_product_end` (`okayapi_opentrip_travel_product_end`),
    KEY `detail_property` (`detail_property`),
    KEY `market_price` (`market_price`),
    KEY `child_price` (`child_price`),
    KEY `deposit` (`deposit`),
    KEY `promotion` (`promotion`),
    KEY `start_time` (`start_time`),
    KEY `people` (`people`),
    KEY `days` (`days`),
    KEY `place_of_issue` (`place_of_issue`),
    KEY `visa_type` (`visa_type`),
    KEY `sent_visa_place` (`sent_visa_place`),
    KEY `ship_depart_city` (`ship_depart_city`),
    KEY `ship_route` (`ship_route`),
    KEY `ship_company` (`ship_company`),
    KEY `ship_name` (`ship_name`),
    KEY `ship_depart_time` (`ship_depart_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '轻量旅游电商-产品';

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