Просмотр архива Клон @Mail.Ru (сборка на InstantCMS by Softober-InstantSocial)

DROP TABLE IF EXISTS `cms_phlog_item`;

CREATE TABLE IF NOT EXISTS
`cms_phlog_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id`
int(11) NOT NULL,
  `pubdate` datetime NOT NULL,
  `editdate` datetime
NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
 
`seolink` varchar(255) NOT NULL,
  `metakeys` varchar(255) NOT NULL,
 
`hits` int(11) NOT NULL,
  `comm` int(11) NOT NULL,
  `published` int(11)
NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY
`seolink` (`seolink`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
;


CREATE TABLE IF NOT EXISTS `cms_phlog_photos` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `phlog_id` int(11) NOT NULL,
  `image`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251;

CREATE TABLE IF NOT EXISTS `cms_phlog_rating` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `ph_id` int(11) NOT NULL,
  `user_id`
int(11) NOT NULL,
  `vote` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251;