KOD BAZY DANYCH.SQL
-- Struktura tabeli dla `kategorie` -- CREATE TABLE `kategorie` ( `id_kategorii` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `nazwa_kategorii` text NOT NULL, PRIMARY KEY (`id_kategorii`) ) ENGINE=MyISAM DEFAULT CHARSET=latin2; -- -------------------------------------------------------- -- -- Struktura tabeli dla `newsy` -- CREATE TABLE `newsy` ( `id_newsa` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `id_kategorii` int(10) UNSIGNED NOT NULL DEFAULT '0', `tytul` tinytext NOT NULL, `tresc` longtext NOT NULL, PRIMARY KEY (`id_newsa`), FULLTEXT KEY `tresc` (`tresc`) ) ENGINE=MyISAM DEFAULT CHARSET=latin2;