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.
79 lines
3.3 KiB
79 lines
3.3 KiB
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost111
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80031
|
|
Source Host : localhost:3306
|
|
Source Schema : chengxu
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80031
|
|
File Encoding : 65001
|
|
|
|
Date: 20/05/2024 11:20:26
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_ad
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_ad`;
|
|
CREATE TABLE `t_ad` (
|
|
`ad_id` int NOT NULL AUTO_INCREMENT,
|
|
`ad_acc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`ad_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
|
`ad_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`ad_id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_ad
|
|
-- ----------------------------
|
|
INSERT INTO `t_ad` VALUES (1, 'admin', 'admin','张三');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_commode
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_commode`;
|
|
CREATE TABLE `t_commode` (
|
|
`commod_id` int NOT NULL AUTO_INCREMENT,
|
|
`commod_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
|
`commod_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
|
`commode_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '品牌',
|
|
`commode_pro` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '产地',
|
|
`commode_num` int NULL DEFAULT NULL,
|
|
`commode_jinjia` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
|
`commode_shoujia` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`commod_id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_commode
|
|
-- ----------------------------
|
|
INSERT INTO `t_commode` VALUES (1, '水果', '苹果', '红富士', '河北', 50, '10', '100');
|
|
INSERT INTO `t_commode` VALUES (3, '水果', '栗子', '好厉害', '河北', 800, '80', '90');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user`;
|
|
CREATE TABLE `t_user` (
|
|
`user_id` int NOT NULL AUTO_INCREMENT,
|
|
`user_acc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`user_pass` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`user_sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`user_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`user_id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user
|
|
-- ----------------------------
|
|
INSERT INTO `t_user` VALUES (1, '123', '456','李四','女','10086');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|