CREATE TABLE   IF NOT EXISTS archivo (
  id int(5) unsigned NOT NULL auto_increment,
  documento int(5) unsigned NOT NULL default "0",
  titulo varchar(150) default NULL,
  fichero varchar(150) NOT NULL default "",
  PRIMARY KEY  (id)
) ENGINE=MyISAM
[-]
CREATE TABLE    IF NOT EXISTS carpeta (
  id int(5) unsigned NOT NULL auto_increment,
  tipo varchar(10) NOT NULL default "carpeta",
  nombre varchar(150) default NULL,
  parent int(5) default NULL,
  permiso varchar(15) NOT NULL default "",
  nivel int(11) NOT NULL default "0",
  PRIMARY KEY  (id)
) ENGINE=MyISAM
[-]
CREATE TABLE   IF NOT EXISTS documentos (
  id int(5) unsigned NOT NULL auto_increment,
  carpeta int(5) unsigned NOT NULL default "0",
  fecha_ing date NOT NULL default "0000-00-00",
  fecha_fin date NOT NULL default "0000-00-00",
  titulo text NOT NULL,
  texto text NOT NULL,
  permiso varchar(15) NOT NULL default "",
  PRIMARY KEY  (id)
) ENGINE=MyISAM
[-]
CREATE TABLE   IF NOT EXISTS parametros (
  id int(5) NOT NULL auto_increment,
  descripcion varchar(40) NOT NULL default "",
  parametro int(11) NOT NULL default "0",
  PRIMARY KEY  (id)
) ENGINE=MyISAM
[-]
INSERT INTO parametros VALUES (1, "Numero maximo de carpetas", 2)
[-]
INSERT INTO parametros VALUES (2, "Numero maximo de subcarpetas", 3)
[-]
INSERT INTO parametros VALUES (3, "Numero maximo de documentos", 4)
[-]
INSERT INTO parametros VALUES (4, "Numero maximo de archivos", 5)