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

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


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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;

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',
  `hash` text NOT
NULL,
  `user_pages` int(11) DEFAULT '10',
  `status` varchar(500) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;