DB_51Aspx/db.sql

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

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

/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - nongchanpincangkuguanli
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`nongchanpincangkuguanli` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `nongchanpincangkuguanli`;

/*Table structure for table `config` */

DROP TABLE IF EXISTS `config`;

CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='配置文件';

/*Data for the table `config` */

insert  into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/jspmm2ql6/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspmm2ql6/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspmm2ql6/upload/picture3.jpg'),(4,'picture4','http://localhost:8080/jspmm2ql6/upload/picture4.jpg'),(5,'picture5','http://localhost:8080/jspmm2ql6/upload/picture5.jpg'),(6,'homepage',NULL);

/*Table structure for table `dictionary` */

DROP TABLE IF EXISTS `dictionary`;

CREATE TABLE `dictionary` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
  `dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
  `code_index` int(11) DEFAULT NULL COMMENT '编码',
  `index_name` varchar(200) DEFAULT NULL COMMENT '编码名字  Search111 ',
  `super_id` int(11) DEFAULT NULL COMMENT '父字段id',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='字典表';

/*Data for the table `dictionary` */

insert  into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`create_time`) values (1,'sex_types','性别',1,'男',NULL,'2021-03-10 17:37:17'),(2,'sex_types','性别',2,'女',NULL,'2021-03-10 17:37:17'),(3,'politics_types','政治面貌',1,'群众',NULL,'2021-03-10 17:37:17'),(4,'politics_types','政治面貌',2,'党员',NULL,'2021-03-10 17:37:17'),(5,'goods_types','物资类型',1,'粮油',NULL,'2021-03-10 17:37:17'),(6,'goods_types','物资类型',2,'果蔬',NULL,'2021-03-10 17:37:17'),(7,'goods_types','物资类型',3,'花卉',NULL,'2021-03-10 17:37:17'),(8,'goods_types','物资类型',4,'林产品',NULL,'2021-03-10 17:37:17'),(9,'goods_types','物资类型',5,'畜禽产品',NULL,'2021-03-10 17:37:17'),(10,'goods_types','物资类型',6,'水产品',NULL,'2021-03-10 17:37:17'),(11,'order_types','订单类型',1,'出库',NULL,'2021-03-10 17:37:17'),(12,'order_types','订单类型',2,'入库',NULL,'2021-03-10 17:37:17'),(13,'caozuo_types','操作类型',1,'已操作',NULL,'2021-03-10 17:37:17'),(14,'caozuo_types','操作类型',2,'未操作',NULL,'2021-03-10 17:37:17'),(15,'entrust_types','委托物资状态',1,'不同意',NULL,'2021-03-10 17:37:17'),(16,'entrust_types','委托物资状态',2,'同意',NULL,'2021-03-10 17:37:17'),(18,'goods_types','物资类型',8,'8',NULL,'2021-03-11 18:01:32'),(19,'goods_types','物资类型',9,'是',NULL,'2021-03-11 21:05:55');

/*Table structure for table `entrust_in_out_order` */

DROP TABLE IF EXISTS `entrust_in_out_order`;

CREATE TABLE `entrust_in_out_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',