CREATE TABLE IF NOT EXISTS `fotos` 
(
  
`id` int(11) NOT NULL,

`foto` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,

`comentario` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL

) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `fotos`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `fotos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

CREATE TABLE IF NOT EXISTS `noticias` (
`Id` int(6) unsigned NOT NULL,
`data` date DEFAULT NULL,
`titulo` text,
`noticia` text NOT NULL,
`user` varchar(20) NOT NULL,
`server` int(11) NOT NULL DEFAULT '1',
`tipo` tinyint(4) NOT NULL DEFAULT '1',
`dias_promo` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=1081 DEFAULT CHARSET=latin1;

ALTER TABLE `noticias`
ADD PRIMARY KEY (`Id`);

ALTER TABLE `noticias`
MODIFY `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1081;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;