Просмотр архива DCMS Special 7.0.0

CREATE TABLE IF NOT EXISTS `diary` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT '0',
  `name` varchar(60)
DEFAULT NULL,
  `text` mediumtext,
  `tags` mediumtext,
  `poll`
enum('1','0') DEFAULT '0',
  `poll_text` mediumtext,
  `poll_timee`
enum('infin','day','3days','week','month','3months') DEFAULT 'infin',
 
`poll_time` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
 
`count_visits` int(11) DEFAULT '0',
  `password` mediumtext,
  `id_cat`
int(11) DEFAULT NULL,
  `sk` enum('0','1') DEFAULT '0',
  `a_time` int(11)
DEFAULT NULL,
  `sk_time` int(11) DEFAULT NULL,
  `sk_user` int(11) DEFAULT
NULL,
  `sk_msg` text,
  `adult` enum('0','1') DEFAULT '0',
  `access`
enum('all','only_me','friends','pass','auth') DEFAULT 'all',
  `poll_check`
enum('0','1') DEFAULT '0',
  `visits` text,
  `komm`
enum('all','only_me','friends') DEFAULT 'all',
  `poll_time_start` int(11)
DEFAULT NULL,
  `rating` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`diary_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_diary`
int(11) DEFAULT '0',
  `id_user` int(11) DEFAULT '0',
  `name` varchar(50)
DEFAULT NULL,
  `ras` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS
`diary_poll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_diary` int(11)
DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `var` varchar(512) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE
TABLE IF NOT EXISTS `diary_pollen` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_diary` int(11) DEFAULT NULL,
  `id_user` int(11)
DEFAULT NULL,
  `id_var` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE
TABLE IF NOT EXISTS `diary_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `id_user` int(11) DEFAULT NULL,
  `id_diary` int(11) DEFAULT NULL,
 
`time` int(11) DEFAULT NULL,
  `msg` varchar(1024) DEFAULT NULL,
  `reply`
int(11) DEFAULT NULL,
  `komm_reply` text,
  `sk` enum('0','1') DEFAULT
'0',
  `sk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `diary_rating` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_diary` int(11) DEFAULT '0',
 
`id_user` int(11) DEFAULT '0',
  `rating` int(11) DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;