-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathconnectvida.sql
More file actions
158 lines (131 loc) · 11.5 KB
/
connectvida.sql
File metadata and controls
158 lines (131 loc) · 11.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Tempo de geração: 09-Ago-2020 às 06:58
-- Versão do servidor: 10.4.13-MariaDB
-- versão do PHP: 7.4.8
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Banco de dados: `connectvida`
-- Executar esse script caso o banco não esteja criado
-- CREATE DATABASE connectvida;
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `files`
--
CREATE TABLE `files` (
`id` int(11) NOT NULL,
`alias` text NOT NULL,
`src` text NOT NULL,
`type` text NOT NULL,
`post_id` int(11) NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Estrutura da tabela `posts`
--
CREATE TABLE `posts` (
`id` int(11) NOT NULL,
`title` text NOT NULL,
`subtitle` text NOT NULL,
`subject` text NOT NULL,
`image` text NOT NULL,
`body` text NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Extraindo dados da tabela `posts`
--
INSERT INTO `posts` (`id`, `title`, `subtitle`, `subject`, `image`, `body`, `updated_at`, `created_at`) VALUES
(1, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'feminismo', 'https://images.unsplash.com/photo-1547937084-4d587301a545?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=750&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:37:44', '2020-08-09 04:37:44'),
(2, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'feminismo', 'https://images.unsplash.com/photo-1547937084-4d587301a545?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=750&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:37:48', '2020-08-09 04:37:48'),
(3, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'feminismo', 'https://images.unsplash.com/photo-1547937084-4d587301a545?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=750&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:37:49', '2020-08-09 04:37:49'),
(4, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'tecnologia', 'https://i1.wp.com/www.mtitecnologia.com.br/wp-content/uploads/2017/03/influencia-redes-sociais.jpg?fit=500%2C335&ssl=1&w=640', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:38:19', '2020-08-09 04:38:19'),
(5, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'tecnologia', 'https://i1.wp.com/www.mtitecnologia.com.br/wp-content/uploads/2017/03/influencia-redes-sociais.jpg?fit=500%2C335&ssl=1&w=640', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:38:20', '2020-08-09 04:38:20'),
(6, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'tecnologia', 'https://i1.wp.com/www.mtitecnologia.com.br/wp-content/uploads/2017/03/influencia-redes-sociais.jpg?fit=500%2C335&ssl=1&w=640', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:38:21', '2020-08-09 04:38:21'),
(7, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'saúde', 'https://images.unsplash.com/photo-1542736667-069246bdbc6d?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=751&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:39:01', '2020-08-09 04:39:01'),
(8, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'saúde', 'https://images.unsplash.com/photo-1542736667-069246bdbc6d?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=751&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:39:02', '2020-08-09 04:39:02'),
(9, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'saúde', 'https://images.unsplash.com/photo-1542736667-069246bdbc6d?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=751&q=80', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:39:03', '2020-08-09 04:39:03'),
(10, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'artes', 'https://www.oreporter.net/wp-content/uploads/2018/12/fundo-cultura-gravatai.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:51:19', '2020-08-09 04:51:19'),
(11, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'artes', 'https://www.oreporter.net/wp-content/uploads/2018/12/fundo-cultura-gravatai.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:51:20', '2020-08-09 04:51:20'),
(12, 'Titulo do post', 'This is a wider card with supporting text below as a natural lead-in to additional content. This contentis a little bit longer.', 'artes', 'https://www.oreporter.net/wp-content/uploads/2018/12/fundo-cultura-gravatai.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam eget ligula eu lectus lobortis condimentum. Aliquam nonummy auctor massa. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla at risus. Quisque purus magna, auctor et, sagittis ac, posuere eu, lectus. Nam mattis, felis ut adipiscing.', '2020-08-09 04:51:20', '2020-08-09 04:51:20');
-- --------------------------------------------------------
--
-- Estrutura da tabela `posts_comments`
--
CREATE TABLE `posts_comments` (
`id` int(11) NOT NULL,
`name` text NOT NULL,
`email` text NOT NULL,
`body` text NOT NULL,
`post_id` int(11) NOT NULL,
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Índices para tabelas despejadas
--
--
-- Índices para tabela `files`
--
ALTER TABLE `files`
ADD PRIMARY KEY (`id`),
ADD KEY `post_id` (`post_id`);
--
-- Índices para tabela `posts`
--
ALTER TABLE `posts`
ADD PRIMARY KEY (`id`);
--
-- Índices para tabela `posts_comments`
--
ALTER TABLE `posts_comments`
ADD PRIMARY KEY (`id`),
ADD KEY `post_id` (`post_id`);
--
-- AUTO_INCREMENT de tabelas despejadas
--
--
-- AUTO_INCREMENT de tabela `files`
--
ALTER TABLE `files`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de tabela `posts`
--
ALTER TABLE `posts`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT de tabela `posts_comments`
--
ALTER TABLE `posts_comments`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Restrições para despejos de tabelas
--
--
-- Limitadores para a tabela `files`
--
ALTER TABLE `files`
ADD CONSTRAINT `files_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;
--
-- Limitadores para a tabela `posts_comments`
--
ALTER TABLE `posts_comments`
ADD CONSTRAINT `posts_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;