Unity家装设计（前后台分离

/* Navicat MySQL Data Transfer Source Server : lagoon Source Server Version : 50710 Source Host : localhost:3306 Source Database : unity Target Server Type : MYSQL Target Server Version : 50710 File Encoding : 65001 Date: 2019-02-22 15:39:48 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for all_room_data -- ---------------------------- DROP TABLE IF EXISTS `all_room_data`; CREATE TABLE `all_room_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `room_text` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of all_room_data -- ---------------------------- INSERT INTO `all_room_data` VALUES ('1', 'bedroom'); -- ---------------------------- -- Table structure for furniture_data -- ---------------------------- DROP TABLE IF EXISTS `furniture_data`; CREATE TABLE `furniture_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_id` int(11) DEFAULT NULL, `furniture_text` varchar(255) DEFAULT NULL, `object_name` varchar(255) DEFAULT NULL, `spawn_height` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of furniture_data -- ---------------------------- INSERT INTO `furniture_data` VALUES ('1', '4', 'chair1', 'chair', '0'); -- ---------------------------- -- Table structure for type_data -- ---------------------------- DROP TABLE IF EXISTS `type_data`; CREATE TABLE `type_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_text` varchar(255) DEFAULT NULL, `room_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of type_data -- ---------------------------- INSERT INTO `type_data` VALUES ('1', 'bed', '1'); INSERT INTO `type_data` VALUES ('2', 'light', '1'); INSERT INTO `type_data` VALUES ('3', 'desk', '1'); INSERT INTO `type_data` VALUES ('4', 'chair', '1'); INSERT INTO `type_data` VALUES ('5', 'wrdrb', '1'); INSERT INTO `type_data` VALUES ('6', 'ground', '1');