database/ssmyyjxcglxthsg4061a5.sql

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

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

/*
Navicat MySQL Data Transfer

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

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

Date: 2019-03-17 01:17:45
*/

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=4 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2019-02-25 13:37:22');
INSERT INTO `allusers` VALUES ('3', '111111', '111111', '普通管理员', '2019-03-01 16:39:09');

-- ----------------------------
-- Table structure for `caigouxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `caigouxinxi`;
CREATE TABLE `caigouxinxi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caigoubianhao` varchar(50) DEFAULT NULL,
  `gonghuoshang` varchar(50) DEFAULT NULL,
  `yaopinbianhao` varchar(50) DEFAULT NULL,
  `yaopinmingcheng` varchar(50) DEFAULT NULL,
  `kucun` varchar(50) DEFAULT NULL,
  `jiage` varchar(50) DEFAULT NULL,
  `caigoushuliang` varchar(50) DEFAULT NULL,
  `caigouriqi` date DEFAULT NULL,
  `issh` varchar(10) DEFAULT '否',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of caigouxinxi
-- ----------------------------
INSERT INTO `caigouxinxi` VALUES ('2', '03011634141282', 'fdg', '018', '氨溴特罗口服液', '12', '22', '22', '2019-03-01', '是', '2019-03-01 16:34:19');
INSERT INTO `caigouxinxi` VALUES ('3', '03011637211954', 'fds反倒是', '001', '柴桂颗粒', '60', '100', '39', '2019-03-01', '是', '2019-03-01 16:37:32');
INSERT INTO `caigouxinxi` VALUES ('4', '03011643429766', '12对方是否大多数非', '11111112', '覆盖大法规的规范', '0', '33', '888', '2019-03-01', '是', '2019-03-01 16:43:50');