DB_51Aspx/jspmmmjc4.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: jspmmmjc4
-- ------------------------------------------------------
-- Server version	5.7.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `caipinxinxi`
--

DROP TABLE IF EXISTS `caipinxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caipinxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `shangjiabianhao` varchar(200) DEFAULT NULL COMMENT '商家编号',
  `shangjiaming` varchar(200) DEFAULT NULL COMMENT '商家名',
  `caixi` varchar(200) DEFAULT NULL COMMENT '菜系',
  `meishimingcheng` varchar(200) DEFAULT NULL COMMENT '美食名称',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  `danjia` int(11) DEFAULT NULL COMMENT '单价',
  `zhuliao` longtext COMMENT '主料',
  `fenliang` int(11) DEFAULT NULL COMMENT '份量',
  `meishijieshao` longtext COMMENT '美食介绍',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  `clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616559272395 DEFAULT CHARSET=utf8 COMMENT='菜品信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `caipinxinxi`
--

LOCK TABLES `caipinxinxi` WRITE;
/*!40000 ALTER TABLE `caipinxinxi` DISABLE KEYS */;
INSERT INTO `caipinxinxi` VALUES (41,'2021-03-24 03:58:39','101','1','粤菜','美食22','http://localhost:8080/jspmmmjc4/upload/caipinxinxi_tupian1.jpg',12,'猪肉',111,'好吃到爆',2,2,'2021-03-24 12:12:20',8),(43,'2021-03-24 03:58:39','商家编号3','商家名3','菜系3','美食名称3','http://localhost:8080/jspmmmjc4/upload/caipinxinxi_tupian3.jpg',3,'主料3',3,'美食介绍3',3,3,'2021-03-24 11:58:39',3),(44,'2021-03-24 03:58:39','商家编号4','商家名4','菜系4','美食名称4','http://localhost:8080/jspmmmjc4/upload/caipinxinxi_tupian4.jpg',4,'主料4',4,'美食介绍4',4,4,'2021-03-24 11:58:39',4),(45,'2021-03-24 03:58:39','商家编号5','商家名5','菜系5','美食名称5','http://localhost:8080/jspmmmjc4/upload/caipinxinxi_tupian5.jpg',5,'主料5',5,'美食介绍5',5,5,'2021-03-24 11:58:39',5),(46,'2021-03-24 03:58:39','商家编号6','商家名6','菜系6','美食名称6','http://localhost:8080/jspmmmjc4/upload/caipinxinxi_tupian6.jpg',6,'主料6',6,'美食介绍6',6,6,'2021-03-24 12:11:22',7),(1616559260960,'2021-03-24 04:14:20','101','北大美食','粤菜','美食1231','http://localhost:8080/jspmmmjc4/upload/1616559252335.jpg',12,'12213',111,'2133111',0,0,NULL,0),(1616559272394,'2021-03-24 04:14:32','101','北大美食','川菜','美食名称5','http://localhost:8080/jspmmmjc4/upload/1616559282199.jpg',121,'121',12,'1213',0,0,'2021-03-24 12:14:37',2);
/*!40000 ALTER TABLE `caipinxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `caixifenlei`
--

DROP TABLE IF EXISTS `caixifenlei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;