· 8 years ago · Feb 22, 2018, 03:18 PM
1-- Zrzut struktury tabela zspnr1_baza.aktualnosci
2CREATE TABLE IF NOT EXISTS `aktualnosci` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `tytul` varchar(200) NOT NULL,
5 `aktualnosc` mediumtext NOT NULL,
6 `data` date NOT NULL,
7 `datapol` varchar(45) NOT NULL,
8 `widoczny` tinyint(1) NOT NULL DEFAULT '1',
9 `podkategorie_id` int(11) NOT NULL,
10 `autor` int(10) NOT NULL,
11 `przypiety` tinyint(1) NOT NULL DEFAULT '0',
12 PRIMARY KEY (`id`),
13 KEY `fk_aktualnosci_podkategorie1` (`podkategorie_id`)
14) ENGINE=MyISAM AUTO_INCREMENT=1135 DEFAULT CHARSET=utf8;