Просмотр архива UpCMS v 0.0.2[FIX]

CREATE TABLE IF NOT EXISTS `besedka` (
  `id` int(250) NOT NULL
AUTO_INCREMENT,
  `id_user` int(250) NOT NULL,
  `text` varchar(9999) NOT
NULL,
  `time` int(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id`
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `dl_file`
(
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_raz` int(250) NOT NULL,
 
`id_user` int(250) NOT NULL,
  `down` varchar(9999) NOT NULL,
  `name`
varchar(400) NOT NULL,
  `text` varchar(9000) NOT NULL,
  `time` int(250)
NOT NULL,
  `downs` int(250) NOT NULL DEFAULT '0',
  `format` varchar(250)
NOT NULL DEFAULT '.png',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `dl_komm`
(
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_user` int(250) NOT NULL,
 
`id_dl` int(250) NOT NULL,
  `text` varchar(9999) NOT NULL,
  `time`
int(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `dl_raz`
(
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `name` varchar(950) NOT NULL,

 `info` varchar(950) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id`
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_msg` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_user` int(250)
NOT NULL,
  `time` int(250) NOT NULL,
  `id_theme` int(250) NOT NULL,
 
`text` varchar(10000) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id`
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_podrazdel` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_razdel`
int(250) NOT NULL,
  `name` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`),
 
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `forum_razdel` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `name`
varchar(1000) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`forum_theme` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_podraz`
int(250) NOT NULL,
  `up` int(250) NOT NULL,
  `name` varchar(1000) NOT
NULL,
  `id_user` int(250) NOT NULL,
  `text` varchar(9000) NOT NULL,
 
`time` int(250) NOT NULL,
  `status` enum('open','closed') NOT NULL DEFAULT
'open',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `journal`
(
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `text` varchar(9500) NOT
NULL,
  `time` int(250) NOT NULL,
  `read` enum('0','1') NOT NULL DEFAULT
'0',
  `id_user` int(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`komm_news` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_news` int(250)
NOT NULL,
  `id_author` int(250) NOT NULL,
  `text` varchar(9999) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `log_auth` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_user`
int(250) NOT NULL,
  `time` int(250) NOT NULL,
  `ip` varchar(250) NOT
NULL,
  `type` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
 
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `msg_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user`
int(250) NOT NULL,
  `id_room` int(250) NOT NULL,
  `text` varchar(2500)
NOT NULL,
  `time` int(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY
`id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS `news` (
 
`id` int(250) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
 
`text` varchar(9999) NOT NULL,
  `author` int(250) NOT NULL,
  `time_new`
int(250) NOT NULL,
  `time` int(250) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`obmen_file` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_raz` int(250)
NOT NULL,
  `id_user` int(250) NOT NULL,
  `down` varchar(9999) NOT NULL,
 
`downs` int(250) NOT NULL DEFAULT '0',
  `name` varchar(1000) NOT NULL,
 
`text` varchar(9999) NOT NULL,
  `time` int(250) NOT NULL,
  `format`
varchar(250) NOT NULL DEFAULT '.png',
  PRIMARY KEY (`id`),
  UNIQUE KEY
`id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`obmen_komm` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `id_user`
int(250) NOT NULL,
  `id_obmen` int(250) NOT NULL,
  `text` varchar(9999)
NOT NULL,
  `time` int(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY
`id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-----------------------------------
CREATE TABLE IF NOT EXISTS
`obmen_raz` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `name`
varchar(1000) NOT NULL,
  `info` varchar(9999) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `room_chat` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `name`
varchar(250) NOT NULL,
  `info` varchar(400) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
-----------------------------------
CREATE TABLE IF NOT
EXISTS `settings` (
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `reg_on`
enum('0','1') NOT NULL DEFAULT '1',
  `aut_ban_time` int(250) NOT NULL
DEFAULT '60',
  `index_forum` int(2) NOT NULL DEFAULT '5',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
-----------------------------------
INSERT INTO `settings` (`id`,
`reg_on`, `aut_ban_time`, `index_forum`) VALUES
(1, '1', 600,
7);
-----------------------------------
CREATE TABLE IF NOT EXISTS `user`
(
  `id` int(250) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL,

 `pass` varchar(80) NOT NULL,
  `pol` enum('1','2') NOT NULL DEFAULT '1',
 
`data_reg` int(250) NOT NULL DEFAULT '1',
  `admin_level`
enum('0','1','2','3') NOT NULL DEFAULT '0',
  `up_time` int(250) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;