Просмотр архива NomiCMS 1.1 Beta

CREATE TABLE IF NOT EXISTS `forum_message` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `section` int(11) NOT NULL,

 `topic` int(11) NOT NULL,
  `kto` int(11) NOT NULL,
  `message`
varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(255) NOT NULL,
  `pos` int(32) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `forum_section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(255) NOT NULL,
  `razdel` int(11) NOT NULL,
  `pos` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
Структура таблицы `forum_topic`
--

CREATE TABLE IF NOT
EXISTS `forum_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
int(11) NOT NULL,
  `section` int(11) NOT NULL,
  `kto` int(11) NOT NULL,
 
`name` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
 
`last_message_time` int(11) NOT NULL,
  `is_top_topic` int(11) NOT NULL
DEFAULT '0',
  `is_close_topic` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `mini_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `message` text NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;



-- --------------------------------------------------------


CREATE
TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`kto` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `name` varchar(255)
NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`language` varchar(255) NOT NULL,
  `theme` varchar(255) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;

INSERT INTO `settings` (`id`, `language`, `theme`) VALUES
(1, 'ru',
'default');



--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login`
varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `level` int(11)
NOT NULL DEFAULT '1',
  `name` text NOT NULL,
  `first_name` text NOT
NULL,
  `sex` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `icq`
int(11) NOT NULL,
  `date_registration` int(11) NOT NULL,
 
`date_last_entry` int(11) NOT NULL,
  `ava` varchar(255) NOT NULL DEFAULT
'no_ava.png',
  `country` varchar(255) NOT NULL,
  `city` varchar(255) NOT
NULL,
  `about` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


--
--------------------------------------------------------


CREATE TABLE IF
NOT EXISTS `user_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`kto` int(11) NOT NULL,
  `language` varchar(255) NOT NULL,
  `theme`
varchar(255) NOT NULL,
  `num` int(11) NOT NULL DEFAULT '10',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;