Просмотр файла db.sql

CREATE TABLE `users`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`login` VARCHAR(20) NOT NULL,
`pass` VARCHAR(50) NOT NULL,
`name` VARCHAR(20) NOT NULL,
`city` VARCHAR(100) NOT NULL,
`sex` CHAR(1) NOT NULL,
`birth` INT(11),
`orient` VARCHAR(20),
`about` VARCHAR(500),
`tel` VARCHAR(13),
`icq` VARCHAR(11),
`skype` VARCHAR(50),
`site` VARCHAR(100),
`mail` VARCHAR(100),
`visit` INT(11),
`balans` INT(11),
`rights` SMALLINT(1),
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `rating`(
`user` INT(11) NOT NULL,
`for` INT(11) NOT NULL,
PRIMARY KEY(`user`, `for`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `wall`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`refid` INT(11) NOT NULL,
`author` INT(11) NOT NULL,
`text` VARCHAR(1000) NOT NULL,
`date` INT(11) NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `lists`(
`user` INT(11) NOT NULL,
`ref` INT(11) NOT NULL,
`list` VARCHAR(10) NOT NULL,
PRIMARY KEY(`user`, `ref`, `list`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `chat_rooms`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`caption` VARCHAR(30) NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `chat`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`room` INT(11) NOT NULL,
`author` INT(11) NOT NULL,
`text` VARCHAR(1000) NOT NULL,
`date` INT(11) NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `chat_online`(
`user` INT(11) NOT NULL,
`room` INT(11) NOT NULL,
`date` INT(11) NOT NULL,
PRIMARY KEY(`user`, `room`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `mail`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`from` INT(11) NOT NULL,
`to` INT(11) NOT NULL,
`text` VARCHAR(5000) NOT NULL,
`date` INT(11) NOT NULL,
`readed` SMALLINT(1),
`file` VARCHAR(100),
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `news`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`caption` VARCHAR(50) NOT NULL,
`text` VARCHAR(5000) NOT NULL,
`date` INT(11) NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;