CREATE TABLE   IF NOT EXISTS noticias (
  noticia_id mediumint(8) unsigned NOT NULL auto_increment,
  noticia_fechapublic date default NULL,
  noticia_fechafin date default NULL,
  noticia_titulo varchar(250) default NULL,
  user_id mediumint(8) unsigned default NULL,
  noticia_url varchar(250) default NULL,
  noticia_resumen text,
  noticia_contenido text,
  noticia_tema varchar(5) default NULL,
  PRIMARY KEY  (noticia_id),
  KEY NewIndex (noticia_tema)
) ENGINE=MyISAM 
[-]
CREATE TABLE   IF NOT EXISTS noticia_imagenes (
  imagen_id mediumint(8) unsigned NOT NULL auto_increment,
  noticia_id mediumint(8) unsigned default NULL,
  imagen_url varchar(250) default NULL,
  imagen_tipo varchar(10) default NULL COMMENT "tipos:home-principal-general",
  imagen_peso mediumint(8) default NULL,
  PRIMARY KEY  (imagen_id),
  KEY noticia_id (noticia_id)
) ENGINE=MyISAM
[-]
CREATE TABLE   IF NOT EXISTS noticia_relaciones (
  relacion_id mediumint(8) unsigned NOT NULL auto_increment,
  noticia_id mediumint(8) unsigned default NULL,
  noticia_idrelacion mediumint(8) unsigned default NULL,
  PRIMARY KEY  (relacion_id),
  KEY noticia_id (noticia_id),
  KEY noticia_idrelacion (noticia_idrelacion)
) ENGINE=MyISAM
[-]
CREATE TABLE   IF NOT EXISTS parametrica (
  parametrica_grupo varchar(10) NOT NULL default "",
  parametrica_id varchar(10) NOT NULL default "",
  parametrica_descripcion varchar(250) default NULL,
  parametrica_valor mediumint(8) default NULL,
  PRIMARY KEY  (parametrica_grupo,parametrica_id)
) ENGINE=MyISAM
[-]
INSERT INTO parametrica VALUES ("nt_maximg","home",NULL,10)
[-]
INSERT INTO parametrica VALUES ("nt_maxnot","total",NULL,5000)
[-]
INSERT INTO parametrica VALUES ("nt_maximg","numero",NULL,10)
[-]
INSERT INTO parametrica VALUES ("nt_maximg","peso",NULL,5120)
[-]
INSERT INTO parametrica VALUES ("nt_maxnot","home",NULL,10)
[-]
INSERT INTO parametrica VALUES ("nt_maxnot","menu",NULL,15)
[-]
INSERT INTO parametrica VALUES ("nt_maxnot","activas",NULL,10)
[-]
INSERT INTO parametrica VALUES ("nt_temas","3","tema de prueba",NULL)
[-]
INSERT INTO parametrica VALUES ("nt_dimimg","alto",NULL,1024)
[-]
INSERT INTO parametrica VALUES ("nt_dimimg","ancho",NULL,1024)
[-]
INSERT INTO parametrica VALUES ("nt_dimimg","peso",NULL,1024)
[-]
INSERT INTO parametrica VALUES ("nt_temas","2","tipo de noticia 2",NULL)
[-]
INSERT INTO parametrica VALUES ("nt_dimimg","formato","jpg,gif,png,jpeg",NULL)
[-]
INSERT INTO parametrica VALUES ("nt_temas","4","hhhhhh",NULL)
[-]
INSERT INTO parametrica VALUES ("nt_temas","6","sdasdasd",NULL)