/*
 Navicat Premium Data Transfer

 Source Server         : LocalMySQL
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : universefarm

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

 Date: 06/01/2022 15:15:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for farminfo
-- ----------------------------
DROP TABLE IF EXISTS `farminfo`;
CREATE TABLE `farminfo`  (
  `farm_id` int NOT NULL,
  `soil_id` int NOT NULL,
  PRIMARY KEY (`farm_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of farminfo
-- ----------------------------

-- ----------------------------
-- Table structure for furitinfo
-- ----------------------------
DROP TABLE IF EXISTS `furitinfo`;
CREATE TABLE `furitinfo`  (
  `fruit_id` int NOT NULL AUTO_INCREMENT,
  `fruit_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `fruit_userid` int NOT NULL,
  `fruit_status` int NOT NULL,
  `furti_ maturity` int NOT NULL,
  `fruit_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`fruit_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of furitinfo
-- ----------------------------

-- ----------------------------
-- Table structure for orderinfo
-- ----------------------------
DROP TABLE IF EXISTS `orderinfo`;
CREATE TABLE `orderinfo`  (
  `order_id` int NOT NULL AUTO_INCREMENT COMMENT '订单编号',
  `order_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单名称',
  `order_time` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单结算时间',
  `order_status` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态(未接单，已配送，未配送，已完成）',
  `user_id` int NOT NULL COMMENT '用户编号',
  `order_number` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单内食物总数量',
  `order_money` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单总金额',
  PRIMARY KEY (`order_id`) USING BTREE,
  INDEX `USER_ID`(`user_id`) USING BTREE,
  CONSTRAINT `orderinfo_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `userinfo` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 120 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' ' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of orderinfo
-- ----------------------------
INSERT INTO `orderinfo` VALUES (1, 'J1763848', '2020-01-18-15:49', '已配送', 4, '4', '46');
INSERT INTO `orderinfo` VALUES (2, 'A0254545', '2020-02-15-13:36', '已配送', 1, '1', '13');
INSERT INTO `orderinfo` VALUES (3, 'B1287832', '2020-09-23-17:35', '未配送', 3, '2', '29');
INSERT INTO `orderinfo` VALUES (4, 'A1212313', '2021-01-23-11:23', '未配送', 3, '11', '290');
INSERT INTO `orderinfo` VALUES (5, 'B8848431', '2021-02-16-16:29', '已配送', 1, '2', '25');
INSERT INTO `orderinfo` VALUES (6, 'D1591509', '2021-03-02-19:48', '已配送', 2, '2', '30');
INSERT INTO `orderinfo` VALUES (7, 'D8984748', '2021-04-11-19:32', '未配送', 5, '3', '37');
INSERT INTO `orderinfo` VALUES (8, 'A1354812', '2021-04-17-15:13', '未配送', 5, '2', '18');
INSERT INTO `orderinfo` VALUES (117, 'H2138362', '2021-12-31 15:45', '未配送', 19, '3', '25');
INSERT INTO `orderinfo` VALUES (118, 'W5203006', '2021-12-31 15:47', '未配送', 19, '1', '11');
INSERT INTO `orderinfo` VALUES (119, 'M4931110', '2021-12-31 16:15', '未配送', 2, '2', '4');
INSERT INTO `orderinfo` VALUES (120, 'R2957789', '2021-12-31 16:24', '未配送', 2, '1', '11');
INSERT INTO `orderinfo` VALUES (121, 'K7742898', '2022-01-06 14:45', '未配送', 21, '1', '11');
INSERT INTO `orderinfo` VALUES (122, 'C6817463', '2022-01-06 14:46', '未配送', 21, '2', '22');
INSERT INTO `orderinfo` VALUES (123, 'C4398111', '2022-01-06 15:02', '未配送', 23, '1', '11');

-- ----------------------------
-- Table structure for orderitem
-- ----------------------------
DROP TABLE IF EXISTS `orderitem`;
CREATE TABLE `orderitem`  (
  `orderitem_id` int NOT NULL AUTO_INCREMENT COMMENT '单种菜品对应的编号',
  `order_id` int NOT NULL COMMENT '单种菜品对应的所在订单号',
  `soil_id` int NOT NULL COMMENT '单种菜品对应的菜品编号',
  `orderitem_number` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单种菜品所对应的数量',
  `orderitem_money` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单种菜品所对应的金额',
  PRIMARY KEY (`orderitem_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 138 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of orderitem
-- ----------------------------
INSERT INTO `orderitem` VALUES (1, 1, 2, '3', '33');
INSERT INTO `orderitem` VALUES (2, 1, 1, '1', '13');
INSERT INTO `orderitem` VALUES (3, 2, 21, '1', '13');
INSERT INTO `orderitem` VALUES (4, 3, 41, '1', '13');
INSERT INTO `orderitem` VALUES (5, 3, 42, '1', '16');
INSERT INTO `orderitem` VALUES (6, 4, 67, '10', '260');
INSERT INTO `orderitem` VALUES (7, 4, 69, '1', '30');
INSERT INTO `orderitem` VALUES (8, 5, 51, '1', '18');
INSERT INTO `orderitem` VALUES (9, 5, 52, '1', '7');
INSERT INTO `orderitem` VALUES (10, 6, 34, '2', '30');
INSERT INTO `orderitem` VALUES (11, 7, 56, '1', '14');
INSERT INTO `orderitem` VALUES (12, 7, 57, '1', '15');
INSERT INTO `orderitem` VALUES (13, 7, 58, '1', '8');
INSERT INTO `orderitem` VALUES (14, 8, 11, '2', '18');
INSERT INTO `orderitem` VALUES (15, 9, 19, '1', '12');
INSERT INTO `orderitem` VALUES (16, 9, 20, '1', '14');
INSERT INTO `orderitem` VALUES (17, 10, 64, '1', '6666');
INSERT INTO `orderitem` VALUES (30, 27, 3, '2', '30');
INSERT INTO `orderitem` VALUES (31, 27, 8, '1', '6');
INSERT INTO `orderitem` VALUES (32, 28, 3, '2', '30');
INSERT INTO `orderitem` VALUES (33, 28, 8, '1', '6');
INSERT INTO `orderitem` VALUES (34, 35, 65, '1', '8888');
INSERT INTO `orderitem` VALUES (35, 36, 35, '1', '15');
INSERT INTO `orderitem` VALUES (36, 36, 37, '1', '18');
INSERT INTO `orderitem` VALUES (81, 75, 71, '1', '69');
INSERT INTO `orderitem` VALUES (82, 75, 77, '1', '39');
INSERT INTO `orderitem` VALUES (83, 76, 71, '1', '69');
INSERT INTO `orderitem` VALUES (84, 77, 77, '1', '39');
INSERT INTO `orderitem` VALUES (85, 79, 33, '3', '15');
INSERT INTO `orderitem` VALUES (86, 79, 77, '1', '39');
INSERT INTO `orderitem` VALUES (87, 80, 71, '5', '345');
INSERT INTO `orderitem` VALUES (88, 80, 77, '1', '39');
INSERT INTO `orderitem` VALUES (89, 81, 64, '5', '33330');
INSERT INTO `orderitem` VALUES (90, 81, 65, '1', '8888');
INSERT INTO `orderitem` VALUES (91, 82, 64, '2', '13332');
INSERT INTO `orderitem` VALUES (92, 83, 71, '7', '483');
INSERT INTO `orderitem` VALUES (93, 84, 64, '4', '26664');
INSERT INTO `orderitem` VALUES (94, 85, 64, '2', '13332');
INSERT INTO `orderitem` VALUES (95, 85, 65, '2', '17776');
INSERT INTO `orderitem` VALUES (96, 85, 34, '2', '30');
INSERT INTO `orderitem` VALUES (97, 85, 36, '1', '17');
INSERT INTO `orderitem` VALUES (98, 85, 37, '1', '18');
INSERT INTO `orderitem` VALUES (99, 86, 45, '2', '50');
INSERT INTO `orderitem` VALUES (100, 86, 78, '1', '64');
INSERT INTO `orderitem` VALUES (101, 87, 76, '1', '167');
INSERT INTO `orderitem` VALUES (102, 87, 77, '1', '39');
INSERT INTO `orderitem` VALUES (103, 88, 71, '3', '207');
INSERT INTO `orderitem` VALUES (104, 88, 43, '1', '17');
INSERT INTO `orderitem` VALUES (105, 88, 76, '1', '167');
INSERT INTO `orderitem` VALUES (106, 88, 77, '1', '39');
INSERT INTO `orderitem` VALUES (107, 88, 15, '1', '14');
INSERT INTO `orderitem` VALUES (110, 90, 57, '1', '15');
INSERT INTO `orderitem` VALUES (111, 91, 37, '1', '18');
INSERT INTO `orderitem` VALUES (112, 92, 59, '1', '19');
INSERT INTO `orderitem` VALUES (113, 93, 1, '1', '14');
INSERT INTO `orderitem` VALUES (114, 94, 76, '1', '167');
INSERT INTO `orderitem` VALUES (115, 95, 71, '2', '138');
INSERT INTO `orderitem` VALUES (116, 96, 71, '2', '138');
INSERT INTO `orderitem` VALUES (117, 97, 48, '2', '28');
INSERT INTO `orderitem` VALUES (118, 98, 3, '2', '30');
INSERT INTO `orderitem` VALUES (119, 99, 3, '5', '75');
INSERT INTO `orderitem` VALUES (120, 100, 81, '3', '42');
INSERT INTO `orderitem` VALUES (121, 101, 62, '3', '15');
INSERT INTO `orderitem` VALUES (122, 108, 19, '1', '12');
INSERT INTO `orderitem` VALUES (123, 108, 13, '1', '11');
INSERT INTO `orderitem` VALUES (124, 109, 21, '1', '13');
INSERT INTO `orderitem` VALUES (125, 110, 26, '1', '13');
INSERT INTO `orderitem` VALUES (126, 111, 30, '1', '13');
INSERT INTO `orderitem` VALUES (127, 112, 41, '2', '13');
INSERT INTO `orderitem` VALUES (128, 112, 25, '2', '12');
INSERT INTO `orderitem` VALUES (129, 113, 23, '1', '16');
INSERT INTO `orderitem` VALUES (130, 114, 46, '1', '24');
INSERT INTO `orderitem` VALUES (131, 115, 1, '1', '14');
INSERT INTO `orderitem` VALUES (132, 115, 46, '1', '24');
INSERT INTO `orderitem` VALUES (133, 116, 102, '1', '11');
INSERT INTO `orderitem` VALUES (134, 117, 1, '1', '14');
INSERT INTO `orderitem` VALUES (135, 117, 102, '2', '11');
INSERT INTO `orderitem` VALUES (136, 118, 102, '1', '11');
INSERT INTO `orderitem` VALUES (137, 119, 10, '2', '4');
INSERT INTO `orderitem` VALUES (138, 120, 103, '1', '11');
INSERT INTO `orderitem` VALUES (139, 121, 103, '1', '11');
INSERT INTO `orderitem` VALUES (140, 122, 102, '1', '11');
INSERT INTO `orderitem` VALUES (141, 122, 103, '1', '11');
INSERT INTO `orderitem` VALUES (142, 123, 101, '1', '11');

-- ----------------------------
-- Table structure for soilinfo
-- ----------------------------
DROP TABLE IF EXISTS `soilinfo`;
CREATE TABLE `soilinfo`  (
  `soil_id` int NOT NULL AUTO_INCREMENT COMMENT '菜品编号',
  `soil_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜品名称',
  `soil_des` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜品描述',
  `soil_price` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜品价格',
  `soil_photo` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜品图片',
  `soil_userid` int NOT NULL,
  `soil_status` int NOT NULL,
  `soil_maturity` int NOT NULL,
  `soil_fruit` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`soil_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' ' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of soilinfo
-- ----------------------------
INSERT INTO `soilinfo` VALUES (1, '乾生钱农场', '远远地，是那么青幽幽的一大片，青山朴实地屹立在那里，仿佛亘古不变；脚下，是结结实实的黄土地，深沉厚重，一步一个脚印。', '14', 'valley.jpg', 0, 0, 8, '乾生钱农场');
INSERT INTO `soilinfo` VALUES (2, '流浪的狼之农场', ' 一指尘土、土壤。泥土即土壤，是球陆地表面具有一定肥力能够生长植物的疏松表层。', '23', 'lake.jpeg', 2, 0, 3, '流浪的狼之农场');
INSERT INTO `soilinfo` VALUES (5, '香蕉', '一代天骄，万丈光芒', '14', 'xj.png', 1, 0, 10, '香蕉');
INSERT INTO `soilinfo` VALUES (10, '猕猴桃', '野生，黄心的，甜掉牙，不管镶', '4', 'mht.png', 2, 0, 50, '猕猴桃');
INSERT INTO `soilinfo` VALUES (20, '桃子', '三千年一开花，三千年一结果，蟠桃会特供', '14', 'tz.png', 2, 0, 90, '桃子');
INSERT INTO `soilinfo` VALUES (22, '苹果', '我比牛顿有名气', '15', 'pg.png', 3, 0, 10, '苹果');
INSERT INTO `soilinfo` VALUES (23, 'zzz农场', '只要挪动一点杂草生存的空间，她就会把黄土地装点，撑起一片绿色', '16', 'zzz.png', 19, 0, 45, 'zzz农场');
INSERT INTO `soilinfo` VALUES (24, '苹什么', '每天一个苹果，医生远离你', '15', 'pg.png', 3, 0, 60, '苹果');
INSERT INTO `soilinfo` VALUES (27, '蕉绿', '一根限量款的香蕉，不准错过哦！', '15', 'xj.png', 3, 0, 10, '蕉绿');
INSERT INTO `soilinfo` VALUES (28, '老实芭蕉', '外表鲜艳，内心也甜', '16', 'bj.png', 15, 0, 20, '芭蕉');
INSERT INTO `soilinfo` VALUES (29, '炒鸡管理员农场', '思想是种子，在有的土壤里它能成长，在有的土壤里它就会死亡，所以播种思想的人，首先要研究土壤。这样就多了成功的希望。', '14', 'admin.png', 15, 0, 30, '炒鸡管理员农场');
INSERT INTO `soilinfo` VALUES (31, '西柚苗', '那柚子皮上像涂过一层桐油，黄黄的、光光的，香味幽雅而清淡，使人闻着直流口水', '15', 'xym.png', 15, 0, 50, '西柚');
INSERT INTO `soilinfo` VALUES (32, '芭蕉苗', '青翠欲滴，耸入云天', '16', 'bjm.png', 15, 0, 60, '芭蕉');
INSERT INTO `soilinfo` VALUES (34, '蜜桃苗', '苍翠挺拔，郁郁葱葱', '15', 'mtm.png', 16, 0, 80, '蜜桃');
INSERT INTO `soilinfo` VALUES (35, '猕猴桃苗', '长势旺盛，郁郁葱葱', '15', 'mhtm.png', 16, 0, 90, '猕猴桃');
INSERT INTO `soilinfo` VALUES (36, '好农场', '奶的味道比较浓厚，甜度也相对较甜，口感和味道更容易被大众所接纳。\r\n有机肥养分全面，富含有机质、氮、磷、钾和微量元素，', '17', 'JYH.png', 16, 0, 10, '好农场');
INSERT INTO `soilinfo` VALUES (37, '葡萄苗', '郁郁葱葱的麦苗在春天里散发着它特有的气息。有一种熟悉的味道在这里弥漫，是清新，是感动!', '18', 'ptm.png', 16, 0, 20, '葡萄');
INSERT INTO `soilinfo` VALUES (38, '苹果苗', '豆香馅甜，入口绵软，矿物元素丰富、提高免疫力、安神除烦。', '14', 'pgm.png', 17, 0, 30, '苹果');
INSERT INTO `soilinfo` VALUES (39, '柚秀', '秋天的第一个柚子安排起来。', '16', 'yzm.png', 17, 0, 40, '柚子');
INSERT INTO `soilinfo` VALUES (40, '往哪里桃', '天上仙桃，人间金桃', '14', 'tzm.png', 17, 0, 50, '桃子');
INSERT INTO `soilinfo` VALUES (42, '葡萄', '一串串葡萄绿绿的，晶莹透明，真像是用水晶和玉石雕刻出来似的。', '16', 'pt.png', 17, 0, 70, '葡萄');
INSERT INTO `soilinfo` VALUES (43, '西柚', '柚货迷人', '17', 'xy.png', 17, 0, 80, '西柚');
INSERT INTO `soilinfo` VALUES (44, '枇杷', '成熟的枇杷，青里透黄，形状椭圆椭圆的，别看它的圆，吃起来甘甜爽口，只要轻轻咬一口，满口充满鲜嫩的汁水，直甜到心里。', '20', 'pp.png', 17, 0, 90, '枇杷');
INSERT INTO `soilinfo` VALUES (45, '枇杷苗', '枇杷树上下垂一簇簇诱人的果实，一颗颗枇杷果实挨挨挤挤，就像永远不分离的好兄弟', '25', 'ppm.png', 17, 0, 10, '枇杷');
INSERT INTO `soilinfo` VALUES (46, '坏农场', '我要像一棵小草那样生存，只要有一点土壤，就要倔强的生根发芽。无所谓阳光过分的眷恋，不需要雨露太多的恩泽，哪怕承受了顽石的压迫，也要坚强的挺直腰杆', '24', 'sun.jpg', 19, 0, 20, '坏农场');
INSERT INTO `soilinfo` VALUES (47, '梨', '这鸭梨又香又甜，咬一口脆生生的，甜水顺着下巴一直流', '17', 'l.png', 17, 0, 30, '梨');
INSERT INTO `soilinfo` VALUES (48, '草莓', '草莓像是精心挑选的，每个都差不多一样大小，像我的大拇指那么大。上端尖尖的，末端圆圆的，大大的，就像平常见到的“心”形图案。表面不光滑，像是镶上了许多小点点。', '20', 'cm.png', 2, 0, 20, '草莓');
INSERT INTO `soilinfo` VALUES (49, '草莓苗', '吹来，嫩芽渐渐地变成了小绿叶儿，满树答的绿叶在微风中飒飒做响。小树苗尽情地吮吸着春天的甘露。', '45', 'cmm.png', 2, 0, 28, '草莓');
INSERT INTO `soilinfo` VALUES (50, '菠萝', '一个个黄澄澄、金灿灿的菠萝，似金珠般井然有序地排列着，美极了！', '21', 'bl.png', 6, 0, 32, '菠萝');
INSERT INTO `soilinfo` VALUES (51, '菠萝苗', '小树沐浴着阳光，一天一天地向上伸展着身体。小树苗尽情地吮吸着春天的甘露。', '12', 'blm.png', 6, 0, 12, '菠萝');
INSERT INTO `soilinfo` VALUES (52, '羊羊农场', ' 每天，脚下踩的就是泥土。它虽然被无数人踩着，但没有向人类要过报酬，只是默默地承受着一切。', '13', 'YY.png', 6, 0, 45, '羊羊农场');
INSERT INTO `soilinfo` VALUES (53, '牛油果', '大家好，我是大名鼎鼎的牛油果，我披着一件暗紫色的外袍，乍一看像一个手榴弹，仔细看的话更像一个大鸭梨，我的外袍上布满了密密麻麻的颗粒。', '33', 'nyg.png', 8, 0, 34, '牛油果');
INSERT INTO `soilinfo` VALUES (54, '牛油果苗', '微风吹拂，树苗轻轻晃动，好像把自己的精神抖擞抖擞，准备使出全身的力气往上蹿呢！', '23', 'nygm.png', 8, 0, 55, '牛油果');
INSERT INTO `soilinfo` VALUES (56, '李子', '从果园里飘出一阵阵醉人的芳香。你亲口尝尝那红通通的李子，又甜又脆', '12', 'lz.png', 2, 0, 67, '李子');
INSERT INTO `soilinfo` VALUES (57, '李子苗', '田野上，树苗返青，一望无边，仿佛绿色的波浪。那金黄色的野菜花，在绿波中闪光。', '13', 'lzm.png', 2, 0, 35, '李子');
INSERT INTO `soilinfo` VALUES (58, '榴莲', '一听到榴莲，有的人可能会说它臭如猫屎，不堪如鼻；而有些人却觉得又香又甜。它的外形是椭圆的，酷似西瓜，但表面却布满了尖锥般坚硬的“钢刺”，时刻警戒着那些对它垂涎三尺的动物们。', '24', 'll.png', 4, 0, 35, '榴莲');
INSERT INTO `soilinfo` VALUES (59, '榴莲苗', '小树在大风中翩翩起舞。小树是森林的儿子，阳光是保姆，溪流是乳汁小鸟、松答鼠是玩伴。', '46', 'llm.png', 4, 0, 35, '榴莲');
INSERT INTO `soilinfo` VALUES (60, '火星农场', ' 泥土朴实得不能在普通了。它被人们踩在脚下，甚至被人们抛弃，可它却毫无怨言，就像那朴实的老黄牛一样。', '67', 'LiMan.png', 5, 0, 46, '火星农场');
INSERT INTO `soilinfo` VALUES (61, '小番茄', '夏天到了，一棵棵西红柿树上挂着青绿色的圆溜溜的西红柿，它们有的几个亲热的挨在一起，好像挂在一起的风铃，一阵微风吹来，西红柿摇摇摆摆，好像风铃在相互撞击，使我耳边又响起了风铃声，有的独自一个，好像在沉思，有的把肚皮高高得举起，好像在炫耀自己个子大。', '78', 'xfq.png', 5, 0, 57, '小番茄');
INSERT INTO `soilinfo` VALUES (62, '小番茄苗', '绿油油的树苗一眼望不到边，在微风吹拂下不停地荡漾，犹如一片绿色的海洋。\r\n', '67', 'xfqm.png', 5, 0, 35, '小番茄');
INSERT INTO `soilinfo` VALUES (63, '芒果', '芒果的外表黄澄澄的，光滑的皮上好像是涂了一层蜡，有一种很厚实的感觉。更特别的是那种彩色的芒果，它表面各种颜色杂揉在一起，看上去像小猫打翻了的调色盘，非常地绚丽。', '45', 'mg.png', 6, 0, 57, '芒果');
INSERT INTO `soilinfo` VALUES (64, '芒果苗', '绿油油的树苗一眼望不到边，在微风吹拂下不停地荡漾，犹如一片绿色的海洋。\r\n绿油油的树苗一眼望不到边，在微风吹拂下不停地荡漾，犹如一片绿色的海洋。\r\n', '46', 'mgm.png', 6, 0, 34, '芒果');
INSERT INTO `soilinfo` VALUES (65, '西瓜', '西瓜圆溜溜的，像一个篮球，表皮墨绿和嫩绿相间。', '46', 'xg.png', 6, 0, 67, '西瓜');
INSERT INTO `soilinfo` VALUES (66, '西瓜苗', '\r\n地里的树苗，长得肥绿肥绿，风刮着，就像一湖绿水。', '57', 'xgm.png', 2, 0, 45, '西瓜');
INSERT INTO `soilinfo` VALUES (67, '无敌农场', '泥土平凡而朴实，博大而厚重，默默奉献而不期回报，功高盖世而绝不张扬', '34', 'LZY.png', 16, 0, 57, '无敌农场');
INSERT INTO `soilinfo` VALUES (68, '山竹', '山竹是一种南方水果，长得圆滚滚的，颜色紫黑，真像一个非洲来的小弟弟。长得像蒜瓣，颜色是乳白的。还戴着一顶小绿帽呢！不仅长的独特，气味也很独特！山竹的气味是像花一样的清香。闻起来可舒服了，闻着就想一口全吃下去！', '56', 'sz.png', 16, 0, 15, '山竹');
INSERT INTO `soilinfo` VALUES (69, '山竹苗', '绿油油的树苗一眼望不到边，在微风吹拂下不停地荡漾，犹如一片绿色的海洋。\r\n绿油油的树苗一眼望不到边，在微风吹拂下不停地荡漾，犹如一片绿色的海洋。\r\n', '68', 'szm.png', 16, 0, 57, '山竹');
INSERT INTO `soilinfo` VALUES (70, '荔枝', '荔枝的形状象鸡心，大小如乒乓球一般。拿起一串荔枝，一股清香扑鼻而来那香甜味迎面扑来，使人陶醉。', '78', 'lz1.png', 17, 0, 68, '荔枝');
INSERT INTO `soilinfo` VALUES (71, '荔枝苗', '春天，无边的树苗，绿油油、清爽爽、活脱脱、笑朗朗，清风吹来，阵阵清香……', '46', 'lzm1.png', 17, 0, 57, '荔枝');
INSERT INTO `soilinfo` VALUES (72, '哈密瓜', '哈密瓜是椎圆形的，瓜皮有些是黄的，有些是绿色的，有些是绿中带黄。切开瓜皮，一阵甜甜的香气扑鼻而来，切一块下来，黄色的果肉里带着清凉的汁水，咬一口，啊！一股清凉的滋味顿时流入我的心田，太清爽了', '36', 'hmg.png', 17, 0, 45, '哈密瓜');
INSERT INTO `soilinfo` VALUES (73, '哈密瓜苗', '嫩的树苗纷纷钻出土地妈妈的怀抱，来迎接美丽的春天，绿油油的小脑袋轻轻摇曳，一眼望去，漫无边际，仿佛绿色的海浪，和风吹来，这些可爱的苗儿不禁跳了轻快的舞蹈，以表达自己无尽的喜悦。', '36', 'hmgm.png', 1, 0, 46, '哈密瓜');
INSERT INTO `soilinfo` VALUES (74, '木瓜', '木瓜又名木瓜海棠，叶椭圆，花粉红，果深黄色，具光泽，味微酸涩，有芳香。可入药，又可食用。家乡的土地上，能生长出这样的佳木，也实在是一件令人骄傲的事儿。', '57', 'mg1.png', 1, 0, 78, '木瓜');
INSERT INTO `soilinfo` VALUES (75, '木瓜苗', '\r\n正在返青的树苗，毛绒绒、绿茵茵的，在朝辉下挑着一颗颗晶莹透亮的露珠。', '47', 'mgm1.png', 1, 0, 6, '木瓜');
INSERT INTO `soilinfo` VALUES (76, '苹果', '夏天，苹果树葱郁的绿叶闪闪发亮，密密层层，一个个小苹果像翡翠镶嵌在绿叶下边。', '88', 'pg.png', 2, 0, 8, '苹果');
INSERT INTO `soilinfo` VALUES (77, '苹果苗', '\r\n一望无际的田野上，树苗绿油油的，像绿色的海洋。', '57', 'pgm.png', 2, 0, 9, '苹果');
INSERT INTO `soilinfo` VALUES (78, '梨', '鸭梨的皮非常薄，薄得有时一碰就破；个大，大得叫你吃惊；汁多，咬一口像喝了一碗用甘泉冲出来的甜水。', '78', 'l.png', 3, 0, 89, '梨');
INSERT INTO `soilinfo` VALUES (79, '梨苗', '\r\n一望无际的田野上，树苗绿油油的，像绿色的海洋。春天到了，鸟语花香，到处一片生机勃勃的景色，树苗里绿油油的麦苗欢快的成长的，微风过后，一片片绿浪像一幅美丽的画面。', '79', 'lm.png', 3, 0, 78, '梨');
INSERT INTO `soilinfo` VALUES (80, '石榴', '我可爱吃石榴啦！虽然它的红里透黄的“衣裳”不太好看，但是它的味道甜甜的，非常好吃。它的果粒晶莹剔透，多像一颗颗漂亮的粉红小水晶啊！它粗糙的果皮，有很大的药用价值哦', '79', 'sl.png', 6, 0, 89, '石榴');
INSERT INTO `soilinfo` VALUES (81, '石榴苗', '许多树苗的叶子发黄了，随着阵阵秋风，纷度纷扬扬落下，而小树不但翠绿，生机勃勃，而且又孕含着未来的花苞去，真像粉红、银白色的云彩。', '86', 'slm.png', 5, 0, 37, '石榴');
INSERT INTO `soilinfo` VALUES (82, '樱桃', '个大，大得叫你吃惊；汁多，咬一口就好像喝了一碗用甘泉冲出来的甜水。', '68', 'yt1.png', 4, 0, 79, '樱桃');
INSERT INTO `soilinfo` VALUES (83, '樱桃苗', '春风一阵暖似一阵，小树桑芽冒出来，翠生生、水灵灵的，绿得鲜嫩，绿得喜人。', '78', 'ytm1.png', 4, 0, 46, '樱桃');
INSERT INTO `soilinfo` VALUES (84, '火龙果', '扒开火龙果的皮，里面的肉是白色的，上面有许多像黑芝麻一样的东西，黑白相间，特别诱人。 火龙果的味道清甜可口，我最喜欢的吃法是：像剥香蕉一样剥开皮，用勺子舀着来吃，中间比较甜，离皮近的地方比较酸。', '47', 'hlg.png', 5, 0, 89, '火龙果');
INSERT INTO `soilinfo` VALUES (85, '火龙果苗', '正在返青的树苗，毛绒绒、绿茵茵的，在朝辉下挑着一颗颗晶莹透亮的露珠。', '36', 'hlgm.png', 5, 0, 48, '火龙果');
INSERT INTO `soilinfo` VALUES (86, '西瓜', '西瓜圆溜溜的，像一个篮球，表皮墨绿和嫩绿相间。', '58', 'xg.png', 5, 0, 48, '西瓜');
INSERT INTO `soilinfo` VALUES (87, '西瓜苗', '春天到了，鸟语花香，到处一片生机勃勃的景色，树苗里绿油油的西瓜苗欢快的成长的，微风过后，一片片绿浪像一幅美丽的画面。', '47', 'xgm1.png', 16, 0, 479, '西瓜');
INSERT INTO `soilinfo` VALUES (88, '杨桃', '忆醉三山芳树下，几曾风韵忘怀。黄金颜色五花开，味如卢桔熟，贵似荔枝来。', '58', 'yt.png', 16, 0, 58, '杨桃');
INSERT INTO `soilinfo` VALUES (89, '杨桃苗', '春天，无边的杨桃苗，绿油油、清爽爽、活脱脱、笑朗朗，清风吹来，阵阵清香……', '39', 'ytm.png', 16, 0, 58, '杨桃');
INSERT INTO `soilinfo` VALUES (90, '牛油果苗', '郁郁葱葱的牛油果苗在春天里散发着它特有的气息。有一种熟悉的味道在这里弥漫，是清新，是感动!', '85', 'nygm.png', 17, 0, 49, '牛油果');
INSERT INTO `soilinfo` VALUES (91, '哈密瓜', '哈密瓜是椎圆形的，瓜皮有些是黄的，有些是绿色的，有些是绿中带黄。切开瓜皮，一阵甜甜的香气扑鼻而来，切一块下来，黄色的果肉里带着清凉的汁水，咬一口，啊！一股清凉的滋味顿时流入我的心田，太清爽了', '79', 'hmg.png', 17, 0, 69, '哈密瓜');
INSERT INTO `soilinfo` VALUES (92, '哈密瓜苗', '一望无际的田野上，哈密瓜苗绿油油的，像绿色的海洋。', '58', 'hmgm1.png', 2, 0, 5, '哈密瓜');
INSERT INTO `soilinfo` VALUES (93, '葡萄', '一串串葡萄绿绿的，晶莹透明，真像是用水晶和玉石雕刻出来似的。', '58', 'pt.png', 6, 0, 5, '葡萄');
INSERT INTO `soilinfo` VALUES (94, '葡萄苗', '地里的葡萄苗，长得肥绿肥绿，风刮着，就像一湖绿水。', '48', 'ptm.png', 6, 0, 8, '葡萄');
INSERT INTO `soilinfo` VALUES (95, '菠萝', '一个个黄澄澄、金灿灿的菠萝，似金珠般井然有序地排列着，美极了！', '89', 'bl.png', 5, 0, 78, '菠萝');
INSERT INTO `soilinfo` VALUES (96, '菠萝苗', '田野上，菠萝苗返青，一望无边，仿佛绿色的波浪。那金黄色的野菜花，在绿波中闪光。', '67', 'blm.png', 5, 0, 47, '菠萝');
INSERT INTO `soilinfo` VALUES (97, '桃子', '桃子已由白变红，红中透白。一个个像胖娃娃似的，红着脸，扒开树叶，俏皮地偷偷向人们笑。', '48', 'tz.png', 1, 0, 687, '桃子');
INSERT INTO `soilinfo` VALUES (98, '桃子苗', '微风吹拂，桃子苗轻轻晃动，好像把自己的精神抖擞抖擞，准备使出全身的力气往上蹿呢！', '58', 'tzm1.png', 1, 0, 68, '桃子');
INSERT INTO `soilinfo` VALUES (99, '杨梅', '个大，大得叫你吃惊；汁多，咬一口就好像喝了一碗用甘泉冲出来的甜水。', '58', 'ym.png', 1, 0, 80, '杨梅');
INSERT INTO `soilinfo` VALUES (100, '杨梅苗', '田野里，杨梅苗返青，一望无边，仿佛绿色的波浪。', '69', 'ymm.png', 2, 0, 80, '杨梅');
INSERT INTO `soilinfo` VALUES (101, '流浪的狼', '沃嫩爹啊', '11', '1640920138572_1640920138521.jpg', 23, 0, 23, '流浪的狼');
INSERT INTO `soilinfo` VALUES (102, '流浪的狼', '沃嫩爹啊', '11', '1640935714911_1640935714645.jpg', 21, 0, 10008, '绿豆糕');
INSERT INTO `soilinfo` VALUES (103, '绿豆糕', '好吃', '11', '1640939046645_1640939045965.jpg', 21, 0, 33, '豆制品');

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo`  (
  `user_id` int NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `user_account` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
  `user_password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
  `user_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户昵称',
  `user_addressed` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户地址',
  `user_phone` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码',
  `user_photo` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `user_integral` double(11, 0) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '用户积分',
  `farm_id` int NULL DEFAULT NULL,
  `user_status` int(10) UNSIGNED ZEROFILL NOT NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' ' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES (1, 'WangHuiQian', '123456', 'wang hui qian', '襄樊县襄樊乡襄樊村襄樊小区', '12345678911', 'tx1.png', 00000089782, 1, 0000000000);
INSERT INTO `userinfo` VALUES (2, 'rt777', '123456', 'LLDL', '匈牙利阿卡其乌尔利斯大利街280372号', '12345678910', '1640939169545_1640939169510.jpg', 00000162143, 2, 0000000000);
INSERT INTO `userinfo` VALUES (3, 'zzz', '123456', 'zzz', '翻斗大街翻斗花园二号楼1001室', '12345678910', 'tx3.jpg', 00000004367, 3, 0000000000);
INSERT INTO `userinfo` VALUES (4, 'YY', '124578963', 'YY', '阿联酋南半岛可夫达吉汉区', '12345678912', 'tx4.png', 00000206852, 4, 0000000000);
INSERT INTO `userinfo` VALUES (5, 'LiMan', '123456', 'LiMan', '加拿大渥太华市', '12345678910', 'tx5.jpg', 00000000404, 5, 0000000000);
INSERT INTO `userinfo` VALUES (6, 'LZY', '123456', 'lZY', '翻斗花园098', '13407988455', 'tx6.jpg', 00000000000, 6, 0000000000);
INSERT INTO `userinfo` VALUES (15, 'admin', 'admin', 'admin', '江西省南昌市南昌航空大学大学20栋204', '18179632373', 'tx7.png', 00000999999, 15, 0000000000);
INSERT INTO `userinfo` VALUES (16, 'JYH', '123456', 'JYH', '南昌航空大学20栋206', '19203829382', 'tx8.jpg', 00000000000, 16, 0000000000);
INSERT INTO `userinfo` VALUES (17, 'SQL', '123456', 'SQL', '花园世界001', '17870438438', 'tx9.jpg', 00000000024, 17, 0000000000);
INSERT INTO `userinfo` VALUES (18, 'admin', '123456', 'admin', 'xxx', 'xxx', '', 00000000000, 0, 0000000002);
INSERT INTO `userinfo` VALUES (19, 'rt7771', '123456', '闪光桐人', '爱咋地撒大大啊', '123456', '1640934429102_1640934429052.jpg', 00000158819, NULL, 0000000000);
INSERT INTO `userinfo` VALUES (21, 'rt7772', '123456', '闪光桐人啊', NULL, '123456', NULL, 00000001564, NULL, 0000000000);
INSERT INTO `userinfo` VALUES (23, 'rt7773', '123456', '闪光桐人啊', NULL, '123456', NULL, 00000000132, NULL, 0000000000);

-- ----------------------------
-- Procedure structure for update_status
-- ----------------------------
DROP PROCEDURE IF EXISTS `update_status`;
delimiter ;;
CREATE PROCEDURE `update_status`()
UPDATE soilinfo set soil_status=0 where soil_status=1
;
;;
delimiter ;

-- ----------------------------
-- Event structure for e
-- ----------------------------
DROP EVENT IF EXISTS `e`;
delimiter ;;
CREATE EVENT `e`
ON SCHEDULE
EVERY '1' DAY STARTS '2021-12-27 00:04:18'
ON COMPLETION PRESERVE
DO update soilinfo SET soil_status=0 where soil_status=1
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;