-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: siwap
-- ------------------------------------------------------
-- Server version 5.5.60-MariaDB
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `albums`
--
DROP TABLE IF EXISTS `albums`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `albums` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`url` char(30) NOT NULL,
`time` int(12) NOT NULL,
`name` char(30) NOT NULL,
`user_id` int(12) NOT NULL,
`guest_hash` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `albums`
--
LOCK TABLES `albums` WRITE;
/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
INSERT INTO `albums` VALUES (1,'',1552687833,'Test',3,'');
/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `audios`
--
DROP TABLE IF EXISTS `audios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audios` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`title` char(250) NOT NULL,
`poster` char(250) NOT NULL,
`user_id` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `audios`
--
LOCK TABLES `audios` WRITE;
/*!40000 ALTER TABLE `audios` DISABLE KEYS */;
INSERT INTO `audios` VALUES (1,'http://tegos.kz/new/trap/Tegos_Trap_45_1.mp3','Trap #1','https://images.rapgenius.com/a4daafd9ab20240703eb1308ed23e76d.1000x563x1.jpg',3),(2,'http://tegos.kz/new/trap/Tegos_Trap_45_2.mp3','Trap #2','http://getwallpapers.com/wallpaper/full/7/f/4/708357-trap-music-wallpapers-1920x1080-for-phone.jpg',3),(3,'http://tegos.kz/new/trap/Tegos_Trap_45_3.mp3','Trap #3','https://i.ytimg.com/vi/dxT0AjAhdPo/maxresdefault.jpg',3),(4,'http://tegos.kz/new/trap/Tegos_Trap_45_4.mp3','Trap #4','https://wallpapertag.com/wallpaper/full/8/d/c/757753-gorgerous-trap-nation-wallpapers-1920x1080-for-ios.jpg',3),(5,'http://tegos.kz/new/trap/Tegos_Trap_45_5.mp3','Trap #5','https://i.ytimg.com/vi/ciQ4nfSpXuU/maxresdefault.jpg',3);
/*!40000 ALTER TABLE `audios` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category_gifts`
--
DROP TABLE IF EXISTS `category_gifts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category_gifts` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`type` int(12) NOT NULL,
`name` char(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category_gifts`
--
LOCK TABLES `category_gifts` WRITE;
/*!40000 ALTER TABLE `category_gifts` DISABLE KEYS */;
/*!40000 ALTER TABLE `category_gifts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chat`
--
DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`message` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chat`
--
LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
INSERT INTO `chat` VALUES (1,1555444948,10,'Ррр');
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dialog_users`
--
DROP TABLE IF EXISTS `dialog_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dialog_users` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`access` int(1) NOT NULL,
`user_id` int(12) NOT NULL,
`dialog_id` int(12) NOT NULL,
`date_add` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dialog_users`
--
LOCK TABLES `dialog_users` WRITE;
/*!40000 ALTER TABLE `dialog_users` DISABLE KEYS */;
INSERT INTO `dialog_users` VALUES (1,3,3,1,1552688429),(2,0,21,1,1552688429),(3,0,19,1,1552688429),(4,0,16,1,1552688429),(5,0,10,1,1552688429);
/*!40000 ALTER TABLE `dialog_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dialogs`
--
DROP TABLE IF EXISTS `dialogs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dialogs` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`name` char(100) NOT NULL,
`avatar` char(100) NOT NULL,
`last_time` int(12) NOT NULL,
`author_id` int(12) NOT NULL,
`contact_id` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dialogs`
--
LOCK TABLES `dialogs` WRITE;
/*!40000 ALTER TABLE `dialogs` DISABLE KEYS */;
INSERT INTO `dialogs` VALUES (1,'Тестинг','../uploads/avatar/58189a69-684c-4739-a594-20b99e012a66.jpg',1553276880,3,0);
/*!40000 ALTER TABLE `dialogs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forgot`
--
DROP TABLE IF EXISTS `forgot`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forgot` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`hash` char(70) NOT NULL,
`user_id` int(12) NOT NULL,
`pincode` int(12) NOT NULL,
`recovered` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forgot`
--
LOCK TABLES `forgot` WRITE;
/*!40000 ALTER TABLE `forgot` DISABLE KEYS */;
INSERT INTO `forgot` VALUES (1,1549134474,'',1,12885109,0),(2,1549134660,'',1,47468037,0),(3,1549134794,'979b802477263cde1232026136100b8d',1,43726507,1),(4,1549134955,'023adb5080a14854e342c75e30112253',2,91434436,1),(5,1549146092,'7dda1069d43046d4c2e196df6ece7075',2,84495637,0),(6,1549264004,'8390deae6d56736c165f50b4b0e8ac2d',1,98339350,1),(7,1550165715,'45dbed46307f715e06079f96e6890766',1,42299039,0),(8,1550165735,'eead071f78ed049e7d2215667880b86f',1,80346323,0),(9,1550837002,'63af8a3556b69f55e14346c089fffc70',3,93710152,0),(10,1550837809,'845fd6a2162af562759c294991f1a1d9',3,25707771,0),(11,1550837905,'d51aea20dd00aa5044675e11b8fb6529',3,63897463,0),(12,1550838129,'2f2ed6a4d7b797ce16d0fc0eee84866b',3,9193138,0),(13,1550838182,'b4584e938e29ad668c3950159a7d7f4b',3,25012267,0),(14,1550838225,'f2be0e4e27f4595c785366a49f70019d',3,19871984,0),(15,1550838234,'b133dc08f7aa5bb5b7511ebc7350b182',3,43519,0),(16,1550838600,'41c7df1f18a8ae04554169f3de6880e1',3,44160100,1),(17,1551089335,'24e1571b02761894ac4d11cb5723fc15',18,83448569,0),(18,1551527545,'a406cd3c28757aa6c4a2b7ac93dc8987',3,26309110,1),(19,1551645164,'a9491aa7d16d8ef088fead51bfe6f6eb',21,39928368,0),(20,1555444594,'5eeacfe616fdf425eac5b2d19f10d185',10,56661188,0),(21,1555444599,'e24ff45810964d69ea9547fb26021811',10,55109906,0),(22,1555444637,'f616ca1e39663cb9f5d0684991edb43c',10,9519006,0);
/*!40000 ALTER TABLE `forgot` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `friends`
--
DROP TABLE IF EXISTS `friends`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `friends` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`status` int(1) NOT NULL,
`user_id` int(12) NOT NULL,
`message` char(100) NOT NULL,
`subscriber_id` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `friends`
--
LOCK TABLES `friends` WRITE;
/*!40000 ALTER TABLE `friends` DISABLE KEYS */;
INSERT INTO `friends` VALUES (1,1552689203,1,2,'Тест',1);
/*!40000 ALTER TABLE `friends` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gift`
--
DROP TABLE IF EXISTS `gift`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gift` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`price` int(12) NOT NULL,
`name` char(100) COLLATE utf8_unicode_ci NOT NULL,
`image` char(50) COLLATE utf8_unicode_ci NOT NULL,
`cat_id` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gift`
--
LOCK TABLES `gift` WRITE;
/*!40000 ALTER TABLE `gift` DISABLE KEYS */;
/*!40000 ALTER TABLE `gift` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`read` int(1) NOT NULL,
`time` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`dialog_id` int(12) NOT NULL,
`message` tinytext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (1,1,1552688435,3,1,'Тест'),(2,1,1552720051,3,1,'Хм'),(3,1,1553276880,3,1,'Ля');
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`read` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`message` text CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news`
--
LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` VALUES (1,1552688121,0,3,'Тест'),(2,1553290336,0,3,'Тест');
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_files`
--
DROP TABLE IF EXISTS `news_files`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_files` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`url` char(100) NOT NULL,
`time` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`news_id` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_files`
--
LOCK TABLES `news_files` WRITE;
/*!40000 ALTER TABLE `news_files` DISABLE KEYS */;
INSERT INTO `news_files` VALUES (1,'http://siwap.ru/uploads/attachs/siwap.ru_attach_86d3365d70.jpg',1552688121,3,1),(2,'http://siwap.ru/uploads/attachs/siwap.ru_attach_7c7e5b3a8d.jpg',1553290336,3,2);
/*!40000 ALTER TABLE `news_files` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_likes`
--
DROP TABLE IF EXISTS `news_likes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_likes` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`type` int(1) NOT NULL,
`time` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`news_id` int(12) NOT NULL,
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`),
CONSTRAINT `news_likes_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_likes`
--
LOCK TABLES `news_likes` WRITE;
/*!40000 ALTER TABLE `news_likes` DISABLE KEYS */;
INSERT INTO `news_likes` VALUES (1,1,1553290316,3,1),(2,1,1553290345,3,2),(3,1,1555444924,10,1),(4,1,1555444926,10,2);
/*!40000 ALTER TABLE `news_likes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_views`
--
DROP TABLE IF EXISTS `news_views`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_views` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`news_id` int(12) NOT NULL,
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`),
CONSTRAINT `news_views_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_views`
--
LOCK TABLES `news_views` WRITE;
/*!40000 ALTER TABLE `news_views` DISABLE KEYS */;
/*!40000 ALTER TABLE `news_views` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
`id` int(12) NOT NULL,
`time` int(12) NOT NULL,
`type` int(1) NOT NULL,
`user_id` int(12) NOT NULL,
`read` int(1) NOT NULL,
`author_id` int(12) NOT NULL,
`message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notifications`
--
LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
INSERT INTO `notifications` VALUES (0,9898989,0,1,1,2,'Хочет добавить вас в друзья'),(0,668686,0,1,1,3,'Оценил вашу запись');
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `photos`
--
DROP TABLE IF EXISTS `photos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `photos` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`name` char(100) NOT NULL,
`user_id` int(12) NOT NULL,
`album_id` int(12) NOT NULL,
`guest_hash` char(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `photos`
--
LOCK TABLES `photos` WRITE;
/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
INSERT INTO `photos` VALUES (1,0,'siwap.ru-32905e5bc70129a774a4.png',3,1,''),(2,0,'58189a69-684c-4739-a594-20b99e012a66.jpg',3,0,''),(3,0,'siwap.ru-avatar_e0604afa7a791ab697479ee5d08886.jpg',3,0,''),(4,0,'siwap.ru-avatar_ea586b547169ed0d9cb4272eca178d.jpg',3,0,''),(5,0,'1543376491.jpg',3,1,''),(6,0,'1547274250.jpg',3,1,''),(7,0,'siwap.ru-avatar_2d26e7d922216282cf450e3d4d947f.png',10,0,''),(8,0,'siwap.ru-avatar_f47a708c97261831dc94bc272b5414.png',10,0,''),(9,0,'siwap.ru-avatar_2c32ee7c1141e396f013841a3b3349.png',10,0,''),(10,0,'siwap.ru-avatar_9c561df60e36618f96bd56d82f2631.png',10,0,''),(11,0,'siwap.ru-cover_a85e0f59c93bb9c808c2cd635742de.png',10,0,''),(12,0,'siwap.ru-cover_e97e1171f4e9934212de3ca7d1cd9a.jpeg',10,0,'');
/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `quotes`
--
DROP TABLE IF EXISTS `quotes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quotes` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`text` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `quotes`
--
LOCK TABLES `quotes` WRITE;
/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `settings`
--
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`site_url` char(100) NOT NULL,
`site_name` char(100) NOT NULL,
`site_description` text NOT NULL,
`adver_price_day` decimal(11,2) NOT NULL,
`adver_price_year` decimal(11,2) NOT NULL,
`adver_price_month` decimal(11,2) NOT NULL,
`max_files_to_download` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `settings`
--
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'a0235280.xsph.ru','Фотохостинг ThePix','ThePix - это бесплатный хостинг изображений',0.00,0.00,0.00,100);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`login` varchar(20) NOT NULL,
`number` varchar(25) NOT NULL,
`token` varchar(60) NOT NULL,
`password` varchar(30) NOT NULL,
`name` varchar(20) NOT NULL,
`last_name` varchar(30) NOT NULL,
`avatar` varchar(100) NOT NULL,
`fon_avatar` varchar(100) NOT NULL,
`country` varchar(40) NOT NULL,
`city` varchar(40) NOT NULL,
`date_reg` int(12) NOT NULL,
`date_last` int(20) NOT NULL,
`online` int(12) NOT NULL,
`access` int(1) NOT NULL,
`email` varchar(50) NOT NULL,
`status` varchar(60) NOT NULL,
`gender` int(1) NOT NULL,
`money` decimal(11,2) NOT NULL DEFAULT '0.00',
`vip` int(1) NOT NULL,
`age` int(3) NOT NULL,
`cache_file` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Array','79407767453','3b4a6a61b2faf075d9ecb5721442cb49','qazxsw102','Евгений','Шишмаков','','','Россия','Краснодар',1549115645,1553289293,1553289293,4,'[email protected]','Плата тлеет, неспеша, тихо куллером шурша..????',1,0.00,0,19,'f6a6b856aeb74a115592c01feb4316a7f2c0d690228ba8.dat'),(2,'Admin','89387777867','b31cf577965b3527d48f3d1f3d217251','Ghj26549','Макс','Алиев','/uploads/avatar/siwap.ru_avatar-601657de27.jpg','','Россия','Хасавюрт',1549116639,1555579967,1555579967,0,'[email protected]','Нет статуса',1,0.00,0,24,''),(13,'id13','380734565253','3cbca61cdd0ad88717abe8b826e32a82','928430','fhhfhxhx','xhxhhxhx','','','','',1550165415,0,0,0,'','',1,0.00,0,0,''),(3,'Router','79407117933','f6fca0bce31adbc20030a04112caf4dd','qazxsw102','Евгений','Николаевич','/uploads/avatar/siwap.ru-avatar_ea586b547169ed0d9cb4272eca178d.jpg','','Россия','',1549179635,1556011124,1556011124,0,'','Ку-ку, епта',1,0.00,0,20,'3df9eb0c42b4e8c7ab98ffaff22b604edff5fbf3.dat'),(4,'id4','79387833300','84f66243324360b501c602399a65f551','456524','The','Симба','','','Россия','',1549190793,1549346118,1549346118,0,'','',1,0.00,0,0,''),(5,'id5','89181234567','8f862bf10cf2bcd065bbfaa92e92571b','473437','Нет','Тоже','','','','',1549375236,0,0,0,'','',1,0.00,0,0,''),(6,'id6','89085056904','50aa4e46d3940b64bfb22fb6fe8e0210','876432','Нет','Тоже','','','','',1549447077,1549539742,1549539742,0,'','',1,0.00,0,0,''),(7,'id7','79805461617','7937400c6a3cfc8ee33f8cc845833c99','878508','Viktor','Kovalev','','','','',1549447154,1549549462,1549549462,0,'','',1,0.00,0,0,''),(8,'Gosenov','89285558642','4f1c59452cb8759c9dca13e63777691a','159595','гасан','госенов','','','Россия','',1549533834,1549541919,1549541919,0,'','',1,0.00,0,0,''),(9,'id9','89181234566','72c9342ad7d2d880673bc9501f90b2f2','831805','Test','Tester','','','','',1549539306,0,0,0,'','',1,0.00,0,0,''),(10,'id10','89021246268','35f76d94007b61a9842b5ec6b66e815f','545605','вован','охотников','/uploads/avatar/siwap.ru-avatar_9c561df60e36618f96bd56d82f2631.png','/uploads/cover/siwap.ru-cover_e97e1171f4e9934212de3ca7d1cd9a.jpeg','','',1549866939,1555863026,1555863026,0,'','',1,0.00,0,0,''),(11,'id11','89181233567','cf87eb193ae2e27146d8fa669d30ac55','95499','First name','Last name','','','','',1549911104,0,0,0,'','',1,0.00,0,0,''),(12,'id12','80292554478','5b29f559314777fe4f7f7483b0bf043d','536685','Аааа','Ааааааа','','','','',1549967013,0,0,0,'','',1,0.00,0,0,''),(14,'id14','380734026675','3b75df41564a12473a9dc54aab4690d6','203579','fhhfhxh','xhxhhxh','','','','',1550165434,0,0,0,'','',1,0.00,0,0,''),(16,'Acis','79409694183','1fd9f8adda80690456c26eba54a8bfa8','zxcvbnm12','Артем','Климов','','','','',1550166349,1551409087,1551409087,0,'','Еуууы',1,0.00,0,0,''),(17,'id17','78149433620','ef72fe9d9781e169b2bb64443acfedd2','484533','Hacked','Good','','','','',1550251282,0,0,0,'','',1,0.00,0,0,''),(18,'id18','380675487013','561d95a20756246ef0de710ccbb13f4b','580342','Джавид','Азизов','','','','',1551089215,0,0,0,'','',1,0.00,0,0,''),(19,'id19','89041059708','3f754e2fb909aefb9462033afdf4a17f','91370','Денис','Агустинов','','','','',1551093754,1551094289,1551094289,0,'','Это только начало!',1,0.00,0,0,''),(20,'id20','380734565255','630ae34dea33f116bde9fb3825754329','109588','Hxhxhxh','Bxbxbxbxb','','','','',1551200669,0,0,0,'','',1,0.00,0,0,''),(21,'id21','89605214009','e08d0befd635b0f707b36a9f43b94b39','794612','Дмитрий','Хлыст','','','','',1551645139,1554297328,1554297328,0,'','',1,0.00,0,0,'');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_gifts`
--
DROP TABLE IF EXISTS `user_gifts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_gifts` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(12) NOT NULL,
`gift_id` int(12) NOT NULL,
`who_id` int(12) NOT NULL,
`user_id` int(12) NOT NULL,
`message` char(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_gifts`
--
LOCK TABLES `user_gifts` WRITE;
/*!40000 ALTER TABLE `user_gifts` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_gifts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `worldkassa`
--
DROP TABLE IF EXISTS `worldkassa`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `worldkassa` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID платежа (Внутренний ID)',
`user_id` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
`pay_id` int(11) unsigned NOT NULL COMMENT 'ID платежа в Worldkassa',
`time` int(11) unsigned NOT NULL COMMENT 'Время инициализации платежа',
`pay_time` int(11) unsigned DEFAULT '0' COMMENT 'Время оплаты',
`amount` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Статистика платежей через WorldKassa';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `worldkassa`
--
LOCK TABLES `worldkassa` WRITE;
/*!40000 ALTER TABLE `worldkassa` DISABLE KEYS */;
INSERT INTO `worldkassa` VALUES (1,1,978542,1549632353,0,10.00);
/*!40000 ALTER TABLE `worldkassa` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-05-30 1:07:37