View file guest v2/guest/tables.sql

DROP TABLE `guest_tema_dnja`;

CREATE TABLE IF NOT EXISTS `guest_tema_dnja` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `tema` varchar(1024) default NULL,
 `time` int(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `guest_tema_dnja_otzuv` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `id_user` int(11) NOT NULL DEFAULT '0',
 `id_tema` int(11) NOT NULL DEFAULT '0',
 `plus` int(11) NOT NULL DEFAULT '0',
 `minus` int(11) NOT NULL DEFAULT '0',
 `time` int(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;