Просмотр архива Blog exl

DROP TABLE IF EXISTS `action`;

CREATE TABLE `action` (
  `id` int(22) NOT
NULL AUTO_INCREMENT,
  `id_us` int(22) NOT NULL,
  `read` smallint(2) NOT
NULL,
  `msg` text,
  `time` int(22) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `avt`;

CREATE
TABLE `avt` (
  `id` int(22) NOT NULL AUTO_INCREMENT,
  `id_us` int(22) NOT
NULL,
  `kto` int(22) NOT NULL,
  `read` smallint(2) NOT NULL,
  `type`
varchar(100) NOT NULL,
  `msg` varchar(150) NOT NULL,
  `time` int(22) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `blog`;

CREATE TABLE `blog` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` char(150) NOT NULL,
  `time` int(22) NOT NULL,
 
`msg` text,
  `id_cat` int(22) NOT NULL,
  `activ` int(2) NOT NULL,
 
`id_us` int(22) NOT NULL,
  `look` int(22) NOT NULL,
  `metka` varchar(40)
NOT NULL,
  `file` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`blog_vote`;

CREATE TABLE `blog_vote` (
  `id` int(22) NOT NULL
AUTO_INCREMENT,
  `id_blog` int(22) NOT NULL,
  `like` smallint(2) NOT
NULL,
  `id_us` int(22) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=latin1;




DROP TABLE IF EXISTS `blogger`;

CREATE TABLE
`blogger` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` char(35) NOT
NULL,
  `pass` char(100) NOT NULL,
  `name` char(38) NOT NULL,
  `ava`
varchar(50) NOT NULL,
  `time_reg` int(22) NOT NULL,
  `sex` int(2) DEFAULT
NULL,
  `ip` text,
  `ua` text,
  `onl` int(22) NOT NULL,
  `email`
varchar(50) NOT NULL,
  `level` int(1) NOT NULL,
  `city` varchar(100) NOT
NULL,
  `icq` int(10) NOT NULL,
  `style` varchar(150) NOT NULL DEFAULT
'/design/css.css',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `cat`;

CREATE TABLE `cat` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `name` char(38) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`chat`;

CREATE TABLE `chat` (
  `id` int(22) NOT NULL AUTO_INCREMENT,
 
`id_us` int(35) NOT NULL,
  `msg` text NOT NULL,
  `time` int(22) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `design`;

CREATE TABLE `design` (
  `id` int(20) NOT NULL
AUTO_INCREMENT,
  `us` int(11) NOT NULL DEFAULT '0',
  `path` char(100)
DEFAULT NULL,
  `name` char(200) DEFAULT NULL,
  `kod` text,
  `off` int(1)
NOT NULL DEFAULT '0',
  `graph` char(150) NOT NULL DEFAULT '/images/',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;

INSERT INTO `design`
VALUES("1","0","/design/style.css","Default","","1","");



DROP
TABLE IF EXISTS `komm`;

CREATE TABLE `komm` (
  `id` int(22) NOT NULL
AUTO_INCREMENT,
  `id_us` int(22) NOT NULL,
  `id_blog` int(22) NOT NULL,
 
`msg` text,
  `time` int(22) NOT NULL,
  `type` smallint(2) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `mail`;

CREATE TABLE `mail` (
  `id` int(22) NOT NULL
AUTO_INCREMENT,
  `kto` int(22) NOT NULL,
  `komu` int(22) NOT NULL,
 
`msg` text,
  `read` int(22) NOT NULL,
  `time` int(22) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`news`;

CREATE TABLE `news` (
  `id` int(22) NOT NULL AUTO_INCREMENT,
 
`msg` text,
  `time` int(22) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `news_komm`;

CREATE TABLE
`news_komm` (
  `id` int(22) NOT NULL AUTO_INCREMENT,
  `id_us` int(22) NOT
NULL,
  `id_news` int(22) NOT NULL,
  `msg` varchar(150) NOT NULL,
  `time`
int(22) NOT NULL,
  `activ` smallint(2) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`settings`;

CREATE TABLE `settings` (
  `id` int(22) NOT NULL
AUTO_INCREMENT,
  `description` char(150) NOT NULL,
  `keywords` char(150)
NOT NULL,
  `copy` char(150) NOT NULL,
  `online` int(22) NOT NULL DEFAULT
'600',
  `logo` varchar(100) NOT NULL,
  `name` varchar(55) NOT NULL,
 
`chat` smallint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`smiles`;

CREATE TABLE `smiles` (
  `id` int(22) NOT NULL AUTO_INCREMENT,

 `name` varchar(35) NOT NULL,
  `file` varchar(150) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;