Просмотр архива NetsCMS

CREATE TABLE IF NOT EXISTS `minichat` (
  `id` int(99) NOT NULL
AUTO_INCREMENT,
  `id_user` int(99) NOT NULL,
  `time` int(99) NOT NULL,
 
`text` varchar(5000) NOT NULL,
  `id_profile` int(99) NOT NULL,
 
`notification` varchar(99) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `news`
(
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `id_user` int(99) NOT NULL,
 
`time` int(99) NOT NULL,
  `text` varchar(5000) NOT NULL,
  `title`
varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `news_comments`
(
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `id_user` int(99) NOT NULL,
 
`id_news` int(99) NOT NULL,
  `time` int(99) NOT NULL,
  `text`
varchar(5000) CHARACTER SET utf8mb4 NOT NULL,
  `id_profile` int(99) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(99) NOT
NULL AUTO_INCREMENT,
  `time_reg` int(99) NOT NULL,
  `time_last` int(99)
NOT NULL,
  `login` varchar(30) NOT NULL,
  `password` varchar(32) NOT
NULL,
  `level` enum('0','1','2','3','4') DEFAULT '0',
  `sex`
enum('0','1') DEFAULT '0',
  `money` int(99) DEFAULT '0',
  `token` text
NOT NULL,
  `pages` int(11) DEFAULT '10',
  `name` varchar(50) NOT NULL,
 
`city` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `language`
varchar(2) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `ua` varchar(30) NOT
NULL,
  `rating` int(99) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS
`users_block` (
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `id_user` int(99)
NOT NULL,
  `id_profile` int(99) NOT NULL,
  `time` int(99) NOT NULL,
 
`time_ban` int(99) NOT NULL,
  `text` varchar(5000) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE
TABLE IF NOT EXISTS `users_mail` (
  `id` int(99) NOT NULL AUTO_INCREMENT,

 `id_user` int(99) NOT NULL,
  `id_profile` int(99) NOT NULL,
  `read`
enum('0','1') DEFAULT '0',
  `time` int(99) NOT NULL,
  `text`
varchar(5000) CHARACTER SET utf8mb4 NOT NULL,
  `delete` int(99) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `users_notification` (
  `id` int(99) NOT
NULL AUTO_INCREMENT,
  `id_user` int(99) NOT NULL,
  `id_profile` int(99)
NOT NULL,
  `id_post` int(99) NOT NULL,
  `time` int(99) NOT NULL,
  `type`
varchar(99) NOT NULL,
  `read` enum('0','1') DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;