-
Notifications
You must be signed in to change notification settings - Fork 0
/
bancodedados.sql
27 lines (22 loc) · 926 Bytes
/
bancodedados.sql
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
DROP TABLE IF EXISTS cadastro;
DROP TABLE IF EXISTS topicos;
DROP TABLE IF EXISTS mensagens;
CREATE TABLE cadastro (
id INT PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE,
nomecompletocad VARCHAR(200) NOT NULL,
emailcad VARCHAR(200) NOT NULL,
nascimentocad DATE NOT NULL,
senhacad VARCHAR(200) NOT NULL);
CREATE TABLE topicos (
id INT PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE,
topico VARCHAR(200) NOT NULL,
op INT NOT NULL);
CREATE TABLE mensagens (
id INT PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE,
datahora DATETIME NOT NULL,
idUser INT NOT NULL,
mensagem TEXT NOT NULL,
idTopico INT NOT NULL);
ALTER TABLE topicos ADD CONSTRAINT topicos_op_cadastro_id FOREIGN KEY (op) REFERENCES cadastro(id);
ALTER TABLE mensagens ADD CONSTRAINT mensagens_idUser_cadastro_id FOREIGN KEY (idUser) REFERENCES cadastro(id);
ALTER TABLE mensagens ADD CONSTRAINT mensagens_idTopico_topicos_id FOREIGN KEY (idTopico) REFERENCES topicos(id);