数据库/db.sql

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

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

/*
SQLyog Community Edition- MySQL GUI v6.54
MySQL - 5.5.25a : Database - yanglaoyuan
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

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

/*!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' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`yanglaoyuan` /*!40100 DEFAULT CHARACTER SET gb2312 */;

USE `yanglaoyuan`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `realname` varchar(50) DEFAULT NULL,
  `sex` varchar(50) DEFAULT NULL,
  `age` varchar(50) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `addtime` varchar(50) DEFAULT NULL,
  `sf` varchar(50) DEFAULT '普通管理员',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;

/*Data for the table `admin` */

insert  into `admin`(`id`,`username`,`password`,`realname`,`sex`,`age`,`address`,`tel`,`addtime`,`sf`) values (1,'admin','111','陈道明','男','25','成都市金牛区','13900000000','2016-03-09 22:59:56','系统管理员'),(12,'111','111','奥巴马','男','22','洪山区珞喻路吴家湾','13800000000','2016-03-18 02:07:31','普通管理员');

/*Table structure for table `fy` */

DROP TABLE IF EXISTS `fy`;

CREATE TABLE `fy` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `lr` varchar(500) DEFAULT NULL,
  `fy` varchar(500) DEFAULT NULL,
  `kc` varchar(500) DEFAULT NULL,
  `zt` varchar(500) DEFAULT NULL,
  `xx` varchar(500) DEFAULT NULL,
  `sji` varchar(500) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

/*Data for the table `fy` */

insert  into `fy`(`id`,`lr`,`fy`,`kc`,`zt`,`xx`,`sji`) values (1,'张三丰','1900','200','未付','test','1700.0');

/*Table structure for table `hgqj` */