Sample Database Schema

curso_cakephp_ufms.sql

CREATE DATABASE IF NOT EXISTS `grade_disciplinar` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `grade_disciplinar`;

CREATE TABLE cursos (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nome VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    created DATETIME NOT NULL ,
    updated DATETIME NOT NULL 
);

CREATE TABLE disciplinas ( 
    id INT AUTO_INCREMENT PRIMARY KEY,
    curso_id INT NOT NULL,
    nome VARCHAR(50) NOT NULL , 
    carga_horaria INT(3) NOT NULL , 
    created DATETIME NOT NULL , 
    modified DATETIME NOT NULL,
    FOREIGN KEY user_key (curso_id) REFERENCES cursos(id)
);


INSERT INTO cursos VALUES(1, 'computação', 'teste@curso.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO cursos VALUES(2, 'matematica', 'mat@ufms.br', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO cursos VALUES(3, 'engenharia', 'eng@ufms.br', '0000-00-00 00:00:00', '0000-00-00 00:00:00');