Problem z mNews Opcje

[mateuszhp]

[SQL] pobierz, plaintext 
CREATE TABLE `mkomentarze` (
  `kom_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` int(30) collate utf8_polish_ci NOT NULL DEFAULT '',
  `ip` varchar(20) collate utf8_polish_ci NOT NULL DEFAULT '',
  `autor` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `u_stat` varchar(1) collate utf8_polish_ci NOT NULL DEFAULT '',
  `tresc` text collate utf8_polish_ci NOT NULL,
  PRIMARY KEY  (`kom_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `mnews` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `data` int(30) collate utf8_polish_ci NOT NULL DEFAULT '',
  `dodal` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `tytul` varchar(200) collate utf8_polish_ci NOT NULL DEFAULT '',
  `img` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `przypis` varchar(255) collate utf8_polish_ci DEFAULT NULL,
  `tresc` text collate utf8_polish_ci NOT NULL,
  `wd` int(1) UNSIGNED NOT NULL DEFAULT '0',
  `kat_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `tresc` (`tresc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci PACK_KEYS=0 AUTO_INCREMENT=1 ;
[SQL] pobierz, plaintext 

W tych dwóch tabelach wyskakuja mi błędy. Jak by był ktoś tak miły i poprawił za mnie te tabele był bym bardzo wdzięczny
P.S. Sorki że zaśmiecam to forum ale jestem goły w bazach danych:D

[minolone]

kolego miales blad w dodawaniu pola data, a tak na marginesia dodajac pole data tworz je jako typ "date"

[SQL] pobierz, plaintext 
CREATE TABLE `mkomentarze` (
  `kom_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` date collate utf8_polish_ci NOT NULL,
  `ip` varchar(20) collate utf8_polish_ci NOT NULL DEFAULT '',
  `autor` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `u_stat` varchar(1) collate utf8_polish_ci NOT NULL DEFAULT '',
  `tresc` text collate utf8_polish_ci NOT NULL,
  PRIMARY KEY  (`kom_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=1 ;
 
 
 
CREATE TABLE `mnews` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `data` date collate utf8_polish_ci NOT NULL,
  `dodal` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `tytul` varchar(200) collate utf8_polish_ci NOT NULL DEFAULT '',
  `img` varchar(100) collate utf8_polish_ci NOT NULL DEFAULT '',
  `przypis` varchar(255) collate utf8_polish_ci DEFAULT NULL,
  `tresc` text collate utf8_polish_ci NOT NULL,
  `wd` int(1) UNSIGNED NOT NULL DEFAULT '0',
  `kat_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `tresc` (`tresc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci PACK_KEYS=0 AUTO_INCREMENT=1 ;
 
[SQL] pobierz, plaintext 

dodajac date do bazy dodawaj ja w formie 0000-00-00, pozdrawiam

Ten post edytował minolone 24.02.2010, 01:07:28