/*
Navicat MySQL Data Transfer

Source Server         : seho
Source Server Version : 50726
Source Host           : localhost:3306
Source Database       : hotel

Target Server Type    : MYSQL
Target Server Version : 50726
File Encoding         : 65001

Date: 2020-10-13 11:08:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for hotel_move_ren
-- ----------------------------
DROP TABLE IF EXISTS `hotel_move_ren`;
CREATE TABLE `hotel_move_ren` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '添加入住人',
  `user_name` varchar(50) DEFAULT NULL,
  `user_num` varchar(50) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `status` varchar(5) DEFAULT '1' COMMENT '0离店1在住',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hotel_move_ren
-- ----------------------------
INSERT INTO `hotel_move_ren` VALUES ('191', '陈芳1', '芳姐1', '10085', '1');
INSERT INTO `hotel_move_ren` VALUES ('192', '陈芳2', '芳姐2', '10085', '1');
INSERT INTO `hotel_move_ren` VALUES ('193', '陈芳3', '芳姐3', '10085', '1');
INSERT INTO `hotel_move_ren` VALUES ('194', '易捷1', '街1', '1001', '1');
INSERT INTO `hotel_move_ren` VALUES ('195', '易捷2', '街12', '1001', '1');
INSERT INTO `hotel_move_ren` VALUES ('196', '大龙', '龙哥', '302', '1');
INSERT INTO `hotel_move_ren` VALUES ('197', '大老板1', 'lao板1', '301', '1');
INSERT INTO `hotel_move_ren` VALUES ('198', '大老板2', 'lao板2', '301', '1');