Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as Plain Text by yourname ( 13 years ago )
-- MySQL dump 10.13 Distrib 5.5.30, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: keyok
-- ------------------------------------------------------
-- Server version 5.5.30-1~dotdeb.0
/*!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 `keywords__folders`
--
DROP TABLE IF EXISTS `keywords__folders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keywords__folders` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`color` tinyint(4) NOT NULL DEFAULT '0',
`type` tinyint(4) NOT NULL DEFAULT '0',
`parent_id` int(11) unsigned DEFAULT NULL,
`hidden` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `fk_keywords__folders_parent` (`parent_id`),
CONSTRAINT `fk_keywords__folders_parent` FOREIGN KEY (`parent_id`) REFERENCES `keywords__folders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keywords__folders`
--
LOCK TABLES `keywords__folders` WRITE;
/*!40000 ALTER TABLE `keywords__folders` DISABLE KEYS */;
INSERT INTO `keywords__folders` VALUES (7,5,'favourites',0,1,NULL,0),(8,5,'strike_out',0,2,NULL,0),(9,5,'trash',0,3,NULL,0),(10,5,'папка 1',4,0,NULL,0),(11,5,'папка 2',7,0,NULL,0),(12,5,'папка 3',0,0,NULL,0);
/*!40000 ALTER TABLE `keywords__folders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `keywords__folders_keywords`
--
DROP TABLE IF EXISTS `keywords__folders_keywords`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keywords__folders_keywords` (
`keyword_id` int(11) NOT NULL,
`folder_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`keyword_id`,`folder_id`),
KEY `fk_keywords__folders_keywords_folder` (`folder_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keywords__folders_keywords`
--
LOCK TABLES `keywords__folders_keywords` WRITE;
/*!40000 ALTER TABLE `keywords__folders_keywords` DISABLE KEYS */;
/*!40000 ALTER TABLE `keywords__folders_keywords` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `profiles`
--
DROP TABLE IF EXISTS `profiles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`middle_name` varchar(255) NOT NULL DEFAULT '',
`career` int(1) NOT NULL DEFAULT '0',
`avatar` varchar(255) NOT NULL DEFAULT '',
`phone` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`user_id`),
CONSTRAINT `user_profile_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `profiles`
--
LOCK TABLES `profiles` WRITE;
/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
INSERT INTO `profiles` VALUES (1,'Administrator','Admin','',0,'assets/220px-Yorkelatitude.JPG','+7 (905) 363-53-73'),(2,'Никита','Джигруда','',0,'assets/dR-6rCPqQ16D-SmOjHl8/1351605112_no_tidehunter.jpg',''),(3,'Mira','Smurkov','',0,'assets/KCRvuso_mmesHGDv-jN/82b4_a484.jpg',''),(4,'Nikita','Hg2','',0,'',''),(5,'Алексей','Киреев','',0,'','');
/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `profiles_fields`
--
DROP TABLE IF EXISTS `profiles_fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles_fields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`varname` varchar(50) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`field_type` varchar(50) NOT NULL DEFAULT '',
`field_size` int(3) NOT NULL DEFAULT '0',
`field_size_min` int(3) NOT NULL DEFAULT '0',
`required` int(1) NOT NULL DEFAULT '0',
`match` varchar(255) NOT NULL DEFAULT '',
`range` varchar(255) NOT NULL DEFAULT '',
`error_message` varchar(255) NOT NULL DEFAULT '',
`other_validator` text,
`default` varchar(255) NOT NULL DEFAULT '',
`widget` varchar(255) NOT NULL DEFAULT '',
`widgetparams` text,
`position` int(3) NOT NULL DEFAULT '0',
`visible` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `profiles_fields`
--
LOCK TABLES `profiles_fields` WRITE;
/*!40000 ALTER TABLE `profiles_fields` DISABLE KEYS */;
INSERT INTO `profiles_fields` VALUES (1,'first_name','First Name','VARCHAR',255,3,2,'','','Incorrect First Name (length between 3 and 50 characters).','','','','',2,3),(2,'last_name','Last Name','VARCHAR',255,3,2,'','','Incorrect Last Name (length between 3 and 50 characters).','','','','',1,3),(3,'middle_name','Отчество','VARCHAR',255,0,2,'','','','','','','',3,3),(5,'career','Род деятельности','INTEGER',1,0,0,'','0==---;1==Сеошник;2==Блоггер;3==Автор','','','0','','',4,3),(6,'avatar','Аватар','VARCHAR',255,0,0,'','','','','','UWavatar','',5,3),(7,'phone','Номер телефона','VARCHAR',255,0,0,'','','','','','','',6,3);
/*!40000 ALTER TABLE `profiles_fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `statistic__user_actions`
--
DROP TABLE IF EXISTS `statistic__user_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statistic__user_actions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`action_id` tinyint(4) NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `fk_statistic__user_actions_keyword` (`keyword_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `statistic__user_actions`
--
LOCK TABLES `statistic__user_actions` WRITE;
/*!40000 ALTER TABLE `statistic__user_actions` DISABLE KEYS */;
/*!40000 ALTER TABLE `statistic__user_actions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `statistic__user_search`
--
DROP TABLE IF EXISTS `statistic__user_search`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statistic__user_search` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`keyword_id` int(11) NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `fk_statistic__user_search_keyword` (`keyword_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `statistic__user_search`
--
LOCK TABLES `statistic__user_search` WRITE;
/*!40000 ALTER TABLE `statistic__user_search` DISABLE KEYS */;
/*!40000 ALTER TABLE `statistic__user_search` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storage`
--
DROP TABLE IF EXISTS `storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storage` (
`key` varchar(255) DEFAULT NULL,
`value` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storage`
--
LOCK TABLES `storage` WRITE;
/*!40000 ALTER TABLE `storage` DISABLE KEYS */;
INSERT INTO `storage` VALUES ('1620d1f14f602299fda75dddd649758a','\"{\\\"0\\\":1359703508,\\\"1\\\":\\\"\\\\\\/home\\\\\\/solivager\\\\\\/work\\\\\\/key-ok\\\\\\/src\\\\\\/assets\\\\\\/32a9f73f793b9feeb542eb0a0e287442.JPG\\\",\\\"resize\\\":{\\\"width\\\":100,\\\"height\\\":133,\\\"master\\\":2},\\\"crop\\\":{\\\"width\\\":100,\\\"height\\\":100,\\\"top\\\":\\\"center\\\",\\\"left\\\":\\\"center\\\"}}\"'),('6c5aff76409c526eeb4ebd487c8d8e65','\"{\\\"0\\\":1359706940,\\\"1\\\":\\\"\\\\\\/home\\\\\\/solivager\\\\\\/work\\\\\\/key-ok\\\\\\/src\\\\\\/assets\\\\\\/220px-Yorkelatitude.JPG\\\",\\\"resize\\\":{\\\"width\\\":100,\\\"height\\\":116,\\\"master\\\":2},\\\"crop\\\":{\\\"width\\\":100,\\\"height\\\":100,\\\"top\\\":\\\"center\\\",\\\"left\\\":\\\"center\\\"}}\"'),('e6e2a3967d1e82bc9e1f764ef3348cdf','\"{\\\"0\\\":1361995796,\\\"1\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/key-ok.com\\\\\\/deploy\\\\\\/releases\\\\\\/01\\\\\\/frontend\\\\\\/www\\\\\\/assets\\\\\\/dR-6rCPqQ16D-SmOjHl8\\\\\\/1351605112_no_tidehunter.jpg\\\",\\\"resize\\\":{\\\"width\\\":331,\\\"height\\\":207,\\\"master\\\":2},\\\"crop\\\":{\\\"width\\\":205,\\\"height\\\":207,\\\"top\\\":\\\"center\\\",\\\"left\\\":\\\"center\\\"}}\"'),('91583dfd401847cefc03c914b26e90a7','\"{\\\"0\\\":1361998143,\\\"1\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/key-ok.com\\\\\\/deploy\\\\\\/releases\\\\\\/01\\\\\\/frontend\\\\\\/www\\\\\\/assets\\\\\\/zj-4CEw02FGwm-n_wjf\\\\\\/82b4_a484.jpg\\\",\\\"resize\\\":{\\\"width\\\":207,\\\"height\\\":207,\\\"master\\\":2},\\\"crop\\\":{\\\"width\\\":205,\\\"height\\\":207,\\\"top\\\":\\\"center\\\",\\\"left\\\":\\\"center\\\"}}\"'),('5ec647d36ad43cdf14046f24cfe59627','\"{\\\"0\\\":1361998171,\\\"1\\\":\\\"\\\\\\/var\\\\\\/www\\\\\\/key-ok.com\\\\\\/deploy\\\\\\/releases\\\\\\/01\\\\\\/frontend\\\\\\/www\\\\\\/assets\\\\\\/KCRvuso_mmesHGDv-jN\\\\\\/82b4_a484.jpg\\\",\\\"resize\\\":{\\\"width\\\":207,\\\"height\\\":207,\\\"master\\\":2},\\\"crop\\\":{\\\"width\\\":205,\\\"height\\\":207,\\\"top\\\":\\\"center\\\",\\\"left\\\":\\\"center\\\"}}\"');
/*!40000 ALTER TABLE `storage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_migration`
--
DROP TABLE IF EXISTS `tbl_migration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_migration` (
`version` varchar(255) NOT NULL,
`apply_time` int(11) DEFAULT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_migration`
--
LOCK TABLES `tbl_migration` WRITE;
/*!40000 ALTER TABLE `tbl_migration` DISABLE KEYS */;
INSERT INTO `tbl_migration` VALUES ('m000000_000000_base',1361994822),('m130204_102751_add_keywords_tables',1361994831),('m130215_134048_remove_blacklist',1361994831),('m130216_095702_add_parent_folders',1361994831),('m130220_143623_password_ends',1361994831),('m130227_052808_social_services',1361994831),('m130227_095054_add_folder_hidden',1362048856),('m130227_191525_sync_profiles',1361994831);
/*!40000 ALTER TABLE `tbl_migration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user__social_services`
--
DROP TABLE IF EXISTS `user__social_services`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user__social_services` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`service` tinyint(3) unsigned NOT NULL,
`user_id` int(11) NOT NULL,
`service_id` varchar(255) NOT NULL,
`service_name` varchar(255) NOT NULL,
`service_url` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
CONSTRAINT `user__social_services_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user__social_services`
--
LOCK TABLES `user__social_services` WRITE;
/*!40000 ALTER TABLE `user__social_services` DISABLE KEYS */;
/*!40000 ALTER TABLE `user__social_services` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL DEFAULT '',
`password` varchar(128) NOT NULL DEFAULT '',
`email` varchar(128) NOT NULL DEFAULT '',
`activkey` varchar(128) NOT NULL DEFAULT '',
`superuser` int(1) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '0',
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastvisit_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`phone_confirmed` tinyint(1) NOT NULL,
`password_end` varchar(3) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_username` (`username`),
UNIQUE KEY `user_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'nikita','71be7c7eeb8c6ebeff32137bc5fcd0c8','[email protected]','7d9575aaad062aa0064117a00fe582f7',1,1,'2013-01-29 14:59:24','2013-02-01 10:55:46',1,''),(2,'nikita1','96e79218965eb72c92a549dd5a330112','[email protected]','ab9db56b4b26e1f8f823c2db2b9fa2ff',0,1,'2013-02-27 19:57:50','0000-00-00 00:00:00',0,'111'),(3,'seo2','96e79218965eb72c92a549dd5a330112','[email protected]','0b08ac3a3879f962c76f3492f92f3f89',0,1,'2013-02-27 20:47:42','0000-00-00 00:00:00',0,'111'),(4,'gavnar','96e79218965eb72c92a549dd5a330112','[email protected]','f28f7427388ff9a344a82f10d9e2c38d',0,1,'2013-02-28 07:06:14','0000-00-00 00:00:00',0,'111'),(5,'alexk984','96e79218965eb72c92a549dd5a330112','[email protected]','105d5cab65a352597db95be38b1515b7',0,1,'2013-02-28 09:32:54','0000-00-00 00:00:00',0,'111');
/*!40000 ALTER TABLE `users` 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 2013-02-28 13:07:45
Revise this Paste