da17ijF5

1CREATE TABLE IF NOT EXISTS `fotos` 
2(
3`id` int(11) NOT NULL,
4`foto` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
5`comentario` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
6) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
7ALTER TABLE `fotos`
8ADD PRIMARY KEY (`id`);
9ALTER TABLE `fotos`
10MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
11
12
13CREATE TABLE IF NOT EXISTS `noticias` (
14`Id` int(6) unsigned NOT NULL,
15`data` date DEFAULT NULL,
16`titulo` text,
17`noticia` text NOT NULL,
18`user` varchar(20) NOT NULL,
19`server` int(11) NOT NULL DEFAULT '1',
20`tipo` tinyint(4) NOT NULL DEFAULT '1',
21`dias_promo` int(11) NOT NULL DEFAULT '0'
22) ENGINE=MyISAM AUTO_INCREMENT=1081 DEFAULT CHARSET=latin1;
23ALTER TABLE `noticias`
24ADD PRIMARY KEY (`Id`);
25ALTER TABLE `noticias`
26MODIFY `Id` int(6) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1081;