isaac-goncalves / asc_contact_manager Goto Github PK

Script para criação das tabelas:

CREATE DATABASE contact_manager /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;

CREATE TABLE campaings ( id int(11) NOT NULL AUTO_INCREMENT, nome varchar(255) DEFAULT NULL, PRIMARY KEY (id), KEY idx_campains_idcampains (id) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE contacts ( id int(11) NOT NULL AUTO_INCREMENT, nome varchar(100) NOT NULL, sobrenome varchar(100) NOT NULL, email varchar(255) NOT NULL, telefone varchar(15) NOT NULL, endereco varchar(255) DEFAULT NULL, cidade varchar(100) DEFAULT NULL, cep varchar(10) DEFAULT NULL, data_nascimento date DEFAULT NULL, campaing_id int(11) DEFAULT NULL, PRIMARY KEY (id), KEY campain_id_idx (campaing_id), CONSTRAINT campain_id FOREIGN KEY (campaing_id) REFERENCES campaings (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=74869 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;