okayapi_landi_guest

-- MySQL Table okayapi_landi_guest
-- From: OkayAPI.com
CREATE TABLE `okayapi_landi_guest` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `guest_name` varchar(64) NULL COMMENT '',
    `room_number` varchar(64) NULL COMMENT '',
    `room_type` varchar(64) NULL COMMENT '',
    `contract_number` varchar(64) NULL COMMENT '',
    `tel` varchar(64) NULL COMMENT '',
    `company` varchar(64) NULL COMMENT '',
    `title` varchar(64) NULL COMMENT '',
    `persons` int(11) NULL COMMENT '',
    `coming` int(11) NULL COMMENT '',
    `parking` varchar(64) NULL COMMENT '',
    `car` varchar(64) NULL COMMENT '',
    `okayapi_landi_guest_comment` varchar(256) NULL COMMENT '',
    `charge` double NULL COMMENT '',
    `timein` datetime NULL COMMENT '',
    `timeout` datetime NULL COMMENT '',
    `sys_state` int(11) NULL DEFAULT '1' COMMENT '正在入住0  历史入住1',
    `other_guests` varchar(255) NULL COMMENT '',
    `guest_type` varchar(255) NULL COMMENT '',
    `birthday` date NULL COMMENT '',
    `email` varchar(64) NULL COMMENT '',
    `company_contactor` varchar(64) NULL COMMENT '',
    `company_tel` varchar(64) NULL COMMENT '',
    `company_account` varchar(64) NULL COMMENT '',
    `company_invoice` varchar(64) NULL COMMENT '',
    `company_paymode` varchar(64) NULL COMMENT '',
    KEY `guest_name` (`guest_name`),
    KEY `room_number` (`room_number`),
    KEY `room_type` (`room_type`),
    KEY `contract_number` (`contract_number`),
    KEY `tel` (`tel`),
    KEY `company` (`company`),
    KEY `title` (`title`),
    KEY `persons` (`persons`),
    KEY `coming` (`coming`),
    KEY `parking` (`parking`),
    KEY `car` (`car`),
    KEY `okayapi_landi_guest_comment` (`okayapi_landi_guest_comment`),
    KEY `charge` (`charge`),
    KEY `timein` (`timein`),
    KEY `timeout` (`timeout`),
    KEY `sys_state` (`sys_state`),
    KEY `other_guests` (`other_guests`),
    KEY `guest_type` (`guest_type`),
    KEY `birthday` (`birthday`),
    KEY `email` (`email`),
    KEY `company_contactor` (`company_contactor`),
    KEY `company_tel` (`company_tel`),
    KEY `company_account` (`company_account`),
    KEY `company_invoice` (`company_invoice`),
    KEY `company_paymode` (`company_paymode`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'LD酒店租房管理-访客';

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