Просмотр архива SNE

-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jul 20, 2013 at 05:37 PM
-- Server
version: 5.1.40
-- PHP Version: 5.3.13

SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `vk`
--

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

--
-- Table
structure for table `friendship`
--

CREATE TABLE IF NOT EXISTS
`friendship` (
  `id_user_1` int(32) NOT NULL,
  `id_user_2` int(32) NOT
NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;

--
-- Dumping data for table `friendship`
--


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

--
-- Table
structure for table `privs`
--

CREATE TABLE IF NOT EXISTS `privs` (
 
`id_priv` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
 
`description` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id_priv`),
 
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
AUTO_INCREMENT=6 ;

--
-- Dumping data for table `privs`
--

INSERT INTO
`privs` (`id_priv`, `name`, `description`) VALUES
(5, 'EDITOR', NULL);

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

--
-- Table
structure for table `privs2roles`
--

CREATE TABLE IF NOT EXISTS
`privs2roles` (
  `id_priv` int(5) NOT NULL,
  `id_role` int(5) NOT NULL,
 
PRIMARY KEY (`id_priv`,`id_role`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;

--
-- Dumping data for table `privs2roles`
--

INSERT INTO
`privs2roles` (`id_priv`, `id_role`) VALUES
(2, 1),
(3, 1),
(4, 1),
(5,
1);

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

--
--
Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS
`profile` (
  `id_profile` int(100) NOT NULL AUTO_INCREMENT,
  `id_user`
int(100) NOT NULL,
  `first_name` varchar(255) CHARACTER SET utf8 NOT
NULL,
  `last_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `bdate`
varchar(10) CHARACTER SET utf8 NOT NULL,
  `city` int(32) NOT NULL,
 
`country` int(32) NOT NULL,
  `relation` int(1) NOT NULL,
  `relation_uid`
int(100) NOT NULL,
  `sex` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
 
`screen_name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
 
`bday` int(32) NOT NULL,
  `bmonth` int(32) NOT NULL,
  `byear` int(32) NOT
NULL,
  `lang` int(32) NOT NULL,
  `mobile_phone` varchar(255) NOT NULL,
 
PRIMARY KEY (`id_profile`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
AUTO_INCREMENT=30 ;

--
-- Dumping data for table `profile`
--

INSERT INTO
`profile` (`id_profile`, `id_user`, `first_name`, `last_name`, `bdate`,
`city`, `country`, `relation`, `relation_uid`, `sex`, `screen_name`,
`status`, `bday`, `bmonth`, `byear`, `lang`, `mobile_phone`) VALUES
(1, 2,
'Артем', 'Богославский', '31.8.1996', 4088, 3159, 5, 2,
'1', 'art', 'Реализовал изменение статуса)))', 0,
0, 0, 0, '');

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

--
-- Table
structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
 
`id_role` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
 
`description` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id_role`),
 
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;

--
-- Dumping data for table `roles`
--

INSERT INTO
`roles` (`id_role`, `name`, `description`) VALUES
(1, 'admin', '???? ???
??????');

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

--
-- Table
structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (

 `id_session` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT
NULL,
  `sid` varchar(10) NOT NULL,
  `time_start` datetime NOT NULL,
 
`time_last` datetime NOT NULL,
  PRIMARY KEY (`id_session`),
  UNIQUE KEY
`sid` (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=253
;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions`
(`id_session`, `id_user`, `sid`, `time_start`, `time_last`) VALUES
(252, 2,
'm6s8cOkgpV', '2013-07-20 17:31:58', '2013-07-20 17:33:10');

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

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

CREATE TABLE IF NOT EXISTS `users` (
 
`id_user` int(5) NOT NULL AUTO_INCREMENT,
  `login` varchar(256) NOT NULL,

 `password` varchar(32) NOT NULL,
  `id_role` int(5) DEFAULT NULL,
 
`id_profile` int(11) NOT NULL,
  PRIMARY KEY (`id_user`),
  UNIQUE KEY
`login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=24
;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id_user`,
`login`, `password`, `id_role`, `id_profile`) VALUES
(2, 'Admin',
'c4ca4238a0b923820dcc509a6f75849b', 1, 1);