text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost_3306
  Source Server Version : 80017
  Source Host           : localhost:3306
  Source Database       : freelancer
  
  Target Server Type    : MYSQL
  Target Server Version : 80017
  File Encoding         : 65001
  
  Date: 2020-07-07 14:28:12
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for developer
  -- ----------------------------
  DROP TABLE IF EXISTS `developer`;
  CREATE TABLE `developer` (
    `url` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `project` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`url`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for match
  -- ----------------------------
  DROP TABLE IF EXISTS `match`;
  CREATE TABLE `match` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `projectUrl` varchar(255) NOT NULL,
    `developerUrl` varchar(255) NOT NULL,
    `isAward` tinyint(4) NOT NULL,
    `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=26134 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for project
  -- ----------------------------
  DROP TABLE IF EXISTS `project`;
  CREATE TABLE `project` (
    `url` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `tag` varchar(255) NOT NULL,
    `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `match` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`url`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  