Просмотр архива Соц сеть krasavo.ru на основе DCMS

DROP TABLE `jokes`;
DROP TABLE `jokes_cat`;
CREATE TABLE `jokes_cat`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`post` int(11) NOT NULL,
`name`
varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1
DEFAULT CHARSET=utf8;
CREATE TABLE `jokes_view` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`view` int(11) NOT NULL,
`id_joke` int(11) NOT
NULL,
`id_cat` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
CREATE
TABLE `jokes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT
NULL,
`id_user` int(11) NOT NULL,
`id_cat` int(11) NOT NULL,
`view`
int(11) NOT NULL default'0',
`name` varchar(32) NOT NULL,
`msg`
varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;