okayapi_landi_drinking_water

-- MySQL Table okayapi_landi_drinking_water
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_drinking_water` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `room_num` varchar(64) NULL COMMENT '',
    `guest_id` int(11) NULL COMMENT '',
    `guest_name` varchar(64) NULL COMMENT '',
    `barrel_count` int(11) NULL DEFAULT '0' COMMENT '桶装水数量',
    `barrel_remaincount` int(11) NULL DEFAULT '0' COMMENT '',
    `barrel_limitcount` int(11) NULL COMMENT '桶装水限额',
    `barrel_unitprice` double NULL DEFAULT '0' COMMENT '',
    `bottle_count` int(11) NULL DEFAULT '0' COMMENT '瓶装矿泉水（提）数量',
    `bottle_remaincount` int(11) NULL COMMENT '',
    `bottle_limitcount` int(11) NULL COMMENT '瓶装矿泉水（提）限额',
    `bottle_unitprice` double NULL COMMENT '',
    `excess_price` double NULL COMMENT '超出限额数量的总金额',
    `pay_mode` tinyint(3) NULL COMMENT '支付方式（现金0 月结1）',
    `okayapi_landi_drinking_water_comment` varchar(64) NULL COMMENT '',
    `staff_id` int(11) NULL COMMENT '',
    `staff_name` varchar(64) NULL COMMENT '',
    `occur_time` datetime NULL COMMENT '',
    `import_time` datetime NULL COMMENT '',
    `edit_time` datetime NULL COMMENT '',
    KEY `room_num` (`room_num`),
    KEY `guest_id` (`guest_id`),
    KEY `guest_name` (`guest_name`),
    KEY `barrel_count` (`barrel_count`),
    KEY `barrel_remaincount` (`barrel_remaincount`),
    KEY `barrel_limitcount` (`barrel_limitcount`),
    KEY `barrel_unitprice` (`barrel_unitprice`),
    KEY `bottle_count` (`bottle_count`),
    KEY `bottle_remaincount` (`bottle_remaincount`),
    KEY `bottle_limitcount` (`bottle_limitcount`),
    KEY `bottle_unitprice` (`bottle_unitprice`),
    KEY `excess_price` (`excess_price`),
    KEY `pay_mode` (`pay_mode`),
    KEY `okayapi_landi_drinking_water_comment` (`okayapi_landi_drinking_water_comment`),
    KEY `staff_id` (`staff_id`),
    KEY `staff_name` (`staff_name`),
    KEY `occur_time` (`occur_time`),
    KEY `import_time` (`import_time`),
    KEY `edit_time` (`edit_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-酒水';

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