Файл: SQL.sql
Строк: 53
CREATE TABLE `bann` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`user_id`
int(11) NOT NULL,
`who` int(11) NOT NULL,
`why` varchar(250) NOT NULL,
`time_bann` int(11) NOT NULL,
`type` varchar(250) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `blog` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`user_id` int(22) NOT NULL,
`text` text,
`time` bigint(22) NOT NULL,
`tags` varchar(250) NOT NULL,
`chit` int(11) NOT NULL,
`latname` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE
`comments` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`blog` int(11) NOT
NULL,
`user_id` int(22) NOT NULL,
`text` text,
`time` bigint(22) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE
TABLE `mail` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`id_user` int(11)
NOT NULL,
`text` text,
`user_id` int(11) NOT NULL,
`read` int(11) NOT
NULL,
`type` varchar(100) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `session` (
`id_session` char(200) NOT NULL,
`ua` text,
`ip` varchar(100) NOT
NULL,
`date` int(11) NOT NULL,
`pereh` int(11) NOT NULL,
PRIMARY KEY
(`id_session`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `setting`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`keywords` text,
`description` text,
`reg` int(11) NOT NULL,
`index_end` int(11) NOT
NULL,
`end` int(11) NOT NULL,
`title` varchar(100) NOT NULL,
`onl`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO `setting` VALUES
(1, 'Блог,
интернет, политика, обсуждение, война,
Новороссия, ополчение, Русская Весна, it
news', 'Мобильный блог обо всем. Обсуждение,
полезная информация, блогосфера', 1, 5, 10,
'Vevas.Ru', 900);
CREATE TABLE `smiles` (
`id` int(22) NOT NULL
AUTO_INCREMENT,
`name` varchar(250) NOT NULL,
`file` varchar(250) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE
TABLE `users` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`user`
varchar(250) NOT NULL,
`pass` varchar(250) NOT NULL,
`level` int(11)
NOT NULL,
`sex` int(11) NOT NULL,
`ip` text,
`soft` text,
`time_reg` bigint(22) NOT NULL,
`mail` varchar(250) NOT NULL,
`onl`
int(11) NOT NULL,
`name` char(250) NOT NULL,
`icq` int(9) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;