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

CREATE TABLE `blog` (
  `blog_id` int(11) NOT NULL auto_increment,
  `user` text,
  `blog_title` text,
  `blog_content` text,
  PRIMARY KEY  (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
CREATE TABLE `blog_files` (
  `id` int(11) NOT NULL auto_increment,
  `id_blog` int(11) NOT NULL,
  `name` varchar(64) default NULL,
  `ras` varchar(32) NOT NULL,
  `size` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id_post` (`id_blog`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
CREATE TABLE `blog_img` ( `id` int(11) NOT NULL
auto_increment, `id_blog` int(11) NOT NULL, `name` varchar(64) default
NULL, `ras` varchar(32) NOT NULL, `size` int(11) NOT NULL, `type` varchar(32) NOT
NULL, PRIMARY KEY (`id`), KEY `id_post` (`id_blog`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client
= @saved_cs_client;
CREATE TABLE `blog_komm`
( `id` int(11) NOT NULL
auto_increment, `id_user` int(11) NOT NULL, `id_blog` varchar(50) NOT
NULL, `msg` varchar(1024) NOT
NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
SET character_set_client =
@ saved_cs_client;
CREATE TABLE `blog_komm`
( `id` int(11) NOT NULL
auto_increment, `id_user` int(11) NOT NULL, `id_blog` varchar(50) NOT
NULL, `msg` varchar(1024) NOT
NULL, `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
SET character_set_client =
@ saved_cs_client;
CREATE TABLE `blog_list` ( `id` int(11) NOT NULL
auto_increment, `id_user` int(11) NOT NULL, `name` varchar(50) NOT
NULL, `msg` varchar(5000) NOT
NULL, `time` int(11) NOT NULL, `privat` int(11) NOT NULL, `count` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM
AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;
SET character_set_client =
@ saved_cs_client;