At some pre-installed with a blank mysql database sqlite database, I spent
over an existing data. I think this is the cause of the problem, but it was
necessary.
Yes, we have a daily backup. But size is 50 Mbytes of compressed.I have
included in the scheme.
Viktor
On Thursday, June 28, 2012 11:28:17 AM UTC+2, Christian Hammond wrote:
>
> Somehow or another, you have corrupt database schema evolution data that
> can't be loaded.
>
> At any point, did you ever do any kind of database migration by hand, or
> modify the django_evolution or django_project_version tables in the
> database?
>
> Do you have any backups?
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
>
>
> On Thu, Jun 28, 2012 at 2:03 AM, Viktor Jozsa <jozsa.vikt...@gmail.com>wrote:
>
>> Hi!
>>
>> The same problem occurs on a test server.
>>
>>
>> What is the problem. Thank you in advance.
>>
>> Regards
>>
>> Viktor
>>
>>> --
>> Want to help the Review Board project? Donate today at
>> http://www.reviewboard.org/donate/
>> Happy user? Let us know at http://www.reviewboard.org/users/
>> -~----------~----~----~----~------~----~------~--~---
>> To unsubscribe from this group, send email to
>> reviewboard+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/reviewboard?hl=en
>>
>
>
On Thursday, June 28, 2012 11:28:17 AM UTC+2, Christian Hammond wrote:
>
> Somehow or another, you have corrupt database schema evolution data that
> can't be loaded.
>
> At any point, did you ever do any kind of database migration by hand, or
> modify the django_evolution or django_project_version tables in the
> database?
>
> Do you have any backups?
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board - http://www.reviewboard.org
> VMware, Inc. - http://www.vmware.com
>
>
> On Thu, Jun 28, 2012 at 2:03 AM, Viktor Jozsa <jozsa.vikt...@gmail.com>wrote:
>
>> Hi!
>>
>> The same problem occurs on a test server.
>>
>>
>> What is the problem. Thank you in advance.
>>
>> Regards
>>
>> Viktor
>>
>>> --
>> Want to help the Review Board project? Donate today at
>> http://www.reviewboard.org/donate/
>> Happy user? Let us know at http://www.reviewboard.org/users/
>> -~----------~----~----~----~------~----~------~--~---
>> To unsubscribe from this group, send email to
>> reviewboard+unsubscr...@googlegroups.com
>> For more options, visit this group at
>> http://groups.google.com/group/reviewboard?hl=en
>>
>
>
--
Want to help the Review Board project? Donate today at
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~----------~----~----~----~------~----~------~--~---
To unsubscribe from this group, send email to
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/reviewboard?hl=en
-- MySQL dump 10.13 Distrib 5.1.61, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: reviewboard
-- ------------------------------------------------------
-- Server version 5.1.61-0+squeeze1
/*!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 `accounts_localsiteprofile`
--
DROP TABLE IF EXISTS `accounts_localsiteprofile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_localsiteprofile` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`profile_id` int(11) NOT NULL,
`local_site_id` int(11) DEFAULT NULL,
`direct_incoming_request_count` int(11) DEFAULT NULL,
`total_incoming_request_count` int(11) DEFAULT NULL,
`pending_outgoing_request_count` int(11) DEFAULT NULL,
`total_outgoing_request_count` int(11) DEFAULT NULL,
`starred_public_request_count` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`local_site_id`),
UNIQUE KEY `profile_id` (`profile_id`,`local_site_id`),
KEY `accounts_localsiteprofile_fbfc09f1` (`user_id`),
KEY `accounts_localsiteprofile_141c6eec` (`profile_id`),
KEY `accounts_localsiteprofile_45ded6af` (`local_site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `accounts_profile`
--
DROP TABLE IF EXISTS `accounts_profile`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_profile` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`first_time_setup_done` tinyint(1) NOT NULL,
`collapsed_diffs` tinyint(1) NOT NULL,
`wordwrapped_diffs` tinyint(1) NOT NULL,
`syntax_highlighting` tinyint(1) NOT NULL,
`show_submitted` tinyint(1) NOT NULL,
`sort_review_request_columns` varchar(256) NOT NULL,
`sort_dashboard_columns` varchar(256) NOT NULL,
`sort_submitter_columns` varchar(256) NOT NULL,
`sort_group_columns` varchar(256) NOT NULL,
`review_request_columns` varchar(256) NOT NULL,
`dashboard_columns` varchar(256) NOT NULL,
`submitter_columns` varchar(256) NOT NULL,
`group_columns` varchar(256) NOT NULL,
`is_private` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `accounts_profile_starred_groups`
--
DROP TABLE IF EXISTS `accounts_profile_starred_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_profile_starred_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`profile_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `profile_id` (`profile_id`,`group_id`),
KEY `accounts_profile_starred_groups_141c6eec` (`profile_id`),
KEY `accounts_profile_starred_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `accounts_profile_starred_review_requests`
--
DROP TABLE IF EXISTS `accounts_profile_starred_review_requests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_profile_starred_review_requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`profile_id` int(11) NOT NULL,
`reviewrequest_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `profile_id` (`profile_id`,`reviewrequest_id`),
UNIQUE KEY `profile_starred_review_requests__reviewrequest_profile` (`reviewrequest_id`,`profile_id`),
KEY `accounts_profile_starred_review_requests_141c6eec` (`profile_id`),
KEY `accounts_profile_starred_review_requests_3109547e` (`reviewrequest_id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `accounts_reviewrequestvisit`
--
DROP TABLE IF EXISTS `accounts_reviewrequestvisit`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts_reviewrequestvisit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`review_request_id` int(11) NOT NULL,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`review_request_id`),
KEY `accounts_reviewrequestvisit_fbfc09f1` (`user_id`),
KEY `accounts_reviewrequestvisit_bf7a5334` (`review_request_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4339 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `attachments_fileattachment`
--
DROP TABLE IF EXISTS `attachments_fileattachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attachments_fileattachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`caption` varchar(256) NOT NULL,
`draft_caption` varchar(256) NOT NULL,
`file` varchar(100) NOT NULL,
`mimetype` varchar(256) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_group`
--
DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_group_permissions`
--
DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`permission_id`),
KEY `auth_group_permissions_bda51c3c` (`group_id`),
KEY `auth_group_permissions_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_message`
--
DROP TABLE IF EXISTS `auth_message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`message` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `auth_message_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_permission`
--
DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
KEY `auth_permission_e4470c6e` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_user`
--
DROP TABLE IF EXISTS `auth_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(75) NOT NULL,
`password` varchar(128) NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`is_superuser` tinyint(1) NOT NULL,
`last_login` datetime NOT NULL,
`date_joined` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_user_groups`
--
DROP TABLE IF EXISTS `auth_user_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`group_id`),
KEY `auth_user_groups_fbfc09f1` (`user_id`),
KEY `auth_user_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `auth_user_user_permissions`
--
DROP TABLE IF EXISTS `auth_user_user_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`permission_id`),
KEY `auth_user_user_permissions_fbfc09f1` (`user_id`),
KEY `auth_user_user_permissions_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=201 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `changedescs_changedescription`
--
DROP TABLE IF EXISTS `changedescs_changedescription`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `changedescs_changedescription` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timestamp` datetime NOT NULL,
`public` tinyint(1) NOT NULL,
`text` longtext NOT NULL,
`fields_changed` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2009 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `diffviewer_diffset`
--
DROP TABLE IF EXISTS `diffviewer_diffset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diffviewer_diffset` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL,
`revision` int(11) NOT NULL,
`timestamp` datetime NOT NULL,
`basedir` varchar(256) NOT NULL,
`history_id` int(11) DEFAULT NULL,
`repository_id` int(11) NOT NULL,
`diffcompat` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `diffviewer_diffset_6c9c0cef` (`history_id`),
KEY `diffviewer_diffset_6a730446` (`repository_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1812 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `diffviewer_diffsethistory`
--
DROP TABLE IF EXISTS `diffviewer_diffsethistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diffviewer_diffsethistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1797 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `diffviewer_filediff`
--
DROP TABLE IF EXISTS `diffviewer_filediff`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diffviewer_filediff` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`diffset_id` int(11) NOT NULL,
`source_file` varchar(1024) NOT NULL,
`dest_file` varchar(1024) NOT NULL,
`source_revision` varchar(512) NOT NULL,
`dest_detail` varchar(512) NOT NULL,
`diff_base64` longtext NOT NULL,
`binary` tinyint(1) NOT NULL,
`parent_diff_base64` longtext NOT NULL,
`status` varchar(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `diffviewer_filediff_47e4d75c` (`diffset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23314 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_admin_log`
--
DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action_time` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`object_id` longtext,
`object_repr` varchar(200) NOT NULL,
`action_flag` smallint(5) unsigned NOT NULL,
`change_message` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `django_admin_log_fbfc09f1` (`user_id`),
KEY `django_admin_log_e4470c6e` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_content_type`
--
DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`app_label` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `app_label` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_evolution`
--
DROP TABLE IF EXISTS `django_evolution`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_evolution` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`version_id` int(11) NOT NULL,
`app_label` varchar(200) NOT NULL,
`label` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `django_evolution_fef0b09d` (`version_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_project_version`
--
DROP TABLE IF EXISTS `django_project_version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_project_version` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`signature` longtext NOT NULL,
`when` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_session`
--
DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_session` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime NOT NULL,
PRIMARY KEY (`session_key`),
KEY `django_session_c25c2c28` (`expire_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `django_site`
--
DROP TABLE IF EXISTS `django_site`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_site` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(100) NOT NULL,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `hostingsvcs_hostingserviceaccount`
--
DROP TABLE IF EXISTS `hostingsvcs_hostingserviceaccount`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hostingsvcs_hostingserviceaccount` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`service_name` varchar(128) NOT NULL,
`username` varchar(128) NOT NULL,
`data` longtext NOT NULL,
`visible` tinyint(1) NOT NULL,
`local_site_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `service_name` (`service_name`,`username`,`local_site_id`),
KEY `local_site_id_refs_id_4e8fb8ce` (`local_site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_comment`
--
DROP TABLE IF EXISTS `reviews_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`issue_opened` tinyint(1) NOT NULL,
`issue_status` varchar(1) DEFAULT NULL,
`filediff_id` int(11) NOT NULL,
`interfilediff_id` int(11) DEFAULT NULL,
`reply_to_id` int(11) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`text` longtext NOT NULL,
`first_line` int(10) unsigned DEFAULT NULL,
`num_lines` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `reviews_comment_975f86ad` (`issue_status`),
KEY `reviews_comment_367cba1f` (`filediff_id`),
KEY `reviews_comment_a69b1564` (`interfilediff_id`),
KEY `reviews_comment_2710e4f4` (`reply_to_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7097 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_defaultreviewer`
--
DROP TABLE IF EXISTS `reviews_defaultreviewer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_defaultreviewer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`file_regex` varchar(256) NOT NULL,
`local_site_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `reviews_defaultreviewer_45ded6af` (`local_site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_defaultreviewer_groups`
--
DROP TABLE IF EXISTS `reviews_defaultreviewer_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_defaultreviewer_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`defaultreviewer_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `defaultreviewer_id` (`defaultreviewer_id`,`group_id`),
KEY `reviews_defaultreviewer_groups_477deba9` (`defaultreviewer_id`),
KEY `reviews_defaultreviewer_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_defaultreviewer_people`
--
DROP TABLE IF EXISTS `reviews_defaultreviewer_people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_defaultreviewer_people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`defaultreviewer_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `defaultreviewer_id` (`defaultreviewer_id`,`user_id`),
KEY `reviews_defaultreviewer_people_477deba9` (`defaultreviewer_id`),
KEY `reviews_defaultreviewer_people_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_defaultreviewer_repository`
--
DROP TABLE IF EXISTS `reviews_defaultreviewer_repository`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_defaultreviewer_repository` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`defaultreviewer_id` int(11) NOT NULL,
`repository_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `defaultreviewer_id` (`defaultreviewer_id`,`repository_id`),
KEY `reviews_defaultreviewer_repository_477deba9` (`defaultreviewer_id`),
KEY `reviews_defaultreviewer_repository_6a730446` (`repository_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_fileattachmentcomment`
--
DROP TABLE IF EXISTS `reviews_fileattachmentcomment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_fileattachmentcomment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`issue_opened` tinyint(1) NOT NULL,
`issue_status` varchar(1) DEFAULT NULL,
`file_attachment_id` int(11) NOT NULL,
`reply_to_id` int(11) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`text` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `reviews_fileattachmentcomment_975f86ad` (`issue_status`),
KEY `reviews_fileattachmentcomment_c8f1c9e3` (`file_attachment_id`),
KEY `reviews_fileattachmentcomment_2710e4f4` (`reply_to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_group`
--
DROP TABLE IF EXISTS `reviews_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`display_name` varchar(64) NOT NULL,
`mailing_list` varchar(75) NOT NULL,
`local_site_id` int(11) DEFAULT NULL,
`incoming_request_count` int(11) DEFAULT NULL,
`invite_only` tinyint(1) NOT NULL,
`visible` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`local_site_id`),
KEY `reviews_group_52094d6e` (`name`),
KEY `reviews_group_45ded6af` (`local_site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_group_users`
--
DROP TABLE IF EXISTS `reviews_group_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_group_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`user_id`),
KEY `group_users__group_user` (`group_id`,`user_id`),
KEY `reviews_group_users_bda51c3c` (`group_id`),
KEY `reviews_group_users_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_review`
--
DROP TABLE IF EXISTS `reviews_review`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_review` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`timestamp` datetime NOT NULL,
`public` tinyint(1) NOT NULL,
`ship_it` tinyint(1) NOT NULL,
`base_reply_to_id` int(11) DEFAULT NULL,
`email_message_id` varchar(255) DEFAULT NULL,
`time_emailed` datetime DEFAULT NULL,
`body_top` longtext NOT NULL,
`body_bottom` longtext NOT NULL,
`body_top_reply_to_id` int(11) DEFAULT NULL,
`body_bottom_reply_to_id` int(11) DEFAULT NULL,
`reviewed_diffset_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `reviews_review_bf7a5334` (`review_request_id`),
KEY `reviews_review_fbfc09f1` (`user_id`),
KEY `reviews_review_3534312d` (`base_reply_to_id`),
KEY `reviews_review_9faae2ee` (`body_top_reply_to_id`),
KEY `reviews_review_4a7afee7` (`body_bottom_reply_to_id`),
KEY `reviews_review_54af9375` (`reviewed_diffset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4220 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_review_comments`
--
DROP TABLE IF EXISTS `reviews_review_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_review_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_id` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review_id` (`review_id`,`comment_id`),
KEY `reviews_review_comments_9038cf0e` (`review_id`),
KEY `reviews_review_comments_9b3dc754` (`comment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7096 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_review_file_attachment_comments`
--
DROP TABLE IF EXISTS `reviews_review_file_attachment_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_review_file_attachment_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_id` int(11) NOT NULL,
`fileattachmentcomment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review_id` (`review_id`,`fileattachmentcomment_id`),
KEY `reviews_review_file_attachment_comments_9038cf0e` (`review_id`),
KEY `reviews_review_file_attachment_comments_b906f02f` (`fileattachmentcomment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_review_screenshot_comments`
--
DROP TABLE IF EXISTS `reviews_review_screenshot_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_review_screenshot_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_id` int(11) NOT NULL,
`screenshotcomment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review_id` (`review_id`,`screenshotcomment_id`),
KEY `reviews_review_screenshot_comments_9038cf0e` (`review_id`),
KEY `reviews_review_screenshot_comments_1997ee92` (`screenshotcomment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest`
--
DROP TABLE IF EXISTS `reviews_reviewrequest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`submitter_id` int(11) NOT NULL,
`time_added` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`status` varchar(1) NOT NULL,
`public` tinyint(1) NOT NULL,
`changenum` int(10) unsigned DEFAULT NULL,
`repository_id` int(11) DEFAULT NULL,
`email_message_id` varchar(255) DEFAULT NULL,
`time_emailed` datetime DEFAULT NULL,
`summary` varchar(300) NOT NULL,
`description` longtext NOT NULL,
`testing_done` longtext NOT NULL,
`bugs_closed` varchar(300) NOT NULL,
`diffset_history_id` int(11) NOT NULL,
`branch` varchar(300) NOT NULL,
`last_review_timestamp` datetime DEFAULT NULL,
`shipit_count` int(11) DEFAULT NULL,
`local_site_id` int(11) DEFAULT NULL,
`local_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `changenum` (`changenum`,`repository_id`),
UNIQUE KEY `local_site_id` (`local_site_id`,`local_id`),
KEY `reviews_reviewrequest_1a37f020` (`submitter_id`),
KEY `reviews_reviewrequest_c9ad71dd` (`status`),
KEY `reviews_reviewrequest_48dee32a` (`changenum`),
KEY `reviews_reviewrequest_6a730446` (`repository_id`),
KEY `reviews_reviewrequest_d4923f3b` (`diffset_history_id`),
KEY `reviews_reviewrequest_45ded6af` (`local_site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1783 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_changedescs`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_changedescs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_changedescs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`changedescription_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`changedescription_id`),
KEY `reviews_reviewrequest_changedescs_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_changedescs_20060ff1` (`changedescription_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1927 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_file_attachments`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_file_attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_file_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`fileattachment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`fileattachment_id`),
KEY `reviews_reviewrequest_file_attachments_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_file_attachments_484aade7` (`fileattachment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_inactive_file_attachments`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_inactive_file_attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_inactive_file_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`fileattachment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`fileattachment_id`),
KEY `reviews_reviewrequest_inactive_file_attachments_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_inactive_file_attachments_484aade7` (`fileattachment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_inactive_screenshots`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_inactive_screenshots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_inactive_screenshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`screenshot_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`screenshot_id`),
KEY `reviews_reviewrequest_inactive_screenshots_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_inactive_screenshots_62c5ecba` (`screenshot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_screenshots`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_screenshots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_screenshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`screenshot_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`screenshot_id`),
KEY `reviews_reviewrequest_screenshots_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_screenshots_62c5ecba` (`screenshot_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_target_groups`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_target_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_target_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`group_id`),
UNIQUE KEY `reviewrequest_target_groups__reviewrequest_group` (`reviewrequest_id`,`group_id`),
KEY `reviews_reviewrequest_target_groups_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_target_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequest_target_people`
--
DROP TABLE IF EXISTS `reviews_reviewrequest_target_people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequest_target_people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequest_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequest_id` (`reviewrequest_id`,`user_id`),
KEY `reviewrequest_target_people__reviewrequest_user` (`reviewrequest_id`,`user_id`),
KEY `reviews_reviewrequest_target_people_3109547e` (`reviewrequest_id`),
KEY `reviews_reviewrequest_target_people_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3517 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_request_id` int(11) NOT NULL,
`last_updated` datetime NOT NULL,
`summary` varchar(300) NOT NULL,
`description` longtext NOT NULL,
`testing_done` longtext NOT NULL,
`bugs_closed` varchar(300) NOT NULL,
`diffset_id` int(11) DEFAULT NULL,
`changedesc_id` int(11) DEFAULT NULL,
`branch` varchar(300) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review_request_id` (`review_request_id`),
KEY `reviews_reviewrequestdraft_47e4d75c` (`diffset_id`),
KEY `reviews_reviewrequestdraft_d348e07b` (`changedesc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1867 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_file_attachments`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_file_attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_file_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`fileattachment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`fileattachment_id`),
KEY `reviews_reviewrequestdraft_file_attachments_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_file_attachments_484aade7` (`fileattachment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_inactive_file_attachments`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_inactive_file_attachments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_inactive_file_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`fileattachment_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`fileattachment_id`),
KEY `reviews_reviewrequestdraft_inactive_file_attachments_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_inactive_file_attachments_484aade7` (`fileattachment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_inactive_screenshots`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_inactive_screenshots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_inactive_screenshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`screenshot_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`screenshot_id`),
KEY `reviews_reviewrequestdraft_inactive_screenshots_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_inactive_screenshots_62c5ecba` (`screenshot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_screenshots`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_screenshots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_screenshots` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`screenshot_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`screenshot_id`),
KEY `reviews_reviewrequestdraft_screenshots_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_screenshots_62c5ecba` (`screenshot_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_target_groups`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_target_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_target_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`group_id`),
KEY `reviews_reviewrequestdraft_target_groups_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_target_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_reviewrequestdraft_target_people`
--
DROP TABLE IF EXISTS `reviews_reviewrequestdraft_target_people`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_reviewrequestdraft_target_people` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewrequestdraft_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`user_id`),
KEY `reviews_reviewrequestdraft_target_people_995550ce` (`reviewrequestdraft_id`),
KEY `reviews_reviewrequestdraft_target_people_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4156 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_screenshot`
--
DROP TABLE IF EXISTS `reviews_screenshot`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_screenshot` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`caption` varchar(256) NOT NULL,
`draft_caption` varchar(256) NOT NULL,
`image` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `reviews_screenshotcomment`
--
DROP TABLE IF EXISTS `reviews_screenshotcomment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews_screenshotcomment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`issue_opened` tinyint(1) NOT NULL,
`issue_status` varchar(1) DEFAULT NULL,
`screenshot_id` int(11) NOT NULL,
`reply_to_id` int(11) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`text` longtext NOT NULL,
`x` smallint(5) unsigned DEFAULT NULL,
`y` smallint(5) unsigned NOT NULL,
`w` smallint(5) unsigned NOT NULL,
`h` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `reviews_screenshotcomment_975f86ad` (`issue_status`),
KEY `reviews_screenshotcomment_62c5ecba` (`screenshot_id`),
KEY `reviews_screenshotcomment_2710e4f4` (`reply_to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scmtools_repository`
--
DROP TABLE IF EXISTS `scmtools_repository`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scmtools_repository` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`path` varchar(255) NOT NULL,
`mirror_path` varchar(255) NOT NULL,
`raw_file_url` varchar(255) NOT NULL,
`username` varchar(32) NOT NULL,
`password` varchar(128) NOT NULL,
`tool_id` int(11) NOT NULL,
`bug_tracker` varchar(256) NOT NULL,
`encoding` varchar(32) NOT NULL,
`visible` tinyint(1) NOT NULL,
`local_site_id` int(11) DEFAULT NULL,
`public` tinyint(1) NOT NULL,
`extra_data` longtext NOT NULL,
`hosting_account_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`local_site_id`),
UNIQUE KEY `path` (`path`,`local_site_id`),
KEY `scmtools_repository_ff924466` (`tool_id`),
KEY `scmtools_repository_45ded6af` (`local_site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scmtools_repository_review_groups`
--
DROP TABLE IF EXISTS `scmtools_repository_review_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scmtools_repository_review_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`repository_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `repository_id` (`repository_id`,`group_id`),
KEY `scmtools_repository_review_groups_6a730446` (`repository_id`),
KEY `scmtools_repository_review_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scmtools_repository_users`
--
DROP TABLE IF EXISTS `scmtools_repository_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scmtools_repository_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`repository_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `repository_id` (`repository_id`,`user_id`),
KEY `scmtools_repository_users_6a730446` (`repository_id`),
KEY `scmtools_repository_users_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=347 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scmtools_tool`
--
DROP TABLE IF EXISTS `scmtools_tool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scmtools_tool` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`class_name` varchar(128) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `class_name` (`class_name`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `site_localsite`
--
DROP TABLE IF EXISTS `site_localsite`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_localsite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `site_localsite_admins`
--
DROP TABLE IF EXISTS `site_localsite_admins`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_localsite_admins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`localsite_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `localsite_id` (`localsite_id`,`user_id`),
KEY `site_localsite_admins_5eaeed01` (`localsite_id`),
KEY `site_localsite_admins_fbfc09f1` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `site_localsite_users`
--
DROP TABLE IF EXISTS `site_localsite_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_localsite_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`localsite_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `localsite_id` (`localsite_id`,`user_id`),
KEY `site_localsite_users_5eaeed01` (`localsite_id`),
KEY `site_localsite_users_fbfc09f1` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `siteconfig_siteconfiguration`
--
DROP TABLE IF EXISTS `siteconfig_siteconfiguration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `siteconfig_siteconfiguration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL,
`version` varchar(20) NOT NULL,
`settings` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `siteconfig_siteconfiguration_6223029` (`site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!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 2012-06-28 11:55:06