dummy/db/structure.sql
-- MySQL dump 10.13 Distrib 5.6.14, for osx10.7 (x86_64)
--
-- Host: localhost Database: voluntary_scholarship_development
-- ------------------------------------------------------
-- Server version 5.6.14
/*!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 `areas`
--
DROP TABLE IF EXISTS `areas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `areas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ancestry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ancestry_depth` int(11) DEFAULT '0',
`position` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`users_count` int(11) DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_areas_on_slug` (`slug`),
UNIQUE KEY `index_areas_on_name` (`name`),
KEY `index_areas_on_ancestry` (`ancestry`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `areas_projects`
--
DROP TABLE IF EXISTS `areas_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `areas_projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area_id` int(11) DEFAULT NULL,
`project_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_areas_projects_on_area_id_and_project_id` (`area_id`,`project_id`),
KEY `index_areas_projects_on_area_id` (`area_id`),
KEY `index_areas_projects_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `areas_users`
--
DROP TABLE IF EXISTS `areas_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `areas_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_areas_users_on_area_id_and_user_id` (`area_id`,`user_id`),
KEY `index_areas_users_on_area_id` (`area_id`),
KEY `index_areas_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `argument_topics`
--
DROP TABLE IF EXISTS `argument_topics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `argument_topics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_argument_topics_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `arguments`
--
DROP TABLE IF EXISTS `arguments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arguments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`argumentable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`argumentable_id` int(11) DEFAULT NULL,
`topic_id` int(11) DEFAULT NULL,
`value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `arguments_index_on_argumentable_topic` (`topic_id`,`argumentable_id`,`argumentable_type`),
KEY `arguments_index_on_argumentable` (`argumentable_id`,`argumentable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `comments`
--
DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`commentable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`commentable_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`ancestry` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ancestry_depth` int(11) DEFAULT '0',
`position` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_comments_on_commentable_id_and_commentable_type` (`commentable_id`,`commentable_type`),
KEY `index_comments_on_ancestry` (`ancestry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `friendly_id_slugs`
--
DROP TABLE IF EXISTS `friendly_id_slugs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `friendly_id_slugs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sluggable_id` int(11) NOT NULL,
`sluggable_type` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_friendly_id_slugs_on_slug_and_sluggable_type` (`slug`,`sluggable_type`),
KEY `index_friendly_id_slugs_on_sluggable_id` (`sluggable_id`),
KEY `index_friendly_id_slugs_on_sluggable_type` (`sluggable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `likes`
--
DROP TABLE IF EXISTS `likes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`positive` tinyint(1) DEFAULT '1',
`target_id` int(11) DEFAULT NULL,
`target_type` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_likes_on_target_id_and_user_id_and_target_type` (`target_id`,`user_id`,`target_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `list_items`
--
DROP TABLE IF EXISTS `list_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `list_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`list_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`thing_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`thing_id` int(11) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `lists`
--
DROP TABLE IF EXISTS `lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lists` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_lists_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mongo_db_documents`
--
DROP TABLE IF EXISTS `mongo_db_documents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mongo_db_documents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mongo_db_object_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`klass_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_mongo_db_documents_on_mongo_db_object_id_and_klass_name` (`mongo_db_object_id`,`klass_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `organizations`
--
DROP TABLE IF EXISTS `organizations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `organizations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_organizations_on_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `professions`
--
DROP TABLE IF EXISTS `professions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `professions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `projects`
--
DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`product_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`organization_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_projects_on_slug` (`slug`),
KEY `index_projects_on_user_id` (`user_id`),
KEY `index_projects_on_product_id` (`product_id`),
KEY `index_projects_on_organization_id` (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `projects_users`
--
DROP TABLE IF EXISTS `projects_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`project_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_projects_users_on_project_id_and_user_id` (`project_id`,`user_id`) USING BTREE,
KEY `index_projects_users_on_project_id` (`project_id`),
KEY `index_projects_users_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `schema_migrations`
--
DROP TABLE IF EXISTS `schema_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schema_migrations` (
`version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scholarship_iteration_participations`
--
DROP TABLE IF EXISTS `scholarship_iteration_participations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scholarship_iteration_participations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iteration_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`roles` int(11) DEFAULT NULL,
`team_id` int(11) DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_scholarship_iteration_participations_on_iteration_user` (`iteration_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scholarship_iterations`
--
DROP TABLE IF EXISTS `scholarship_iterations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scholarship_iterations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`program_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`from` datetime DEFAULT NULL,
`to` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_scholarship_iterations_on_program_id_and_from_and_to` (`program_id`,`from`,`to`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scholarship_programs`
--
DROP TABLE IF EXISTS `scholarship_programs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scholarship_programs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`organization_id` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_scholarship_programs_on_organization_id_and_name` (`organization_id`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scholarship_team_memberships`
--
DROP TABLE IF EXISTS `scholarship_team_memberships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scholarship_team_memberships` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`team_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`roles` int(11) DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_scholarship_team_memberships_on_team_id_and_user_id` (`team_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scholarship_teams`
--
DROP TABLE IF EXISTS `scholarship_teams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scholarship_teams` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`kind` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`github_handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`twitter_handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_scholarship_teams_on_name` (`name`),
UNIQUE KEY `index_scholarship_teams_on_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `things`
--
DROP TABLE IF EXISTS `things`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `things` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_things_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rpx_identifier` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`text` text COLLATE utf8_unicode_ci,
`serialized_private_key` text COLLATE utf8_unicode_ci,
`language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`salutation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`marital_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`family_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_of_birth` date DEFAULT NULL,
`place_of_birth` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`citizenship` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
`encrypted_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`reset_password_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`reset_password_sent_at` datetime DEFAULT NULL,
`remember_created_at` datetime DEFAULT NULL,
`sign_in_count` int(11) DEFAULT '0',
`current_sign_in_at` datetime DEFAULT NULL,
`last_sign_in_at` datetime DEFAULT NULL,
`current_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`confirmation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`confirmed_at` datetime DEFAULT NULL,
`confirmation_sent_at` datetime DEFAULT NULL,
`unconfirmed_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`failed_attempts` int(11) DEFAULT '0',
`unlock_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`locked_at` datetime DEFAULT NULL,
`authentication_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password_salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`interface_language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`employment_relationship` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`profession_id` int(11) DEFAULT NULL,
`foreign_languages` text COLLATE utf8_unicode_ci,
`provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastfm_user_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`api_key` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`roles` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_email` (`email`),
UNIQUE KEY `index_users_on_slug` (`slug`),
UNIQUE KEY `index_users_on_name` (`name`),
UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`),
KEY `index_users_on_profession_id` (`profession_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2015-08-19 17:27:22
INSERT INTO schema_migrations (version) VALUES ('20140306191343');
INSERT INTO schema_migrations (version) VALUES ('20140306191344');
INSERT INTO schema_migrations (version) VALUES ('20140306191345');
INSERT INTO schema_migrations (version) VALUES ('20140306191346');
INSERT INTO schema_migrations (version) VALUES ('20140306191347');
INSERT INTO schema_migrations (version) VALUES ('20140306191348');
INSERT INTO schema_migrations (version) VALUES ('20140306191349');
INSERT INTO schema_migrations (version) VALUES ('20140306191350');
INSERT INTO schema_migrations (version) VALUES ('20140306191351');
INSERT INTO schema_migrations (version) VALUES ('20140306191352');
INSERT INTO schema_migrations (version) VALUES ('20140306191353');
INSERT INTO schema_migrations (version) VALUES ('20140306191354');
INSERT INTO schema_migrations (version) VALUES ('20140306191355');
INSERT INTO schema_migrations (version) VALUES ('20140306191356');
INSERT INTO schema_migrations (version) VALUES ('20140307081024');
INSERT INTO schema_migrations (version) VALUES ('20140307160706');
INSERT INTO schema_migrations (version) VALUES ('20140310182713');
INSERT INTO schema_migrations (version) VALUES ('20140310203823');
INSERT INTO schema_migrations (version) VALUES ('20140311174333');
INSERT INTO schema_migrations (version) VALUES ('20140314155742');
INSERT INTO schema_migrations (version) VALUES ('20150412125403');
INSERT INTO schema_migrations (version) VALUES ('20150412125404');
INSERT INTO schema_migrations (version) VALUES ('20150412125405');
INSERT INTO schema_migrations (version) VALUES ('20150819152542');
INSERT INTO schema_migrations (version) VALUES ('20150819152543');
INSERT INTO schema_migrations (version) VALUES ('20150819152544');
INSERT INTO schema_migrations (version) VALUES ('20150819152545');