Просмотр архива [GlobalCMS] Форум

CREATE TABLE `forums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid`
int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `info` varchar(120)
NOT NULL,
  `lvl` varchar(120) NOT NULL,
  PRIMARY KEY
(`id`)
);

CREATE TABLE `forum_posts` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `tema` int(11) NOT NULL,
  `user` int(11) NOT NULL,
 
`var` int(11) NOT NULL,
  `razdel` int(11) NOT NULL,
  `text` text NOT
NULL,
  `coledit` int(11) NOT NULL,
  `edit` int(11) NOT NULL,
 
`timeedit` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
);

CREATE TABLE `forum_razdel` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `forum` int(11) NOT NULL,
  `sid` int(11) NOT NULL,
 
`lvl` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `name` varchar(60)
NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `forum_tems` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `razdel`
int(11) NOT NULL,
  `status` int(2) NOT NULL,
  `var` int(2) NOT NULL,
 
`name` varchar(80) NOT NULL,
  `time` int(11) NOT NULL,
  `uptime`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
);