Hello,
I am trying to upgrade rb from 1.0.5 to 2.0.15 (in the attachment the old
db schema)
I am following this steps.
1. Install a fresh new 2.0.15
2. Restore the old 1.0.5 database (in replace of the newer one that I just
installed)
3. Execute rb-site upgrade /var/www/rb.searchrev.com/
But I am getting the following errors.
[root@reviewboard conf]# rb-site upgrade /var/www/rb.searchrev.com/
Rebuilding directory structure
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 extensions_registeredextension
Creating table accounts_localsiteprofile
Creating table attachments_fileattachment
Creating table diffviewer_filediffdata
Creating table hostingsvcs_hostingserviceaccount
Creating table reviews_fileattachmentcomment
Creating table site_localsite_users
Creating table site_localsite_admins
Creating table site_localsite
Upgrading Review Board from 1.0.5.1 to 2.0.15
There are unapplied evolutions for auth.
There are unapplied evolutions for contenttypes.
There are unapplied evolutions for sessions.
There are unapplied evolutions for accounts.
There are unapplied evolutions for attachments.
There are unapplied evolutions for changedescs.
There are unapplied evolutions for diffviewer.
There are unapplied evolutions for hostingsvcs.
There are unapplied evolutions for reviews.
There are unapplied evolutions for scmtools.
There are unapplied evolutions for site.
Adding baseline version for new models
Evolutions in attachments baseline: file_attachment_orig_filename,
file_attachment_file_max_length_512, file_attachment_repo_info,
file_attachment_repo_path_no_index,
file_attachment_repo_revision_max_length_64
Evolutions in site baseline: localsite_public
Evolutions in hostingsvcs baseline: account_hosting_url,
account_hosting_url_max_length_255, account_unique_together_baseline
Project signature has changed - an evolution is required
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
Registering new SCM Tool Plastic SCM
(reviewboard.scmtools.plastic.PlasticTool) in database
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:
The application markup has been deleted
In model reviews.DefaultReviewer:
In field 'repository':
Property 'null' has changed
In model reviews.ReviewRequest:
In field 'repository':
Property 'null' has changed
CommandError: Your models contain changes that Django Evolution cannot
resolve automatically.
In a second attempt I read I need to copy some data from the newer database
in order to complete the upgrade.
in the old database
insert into django_evolution select * from rb_install.django_evolution;
insert into django_project_version select * from
rb_install.django_project_version;
and then try again the upgrade
But after that I am getting this error.
[root@reviewboard conf]# rb-site upgrade /var/www/rb.searchrev.com/
Rebuilding directory structure
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 extensions_registeredextension
Creating table accounts_localsiteprofile
Creating table attachments_fileattachment
Creating table diffviewer_filediffdata
Creating table hostingsvcs_hostingserviceaccount
Creating table reviews_fileattachmentcomment
Creating table site_localsite_users
Creating table site_localsite_admins
Creating table site_localsite
Upgrading Review Board from 1.0.5.1 to 2.0.15
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
Registering new SCM Tool Plastic SCM
(reviewboard.scmtools.plastic.PlasticTool) in database
No evolution required.
------------------- <end log output> -------------------
Resetting in-database caches.
Traceback (most recent call last):
File "/usr/bin/rb-site", line 9, in <module>
load_entry_point('ReviewBoard==2.0.15', 'console_scripts', 'rb-site')()
File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
line 1885, in main
command.run()
File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
line 1698, in run
site.run_manage_command("fixreviewcounts")
File "/usr/lib/python2.7/site-packages/reviewboard/cmdline/rbsite.py",
line 662, in run_manage_command
execute_from_command_line([__file__, cmd] + params)
File
"/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line
399, in execute_from_command_line
utility.execute()
File
"/usr/lib/python2.7/site-packages/django/core/management/__init__.py", line
392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/lib/python2.7/site-packages/django/core/management/base.py",
line 242, in run_from_argv
self.execute(*args, **options.__dict__)
File "/usr/lib/python2.7/site-packages/django/core/management/base.py",
line 285, in execute
output = self.handle(*args, **options)
File "/usr/lib/python2.7/site-packages/django/core/management/base.py",
line 415, in handle
return self.handle_noargs(**options)
File
"/usr/lib/python2.7/site-packages/reviewboard/reviews/management/commands/fixreviewcounts.py",
line 12, in handle_noargs
fix_review_counts()
File "/usr/lib/python2.7/site-packages/reviewboard/accounts/admin.py",
line 137, in fix_review_counts
Group.objects.update(incoming_request_count=None)
File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line
214, in update
return self.get_queryset().update(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line
493, in update
rows = query.get_compiler(self.db).execute_sql(None)
File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 980, in execute_sql
cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 786, in execute_sql
cursor.execute(sql, params)
File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line
53, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.7/site-packages/django/db/utils.py", line 99, in
__exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line
53, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.7/site-packages/django/db/backends/mysql/base.py",
line 124, in execute
return self.cursor.execute(query, args)
File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.OperationalError: (1054, "Unknown column
'incoming_request_count' in 'field list'")
If you can help I really appreciate .
BR
--
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 reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
-- MySQL dump 10.13 Distrib 5.5.41, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: reviewboard
-- ------------------------------------------------------
-- Server version 5.5.41-0ubuntu0.12.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_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,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=45 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 `group_id_refs_id_f1d0eabb` (`group_id`)
) ENGINE=INNODB 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`)
) ENGINE=INNODB AUTO_INCREMENT=14 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_user_id` (`user_id`),
KEY `accounts_reviewrequestvisit_review_request_id` (`review_request_id`)
) ENGINE=INNODB AUTO_INCREMENT=5054 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 AUTO_INCREMENT=4 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 `permission_id_refs_id_a7792de1` (`permission_id`)
) ENGINE=INNODB AUTO_INCREMENT=364 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_user_id` (`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=184 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_content_type_id` (`content_type_id`)
) ENGINE=INNODB AUTO_INCREMENT=85 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=48 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 `group_id_refs_id_f0ee9890` (`group_id`)
) ENGINE=INNODB AUTO_INCREMENT=9 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 `permission_id_refs_id_67e79cb` (`permission_id`)
) ENGINE=INNODB AUTO_INCREMENT=256 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=INNODB AUTO_INCREMENT=1372 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,
`history_id` int(11) DEFAULT NULL,
`repository_id` int(11) NOT NULL,
`diffcompat` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `diffviewer_diffset_history_id` (`history_id`),
KEY `diffviewer_diffset_repository_id` (`repository_id`)
) ENGINE=INNODB AUTO_INCREMENT=4061 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=INNODB AUTO_INCREMENT=2356 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,
PRIMARY KEY (`id`),
KEY `diffviewer_filediff_diffset_id` (`diffset_id`)
) ENGINE=INNODB AUTO_INCREMENT=26839 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_user_id` (`user_id`),
KEY `django_admin_log_content_type_id` (`content_type_id`)
) ENGINE=INNODB AUTO_INCREMENT=167 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=28 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_version_id` (`version_id`)
) ENGINE=INNODB AUTO_INCREMENT=7 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=2 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`)
) 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 `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,
PRIMARY KEY (`id`),
KEY `reviews_comment_filediff_id` (`filediff_id`),
KEY `reviews_comment_interfilediff_id` (`interfilediff_id`),
KEY `reviews_comment_reply_to_id` (`reply_to_id`)
) ENGINE=INNODB AUTO_INCREMENT=759 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,
PRIMARY KEY (`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 `group_id_refs_id_26ae5c3c` (`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 `user_id_refs_id_62bc5f6c` (`user_id`)
) ENGINE=INNODB 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,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=INNODB AUTO_INCREMENT=4 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 `user_id_refs_id_5b8bf0e9` (`user_id`),
KEY `group_users__group_user` (`group_id`,`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=162 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_review_request_id` (`review_request_id`),
KEY `reviews_review_user_id` (`user_id`),
KEY `reviews_review_base_reply_to_id` (`base_reply_to_id`),
KEY `reviews_review_body_top_reply_to_id` (`body_top_reply_to_id`),
KEY `reviews_review_body_bottom_reply_to_id` (`body_bottom_reply_to_id`),
KEY `reviews_review_reviewed_diffset_id` (`reviewed_diffset_id`)
) ENGINE=INNODB AUTO_INCREMENT=3173 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 `comment_id_refs_id_fdbb0d2f` (`comment_id`)
) ENGINE=INNODB AUTO_INCREMENT=759 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 `screenshotcomment_id_refs_id_24c2082d` (`screenshotcomment_id`)
) ENGINE=INNODB 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) NOT 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,
PRIMARY KEY (`id`),
UNIQUE KEY `changenum` (`changenum`,`repository_id`),
KEY `reviews_reviewrequest_submitter_id` (`submitter_id`),
KEY `reviews_reviewrequest_status` (`status`),
KEY `reviews_reviewrequest_changenum` (`changenum`),
KEY `reviews_reviewrequest_repository_id` (`repository_id`),
KEY `reviews_reviewrequest_diffset_history_id` (`diffset_history_id`)
) ENGINE=INNODB AUTO_INCREMENT=2356 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 `changedescription_id_refs_id_f7b94348` (`changedescription_id`)
) ENGINE=INNODB AUTO_INCREMENT=1206 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 `screenshot_id_refs_id_10b11c4c` (`screenshot_id`)
) ENGINE=INNODB 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 `screenshot_id_refs_id_3e4abe6d` (`screenshot_id`)
) ENGINE=INNODB AUTO_INCREMENT=17 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 `group_id_refs_id_1e6c8414` (`group_id`)
) ENGINE=INNODB AUTO_INCREMENT=1492 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 `user_id_refs_id_4dfd3814` (`user_id`),
KEY `reviewrequest_target_people__reviewrequest_user` (`reviewrequest_id`,`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=2295 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_diffset_id` (`diffset_id`),
KEY `reviews_reviewrequestdraft_changedesc_id` (`changedesc_id`)
) ENGINE=INNODB AUTO_INCREMENT=3133 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 `screenshot_id_refs_id_9bfd3b48` (`screenshot_id`)
) ENGINE=INNODB AUTO_INCREMENT=4 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 `screenshot_id_refs_id_f4164ceb` (`screenshot_id`)
) ENGINE=INNODB AUTO_INCREMENT=42 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 `group_id_refs_id_d52232fc` (`group_id`)
) ENGINE=INNODB AUTO_INCREMENT=2751 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 `user_id_refs_id_5ff3d698` (`user_id`)
) ENGINE=INNODB AUTO_INCREMENT=4637 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=17 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_screenshot_id` (`screenshot_id`),
KEY `reviews_screenshotcomment_reply_to_id` (`reply_to_id`)
) ENGINE=INNODB 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(128) NOT NULL,
`mirror_path` varchar(128) 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,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `path` (`path`),
KEY `scmtools_repository_tool_id` (`tool_id`)
) ENGINE=INNODB AUTO_INCREMENT=3 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=8 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_site_id` (`site_id`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping events for database 'reviewboard'
--
--
-- Dumping routines for database 'reviewboard'
--
/*!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 2015-04-10 9:46:15
