##// END OF EJS Templates
http-proto: in case incoming requests come in as chunked stream the data to VCSServer....
http-proto: in case incoming requests come in as chunked stream the data to VCSServer. This should solve a problem of uploading large files to rhodecode. In case of git with small postBuffers GIT client streams data to the server. In such case we want to stream the data back again to vcsserver without reading it fully inside RhodeCode.

File last commit:

r1:854a839a default
r1434:59cf3775 stable
Show More
1.5.0.sql
863 lines | 64.2 KiB | text/x-sql | TransactSqlLexer
project: added all source files and assets
r1 -- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: rhodecode
-- ------------------------------------------------------
-- Server version 5.5.31-0ubuntu0.12.04.1
/*!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 `cache_invalidation`
--
DROP TABLE IF EXISTS `cache_invalidation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_invalidation` (
`cache_id` int(11) NOT NULL AUTO_INCREMENT,
`cache_key` varchar(255) DEFAULT NULL,
`cache_args` varchar(255) DEFAULT NULL,
`cache_active` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`cache_id`),
UNIQUE KEY `cache_id` (`cache_id`),
UNIQUE KEY `cache_key` (`cache_key`),
KEY `key_idx` (`cache_key`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cache_invalidation`
--
LOCK TABLES `cache_invalidation` WRITE;
/*!40000 ALTER TABLE `cache_invalidation` DISABLE KEYS */;
INSERT INTO `cache_invalidation` VALUES (1,'1RC/fakeclone','RC/fakeclone',1),(2,'1RC/muay','RC/muay',0),(3,'1RC/rc2/test2','RC/rc2/test2',1),(4,'1RC/rc2/test3','RC/rc2/test3',1),(5,'1RC/rc2/test4','RC/rc2/test4',1),(6,'1rhodecode-cli-gist','rhodecode-cli-gist',0),(7,'1RC/new','RC/new',0),(8,'1.rc_gist_store/32','.rc_gist_store/32',0),(9,'1vcs','vcs',0),(10,'1.rc_gist_store/36','.rc_gist_store/36',0),(11,'1.rc_gist_store/37','.rc_gist_store/37',0),(12,'1.rc_gist_store/39','.rc_gist_store/39',0),(13,'1remote-salt','remote-salt',1),(14,'1RC/INRC/trololo','RC/INRC/trololo',0),(15,'1quest','quest',0),(16,'1csa-hyperion','csa-hyperion',1),(17,'1rhodecode','rhodecode',0),(18,'1RC/origin-fork-fork','RC/origin-fork-fork',0),(19,'1.rc_gist_store/45','.rc_gist_store/45',0),(20,'1.rc_gist_store/44','.rc_gist_store/44',0),(21,'1.rc_gist_store/46','.rc_gist_store/46',0),(22,'1.rc_gist_store/41','.rc_gist_store/41',0),(23,'1.rc_gist_store/40','.rc_gist_store/40',0),(24,'1RC/gogo2','RC/gogo2',0),(25,'1.rc_gist_store/42','.rc_gist_store/42',0),(26,'1.rc_gist_store/49','.rc_gist_store/49',0),(27,'1.rc_gist_store/48','.rc_gist_store/48',0),(28,'1csa-collins','csa-collins',1),(29,'1.rc_gist_store/54','.rc_gist_store/54',0),(30,'1.rc_gist_store/55','.rc_gist_store/55',0),(31,'1.rc_gist_store/52','.rc_gist_store/52',0),(32,'1.rc_gist_store/53','.rc_gist_store/53',0),(33,'1.rc_gist_store/50','.rc_gist_store/50',0),(34,'1.rc_gist_store/51','.rc_gist_store/51',0),(35,'1BIG/android','BIG/android',1),(36,'1RC/gogo-fork','RC/gogo-fork',0),(37,'1RC/mygr/lol','RC/mygr/lol',0),(38,'1RC/hg-repo','RC/hg-repo',0),(39,'1RC/bin-ops','RC/bin-ops',0),(40,'1.rc_gist_store/xFvj6dFqqVK5vfsGP8PU','.rc_gist_store/xFvj6dFqqVK5vfsGP8PU',0),(41,'1rhodecode-git','rhodecode-git',1),(42,'1csa-io','csa-io',1),(43,'1RC/qweqwe-fork','RC/qweqwe-fork',0),(44,'1csa-libcloud','csa-libcloud',1),(45,'1waitress','waitress',1),(46,'1.rc_gist_store/8','.rc_gist_store/8',0),(47,'1.rc_gist_store/9','.rc_gist_store/9',0),(48,'1RC/foobar','RC/foobar',0),(49,'1.rc_gist_store/1','.rc_gist_store/1',0),(50,'1.rc_gist_store/3','.rc_gist_store/3',0),(51,'1.rc_gist_store/4','.rc_gist_store/4',0),(52,'1.rc_gist_store/5','.rc_gist_store/5',0),(53,'1.rc_gist_store/6','.rc_gist_store/6',0),(54,'1.rc_gist_store/7','.rc_gist_store/7',0),(55,'1csa-harmony','csa-harmony',1),(56,'1RC/łęcina','RC/łęcina',0),(57,'1rhodecode-extensions','rhodecode-extensions',0),(58,'1csa-prometheus','csa-prometheus',1),(59,'1RC/empty-git','RC/empty-git',1),(60,'1csa-salt-states','csa-salt-states',1),(61,'1rhodecode-premium','rhodecode-premium',0),(62,'1RC/qweqwe-fork2','RC/qweqwe-fork2',0),(63,'1RC/INRC/L2_NEW/lalalal','RC/INRC/L2_NEW/lalalal',0),(64,'1RC/INRC/L2_NEW/L3/repo_test_move','RC/INRC/L2_NEW/L3/repo_test_move',0),(65,'1RC/jap','RC/jap',1),(66,'1RC/origin','RC/origin',0),(67,'1rhodecode-cli-api','rhodecode-cli-api',0),(68,'1csa-armstrong','csa-armstrong',1),(69,'1.rc_gist_store/NAsB8cacjxnqdyZ8QUl3','.rc_gist_store/NAsB8cacjxnqdyZ8QUl3',0),(70,'1RC/lol/haha','RC/lol/haha',0),(71,'1enc-envelope','enc-envelope',0),(72,'1.rc_gist_store/43','.rc_gist_store/43',0),(73,'1RC/test','RC/test',0),(74,'1BIG/git','BIG/git',1),(75,'1RC/origin-fork','RC/origin-fork',0),(76,'1RC/trololo','RC/trololo',0),(77,'1.rc_gist_store/FLj8GunafFAVBnuTWDxU','.rc_gist_store/FLj8GunafFAVBnuTWDxU',0),(78,'1RC/ąqweqwe','RC/ąqweqwe',0),(79,'1csa-unity','csa-unity',1),(80,'1RC/vcs-git','RC/vcs-git',1),(81,'1.rc_gist_store/12','.rc_gist_store/12',0),(82,'1.rc_gist_store/13','.rc_gist_store/13',0),(83,'1.rc_gist_store/10','.rc_gist_store/10',0),(84,'1.rc_gist_store/11','.rc_gist_store/11',0),(85,'1RC/kiall-nova','RC/kiall-nova',1),(86,'1RC/rc2/test','RC/rc2/test',0),(87,'1DOCS','DOCS',1),(88,'1RC/fork-remote','RC/fork-remote',0),(89,'1RC/git-pull-test','RC/git-pull-test',1),(90,'1pyramidpypi','pyramidpypi',1),(91,'1.rc_gist_store/aQpbufbhSac6FyvVHhmS','.rc_gist_store/aQpbufbhSac6FyvVHhmS',0),(92,'1csa-aldrin','csa-aldrin',1),(93,'1.rc_gist_store/QL2GhrlKymNmrUJJy5js','.rc_gist_store/QL2GhrlKymNmrUJJy5js',0),(94,'1RC/git-test','RC/git-test',1),(95,'1salt','salt',1);
/*!40000 ALTER TABLE `cache_invalidation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `changeset_comments`
--
DROP TABLE IF EXISTS `changeset_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changeset_comments` (
`comment_id` int(11) NOT NULL AUTO_INCREMENT,
`repo_id` int(11) NOT NULL,
`revision` varchar(40) DEFAULT NULL,
`pull_request_id` int(11) DEFAULT NULL,
`line_no` varchar(10) DEFAULT NULL,
`hl_lines` varchar(512) DEFAULT NULL,
`f_path` varchar(1000) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`text` mediumtext NOT NULL,
`created_on` datetime NOT NULL,
`modified_at` datetime NOT NULL,
PRIMARY KEY (`comment_id`),
KEY `repo_id` (`repo_id`),
KEY `pull_request_id` (`pull_request_id`),
KEY `user_id` (`user_id`),
KEY `cc_revision_idx` (`revision`),
CONSTRAINT `changeset_comments_ibfk_1` FOREIGN KEY (`repo_id`) REFERENCES `repositories` (`repo_id`),
CONSTRAINT `changeset_comments_ibfk_2` FOREIGN KEY (`pull_request_id`) REFERENCES `pull_requests` (`pull_request_id`),
CONSTRAINT `changeset_comments_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `changeset_comments`
--
LOCK TABLES `changeset_comments` WRITE;
/*!40000 ALTER TABLE `changeset_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `changeset_comments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `changeset_statuses`
--
DROP TABLE IF EXISTS `changeset_statuses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changeset_statuses` (
`changeset_status_id` int(11) NOT NULL AUTO_INCREMENT,
`repo_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`revision` varchar(40) NOT NULL,
`status` varchar(128) NOT NULL,
`changeset_comment_id` int(11) DEFAULT NULL,
`modified_at` datetime NOT NULL,
`version` int(11) NOT NULL,
`pull_request_id` int(11) DEFAULT NULL,
PRIMARY KEY (`changeset_status_id`),
UNIQUE KEY `repo_id` (`repo_id`,`revision`,`version`),
KEY `user_id` (`user_id`),
KEY `changeset_comment_id` (`changeset_comment_id`),
KEY `pull_request_id` (`pull_request_id`),
KEY `cs_version_idx` (`version`),
KEY `cs_revision_idx` (`revision`),
CONSTRAINT `changeset_statuses_ibfk_1` FOREIGN KEY (`repo_id`) REFERENCES `repositories` (`repo_id`),
CONSTRAINT `changeset_statuses_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `changeset_statuses_ibfk_3` FOREIGN KEY (`changeset_comment_id`) REFERENCES `changeset_comments` (`comment_id`),
CONSTRAINT `changeset_statuses_ibfk_4` FOREIGN KEY (`pull_request_id`) REFERENCES `pull_requests` (`pull_request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `changeset_statuses`
--
LOCK TABLES `changeset_statuses` WRITE;
/*!40000 ALTER TABLE `changeset_statuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `changeset_statuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `db_migrate_version`
--
DROP TABLE IF EXISTS `db_migrate_version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_migrate_version` (
`repository_id` varchar(250) NOT NULL,
`repository_path` text,
`version` int(11) DEFAULT NULL,
PRIMARY KEY (`repository_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `db_migrate_version`
--
LOCK TABLES `db_migrate_version` WRITE;
/*!40000 ALTER TABLE `db_migrate_version` DISABLE KEYS */;
INSERT INTO `db_migrate_version` VALUES ('rhodecode_db_migrations','versions',8);
/*!40000 ALTER TABLE `db_migrate_version` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(255) NOT NULL,
`group_parent_id` int(11) DEFAULT NULL,
`group_description` varchar(10000) DEFAULT NULL,
`enable_locking` tinyint(1) NOT NULL,
PRIMARY KEY (`group_id`),
UNIQUE KEY `group_id` (`group_id`),
UNIQUE KEY `group_name_2` (`group_name`),
UNIQUE KEY `group_name` (`group_name`,`group_parent_id`),
KEY `group_parent_id` (`group_parent_id`),
CONSTRAINT `groups_ibfk_1` FOREIGN KEY (`group_parent_id`) REFERENCES `groups` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (1,'RC',NULL,'RC group',0),(2,'RC/rc2',1,'RC/rc2 group',0),(3,'.rc_gist_store',NULL,'.rc_gist_store group',0),(4,'RC/INRC',1,'RC/INRC group',0),(5,'BIG',NULL,'BIG group',0),(6,'RC/mygr',1,'RC/mygr group',0),(7,'RC/INRC/L2_NEW',4,'RC/INRC/L2_NEW group',0),(8,'RC/INRC/L2_NEW/L3',7,'RC/INRC/L2_NEW/L3 group',0),(9,'RC/lol',1,'RC/lol group',0);
/*!40000 ALTER TABLE `groups` 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` (
`notification_id` int(11) NOT NULL AUTO_INCREMENT,
`subject` varchar(512) DEFAULT NULL,
`body` mediumtext,
`created_by` int(11) DEFAULT NULL,
`created_on` datetime NOT NULL,
`type` varchar(256) DEFAULT NULL,
PRIMARY KEY (`notification_id`),
KEY `created_by` (`created_by`),
KEY `notification_type_idx` (`type`(255)),
CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) 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 */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
`permission_id` int(11) NOT NULL AUTO_INCREMENT,
`permission_name` varchar(255) DEFAULT NULL,
`permission_longname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`permission_id`),
UNIQUE KEY `permission_id` (`permission_id`),
KEY `p_perm_name_idx` (`permission_name`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissions`
--
LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'repository.none','repository.none'),(2,'repository.read','repository.read'),(3,'repository.write','repository.write'),(4,'repository.admin','repository.admin'),(5,'group.none','group.none'),(6,'group.read','group.read'),(7,'group.write','group.write'),(8,'group.admin','group.admin'),(9,'hg.admin','hg.admin'),(10,'hg.create.none','hg.create.none'),(11,'hg.create.repository','hg.create.repository'),(12,'hg.fork.none','hg.fork.none'),(13,'hg.fork.repository','hg.fork.repository'),(14,'hg.register.none','hg.register.none'),(15,'hg.register.manual_activate','hg.register.manual_activate'),(16,'hg.register.auto_activate','hg.register.auto_activate');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pull_request_reviewers`
--
DROP TABLE IF EXISTS `pull_request_reviewers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pull_request_reviewers` (
`pull_requests_reviewers_id` int(11) NOT NULL AUTO_INCREMENT,
`pull_request_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
PRIMARY KEY (`pull_requests_reviewers_id`),
KEY `pull_request_id` (`pull_request_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `pull_request_reviewers_ibfk_1` FOREIGN KEY (`pull_request_id`) REFERENCES `pull_requests` (`pull_request_id`),
CONSTRAINT `pull_request_reviewers_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pull_request_reviewers`
--
LOCK TABLES `pull_request_reviewers` WRITE;
/*!40000 ALTER TABLE `pull_request_reviewers` DISABLE KEYS */;
/*!40000 ALTER TABLE `pull_request_reviewers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pull_requests`
--
DROP TABLE IF EXISTS `pull_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pull_requests` (
`pull_request_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(256) DEFAULT NULL,
`description` text,
`status` varchar(256) NOT NULL,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`revisions` text,
`org_repo_id` int(11) NOT NULL,
`org_ref` varchar(256) NOT NULL,
`other_repo_id` int(11) NOT NULL,
`other_ref` varchar(256) NOT NULL,
PRIMARY KEY (`pull_request_id`),
KEY `user_id` (`user_id`),
KEY `org_repo_id` (`org_repo_id`),
KEY `other_repo_id` (`other_repo_id`),
CONSTRAINT `pull_requests_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `pull_requests_ibfk_2` FOREIGN KEY (`org_repo_id`) REFERENCES `repositories` (`repo_id`),
CONSTRAINT `pull_requests_ibfk_3` FOREIGN KEY (`other_repo_id`) REFERENCES `repositories` (`repo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pull_requests`
--
LOCK TABLES `pull_requests` WRITE;
/*!40000 ALTER TABLE `pull_requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `pull_requests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `repo_to_perm`
--
DROP TABLE IF EXISTS `repo_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repo_to_perm` (
`repo_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
`repository_id` int(11) NOT NULL,
PRIMARY KEY (`repo_to_perm_id`),
UNIQUE KEY `user_id` (`user_id`,`repository_id`,`permission_id`),
UNIQUE KEY `repo_to_perm_id` (`repo_to_perm_id`),
KEY `permission_id` (`permission_id`),
KEY `repository_id` (`repository_id`),
CONSTRAINT `repo_to_perm_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `repo_to_perm_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`),
CONSTRAINT `repo_to_perm_ibfk_3` FOREIGN KEY (`repository_id`) REFERENCES `repositories` (`repo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `repo_to_perm`
--
LOCK TABLES `repo_to_perm` WRITE;
/*!40000 ALTER TABLE `repo_to_perm` DISABLE KEYS */;
INSERT INTO `repo_to_perm` VALUES (1,1,2,1),(2,1,2,2),(3,1,2,3),(4,1,2,4),(5,1,2,5),(6,1,2,6),(7,1,2,7),(8,1,2,8),(9,1,2,9),(10,1,2,10),(11,1,2,11),(12,1,2,12),(13,1,2,13),(14,1,2,14),(15,1,2,15),(16,1,2,16),(17,1,2,17),(18,1,2,18),(19,1,2,19),(20,1,2,20),(21,1,2,21),(22,1,2,22),(23,1,2,23),(24,1,2,24),(25,1,2,25),(26,1,2,26),(27,1,2,27),(28,1,2,28),(29,1,2,29),(30,1,2,30),(31,1,2,31),(32,1,2,32),(33,1,2,33),(34,1,2,34),(35,1,2,35),(36,1,2,36),(37,1,2,37),(38,1,2,38),(39,1,2,39),(40,1,2,40),(41,1,2,41),(42,1,2,42),(43,1,2,43),(44,1,2,44),(45,1,2,45),(46,1,2,46),(47,1,2,47),(48,1,2,48),(49,1,2,49),(50,1,2,50),(51,1,2,51),(52,1,2,52),(53,1,2,53),(54,1,2,54),(55,1,2,55),(56,1,2,56),(57,1,2,57),(58,1,2,58),(59,1,2,59),(60,1,2,60),(61,1,2,61),(62,1,2,62),(63,1,2,63),(64,1,2,64),(65,1,2,65),(66,1,2,66),(67,1,2,67),(68,1,2,68),(69,1,2,69),(70,1,2,70),(71,1,2,71),(72,1,2,72),(73,1,2,73),(74,1,2,74),(75,1,2,75),(76,1,2,76),(77,1,2,77),(78,1,2,78),(79,1,2,79),(80,1,2,80),(81,1,2,81),(82,1,2,82),(83,1,2,83),(84,1,2,84),(85,1,2,85),(86,1,2,86),(87,1,2,87),(88,1,2,88),(89,1,2,89),(90,1,2,90),(91,1,2,91),(92,1,2,92),(93,1,2,93),(94,1,2,94),(95,1,2,95);
/*!40000 ALTER TABLE `repo_to_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `repositories`
--
DROP TABLE IF EXISTS `repositories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repositories` (
`repo_id` int(11) NOT NULL AUTO_INCREMENT,
`repo_name` varchar(255) NOT NULL,
`clone_uri` varchar(255) DEFAULT NULL,
`repo_type` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL,
`private` tinyint(1) DEFAULT NULL,
`statistics` tinyint(1) DEFAULT NULL,
`downloads` tinyint(1) DEFAULT NULL,
`description` varchar(10000) DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`updated_on` datetime DEFAULT NULL,
`landing_revision` varchar(255) NOT NULL,
`enable_locking` tinyint(1) NOT NULL,
`locked` varchar(255) DEFAULT NULL,
`fork_id` int(11) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`repo_id`),
UNIQUE KEY `repo_name` (`repo_name`),
UNIQUE KEY `repo_id` (`repo_id`),
UNIQUE KEY `repo_name_2` (`repo_name`),
KEY `user_id` (`user_id`),
KEY `fork_id` (`fork_id`),
KEY `group_id` (`group_id`),
KEY `r_repo_name_idx` (`repo_name`),
CONSTRAINT `repositories_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `repositories_ibfk_2` FOREIGN KEY (`fork_id`) REFERENCES `repositories` (`repo_id`),
CONSTRAINT `repositories_ibfk_3` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `repositories`
--
LOCK TABLES `repositories` WRITE;
/*!40000 ALTER TABLE `repositories` DISABLE KEYS */;
INSERT INTO `repositories` VALUES (1,'RC/fakeclone','http://user@vm/RC/fakeclone','git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:30','2013-05-29 14:15:30','tip',0,NULL,NULL,1),(2,'RC/muay',NULL,'hg',2,0,0,0,'RC/muay repository','2013-05-29 14:15:30','2013-05-29 14:15:30','tip',0,NULL,NULL,1),(3,'RC/rc2/test2',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:30','2013-05-29 14:15:30','tip',0,NULL,NULL,2),(4,'RC/rc2/test3',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:30','2013-05-29 14:15:30','tip',0,NULL,NULL,2),(5,'RC/rc2/test4',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,2),(6,'rhodecode-cli-gist',NULL,'hg',2,0,0,0,'rhodecode-cli-gist repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(7,'RC/new',NULL,'hg',2,0,0,0,'RC/new repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,1),(8,'.rc_gist_store/32',NULL,'hg',2,0,0,0,'.rc_gist_store/32 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(9,'vcs',NULL,'hg',2,0,0,0,'vcs repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(10,'.rc_gist_store/36',NULL,'hg',2,0,0,0,'.rc_gist_store/36 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(11,'.rc_gist_store/37',NULL,'hg',2,0,0,0,'.rc_gist_store/37 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(12,'.rc_gist_store/39',NULL,'hg',2,0,0,0,'.rc_gist_store/39 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(13,'remote-salt',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(14,'RC/INRC/trololo',NULL,'hg',2,0,0,0,'RC/INRC/trololo repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,4),(15,'quest',NULL,'hg',2,0,0,0,'quest repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(16,'csa-hyperion',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(17,'rhodecode',NULL,'hg',2,0,0,0,'rhodecode repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(18,'RC/origin-fork-fork',NULL,'hg',2,0,0,0,'RC/origin-fork-fork repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,1),(19,'.rc_gist_store/45',NULL,'hg',2,0,0,0,'.rc_gist_store/45 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(20,'.rc_gist_store/44',NULL,'hg',2,0,0,0,'.rc_gist_store/44 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(21,'.rc_gist_store/46',NULL,'hg',2,0,0,0,'.rc_gist_store/46 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(22,'.rc_gist_store/41',NULL,'hg',2,0,0,0,'.rc_gist_store/41 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(23,'.rc_gist_store/40',NULL,'hg',2,0,0,0,'.rc_gist_store/40 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(24,'RC/gogo2',NULL,'hg',2,0,0,0,'RC/gogo2 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,1),(25,'.rc_gist_store/42',NULL,'hg',2,0,0,0,'.rc_gist_store/42 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(26,'.rc_gist_store/49',NULL,'hg',2,0,0,0,'.rc_gist_store/49 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(27,'.rc_gist_store/48',NULL,'hg',2,0,0,0,'.rc_gist_store/48 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(28,'csa-collins',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,NULL),(29,'.rc_gist_store/54',NULL,'hg',2,0,0,0,'.rc_gist_store/54 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(30,'.rc_gist_store/55',NULL,'hg',2,0,0,0,'.rc_gist_store/55 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(31,'.rc_gist_store/52',NULL,'hg',2,0,0,0,'.rc_gist_store/52 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(32,'.rc_gist_store/53',NULL,'hg',2,0,0,0,'.rc_gist_store/53 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(33,'.rc_gist_store/50',NULL,'hg',2,0,0,0,'.rc_gist_store/50 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(34,'.rc_gist_store/51',NULL,'hg',2,0,0,0,'.rc_gist_store/51 repository','2013-05-29 14:15:31','2013-05-29 14:15:31','tip',0,NULL,NULL,3),(35,'BIG/android',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,5),(36,'RC/gogo-fork',NULL,'hg',2,0,0,0,'RC/gogo-fork repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(37,'RC/mygr/lol',NULL,'hg',2,0,0,0,'RC/mygr/lol repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,6),(38,'RC/hg-repo',NULL,'hg',2,0,0,0,'RC/hg-repo repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(39,'RC/bin-ops',NULL,'hg',2,0,0,0,'RC/bin-ops repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(40,'.rc_gist_store/xFvj6dFqqVK5vfsGP8PU',NULL,'hg',2,0,0,0,'.rc_gist_store/xFvj6dFqqVK5vfsGP8PU repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(41,'rhodecode-git',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(42,'csa-io',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(43,'RC/qweqwe-fork',NULL,'hg',2,0,0,0,'RC/qweqwe-fork repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(44,'csa-libcloud',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(45,'waitress',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(46,'.rc_gist_store/8',NULL,'hg',2,0,0,0,'.rc_gist_store/8 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(47,'.rc_gist_store/9',NULL,'hg',2,0,0,0,'.rc_gist_store/9 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(48,'RC/foobar',NULL,'hg',2,0,0,0,'RC/foobar repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(49,'.rc_gist_store/1',NULL,'hg',2,0,0,0,'.rc_gist_store/1 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(50,'.rc_gist_store/3',NULL,'hg',2,0,0,0,'.rc_gist_store/3 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(51,'.rc_gist_store/4',NULL,'hg',2,0,0,0,'.rc_gist_store/4 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(52,'.rc_gist_store/5',NULL,'hg',2,0,0,0,'.rc_gist_store/5 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(53,'.rc_gist_store/6',NULL,'hg',2,0,0,0,'.rc_gist_store/6 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(54,'.rc_gist_store/7',NULL,'hg',2,0,0,0,'.rc_gist_store/7 repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,3),(55,'csa-harmony',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(56,'RC/łęcina',NULL,'hg',2,0,0,0,'RC/łęcina repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(57,'rhodecode-extensions',NULL,'hg',2,0,0,0,'rhodecode-extensions repository','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(58,'csa-prometheus',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,NULL),(59,'RC/empty-git',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:32','2013-05-29 14:15:32','tip',0,NULL,NULL,1),(60,'csa-salt-states',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(61,'rhodecode-premium',NULL,'hg',2,0,0,0,'rhodecode-premium repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(62,'RC/qweqwe-fork2',NULL,'hg',2,0,0,0,'RC/qweqwe-fork2 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(63,'RC/INRC/L2_NEW/lalalal',NULL,'hg',2,0,0,0,'RC/INRC/L2_NEW/lalalal repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,7),(64,'RC/INRC/L2_NEW/L3/repo_test_move',NULL,'hg',2,0,0,0,'RC/INRC/L2_NEW/L3/repo_test_move repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,8),(65,'RC/jap',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(66,'RC/origin',NULL,'hg',2,0,0,0,'RC/origin repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(67,'rhodecode-cli-api',NULL,'hg',2,0,0,0,'rhodecode-cli-api repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(68,'csa-armstrong',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(69,'.rc_gist_store/NAsB8cacjxnqdyZ8QUl3',NULL,'hg',2,0,0,0,'.rc_gist_store/NAsB8cacjxnqdyZ8QUl3 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(70,'RC/lol/haha',NULL,'hg',2,0,0,0,'RC/lol/haha repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,9),(71,'enc-envelope',NULL,'hg',2,0,0,0,'enc-envelope repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(72,'.rc_gist_store/43',NULL,'hg',2,0,0,0,'.rc_gist_store/43 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(73,'RC/test',NULL,'hg',2,0,0,0,'RC/test repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(74,'BIG/git',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,5),(75,'RC/origin-fork',NULL,'hg',2,0,0,0,'RC/origin-fork repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(76,'RC/trololo',NULL,'hg',2,0,0,0,'RC/trololo repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(77,'.rc_gist_store/FLj8GunafFAVBnuTWDxU',NULL,'hg',2,0,0,0,'.rc_gist_store/FLj8GunafFAVBnuTWDxU repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(78,'RC/ąqweqwe',NULL,'hg',2,0,0,0,'RC/ąqweqwe repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(79,'csa-unity',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,NULL),(80,'RC/vcs-git',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(81,'.rc_gist_store/12',NULL,'hg',2,0,0,0,'.rc_gist_store/12 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(82,'.rc_gist_store/13',NULL,'hg',2,0,0,0,'.rc_gist_store/13 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(83,'.rc_gist_store/10',NULL,'hg',2,0,0,0,'.rc_gist_store/10 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(84,'.rc_gist_store/11',NULL,'hg',2,0,0,0,'.rc_gist_store/11 repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,3),(85,'RC/kiall-nova',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,1),(86,'RC/rc2/test',NULL,'hg',2,0,0,0,'RC/rc2/test repository','2013-05-29 14:15:33','2013-05-29 14:15:33','tip',0,NULL,NULL,2),(87,'DOCS',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,NULL),(88,'RC/fork-remote',NULL,'hg',2,0,0,0,'RC/fork-remote repository','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,1),(89,'RC/git-pull-test',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,1),(90,'pyramidpypi',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,NULL),(91,'.rc_gist_store/aQpbufbhSac6FyvVHhmS',NULL,'hg',2,0,0,0,'.rc_gist_store/aQpbufbhSac6FyvVHhmS repository','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,3),(92,'csa-aldrin',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,NULL),(93,'.rc_gist_store/QL2GhrlKymNmrUJJy5js',NULL,'hg',2,0,0,0,'.rc_gist_store/QL2GhrlKymNmrUJJy5js repository','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,3),(94,'RC/git-test',NULL,'git',2,0,0,0,'Unnamed repository','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,1),(95,'salt',NULL,'git',2,0,0,0,'Unnamed repository; edit this file \'description\' to name the repository.\n','2013-05-29 14:15:34','2013-05-29 14:15:34','tip',0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `repositories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rhodecode_settings`
--
DROP TABLE IF EXISTS `rhodecode_settings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rhodecode_settings` (
`app_settings_id` int(11) NOT NULL AUTO_INCREMENT,
`app_settings_name` varchar(255) DEFAULT NULL,
`app_settings_value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`app_settings_id`),
UNIQUE KEY `app_settings_id` (`app_settings_id`),
UNIQUE KEY `app_settings_name` (`app_settings_name`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rhodecode_settings`
--
LOCK TABLES `rhodecode_settings` WRITE;
/*!40000 ALTER TABLE `rhodecode_settings` DISABLE KEYS */;
INSERT INTO `rhodecode_settings` VALUES (1,'realm','RhodeCode authentication'),(2,'title','RhodeCode'),(3,'ga_code',''),(4,'show_public_icon','True'),(5,'show_private_icon','True'),(6,'stylify_metatags','False'),(7,'ldap_active','false'),(8,'ldap_host',''),(9,'ldap_port','389'),(10,'ldap_tls_kind','PLAIN'),(11,'ldap_tls_reqcert',''),(12,'ldap_dn_user',''),(13,'ldap_dn_pass',''),(14,'ldap_base_dn',''),(15,'ldap_filter',''),(16,'ldap_search_scope',''),(17,'ldap_attr_login',''),(18,'ldap_attr_firstname',''),(19,'ldap_attr_lastname',''),(20,'ldap_attr_email',''),(21,'default_repo_enable_locking','False'),(22,'default_repo_enable_downloads','False'),(23,'default_repo_enable_statistics','False'),(24,'default_repo_private','False'),(25,'default_repo_type','hg');
/*!40000 ALTER TABLE `rhodecode_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rhodecode_ui`
--
DROP TABLE IF EXISTS `rhodecode_ui`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rhodecode_ui` (
`ui_id` int(11) NOT NULL AUTO_INCREMENT,
`ui_section` varchar(255) DEFAULT NULL,
`ui_key` varchar(255) DEFAULT NULL,
`ui_value` varchar(255) DEFAULT NULL,
`ui_active` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`ui_id`),
UNIQUE KEY `ui_id` (`ui_id`),
UNIQUE KEY `ui_key` (`ui_key`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rhodecode_ui`
--
LOCK TABLES `rhodecode_ui` WRITE;
/*!40000 ALTER TABLE `rhodecode_ui` DISABLE KEYS */;
INSERT INTO `rhodecode_ui` VALUES (1,'hooks','changegroup.update','hg update >&2',0),(2,'hooks','changegroup.repo_size','python:rhodecode.lib.hooks.repo_size',1),(3,'hooks','changegroup.push_logger','python:rhodecode.lib.hooks.log_push_action',1),(4,'hooks','prechangegroup.pre_push','python:rhodecode.lib.hooks.pre_push',1),(5,'hooks','outgoing.pull_logger','python:rhodecode.lib.hooks.log_pull_action',1),(6,'hooks','preoutgoing.pre_pull','python:rhodecode.lib.hooks.pre_pull',1),(7,'extensions','largefiles','',1),(8,'extensions','hgsubversion','',0),(9,'extensions','hggit','',0),(10,'web','push_ssl','false',1),(11,'web','allow_archive','gz zip bz2',1),(12,'web','allow_push','*',1),(13,'web','baseurl','/',1),(14,'paths','/','/mnt/hgfs/workspace-python',1);
/*!40000 ALTER TABLE `rhodecode_ui` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `statistics`
--
DROP TABLE IF EXISTS `statistics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statistics` (
`stat_id` int(11) NOT NULL AUTO_INCREMENT,
`repository_id` int(11) NOT NULL,
`stat_on_revision` int(11) NOT NULL,
`commit_activity` mediumblob NOT NULL,
`commit_activity_combined` blob NOT NULL,
`languages` mediumblob NOT NULL,
PRIMARY KEY (`stat_id`),
UNIQUE KEY `repository_id` (`repository_id`),
UNIQUE KEY `stat_id` (`stat_id`),
UNIQUE KEY `repository_id_2` (`repository_id`),
CONSTRAINT `statistics_ibfk_1` FOREIGN KEY (`repository_id`) REFERENCES `repositories` (`repo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `statistics`
--
LOCK TABLES `statistics` WRITE;
/*!40000 ALTER TABLE `statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `statistics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_email_map`
--
DROP TABLE IF EXISTS `user_email_map`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_email_map` (
`email_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`email_id`),
UNIQUE KEY `email_id` (`email_id`),
UNIQUE KEY `email` (`email`),
KEY `user_id` (`user_id`),
KEY `uem_email_idx` (`email`),
CONSTRAINT `user_email_map_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_email_map`
--
LOCK TABLES `user_email_map` WRITE;
/*!40000 ALTER TABLE `user_email_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_email_map` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_followings`
--
DROP TABLE IF EXISTS `user_followings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_followings` (
`user_following_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`follows_repository_id` int(11) DEFAULT NULL,
`follows_user_id` int(11) DEFAULT NULL,
`follows_from` datetime DEFAULT NULL,
PRIMARY KEY (`user_following_id`),
UNIQUE KEY `user_following_id` (`user_following_id`),
UNIQUE KEY `user_id` (`user_id`,`follows_repository_id`),
UNIQUE KEY `user_id_2` (`user_id`,`follows_user_id`),
KEY `follows_repository_id` (`follows_repository_id`),
KEY `follows_user_id` (`follows_user_id`),
CONSTRAINT `user_followings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_followings_ibfk_2` FOREIGN KEY (`follows_repository_id`) REFERENCES `repositories` (`repo_id`),
CONSTRAINT `user_followings_ibfk_3` FOREIGN KEY (`follows_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_followings`
--
LOCK TABLES `user_followings` WRITE;
/*!40000 ALTER TABLE `user_followings` DISABLE KEYS */;
INSERT INTO `user_followings` VALUES (1,2,1,NULL,'2013-05-29 14:15:30'),(2,2,2,NULL,'2013-05-29 14:15:30'),(3,2,3,NULL,'2013-05-29 14:15:30'),(4,2,4,NULL,'2013-05-29 14:15:31'),(5,2,5,NULL,'2013-05-29 14:15:31'),(6,2,6,NULL,'2013-05-29 14:15:31'),(7,2,7,NULL,'2013-05-29 14:15:31'),(8,2,8,NULL,'2013-05-29 14:15:31'),(9,2,9,NULL,'2013-05-29 14:15:31'),(10,2,10,NULL,'2013-05-29 14:15:31'),(11,2,11,NULL,'2013-05-29 14:15:31'),(12,2,12,NULL,'2013-05-29 14:15:31'),(13,2,13,NULL,'2013-05-29 14:15:31'),(14,2,14,NULL,'2013-05-29 14:15:31'),(15,2,15,NULL,'2013-05-29 14:15:31'),(16,2,16,NULL,'2013-05-29 14:15:31'),(17,2,17,NULL,'2013-05-29 14:15:31'),(18,2,18,NULL,'2013-05-29 14:15:31'),(19,2,19,NULL,'2013-05-29 14:15:31'),(20,2,20,NULL,'2013-05-29 14:15:31'),(21,2,21,NULL,'2013-05-29 14:15:31'),(22,2,22,NULL,'2013-05-29 14:15:31'),(23,2,23,NULL,'2013-05-29 14:15:31'),(24,2,24,NULL,'2013-05-29 14:15:31'),(25,2,25,NULL,'2013-05-29 14:15:31'),(26,2,26,NULL,'2013-05-29 14:15:31'),(27,2,27,NULL,'2013-05-29 14:15:31'),(28,2,28,NULL,'2013-05-29 14:15:31'),(29,2,29,NULL,'2013-05-29 14:15:31'),(30,2,30,NULL,'2013-05-29 14:15:31'),(31,2,31,NULL,'2013-05-29 14:15:31'),(32,2,32,NULL,'2013-05-29 14:15:31'),(33,2,33,NULL,'2013-05-29 14:15:31'),(34,2,34,NULL,'2013-05-29 14:15:31'),(35,2,35,NULL,'2013-05-29 14:15:32'),(36,2,36,NULL,'2013-05-29 14:15:32'),(37,2,37,NULL,'2013-05-29 14:15:32'),(38,2,38,NULL,'2013-05-29 14:15:32'),(39,2,39,NULL,'2013-05-29 14:15:32'),(40,2,40,NULL,'2013-05-29 14:15:32'),(41,2,41,NULL,'2013-05-29 14:15:32'),(42,2,42,NULL,'2013-05-29 14:15:32'),(43,2,43,NULL,'2013-05-29 14:15:32'),(44,2,44,NULL,'2013-05-29 14:15:32'),(45,2,45,NULL,'2013-05-29 14:15:32'),(46,2,46,NULL,'2013-05-29 14:15:32'),(47,2,47,NULL,'2013-05-29 14:15:32'),(48,2,48,NULL,'2013-05-29 14:15:32'),(49,2,49,NULL,'2013-05-29 14:15:32'),(50,2,50,NULL,'2013-05-29 14:15:32'),(51,2,51,NULL,'2013-05-29 14:15:32'),(52,2,52,NULL,'2013-05-29 14:15:32'),(53,2,53,NULL,'2013-05-29 14:15:32'),(54,2,54,NULL,'2013-05-29 14:15:32'),(55,2,55,NULL,'2013-05-29 14:15:32'),(56,2,56,NULL,'2013-05-29 14:15:32'),(57,2,57,NULL,'2013-05-29 14:15:32'),(58,2,58,NULL,'2013-05-29 14:15:32'),(59,2,59,NULL,'2013-05-29 14:15:32'),(60,2,60,NULL,'2013-05-29 14:15:33'),(61,2,61,NULL,'2013-05-29 14:15:33'),(62,2,62,NULL,'2013-05-29 14:15:33'),(63,2,63,NULL,'2013-05-29 14:15:33'),(64,2,64,NULL,'2013-05-29 14:15:33'),(65,2,65,NULL,'2013-05-29 14:15:33'),(66,2,66,NULL,'2013-05-29 14:15:33'),(67,2,67,NULL,'2013-05-29 14:15:33'),(68,2,68,NULL,'2013-05-29 14:15:33'),(69,2,69,NULL,'2013-05-29 14:15:33'),(70,2,70,NULL,'2013-05-29 14:15:33'),(71,2,71,NULL,'2013-05-29 14:15:33'),(72,2,72,NULL,'2013-05-29 14:15:33'),(73,2,73,NULL,'2013-05-29 14:15:33'),(74,2,74,NULL,'2013-05-29 14:15:33'),(75,2,75,NULL,'2013-05-29 14:15:33'),(76,2,76,NULL,'2013-05-29 14:15:33'),(77,2,77,NULL,'2013-05-29 14:15:33'),(78,2,78,NULL,'2013-05-29 14:15:33'),(79,2,79,NULL,'2013-05-29 14:15:33'),(80,2,80,NULL,'2013-05-29 14:15:33'),(81,2,81,NULL,'2013-05-29 14:15:33'),(82,2,82,NULL,'2013-05-29 14:15:33'),(83,2,83,NULL,'2013-05-29 14:15:33'),(84,2,84,NULL,'2013-05-29 14:15:33'),(85,2,85,NULL,'2013-05-29 14:15:33'),(86,2,86,NULL,'2013-05-29 14:15:33'),(87,2,87,NULL,'2013-05-29 14:15:34'),(88,2,88,NULL,'2013-05-29 14:15:34'),(89,2,89,NULL,'2013-05-29 14:15:34'),(90,2,90,NULL,'2013-05-29 14:15:34'),(91,2,91,NULL,'2013-05-29 14:15:34'),(92,2,92,NULL,'2013-05-29 14:15:34'),(93,2,93,NULL,'2013-05-29 14:15:34'),(94,2,94,NULL,'2013-05-29 14:15:34'),(95,2,95,NULL,'2013-05-29 14:15:34');
/*!40000 ALTER TABLE `user_followings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_logs`
--
DROP TABLE IF EXISTS `user_logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_logs` (
`user_log_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`repository_id` int(11) DEFAULT NULL,
`repository_name` varchar(255) DEFAULT NULL,
`user_ip` varchar(255) DEFAULT NULL,
`action` mediumtext,
`action_date` datetime DEFAULT NULL,
PRIMARY KEY (`user_log_id`),
UNIQUE KEY `user_log_id` (`user_log_id`),
KEY `user_id` (`user_id`),
KEY `repository_id` (`repository_id`),
CONSTRAINT `user_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_logs_ibfk_2` FOREIGN KEY (`repository_id`) REFERENCES `repositories` (`repo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_logs`
--
LOCK TABLES `user_logs` WRITE;
/*!40000 ALTER TABLE `user_logs` DISABLE KEYS */;
INSERT INTO `user_logs` VALUES (1,2,'marcink',1,'RC/fakeclone','','started_following_repo','2013-05-29 14:15:30'),(2,2,'marcink',2,'RC/muay','','started_following_repo','2013-05-29 14:15:30'),(3,2,'marcink',3,'RC/rc2/test2','','started_following_repo','2013-05-29 14:15:30'),(4,2,'marcink',4,'RC/rc2/test3','','started_following_repo','2013-05-29 14:15:30'),(5,2,'marcink',5,'RC/rc2/test4','','started_following_repo','2013-05-29 14:15:31'),(6,2,'marcink',6,'rhodecode-cli-gist','','started_following_repo','2013-05-29 14:15:31'),(7,2,'marcink',7,'RC/new','','started_following_repo','2013-05-29 14:15:31'),(8,2,'marcink',8,'.rc_gist_store/32','','started_following_repo','2013-05-29 14:15:31'),(9,2,'marcink',9,'vcs','','started_following_repo','2013-05-29 14:15:31'),(10,2,'marcink',10,'.rc_gist_store/36','','started_following_repo','2013-05-29 14:15:31'),(11,2,'marcink',11,'.rc_gist_store/37','','started_following_repo','2013-05-29 14:15:31'),(12,2,'marcink',12,'.rc_gist_store/39','','started_following_repo','2013-05-29 14:15:31'),(13,2,'marcink',13,'remote-salt','','started_following_repo','2013-05-29 14:15:31'),(14,2,'marcink',14,'RC/INRC/trololo','','started_following_repo','2013-05-29 14:15:31'),(15,2,'marcink',15,'quest','','started_following_repo','2013-05-29 14:15:31'),(16,2,'marcink',16,'csa-hyperion','','started_following_repo','2013-05-29 14:15:31'),(17,2,'marcink',17,'rhodecode','','started_following_repo','2013-05-29 14:15:31'),(18,2,'marcink',18,'RC/origin-fork-fork','','started_following_repo','2013-05-29 14:15:31'),(19,2,'marcink',19,'.rc_gist_store/45','','started_following_repo','2013-05-29 14:15:31'),(20,2,'marcink',20,'.rc_gist_store/44','','started_following_repo','2013-05-29 14:15:31'),(21,2,'marcink',21,'.rc_gist_store/46','','started_following_repo','2013-05-29 14:15:31'),(22,2,'marcink',22,'.rc_gist_store/41','','started_following_repo','2013-05-29 14:15:31'),(23,2,'marcink',23,'.rc_gist_store/40','','started_following_repo','2013-05-29 14:15:31'),(24,2,'marcink',24,'RC/gogo2','','started_following_repo','2013-05-29 14:15:31'),(25,2,'marcink',25,'.rc_gist_store/42','','started_following_repo','2013-05-29 14:15:31'),(26,2,'marcink',26,'.rc_gist_store/49','','started_following_repo','2013-05-29 14:15:31'),(27,2,'marcink',27,'.rc_gist_store/48','','started_following_repo','2013-05-29 14:15:31'),(28,2,'marcink',28,'csa-collins','','started_following_repo','2013-05-29 14:15:31'),(29,2,'marcink',29,'.rc_gist_store/54','','started_following_repo','2013-05-29 14:15:31'),(30,2,'marcink',30,'.rc_gist_store/55','','started_following_repo','2013-05-29 14:15:31'),(31,2,'marcink',31,'.rc_gist_store/52','','started_following_repo','2013-05-29 14:15:31'),(32,2,'marcink',32,'.rc_gist_store/53','','started_following_repo','2013-05-29 14:15:31'),(33,2,'marcink',33,'.rc_gist_store/50','','started_following_repo','2013-05-29 14:15:31'),(34,2,'marcink',34,'.rc_gist_store/51','','started_following_repo','2013-05-29 14:15:31'),(35,2,'marcink',35,'BIG/android','','started_following_repo','2013-05-29 14:15:32'),(36,2,'marcink',36,'RC/gogo-fork','','started_following_repo','2013-05-29 14:15:32'),(37,2,'marcink',37,'RC/mygr/lol','','started_following_repo','2013-05-29 14:15:32'),(38,2,'marcink',38,'RC/hg-repo','','started_following_repo','2013-05-29 14:15:32'),(39,2,'marcink',39,'RC/bin-ops','','started_following_repo','2013-05-29 14:15:32'),(40,2,'marcink',40,'.rc_gist_store/xFvj6dFqqVK5vfsGP8PU','','started_following_repo','2013-05-29 14:15:32'),(41,2,'marcink',41,'rhodecode-git','','started_following_repo','2013-05-29 14:15:32'),(42,2,'marcink',42,'csa-io','','started_following_repo','2013-05-29 14:15:32'),(43,2,'marcink',43,'RC/qweqwe-fork','','started_following_repo','2013-05-29 14:15:32'),(44,2,'marcink',44,'csa-libcloud','','started_following_repo','2013-05-29 14:15:32'),(45,2,'marcink',45,'waitress','','started_following_repo','2013-05-29 14:15:32'),(46,2,'marcink',46,'.rc_gist_store/8','','started_following_repo','2013-05-29 14:15:32'),(47,2,'marcink',47,'.rc_gist_store/9','','started_following_repo','2013-05-29 14:15:32'),(48,2,'marcink',48,'RC/foobar','','started_following_repo','2013-05-29 14:15:32'),(49,2,'marcink',49,'.rc_gist_store/1','','started_following_repo','2013-05-29 14:15:32'),(50,2,'marcink',50,'.rc_gist_store/3','','started_following_repo','2013-05-29 14:15:32'),(51,2,'marcink',51,'.rc_gist_store/4','','started_following_repo','2013-05-29 14:15:32'),(52,2,'marcink',52,'.rc_gist_store/5','','started_following_repo','2013-05-29 14:15:32'),(53,2,'marcink',53,'.rc_gist_store/6','','started_following_repo','2013-05-29 14:15:32'),(54,2,'marcink',54,'.rc_gist_store/7','','started_following_repo','2013-05-29 14:15:32'),(55,2,'marcink',55,'csa-harmony','','started_following_repo','2013-05-29 14:15:32'),(56,2,'marcink',56,'RC/łęcina','','started_following_repo','2013-05-29 14:15:32'),(57,2,'marcink',57,'rhodecode-extensions','','started_following_repo','2013-05-29 14:15:32'),(58,2,'marcink',58,'csa-prometheus','','started_following_repo','2013-05-29 14:15:32'),(59,2,'marcink',59,'RC/empty-git','','started_following_repo','2013-05-29 14:15:32'),(60,2,'marcink',60,'csa-salt-states','','started_following_repo','2013-05-29 14:15:33'),(61,2,'marcink',61,'rhodecode-premium','','started_following_repo','2013-05-29 14:15:33'),(62,2,'marcink',62,'RC/qweqwe-fork2','','started_following_repo','2013-05-29 14:15:33'),(63,2,'marcink',63,'RC/INRC/L2_NEW/lalalal','','started_following_repo','2013-05-29 14:15:33'),(64,2,'marcink',64,'RC/INRC/L2_NEW/L3/repo_test_move','','started_following_repo','2013-05-29 14:15:33'),(65,2,'marcink',65,'RC/jap','','started_following_repo','2013-05-29 14:15:33'),(66,2,'marcink',66,'RC/origin','','started_following_repo','2013-05-29 14:15:33'),(67,2,'marcink',67,'rhodecode-cli-api','','started_following_repo','2013-05-29 14:15:33'),(68,2,'marcink',68,'csa-armstrong','','started_following_repo','2013-05-29 14:15:33'),(69,2,'marcink',69,'.rc_gist_store/NAsB8cacjxnqdyZ8QUl3','','started_following_repo','2013-05-29 14:15:33'),(70,2,'marcink',70,'RC/lol/haha','','started_following_repo','2013-05-29 14:15:33'),(71,2,'marcink',71,'enc-envelope','','started_following_repo','2013-05-29 14:15:33'),(72,2,'marcink',72,'.rc_gist_store/43','','started_following_repo','2013-05-29 14:15:33'),(73,2,'marcink',73,'RC/test','','started_following_repo','2013-05-29 14:15:33'),(74,2,'marcink',74,'BIG/git','','started_following_repo','2013-05-29 14:15:33'),(75,2,'marcink',75,'RC/origin-fork','','started_following_repo','2013-05-29 14:15:33'),(76,2,'marcink',76,'RC/trololo','','started_following_repo','2013-05-29 14:15:33'),(77,2,'marcink',77,'.rc_gist_store/FLj8GunafFAVBnuTWDxU','','started_following_repo','2013-05-29 14:15:33'),(78,2,'marcink',78,'RC/ąqweqwe','','started_following_repo','2013-05-29 14:15:33'),(79,2,'marcink',79,'csa-unity','','started_following_repo','2013-05-29 14:15:33'),(80,2,'marcink',80,'RC/vcs-git','','started_following_repo','2013-05-29 14:15:33'),(81,2,'marcink',81,'.rc_gist_store/12','','started_following_repo','2013-05-29 14:15:33'),(82,2,'marcink',82,'.rc_gist_store/13','','started_following_repo','2013-05-29 14:15:33'),(83,2,'marcink',83,'.rc_gist_store/10','','started_following_repo','2013-05-29 14:15:33'),(84,2,'marcink',84,'.rc_gist_store/11','','started_following_repo','2013-05-29 14:15:33'),(85,2,'marcink',85,'RC/kiall-nova','','started_following_repo','2013-05-29 14:15:33'),(86,2,'marcink',86,'RC/rc2/test','','started_following_repo','2013-05-29 14:15:33'),(87,2,'marcink',87,'DOCS','','started_following_repo','2013-05-29 14:15:34'),(88,2,'marcink',88,'RC/fork-remote','','started_following_repo','2013-05-29 14:15:34'),(89,2,'marcink',89,'RC/git-pull-test','','started_following_repo','2013-05-29 14:15:34'),(90,2,'marcink',90,'pyramidpypi','','started_following_repo','2013-05-29 14:15:34'),(91,2,'marcink',91,'.rc_gist_store/aQpbufbhSac6FyvVHhmS','','started_following_repo','2013-05-29 14:15:34'),(92,2,'marcink',92,'csa-aldrin','','started_following_repo','2013-05-29 14:15:34'),(93,2,'marcink',93,'.rc_gist_store/QL2GhrlKymNmrUJJy5js','','started_following_repo','2013-05-29 14:15:34'),(94,2,'marcink',94,'RC/git-test','','started_following_repo','2013-05-29 14:15:34'),(95,2,'marcink',95,'salt','','started_following_repo','2013-05-29 14:15:34');
/*!40000 ALTER TABLE `user_logs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_repo_group_to_perm`
--
DROP TABLE IF EXISTS `user_repo_group_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_repo_group_to_perm` (
`group_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`group_to_perm_id`),
UNIQUE KEY `user_id` (`user_id`,`group_id`,`permission_id`),
UNIQUE KEY `group_to_perm_id` (`group_to_perm_id`),
KEY `group_id` (`group_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `user_repo_group_to_perm_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_repo_group_to_perm_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`),
CONSTRAINT `user_repo_group_to_perm_ibfk_3` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_repo_group_to_perm`
--
LOCK TABLES `user_repo_group_to_perm` WRITE;
/*!40000 ALTER TABLE `user_repo_group_to_perm` DISABLE KEYS */;
INSERT INTO `user_repo_group_to_perm` VALUES (1,1,1,6),(2,1,2,6),(3,1,3,6),(4,1,4,6),(5,1,5,6),(6,1,6,6),(7,1,7,6),(8,1,8,6),(9,1,9,6);
/*!40000 ALTER TABLE `user_repo_group_to_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_to_notification`
--
DROP TABLE IF EXISTS `user_to_notification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_to_notification` (
`user_id` int(11) NOT NULL,
`notification_id` int(11) NOT NULL,
`read` tinyint(1) DEFAULT NULL,
`sent_on` datetime DEFAULT NULL,
PRIMARY KEY (`user_id`,`notification_id`),
UNIQUE KEY `user_id` (`user_id`,`notification_id`),
KEY `notification_id` (`notification_id`),
CONSTRAINT `user_to_notification_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_to_notification_ibfk_2` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_to_notification`
--
LOCK TABLES `user_to_notification` WRITE;
/*!40000 ALTER TABLE `user_to_notification` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_to_notification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_to_perm`
--
DROP TABLE IF EXISTS `user_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_to_perm` (
`user_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`user_to_perm_id`),
UNIQUE KEY `user_id` (`user_id`,`permission_id`),
UNIQUE KEY `user_to_perm_id` (`user_to_perm_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `user_to_perm_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_to_perm_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_to_perm`
--
LOCK TABLES `user_to_perm` WRITE;
/*!40000 ALTER TABLE `user_to_perm` DISABLE KEYS */;
INSERT INTO `user_to_perm` VALUES (4,1,2),(5,1,6),(2,1,11),(3,1,13),(1,1,15);
/*!40000 ALTER TABLE `user_to_perm` 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` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`active` tinyint(1) DEFAULT NULL,
`admin` tinyint(1) DEFAULT NULL,
`firstname` varchar(255) DEFAULT NULL,
`lastname` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`ldap_dn` varchar(255) DEFAULT NULL,
`api_key` varchar(255) DEFAULT NULL,
`inherit_default_permissions` tinyint(1) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_id` (`user_id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `u_username_idx` (`username`),
KEY `u_email_idx` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 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,'default','$2a$10$H9jd01.Elb7uAckLZ7HGL.Ue6AvC/pbMS3oR3.hT7uN3Gp2RIIKF.',1,0,'Anonymous','User','anonymous@rhodecode.org',NULL,NULL,'c975634648424bb781d0b4329f8b17cef5c03c73',1),(2,'marcink','$2a$10$7GAtHG19SebcR1nwEDEAsOjmJcnTcbwJ0eGEZhJT/crgxy2rPl6om',1,1,'RhodeCode','Admin','marcin',NULL,NULL,'63690794a1344bc9e8129a2f9c2deffe649529da',1);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_group_repo_group_to_perm`
--
DROP TABLE IF EXISTS `users_group_repo_group_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_group_repo_group_to_perm` (
`users_group_repo_group_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`users_group_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`users_group_repo_group_to_perm_id`),
UNIQUE KEY `users_group_id` (`users_group_id`,`group_id`),
UNIQUE KEY `users_group_repo_group_to_perm_id` (`users_group_repo_group_to_perm_id`),
KEY `group_id` (`group_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `users_group_repo_group_to_perm_ibfk_1` FOREIGN KEY (`users_group_id`) REFERENCES `users_groups` (`users_group_id`),
CONSTRAINT `users_group_repo_group_to_perm_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`),
CONSTRAINT `users_group_repo_group_to_perm_ibfk_3` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_group_repo_group_to_perm`
--
LOCK TABLES `users_group_repo_group_to_perm` WRITE;
/*!40000 ALTER TABLE `users_group_repo_group_to_perm` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_group_repo_group_to_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_group_repo_to_perm`
--
DROP TABLE IF EXISTS `users_group_repo_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_group_repo_to_perm` (
`users_group_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`users_group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
`repository_id` int(11) NOT NULL,
PRIMARY KEY (`users_group_to_perm_id`),
UNIQUE KEY `repository_id` (`repository_id`,`users_group_id`,`permission_id`),
UNIQUE KEY `users_group_to_perm_id` (`users_group_to_perm_id`),
KEY `users_group_id` (`users_group_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `users_group_repo_to_perm_ibfk_1` FOREIGN KEY (`users_group_id`) REFERENCES `users_groups` (`users_group_id`),
CONSTRAINT `users_group_repo_to_perm_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`),
CONSTRAINT `users_group_repo_to_perm_ibfk_3` FOREIGN KEY (`repository_id`) REFERENCES `repositories` (`repo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_group_repo_to_perm`
--
LOCK TABLES `users_group_repo_to_perm` WRITE;
/*!40000 ALTER TABLE `users_group_repo_to_perm` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_group_repo_to_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_group_to_perm`
--
DROP TABLE IF EXISTS `users_group_to_perm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_group_to_perm` (
`users_group_to_perm_id` int(11) NOT NULL AUTO_INCREMENT,
`users_group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`users_group_to_perm_id`),
UNIQUE KEY `users_group_id` (`users_group_id`,`permission_id`),
UNIQUE KEY `users_group_to_perm_id` (`users_group_to_perm_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `users_group_to_perm_ibfk_1` FOREIGN KEY (`users_group_id`) REFERENCES `users_groups` (`users_group_id`),
CONSTRAINT `users_group_to_perm_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_group_to_perm`
--
LOCK TABLES `users_group_to_perm` WRITE;
/*!40000 ALTER TABLE `users_group_to_perm` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_group_to_perm` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_groups`
--
DROP TABLE IF EXISTS `users_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_groups` (
`users_group_id` int(11) NOT NULL AUTO_INCREMENT,
`users_group_name` varchar(255) NOT NULL,
`users_group_active` tinyint(1) DEFAULT NULL,
`users_group_inherit_default_permissions` tinyint(1) NOT NULL,
PRIMARY KEY (`users_group_id`),
UNIQUE KEY `users_group_id` (`users_group_id`),
UNIQUE KEY `users_group_name` (`users_group_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_groups`
--
LOCK TABLES `users_groups` WRITE;
/*!40000 ALTER TABLE `users_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users_groups_members`
--
DROP TABLE IF EXISTS `users_groups_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_groups_members` (
`users_group_member_id` int(11) NOT NULL AUTO_INCREMENT,
`users_group_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`users_group_member_id`),
UNIQUE KEY `users_group_member_id` (`users_group_member_id`),
KEY `users_group_id` (`users_group_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `users_groups_members_ibfk_1` FOREIGN KEY (`users_group_id`) REFERENCES `users_groups` (`users_group_id`),
CONSTRAINT `users_groups_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users_groups_members`
--
LOCK TABLES `users_groups_members` WRITE;
/*!40000 ALTER TABLE `users_groups_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `users_groups_members` 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-05-29 14:15:42