Skip to content

Instantly share code, notes, and snippets.

@anthonymoralez

anthonymoralez/mysqldump.gitlabhq.sql

Last active December 14, 2015 02:39
Show Gist options
  • Save anthonymoralez/5015384 to your computer and use it in GitHub Desktop.
Save anthonymoralez/5015384 to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump of gitlabhq database after db:migrate
Raw
mysqldump.gitlabhq.sql
-- MySQL dump 10.11
--
-- Host: localhost Database: gitlabhq_development
-- ------------------------------------------------------
-- Server version 5.0.95
/*!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 `events`
--
DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
`id` int(11) NOT NULL auto_increment,
`target_type` varchar(255) collate utf8_unicode_ci default NULL,
`target_id` int(11) default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`data` text collate utf8_unicode_ci,
`project_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`action` int(11) default NULL,
`author_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_events_on_project_id` (`project_id`),
KEY `index_events_on_author_id` (`author_id`),
KEY `index_events_on_action` (`action`),
KEY `index_events_on_target_type` (`target_type`),
KEY `index_events_on_created_at` (`created_at`),
KEY `index_events_on_target_id` (`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `events`
--
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `issues`
--
DROP TABLE IF EXISTS `issues`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `issues` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`assignee_id` int(11) default NULL,
`author_id` int(11) default NULL,
`project_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`position` int(11) default '0',
`branch_name` varchar(255) collate utf8_unicode_ci default NULL,
`description` text collate utf8_unicode_ci,
`milestone_id` int(11) default NULL,
`state` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `index_issues_on_project_id` (`project_id`),
KEY `index_issues_on_assignee_id` (`assignee_id`),
KEY `index_issues_on_milestone_id` (`milestone_id`),
KEY `index_issues_on_author_id` (`author_id`),
KEY `index_issues_on_created_at` (`created_at`),
KEY `index_issues_on_title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `issues`
--
LOCK TABLES `issues` WRITE;
/*!40000 ALTER TABLE `issues` DISABLE KEYS */;
/*!40000 ALTER TABLE `issues` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `keys`
--
DROP TABLE IF EXISTS `keys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keys` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`key` text collate utf8_unicode_ci,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`identifier` varchar(255) collate utf8_unicode_ci default NULL,
`project_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_keys_on_user_id` (`user_id`),
KEY `index_keys_on_identifier` (`identifier`),
KEY `index_keys_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keys`
--
LOCK TABLES `keys` WRITE;
/*!40000 ALTER TABLE `keys` DISABLE KEYS */;
/*!40000 ALTER TABLE `keys` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `merge_requests`
--
DROP TABLE IF EXISTS `merge_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `merge_requests` (
`id` int(11) NOT NULL auto_increment,
`target_branch` varchar(255) collate utf8_unicode_ci NOT NULL,
`source_branch` varchar(255) collate utf8_unicode_ci NOT NULL,
`project_id` int(11) NOT NULL,
`author_id` int(11) default NULL,
`assignee_id` int(11) default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`st_commits` longtext collate utf8_unicode_ci,
`st_diffs` longtext collate utf8_unicode_ci,
`merge_status` int(11) NOT NULL default '1',
`milestone_id` int(11) default NULL,
`state` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `index_merge_requests_on_project_id` (`project_id`),
KEY `index_merge_requests_on_assignee_id` (`assignee_id`),
KEY `index_merge_requests_on_milestone_id` (`milestone_id`),
KEY `index_merge_requests_on_author_id` (`author_id`),
KEY `index_merge_requests_on_created_at` (`created_at`),
KEY `index_merge_requests_on_source_branch` (`source_branch`),
KEY `index_merge_requests_on_target_branch` (`target_branch`),
KEY `index_merge_requests_on_title` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `merge_requests`
--
LOCK TABLES `merge_requests` WRITE;
/*!40000 ALTER TABLE `merge_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `merge_requests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `milestones`
--
DROP TABLE IF EXISTS `milestones`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `milestones` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate utf8_unicode_ci NOT NULL,
`project_id` int(11) NOT NULL,
`description` text collate utf8_unicode_ci,
`due_date` date default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`state` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `index_milestones_on_due_date` (`due_date`),
KEY `index_milestones_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `milestones`
--
LOCK TABLES `milestones` WRITE;
/*!40000 ALTER TABLE `milestones` DISABLE KEYS */;
/*!40000 ALTER TABLE `milestones` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `namespaces`
--
DROP TABLE IF EXISTS `namespaces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `namespaces` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`path` varchar(255) collate utf8_unicode_ci NOT NULL,
`owner_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `index_namespaces_on_owner_id` (`owner_id`),
KEY `index_namespaces_on_name` (`name`),
KEY `index_namespaces_on_path` (`path`),
KEY `index_namespaces_on_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `namespaces`
--
LOCK TABLES `namespaces` WRITE;
/*!40000 ALTER TABLE `namespaces` DISABLE KEYS */;
/*!40000 ALTER TABLE `namespaces` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `notes`
--
DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notes` (
`id` int(11) NOT NULL auto_increment,
`note` text collate utf8_unicode_ci,
`noteable_type` varchar(255) collate utf8_unicode_ci default NULL,
`author_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`project_id` int(11) default NULL,
`attachment` varchar(255) collate utf8_unicode_ci default NULL,
`line_code` varchar(255) collate utf8_unicode_ci default NULL,
`commit_id` varchar(255) collate utf8_unicode_ci default NULL,
`noteable_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_notes_on_noteable_type` (`noteable_type`),
KEY `index_notes_on_project_id` (`project_id`),
KEY `index_notes_on_created_at` (`created_at`),
KEY `index_notes_on_commit_id` (`commit_id`),
KEY `index_notes_on_project_id_and_noteable_type` (`project_id`,`noteable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `notes`
--
LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`path` varchar(255) collate utf8_unicode_ci default NULL,
`description` text collate utf8_unicode_ci,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`creator_id` int(11) default NULL,
`default_branch` varchar(255) collate utf8_unicode_ci default NULL,
`issues_enabled` tinyint(1) NOT NULL default '1',
`wall_enabled` tinyint(1) NOT NULL default '1',
`merge_requests_enabled` tinyint(1) NOT NULL default '1',
`wiki_enabled` tinyint(1) NOT NULL default '1',
`namespace_id` int(11) default NULL,
`public` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index_projects_on_namespace_id` (`namespace_id`),
KEY `index_projects_on_owner_id` (`creator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects`
--
LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `protected_branches`
--
DROP TABLE IF EXISTS `protected_branches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `protected_branches` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime 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 `protected_branches`
--
LOCK TABLES `protected_branches` WRITE;
/*!40000 ALTER TABLE `protected_branches` DISABLE KEYS */;
/*!40000 ALTER TABLE `protected_branches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- 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 */;
--
-- Dumping data for table `schema_migrations`
--
LOCK TABLES `schema_migrations` WRITE;
/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
INSERT INTO `schema_migrations` VALUES ('20110913200833'),('20110913204141'),('20110914221600'),('20110915205627'),('20110915213352'),('20110916123731'),('20110916162511'),('20110917212932'),('20110921192501'),('20110922110156'),('20110923211333'),('20110924214549'),('20110924215658'),('20110926082616'),('20110927130352'),('20110928140106'),('20110928142747'),('20110928161328'),('20111005193700'),('20111009101738'),('20111009110913'),('20111009111204'),('20111015154310'),('20111016183422'),('20111016193417'),('20111016195506'),('20111019212429'),('20111021101550'),('20111025134235'),('20111027051828'),('20111027142641'),('20111027152724'),('20111101222453'),('20111111093150'),('20111115063954'),('20111124115339'),('20111127155345'),('20111206213842'),('20111206222316'),('20111207211728'),('20111214091851'),('20111220190817'),('20111231111825'),('20120110180749'),('20120119202326'),('20120121122616'),('20120206170141'),('20120215182305'),('20120216085842'),('20120216215008'),('20120219130957'),('20120219140810'),('20120219193300'),('20120228130210'),('20120228134252'),('20120301185805'),('20120307095918'),('20120315111711'),('20120315132931'),('20120317095543'),('20120323221339'),('20120329170745'),('20120405211750'),('20120408180246'),('20120408181910'),('20120413135904'),('20120627145613'),('20120706065612'),('20120712080407'),('20120729131232'),('20120905043334'),('20121002150926'),('20121002151033'),('20121009205010'),('20121026114600'),('20121119170638'),('20121120051432'),('20121120103700'),('20121120113838'),('20121122145155'),('20121122150932'),('20121123104937'),('20121123164910'),('20121203154450'),('20121203160507'),('20121205201726'),('20121218164840'),('20121219095402'),('20121219183753'),('20121220064104'),('20121220064453'),('20130102143055'),('20130110172407'),('20130125090214'),('20130131070232'),('20130214154045'),('20130218140952'),('20130218141038'),('20130218141117'),('20130218141258'),('20130218141327'),('20130218141344'),('20130218141444'),('20130218141507'),('20130218141536'),('20130218141554');
/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `services`
--
DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `services` (
`id` int(11) NOT NULL auto_increment,
`type` varchar(255) collate utf8_unicode_ci default NULL,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`token` varchar(255) collate utf8_unicode_ci default NULL,
`project_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`active` tinyint(1) NOT NULL default '0',
`project_url` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `index_services_on_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `services`
--
LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `snippets`
--
DROP TABLE IF EXISTS `snippets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `snippets` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`content` text collate utf8_unicode_ci,
`author_id` int(11) NOT NULL,
`project_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`file_name` varchar(255) collate utf8_unicode_ci default NULL,
`expires_at` datetime default NULL,
PRIMARY KEY (`id`),
KEY `index_snippets_on_project_id` (`project_id`),
KEY `index_snippets_on_created_at` (`created_at`),
KEY `index_snippets_on_expires_at` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `snippets`
--
LOCK TABLES `snippets` WRITE;
/*!40000 ALTER TABLE `snippets` DISABLE KEYS */;
/*!40000 ALTER TABLE `snippets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `taggings`
--
DROP TABLE IF EXISTS `taggings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taggings` (
`id` int(11) NOT NULL auto_increment,
`tag_id` int(11) default NULL,
`taggable_id` int(11) default NULL,
`taggable_type` varchar(255) collate utf8_unicode_ci default NULL,
`tagger_id` int(11) default NULL,
`tagger_type` varchar(255) collate utf8_unicode_ci default NULL,
`context` varchar(255) collate utf8_unicode_ci default NULL,
`created_at` datetime default NULL,
PRIMARY KEY (`id`),
KEY `index_taggings_on_tag_id` (`tag_id`),
KEY `index_taggings_on_taggable_id_and_taggable_type_and_context` (`taggable_id`,`taggable_type`,`context`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taggings`
--
LOCK TABLES `taggings` WRITE;
/*!40000 ALTER TABLE `taggings` DISABLE KEYS */;
/*!40000 ALTER TABLE `taggings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tags`
--
DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci default 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 `tags`
--
LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_team_project_relationships`
--
DROP TABLE IF EXISTS `user_team_project_relationships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_team_project_relationships` (
`id` int(11) NOT NULL auto_increment,
`project_id` int(11) default NULL,
`user_team_id` int(11) default NULL,
`greatest_access` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime 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 `user_team_project_relationships`
--
LOCK TABLES `user_team_project_relationships` WRITE;
/*!40000 ALTER TABLE `user_team_project_relationships` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_team_project_relationships` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_team_user_relationships`
--
DROP TABLE IF EXISTS `user_team_user_relationships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_team_user_relationships` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) default NULL,
`user_team_id` int(11) default NULL,
`group_admin` tinyint(1) default NULL,
`permission` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime 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 `user_team_user_relationships`
--
LOCK TABLES `user_team_user_relationships` WRITE;
/*!40000 ALTER TABLE `user_team_user_relationships` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_team_user_relationships` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_teams`
--
DROP TABLE IF EXISTS `user_teams`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_teams` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`path` varchar(255) collate utf8_unicode_ci default NULL,
`owner_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime 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 `user_teams`
--
LOCK TABLES `user_teams` WRITE;
/*!40000 ALTER TABLE `user_teams` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_teams` 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,
`email` varchar(255) collate utf8_unicode_ci NOT NULL 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,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`name` varchar(255) collate utf8_unicode_ci default NULL,
`admin` tinyint(1) NOT NULL default '0',
`projects_limit` int(11) default '10',
`skype` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`linkedin` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`twitter` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`authentication_token` varchar(255) collate utf8_unicode_ci default NULL,
`dark_scheme` tinyint(1) NOT NULL default '0',
`theme_id` int(11) NOT NULL default '1',
`bio` varchar(255) collate utf8_unicode_ci default NULL,
`blocked` tinyint(1) NOT NULL default '0',
`failed_attempts` int(11) default '0',
`locked_at` datetime default NULL,
`extern_uid` varchar(255) collate utf8_unicode_ci default NULL,
`provider` varchar(255) collate utf8_unicode_ci default NULL,
`username` varchar(255) collate utf8_unicode_ci default NULL,
`can_create_group` tinyint(1) NOT NULL default '1',
`can_create_team` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_email` (`email`),
UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`),
UNIQUE KEY `index_users_on_extern_uid_and_provider` (`extern_uid`,`provider`),
KEY `index_users_on_admin` (`admin`),
KEY `index_users_on_blocked` (`blocked`),
KEY `index_users_on_name` (`name`),
KEY `index_users_on_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_projects`
--
DROP TABLE IF EXISTS `users_projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_projects` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`project_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`project_access` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index_users_projects_on_project_id` (`project_id`),
KEY `index_users_projects_on_project_access` (`project_access`),
KEY `index_users_projects_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_projects`
--
LOCK TABLES `users_projects` WRITE;
/*!40000 ALTER TABLE `users_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `web_hooks`
--
DROP TABLE IF EXISTS `web_hooks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_hooks` (
`id` int(11) NOT NULL auto_increment,
`url` varchar(255) collate utf8_unicode_ci default NULL,
`project_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`type` varchar(255) collate utf8_unicode_ci default 'ProjectHook',
`service_id` int(11) default 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 `web_hooks`
--
LOCK TABLES `web_hooks` WRITE;
/*!40000 ALTER TABLE `web_hooks` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_hooks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wikis`
--
DROP TABLE IF EXISTS `wikis`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wikis` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate utf8_unicode_ci default NULL,
`content` text collate utf8_unicode_ci,
`project_id` int(11) default NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`slug` varchar(255) collate utf8_unicode_ci default NULL,
`user_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `index_wikis_on_project_id` (`project_id`),
KEY `index_wikis_on_slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wikis`
--
LOCK TABLES `wikis` WRITE;
/*!40000 ALTER TABLE `wikis` DISABLE KEYS */;
/*!40000 ALTER TABLE `wikis` 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-22 9:57:03
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment