I updated from 1.5.4 to 1.6beta1 to 1.6rc1. The upgrade from 1.5.4 to beta1 was a few months ago and I was new to both reviewboard and django. Maybe I didn't run the rb-site upgrade step after that upgrade? I can't be sure either way now. Upgrading to rc1 was done with easy_install and then running rb-site upgrade.
Schema dump: ======== -- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: reviewboard -- ------------------------------------------------------ -- Server version 5.1.49-3 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `accounts_localsiteprofile` -- DROP TABLE IF EXISTS `accounts_localsiteprofile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accounts_localsiteprofile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `profile_id` int(11) NOT NULL, `local_site_id` int(11) DEFAULT NULL, `direct_incoming_request_count` int(11) DEFAULT NULL, `total_incoming_request_count` int(11) DEFAULT NULL, `pending_outgoing_request_count` int(11) DEFAULT NULL, `total_outgoing_request_count` int(11) DEFAULT NULL, `starred_public_request_count` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`,`local_site_id`), UNIQUE KEY `profile_id` (`profile_id`,`local_site_id`), KEY `accounts_localsiteprofile_fbfc09f1` (`user_id`), KEY `accounts_localsiteprofile_141c6eec` (`profile_id`), KEY `accounts_localsiteprofile_45ded6af` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=27 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, `show_submitted` tinyint(1) NOT NULL, `sort_review_request_columns` varchar(256) NOT NULL, `sort_dashboard_columns` varchar(256) NOT NULL, `sort_submitter_columns` varchar(256) NOT NULL, `sort_group_columns` varchar(256) NOT NULL, `review_request_columns` varchar(256) NOT NULL, `dashboard_columns` varchar(256) NOT NULL, `submitter_columns` varchar(256) NOT NULL, `group_columns` varchar(256) NOT NULL, `is_private` tinyint(1) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=31 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_bda51c3c` (`group_id`) ) ENGINE=MyISAM 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=8 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_fbfc09f1` (`user_id`), KEY `accounts_reviewrequestvisit_bf7a5334` (`review_request_id`) ) ENGINE=MyISAM AUTO_INCREMENT=383 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(100) NOT NULL, `mimetype` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM 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 AUTO_INCREMENT=3 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_bda51c3c` (`group_id`), KEY `auth_group_permissions_1e014c8f` (`permission_id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `auth_message` -- DROP TABLE IF EXISTS `auth_message`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auth_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `message` longtext NOT NULL, PRIMARY KEY (`id`), KEY `auth_message_fbfc09f1` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=60 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_e4470c6e` (`content_type_id`) ) ENGINE=MyISAM AUTO_INCREMENT=97 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=31 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_fbfc09f1` (`user_id`), KEY `auth_user_groups_bda51c3c` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 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_fbfc09f1` (`user_id`), KEY `auth_user_user_permissions_1e014c8f` (`permission_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 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` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=121 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, PRIMARY KEY (`id`), KEY `diffviewer_diffset_6c9c0cef` (`history_id`), KEY `diffviewer_diffset_6a730446` (`repository_id`) ) ENGINE=MyISAM AUTO_INCREMENT=417 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, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=308 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, PRIMARY KEY (`id`), KEY `diffviewer_filediff_47e4d75c` (`diffset_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6889 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_fbfc09f1` (`user_id`), KEY `django_admin_log_e4470c6e` (`content_type_id`) ) ENGINE=MyISAM AUTO_INCREMENT=64 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=32 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_fef0b09d` (`version_id`) ) ENGINE=MyISAM AUTO_INCREMENT=22 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=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_c25c2c28` (`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 `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, `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, `issue_opened` tinyint(1) NOT NULL, `issue_status` varchar(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `reviews_comment_367cba1f` (`filediff_id`), KEY `reviews_comment_a69b1564` (`interfilediff_id`), KEY `reviews_comment_2710e4f4` (`reply_to_id`), KEY `reviews_comment_975f86ad` (`issue_status`) ) ENGINE=MyISAM AUTO_INCREMENT=329 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 AUTO_INCREMENT=6 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_bda51c3c` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 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_fbfc09f1` (`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, PRIMARY KEY (`id`), KEY `reviews_fileattachmentcomment_975f86ad` (`issue_status`), KEY `reviews_fileattachmentcomment_c8f1c9e3` (`file_attachment_id`), KEY `reviews_fileattachmentcomment_2710e4f4` (`reply_to_id`) ) ENGINE=MyISAM DEFAULT CHARSET=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(75) NOT NULL, `local_site_id` int(11) DEFAULT NULL, `incoming_request_count` int(11) DEFAULT NULL, `invite_only` tinyint(1) NOT NULL, `visible` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `reviews_group_45ded6af` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 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_bda51c3c` (`group_id`), KEY `reviews_group_users_fbfc09f1` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=26 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, PRIMARY KEY (`id`), KEY `reviews_review_bf7a5334` (`review_request_id`), KEY `reviews_review_fbfc09f1` (`user_id`), KEY `reviews_review_3534312d` (`base_reply_to_id`), KEY `reviews_review_9faae2ee` (`body_top_reply_to_id`), KEY `reviews_review_4a7afee7` (`body_bottom_reply_to_id`), KEY `reviews_review_54af9375` (`reviewed_diffset_id`) ) ENGINE=MyISAM AUTO_INCREMENT=350 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_9038cf0e` (`review_id`), KEY `reviews_review_comments_9b3dc754` (`comment_id`) ) ENGINE=MyISAM AUTO_INCREMENT=328 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_9038cf0e` (`review_id`), KEY `reviews_review_screenshot_comments_1997ee92` (`screenshotcomment_id`) ) ENGINE=MyISAM 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, PRIMARY KEY (`id`), UNIQUE KEY `changenum` (`changenum`,`repository_id`), KEY `reviews_reviewrequest_1a37f020` (`submitter_id`), KEY `reviews_reviewrequest_c9ad71dd` (`status`), KEY `reviews_reviewrequest_48dee32a` (`changenum`), KEY `reviews_reviewrequest_6a730446` (`repository_id`), KEY `reviews_reviewrequest_d4923f3b` (`diffset_history_id`), KEY `reviews_reviewrequest_45ded6af` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=308 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=117 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 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 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_bda51c3c` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=304 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_fbfc09f1` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=301 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, PRIMARY KEY (`id`), UNIQUE KEY `review_request_id` (`review_request_id`), KEY `reviews_reviewrequestdraft_47e4d75c` (`diffset_id`), KEY `reviews_reviewrequestdraft_d348e07b` (`changedesc_id`) ) ENGINE=MyISAM AUTO_INCREMENT=423 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_995550ce` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_inactive_screenshots_62c5ecba` (`screenshot_id`) ) ENGINE=MyISAM 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_995550ce` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_screenshots_62c5ecba` (`screenshot_id`) ) ENGINE=MyISAM 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_995550ce` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_target_groups_bda51c3c` (`group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=381 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_995550ce` (`reviewrequestdraft_id`), KEY `reviews_reviewrequestdraft_target_people_fbfc09f1` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=469 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 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, `screenshot_id` int(11) NOT NULL, `reply_to_id` int(11) DEFAULT NULL, `timestamp` datetime NOT NULL, `text` longtext NOT NULL, `x` smallint(5) unsigned DEFAULT NULL, `y` smallint(5) unsigned NOT NULL, `w` smallint(5) unsigned NOT NULL, `h` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `reviews_screenshotcomment_62c5ecba` (`screenshot_id`), KEY `reviews_screenshotcomment_2710e4f4` (`reply_to_id`) ) ENGINE=MyISAM 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, PRIMARY KEY (`id`), KEY `scmtools_repository_ff924466` (`tool_id`), KEY `scmtools_repository_45ded6af` (`local_site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 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 `group_id_refs_id_edac6e1f` (`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 `user_id_refs_id_298296b5` (`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, 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_fbfc09f1` (`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_fbfc09f1` (`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` text 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 2011-06-29 13:50:31 On Jun 29, 1:47 pm, Christian Hammond <chip...@chipx86.com> wrote: > Scratch the scratch that. The problem I hit was separate and local to my > setup (didn't fully switch branches in a clean way). So, I can't actually > reproduce this, and I started off with Django 1.2.5 and RB 1.6 beta1 and > went to Django 1.3 and RB RC1, and it worked fine. So we need to figure out > how your database is in an inconsistent state. > > Just to verify, how do you do the upgrade to RC1? > > Can you dump the database schema and send it to me? (No content, just the > schema.) > > Christian > > -- > Christian Hammond - chip...@chipx86.com > Review Board -http://www.reviewboard.org > VMware, Inc. -http://www.vmware.com > > On Wed, Jun 29, 2011 at 1:33 PM, Christian Hammond <chip...@chipx86.com>wrote: > > > > > > > > > Sorry, scratch that. I'm able to reproduce this when going from beta 1 to > > RC1 as well. It has to do with the is_profile. Looking into it. It *does* > > have an evolution file, but it appears that it's not being taken into > > account. > > > Christian > > > -- > > Christian Hammond - chip...@chipx86.com > > Review Board -http://www.reviewboard.org > > VMware, Inc. -http://www.vmware.com > > > On Wed, Jun 29, 2011 at 1:31 PM, Christian Hammond > > <chip...@chipx86.com>wrote: > > >> So what I'm seeing is that some of these evolutions that have been applied > >> are recorded as having already been applied. That most often happens when > >> you've done an upgrade, then tried reverting the schema for some reason > >> (perhaps to downgrade) but never erased the evolution history. You say the > >> database wasn't modified, but did anything ever happen beyond just > >> upgrading > >> from one release to another? > > >> What database are you using? > > >> What version of Review Board did you have installed prior to 1.6 beta 1? > > >> Christian > > >> -- > >> Christian Hammond - chip...@chipx86.com > > >> Review Board -http://www.reviewboard.org > >> VMware, Inc. -http://www.vmware.com > > >> On Wed, Jun 29, 2011 at 1:02 PM, martin <martin.don...@gmail.com> wrote: > > >>> Thanks Christian. > > >>> Screenshot:http://dl.dropbox.com/u/9410307/evolutions.PNG > > >>> #----- Evolution for sessions > >>> from django_evolution.mutations import * > >>> from django.db import models > > >>> MUTATIONS = [ > >>> ChangeField('Session', 'expire_date', initial=None, db_index=True) > >>> ] > >>> #---------------------- > >>> #----- Evolution for accounts > >>> from django_evolution.mutations import * > >>> from django.db import models > > >>> MUTATIONS = [ > >>> AddField('Profile', 'is_private', models.BooleanField, > >>> initial=False) > >>> ] > >>> #---------------------- > >>> #----- Evolution for reviews > >>> from django_evolution.mutations import * > >>> from django.db import models > > >>> MUTATIONS = [ > >>> AddField('Comment', 'issue_opened', models.BooleanField, > >>> initial=False), > >>> AddField('Comment', 'issue_status', models.CharField, > >>> max_length=1, null=True, db_index=True), > >>> AddField('Group', 'local_site', models.ForeignKey, null=True, > >>> related_model='site.LocalSite'), > >>> AddField('Group', 'incoming_request_count', models.CounterField, > >>> null=True), > >>> AddField('Group', 'visible', models.BooleanField, initial=True), > >>> AddField('Group', 'invite_only', models.BooleanField, > >>> initial=False), > >>> ChangeField('Group', 'name', initial=None, unique=False), > >>> AddField('Review', 'file_attachment_comments', > >>> models.ManyToManyField, > >>> related_model='reviews.FileAttachmentComment'), > >>> AddField('ReviewRequestDraft', 'inactive_file_attachments', > >>> models.ManyToManyField, related_model='attachments.FileAttachment'), > >>> AddField('ReviewRequestDraft', 'file_attachments', > >>> models.ManyToManyField, related_model='attachments.FileAttachment'), > >>> AddField('ReviewRequest', 'inactive_file_attachments', > >>> models.ManyToManyField, related_model='attachments.FileAttachment'), > >>> AddField('ReviewRequest', 'local_site', models.ForeignKey, > >>> null=True, related_model='site.LocalSite'), > >>> AddField('ReviewRequest', 'local_id', models.IntegerField, > >>> null=True), > >>> AddField('ReviewRequest', 'file_attachments', > >>> models.ManyToManyField, related_model='attachments.FileAttachment'), > >>> AddField('DefaultReviewer', 'local_site', models.ForeignKey, > >>> null=True, related_model='site.LocalSite'), > >>> AddField('ScreenshotComment', 'issue_opened', models.BooleanField, > >>> initial=False), > >>> AddField('ScreenshotComment', 'issue_status', models.CharField, > >>> max_length=1, null=True, db_index=True) > >>> ] > >>> #---------------------- > >>> #----- Evolution for scmtools > >>> from django_evolution.mutations import * > >>> from django.db import models > > >>> MUTATIONS = [ > >>> AddField('Repository', 'review_groups', models.ManyToManyField, > >>> related_model='reviews.Group'), > >>> AddField('Repository', 'local_site', models.ForeignKey, null=True, > >>> related_model='site.LocalSite'), > >>> AddField('Repository', 'public', models.BooleanField, > >>> initial=True), > >>> AddField('Repository', 'users', models.ManyToManyField, > >>> related_model='auth.User'), > >>> ChangeField('Repository', 'path', initial=None, unique=False), > >>> ChangeField('Repository', 'name', initial=None, unique=False) > >>> ] > >>> #---------------------- > >>> Trial evolution successful. > >>> Run './manage.py evolve --hint --execute' to apply evolution. > > >>> On Jun 29, 12:20 pm, Christian Hammond <chip...@chipx86.com> wrote: > >>> > Those were added before beta 1, but I think the error may be > >>> misleading. It > >>> > mentions "sessions", which is Django-supplied. > > >>> > Can you run: > > >>> > $ rb-site manage /path/to/site evolve -- --hint > > >>> > (Do not run --hint --execute if anyone tells you to) > > >>> > Show me the results of that. > > >>> > Then, go into the admin UI -> Database -> Evolutions and screenshot > >>> that for > >>> > me. I need to see the entire list. You can send that privately, but it > >>> > shouldn't have any confidential info. > > >>> > Christian > > >>> > -- > >>> > Christian Hammond - chip...@chipx86.com > >>> > Review Board -http://www.reviewboard.org > >>> > VMware, Inc. -http://www.vmware.com > > >>> > On Wed, Jun 29, 2011 at 11:54 AM, martin <martin.don...@gmail.com> > >>> wrote: > >>> > > When I run rb-site upgrade /my/site I get the following: > > >>> > > === > >>> > > Rebuilding directory structure > >>> > > Updating database. This may take a while. > >>> > > Creating tables ... > >>> > > Upgrading Review Board from 1.6 beta 1 to 1.6 RC1 > >>> > > There are unapplied evolutions for sessions. > >>> > > There are unapplied evolutions for accounts. > >>> > > There are unapplied evolutions for reviews. > >>> > > Project signature has changed - an evolution is required > >>> > > Installing custom SQL ... > >>> > > Installing indexes ... > >>> > > No fixtures found. > >>> > > /usr/local/lib/python2.6/dist-packages/pycrypto-2.3-py2.6-linux- > >>> > > x86_64.egg/Crypto/Util/randpool.py:40: RandomPool_DeprecationWarning: > >>> > > This application uses RandomPool, which is BROKEN in older releases. > >>> > > Seehttp://www.pycrypto.org/randpool-broken > >>> > > RandomPool_DeprecationWarning) > >>> > > The stored evolutions do not completely resolve all model changes. > >>> > > Run `./manage.py evolve --hint` to see a suggestion for the changes > >>> > > required. > > >>> > > The following are the changes that could not be resolved: > >>> > > In model reviews.DefaultReviewer: > >>> > > Field 'local_site' has been added > >>> > > In model reviews.ReviewRequest: > >>> > > Field 'local_site' has been added > >>> > > Field 'local_id' has been added > >>> > > In model reviews.Group: > >>> > > Field 'local_site' has been added > >>> > > Field 'incoming_request_count' has been added > >>> > > Field 'visible' has been added > >>> > > Field 'invite_only' has been added > >>> > > In field 'name': > >>> > > Property 'unique' has changed > >>> > > In model scmtools.Repository: > >>> > > Field 'review_groups' has been added > >>> > > Field 'local_site' has been added > >>> > > Field 'public' has been added > >>> > > Field 'users' has been added > >>> > > In field 'path': > >>> > > Property 'unique' has changed > >>> > > In field 'name': > >>> > > Property 'unique' has changed > >>> > > Error: Your models contain changes that Django Evolution cannot > >>> > > resolve automatically. > >>> > > === > > >>> > > I haven't made any modifications to the DB structure myself between > >>> > > beta1 and rc1. This upgrade did also include and upgrade from django > >>> > > 1.2.5 to django 1.3, not sure if that effects anything. Can anyone > >>> > > suggest how I would go about resolving this? > > >>> > > -- > >>> > > Want to help the Review Board project? Donate today at > >>> > >http://www.reviewboard.org/donate/ > >>> > > Happy user? Let us know athttp://www.reviewboard.org/users/ > >>> > > -~----------~----~----~----~------~----~------~--~--- > >>> > > To unsubscribe from this group, send email to > >>> > > reviewboard+unsubscr...@googlegroups.com > >>> > > For more options, visit this group at > >>> > >http://groups.google.com/group/reviewboard?hl=en > > >>> -- > >>> Want to help the Review Board project? Donate today at > >>>http://www.reviewboard.org/donate/ > >>> Happy user? Let us know athttp://www.reviewboard.org/users/ > >>> -~----------~----~----~----~------~----~------~--~--- > >>> To unsubscribe from this group, send email to > >>> reviewboard+unsubscr...@googlegroups.com > >>> For more options, visit this group at > >>>http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en