食谱菜谱大全（数据库）

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50726 Source Host : localhost:3306 Source Database : datasets Target Server Type : MYSQL Target Server Version : 50726 File Encoding : 65001 Date: 2022-06-28 15:31:09 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for food_meau -- ---------------------------- DROP TABLE IF EXISTS `food_meau`; CREATE TABLE `food_meau` ( `meauID` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `tags` varchar(255) DEFAULT NULL, `method` varchar(255) DEFAULT NULL, `img` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `level` varchar(255) DEFAULT NULL, `peopleNum` varchar(255) DEFAULT NULL, `taste` varchar(255) DEFAULT NULL, `prepareTime` varchar(255) DEFAULT NULL, `cookTime` varchar(255) DEFAULT NULL, `mainIngredient` text COMMENT '主料', `accessories` text COMMENT '辅料', `measure` text COMMENT '步骤', `techniques` varchar(255) DEFAULT NULL COMMENT '技巧', `scrapyTime` varchar(255) DEFAULT NULL, PRIMARY KEY (`meauID`) ) ENGINE=InnoDB AUTO_INCREMENT=3962 DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of food_meau -- ---------------------------- INSERT INTO `food_meau` VALUES ('1', '柠檬戚风蛋糕', '健脑益智,保肝,动脉硬化,防癌,延年益寿,美容护肤,镇静助眠,美容养颜,益智,润肺生津,润肺止咳,降血压,抗衰老', '烘焙', 'http://s1.st.meishij.net/r/141/154/4351141/a4351141_151783971393229.jpg', 'http://www.meishij.net/zuofa/ningmengqifengdangao_2.html', '初级入门', '3人份', '甜味', '5分钟', '<60分钟', '{\"mainIngredientList\": [{\"weight\": \"3\\u4e2a\", \"name\": \"\\u9e21\\u86cb\", \"imgUrl\": \"http://images.meishij.net/p/20110718/769130e8c9a062a32ed14383c083561f_60x60.jpg\"}, {\"weight\": \"50\\u514b\", \"name\": \"\\u4f4e\\u7b4b\\u9762\\u7c89\", \"imgUrl\": \"http://site.meishij.net/shicaiimg/243/shicai25243_60x60.jpg\"}, {\"weight\": \"30\\u514b\", \"name\": \"\\u725b\\u5976\", \"imgUrl\": \"http://images.meishij.net/p/20110719/6f1b7f40cb46e52033747505bef1a2e1_60x60.jpg\"}, {\"weight\": \"40\\u514b\", \"name\": \"\\u7ec6\\u7802\\u7cd6\", \"imgUrl\": \"http://images.meishij.net/p/20130312/f5b5fca4dc738167b871559a100a8a11_60x60.jpg\"}, {\"weight\": \"20\\u514b\", \"name\": \"\\u7389\\u7c73\\u6cb9\", \"imgUrl\": \"http://site.meishij.net/shicaiimg/112/shicai1362_60x60.jpg\"}, {\"weight\": \"2\\u514b\", \"name\": \"\\u67e0\\u6aac\\u76ae\\u788e\", \"imgUrl\": \"http://images.meishij.net/p/20130918/c06c2fa329d52abb6e5cad538d6ad30c_60x60.jpg\"}]}', '{\"accessoriesList\": [{\"name\": \"\\u7535\\u52a8\\u6253\\u86cb\\u5668\", \"weight\": \"\"}, {\"name\": \"\\u624b\\u52a8\\u6253\\u86cb\\u5668\", \"weight\": \"\"}, {\"name\": \"\\u70e4\\u7bb1\", \"weight\": \"\"}]}', '{\"measureList\": [{\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783743456530.jpg\"], \"step\": \"1.\", \"des\": \"\\u5148\\u5c06\\u9e21\\u86cb\\u7684\\u86cb\\u767d\\u4e0e\\u86cb\\u9ec4\\u5206\\u5f00\\u653e\\u5728\\u4e24\\u4e2a\\u65e0\\u6c34\\u65e0\\u6cb9\\u76c6\\u5185\\uff1b\\uff08\\u9e21\\u86cb\\u662f\\u5e26\\u58f350\\u514b\\u4ee5\\u4e0a\\u76843\\u4e2a\\uff0c\\u51b7\\u85cf\\u4fdd\\u5b58\\u7684\\uff0c\\u4e0d\\u8981\\u7528\\u5ba4\\u6e29\\u7684\\uff0c\\u7279\\u522b\\u590f\\u5929\\u65f6\\uff09\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783752597589.jpg\"], \"step\": \"2.\", \"des\": \"\\u5148\\u628a\\u7389\\u7c73\\u6cb9\\u4e0e\\u86cb\\u9ec4\\u6df7\\u5408\\u6405\\u6253\\u5747\\u5300\\uff1b\\uff08\\u6df7\\u5408\\u5b8c\\u6210\\u540e\\uff0c\\u86cb\\u9ec4\\u6db2\\u5fae\\u5fae\\u53d1\\u767d\\uff0c\\u65e0\\u6cb9\\u82b1\\uff0c\\u505a\\u597d\\u8fd9\\u4e00\\u6b65\\u621a\\u98ce\\u4e0d\\u5bb9\\u6613\\u51fa\\u73b0\\u5e03\\u4e01\\u5c42\\uff09\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783761887394.jpg\"], \"step\": \"3.\", \"des\": \"\\u518d\\u628a\\u725b\\u5976\\uff08\\u6e05\\u6c34\\uff09\\u5206\\u6b21\\u52a0\\u5165\\u5230\\u86cb\\u9ec4\\u6db2\\u4e2d\\u6405\\u6253\\u5747\\u5300\\uff0c\\u6df7\\u5408\\u5b8c\\u6210\\u540e\\u86cb\\u9ec4\\u6db2\\u660e\\u663e\\u53d1\\u767d\\uff0c\\u6ca1\\u6709\\u6cb9\\u82b1\\u6d6e\\u5728\\u4e0a\\u9762\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783766184104.jpg\"], \"step\": \"4.\", \"des\": \"\\u52a0\\u51652\\u514b\\u7684\\u67e0\\u6aac\\u76ae\\u788e\\u4e0e\\u86cb\\u9ec4\\u6db2\\u4f53\\u6df7\\u5408\\u6405\\u62cc\\u5747\\u5300\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783794732828.jpg\"], \"step\": \"5.\", \"des\": \"\\u52a0\\u5165\\u8fc7\\u7b5b\\u7684\\u4f4e\\u7b4b\\u9762\\u7c89\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783802700601.jpg\"], \"step\": \"6.\", \"des\": \"\\u8f7b\\u8f7b\\u6405\\u62cc\\u81f3\\u5747\\u5300\\u65e0\\u9897\\u7c92\\u72b6\\u5373\\u53ef\\uff1b\\uff08\\u6ce8\\u610f\\u4e0d\\u8981\\u8fc7\\u5ea6\\u6405\\u62cc\\uff0c\\u4e0d\\u8981\\u6709\\u9897\\u7c92\\uff0c\\u4e0d\\u7136\\u6210\\u54c1\\u4f1a\\u975e\\u5e38\\u7c97\\u7cd9\\uff09\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783810381690.jpg\"], \"step\": \"7.\", \"des\": \"\\u63a5\\u7740\\u6211\\u4eec\\u6765\\u6253\\u53d1\\u86cb\\u767d\\uff0c\\u4e00\\u4e2a\\u6253\\u53d1\\u6210\\u529f\\u7684\\u86cb\\u767d\\u662f\\u505a\\u51fa\\u597d\\u621a\\u98ce\\u7684\\u57fa\\u7840\\uff1a\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783818483616.jpg\"], \"step\": \"8.\", \"des\": \"\\u7528\\u86cb\\u52a8\\u6253\\u86cb\\u5668\\u5c06\\u86cb\\u767d\\u6253\\u81f3\\u7c97\\u6ce1\\uff08\\u6ce8\\u610f\\u6253\\u81f3\\u6ca1\\u6709\\u6db2\\u4f53\\u86cb\\u767d\\u65f6\\u5c31\\u53ef\\u4ee5\\uff09\\uff0c\\u8fd9\\u662f\\u52a0\\u5165\\u4e00\\u534a\\u768420\\u514b\\u7ec6\\u7802\\u7cd6\\uff0c\\uff08\\u6ce8\\u610f\\u662f\\u4e00\\u534a\\uff0c\\u4e0d\\u662f\\u5e73\\u5e38\\u505a\\u621a\\u98ce\\u65f6\\u7684\\u4e09\\u5206\\u4e4b\\u4e00\\uff09\\u7ee7\\u7eed\\u6253\\u53d1\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783826312141.jpg\"], \"step\": \"9.\", \"des\": \"\\u7ee7\\u7eed\\u6253\\u53d1\\u81f3\\u6709\\u6bd4\\u8f83\\u7ec6\\u817b\\u7684\\u6ce1\\u6cab\\uff0c\\u4f53\\u79ef\\u4e5f\\u660e\\u663e\\u589e\\u5927\\u65f6\\uff0c\\u52a0\\u5165\\u5269\\u4e0b\\u4e00\\u534a\\u768420\\u514b\\u7ec6\\u7802\\u7cd6\\uff0c\\u7ee7\\u7eed\\u6253\\u53d1\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783835360598.jpg\"], \"step\": \"10.\", \"des\": \"\\u7ee7\\u7eed\\u6253\\u53d1\\u81f3\\u86cb\\u767d\\u975e\\u5e38\\u7ec6\\u817b\\uff0c\\u63d0\\u8d77\\u6253\\u86cb\\u5668\\u4f1a\\u5448\\u4e00\\u4e2a\\u5c16\\u5c16\\u7684\\u5c0f\\u89d2\\uff08\\u70e4\\u7bb1\\u4e0a\\u4e0b\\u706b130\\u5ea6\\u9884\\u70ed10\\u5206\\u949f\\uff09\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783842752502.jpg\"], \"step\": \"11.\", \"des\": \"\\u5148\\u53d6\\u4e09\\u5206\\u4e4b\\u4e00\\u7684\\u86cb\\u767d\\u5230\\u5230\\u86cb\\u9ec4\\u7cca\\u4e2d\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783850784568.jpg\"], \"step\": \"12.\", \"des\": \"\\u7528\\u522e\\u5200\\u6216\\u624b\\u52a8\\u6253\\u86cb\\u5668\\u4ece\\u4e0b\\u5f80\\u4e0a\\u7ffb\\u62cc\\uff0c\\u52a8\\u4f5c\\u8f7b\\u67d4\\u5373\\u53ef\\uff0c\\u4e0d\\u7528\\u8fc7\\u4efd\\u5c0f\\u5fc3\\uff1b\"}, {\"picture\": [\"http://s1.st.meishij.net/rs/141/154/4351141/n4351141_151783858750023.jpg\"], \"step\": \"13.\", \"des\": \"\\u5c06\\u6df7\\u5408\\u597d\\u7684\\u86cb\\u9ec4\\u7cca\\uff0c\\u5012\\u5165\\u5269\\u4e0b\\u4e09\\u5206\\u4e4b\\u4e8c\\u7684\\u86cb\\u767d\\u91cc\\uff0c\\u7ee7\\u7eed\\u7528\\u7ffb\\u62cc\\u7684\\u65b9\\u5f0f\\u6df7\\u5408\\u5747\\u5300\\uff1b\"}, {\"picture\": [\"http://s1.st.meishi