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.
-- 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=211 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, `visibility` varchar(1) NOT NULL DEFAULT 'V', 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`), KEY `accounts_reviewrequestvisit_05ee5d21` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=20761 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `accounts_trophy` -- DROP TABLE IF EXISTS `accounts_trophy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accounts_trophy` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` varchar(100) NOT NULL, `received_date` datetime NOT NULL, `review_request_id` int(11) NOT NULL, `local_site_id` int(11) DEFAULT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `accounts_trophy_17900555` (`review_request_id`), KEY `accounts_trophy_c467b315` (`local_site_id`), KEY `accounts_trophy_6340c63c` (`user_id`), CONSTRAINT `local_site_id_refs_id_babe9a5d` FOREIGN KEY (`local_site_id`) REFERENCES `site_localsite` (`id`), CONSTRAINT `review_request_id_refs_id_7fc332cd` FOREIGN KEY (`review_request_id`) REFERENCES `reviews_reviewrequest` (`id`), CONSTRAINT `user_id_refs_id_835b8c07` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB 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(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, `attachment_history_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`), KEY `attachments_fileattachment_6a9291ac` (`attachment_history_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1094 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `attachments_fileattachmenthistory` -- DROP TABLE IF EXISTS `attachments_fileattachmenthistory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attachments_fileattachmenthistory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `display_position` int(11) NOT NULL, `latest_revision` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=124 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=11849 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=InnoDB AUTO_INCREMENT=16707 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=InnoDB AUTO_INCREMENT=6113 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=InnoDB AUTO_INCREMENT=128754 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=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `diffviewer_rawfilediffdata` -- DROP TABLE IF EXISTS `diffviewer_rawfilediffdata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `diffviewer_rawfilediffdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `binary_hash` varchar(40) NOT NULL, `binary` longblob NOT NULL, `compression` varchar(1) DEFAULT NULL, `extra_data` longtext, PRIMARY KEY (`id`), UNIQUE KEY `binary_hash` (`binary_hash`) ) ENGINE=InnoDB 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_403f60f` (`user_id`), KEY `django_admin_log_1bb8f392` (`content_type_id`) ) ENGINE=InnoDB AUTO_INCREMENT=145 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=InnoDB AUTO_INCREMENT=41 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=InnoDB AUTO_INCREMENT=79 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=InnoDB AUTO_INCREMENT=5 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications_webhooktarget` -- DROP TABLE IF EXISTS `notifications_webhooktarget`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications_webhooktarget` ( `id` int(11) NOT NULL AUTO_INCREMENT, `enabled` tinyint(1) NOT NULL, `events` varchar(105) NOT NULL, `url` varchar(200) NOT NULL, `encoding` varchar(40) NOT NULL, `use_custom_content` tinyint(1) NOT NULL, `custom_content` longtext, `secret` varchar(128) NOT NULL, `apply_to` varchar(1) NOT NULL, `local_site_id` int(11) DEFAULT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `notifications_webhooktarget_c467b315` (`local_site_id`), CONSTRAINT `local_site_id_refs_id_fd45c4e8` FOREIGN KEY (`local_site_id`) REFERENCES `site_localsite` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `notifications_webhooktarget_repositories` -- DROP TABLE IF EXISTS `notifications_webhooktarget_repositories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications_webhooktarget_repositories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `webhooktarget_id` int(11) NOT NULL, `repository_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `webhooktarget_id` (`webhooktarget_id`,`repository_id`), KEY `notifications_webhooktarget_repositories_69be96ee` (`webhooktarget_id`), KEY `notifications_webhooktarget_repositories_a322ed1e` (`repository_id`), CONSTRAINT `webhooktarget_id_refs_id_d5ae3ed2` FOREIGN KEY (`webhooktarget_id`) REFERENCES `notifications_webhooktarget` (`id`), CONSTRAINT `repository_id_refs_id_c926fd2a` FOREIGN KEY (`repository_id`) REFERENCES `scmtools_repository` (`id`) ) ENGINE=InnoDB 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, `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=InnoDB AUTO_INCREMENT=24763 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=882 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=InnoDB 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=InnoDB AUTO_INCREMENT=800 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=InnoDB AUTO_INCREMENT=22848 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=InnoDB AUTO_INCREMENT=24763 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=InnoDB AUTO_INCREMENT=882 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=InnoDB 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=InnoDB AUTO_INCREMENT=6113 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=InnoDB AUTO_INCREMENT=10886 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=InnoDB 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=InnoDB AUTO_INCREMENT=1296 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=InnoDB AUTO_INCREMENT=318 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=3822 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=InnoDB AUTO_INCREMENT=12882 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=InnoDB AUTO_INCREMENT=11673 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=InnoDB 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=InnoDB AUTO_INCREMENT=2394 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=InnoDB AUTO_INCREMENT=392 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=9229 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=InnoDB AUTO_INCREMENT=30958 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=5 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB 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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `webapi_webapitoken` -- DROP TABLE IF EXISTS `webapi_webapitoken`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webapi_webapitoken` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `token` varchar(40) NOT NULL, `time_added` datetime NOT NULL, `last_updated` datetime NOT NULL, `note` longtext NOT NULL, `policy` longtext, `extra_data` longtext, `local_site_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `token` (`token`), KEY `webapi_webapitoken_6340c63c` (`user_id`), KEY `webapi_webapitoken_c467b315` (`local_site_id`), CONSTRAINT `local_site_id_refs_id_38cf9f6f` FOREIGN KEY (`local_site_id`) REFERENCES `site_localsite` (`id`), CONSTRAINT `user_id_refs_id_ceac17a9` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB 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 2017-08-14 3:10:10
