Hi Christian, I (re) tried this procedure of creating a dump from production, creating a database on a test server, changing the engine to InnoDB for 64 tables and, running the rb-site upgrade. Still, it's failing somewhere, but I'm able to capture the log message from the upgrade failure, the first after using a pristine DB copy from the production.
root@test:~# rb-site upgrade /var/www/netcomm-codereviews 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 ... Creating table accounts_trophy Creating table attachments_fileattachmenthistory Creating table diffviewer_rawfilediffdata Creating table notifications_webhooktarget_repositories Creating table notifications_webhooktarget Creating table webapi_webapitoken Upgrading Review Board from 2.0.25 to 2.5.15 There are unapplied evolutions for accounts. There are unapplied evolutions for attachments. There are unapplied evolutions for diffviewer. There are unapplied evolutions for notifications. There are unapplied evolutions for reviews. There are unapplied evolutions for webapi. Adding baseline version for new models Evolutions in notifications baseline: webhooktarget_extra_state, webhooktarget_extra_data_null 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... Applying database evolutions for attachments... Applying database evolutions for diffviewer... Database evolutions for diffviewer failed! The SQL statement was: CREATE INDEX `diffviewer_filediff_4d02a56a` ON `diffviewer_filediff` (`raw_diff_hash_id`); The database error was: (1061, "Duplicate key name 'diffviewer_filediff_4d02a56a'") CommandError: Error applying evolution for diffviewer: (1061, "Duplicate key name 'diffviewer_filediff_4d02a56a'") ----------------------------------------------------------------------------------------------------------- By the time it failed it has created at least 5 tables. Seems like it's hard to tell what is causing the duplicate key name on table indexes. Attaching here are the latest schema post-upgrade failure but hey! thanks so much for helping me out on this one :) -Gene On Tue, 22 Aug 2017 at 17:10 Christian Hammond <[email protected]> wrote: > Hi Gene, > > The schema looks healthy at first glance. It seems like a normal 2.0.x > schema, and one that would be safe to upgrade to 2.5.x. > > I don't know what the original error was that you hit (the one in the > original post here was due to a subsequent attempt at upgrading a database > that already failed in a way we couldn't recover from), but one possible > cause of failures would be the table engine type. > > Old versions of MySQL used MyISAM as the table type (the ENGINE= lines in > the schema). Newer MySQL versions (from the past several years onward) > default to InnoDB for any new tables (and 2.5.x would introduce new > tables). If you have a mix of table types, MySQL can end up throwing > confusing errors when attempting to create any relations between those > tables. It's something I'd love for us to be able to catch, but it's pretty > much a MySQL responsibility. > > While I don't know if you hit an error related to that, what you might > want to try doing is converting your schema to use InnoDB for all tables. > You can do a full database dump from the production server, change all > ENGINE=MyISAM entries to ENGINE=InnoDB, and then load the database into the > test server. Then attempt an upgrade, and see if it goes through > successfully. > > If it doesn't succeed, show me the full output, and I'll probably be able > to narrow it down. > > Christian > > On Sun, Aug 20, 2017 at 6:25 PM, Gene Paul Quevedo <[email protected] > > wrote: > >> Oops looks like you might be right. Anyway here's our schema direct >> coming from our production site. >> >> Previously we were running 2.0.20, and the upgrade went smooth if I >> recall. >> >> On Monday, 21 August 2017 10:23:03 UTC+10, Gene Paul Quevedo wrote: >>> >>> hi Christian >>> >>> The schema is from 2.0.25. It was from a snapshot of our test server >>> before the upgrade was performed. If there's a suspicion I could generate >>> again the schema coming from ou production server, which runs 2.0.25 >>> >>> On Tuesday, 15 August 2017 09:49:09 UTC+10, Christian Hammond wrote: >>>> >>>> Hi Gene, >>>> >>>> Looks like there was a partial attempt at an evolution that failed once >>>> before. The "visibility" column was applied and then something apparently >>>> went wrong, or upgrading was cancelled. Deleting the duplicates and running >>>> again would lead to this, unless carefully handled in a way compatible with >>>> django-evolution's internals. >>>> >>>> Is this database schema the initial one applied from 2.0.25, or what >>>> you have on the test server after the upgrade attempts? >>>> >>>> Christian >>>> >>>> On Sun, Aug 13, 2017 at 8:40 PM, Gene Paul Quevedo <[email protected] >>>> > wrote: >>>> >>>>> Hi, >>>>> >>>>> I'ts my first time to post here, and I hope someone can point me to >>>>> the right way of solving this issue, even though it seems like there were >>>>> issues like this before >>>>> >>>>> I'm trying to do a DB upgrade of Review from 2.0.25 to 2.5.15 on a >>>>> test server with a copy of our Database, and seems like it has bumped into >>>>> this issue >>>>> >>>>> Rebuilding directory structure >>>>> Upgrading site settings_local.py >>>>> Updating database. This may take a while. >>>>> >>>>> The log output below, including warnings and errors, >>>>> can be ignored unless upgrade fails. >>>>> >>>>> ------------------ <begin log output> ------------------ >>>>> Creating tables ... >>>>> There are unapplied evolutions for accounts. >>>>> There are unapplied evolutions for attachments. >>>>> There are unapplied evolutions for diffviewer. >>>>> There are unapplied evolutions for reviews. >>>>> There are unapplied evolutions for webapi. >>>>> Project signature has changed - an evolution is required >>>>> Installing custom SQL ... >>>>> Installing indexes ... >>>>> Installed 0 object(s) from 0 fixture(s) >>>>> >>>>> This may take a while. Please be patient, and do not cancel the >>>>> upgrade! >>>>> >>>>> Applying database evolutions for accounts... >>>>> Database evolutions for accounts failed! >>>>> The SQL statement was: (u'ALTER TABLE `accounts_reviewrequestvisit` >>>>> ADD COLUMN `visibility` varchar(1) NOT NULL DEFAULT %s;', [u'V']) >>>>> >>>>> >>>>> >>>>> *The database error was: (1060, "Duplicate column name >>>>> 'visibility'")CommandError: Error applying evolution for accounts: (1060, >>>>> "Duplicate column name 'visibility'")* >>>>> There are probably 4 variations of that 'duplicate column' error, and >>>>> the other one is a 'duplicate index' . >>>>> My initial solution was to delete the duplicates and run the upgrade >>>>> procedure again, but seems like the duplication seems to be repeating (!), >>>>> as if Django Evolution is creating those duplicate columns/indices >>>>> >>>>> Any ideas on how to debug this further? I'm attaching our DB schema >>>>> here >>>>> >>>>> thank you! >>>>> - Gene >>>>> >>>>> -- >>>>> Supercharge your Review Board with Power Pack: >>>>> https://www.reviewboard.org/powerpack/ >>>>> Want us to host Review Board for you? Check out RBCommons: >>>>> https://rbcommons.com/ >>>>> Happy user? Let us know! https://www.reviewboard.org/users/ >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "reviewboard" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> >>>> >>>> -- >>>> Christian Hammond >>>> President/CEO of Beanbag <https://www.beanbaginc.com/> >>>> Makers of Review Board <https://www.reviewboard.org/> >>>> >>> -- >> Supercharge your Review Board with Power Pack: >> https://www.reviewboard.org/powerpack/ >> Want us to host Review Board for you? Check out RBCommons: >> https://rbcommons.com/ >> Happy user? Let us know! https://www.reviewboard.org/users/ >> --- >> You received this message because you are subscribed to the Google Groups >> "reviewboard" group. >> > To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> > >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Christian Hammond > President/CEO of Beanbag <https://www.beanbaginc.com/> > Makers of Review Board <https://www.reviewboard.org/> > > -- > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > Happy user? Let us know! https://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to a topic in the > Google Groups "reviewboard" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/reviewboard/NZ33huj8f8A/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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=229 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, 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`,`visibility`) ) ENGINE=InnoDB AUTO_INCREMENT=21866 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 `review_request_id_refs_id_7fc332cd` FOREIGN KEY (`review_request_id`) REFERENCES `reviews_reviewrequest` (`id`), CONSTRAINT `local_site_id_refs_id_babe9a5d` FOREIGN KEY (`local_site_id`) REFERENCES `site_localsite` (`id`), CONSTRAINT `user_id_refs_id_835b8c07` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `attachments_fileattachment` -- DROP TABLE IF EXISTS `attachments_fileattachment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attachments_fileattachment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `caption` varchar(256) NOT NULL, `draft_caption` varchar(256) NOT NULL, `file` varchar(512) DEFAULT NULL, `mimetype` varchar(256) NOT NULL, `orig_filename` varchar(256) DEFAULT NULL, `repository_id` int(11) DEFAULT NULL, `repo_revision` varchar(64) DEFAULT NULL, `repo_path` varchar(1024) DEFAULT NULL, `added_in_filediff_id` int(11) DEFAULT NULL, `attachment_revision` int(11) NOT 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=1259 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=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=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=12506 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=17589 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=6401 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, `raw_diff_hash_id` int(11) DEFAULT NULL, `raw_parent_diff_hash_id` int(11) DEFAULT NULL, 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=136300 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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `django_admin_log` -- DROP TABLE IF EXISTS `django_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `django_admin_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_time` datetime NOT NULL, `user_id` int(11) NOT NULL, `content_type_id` int(11) DEFAULT NULL, `object_id` longtext, `object_repr` varchar(200) NOT NULL, `action_flag` smallint(5) unsigned NOT NULL, `change_message` longtext NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_403f60f` (`user_id`), KEY `django_admin_log_1bb8f392` (`content_type_id`) ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `django_content_type` -- DROP TABLE IF EXISTS `django_content_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `django_content_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `app_label` (`app_label`,`model`) ) ENGINE=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=4 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=latin1; /*!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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reviews_comment` -- DROP TABLE IF EXISTS `reviews_comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reviews_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `issue_opened` tinyint(1) NOT NULL, `issue_status` varchar(1) DEFAULT NULL, `filediff_id` int(11) NOT NULL, `interfilediff_id` int(11) DEFAULT NULL, `reply_to_id` int(11) DEFAULT NULL, `timestamp` datetime NOT NULL, `text` longtext NOT NULL, `first_line` int(10) unsigned DEFAULT NULL, `num_lines` int(10) unsigned DEFAULT NULL, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, PRIMARY KEY (`id`), KEY `reviews_comment_68a07953` (`issue_status`), KEY `reviews_comment_367cba1f` (`filediff_id`), KEY `reviews_comment_5964ea9c` (`interfilediff_id`), KEY `reviews_comment_2710e4f4` (`reply_to_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26135 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=1200 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=806 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reviews_review` -- DROP TABLE IF EXISTS `reviews_review`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reviews_review` ( `id` int(11) NOT NULL AUTO_INCREMENT, `review_request_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `timestamp` datetime NOT NULL, `public` tinyint(1) NOT NULL, `ship_it` tinyint(1) NOT NULL, `base_reply_to_id` int(11) DEFAULT NULL, `email_message_id` varchar(255) DEFAULT NULL, `time_emailed` datetime DEFAULT NULL, `body_top` longtext NOT NULL, `body_bottom` longtext NOT NULL, `body_top_reply_to_id` int(11) DEFAULT NULL, `body_bottom_reply_to_id` int(11) DEFAULT NULL, `reviewed_diffset_id` int(11) DEFAULT NULL, `rich_text` tinyint(1) NOT NULL, `extra_data` longtext, `body_top_rich_text` tinyint(1) NOT NULL, `body_bottom_rich_text` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `reviews_review_4085accc` (`review_request_id`), KEY `reviews_review_403f60f` (`user_id`), KEY `reviews_review_3534312d` (`base_reply_to_id`), KEY `reviews_review_60551d12` (`body_top_reply_to_id`), KEY `reviews_review_4a7afee7` (`body_bottom_reply_to_id`), KEY `reviews_review_54af9375` (`reviewed_diffset_id`) ) ENGINE=InnoDB AUTO_INCREMENT=24100 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=26135 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=1200 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=6401 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=11500 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=45 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=1554 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=342 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=4079 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=13498 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=12355 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=103 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=2761 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=416 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=9943 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=32736 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=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scmtools_repository_review_groups` -- DROP TABLE IF EXISTS `scmtools_repository_review_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scmtools_repository_review_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `repository_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `repository_id` (`repository_id`,`group_id`), KEY `scmtools_repository_review_groups_6a730446` (`repository_id`), KEY `scmtools_repository_review_groups_425ae3c4` (`group_id`) ) ENGINE=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=latin1; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-08-29 3:07:13
