mupdY60P

1
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
5
6-- -----------------------------------------------------
7-- Schema jspd
8-- -----------------------------------------------------
9
10-- -----------------------------------------------------
11-- Schema jspd
12-- -----------------------------------------------------
13CREATE SCHEMA IF NOT EXISTS `jspd` DEFAULT CHARACTER SET utf8 ;
14USE `jspd` ;
15
16-- -----------------------------------------------------
17-- Table `jspd`.`education`
18-- -----------------------------------------------------
19CREATE TABLE IF NOT EXISTS `jspd`.`education` (
20  `id` INT NOT NULL AUTO_INCREMENT,
21  `place` VARCHAR(255) NOT NULL,
22  `start` DATE NOT NULL,
23  `end` DATE NOT NULL,
24  `title` VARCHAR(255) NOT NULL,
25  `obtained` VARCHAR(255) NOT NULL,
26  PRIMARY KEY (`id`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `jspd`.`config`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `jspd`.`config` (
34  `id` INT NOT NULL AUTO_INCREMENT,
35  `aboutme` LONGTEXT NOT NULL,
36  `post` VARCHAR(45) NOT NULL,
37  `twitter` VARCHAR(45) NULL,
38  `intagram` VARCHAR(45) NULL,
39  `facebook` VARCHAR(45) NULL,
40  `linkedin` VARCHAR(45) NULL,
41  `snapchat` VARCHAR(45) NULL,
42  `git` VARCHAR(45) NULL,
43  `email` VARCHAR(45) NOT NULL,
44  `open` TINYINT NOT NULL,
45  PRIMARY KEY (`id`))
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `jspd`.`project`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `jspd`.`project` (
53  `id` INT NOT NULL AUTO_INCREMENT,
54  `name` VARCHAR(45) NOT NULL,
55  `description` LONGTEXT NOT NULL,
56  `post` VARCHAR(45) NOT NULL,
57  `worked` DATE NOT NULL,
58  PRIMARY KEY (`id`))
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `jspd`.`client`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `jspd`.`client` (
66  `id` INT NOT NULL AUTO_INCREMENT,
67  `name` VARCHAR(45) NOT NULL,
68  PRIMARY KEY (`id`))
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `jspd`.`picture`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `jspd`.`picture` (
76  `id` INT NOT NULL AUTO_INCREMENT,
77  `url` LONGTEXT NOT NULL,
78  PRIMARY KEY (`id`))
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `jspd`.`technology`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `jspd`.`technology` (
86  `id` INT NOT NULL AUTO_INCREMENT,
87  `name` VARCHAR(45) NOT NULL,
88  PRIMARY KEY (`id`))
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `jspd`.`project_has_technology`
94-- -----------------------------------------------------
95CREATE TABLE IF NOT EXISTS `jspd`.`project_has_technology` (
96  `project_id` INT NOT NULL,
97  `technology_id` INT NOT NULL,
98  PRIMARY KEY (`project_id`, `technology_id`),
99  INDEX `fk_project_has_technology_technology1_idx` (`technology_id` ASC) VISIBLE,
100  INDEX `fk_project_has_technology_project_idx` (`project_id` ASC) VISIBLE)
101ENGINE = InnoDB;
102
103
104-- -----------------------------------------------------
105-- Table `jspd`.`project_has_picture`
106-- -----------------------------------------------------
107CREATE TABLE IF NOT EXISTS `jspd`.`project_has_picture` (
108  `project_id` INT NOT NULL,
109  `picture_id` INT NOT NULL,
110  PRIMARY KEY (`project_id`, `picture_id`),
111  INDEX `fk_project_has_picture_picture1_idx` (`picture_id` ASC) VISIBLE,
112  INDEX `fk_project_has_picture_project1_idx` (`project_id` ASC) VISIBLE)
113ENGINE = InnoDB;
114
115
116-- -----------------------------------------------------
117-- Table `jspd`.`project_has_client`
118-- -----------------------------------------------------
119CREATE TABLE IF NOT EXISTS `jspd`.`project_has_client` (
120  `project_id` INT NOT NULL,
121  `client_id` INT NOT NULL,
122  PRIMARY KEY (`project_id`, `client_id`),
123  INDEX `fk_project_has_client_client1_idx` (`client_id` ASC) VISIBLE,
124  INDEX `fk_project_has_client_project1_idx` (`project_id` ASC) VISIBLE)
125ENGINE = InnoDB;
126
127
128SET SQL_MODE=@OLD_SQL_MODE;
129SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
130SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;