CREATE TABLE generovictor (
  idgenerovictor INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NULL    ,
PRIMARY KEY(idgenerovictor));



CREATE TABLE localvictor (
  idlocalvictor INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NOT NULL  ,
  peso REAL  NOT NULL    ,
PRIMARY KEY(idlocalvictor));



CREATE TABLE categoriavictor (
  idcategoriavictor INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NULL    ,
PRIMARY KEY(idcategoriavictor));



CREATE TABLE editoravictor (
  ideditoravictor INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  nome VARCHAR(50)  NOT NULL    ,
PRIMARY KEY(ideditoravictor));



CREATE TABLE materialvictor (
  idmaterialvictor INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  categoriavictor_idcategoriavictor INTEGER UNSIGNED  NOT NULL  ,
  generovictor_idgenerovictor INTEGER UNSIGNED  NOT NULL  ,
  editoravictor_ideditoravictor INTEGER UNSIGNED  NOT NULL  ,
  localvictor_idlocalvictor INTEGER UNSIGNED  NOT NULL  ,
  titulo VARCHAR(255)  NOT NULL  ,
  paginas INTEGER UNSIGNED  NOT NULL  ,
  ano YEAR  NOT NULL  ,
  sinopse TEXT  NOT NULL  ,
  pesopagina REAL  NOT NULL  ,
  capa TEXT  NOT NULL  ,
  sumario TEXT  NOT NULL    ,
PRIMARY KEY(idmaterialvictor)  ,
INDEX materialmiguel_FKIndex1(categoriavictor_idcategoriavictor)  ,
INDEX materialmiguel_FKIndex2(generovictor_idgenerovictor)  ,
INDEX materialmiguel_FKIndex3(localvictor_idlocalvictor)  ,
INDEX materialmiguel_FKIndex4(editoravictor_ideditoravictor),
  FOREIGN KEY(categoriavictor_idcategoriavictor)
    REFERENCES categoriavictor(idcategoriavictor)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(generovictor_idgenerovictor)
    REFERENCES generovictor(idgenerovictor)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(localvictor_idlocalvictor)
    REFERENCES localvictor(idlocalvictor)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(editoravictor_ideditoravictor)
    REFERENCES editoravictor(ideditoravictor)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);