Файл: vkolhoze.com/inc/gallery/sql.sql
Строк: 20
DROP TABLE IF EXISTS `gallery_photo`;
CREATE TABLE `gallery_photo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`status` enum('0','1','2') DEFAULT '0',
`name` varchar(1024) DEFAULT
NULL,
`img` varchar(1024) default null,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `com_photo``;
CREATE TABLE `com_photo` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_photo` int(11)
default null,
`msg` varchar(1024) DEFAULT NULL,
`time` int(11)
default null,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rating_photo`;
CREATE
TABLE `rating_photo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_photo` int(11) default null,
`rating` enum('0','1') DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;