1700 fıkra db

YÜZBAŞI Yaş : 23 Kayıt : 24 09 2007 Mesajlar : 15

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