WebRoot/database/121210150203.sql

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

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

/*
MySQL Backup
Source Server Version: 5.5.20
Source Database: kc
Date: 12/10/2012 15:02:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `about`
-- ----------------------------
DROP TABLE IF EXISTS `about`;
CREATE TABLE `about` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `loginip` varchar(20) DEFAULT NULL,
  `logintime` varchar(30) DEFAULT NULL,
  `logincount` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `dish`
-- ----------------------------
DROP TABLE IF EXISTS `dish`;
CREATE TABLE `dish` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `about` varchar(255) DEFAULT NULL,
  `shtick` varchar(255) DEFAULT NULL,
  `material` varchar(255) DEFAULT NULL,
  `hot` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `memberprice` double DEFAULT NULL,
  `isnew` varchar(255) DEFAULT NULL,
  `senddate` varchar(255) DEFAULT NULL,
  `dishSort_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2F0D9A58641C3B` (`dishSort_id`),
  CONSTRAINT `FK2F0D9A58641C3B` FOREIGN KEY (`dishSort_id`) REFERENCES `dishsort` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `dishsort`
-- ----------------------------
DROP TABLE IF EXISTS `dishsort`;
CREATE TABLE `dishsort` (