DB_51aspx/db_marry.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : 1

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

Date: 2019-10-09 12:00:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `grapher`
-- ----------------------------
DROP TABLE IF EXISTS `grapher`;
CREATE TABLE `grapher` (
`gid`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名' ,
`tel`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话' ,
PRIMARY KEY (`gid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
/*!50003 AUTO_INCREMENT=5 */

;

-- ----------------------------
-- Records of grapher
-- ----------------------------
BEGIN;
INSERT INTO `grapher` VALUES ('1', '张三', '13888888888'), ('2', '王二', '13888888888'), ('3', '李四', '13888888888'), ('4', '金坷垃', '13888888888');
COMMIT;

-- ----------------------------
-- Table structure for `order`
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`oid`  int(11) NOT NULL AUTO_INCREMENT ,
`time`  datetime NOT NULL COMMENT '时间' ,
`gid`  int(11) NOT NULL COMMENT '摄影师编号' ,
`uid`  int(11) NOT NULL COMMENT '用户编号' ,
`mark`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注' ,
PRIMARY KEY (`oid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
/*!50003 AUTO_INCREMENT=3 */

;

-- ----------------------------
-- Records of order