/*
 Navicat Premium Data Transfer

 Source Server         : test_app
 Source Server Type    : MySQL
 Source Server Version : 80019 (8.0.19)
 Source Host           : localhost:3306
 Source Schema         : node

 Target Server Type    : MySQL
 Target Server Version : 80019 (8.0.19)
 File Encoding         : 65001

 Date: 22/11/2024 11:25:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for node_banners
-- ----------------------------
DROP TABLE IF EXISTS `node_banners`;
CREATE TABLE `node_banners`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `bannername` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '轮播图名称',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '轮播图名称',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `bannername`(`bannername` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of node_banners
-- ----------------------------
INSERT INTO `node_banners` VALUES (2, '张三', 'http://127.0.0.1:8000/2856b1aabfa22c3154add5700.gif', '2024-08-13 01:45:23', '2024-08-13 01:45:23');
INSERT INTO `node_banners` VALUES (3, '对的', 'http://127.0.0.1:8000/2856b1aabfa22c3154add5701.png', '2024-08-13 01:56:40', '2024-08-13 01:56:40');
INSERT INTO `node_banners` VALUES (4, '222', 'http://127.0.0.1:8000/2856b1aabfa22c3154add5706.png', '2024-08-13 02:06:16', '2024-08-13 02:09:54');
INSERT INTO `node_banners` VALUES (5, '66', 'http://127.0.0.1:8000/920d1ec7c51a31660bf8a4903.png', '2024-08-23 02:54:51', '2024-08-23 02:54:51');

-- ----------------------------
-- Table structure for node_goods
-- ----------------------------
DROP TABLE IF EXISTS `node_goods`;
CREATE TABLE `node_goods`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `goodsname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名',
  `goodsprice` decimal(10, 2) NOT NULL COMMENT '价格',
  `goodsnum` int NOT NULL COMMENT '商品库存',
  `goodsimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品图片',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `goodsdesc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `goodsname`(`goodsname` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of node_goods
-- ----------------------------
INSERT INTO `node_goods` VALUES (1, 'css', 50.00, 20, 'http://127.0.0.1:8000/f12b4e2ec20ecb66a0cf13e03.jpg', '2024-08-09 08:18:35', '2024-08-23 01:56:24', '口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的口感是很棒的');
INSERT INTO `node_goods` VALUES (2, '鸡哥', 29.90, 2, 'http://127.0.0.1:8000/920d1ec7c51a31660bf8a4902.png', '2024-08-23 02:17:42', '2024-08-23 02:17:42', '喜欢唱跳rap篮球');

-- ----------------------------
-- Table structure for node_news
-- ----------------------------
DROP TABLE IF EXISTS `node_news`;
CREATE TABLE `node_news`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `newsname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '新闻标题',
  `newsdesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '新闻内容',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of node_news
-- ----------------------------

-- ----------------------------
-- Table structure for node_users
-- ----------------------------
DROP TABLE IF EXISTS `node_users`;
CREATE TABLE `node_users`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名,唯一',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `is_admin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是管理员,0不是管理员,1是管理员',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of node_users
-- ----------------------------
INSERT INTO `node_users` VALUES (1, 'admin', '$2a$10$oGu.J3V.JzvImabMClim4.rasfAPQcyPgurJloRa4lOnAjonBVjAS', 1, '2024-07-25 06:46:02', '2024-07-25 06:46:02', '');
INSERT INTO `node_users` VALUES (2, 'zhangsan', '$2a$10$cgyfzTOTimYegdtM50w5Qeb6SNCZFCG7rQ3HVae2bKZB.RHU1NxLi', 0, '2024-07-25 06:46:20', '2024-07-25 06:46:20', '');

SET FOREIGN_KEY_CHECKS = 1;