Файл: system/bd.sql
Строк: 110
/*
------------------------------
##############################
-
Загруз Центр -
- by Kemel
-
##############################
------------------------------
*/
/*
ЛУЗЕРЫ=) */
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT
NULL auto_increment,
`login` varchar(40) NOT NULL,
`pass`
varchar(100) NOT NULL,
`email` varchar(50) NOT NULL,
`right`
tinyint(2) NOT NULL default '1',
`name` varchar(40) NOT NULL,
`sex`
enum ('m','w') NOT NULL default 'm',
`day` tinyint(2) NOT NULL,
`month` tinyint(2) NOT NULL,
`year` smallint(4) NOT NULL,
`status`
tinyint(1) NOT NULL,
`country` tinyint(2) NOT NULL,
`city`
varchar(50) NOT NULL,
`outcity` varchar(50) NOT NULL,
`number`
bigint(12) NOT NULL,
`icq` int(9) NOT NULL,
`do` text(300) NOT
NULL,
`interes` text(300) NOT NULL,
`music` text(300) NOT NULL,
`about` text(300) NOT NULL,
`foto` char(4) NOT NULL,
`podpis`
varchar(100) NOT NULL,
`balls` int(10) NOT NULL default '0',
`ip`
char(30) NOT NULL,
`browser` varchar(100) NOT NULL,
`sort` char(4)
NOT NULL default 'ASC',
`version` enum('web','wap') NOT NULL default
'wap',
`num` tinyint(2) unsigned NOT NULL default '10',
`lasttime`
int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*
Загрузки */
CREATE TABLE IF NOT EXISTS `loads` (
`id`
mediumint(9) NOT NULL auto_increment,
`who` varchar(40) NOT NULL,
`name` varchar(30) NOT NULL,
`fullname` varchar(255) NOT NULL,
`title` varchar(150) NOT NULL,
`avtor` varchar(150) NOT NULL default
'Неизвестный',
`album` varchar(70) NOT NULL,
`first`
char(1) NOT NULL,
`janre` varchar(55) NOT NULL,
`size` int(10) NOT
NULL,
`bit` smallint(5) NOT NULL,
`frequency` smallint(5) NOT NULL,
`mode` char(20) NOT NULL,
`length` char(5) NOT NULL,
`loads` int(10)
NOT NULL default '0',
`lastload` int(11) NOT NULL,
`moder`
enum('no','yes') NOT NULL default 'yes',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
/* Комменты */
CREATE TABLE IF NOT EXISTS `comments` (
`id`
int(11) NOT NULL auto_increment,
`fid` int(11) NOT NULL,
`who`
varchar(40) NOT NULL,
`text` text NOT NULL,
`ip` varchar(30) NOT
NULL,
`browser` tinytext NOT NULL,
`time` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/* Настройки
*/
CREATE TABLE IF NOT EXISTS `settings` (
`option` varchar(60) NOT
NULL,
`value` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ;
INSERT INTO `settings` (`option`,`value`) VALUES
('maxupload','12288'), ('gzip','off'), ('count','1');
/* Реклама
*/
CREATE TABLE IF NOT EXISTS `reklama` (
`title` char(60) NOT NULL,
`site` char(60) NOT NULL,
`time` int(11) NOT NULL
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 ;
/* Почта */
CREATE TABLE IF NOT EXISTS `mail`
(
`id` int(11) NOT NULL auto_increment,
`fid` int(11) NOT NULL,
`oid`
int(11) NOT NULL,
`title` varchar(150) NOT NULL,
`text` text NOT
NULL,
`read` enum('yes','no') NOT NULL default 'no',
`time` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*
Онлайн */
CREATE TABLE IF NOT EXISTS `online` (
`login`
varchar(40) NOT NULL,
`session` varchar(100) NOT NULL,
`ip` char(30)
NOT NULL,
`browser` varchar(100) NOT NULL,
`time` int(11) NOT NULL
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
/* Бан */
CREATE TABLE IF NOT
EXISTS `ban` (
`login` varchar(40) NOT NULL,
`type`
enum('login','ip','browser') NOT NULL default 'login',
`ip` char(30) NOT
NULL,
`browser` varchar(100) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`login`),
KEY (`ip`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
/* Подарки */
CREATE TABLE
IF NOT EXISTS `gifts` (
`id` mediumint(7) NOT NULL auto_increment,
`price` int(11) NOT NULL default '100',
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/* Мод
Подарков*/
CREATE TABLE IF NOT EXISTS `present` (
`id` int(11)
NOT NULL auto_increment,
`fid` mediumint(7) NOT NULL,
`login`
varchar(40) NOT NULL,
`whom` varchar(40) NOT NULL,
`text` text NOT
NULL,
`anonim` enum('0','1') NOT NULL default '0',
`time` int(11) NOT
NULL,
PRIMARY KEY (`id`),
KEY (`fid`),
KEY (`login`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
/* Форум */
CREATE TABLE IF NOT
EXISTS `forum` (
`id` int(11) NOT NULL auto_increment,
`fid` int(11)
NOT NULL,
`type` enum('f','r','t','m') NOT NULL default 'm',
`name`
varchar(40) NOT NULL,
`text` text(400) NOT NULL,
`file` tinytext NOT
NULL,
`size` int(11) NOT NULL default '0',
`ip` char(30) NOT NULL,
`browser` varchar(100) NOT NULL,
`edit` varchar(40) NOT NULL,
`timeedit` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;