YDnGsVfP

1DROP DATABASE IF EXISTS mundipad;
2CREATE DATABASE mundipad;
3
4CREATE TABLE Usuarios (
5	id	INT NOT NULL,
6	nome INT NOT NULL,
7	PRIMARY KEY (ID)
8) Engine = InnoDB;
9
10
11CREATE TABLE Pedidos (
12	id 				INT	NOT NULL AUTO INCREMENT,
13	autor 			VARCHAR(30),
14	prioridade		int	NOT NULL,
15	mensagem 		VARCHAR(30) NOT NULL,
16	dataCriacao	DATE	NOT NULL,
17	autorModif		INT,
18	dataModif		DATE	NOT NULL
19	FOREIGN KEY (autorModif) REFERENCES Usuarios (id),
20	PRIMARY KEY (id)
21	
22) Engine = InnoDB;