21 kategori de 1700 fıkra :
15 YTL
CREATE TABLE `
cat` (
`id` int(10) unsigned NOT NULL auto_increment,
`ad` varchar(255) collate utf8_turkish_ci NOT NULL default '',
`sira` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sira` (`sira`)
);
CREATE TABLE `
icerik` (
`id` int(10) unsigned NOT NULL auto_increment,
`cat_id` int(10) unsigned NOT NULL default '0',
`baslik` varchar(255) collate utf8_turkish_ci NOT NULL default '',
`giris` text collate utf8_turkish_ci NOT NULL,
`devam` text collate utf8_turkish_ci NOT NULL,
`ozel_meta` text collate utf8_turkish_ci NOT NULL,
`ozel_title` text collate utf8_turkish_ci NOT NULL,
`ozel_url` text collate utf8_turkish_ci NOT NULL,
`hit` int(10) unsigned NOT NULL default '0',
`okunmazamani` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `cat_id` (`cat_id`)
);
demo :
FikraCenneti.com fikralar