Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. Read more...
Download (2.98 KB)

Task #616142 » jfinal_demo.sql

中宇 闫, 2016-12-06 07:21 AM

 
/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50506
Source Host : localhost:3306
Source Database : jfinal_demo

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

Date: 2016-12-05 16:12:45
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `blog`
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`content` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES ('7', '时尚女衣 流行女衣 连衣裙 半身裙 尽在恋上猫女衣坊 店铺地址：http//yecaoly.taobao.com', '时尚女衣 流行女衣 连衣裙 半身裙 尽在恋上猫女衣坊 店铺地址：http//yecaoly.taobao.com\r\n￥49.0元 包邮\r\n1.8万人付款 广州');

-- ----------------------------
-- Table structure for `drowde`
-- ----------------------------
DROP TABLE IF EXISTS `drowde`;
CREATE TABLE `drowde` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(10) NOT NULL,
`zanshu` char(20) NOT NULL,
`pinglunshu` char(30) NOT NULL,
`tel` char(13) DEFAULT '-',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of drowde
-- ----------------------------

-- ----------------------------
-- Table structure for `need`
-- ----------------------------
DROP TABLE IF EXISTS `need`;
CREATE TABLE `need` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(10) NOT NULL,
`size` char(20) NOT NULL,
`xuqiu` char(30) NOT NULL,
`time` char(30) NOT NULL,
`tel` char(13) DEFAULT '-',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of need
-- ----------------------------

-- ----------------------------
-- Table structure for `pinglun`
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sunid` int(20) NOT NULL,
`neirong` char(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `sunid` (`sunid`),
CONSTRAINT `pinglun_ibfk_1` FOREIGN KEY (`sunid`) REFERENCES `drowde` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pinglun
-- ----------------------------

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(10) NOT NULL,
`qq` char(20) DEFAULT NULL,
`weibo` char(30) DEFAULT NULL,
`tel` char(13) DEFAULT '-',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
    (1-1/1)