Oops looks like you might be right. Anyway here's our schema direct coming from our production site.
Previously we were running 2.0.20, and the upgrade went smooth if I recall. On Monday, 21 August 2017 10:23:03 UTC+10, Gene Paul Quevedo wrote: > > hi Christian > > The schema is from 2.0.25. It was from a snapshot of our test server > before the upgrade was performed. If there's a suspicion I could generate > again the schema coming from ou production server, which runs 2.0.25 > > On Tuesday, 15 August 2017 09:49:09 UTC+10, Christian Hammond wrote: >> >> Hi Gene, >> >> Looks like there was a partial attempt at an evolution that failed once >> before. The "visibility" column was applied and then something apparently >> went wrong, or upgrading was cancelled. Deleting the duplicates and running >> again would lead to this, unless carefully handled in a way compatible with >> django-evolution's internals. >> >> Is this database schema the initial one applied from 2.0.25, or what you >> have on the test server after the upgrade attempts? >> >> Christian >> >> On Sun, Aug 13, 2017 at 8:40 PM, Gene Paul Quevedo <[email protected]> >> wrote: >> >>> Hi, >>> >>> I'ts my first time to post here, and I hope someone can point me to the >>> right way of solving this issue, even though it seems like there were >>> issues like this before >>> >>> I'm trying to do a DB upgrade of Review from 2.0.25 to 2.5.15 on a test >>> server with a copy of our Database, and seems like it has bumped into this >>> issue >>> >>> Rebuilding directory structure >>> Upgrading site settings_local.py >>> Updating database. This may take a while. >>> >>> The log output below, including warnings and errors, >>> can be ignored unless upgrade fails. >>> >>> ------------------ <begin log output> ------------------ >>> Creating tables ... >>> There are unapplied evolutions for accounts. >>> There are unapplied evolutions for attachments. >>> There are unapplied evolutions for diffviewer. >>> There are unapplied evolutions for reviews. >>> There are unapplied evolutions for webapi. >>> Project signature has changed - an evolution is required >>> Installing custom SQL ... >>> Installing indexes ... >>> Installed 0 object(s) from 0 fixture(s) >>> >>> This may take a while. Please be patient, and do not cancel the upgrade! >>> >>> Applying database evolutions for accounts... >>> Database evolutions for accounts failed! >>> The SQL statement was: (u'ALTER TABLE `accounts_reviewrequestvisit` ADD >>> COLUMN `visibility` varchar(1) NOT NULL DEFAULT %s;', [u'V']) >>> >>> >>> >>> *The database error was: (1060, "Duplicate column name >>> 'visibility'")CommandError: Error applying evolution for accounts: (1060, >>> "Duplicate column name 'visibility'")* >>> There are probably 4 variations of that 'duplicate column' error, and >>> the other one is a 'duplicate index' . >>> My initial solution was to delete the duplicates and run the upgrade >>> procedure again, but seems like the duplication seems to be repeating (!), >>> as if Django Evolution is creating those duplicate columns/indices >>> >>> Any ideas on how to debug this further? I'm attaching our DB schema here >>> >>> thank you! >>> - Gene >>> >>> -- >>> Supercharge your Review Board with Power Pack: >>> https://www.reviewboard.org/powerpack/ >>> Want us to host Review Board for you? Check out RBCommons: >>> https://rbcommons.com/ >>> Happy user? Let us know! https://www.reviewboard.org/users/ >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "reviewboard" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Christian Hammond >> President/CEO of Beanbag <https://www.beanbaginc.com/> >> Makers of Review Board <https://www.reviewboard.org/> >> > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
-- MySQL dump 10.13 Distrib 5.5.54, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: reviewboard -- ------------------------------------------------------ -- Server version 5.5.54-0ubuntu0.14.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 `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, `permissions` longtext, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`,`local_site_id`), UNIQUE KEY `profile_id` (`profile_id`,`local_site_id`), KEY `accounts_localsiteprofile_403f60f` (`user_id`), KEY `accounts_localsiteprofile_141c6eec` (`profile_id`), KEY `accounts_localsiteprofile_45ded6af` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1; /*!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, `is_private` tinyint(1) NOT NULL, `show_closed` 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, `timezone` varchar(30) NOT NULL, `open_an_issue` tinyint(1) NOT NULL, `extra_data` longtext, `should_send_email` tinyint(1) NOT NULL, `should_send_own_updates` tinyint(1) NOT NULL, `default_use_rich_text` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; /*!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=224 DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`), KEY `accounts_reviewrequestvisit_4085accc` (`review_request_id`) ) ENGINE=MyISAM AUTO_INCREMENT=21438 DEFAULT CHARSET=latin1; /*!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(512) DEFAULT NULL, `mimetype` varchar(256) NOT NULL, `orig_filename` varchar(256) DEFAULT NULL, `repository_id` int(11) DEFAULT NULL, `repo_revision` varchar(64) DEFAULT NULL, `repo_path` varchar(1024) DEFAULT NULL, `added_in_filediff_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `attachments_fileattachment_67165655` (`repository_id`), KEY `attachments_fileattachment_45f35bf2` (`repo_revision`), KEY `attachments_fileattachment_8f8fda86` (`added_in_filediff_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1185 DEFAULT CHARSET=latin1; /*!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 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`), KEY `auth_group_permissions_1e014c8f` (`permission_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_1bb8f392` (`content_type_id`) ) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=latin1; /*!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=116 DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`), KEY `auth_user_groups_425ae3c4` (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`), KEY `auth_user_user_permissions_1e014c8f` (`permission_id`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1; /*!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, `rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12288 DEFAULT CHARSET=latin1; /*!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, `base_commit_id` varchar(64) DEFAULT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `diffviewer_diffset_6c9c0cef` (`history_id`), KEY `diffviewer_diffset_6a730446` (`repository_id`), KEY `diffviewer_diffset_cf5b2e25` (`base_commit_id`) ) ENGINE=MyISAM AUTO_INCREMENT=17368 DEFAULT CHARSET=latin1; /*!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, `last_diff_updated` datetime DEFAULT NULL, `extra_data` longtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6298 DEFAULT CHARSET=latin1; /*!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, `diff_hash_id` varchar(40) DEFAULT NULL, `parent_diff_hash_id` varchar(40) DEFAULT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `diffviewer_filediff_47e4d75c` (`diffset_id`), KEY `diffviewer_filediff_4d02a56a` (`diff_hash_id`), KEY `diffviewer_filediff_79f4fcf6` (`parent_diff_hash_id`) ) ENGINE=MyISAM AUTO_INCREMENT=134798 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `diffviewer_filediffdata` -- DROP TABLE IF EXISTS `diffviewer_filediffdata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `diffviewer_filediffdata` ( `binary_hash` varchar(40) NOT NULL, `binary` longtext NOT NULL, `extra_data` longtext, PRIMARY KEY (`binary_hash`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`), KEY `django_admin_log_1bb8f392` (`content_type_id`) ) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=latin1; /*!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=35 DEFAULT CHARSET=latin1; /*!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_10f4f63` (`version_id`) ) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=latin1; /*!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=4 DEFAULT CHARSET=latin1; /*!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_3da3d3d8` (`expire_date`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `extensions_registeredextension` -- DROP TABLE IF EXISTS `extensions_registeredextension`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `extensions_registeredextension` ( `id` int(11) NOT NULL AUTO_INCREMENT, `class_name` varchar(128) NOT NULL, `name` varchar(32) NOT NULL, `enabled` tinyint(1) NOT NULL, `installed` tinyint(1) NOT NULL, `settings` longtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `class_name` (`class_name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!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, `hosting_url` varchar(255) DEFAULT 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`), KEY `hostingsvcs_hostingserviceaccount_c467b315` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*!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, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `reviews_comment_68a07953` (`issue_status`), KEY `reviews_comment_367cba1f` (`filediff_id`), KEY `reviews_comment_5964ea9c` (`interfilediff_id`), KEY `reviews_comment_2710e4f4` (`reply_to_id`) ) ENGINE=MyISAM AUTO_INCREMENT=25894 DEFAULT CHARSET=latin1; /*!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 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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=latin1; /*!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, `extra_data` longtext, `diff_against_file_attachment_id` int(11) DEFAULT NULL, `rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `reviews_fileattachmentcomment_68a07953` (`issue_status`), KEY `reviews_fileattachmentcomment_370e361d` (`file_attachment_id`), KEY `reviews_fileattachmentcomment_2710e4f4` (`reply_to_id`), KEY `reviews_fileattachmentcomment_ef3a1170` (`diff_against_file_attachment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=998 DEFAULT CHARSET=latin1; /*!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(254) DEFAULT 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, `extra_data` longtext, 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=16 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`), KEY `reviews_group_users_403f60f` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=806 DEFAULT CHARSET=latin1; /*!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, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, `body_top_rich_text` tinyint(1) NOT NULL, `body_bottom_rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `reviews_review_4085accc` (`review_request_id`), KEY `reviews_review_403f60f` (`user_id`), KEY `reviews_review_3534312d` (`base_reply_to_id`), KEY `reviews_review_60551d12` (`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=23639 DEFAULT CHARSET=latin1; /*!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_6fc730f2` (`review_id`), KEY `reviews_review_comments_64c238ac` (`comment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=25894 DEFAULT CHARSET=latin1; /*!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_6fc730f2` (`review_id`), KEY `reviews_review_file_attachment_comments_46f90fd1` (`fileattachmentcomment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=998 DEFAULT CHARSET=latin1; /*!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_6fc730f2` (`review_id`), KEY `reviews_review_screenshot_comments_1997ee92` (`screenshotcomment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1; /*!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, `commit_id` varchar(64) DEFAULT NULL, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, `issue_dropped_count` int(11) DEFAULT NULL, `issue_resolved_count` int(11) DEFAULT NULL, `issue_open_count` int(11) DEFAULT NULL, `description_rich_text` tinyint(1) NOT NULL, `testing_done_rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `changenum` (`changenum`,`repository_id`), UNIQUE KEY `local_site_id` (`local_site_id`,`local_id`), UNIQUE KEY `reviews_reviewrequest_b8c24015` (`commit_id`,`repository_id`), KEY `reviews_reviewrequest_1a37f020` (`submitter_id`), KEY `reviews_reviewrequest_36528e23` (`status`), KEY `reviews_reviewrequest_48dee32a` (`changenum`), KEY `reviews_reviewrequest_6a730446` (`repository_id`), KEY `reviews_reviewrequest_2b6dc0c5` (`diffset_history_id`), KEY `reviews_reviewrequest_45ded6af` (`local_site_id`), KEY `reviews_reviewrequest_3b0377a9` (`commit_id`), KEY `reviews_reviewrequest_summary` (`summary`(255)) ) ENGINE=MyISAM AUTO_INCREMENT=6298 DEFAULT CHARSET=latin1; /*!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=11293 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reviews_reviewrequest_depends_on` -- DROP TABLE IF EXISTS `reviews_reviewrequest_depends_on`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reviews_reviewrequest_depends_on` ( `id` int(11) NOT NULL AUTO_INCREMENT, `from_reviewrequest_id` int(11) NOT NULL, `to_reviewrequest_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `from_reviewrequest_id` (`from_reviewrequest_id`,`to_reviewrequest_id`), KEY `to_reviewrequest_id_refs_id_623cfa96` (`to_reviewrequest_id`) ) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1; /*!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 AUTO_INCREMENT=1439 DEFAULT CHARSET=latin1; /*!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=326 DEFAULT CHARSET=latin1; /*!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 AUTO_INCREMENT=78 DEFAULT CHARSET=latin1; /*!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=370 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3984 DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13279 DEFAULT CHARSET=latin1; /*!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, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, `commit_id` varchar(64) DEFAULT NULL, `description_rich_text` tinyint(1) NOT NULL, `testing_done_rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `review_request_id` (`review_request_id`), KEY `reviews_reviewrequestdraft_47e4d75c` (`diffset_id`), KEY `reviews_reviewrequestdraft_2cb71f85` (`changedesc_id`), KEY `reviews_reviewrequestdraft_3b0377a9` (`commit_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12130 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reviews_reviewrequestdraft_depends_on` -- DROP TABLE IF EXISTS `reviews_reviewrequestdraft_depends_on`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reviews_reviewrequestdraft_depends_on` ( `id` int(11) NOT NULL AUTO_INCREMENT, `reviewrequestdraft_id` int(11) NOT NULL, `reviewrequest_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `reviewrequestdraft_id` (`reviewrequestdraft_id`,`reviewrequest_id`), KEY `reviewrequest_id_refs_id_5a1afe0a` (`reviewrequest_id`) ) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_file_attachments_484aade7` (`fileattachment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2591 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_inactive_file_attachments_484aade7` (`fileattachment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=400 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_inactive_screenshots_62c5ecba` (`screenshot_id`) ) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_screenshots_62c5ecba` (`screenshot_id`) ) ENGINE=MyISAM AUTO_INCREMENT=630 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_target_groups_425ae3c4` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9725 DEFAULT CHARSET=latin1; /*!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_66aaaf32` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_target_people_403f60f` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=32192 DEFAULT CHARSET=latin1; /*!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=343 DEFAULT CHARSET=latin1; /*!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, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `reviews_screenshotcomment_68a07953` (`issue_status`), KEY `reviews_screenshotcomment_62c5ecba` (`screenshot_id`), KEY `reviews_screenshotcomment_2710e4f4` (`reply_to_id`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1; /*!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, `hosting_account_id` int(11) DEFAULT NULL, `archived` tinyint(1) NOT NULL, `archived_timestamp` datetime DEFAULT NULL, `hooks_uuid` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`local_site_id`), UNIQUE KEY `scmtools_repository_8c446842` (`archived_timestamp`,`path`,`local_site_id`), UNIQUE KEY `scmtools_repository_f22c3cf5` (`hooks_uuid`,`local_site_id`), KEY `scmtools_repository_6dbb9a` (`tool_id`), KEY `scmtools_repository_45ded6af` (`local_site_id`), KEY `scmtools_repository_6d9617e0` (`hosting_account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!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_425ae3c4` (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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=9 DEFAULT CHARSET=latin1; /*!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, `public` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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_403f60f` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!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=latin1; /*!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 2017-08-21 1:10:36
