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



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



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



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



CREATE TABLE materiallavinia (
  idmateriallavinia INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
  locallavinia_idlocallavinia INTEGER UNSIGNED  NOT NULL  ,
  editoralavinia_ideditoralavinia INTEGER UNSIGNED  NOT NULL  ,
  categorialavinia_idcategorialavinia INTEGER UNSIGNED  NOT NULL  ,
  generolavinia_idgenerolavinia 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(idmateriallavinia)  ,
INDEX materialmiguel_FKIndex1(categorialavinia_idcategorialavinia)  ,
INDEX materialmiguel_FKIndex2(generolavinia_idgenerolavinia)  ,
INDEX materialmiguel_FKIndex3(locallavinia_idlocallavinia)  ,
INDEX materialmiguel_FKIndex4(editoralavinia_ideditoralavinia),
  FOREIGN KEY(categorialavinia_idcategorialavinia)
    REFERENCES categorialavinia(idcategorialavinia)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(generolavinia_idgenerolavinia)
    REFERENCES generolavinia(idgenerolavinia)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(locallavinia_idlocallavinia)
    REFERENCES locallavinia(idlocallavinia)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  FOREIGN KEY(editoralavinia_ideditoralavinia)
    REFERENCES editoralavinia(ideditoralavinia)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION);