Просмотр архива Социальная сеть sraka

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Host: 127.0.0.1
-- Generation Time: Dec 09, 2012 at 12:53 PM
-- Server
version: 5.5.25
-- PHP Version: 5.3.13

SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";


/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;

--
-- Database: `lovs`
--

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `new`
int(11) NOT NULL,
  `news` int(11) NOT NULL,
  `forum` int(11) NOT NULL,
 
`diary` int(11) NOT NULL,
  `chat` int(11) NOT NULL,
  `blog` int(11) NOT
NULL,
  `foto` int(11) NOT NULL,
  `ban` int(11) NOT NULL,
  `edit` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_ban`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_blog`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_edit`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_edit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_forum`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_foto`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_foto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_money`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_money` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  `code` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `admin_jurnal_news`
--

CREATE TABLE IF NOT EXISTS
`admin_jurnal_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `arbour`
--

CREATE TABLE IF NOT EXISTS `arbour` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
 
`message` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `chat_messages`
--

CREATE TABLE IF NOT EXISTS
`chat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT
NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `priv`
int(11) NOT NULL,
  `room` int(11) NOT NULL,
  `umnik` int(11) NOT NULL,
 
`vopros` int(11) NOT NULL,
  `timevopros` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `chat_room`
--

CREATE TABLE IF NOT EXISTS `chat_room`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `descr`
text NOT NULL,
  `time` int(11) NOT NULL,
  `type` int(11) NOT NULL,
 
`ord` int(11) NOT NULL,
  `bes` int(11) NOT NULL,
  `admin` int(11) NOT
NULL,
  `user` int(11) NOT NULL,
  `etime` int(11) NOT NULL,
  `edit`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `chat_vopros`
--

CREATE TABLE IF NOT EXISTS
`chat_vopros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vopros`
varchar(1024) NOT NULL,
  `otvet` varchar(32) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `dialogs_contacts`
--

CREATE TABLE IF NOT EXISTS
`dialogs_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `contact` int(11) NOT NULL,
  `time` int(11) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `dialogs_messages`
--

CREATE TABLE IF NOT EXISTS
`dialogs_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `outuser` int(11) NOT NULL,
  `inuser` int(11) NOT
NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `new` int(11)
NOT NULL,
  `id2` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `diary_comm`
--

CREATE TABLE IF NOT EXISTS
`diary_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `diary`
int(11) NOT NULL,
  `new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `diary_like`
--

CREATE TABLE IF NOT EXISTS
`diary_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  `diary` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `diary_messages`
--

CREATE TABLE IF NOT EXISTS
`diary_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `name` text NOT NULL,
  `message` text NOT NULL,
  `time`
int(11) NOT NULL,
  `view` int(11) NOT NULL,
  `comm_priv` int(11) NOT
NULL,
  `cedit` int(11) NOT NULL,
  `priv` int(11) NOT NULL,
  `etime`
int(11) NOT NULL,
  `who` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
 
`18` int(11) NOT NULL,
  `votes` char(250) NOT NULL,
  `vote1` char(50) NOT
NULL,
  `vote2` char(50) NOT NULL,
  `vote3` char(50) NOT NULL,
  `vote4`
char(50) NOT NULL,
  `vote5` char(50) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `diary_view`
--

CREATE TABLE IF NOT EXISTS
`diary_view` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL,
  `view` int(11) NOT NULL,
  `last_time` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `diary` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `duels_add`
--

CREATE TABLE IF NOT EXISTS `duels_add`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user1` int(11) NOT NULL,
 
`user2` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `duels_list`
--

CREATE TABLE IF NOT EXISTS
`duels_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user1` int(11)
NOT NULL,
  `user2` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`time_end` int(11) NOT NULL,
  `victory` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `duels_votes`
--

CREATE TABLE IF NOT EXISTS
`duels_votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `vote` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `duel`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `forum_categories`
--

CREATE TABLE IF NOT EXISTS
`forum_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text
NOT NULL,
  `time` int(11) NOT NULL,
  `opis` text NOT NULL,
  `user`
int(11) NOT NULL,
  `edit` int(11) NOT NULL,
  `ord` int(11) NOT NULL,
 
`etime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `forum_deleted`
--

CREATE TABLE IF NOT EXISTS
`forum_deleted` (
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `forum_forums`
--

CREATE TABLE IF NOT EXISTS
`forum_forums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT
NULL,
  `time` int(11) NOT NULL,
  `cat` int(11) NOT NULL,
  `ord` int(11)
NOT NULL,
  `user` int(11) NOT NULL,
  `edit` int(11) NOT NULL,
  `etime`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `forum_messages`
--

CREATE TABLE IF NOT EXISTS
`forum_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `cedit`
int(11) NOT NULL,
  `etime` int(11) NOT NULL,
  `main` int(11) NOT NULL,
 
`theme` int(11) NOT NULL,
  `forum` int(11) NOT NULL,
  `cat` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `forum_themes`
--

CREATE TABLE IF NOT EXISTS
`forum_themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `name` text NOT NULL,
  `time` int(11) NOT NULL,
  `forum`
int(11) NOT NULL,
  `cat` int(11) NOT NULL,
  `ord` int(11) NOT NULL,
 
`opis` text NOT NULL,
  `close` int(11) NOT NULL,
  `close_id` int(11) NOT
NULL,
  `who` int(11) NOT NULL,
  `cedit` int(11) NOT NULL,
  `etime`
int(11) NOT NULL,
  `fix` int(11) NOT NULL,
  `18` int(11) NOT NULL,
 
`admin` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `friends`
--

CREATE TABLE IF NOT EXISTS `friends` (
 
`user` int(11) NOT NULL,
  `friend` int(11) NOT NULL,
  `time` int(11) NOT
NULL,
  `rating` int(11) NOT NULL,
  `online` int(11) NOT NULL,
  `active`
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `friends_adding`
--

CREATE TABLE IF NOT EXISTS
`friends_adding` (
  `user` int(11) NOT NULL,
  `friend` int(11) NOT NULL,

 `time` int(11) NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `garems_list`
--

CREATE TABLE IF NOT EXISTS
`garems_list` (
  `id` int(11) NOT NULL,
  `users` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `garems_users`
--

CREATE TABLE IF NOT EXISTS
`garems_users` (
  `id` int(11) NOT NULL,
  `garem` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `steals` int(11) NOT NULL,
  `price` int(11) NOT
NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `gazeta`
--

CREATE TABLE IF NOT EXISTS `gazeta` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `name` text NOT NULL,
  `message` text NOT NULL,
 
`who` int(11) NOT NULL,
  `cedit` int(11) NOT NULL,
  `etime` int(11) NOT
NULL,
  `close` int(11) NOT NULL,
  `close_id` int(11) NOT NULL,
  `rating`
int(11) NOT NULL,
  `img` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `gazeta_comm`
--

CREATE TABLE IF NOT EXISTS
`gazeta_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  `message` text NOT NULL,
  `gazeta`
int(11) NOT NULL,
  `comm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `gazeta_like`
--

CREATE TABLE IF NOT EXISTS
`gazeta_like` (
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`gazeta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `gifts_cat`
--

CREATE TABLE IF NOT EXISTS `gifts_cat`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `ord`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `gifts_list`
--

CREATE TABLE IF NOT EXISTS
`gifts_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `price` int(11)
NOT NULL,
  `cat` int(11) NOT NULL,
  `ord` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `gifts_users`
--

CREATE TABLE IF NOT EXISTS
`gifts_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `outuser` int(11) NOT NULL,
  `gift` int(11) NOT NULL,
 
`message` text NOT NULL,
  `time` int(11) NOT NULL,
  `priv` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `guest`
--

CREATE TABLE IF NOT EXISTS `guest` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `idguest` int(11) NOT NULL,
  `idg`
int(11) NOT NULL,
  `data` text NOT NULL,
  `msg` text NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `jurnal`
--

CREATE TABLE IF NOT EXISTS `jurnal` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
 
`outuser` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT
NULL,
  `new` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `lenta`
--

CREATE TABLE IF NOT EXISTS `lenta` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `text` text
NOT NULL,
  `time` int(11) NOT NULL,
  `new` int(11) NOT NULL,
  `diary`
int(11) NOT NULL,
  `blog` int(11) NOT NULL,
  `forum` int(11) NOT NULL,
 
`foto` int(11) NOT NULL,
  `comm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `lenta_blog`
--

CREATE TABLE IF NOT EXISTS
`lenta_blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `new` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `lenta_diary`
--

CREATE TABLE IF NOT EXISTS
`lenta_diary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `new`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `lenta_forum`
--

CREATE TABLE IF NOT EXISTS
`lenta_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `new`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `lenta_foto`
--

CREATE TABLE IF NOT EXISTS
`lenta_foto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `new` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `mail_contacts`
--

CREATE TABLE IF NOT EXISTS
`mail_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `contact` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `mail_messages`
--

CREATE TABLE IF NOT EXISTS
`mail_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `inuser` int(11) NOT NULL,
  `outuser` int(11) NOT NULL,
 
`message` text NOT NULL,
  `time` int(11) NOT NULL,
  `new` int(11) NOT
NULL,
  `id2` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `microblog_comm`
--

CREATE TABLE IF NOT EXISTS
`microblog_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
 
`microblog` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `microblog_like`
--

CREATE TABLE IF NOT EXISTS
`microblog_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  `microblog` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `microblog_messages`
--

CREATE TABLE IF NOT EXISTS
`microblog_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
 
`view` int(11) NOT NULL,
  `likes` int(11) NOT NULL,
  `comm` int(11) NOT
NULL,
  `main` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `microblog_view`
--

CREATE TABLE IF NOT EXISTS
`microblog_view` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `view` int(11) NOT NULL,
  `last_time` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `microblog` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `name` text NOT NULL,
  `message` text NOT NULL,
 
`who` int(11) NOT NULL,
  `cedit` int(11) NOT NULL,
  `etime` int(11) NOT
NULL,
  `close` int(11) NOT NULL,
  `close_id` int(11) NOT NULL,
  `rating`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `news_comm`
--

CREATE TABLE IF NOT EXISTS `news_comm`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
 
`time` int(11) NOT NULL,
  `message` text NOT NULL,
  `news` int(11) NOT
NULL,
  `comm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `news_like`
--

CREATE TABLE IF NOT EXISTS `news_like`
(
  `user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `news` int(11)
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `photos_albums`
--

CREATE TABLE IF NOT EXISTS
`photos_albums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT
NULL,
  `descr` text NOT NULL,
  `user` int(11) NOT NULL,
  `time` int(11)
NOT NULL,
  `priv` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `photos_comm`
--

CREATE TABLE IF NOT EXISTS
`photos_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
  `photo`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `photos_like`
--

CREATE TABLE IF NOT EXISTS
`photos_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  `photo` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `photos_photo`
--

CREATE TABLE IF NOT EXISTS
`photos_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT
NULL,
  `descr` text NOT NULL,
  `user` int(11) NOT NULL,
  `time` int(11)
NOT NULL,
  `album` int(11) NOT NULL,
  `rating` double NOT NULL,
  `top`
int(11) NOT NULL,
  `edit` text NOT NULL,
  `who` int(11) NOT NULL,
 
`cedit` int(11) NOT NULL,
  `etime` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `popular`
--

CREATE TABLE IF NOT EXISTS `popular` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `popular_history`
--

CREATE TABLE IF NOT EXISTS
`popular_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `rating_history`
--

CREATE TABLE IF NOT EXISTS
`rating_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `outuser` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
`rating` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `ref`
--

CREATE TABLE IF NOT EXISTS `ref` (
  `id`
int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `moneyuser` int(11) NOT
NULL,
  `data` text NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

--
--------------------------------------------------------

--
-- Table
structure for table `smiles`
--

CREATE TABLE IF NOT EXISTS `smiles` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `code` text NOT NULL,
  `category`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `smiles_category`
--

CREATE TABLE IF NOT EXISTS
`smiles_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text
NOT NULL,
  `ord` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `spam`
--

CREATE TABLE IF NOT EXISTS `spam` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `spamer`
int(11) NOT NULL,
  `message` text NOT NULL,
  `type` text NOT NULL,
 
`time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `pass` text NOT
NULL,
  `password` text NOT NULL,
  `sex` text NOT NULL,
  `admin` int(11)
NOT NULL,
  `likes` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
 
`rating_time` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `money_time`
int(11) NOT NULL,
  `online` int(11) NOT NULL,
  `location` text NOT NULL,

 `ban` int(11) NOT NULL,
  `anketa_name` text NOT NULL,
  `anketa_surname`
text NOT NULL,
  `anketa_bday` int(11) NOT NULL,
  `anketa_bmonth` int(11)
NOT NULL,
  `anketa_byear` int(11) NOT NULL,
  `anketa_sp` int(11) NOT
NULL,
  `anketa_spu` int(11) NOT NULL,
  `anketa_city` text NOT NULL,
 
`anketa_mphone` text NOT NULL,
  `anketa_icq` text NOT NULL,
 
`anketa_site` text NOT NULL,
  `anketa_activity` text NOT NULL,
 
`anketa_interests` text NOT NULL,
  `anketa_about` text NOT NULL,
 
`anketa_datareg` int(11) NOT NULL,
  `anketa_alltime` int(11) NOT NULL,
 
`setting_theme` text NOT NULL,
  `setting_users_list` text NOT NULL,
 
`setting_mail_list` text NOT NULL,
  `setting_jurnal_list` text NOT NULL,
 
`priv_mypage` text NOT NULL,
  `priv_anketa` text NOT NULL,
 
`priv_friends` text NOT NULL,
  `priv_mail` text NOT NULL,
 
`chat_location` int(11) NOT NULL,
  `stat_arbour` int(11) NOT NULL,
 
`stat_guestbook` int(11) NOT NULL,
  `stat_chat` int(11) NOT NULL,
 
`stat_forum_themes` int(11) NOT NULL,
  `stat_forum_messages` int(11) NOT
NULL,
  `count_mail` int(11) NOT NULL,
  `count_friends` int(11) NOT NULL,

 `developer` int(11) NOT NULL,
  `ip` char(20) NOT NULL,
  `ua` char(200)
NOT NULL,
  `mail` int(11) NOT NULL,
  `money_ref` int(11) NOT NULL,
 
`link` varchar(200) NOT NULL,
  `clock` int(11) NOT NULL,
  `panel1`
int(11) NOT NULL,
  `panel2` int(11) NOT NULL,
  `panel3` int(11) NOT
NULL,
  `panel4` int(11) NOT NULL,
  `panel5` int(11) NOT NULL,
  `panel6`
int(11) NOT NULL,
  `panel7` int(11) NOT NULL,
  `panel8` int(11) NOT
NULL,
  `panel9` int(11) NOT NULL,
  `panel10` int(11) NOT NULL,
 
`panel11` int(11) NOT NULL,
  `panel12` int(11) NOT NULL,
  `delete`
int(11) NOT NULL,
  `vip` int(11) NOT NULL,
  `flirt1` int(11) NOT NULL,
 
`flirt2` int(11) NOT NULL,
  `flirt3` int(11) NOT NULL,
  `flirt4` int(11)
NOT NULL,
  `flirt5` int(11) NOT NULL,
  `flirt6` int(11) NOT NULL,
 
`flirt7` int(11) NOT NULL,
  `flirt8` int(11) NOT NULL,
  `smile`
varchar(20) NOT NULL,
  `family` int(11) NOT NULL,
  `growth` varchar(11)
NOT NULL DEFAULT '0',
  `weight` varchar(11) NOT NULL DEFAULT '0',
  `hair`
varchar(100) NOT NULL,
  `eyes` varchar(100) NOT NULL,
  `physique` int(11)
NOT NULL,
  `character` varchar(100) NOT NULL,
  `orientation` int(11) NOT
NULL,
  `dating1` int(11) NOT NULL,
  `dating2` int(11) NOT NULL,
 
`dating3` int(11) NOT NULL,
  `dating4` int(11) NOT NULL,
  `dating5`
int(11) NOT NULL,
  `dating6` int(11) NOT NULL,
  `dating7` int(11) NOT
NULL,
  `dating8` int(11) NOT NULL,
  `business` int(11) NOT NULL,
 
`profession` varchar(100) NOT NULL,
  `smoke` int(11) NOT NULL,
  `policy`
int(11) NOT NULL,
  `world_view` int(11) NOT NULL,
  `life` int(11) NOT
NULL,
  `people` int(11) NOT NULL,
  `inspire` varchar(1000) NOT NULL,
 
`pcolor` varchar(11) NOT NULL DEFAULT '#D4EEFF',
  `plink` varchar(11) NOT
NULL DEFAULT '#434e60',
  `pfon` varchar(11) NOT NULL DEFAULT '#b4c8e9',
 
`ncolor` varchar(11) NOT NULL DEFAULT '#FF0000',
  `bb_code` int(11) NOT
NULL,
  `evip` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `users_ban`
--

CREATE TABLE IF NOT EXISTS `users_ban`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
 
`message` text NOT NULL,
  `admin` int(11) NOT NULL,
  `time` int(11) NOT
NULL,
  `time_ban` int(11) NOT NULL,
  `who` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `users_ban_post`
--

CREATE TABLE IF NOT EXISTS
`users_ban_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `message` text NOT NULL,
  `admin` int(11) NOT NULL,
  `time`
int(11) NOT NULL,
  `time_ban` int(11) NOT NULL,
  `who` int(11) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `users_likes`
--

CREATE TABLE IF NOT EXISTS
`users_likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `outuser` int(11) NOT NULL,
  `time` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `users_photo`
--

CREATE TABLE IF NOT EXISTS
`users_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  `page` int(11) NOT NULL,
  `rating`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `users_photo_comm`
--

CREATE TABLE IF NOT EXISTS
`users_photo_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `message` text NOT NULL,
  `time` int(11) NOT NULL,
 
`photo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

--
--------------------------------------------------------

--
-- Table
structure for table `users_photo_like`
--

CREATE TABLE IF NOT EXISTS
`users_photo_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `photo` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

-- --------------------------------------------------------

--
-- Table
structure for table `wall`
--

CREATE TABLE IF NOT EXISTS `wall` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `message`
text NOT NULL,
  `time` int(11) NOT NULL,
  `wall` int(11) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;