DB_51Aspx/db.sql

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

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

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


/*!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*/`daxueshengzaixianzufangpingtai` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `daxueshengzaixianzufangpingtai`;

/*Table structure for table `baoxiu` */

DROP TABLE IF EXISTS `baoxiu`;

CREATE TABLE `baoxiu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
  `fangwu_id` int(11) DEFAULT NULL COMMENT '房屋',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `baoxiu_uuid_number` varchar(200) DEFAULT NULL COMMENT '报修编号',
  `baoxiu_address` varchar(200) DEFAULT NULL COMMENT '报修标题 Search111  ',
  `baoxiu_name` varchar(200) DEFAULT NULL COMMENT '报修位置',
  `baoxiu_photo` varchar(200) DEFAULT NULL COMMENT '报修图片',
  `baoxiu_types` int(11) NOT NULL COMMENT '报修类型 Search111 ',
  `baoxiu_content` longtext COMMENT '报修内容',
  `baoxiu_yesno_types` int(11) DEFAULT NULL COMMENT '申请状态 Search111',
  `baoxiu_yesno_text` longtext COMMENT '审核意见',
  `baoxiu_shenhe_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '报修时间',
  `baoxiu_zhuangtai_types` int(11) DEFAULT '1' COMMENT '报修状态 Search111 ',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='报修';

/*Data for the table `baoxiu` */

insert  into `baoxiu`(`id`,`fangwu_id`,`yonghu_id`,`baoxiu_uuid_number`,`baoxiu_address`,`baoxiu_name`,`baoxiu_photo`,`baoxiu_types`,`baoxiu_content`,`baoxiu_yesno_types`,`baoxiu_yesno_text`,`baoxiu_shenhe_time`,`insert_time`,`baoxiu_zhuangtai_types`,`create_time`) values (1,1,3,'1682662933850','报修标题1','报修位置1','upload/baoxiu1.jpg',2,'报修内容1',1,NULL,NULL,'2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(2,2,3,'1682662933828','报修标题2','报修位置2','upload/baoxiu2.jpg',3,'报修内容2',1,NULL,NULL,'2023-04-28 14:22:13',1,'2023-04-28 14:22:13'),(3,3,1,'1682662933843','报修标题3','报修位置3','upload/baoxiu3.jpg',4,'报修内容3',1,NULL,NULL,'2023-04-28 14:22:13',2,'2023-04-28 14:22:13'),(4,4,1,'1682662933898','报修标题4','报修位置4','upload/baoxiu4.jpg',3,'报修内容4',1,NULL,NULL,'2023-04-28 14:22:13',2,'2023-04-28 14:22:13'),(5,5,1,'1682662933809','报修标题5','报修位置5','upload/baoxiu5.jpg',3,'报修内容5',1,NULL,NULL,'2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(6,6,1,'1682662933886','报修标题6','报修位置6','upload/baoxiu6.jpg',4,'报修内容6',1,NULL,NULL,'2023-04-28 14:22:13',2,'2023-04-28 14:22:13'),(7,7,1,'1682662933899','报修标题7','报修位置7','upload/baoxiu7.jpg',2,'报修内容7',1,NULL,NULL,'2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(8,8,3,'1682662933845','报修标题8','报修位置8','upload/baoxiu8.jpg',4,'报修内容8',1,NULL,NULL,'2023-04-28 14:22:13',1,'2023-04-28 14:22:13'),(9,9,2,'1682662933883','报修标题9','报修位置9','upload/baoxiu9.jpg',1,'报修内容9',1,NULL,NULL,'2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(10,10,1,'1682662933838','报修标题10','报修位置10','upload/baoxiu10.jpg',2,'报修内容10',1,NULL,NULL,'2023-04-28 14:22:13',2,'2023-04-28 14:22:13'),(11,11,1,'1682662933885','报修标题11','报修位置11','upload/baoxiu11.jpg',2,'报修内容11',2,'归还','2023-04-28 15:35:28','2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(12,12,2,'1682662933834','报修标题12','报修位置12','upload/baoxiu12.jpg',2,'报修内容12',1,NULL,NULL,'2023-04-28 14:22:13',3,'2023-04-28 14:22:13'),(13,13,2,'1682662933870','报修标题13','报修位置13','upload/baoxiu13.jpg',1,'报修内容13',1,NULL,NULL,'2023-04-28 14:22:13',1,'2023-04-28 14:22:13'),(14,14,2,'1682662933856','报修标题14','报修位置14','upload/baoxiu14.jpg',2,'报修内容14',1,NULL,NULL,'2023-04-28 14:22:13',1,'2023-04-28 14:22:13'),(15,11,1,'1682667601909','查实的上传','测试','upload/1682667613554.jpg',4,'测试是',2,'红色的sad ','2023-04-28 15:41:06','2023-04-28 15:40:17',3,'2023-04-28 15:40:17');

/*Table structure for table `baoxiu_commentback` */

DROP TABLE IF EXISTS `baoxiu_commentback`;

CREATE TABLE `baoxiu_commentback` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `baoxiu_id` int(11) DEFAULT NULL COMMENT '报修',
  `yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
  `baoxiu_commentback_text` longtext COMMENT '评价内容',
  `insert_time` timestamp NULL DEFAULT NULL COMMENT '评价时间',
  `reply_text` longtext COMMENT '回复内容',
  `update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)