登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 5 Fork 0

小小/体重帮

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
weight.sql 39.32 KB
一键复制 编辑 原始数据 按行查看 历史
春哥 提交于 2021-03-03 23:44 . Signed-off-by: hcc 1778311645@qq.com
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
/*

Navicat MySQL Data Transfer



Source Server         : 180.76.119.18

Source Server Version : 50529

Source Host           : localhost:3306

Source Database       : weight



Target Server Type    : MYSQL

Target Server Version : 50529

File Encoding         : 65001



Date: 2020-11-28 10:09:52

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for `admin`

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(255) DEFAULT NULL,

  `password` varchar(255) DEFAULT NULL,

  `url` varchar(255) DEFAULT NULL,

  `sex` varchar(255) DEFAULT '女',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES ('1', 'admin', 'admin', 'http://127.0.0.1:3000/public/img/admin/admin/1603616487069-8bc8bb14-b2cd-4282-87cb-ba360dc0d8f0.jpg', '男');

INSERT INTO `admin` VALUES ('3', '1', '1', 'http://127.0.0.1:3000/public/img/admin/admin/1603616516599-001.jpg', '男');

INSERT INTO `admin` VALUES ('5', '321', '3123', 'http://127.0.0.1:3000/public/img/admin/admin/1603616498288-b98448a0-ea6b-485d-b434-cf11be399a7d.jpg', '男');



-- ----------------------------

-- Table structure for `follow`

-- ----------------------------

DROP TABLE IF EXISTS `follow`;

CREATE TABLE `follow` (

  `followId` int(11) NOT NULL AUTO_INCREMENT,

  `userId` int(11) NOT NULL,

  `menuId` int(11) NOT NULL,

  PRIMARY KEY (`followId`)

) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of follow

-- ----------------------------

INSERT INTO `follow` VALUES ('11', '48', '4');



-- ----------------------------

-- Table structure for `menu`

-- ----------------------------

DROP TABLE IF EXISTS `menu`;

CREATE TABLE `menu` (

  `menuId` int(11) NOT NULL AUTO_INCREMENT,

  `menuName` varchar(255) DEFAULT NULL,

  `menuImg` varchar(255) DEFAULT NULL,

  `menuImgList` varchar(9999) DEFAULT '[]',

  `menuTime` varchar(11) DEFAULT NULL,

  `menuType` varchar(255) DEFAULT NULL,

  `menuTag` varchar(255) DEFAULT NULL,

  `menuMaterials` text NOT NULL,

  `menuPrice` int(11) DEFAULT NULL,

  `menuComm` varchar(9999) DEFAULT NULL,

  `menuDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `menuPraise` int(11) DEFAULT '0',

  `menuFlavor` enum('麻辣','中辣','微辣','清淡') DEFAULT '清淡',

  `menuHot` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`menuId`)

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of menu

-- ----------------------------

INSERT INTO `menu` VALUES ('1', '土豆肉丝', 'http://127.0.0.1:3000/public/img/user/materialsup/1603618537837-gu-feng03.jpg', '[\"http://127.0.0.1:3000/public/img/user/materialsup/1603618537837-gu-feng03.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603618537839-gu-feng04.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603618537842-gu-feng05.jpg\"]', '午餐', '荤菜菜谱', '[\"美食\",\"11\"]', '<h2>哈哈</h2>', '100', '哈哈', '2020-03-31 22:07:29', '0', '麻辣', '21');

INSERT INTO `menu` VALUES ('2', '土豆肉丝', 'http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg', '[\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\"]', '早餐', '荤菜菜谱', '[\"你猜\",\"好吃\"]', '<h1>第一步</h1><div>需土豆</div>', null, '11', '2020-10-28 22:30:37', '0', '清淡', '33');

INSERT INTO `menu` VALUES ('3', '土豆肉丝', 'http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg', '[\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\"]', '午餐', '荤菜菜谱', '[\"你猜\",\"好吃\"]', '<h1>第一步</h1><div>需土豆</div>', null, '11', '2020-11-03 23:03:31', '0', '清淡', '44');

INSERT INTO `menu` VALUES ('4', '土豆肉丝', 'http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg', '[\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\"]', '早餐', '荤菜菜谱', '[\"你猜\",\"好吃\"]', '<h1>第一步</h1><div>需土豆</div>', null, '11', '2020-03-31 22:07:31', '0', '清淡', '55');

INSERT INTO `menu` VALUES ('8', '竹笋肉丝', 'http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg', '[\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\"]', '早餐', '荤菜菜谱', '[\"竹笋\",\"肉\"]', '<p style=\"text-align: center;\">111111</p>', null, '111', '2020-03-31 22:07:33', '0', '清淡', '77');



-- ----------------------------

-- Table structure for `menutype`

-- ----------------------------

DROP TABLE IF EXISTS `menutype`;

CREATE TABLE `menutype` (

  `menutypeId` int(11) NOT NULL AUTO_INCREMENT,

  `menutypeTitle` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`menutypeId`),

  UNIQUE KEY `menutypeId` (`menutypeTitle`)

) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of menutype

-- ----------------------------

INSERT INTO `menutype` VALUES ('2', '荤菜菜谱');

INSERT INTO `menutype` VALUES ('3', '素菜菜谱');



-- ----------------------------

-- Table structure for `motion`

-- ----------------------------

DROP TABLE IF EXISTS `motion`;

CREATE TABLE `motion` (

  `motionId` int(11) NOT NULL AUTO_INCREMENT,

  `motionType` varchar(255) DEFAULT NULL,

  `motionHot` varchar(255) DEFAULT NULL,

  `motionImg` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`motionId`)

) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of motion

-- ----------------------------

INSERT INTO `motion` VALUES ('3', '俯卧撑', '11', 'http://127.0.0.1:3000/public/img/admin/motion/1603620625058-gu-feng04.jpg');

INSERT INTO `motion` VALUES ('2', '引体向上', '22', 'http://127.0.0.1:3000/public/img/admin/motion/1603620631267-gu-feng03.jpg');



-- ----------------------------

-- Table structure for `plan`

-- ----------------------------

DROP TABLE IF EXISTS `plan`;

CREATE TABLE `plan` (

  `planId` int(11) NOT NULL AUTO_INCREMENT,

  `userId` int(11) NOT NULL,

  `menuFlavor` varchar(255) DEFAULT NULL,

  `type` enum('3','2','1') DEFAULT NULL,

  `motionDataList` longtext,

  `planDate` date DEFAULT NULL,

  PRIMARY KEY (`planId`,`userId`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of plan

-- ----------------------------

INSERT INTO `plan` VALUES ('1', '48', '微辣', '2', '[{\"date\":\"2020-11-02\",\"week\":1,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-03\",\"week\":2,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-04\",\"week\":3,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-05\",\"week\":4,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-06\",\"week\":5,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-07\",\"week\":6,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-08\",\"week\":7,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[]},{\"type\":\"lunch\",\"menuList\":[]},{\"type\":\"dinner\",\"menuList\":[]}]}]', '2020-11-02');

INSERT INTO `plan` VALUES ('2', '48', '清淡', '2', '[{\"date\":\"2020-11-23\",\"week\":1,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-24\",\"week\":2,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-25\",\"week\":3,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-26\",\"week\":4,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-27\",\"week\":5,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-28\",\"week\":6,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]},{\"date\":\"2020-11-29\",\"week\":7,\"motion\":[{\"type\":\"breakfast\",\"menuList\":[{\"menuId\":2,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804162-03c51199c17a442ff09cc14af67c4573.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894804164-5fd82fec325a91a7e7729abbd635e515.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-10-28T14:30:37.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"33\"},{\"menuId\":4,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825469-322f5d838326b4069df192416e1caf4b.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894825471-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-03-31T14:07:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"55\"},{\"menuId\":8,\"menuName\":\"竹笋肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835755-5fd82fec325a91a7e7729abbd635e515.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894835756-67b1e3a44235fd643ea32e790b9c60a5.jpg\\\"]\",\"menuTime\":\"早餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"竹笋\\\",\\\"肉\\\"]\",\"menuMaterials\":\"<p style=\\\"text-align: center;\\\">111111</p>\",\"menuPrice\":null,\"menuComm\":\"111\",\"menuDate\":\"2020-03-31T14:07:33.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"77\"}]},{\"type\":\"lunch\",\"menuList\":[{\"menuId\":3,\"menuName\":\"土豆肉丝\",\"menuImg\":\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\",\"menuImgList\":\"[\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816062-339457269e85be7bbc462cd902332686.jpg\\\",\\\"http://127.0.0.1:3000/public/img/user/materialsup/1603894816063-a3eb5f2c60738983cca52c707b4680e7.jpg\\\"]\",\"menuTime\":\"午餐\",\"menuType\":\"荤菜菜谱\",\"menuTag\":\"[\\\"你猜\\\",\\\"好吃\\\"]\",\"menuMaterials\":\"<h1>第一步</h1><div>需土豆</div>\",\"menuPrice\":null,\"menuComm\":\"11\",\"menuDate\":\"2020-11-03T15:03:31.000Z\",\"menuPraise\":0,\"menuFlavor\":\"清淡\",\"menuHot\":\"44\"}]},{\"type\":\"dinner\",\"menuList\":[]}]}]', '2020-11-23');



-- ----------------------------

-- Table structure for `praise`

-- ----------------------------

DROP TABLE IF EXISTS `praise`;

CREATE TABLE `praise` (

  `praiseId` int(11) NOT NULL AUTO_INCREMENT,

  `userId` int(11) NOT NULL,

  `menuId` int(11) NOT NULL,

  PRIMARY KEY (`praiseId`)

) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of praise

-- ----------------------------



-- ----------------------------

-- Table structure for `rticlea`

-- ----------------------------

DROP TABLE IF EXISTS `rticlea`;

CREATE TABLE `rticlea` (

  `rticleaId` int(11) NOT NULL AUTO_INCREMENT,

  `adminId` int(11) DEFAULT NULL,

  `rticleaTitle` varchar(255) DEFAULT NULL,

  `rticleaComm` varchar(255) DEFAULT NULL,

  `rticleaType` varchar(255) DEFAULT NULL,

  `rticleaImgList` varchar(9999) DEFAULT NULL,

  `rticleaTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `rticleaRead` int(11) DEFAULT '0',

  PRIMARY KEY (`rticleaId`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of rticlea

-- ----------------------------

INSERT INTO `rticlea` VALUES ('1', '3', '11112312', '11', '饮食知识', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620330052-983ab4b19f2a6e75d1e2e698e1caab5a.jpg\"]', '2020-11-27 22:19:13', '52');

INSERT INTO `rticlea` VALUES ('2', '3', '22222', '222', '美食咨询', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620339630-5fd82fec325a91a7e7729abbd635e515.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620339631-67b1e3a44235fd643ea32e790b9c60a5.jpg\"]', '2020-11-27 22:19:17', '7');

INSERT INTO `rticlea` VALUES ('4', '3', '1212', '12121', '饮食知识', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620349311-339457269e85be7bbc462cd902332686.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620349312-a3eb5f2c60738983cca52c707b4680e7.jpg\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1603620349320-cd6e6714a0af24078c312f3cace15d90.jpg\"]', '2020-11-27 22:21:59', '20');

INSERT INTO `rticlea` VALUES ('5', '3', '测试', '11123123', '饮食知识', '[\"http://127.0.0.1:3000/public/img/admin/rticlea/1606486909410-QQ图片20200410141935.png\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1606486909415-QQ图片20200410142003.png\",\"http://127.0.0.1:3000/public/img/admin/rticlea/1606486909418-QQ图片20200410142008.png\"]', '2020-11-27 22:22:02', '1');



-- ----------------------------

-- Table structure for `rticleatype`

-- ----------------------------

DROP TABLE IF EXISTS `rticleatype`;

CREATE TABLE `rticleatype` (

  `rticleatypeId` int(11) NOT NULL AUTO_INCREMENT,

  `rticleatypeTitle` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`rticleatypeId`),

  UNIQUE KEY `rticleatypeId` (`rticleatypeTitle`)

) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of rticleatype

-- ----------------------------

INSERT INTO `rticleatype` VALUES ('1', '饮食知识');

INSERT INTO `rticleatype` VALUES ('2', '美食咨询');



-- ----------------------------

-- Table structure for `sign`

-- ----------------------------

DROP TABLE IF EXISTS `sign`;

CREATE TABLE `sign` (

  `signId` int(11) NOT NULL AUTO_INCREMENT,

  `userId` int(11) NOT NULL,

  `signWeight` varchar(255) DEFAULT NULL,

  `signTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`signId`)

) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of sign

-- ----------------------------

INSERT INTO `sign` VALUES ('4', '48', '106', '2020-10-26 23:37:00');

INSERT INTO `sign` VALUES ('8', '48', '149', '2020-10-27 19:51:53');

INSERT INTO `sign` VALUES ('11', '48', '104', '2020-10-28 21:24:49');

INSERT INTO `sign` VALUES ('12', '48', '122', '2020-10-29 19:51:50');

INSERT INTO `sign` VALUES ('13', '48', '145', '2020-10-30 19:53:35');

INSERT INTO `sign` VALUES ('14', '48', '104', '2020-11-01 10:35:45');

INSERT INTO `sign` VALUES ('15', '48', '108', '2020-11-02 20:41:31');

INSERT INTO `sign` VALUES ('16', '48', '122', '2020-11-03 20:10:17');

INSERT INTO `sign` VALUES ('17', '48', '113', '2020-11-27 22:18:51');



-- ----------------------------

-- Table structure for `user`

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `userId` int(11) NOT NULL AUTO_INCREMENT,

  `userName` varchar(255) DEFAULT NULL,

  `userUrl` varchar(255) DEFAULT NULL,

  `userSex` varchar(255) DEFAULT NULL,

  `userHeight` varchar(255) DEFAULT NULL,

  `userBirthday` date DEFAULT NULL,

  `userTargetWeight` varchar(255) DEFAULT NULL,

  `userWeight` varchar(255) DEFAULT NULL,

  `userPoints` int(255) DEFAULT '0',

  `userKcal` int(11) DEFAULT '0',

  `openid` varchar(255) DEFAULT NULL,

  `session_key` varchar(255) DEFAULT NULL,

  `userTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`userId`)

) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:50');

INSERT INTO `user` VALUES ('4', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:50');

INSERT INTO `user` VALUES ('5', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:57');

INSERT INTO `user` VALUES ('6', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:51');

INSERT INTO `user` VALUES ('7', '李白', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '男', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:51');

INSERT INTO `user` VALUES ('32', null, null, null, null, null, null, null, '0', null, null, null, '2020-10-28 21:11:01');

INSERT INTO `user` VALUES ('33', null, null, null, null, null, null, null, '0', null, null, null, '2020-10-28 21:10:52');

INSERT INTO `user` VALUES ('34', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:55');

INSERT INTO `user` VALUES ('31', '。。', 'https://wx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', null, 'omiwO5CUdC1CeXVAoxvcBbLFkYb8', 'jgd58vSQ3C28c9IaMTAwOg==', '2020-10-28 21:10:52');

INSERT INTO `user` VALUES ('35', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:52');

INSERT INTO `user` VALUES ('36', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:58');

INSERT INTO `user` VALUES ('37', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', null, null, null, '2020-10-28 21:10:52');

INSERT INTO `user` VALUES ('38', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', '0', null, null, '2020-10-28 21:10:55');

INSERT INTO `user` VALUES ('39', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', null, null, null, null, '0', '1000', null, null, '2020-10-28 21:10:53');

INSERT INTO `user` VALUES ('40', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', '未知', '150', '2020-10-25', null, '17', '0', '0', null, null, '2020-10-28 21:10:54');

INSERT INTO `user` VALUES ('41', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, '180', '2020-10-25', '105', '85', '0', '0', null, null, '2020-10-28 21:10:53');

INSERT INTO `user` VALUES ('42', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, null, null, null, null, '0', '0', null, null, '2020-10-28 21:10:59');

INSERT INTO `user` VALUES ('43', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, null, null, null, null, '0', '0', null, null, '2020-10-28 21:10:53');

INSERT INTO `user` VALUES ('44', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, null, null, null, null, '0', '0', null, null, '2020-10-28 21:10:53');

INSERT INTO `user` VALUES ('45', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, '180', '1970-09-01', '19', '16', '0', '100', null, null, '2020-10-28 21:10:54');

INSERT INTO `user` VALUES ('46', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/AgQKkqIeL26yF8EicWTChmOeicCmdFMqIB0HMjSyehgiab0Dktut0WiagPdhzlJelZUaMxXT2IA3PkYUNoNTnTicVYg/132', null, null, null, null, null, '0', '0', null, null, '2020-10-28 21:10:54');

INSERT INTO `user` VALUES ('47', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/arlSoIh2szwic8rsFjfQh7Vq3gffFo7yTOV79heY1fPeYAZsDFvM3wAC6ocLf5G2kRHCoWzAq2KfYcrPxbicW5vg/132', null, null, null, null, null, '0', '0', null, null, '2020-10-28 21:11:00');

INSERT INTO `user` VALUES ('48', '1024', 'https://thirdwx.qlogo.cn/mmopen/vi_32/arlSoIh2szwic8rsFjfQh7Vq3gffFo7yTOV79heY1fPeYAZsDFvM3wAC6ocLf5G2kRHCoWzAq2KfYcrPxbicW5vg/132', '1', '180', '1988-08-01', '144', '137', '35', '200', 'obt995TUKes91H6qGLsCC96JP324', '0PRPOAg8t3fdlJ/M2vQmCw==', '2020-11-27 22:19:39');
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
JavaScript
1
https://gitee.com/hccwh/weight-help.git
git@gitee.com:hccwh/weight-help.git
hccwh
weight-help
体重帮
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部
0d507c66 1850385 C8b1a773 1850385