You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
86 lines
3.1 KiB
86 lines
3.1 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : Mysql
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80026
|
|
Source Host : localhost:3306
|
|
Source Schema : jiudianmanage
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80026
|
|
File Encoding : 65001
|
|
|
|
Date: 20/10/2021 18:46:26
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for config
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `config`;
|
|
CREATE TABLE `config` (
|
|
`id` int NOT NULL,
|
|
`managesalary` double(10, 2) NULL DEFAULT NULL,
|
|
`staffsalary` double(10, 2) NULL DEFAULT NULL,
|
|
`cleanerssalary` double(10, 2) NULL DEFAULT NULL,
|
|
`manage` double(10, 2) NULL DEFAULT NULL,
|
|
`staff` double(10, 2) NULL DEFAULT NULL,
|
|
`cleaner` double(10, 2) NULL DEFAULT NULL,
|
|
`totalmoney` double(10, 2) NULL DEFAULT NULL,
|
|
`totalroom` double(10, 2) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for order
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `order`;
|
|
CREATE TABLE `order` (
|
|
`orderid` int NOT NULL,
|
|
`householdname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`ID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`starttime` datetime NULL DEFAULT NULL,
|
|
`endtime` datetime NULL DEFAULT NULL,
|
|
`money` double NULL DEFAULT NULL,
|
|
`state` int NULL DEFAULT NULL,
|
|
`roomid` int NULL DEFAULT NULL,
|
|
`userid` int NULL DEFAULT NULL,
|
|
PRIMARY KEY (`orderid`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for room
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `room`;
|
|
CREATE TABLE `room` (
|
|
`roomid` int NOT NULL,
|
|
`local` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`money` double NULL DEFAULT NULL,
|
|
`state` int NULL DEFAULT NULL,
|
|
`type` int NULL DEFAULT NULL,
|
|
PRIMARY KEY (`roomid`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user`;
|
|
CREATE TABLE `user` (
|
|
`userid` int NOT NULL,
|
|
`useraccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`age` int NULL DEFAULT NULL,
|
|
`power` int NULL DEFAULT NULL,
|
|
`IDnumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`money` double NULL DEFAULT NULL,
|
|
`photoUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`phonenumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`userid`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|