1 |
|
2 |
|
3 | CREATE TABLE `pages` (
|
4 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
5 | `author_id` int(11),
|
6 | `lang` varchar(15),
|
7 | `status` varchar(15),
|
8 | `title` varchar(255),
|
9 | `subtitle` varchar(255),
|
10 | `slug` varchar(255),
|
11 | `meta_title` varchar(255),
|
12 | `meta_description` TEXT,
|
13 | `excerpt` TEXT,
|
14 | `body` TEXT,
|
15 | `category` varchar(255),
|
16 | `tags` varchar(255),
|
17 | `image_id` int(11),
|
18 | `menu_id` int(11),
|
19 | `menu_order` int(11),
|
20 | `published_at` datetime,
|
21 | `updated_at` datetime,
|
22 | `created_at` datetime NOT NULL,
|
23 | PRIMARY KEY (`id`)
|
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
25 |
|
26 |
|
27 |
|
28 | CREATE TABLE `posts` (
|
29 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
30 | `author_id` int(11),
|
31 | `lang` varchar(15),
|
32 | `status` varchar(15),
|
33 | `title` varchar(255),
|
34 | `slug` varchar(255),
|
35 | `meta_title` varchar(255),
|
36 | `meta_description` TEXT,
|
37 | `excerpt` TEXT,
|
38 | `body` TEXT,
|
39 | `category` varchar(255),
|
40 | `tags` varchar(255),
|
41 | `image_id` int(11),
|
42 | `published_at` datetime,
|
43 | `updated_at` datetime,
|
44 | `created_at` datetime NOT NULL,
|
45 | PRIMARY KEY (`id`)
|
46 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
47 |
|
48 |
|
49 |
|
50 | CREATE TABLE `medias` (
|
51 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
52 | `uuid` varchar(99),
|
53 | `user_id` int(11),
|
54 | `name` varchar(255) NOT NULL,
|
55 | `description` text,
|
56 | `filename` varchar(255),
|
57 | `type` varchar(99),
|
58 | `size` int(11),
|
59 | `container` varchar(255),
|
60 | `fullpath` varchar(255),
|
61 | `is_deleted` tinyint(1),
|
62 | `deleted_at` datetime,
|
63 | `deleted_by` int(11),
|
64 | `created_at` datetime NOT NULL,
|
65 | PRIMARY KEY (`id`)
|
66 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|