File size: 1.24Kb
Скрипт -> Полезные куски кодов
Автор
-> islamfon
Цена -> 77 wmr
Установка проста
Заливаем таблицы
CREATE TABLE IF NOT EXISTS `codes_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `codes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_cat` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`name` varchar(72) NOT NULL,
`kod` varchar(10000) NOT NULL,
`opis` varchar(10000) NOT NULL,
`time` int(11) NOT NULL,
`rating` int(11) NOT NULL DEFAULT '0',
`views` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `codes_komm` (
`id` int(11) NOT NULL auto_increment,
`id_codes` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `codes_views` (
`id_codes` int(11) NOT NULL,
`id_user` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `codes_like` (
`id_codes` int(11) NOT NULL,
`id_user` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;