Просмотр архива Новый колхоз

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;