/*
 Navicat Premium Data Transfer

 Source Server         : first
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : test01

 Target Server Type    : MySQL
 Target Server Version : 80012
 File Encoding         : 65001

 Date: 04/07/2023 19:54:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for album
-- ----------------------------
DROP TABLE IF EXISTS `album`;
CREATE TABLE `album`  (
  `album_id` int(11) NOT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `akind_id` int(11) NULL DEFAULT NULL,
  `album_name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `album_dis` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `album_type` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `photos_num` int(11) NULL DEFAULT NULL,
  `photos_max` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`album_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of album
-- ----------------------------
INSERT INTO `album` VALUES (1, 111, 1, '小狗', '第一个相册', '普通', 22, 100);
INSERT INTO `album` VALUES (2, 111, 2, '小猫', '第二个相册', '普通', 12, 100);
INSERT INTO `album` VALUES (3, 111, 3, '放大假', '第三个相册', 'VIP', 44, 100);

-- ----------------------------
-- Table structure for kind
-- ----------------------------
DROP TABLE IF EXISTS `kind`;
CREATE TABLE `kind`  (
  `kind_id` int(11) NULL DEFAULT NULL,
  `kind_name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of kind
-- ----------------------------
INSERT INTO `kind` VALUES (1, '人物');
INSERT INTO `kind` VALUES (2, '动物');
INSERT INTO `kind` VALUES (3, '风景');

-- ----------------------------
-- Table structure for photos
-- ----------------------------
DROP TABLE IF EXISTS `photos`;
CREATE TABLE `photos`  (
  `photos_id` bigint(20) NOT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `album_id` int(11) NULL DEFAULT NULL,
  `photos_kind` int(11) NULL DEFAULT NULL,
  `photos_type` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `photos_name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `photos_dis` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `uplode_time` date NULL DEFAULT NULL,
  `revise_time` date NULL DEFAULT NULL,
  `wide` int(11) NULL DEFAULT NULL,
  `hight` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`photos_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of photos
-- ----------------------------
INSERT INTO `photos` VALUES (1, 111, 1, 1, '正常', '小猫', '第一次实现', '2023-07-02', '2023-07-05', 480, 960);
INSERT INTO `photos` VALUES (2, 111, 1, 1, '正常', '小狗', '第二次实现', '2023-07-03', '2023-07-06', 480, 960);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL,
  `password` int(8) NULL DEFAULT NULL,
  `user_name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_kind` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `enroll_time` date NULL DEFAULT NULL,
  `photos_num` int(11) NULL DEFAULT NULL,
  `album_num` int(11) NULL DEFAULT NULL,
  `surplus` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (111, 123, '汪宇', 'admin', '2023-07-02', 0, 0, 0);
INSERT INTO `user` VALUES (112, 123, '魏子征', 'user', '2023-07-05', 0, 0, 100);
INSERT INTO `user` VALUES (113, 123, '柴苗青', 'user', '2023-07-03', 0, 0, 300);

-- ----------------------------
-- Table structure for user_manage
-- ----------------------------
DROP TABLE IF EXISTS `user_manage`;
CREATE TABLE `user_manage`  (
  `user_id` int(11) NOT NULL,
  `user_name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_state` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cum_recharge` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of user_manage
-- ----------------------------
INSERT INTO `user_manage` VALUES (111, '魏子征', '正常', 300);
INSERT INTO `user_manage` VALUES (112, '柴苗青', '封禁', 200);

SET FOREIGN_KEY_CHECKS = 1;