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 DEFAULT
[-]
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)
[-]