database/ssmztjdxthsg7588aha2.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50160
Source Host           : localhost:3306
Source Database       : ssmztjdxthsg7588aha2

Target Server Type    : MYSQL
Target Server Version : 50160
File Encoding         : 65001

Date: 2020-03-31 13:03:20
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT '普通管理员',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2020-03-28 17:12:14');

-- ----------------------------
-- Table structure for `canyinmeishi`
-- ----------------------------
DROP TABLE IF EXISTS `canyinmeishi`;
CREATE TABLE `canyinmeishi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `canyinbianhao` varchar(50) DEFAULT NULL,
  `canyinmingcheng` varchar(50) DEFAULT NULL,
  `leibie` varchar(50) DEFAULT NULL,
  `jiage` varchar(50) DEFAULT NULL,
  `tupian` varchar(50) DEFAULT NULL,
  `jianjie` varchar(500) DEFAULT NULL,
  `beizhu` varchar(500) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of canyinmeishi
-- ----------------------------
INSERT INTO `canyinmeishi` VALUES ('2', '3113705870', 'C餐饮', '饮品', '87', 'upload/canyinmeishi2.jpg', 'abc', '没问题', '2020-03-28 17:12:14');
INSERT INTO `canyinmeishi` VALUES ('3', '3113707962', 'Y餐饮', '饮品', '12', 'upload/canyinmeishi1.jpg', 'abc', '暂无', '2020-03-28 17:12:14');
INSERT INTO `canyinmeishi` VALUES ('4', '3113783503', 'D餐饮', '饮品', '47', 'upload/canyinmeishi4.jpg', '无', 'ok', '2020-03-28 17:12:14');
INSERT INTO `canyinmeishi` VALUES ('5', '3113783503', 'P餐饮', '餐品', '71', 'upload/canyinmeishi5.jpg', 'ok', 'ok', '2020-03-28 17:12:14');
INSERT INTO `canyinmeishi` VALUES ('6', '3113781128', 'F餐饮', '餐品', '41', 'upload/canyinmeishi3.jpg', '没问题', '无', '2020-03-28 17:12:14');