Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- 02/09/14 13:46:00
- -- Model: New Model Version: 1.0
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
- -- -----------------------------------------------------
- -- Schema CCM
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `CCM` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
- USE `CCM` ;
- -- -----------------------------------------------------
- -- Table `CCM`.`Utilizador`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Utilizador` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `Username` VARCHAR(16) NOT NULL,
- `Email` VARCHAR(255) NOT NULL,
- `Password` VARCHAR(32) NOT NULL,
- `DataCriacao` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`));
- -- -----------------------------------------------------
- -- Table `CCM`.`Veiculo`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Veiculo` (
- `Matricula` VARCHAR(45) NOT NULL,
- `Ano` DATETIME NOT NULL,
- `Cilindrada` INT(15) NOT NULL,
- `Modelo` VARCHAR(100) NOT NULL,
- `Cor` VARCHAR(100) NOT NULL,
- `NChassis` VARCHAR(50) NOT NULL,
- `Categoria` VARCHAR(50) NOT NULL,
- `TipoComustivel` VARCHAR(50) NOT NULL,
- `DistanciaEixos` VARCHAR(50) NULL,
- `PesoMaxFrente` INT(20) NULL,
- `PesoMaxRetaguarda` INT(20) NULL,
- `PesoTotal` INT(40) NULL,
- `TipoPneu` VARCHAR(100) NOT NULL,
- `Estado` VARCHAR(100) NULL,
- `Observacoes` VARCHAR(5000) NULL,
- PRIMARY KEY (`Matricula`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`Socio`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Socio` (
- `ID` INT NOT NULL AUTO_INCREMENT,
- `Nome` VARCHAR(100) NOT NULL,
- `Profissao` VARCHAR(100) NOT NULL,
- `Morada` VARCHAR(100) NOT NULL,
- `Localidade` VARCHAR(100) NOT NULL,
- `CodigoPostal` VARCHAR(10) NOT NULL,
- `DataNascimento` DATETIME NOT NULL,
- `Telefone` INT(9) NOT NULL,
- `Telemovel` INT(9) NOT NULL,
- `Email` VARCHAR(255) NOT NULL,
- `Matricula` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`ID`),
- INDEX `Matricula_idx` (`Matricula` ASC),
- CONSTRAINT `Matricula`
- FOREIGN KEY (`Matricula`)
- REFERENCES `CCM`.`Veiculo` (`Matricula`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`Quota`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Quota` (
- `ID` INT NOT NULL AUTO_INCREMENT,
- `IDSocio` INT NOT NULL,
- `Ano` INT(7) NOT NULL,
- PRIMARY KEY (`ID`),
- INDEX `ID_idx` (`IDSocio` ASC),
- CONSTRAINT `ID`
- FOREIGN KEY (`IDSocio`)
- REFERENCES `CCM`.`Socio` (`ID`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`Evento`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Evento` (
- `ID` INT NOT NULL AUTO_INCREMENT,
- `IDSocio` INT NOT NULL,
- `Nome` VARCHAR(50) NOT NULL,
- PRIMARY KEY (`ID`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`FotoEvento`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`FotoEvento` (
- `ID` INT(50) NOT NULL AUTO_INCREMENT,
- `IDEvento` INT NOT NULL,
- `Url` VARCHAR(200) NOT NULL,
- `Descricao` VARCHAR(200) NOT NULL,
- `Data` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `Autor` VARCHAR(200) NOT NULL,
- `Posicao` INT(20) NOT NULL DEFAULT 0,
- PRIMARY KEY (`ID`),
- INDEX `ID_idx` (`IDEvento` ASC),
- CONSTRAINT `ID`
- FOREIGN KEY (`IDEvento`)
- REFERENCES `CCM`.`Evento` (`ID`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`FotosVeiculo`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`FotosVeiculo` (
- `ID` INT NOT NULL AUTO_INCREMENT,
- `Matricula` VARCHAR(45) NOT NULL,
- `FotoFrente` VARCHAR(200) NULL,
- `FotoTras` VARCHAR(200) NULL,
- PRIMARY KEY (`ID`),
- INDEX `Matricula_idx` (`Matricula` ASC),
- CONSTRAINT `Matricula`
- FOREIGN KEY (`Matricula`)
- REFERENCES `CCM`.`Veiculo` (`Matricula`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `CCM`.`Socio_participa_Evento`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `CCM`.`Socio_participa_Evento` (
- `Socio_ID` INT NOT NULL,
- `Evento_ID` INT NOT NULL,
- PRIMARY KEY (`Socio_ID`, `Evento_ID`),
- INDEX `fk_Socio_has_Evento_Evento1_idx` (`Evento_ID` ASC),
- INDEX `fk_Socio_has_Evento_Socio1_idx` (`Socio_ID` ASC),
- CONSTRAINT `fk_Socio_has_Evento_Socio1`
- FOREIGN KEY (`Socio_ID`)
- REFERENCES `CCM`.`Socio` (`ID`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_Socio_has_Evento_Evento1`
- FOREIGN KEY (`Evento_ID`)
- REFERENCES `CCM`.`Evento` (`ID`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement