Skip to content

Instantly share code, notes, and snippets.

@Royalone94

Royalone94/jobapp.sql

Created January 13, 2017 00:53
Show Gist options
  • Save Royalone94/145a9454fda9931a10bdbc7e60ea2956 to your computer and use it in GitHub Desktop.
Save Royalone94/145a9454fda9931a10bdbc7e60ea2956 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema artistlancer
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema artistlancer
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `artistlancer` DEFAULT CHARACTER SET utf8 ;
USE `artistlancer` ;
-- -----------------------------------------------------
-- Table `artistlancer`.`artist`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`artist` (
`id` INT(11) NOT NULL DEFAULT 0,
`name` VARCHAR(20) NULL,
`profile` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
`portfolio` VARCHAR(45) NULL,
`availability` TINYINT(1) NULL,
`category` INT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `id_UNIQUE` (`id` ASC))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`model`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`model` (
`id` INT(11) NOT NULL,
`artist_id` INT(11) NULL,
`age` INT(3) NULL,
`height` FLOAT(11) NULL,
`bust` FLOAT(11) NULL,
`waist` FLOAT(11) NULL,
`hip` FLOAT(11) NULL,
`ethnicity` VARCHAR(45) NULL,
`cup` VARCHAR(2) NULL,
`dress` INT(5) NULL,
`shoe` FLOAT(3) NULL,
`haircolor` VARCHAR(15) NULL,
`hairlength` FLOAT(11) NULL,
`eyecolor` VARCHAR(15) NULL,
`shootnudes` TINYINT(1) NULL,
`tattoos` FLOAT(11) NULL,
`piercings` FLOAT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`client`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`client` (
`id` INT(11) NOT NULL,
`profile` VARCHAR(45) NULL,
`name` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`personal_renter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`personal_renter` (
`id` INT(11) NOT NULL,
`profile` VARCHAR(45) NULL,
`name` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`chat_content`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_content` (
`id` INT(11) NOT NULL,
`chatroom_id` VARCHAR(45) NULL,
`text` VARCHAR(200) NULL,
`picture` VARCHAR(200) NULL,
`date` DATETIME NULL,
`read` TINYINT(1) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`chat_idx`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_idx` (
`id` INT(11) NOT NULL,
`employer` INT(11) NULL,
`employee` INT(11) NULL,
`chatroom_id` VARCHAR(100) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`category`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`category` (
`id` INT(11) NOT NULL,
`genre` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`pictures`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`pictures` (
`id` INT(11) NOT NULL,
`url` VARCHAR(45) NULL,
`user_id` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`user` (
`id` INT NOT NULL,
`name` VARCHAR(45) NULL,
`email` VARCHAR(45) NULL,
`password` VARCHAR(45) NULL,
`birthday` DATETIME NULL,
`gender` TINYINT(1) NULL,
`tier` INT(11) NULL,
`membership` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`videos`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`videos` (
`id` INT(11) NOT NULL,
`url` VARCHAR(45) NULL,
`user_id` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`admin` (
`id` INT(11) NOT NULL,
`username` VARCHAR(45) NULL,
`password` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`job`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`job` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`budget` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`jobbidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`jobbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`jobbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`jobbidroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`tfp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`tfp` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`incentives` VARCHAR(45) NULL,
`artist_id` INT(11) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`employee_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`employee_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`employeeroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`prop`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`prop` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`artist_id` INT(11) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`can_ship` TINYINT(1) NULL,
`days` INT(11) NULL,
`type` TINYINT(1) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`location`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`location` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`type` VARCHAR(45) NULL,
`days` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`equipment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`equipment` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`condition` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`days` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`tfpbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`tfpbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`tfpbidroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`locationbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`locationbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`locationbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`equipmentbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`equipmentbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`equipmentbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`propbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`propbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`propbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`feedbacks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`feedbacks` (
`id` INT(11) NOT NULL,
`text` VARCHAR(200) NULL,
`picture` VARCHAR(200) NULL,
`date` DATETIME NULL,
`poster` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Raw
jobapp.sql
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema artistlancer
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema artistlancer
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `artistlancer` DEFAULT CHARACTER SET utf8 ;
USE `artistlancer` ;
-- -----------------------------------------------------
-- Table `artistlancer`.`artist`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`artist` (
`id` INT(11) NOT NULL DEFAULT 0,
`name` VARCHAR(20) NULL,
`profile` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
`portfolio` VARCHAR(45) NULL,
`availability` TINYINT(1) NULL,
`category` INT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `id_UNIQUE` (`id` ASC))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`model`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`model` (
`id` INT(11) NOT NULL,
`artist_id` INT(11) NULL,
`age` INT(3) NULL,
`height` FLOAT(11) NULL,
`bust` FLOAT(11) NULL,
`waist` FLOAT(11) NULL,
`hip` FLOAT(11) NULL,
`ethnicity` VARCHAR(45) NULL,
`cup` VARCHAR(2) NULL,
`dress` INT(5) NULL,
`shoe` FLOAT(3) NULL,
`haircolor` VARCHAR(15) NULL,
`hairlength` FLOAT(11) NULL,
`eyecolor` VARCHAR(15) NULL,
`shootnudes` TINYINT(1) NULL,
`tattoos` FLOAT(11) NULL,
`piercings` FLOAT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`client`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`client` (
`id` INT(11) NOT NULL,
`profile` VARCHAR(45) NULL,
`name` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`personal_renter`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`personal_renter` (
`id` INT(11) NOT NULL,
`profile` VARCHAR(45) NULL,
`name` VARCHAR(45) NULL,
`profession` VARCHAR(45) NULL,
`location` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`chat_content`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_content` (
`id` INT(11) NOT NULL,
`chatroom_id` VARCHAR(45) NULL,
`text` VARCHAR(200) NULL,
`picture` VARCHAR(200) NULL,
`date` DATETIME NULL,
`read` TINYINT(1) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`chat_idx`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_idx` (
`id` INT(11) NOT NULL,
`employer` INT(11) NULL,
`employee` INT(11) NULL,
`chatroom_id` VARCHAR(100) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`category`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`category` (
`id` INT(11) NOT NULL,
`genre` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`pictures`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`pictures` (
`id` INT(11) NOT NULL,
`url` VARCHAR(45) NULL,
`user_id` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`user` (
`id` INT NOT NULL,
`name` VARCHAR(45) NULL,
`email` VARCHAR(45) NULL,
`password` VARCHAR(45) NULL,
`birthday` DATETIME NULL,
`gender` TINYINT(1) NULL,
`tier` INT(11) NULL,
`membership` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`videos`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`videos` (
`id` INT(11) NOT NULL,
`url` VARCHAR(45) NULL,
`user_id` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`admin` (
`id` INT(11) NOT NULL,
`username` VARCHAR(45) NULL,
`password` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`job`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`job` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`budget` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`jobbidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`jobbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`jobbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`jobbidroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`tfp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`tfp` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`incentives` VARCHAR(45) NULL,
`artist_id` INT(11) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`employee_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`employee_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`employeeroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`prop`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`prop` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`artist_id` INT(11) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`can_ship` TINYINT(1) NULL,
`days` INT(11) NULL,
`type` TINYINT(1) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`location`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`location` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`preferences` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`type` VARCHAR(45) NULL,
`days` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`equipment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`equipment` (
`id` INT(11) NOT NULL,
`title` VARCHAR(45) NULL,
`description` VARCHAR(45) NULL,
`condition` VARCHAR(45) NULL,
`right` VARCHAR(45) NULL,
`territory` VARCHAR(45) NULL,
`deadline` INT(11) NULL,
`price_day` FLOAT(20) NULL,
`client_id` VARCHAR(45) NULL,
`bidroom_id` VARCHAR(45) NULL,
`employeeroom_id` VARCHAR(45) NULL,
`days` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`tfpbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`tfpbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`tfpbidroom_id` VARCHAR(45) NULL,
`budget` FLOAT(20) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`locationbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`locationbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`locationbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`equipmentbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`equipmentbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`equipmentbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`propbid_room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`propbid_room` (
`id` INT(11) NOT NULL,
`user_id` INT(11) NULL,
`propbidroom_id` VARCHAR(45) NULL,
`price_day` FLOAT(20) NULL,
`days` INT(11) NULL,
`chatroom_id` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `artistlancer`.`feedbacks`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `artistlancer`.`feedbacks` (
`id` INT(11) NOT NULL,
`text` VARCHAR(200) NULL,
`picture` VARCHAR(200) NULL,
`date` DATETIME NULL,
`poster` INT(11) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment