|
1 | | -CREATE TABLE IF NOT EXISTS `courses` ( |
2 | | - `id` CHAR(36) NOT NULL, |
3 | | - `name` VARCHAR(255) NOT NULL, |
4 | | - `duration` VARCHAR(255) NOT NULL, |
5 | | - PRIMARY KEY (`id`) |
6 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 1 | +CREATE TABLE IF NOT EXISTS courses ( |
| 2 | + id CHAR(36) NOT NULL, |
| 3 | + name VARCHAR(255) NOT NULL, |
| 4 | + duration VARCHAR(255) NOT NULL, |
| 5 | + PRIMARY KEY (id) |
| 6 | +) |
| 7 | + ENGINE = InnoDB |
| 8 | + DEFAULT CHARSET = utf8mb4 |
| 9 | + COLLATE = utf8mb4_unicode_ci; |
7 | 10 |
|
8 | | -CREATE TABLE IF NOT EXISTS `courses_counter` ( |
9 | | - `id` CHAR(36) NOT NULL, |
10 | | - `total` INT NOT NULL, |
11 | | - `existing_courses` JSON NOT NULL, |
12 | | - PRIMARY KEY (`id`) |
13 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 11 | +CREATE TABLE IF NOT EXISTS courses_counter ( |
| 12 | + id CHAR(36) NOT NULL, |
| 13 | + total INT NOT NULL, |
| 14 | + existing_courses JSON NOT NULL, |
| 15 | + PRIMARY KEY (id) |
| 16 | +) |
| 17 | + ENGINE = InnoDB |
| 18 | + DEFAULT CHARSET = utf8mb4 |
| 19 | + COLLATE = utf8mb4_unicode_ci; |
14 | 20 |
|
15 | | -CREATE TABLE IF NOT EXISTS `steps` ( |
16 | | - `id` CHAR(36) NOT NULL, |
17 | | - `title` VARCHAR(155) NOT NULL, |
18 | | - PRIMARY KEY (`id`) |
19 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 21 | +CREATE TABLE IF NOT EXISTS steps ( |
| 22 | + id CHAR(36) NOT NULL, |
| 23 | + title VARCHAR(155) NOT NULL, |
| 24 | + PRIMARY KEY (id) |
| 25 | +) |
| 26 | + ENGINE = InnoDB |
| 27 | + DEFAULT CHARSET = utf8mb4 |
| 28 | + COLLATE = utf8mb4_unicode_ci; |
20 | 29 |
|
21 | | -CREATE TABLE IF NOT EXISTS `steps_challenges` ( |
22 | | - `id` CHAR(36) NOT NULL, |
23 | | - `statement` TEXT NOT NULL, |
24 | | - PRIMARY KEY (`id`), |
25 | | - CONSTRAINT `fk_steps_challenges__step_id` FOREIGN KEY (`id`) REFERENCES `steps` (`id`) |
26 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 30 | +CREATE TABLE IF NOT EXISTS steps_challenges ( |
| 31 | + id CHAR(36) NOT NULL, |
| 32 | + statement TEXT NOT NULL, |
| 33 | + PRIMARY KEY (id), |
| 34 | + CONSTRAINT fk_steps_challenges__step_id FOREIGN KEY (id) REFERENCES steps(id) |
| 35 | +) |
| 36 | + ENGINE = InnoDB |
| 37 | + DEFAULT CHARSET = utf8mb4 |
| 38 | + COLLATE = utf8mb4_unicode_ci; |
27 | 39 |
|
28 | | -CREATE TABLE IF NOT EXISTS `steps_videos` ( |
29 | | - `id` CHAR(36) NOT NULL, |
30 | | - `url` VARCHAR(255) NOT NULL, |
31 | | - `text` TEXT NOT NULL, |
32 | | - PRIMARY KEY (`id`), |
33 | | - CONSTRAINT `fk_steps_video__step_id` FOREIGN KEY (`id`) REFERENCES `steps` (`id`) |
34 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 40 | +CREATE TABLE IF NOT EXISTS steps_videos ( |
| 41 | + id CHAR(36) NOT NULL, |
| 42 | + url VARCHAR(255) NOT NULL, |
| 43 | + text TEXT NOT NULL, |
| 44 | + PRIMARY KEY (id), |
| 45 | + CONSTRAINT fk_steps_video__step_id FOREIGN KEY (id) REFERENCES steps(id) |
| 46 | +) |
| 47 | + ENGINE = InnoDB |
| 48 | + DEFAULT CHARSET = utf8mb4 |
| 49 | + COLLATE = utf8mb4_unicode_ci; |
35 | 50 |
|
36 | | -CREATE TABLE IF NOT EXISTS `domain_events` ( |
37 | | - `id` CHAR(36) NOT NULL, |
38 | | - `aggregate_id` CHAR(36) NOT NULL, |
39 | | - `name` VARCHAR(255) NOT NULL, |
40 | | - `body` JSON NOT NULL, |
41 | | - `occurred_on` timestamp NOT NULL, |
42 | | - PRIMARY KEY (`id`) |
43 | | -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 51 | +CREATE TABLE IF NOT EXISTS domain_events ( |
| 52 | + id CHAR(36) NOT NULL, |
| 53 | + aggregate_id CHAR(36) NOT NULL, |
| 54 | + name VARCHAR(255) NOT NULL, |
| 55 | + body JSON NOT NULL, |
| 56 | + occurred_on TIMESTAMP NOT NULL, |
| 57 | + PRIMARY KEY (id) |
| 58 | +) |
| 59 | + ENGINE = InnoDB |
| 60 | + DEFAULT CHARSET = utf8mb4 |
| 61 | + COLLATE = utf8mb4_unicode_ci; |
0 commit comments