nFwne6wW

1drop database if exists codificando;
2create database if not exists codificando;
3use codificando;
4create table if not exists adm(
5	id integer auto_increment not null primary key,
6    first_name varchar(50) not null,
7    last_name varchar(50) not null,
8    email varchar(50) not null unique,
9    born date not null,
10    `password` varchar(15) not null,
11	description varchar(400) not null,
12    `gender` varchar(25) not null
13);
14create table if not exists article(
15	id integer auto_increment not null primary key,
16    title varchar(200) not null,
17    description text not null,
18    date_create date not null, 
19    id_adm integer not null,
20    constraint article_adm 
21    foreign key (id_adm) 
22    references adm(id) 
23    on delete cascade
24    on update cascade
25);
26create table if not exists section(
27	id integer auto_increment not null primary key,
28    title varchar(50) not null,
29    content mediumtext not null,
30    id_article integer not null,
31    constraint secao_article 
32    foreign key (id_article) 
33    references article(id)
34    on delete cascade
35    on update cascade
36);