Просмотр архива XCMS v1.9

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',
  `user` int(10)
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
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 `change_pass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(10) DEFAULT '0',
  `code` varchar(100) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 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,
  `reply` int(10) DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `chat_room` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 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 ;

CREATE TABLE IF
NOT EXISTS `dialog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto`
int(15) DEFAULT '0',
  `komu` int(15) DEFAULT '0',
  `time` int(15) DEFAULT
'0',
  `last` int(15) DEFAULT '0',
  `new` int(7) DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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 `files_down` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `ip` varchar(50) DEFAULT '0',
  `ua` varchar(300) DEFAULT
'0',
  `file` int(10) DEFAULT '0',
  `time` int(15) DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 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 `friend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`user1` int(8) DEFAULT '0',
  `user2` int(8) DEFAULT '0',
  `status` int(1)
DEFAULT '0',
  `time` int(15) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(100) DEFAULT '0',
  `desc` varchar(500) DEFAULT '0',
  `type`
int(1) DEFAULT '0',
  `user` int(10) DEFAULT '0',
  `avatar` varchar(15)
DEFAULT '0',
  `time` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `groups_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group`
int(10) DEFAULT '0',
  `user` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `groups_wall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group`
int(10) DEFAULT '0',
  `text` varchar(500) DEFAULT '0',
  `user` int(10)
DEFAULT '0',
  `time` int(15) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `hit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(50)
DEFAULT '0',
  `soft` varchar(300) DEFAULT '0',
  `d` int(2) DEFAULT '0',
 
`m` int(2) DEFAULT '0',
  `y` int(4) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `host` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(50)
DEFAULT '0',
  `soft` varchar(300) DEFAULT '0',
  `d` int(2) DEFAULT '0',
 
`m` int(2) DEFAULT '0',
  `y` int(4) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `ignor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(10)
DEFAULT '0',
  `user2` int(10) DEFAULT '0',
  `time` int(15) DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` varchar(500) DEFAULT '0',
  `time` int(15) DEFAULT
'0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
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,
  `file` varchar(300) DEFAULT '0',
  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 `news_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news`
int(10) DEFAULT '0',
  `user` int(10) DEFAULT '0',
  `time` int(15) DEFAULT
'0',
  `text` varchar(300) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to` int(10)
DEFAULT '0',
  `text` varchar(500) DEFAULT '0',
  `status` int(1) DEFAULT
'1',
  `time` int(10) DEFAULT '0',
  `user` int(10) DEFAULT '0',
  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
`obmen_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200)
DEFAULT '0',
  `desc` varchar(300) DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT
EXISTS `online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip`
varchar(50) DEFAULT '0',
  `soft` varchar(300) DEFAULT '0',
  `time`
int(15) DEFAULT '0',
  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,
  `file` varchar(200) DEFAULT '0',
  `reply_to`
int(10) DEFAULT '0',
  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,
 
`desc` varchar(200) DEFAULT '0',
  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,
  `flood` int(3) DEFAULT '0',
 
`record_online` int(15) DEFAULT '0',
  `record_online_time` int(15) DEFAULT
'0',
  `record_host` int(15) DEFAULT '0',
  `record_host_time` int(15)
DEFAULT '0',
  `record_hit` int(15) DEFAULT '0',
  `record_hit_time`
int(15) DEFAULT '0',
  `min_simb` int(10) DEFAULT '0',
  `time_online`
int(5) DEFAULT '0',
  `cost_login` int(10) DEFAULT '0',
  `cost_unban`
int(10) DEFAULT '0',
  `cost_adv_v` int(10) DEFAULT '0',
  `cost_adv_n`
int(10) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO
`setting` (`title`, `head`, `copy`, `rega`, `design`, `flood`,
`record_online`, `record_online_time`, `record_host`, `record_host_time`,
`record_hit`, `record_hit_time`, `min_simb`, `time_online`, `cost_login`,
`cost_unban`, `cost_adv_v`, `cost_adv_n`) VALUES
('X-CMS', 'Сайт', '©
2015 | by Denis', '1', 'styles/1/style.css', 3, 3213, 1423481508, 12930,
1423498764, 15013, 1423498794, 3, 0, 400, 10000, 100000, 50000);

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` int(15)
NOT NULL,
  `avtor` int(5) DEFAULT NULL,
  `time_last` int(15) DEFAULT
'0',
  `last_id` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=cp1251 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` int(1) DEFAULT '0',
  `names`
varchar(55) DEFAULT '0',
  `inf` varchar(255) DEFAULT '0',
  `icq`
varchar(25) DEFAULT '0',
  `balans` varchar(100) DEFAULT '0.0',
  `city`
varchar(15) DEFAULT '0',
  `key` varchar(50) DEFAULT NULL,
  `ban` int(1)
DEFAULT '0',
  `bday` int(2) DEFAULT '0',
  `bmon` int(2) DEFAULT '0',
 
`byea` int(4) DEFAULT '0',
  `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',
  `status` varchar(100) DEFAULT
'0',
  `country` int(10) DEFAULT '0',
  `where1` varchar(300) DEFAULT '0',

 `where2` varchar(300) 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`, `status`, `country`,
`where1`, `where2`) VALUES
(1, 'admin', '0a2e445583b57657758b8117f804cf75',
1423498794, 'admin@x-cms.ga', 6, '0', '0', '0', '10', '0', NULL, 0, 0, 0,
0, 0, 0, 1, 'default.png', 'styles/1/style.css', 0, 0, 0, '0', 0, '0',
'0');