|
/*
|
|
Navicat MySQL Data Transfer
|
|
|
|
Source Server : Tina
|
|
Source Server Version : 50506
|
|
Source Host : localhost:3306
|
|
Source Database : missphoto
|
|
|
|
Target Server Type : MYSQL
|
|
Target Server Version : 50506
|
|
File Encoding : 65001
|
|
|
|
Date: 2016-12-11 16:17:00
|
|
*/
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `comment`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `comment`;
|
|
CREATE TABLE `comment` (
|
|
`cdid` int(5) NOT NULL,
|
|
`cuid` int(5) NOT NULL,
|
|
`comment` varchar(30) NOT NULL,
|
|
PRIMARY KEY (`cdid`,`cuid`),
|
|
KEY `cuid` (`cuid`),
|
|
CONSTRAINT `cdid` FOREIGN KEY (`cdid`) REFERENCES `draw` (`did`),
|
|
CONSTRAINT `cuid` FOREIGN KEY (`cuid`) REFERENCES `user` (`uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of comment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `draw`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `draw`;
|
|
CREATE TABLE `draw` (
|
|
`did` int(5) NOT NULL AUTO_INCREMENT,
|
|
`dlike` int(5) NOT NULL,
|
|
`durl` char(30) NOT NULL,
|
|
`udid` int(5) NOT NULL,
|
|
PRIMARY KEY (`did`),
|
|
KEY `udid` (`udid`),
|
|
CONSTRAINT `udid` FOREIGN KEY (`udid`) REFERENCES `user` (`uid`) ON UPDATE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of draw
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `request`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `request`;
|
|
CREATE TABLE `request` (
|
|
`rid` int(5) NOT NULL AUTO_INCREMENT,
|
|
`rdate` date NOT NULL,
|
|
`rdetail` varchar(30) NOT NULL,
|
|
`ruid` int(5) NOT NULL,
|
|
PRIMARY KEY (`rid`),
|
|
KEY `ruid` (`ruid`),
|
|
CONSTRAINT `ruid` FOREIGN KEY (`ruid`) REFERENCES `user` (`uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of request
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `user`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `user`;
|
|
CREATE TABLE `user` (
|
|
`uid` int(5) NOT NULL AUTO_INCREMENT COMMENT '用户id',
|
|
`uname` varchar(20) NOT NULL COMMENT '用户名',
|
|
`uaccount` varchar(20) NOT NULL COMMENT '用户注册使用的账号（手机/qq/微博）',
|
|
`uimage` varchar(20) DEFAULT NULL,
|
|
PRIMARY KEY (`uid`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Records of user
|
|
-- ----------------------------
|
|
INSERT INTO `user` VALUES ('1', 'zhangtianyi', '995004563', null);
|
|
INSERT INTO `user` VALUES ('2', 'yitianzhang', '1523113593', null);
|
|
INSERT INTO `user` VALUES ('3', 'wangwang', '我是天才', null);
|
.