Просмотр архива xcms 1.1

CREATE TABLE IF NOT EXISTS `ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `link` varchar(150) NOT NULL,
  `time` int(20) NOT NULL,
  `oute`
varchar(5) NOT NULL DEFAULT '0',
  `pozic` varchar(2) NOT NULL,
  `name`
varchar(100) NOT NULL,
  `srok` int(20) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `avatar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_us`
varchar(5) NOT NULL,
  `login` varchar(25) NOT NULL,
  `link` varchar(90)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF
NOT EXISTS `cat_obmen` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `name`
varchar(400) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS
`chat` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_room` int(5) NOT
NULL,
  `author_id` int(5) DEFAULT NULL,
  `text` text NOT NULL,
  `time`
varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `design` (
 
`id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(90) NOT NULL,
 
`link` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

INSERT INTO `design` (`id`, `name`,
`link`) VALUES
(1, 'Зимний(by Selemet)',
'styles/1/style.css');

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `file` text NOT NULL,
 
`size` text NOT NULL,
  `cat` varchar(80) NOT NULL,
  `podcat` varchar(80)
NOT NULL,
  `time` int(13) NOT NULL,
  `genre` varchar(51) NOT NULL,
 
`year` varchar(80) NOT NULL,
  `artist` varchar(80) NOT NULL,
  `down`
int(11) NOT NULL,
  `view` int(11) NOT NULL,
  `bitrate` text NOT NULL,
 
`duration` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `forum` (
 
`id` int(5) NOT NULL AUTO_INCREMENT,
  `razdel` varchar(5) NOT NULL,
 
`name` varchar(90) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `log` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(90) NOT NULL,
  `time`
varchar(150) NOT NULL,
  `iduser` varchar(150) NOT NULL,
  `login`
varchar(50) NOT NULL,
  `uauser` varchar(150) NOT NULL,
  `folder`
varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `mail` (
 
`id` int(5) NOT NULL AUTO_INCREMENT,
  `kto` int(5) NOT NULL,
  `komu`
int(5) NOT NULL,
  `text` text NOT NULL,
  `time` int(15) NOT NULL,
 
`status` int(5) NOT NULL,
  `pole_a` int(5) DEFAULT NULL,
  `pole_b` int(5)
DEFAULT NULL,
  `pole_c` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

CREATE TABLE IF NOT
EXISTS `obmen` (
  `id` int(111) NOT NULL AUTO_INCREMENT,
  `id_cat`
varchar(70) NOT NULL,
  `avtor` text NOT NULL,
  `time` int(11) NOT NULL,
 
`link` varchar(20) NOT NULL,
  `opis` varchar(400) NOT NULL,
  `name`
varchar(150) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `order` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `kol` int(11) DEFAULT '0',
  `comm` varchar(500)
DEFAULT 'NOT NULLED',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `podcat` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `cat` varchar(80) NOT NULL,
 
`name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `posts` (
 
`id` int(7) NOT NULL AUTO_INCREMENT,
  `id_theme` int(5) NOT NULL,
 
`id_forum` int(3) NOT NULL,
  `author_id` int(5) DEFAULT NULL,
  `text`
text NOT NULL,
  `time` varchar(50) NOT NULL,
  `ip` varchar(15) NOT NULL,

 `ua` varchar(20) DEFAULT NULL,
  `pages` varchar(8) DEFAULT NULL,
 
`status` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `razdel` (
 
`id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(90) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `room` (
  `id` int(5) NOT NULL
AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE IF
NOT EXISTS `setting` (
  `title` varchar(90) NOT NULL,
  `head`
varchar(150) NOT NULL,
  `copy` varchar(150) NOT NULL,
  `rega` varchar(5)
NOT NULL,
  `design` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;

INSERT INTO `setting` (`title`, `head`, `copy`, `rega`,
`design`) VALUES
('XCMS', 'xcms.ofsoo.ru', 'Denis S', '1',
'styles/1/style.css');

CREATE TABLE IF NOT EXISTS `themes` (
  `id` int(5)
NOT NULL AUTO_INCREMENT,
  `id_forum` int(5) NOT NULL,
  `status` int(1)
NOT NULL,
  `name` varchar(40) NOT NULL,
  `author_id` int(5) DEFAULT
NULL,
  `time` datetime NOT NULL,
  `avtor` int(5) DEFAULT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`msg` text,
  `act` enum('0','1') DEFAULT '0',
  `priv` int(5) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `login` varchar(32) NOT NULL,
  `password`
varchar(32) NOT NULL,
  `time` int(11) NOT NULL,
  `mail` varchar(32)
DEFAULT NULL,
  `level` enum('0','1') DEFAULT '0',
  `names` varchar(55)
DEFAULT 'Не указано',
  `inf` varchar(255) DEFAULT 'Не
указано',
  `icq` varchar(25) DEFAULT 'Не указано',
 
`balans` varchar(100) DEFAULT '0.0',
  `city` varchar(15) DEFAULT 'Не
указано',
  `key` varchar(50) DEFAULT NULL,
  `ban` int(1) DEFAULT
'0',
  `bday` int(2) DEFAULT '1',
  `bmon` int(2) DEFAULT '1',
  `byea`
int(4) DEFAULT '2000',
  `posts` int(50) DEFAULT '0',
  `postschat` int(50)
DEFAULT '0',
  `sex` int(5) DEFAULT '1',
  `avatar` varchar(100) DEFAULT
'default.png',
  `design` varchar(50) DEFAULT 'styles/1/style.css',
 
`visit` int(15) DEFAULT '0',
  `auth` int(15) DEFAULT '0',
  `flood`
int(15) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `user` (`id`, `login`,
`password`, `time`, `mail`, `level`, `names`, `inf`, `icq`, `balans`,
`city`, `key`, `ban`, `bday`, `bmon`, `byea`, `posts`, `postschat`, `sex`,
`avatar`, `design`, `visit`, `auth`, `flood`) VALUES
(1, 'admin',
'77bb4da40e4cef706d4f9ec6f777ce41', 1292352782, 'dan020795@bk.ru', '1',
'Денис', 'Напоминание - Сделать выбор
города)))', '9164975', '25523737', 'Саратов', '', 0, 2, 7,
1995, 2565, 13, 1, '0', 'styles/1/style.css', 1420218376, 1420210638,
1420215690);