3azbnjSU

1Executing SQL script in server
2ERROR: Error 1062: Duplicate entry 'mydb/regimes' for key 'name'
3SQL Code:
4        CREATE TABLE IF NOT EXISTS `mydb`.`regimes` (
5          `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
6          `description` VARCHAR(255) NOT NULL,
7          `created_at` TIMESTAMP NULL DEFAULT NULL,
8          `updated_at` TIMESTAMP NULL DEFAULT NULL,
9          `deleted_at` TIMESTAMP NULL DEFAULT NULL,
10          PRIMARY KEY (`id`))
11        ENGINE = InnoDB
12        DEFAULT CHARACTER SET = utf8mb4
13        COLLATE = utf8mb4_unicode_ci
14
15SQL script execution finished: statements: 49 succeeded, 1 failed
16
17Fetching back view definitions in final form.
18Nothing to fetch
19	
20CREATE TABLE IF NOT EXISTS `mydb`.`vacancies` (
21  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
22  `company_id` INT UNSIGNED NOT NULL,
23  `manager_id` INT UNSIGNED NOT NULL,
24  `regime_id` INT UNSIGNED NOT NULL,
25  `vacancy_status_id` INT UNSIGNED NOT NULL,
26  `vacancy_type_id` INT UNSIGNED NOT NULL,
27  `title` VARCHAR(255) NOT NULL,
28  `area` VARCHAR(255) NOT NULL,
29  `description` TEXT NULL DEFAULT NULL,
30  `exam_filename` VARCHAR(255) NULL DEFAULT NULL,
31  `workload` VARCHAR(255) NOT NULL,
32  `remuneration` VARCHAR(255) NOT NULL,
33  `quantity` INT NOT NULL,
34  `city` VARCHAR(255) NOT NULL,
35  `soft_skills` VARCHAR(500) NOT NULL,
36  `level` VARCHAR(255) NOT NULL,
37  `specialty` VARCHAR(255) NOT NULL,
38  `skills` VARCHAR(2000) NULL DEFAULT NULL,
39  `help` TINYINT(1) NOT NULL,
40  `created_at` TIMESTAMP NULL DEFAULT NULL,
41  `updated_at` TIMESTAMP NULL DEFAULT NULL,
42  `deleted_at` TIMESTAMP NULL DEFAULT NULL,
43  PRIMARY KEY (`id`),
44  INDEX `fk_vacancies_companies1_idx` (`company_id` ASC) VISIBLE,
45  INDEX `fk_vacancies_managers1_idx` (`manager_id` ASC) VISIBLE,
46  INDEX `fk_vacancies_vacancy_types1_idx` (`vacancy_type_id` ASC) VISIBLE,
47  INDEX `fk_vacancies_vacancy_statuses1_idx` (`vacancy_status_id` ASC) VISIBLE,
48  INDEX `fk_vacancies_regimes1_idx` (`regime_id` ASC) VISIBLE,
49  CONSTRAINT `fk_vacancies_companies1`
50    FOREIGN KEY (`company_id`)
51    REFERENCES `mydb`.`companies` (`id`)
52    ON DELETE NO ACTION
53    ON UPDATE NO ACTION,
54  CONSTRAINT `fk_vacancies_managers1`
55    FOREIGN KEY (`manager_id`)
56    REFERENCES `mydb`.`managers` (`id`)
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION,
59  CONSTRAINT `fk_vacancies_vacancy_types1`
60    FOREIGN KEY (`vacancy_type_id`)
61    REFERENCES `mydb`.`vacancy_types` (`id`)
62    ON DELETE NO ACTION
63    ON UPDATE NO ACTION,
64  CONSTRAINT `fk_vacancies_vacancy_statuses1`
65    FOREIGN KEY (`vacancy_status_id`)
66    REFERENCES `mydb`.`vacancy_statuses` (`id`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION,
69  CONSTRAINT `fk_vacancies_regimes1`
70    FOREIGN KEY (`regime_id`)
71    REFERENCES `mydb`.`regimes` (`id`)
72    ON DELETE NO ACTION
73    ON UPDATE NO ACTION)
74ENGINE = InnoDB
75	
76CREATE TABLE IF NOT EXISTS `mydb`.`professional_profiles` (
77  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
78  `talent_id` INT UNSIGNED NOT NULL,
79  `regime_id` INT UNSIGNED NOT NULL,
80  `vacancy_type_id` INT UNSIGNED NOT NULL,
81  `specialty` VARCHAR(255) NOT NULL,
82  `level` VARCHAR(255) NOT NULL,
83  `available` TINYINT(1) NOT NULL,
84  `curriculum_filename` VARCHAR(255) NOT NULL,
85  `soft_skills` VARCHAR(500) NOT NULL,
86  `relocation` TINYINT(1) NOT NULL,
87  `current_company` VARCHAR(255) NULL DEFAULT NULL,
88  `current_remuneration` VARCHAR(255) NULL DEFAULT NULL,
89  `intended_remuneration` VARCHAR(255) NULL DEFAULT NULL,
90  `remote` TINYINT(1) NOT NULL,
91  `meeting_start` TIME NOT NULL,
92  `meeting_end` TIME NOT NULL,
93  `created_at` TIMESTAMP NULL DEFAULT NULL,
94  `updated_at` TIMESTAMP NULL DEFAULT NULL,
95  `deleted_at` TIMESTAMP NULL DEFAULT NULL,
96  PRIMARY KEY (`id`),
97  INDEX `fk_professional_profiles_talents1_idx` (`talent_id` ASC) VISIBLE,
98  INDEX `fk_professional_profiles_vacancy_types1_idx` (`vacancy_type_id` ASC) VISIBLE,
99  INDEX `fk_professional_profiles_regimes1_idx` (`regime_id` ASC) VISIBLE,
100  CONSTRAINT `fk_professional_profiles_talents1`
101    FOREIGN KEY (`talent_id`)
102    REFERENCES `mydb`.`talents` (`id`)
103    ON DELETE NO ACTION
104    ON UPDATE NO ACTION,
105  CONSTRAINT `fk_professional_profiles_vacancy_types1`
106    FOREIGN KEY (`vacancy_type_id`)
107    REFERENCES `mydb`.`vacancy_types` (`id`)
108    ON DELETE NO ACTION
109    ON UPDATE NO ACTION,
110  CONSTRAINT `fk_professional_profiles_regimes1`
111    FOREIGN KEY (`regime_id`)
112    REFERENCES `mydb`.`regimes` (`id`)
113    ON DELETE NO ACTION
114    ON UPDATE NO ACTION)
115ENGINE = InnoDB