Skip to content

Instantly share code, notes, and snippets.

@autrilla

autrilla/original_schema.txt

Created September 20, 2018 12:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save autrilla/7d34cb941934a8329eb69c924e42be0d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save autrilla/7d34cb941934a8329eb69c924e42be0d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
original_schema.txt
CREATE TABLE `abuse_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`reporter_id` int(11) DEFAULT NULL,
`ip_address` varchar(255) NOT NULL,
`addon_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`message` longtext NOT NULL,
`guid` char(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `reporter_id_refs_id_12d88e23` (`reporter_id`),
KEY `user_id_refs_id_12d88e23` (`user_id`),
KEY `addon_id_refs_id_2b6ff2a7` (`addon_id`),
KEY `created_idx` (`created`),
CONSTRAINT `addon_id_refs_id_2b6ff2a7` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`),
CONSTRAINT `reporter_id_refs_id_12d88e23` FOREIGN KEY (`reporter_id`) REFERENCES `users` (`id`),
CONSTRAINT `user_id_refs_id_12d88e23` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=84406 DEFAULT CHARSET=utf8
CREATE TABLE `addons` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`guid` varchar(255) DEFAULT NULL,
`name` int(11) unsigned DEFAULT NULL,
`slug` varchar(30) DEFAULT NULL,
`defaultlocale` varchar(10) NOT NULL DEFAULT 'en-US',
`addontype_id` int(11) unsigned NOT NULL DEFAULT '0',
`status` tinyint(2) unsigned NOT NULL DEFAULT '0',
`icontype` varchar(25) NOT NULL DEFAULT '',
`homepage` int(11) unsigned DEFAULT NULL,
`supportemail` int(11) unsigned DEFAULT NULL,
`supporturl` int(11) unsigned DEFAULT NULL,
`description` int(11) unsigned DEFAULT NULL,
`summary` int(11) unsigned DEFAULT NULL,
`averagerating` float NOT NULL DEFAULT '0',
`bayesianrating` float NOT NULL DEFAULT '0',
`totalreviews` int(11) NOT NULL DEFAULT '0',
`weeklydownloads` int(11) unsigned NOT NULL DEFAULT '0',
`totaldownloads` int(11) unsigned NOT NULL DEFAULT '0',
`average_daily_users` int(11) unsigned NOT NULL DEFAULT '0',
`developercomments` int(11) unsigned DEFAULT NULL,
`inactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`viewsource` tinyint(1) unsigned NOT NULL DEFAULT '0',
`publicstats` tinyint(1) unsigned NOT NULL DEFAULT '0',
`externalsoftware` tinyint(1) unsigned NOT NULL DEFAULT '0',
`eula` int(11) unsigned DEFAULT NULL,
`privacypolicy` int(11) unsigned DEFAULT NULL,
`target_locale` varchar(255) DEFAULT NULL,
`locale_disambiguation` varchar(255) DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_updated` datetime DEFAULT NULL,
`current_version` int(11) unsigned DEFAULT NULL,
`hotness` double NOT NULL DEFAULT '0',
`auto_repackage` tinyint(1) NOT NULL DEFAULT '1',
`whiteboard` longtext,
`experimental` tinyint(1) NOT NULL DEFAULT '0',
`reputation` smallint(6) DEFAULT NULL,
`requires_payment` tinyint(1) DEFAULT '0',
`contributions` varchar(255) DEFAULT NULL,
`textreviewscount` int(11) DEFAULT '0',
`icon_hash` char(8) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `guid` (`guid`),
UNIQUE KEY `slug` (`slug`),
KEY `addontype_id` (`addontype_id`),
KEY `addons_ibfk_3` (`homepage`),
KEY `addons_ibfk_4` (`description`),
KEY `addons_ibfk_5` (`summary`),
KEY `addons_ibfk_6` (`developercomments`),
KEY `addons_ibfk_7` (`eula`),
KEY `addons_ibfk_8` (`privacypolicy`),
KEY `status` (`status`),
KEY `inactive` (`inactive`),
KEY `supporturl` (`supporturl`),
KEY `supportemail` (`supportemail`),
KEY `target_locale` (`target_locale`),
KEY `bayesianrating` (`bayesianrating`),
KEY `last_updated` (`last_updated`),
KEY `current_version` (`current_version`),
KEY `created_idx` (`created`),
KEY `modified_idx` (`modified`),
KEY `weeklydownloads_idx` (`weeklydownloads`),
KEY `rating_type_idx` (`bayesianrating`,`addontype_id`),
KEY `created_type_idx` (`created`,`addontype_id`),
KEY `modified_type_idx` (`modified`,`addontype_id`),
KEY `downloads_type_idx` (`weeklydownloads`,`addontype_id`),
KEY `last_updated_type_idx` (`last_updated`,`addontype_id`),
KEY `type_status_inactive_idx` (`addontype_id`,`status`,`inactive`),
KEY `hotness_idx` (`hotness`),
KEY `visible_idx` (`addontype_id`,`status`,`inactive`,`current_version`),
KEY `adus_type_idx` (`average_daily_users`,`addontype_id`),
KEY `name_2` (`name`,`status`,`addontype_id`),
CONSTRAINT `addons_ibfk_10` FOREIGN KEY (`supportemail`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_14` FOREIGN KEY (`current_version`) REFERENCES `versions` (`id`) ON DELETE SET NULL,
CONSTRAINT `addons_ibfk_2` FOREIGN KEY (`name`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_3` FOREIGN KEY (`homepage`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_4` FOREIGN KEY (`description`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_5` FOREIGN KEY (`summary`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_6` FOREIGN KEY (`developercomments`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_7` FOREIGN KEY (`eula`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_8` FOREIGN KEY (`privacypolicy`) REFERENCES `translations` (`id`),
CONSTRAINT `addons_ibfk_9` FOREIGN KEY (`supporturl`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=998388 DEFAULT CHARSET=utf8
CREATE TABLE `addons_addonapprovalscounter` (
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`addon_id` int(10) unsigned NOT NULL,
`counter` int(10) unsigned NOT NULL,
`last_human_review` datetime(6) DEFAULT NULL,
`last_content_review` datetime(6) DEFAULT NULL,
PRIMARY KEY (`addon_id`),
CONSTRAINT `addon_id_refs_id_8fcb7166` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `addons_addonfeaturecompatibility` (
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`addon_id` int(11) unsigned NOT NULL,
`e10s` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`addon_id`),
CONSTRAINT `addon_id_refs_id_7779cd14` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `addons_addonreviewerflags` (
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`addon_id` int(10) unsigned NOT NULL,
`needs_admin_code_review` tinyint(1) NOT NULL,
`needs_admin_content_review` tinyint(1) NOT NULL,
`auto_approval_disabled` tinyint(1) NOT NULL DEFAULT '0',
`pending_info_request` datetime(6) DEFAULT NULL,
`notified_about_expiring_info_request` tinyint(1) NOT NULL DEFAULT '0',
`needs_admin_theme_review` tinyint(1) NOT NULL,
PRIMARY KEY (`addon_id`),
CONSTRAINT `addon_id_refs_id_7a280313` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `addons_categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`category_id` int(11) unsigned NOT NULL DEFAULT '0',
`feature` int(1) unsigned NOT NULL DEFAULT '0',
`feature_locales` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id` (`addon_id`,`category_id`),
KEY `category_addon_idx` (`category_id`,`addon_id`),
KEY `feature_addon_idx` (`feature`,`addon_id`),
CONSTRAINT `addons_categories_ibfk_3` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `addons_categories_ibfk_4` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1250701 DEFAULT CHARSET=utf8
CREATE TABLE `addons_collections` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL,
`collection_id` int(11) unsigned NOT NULL,
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`category` tinyint(3) unsigned DEFAULT NULL COMMENT 'for interactive collections template',
`comments` int(11) unsigned DEFAULT NULL,
`downloads` int(11) DEFAULT '0',
`user_id` int(11) DEFAULT NULL,
`modified` datetime DEFAULT '0000-00-00 00:00:00',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id_2` (`addon_id`,`collection_id`),
KEY `addon_id` (`addon_id`),
KEY `collection_id` (`collection_id`),
KEY `user_id` (`user_id`),
KEY `comments` (`comments`),
KEY `created_idx` (`collection_id`,`created`),
CONSTRAINT `addons_collections_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `addons_collections_ibfk_2` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`) ON DELETE CASCADE,
CONSTRAINT `addons_collections_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `addons_collections_ibfk_4` FOREIGN KEY (`comments`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50099496 DEFAULT CHARSET=utf8
CREATE TABLE `addons_denied_slug` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8
CREATE TABLE `addons_dependencies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addon_id` int(11) NOT NULL,
`dependent_addon_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id` (`addon_id`,`dependent_addon_id`),
KEY `addons_dependencies_addon_id_key` (`addon_id`),
KEY `addons_dependencies_dependent_addon_id_key` (`dependent_addon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=492 DEFAULT CHARSET=utf8
CREATE TABLE `addons_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`role` tinyint(2) unsigned NOT NULL DEFAULT '5',
`listed` tinyint(1) unsigned NOT NULL DEFAULT '1',
`position` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id` (`addon_id`,`user_id`),
KEY `user_id` (`user_id`),
KEY `listed` (`listed`),
KEY `addon_user_listed_idx` (`addon_id`,`user_id`,`listed`),
KEY `addon_listed_idx` (`addon_id`,`listed`),
CONSTRAINT `addons_users_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `addons_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1362481 DEFAULT CHARSET=utf8
CREATE TABLE `akismet_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`comment_type` varchar(255) NOT NULL,
`user_ip` varchar(255) NOT NULL,
`user_agent` varchar(255) NOT NULL,
`referrer` varchar(255) NOT NULL,
`user_name` varchar(255) NOT NULL,
`user_email` varchar(255) NOT NULL,
`user_homepage` varchar(255) NOT NULL,
`comment` longtext NOT NULL,
`comment_modified` datetime(6) NOT NULL,
`content_link` varchar(255) NOT NULL,
`content_modified` datetime(6) NOT NULL,
`result` smallint(5) unsigned DEFAULT NULL,
`reported` tinyint(1) NOT NULL,
`rating_instance_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `akismet_reports_rating_instance_id_d282058c_fk_reviews_id` (`rating_instance_id`),
CONSTRAINT `akismet_reports_rating_instance_id_d282058c_fk_reviews_id` FOREIGN KEY (`rating_instance_id`) REFERENCES `reviews` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1427 DEFAULT CHARSET=utf8
CREATE TABLE `api_key` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` int(11) unsigned NOT NULL DEFAULT '1',
`key` varchar(255) NOT NULL,
`secret` longtext NOT NULL,
`is_active` tinyint(1) DEFAULT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`),
UNIQUE KEY `user_id` (`user_id`,`is_active`),
KEY `api_key_user_id` (`user_id`),
CONSTRAINT `api_key_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108356 DEFAULT CHARSET=utf8
CREATE TABLE `applications_versions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`application_id` int(11) unsigned NOT NULL DEFAULT '0',
`version_id` int(11) unsigned NOT NULL DEFAULT '0',
`min` int(11) unsigned NOT NULL DEFAULT '0',
`max` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `application_id` (`application_id`,`version_id`),
KEY `version_id` (`version_id`),
KEY `min` (`min`),
KEY `max` (`max`),
CONSTRAINT `applications_versions_ibfk_4` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`) ON DELETE CASCADE,
CONSTRAINT `applications_versions_ibfk_5` FOREIGN KEY (`min`) REFERENCES `appversions` (`id`),
CONSTRAINT `applications_versions_ibfk_6` FOREIGN KEY (`max`) REFERENCES `appversions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1463421 DEFAULT CHARSET=utf8
CREATE TABLE `appsupport` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`addon_id` int(11) unsigned NOT NULL,
`app_id` int(11) unsigned NOT NULL,
`min` bigint(20) unsigned DEFAULT NULL,
`max` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id` (`addon_id`,`app_id`),
KEY `app_id_refs_id_481ce338` (`app_id`),
KEY `minmax_idx` (`addon_id`,`app_id`,`min`,`max`)
) ENGINE=InnoDB AUTO_INCREMENT=4056958 DEFAULT CHARSET=utf8
CREATE TABLE `appversions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`application_id` int(11) unsigned NOT NULL DEFAULT '0',
`version` varchar(255) NOT NULL DEFAULT '',
`version_int` bigint(20) unsigned DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `application_id_2` (`application_id`,`version`),
KEY `application_id` (`application_id`),
KEY `version` (`version`),
KEY `version_int_idx` (`version_int`)
) ENGINE=InnoDB AUTO_INCREMENT=2080 DEFAULT CHARSET=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
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_group_id` (`group_id`),
KEY `auth_group_permissions_permission_id` (`permission_id`),
CONSTRAINT `group_id_refs_id_3cea63fe` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
CONSTRAINT `permission_id_refs_id_5886d21f` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
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`),
CONSTRAINT `content_type_id_refs_id_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=latin1
CREATE TABLE `blogposts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`date_posted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`permalink` text NOT NULL,
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=439053 DEFAULT CHARSET=utf8
CREATE TABLE `cannedresponses` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`sort_group` varchar(255) DEFAULT NULL,
`type` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`response` varchar(1024) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8
CREATE TABLE `categories` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` int(11) unsigned DEFAULT NULL,
`addontype_id` int(11) unsigned NOT NULL DEFAULT '0',
`application_id` int(11) unsigned DEFAULT NULL,
`weight` int(11) NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`count` int(11) NOT NULL DEFAULT '0',
`slug` varchar(50) NOT NULL DEFAULT '',
`misc` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `addontype_id` (`addontype_id`),
KEY `application_id` (`application_id`),
KEY `tags_ibfk_3` (`name`),
KEY `categories_slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=329 DEFAULT CHARSET=utf8
CREATE TABLE `collection_subscriptions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`collection_id` int(11) unsigned NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `collection_id` (`collection_id`,`user_id`),
KEY `user_id` (`user_id`),
KEY `user_created_idx` (`user_id`,`created`),
CONSTRAINT `collection_subscriptions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `collections_subscriptions_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `collections` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uuid` char(36) NOT NULL DEFAULT '',
`name` int(11) unsigned DEFAULT NULL,
`defaultlocale` varchar(10) NOT NULL DEFAULT 'en-US',
`collection_type` int(11) unsigned NOT NULL DEFAULT '0',
`icontype` varchar(25) NOT NULL DEFAULT '',
`nickname` varchar(30) DEFAULT NULL,
`description` int(11) unsigned DEFAULT NULL,
`listed` tinyint(1) NOT NULL DEFAULT '1',
`subscribers` int(11) DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`downloads` int(11) DEFAULT NULL,
`application_id` int(10) unsigned DEFAULT NULL,
`weekly_subscribers` int(11) DEFAULT NULL,
`monthly_subscribers` int(11) DEFAULT NULL,
`addonCount` int(11) unsigned NOT NULL DEFAULT '0',
`upvotes` int(11) DEFAULT NULL,
`downvotes` int(11) DEFAULT NULL,
`rating` float DEFAULT NULL,
`author_id` int(11) DEFAULT NULL,
`slug` varchar(30) DEFAULT NULL,
`all_personas` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uuid` (`uuid`),
UNIQUE KEY `nickname` (`nickname`),
UNIQUE KEY `author_id` (`author_id`,`slug`),
KEY `listed` (`listed`),
KEY `application_id` (`application_id`),
KEY `name` (`name`),
KEY `description` (`description`),
KEY `subscribers_idx` (`subscribers`),
KEY `slug_idx` (`slug`),
KEY `type_idx` (`collection_type`),
KEY `watcher_idx` (`weekly_subscribers`),
KEY `rating_idx` (`rating`),
KEY `created_idx` (`created`),
CONSTRAINT `collections_ibfk_4` FOREIGN KEY (`name`) REFERENCES `translations` (`id`) ON DELETE SET NULL,
CONSTRAINT `collections_ibfk_5` FOREIGN KEY (`description`) REFERENCES `translations` (`id`) ON DELETE SET NULL,
CONSTRAINT `collections_ibfk_7` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6029622 DEFAULT CHARSET=utf8
CREATE TABLE `collections_votes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`collection_id` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`vote` tinyint(2) NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `collection_id` (`collection_id`,`user_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `collections_votes_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`),
CONSTRAINT `collections_votes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `compat_override` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`name` varchar(255) DEFAULT NULL,
`guid` varchar(255) NOT NULL,
`addon_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `guid` (`guid`),
UNIQUE KEY `addon_id_2` (`addon_id`,`guid`),
KEY `addon_id` (`addon_id`),
CONSTRAINT `compat_override_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2453 DEFAULT CHARSET=utf8
CREATE TABLE `compat_override_range` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`compat_id` int(11) unsigned NOT NULL,
`type` smallint(6) NOT NULL,
`min_version` varchar(255) NOT NULL,
`max_version` varchar(255) NOT NULL,
`app_id` int(11) unsigned NOT NULL,
`min_app_version` varchar(255) NOT NULL,
`max_app_version` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `app_id` (`app_id`),
KEY `compat_id` (`compat_id`),
CONSTRAINT `compat_override_range_ibfk_2` FOREIGN KEY (`compat_id`) REFERENCES `compat_override` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2544 DEFAULT CHARSET=utf8
CREATE TABLE `compat_totals` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`total` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8
CREATE TABLE `compatibility_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(128) DEFAULT NULL,
`works_properly` tinyint(1) unsigned DEFAULT NULL,
`app_guid` varchar(128) DEFAULT NULL,
`app_version` varchar(128) DEFAULT NULL,
`app_build` varchar(128) DEFAULT NULL,
`client_os` varchar(128) DEFAULT NULL,
`client_ip` varchar(128) DEFAULT NULL,
`comments` text,
`other_addons` text,
`created` datetime DEFAULT NULL,
`version` varchar(128) DEFAULT '0.0',
`modified` datetime DEFAULT NULL,
`app_multiprocess_enabled` tinyint(1) NOT NULL DEFAULT '0',
`multiprocess_compatible` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `guid` (`guid`),
KEY `created_idx` (`created`),
KEY `guid_created_idx` (`guid`,`created`),
KEY `guid_wp_idx` (`guid`,`works_properly`)
) ENGINE=InnoDB AUTO_INCREMENT=6699992 DEFAULT CHARSET=utf8
CREATE TABLE `config` (
`key` varchar(255) NOT NULL DEFAULT '',
`value` mediumtext NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `denied_guids` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`guid` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comments` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `guid` (`guid`)
) ENGINE=InnoDB AUTO_INCREMENT=8764 DEFAULT CHARSET=utf8
CREATE TABLE `discovery_discoveryitem` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`addon_id` int(10) unsigned NOT NULL,
`custom_addon_name` varchar(255) NOT NULL,
`custom_heading` varchar(255) NOT NULL,
`custom_description` longtext NOT NULL,
`position` smallint(5) unsigned DEFAULT '0',
`position_china` smallint(5) unsigned DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `addon_id` (`addon_id`),
KEY `discovery_discoveryitem_position_5898729e` (`position`),
KEY `discovery_discoveryitem_position_china_321144f9` (`position_china`),
CONSTRAINT `addon_id_refs_id_93b5ecf8` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8
CREATE TABLE `discovery_modules` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`app_id` int(11) NOT NULL,
`module` varchar(255) NOT NULL,
`ordering` int(11) DEFAULT NULL,
`locales` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `app_id` (`app_id`,`module`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=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`),
CONSTRAINT `content_type_id_refs_id_288599e6` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
CONSTRAINT `user_id_refs_id_c8665aa` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16820 DEFAULT CHARSET=latin1
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=92 DEFAULT CHARSET=latin1
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
CREATE TABLE `download_counts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`src` mediumtext,
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `date_2` (`date`,`addon_id`),
KEY `addon_id` (`addon_id`),
KEY `count` (`count`),
KEY `addon_and_count` (`addon_id`,`count`),
KEY `addon_date_idx` (`addon_id`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=73353165 DEFAULT CHARSET=utf8
CREATE TABLE `editor_subscriptions` (
`user_id` int(11) NOT NULL,
`addon_id` int(11) unsigned NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `addon_id` (`addon_id`),
CONSTRAINT `editor_subscriptions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `editor_subscriptions_ibfk_2` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52122 DEFAULT CHARSET=utf8 COMMENT='Editor subscriptions for add-on updates'
CREATE TABLE `editors_autoapprovalsummary` (
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`version_id` int(10) unsigned NOT NULL,
`verdict` smallint(5) unsigned NOT NULL,
`is_locked` tinyint(1) NOT NULL,
`weight` int(11) NOT NULL,
`confirmed` tinyint(1) DEFAULT NULL,
`has_auto_approval_disabled` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`version_id`),
CONSTRAINT `version_id_refs_id_6d27bb3c` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `email_preview` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`topic` varchar(255) NOT NULL,
`recipient_list` longtext NOT NULL,
`from_email` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `email_preview_277e394d` (`topic`)
) ENGINE=InnoDB AUTO_INCREMENT=514439 DEFAULT CHARSET=utf8
CREATE TABLE `fake_email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` text NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `featured_collections` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`application_id` int(11) unsigned NOT NULL,
`collection_id` int(11) unsigned NOT NULL,
`locale` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `application_id_idx` (`application_id`),
KEY `collection_id_idx` (`collection_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8
CREATE TABLE `file_uploads` (
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`uuid` char(32) NOT NULL,
`path` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`validation` longtext,
`hash` varchar(255) DEFAULT NULL,
`valid` tinyint(1) NOT NULL DEFAULT '0',
`compat_with_app_id` int(11) unsigned DEFAULT NULL,
`compat_with_appver_id` int(11) unsigned DEFAULT NULL,
`automated_signing` tinyint(1) DEFAULT '0',
`version` varchar(255) DEFAULT NULL,
`addon_id` int(11) unsigned DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `uuid` (`uuid`),
KEY `user_id` (`user_id`),
KEY `file_uploads_afe99c5e` (`compat_with_app_id`),
KEY `file_uploads_9a93262a` (`compat_with_appver_id`),
KEY `file_uploads_refs_addon_id` (`addon_id`),
CONSTRAINT `compat_with_appver_id_refs_id_3747a309` FOREIGN KEY (`compat_with_appver_id`) REFERENCES `appversions` (`id`),
CONSTRAINT `file_uploads_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `file_uploads_refs_addon_id` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=976505 DEFAULT CHARSET=utf8
CREATE TABLE `file_validation` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`file_id` int(11) NOT NULL,
`valid` tinyint(1) NOT NULL,
`errors` int(11) NOT NULL,
`warnings` int(11) NOT NULL,
`notices` int(11) NOT NULL,
`validation` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1082966 DEFAULT CHARSET=utf8
CREATE TABLE `files` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`version_id` int(11) unsigned NOT NULL DEFAULT '0',
`platform_id` int(11) unsigned NOT NULL DEFAULT '0',
`filename` varchar(255) NOT NULL DEFAULT '',
`size` int(11) unsigned NOT NULL DEFAULT '0',
`hash` varchar(255) DEFAULT NULL,
`status` tinyint(2) unsigned NOT NULL DEFAULT '0',
`datestatuschanged` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`reviewed` datetime DEFAULT NULL,
`jetpack_version` varchar(10) DEFAULT NULL,
`requires_chrome` tinyint(1) NOT NULL DEFAULT '0',
`strict_compatibility` tinyint(1) NOT NULL DEFAULT '0',
`binary` tinyint(1) NOT NULL DEFAULT '0',
`binary_components` tinyint(1) NOT NULL DEFAULT '0',
`is_packaged` tinyint(1) NOT NULL DEFAULT '0',
`cert_serial_num` text NOT NULL,
`is_signed` tinyint(1) NOT NULL DEFAULT '0',
`is_multi_package` tinyint(1) NOT NULL DEFAULT '0',
`original_hash` varchar(255) NOT NULL DEFAULT '',
`is_experiment` tinyint(1) DEFAULT '0',
`is_webextension` tinyint(1) DEFAULT '0',
`original_status` smallint(6) DEFAULT '0',
`is_restart_required` tinyint(1) NOT NULL,
`is_mozilla_signed_extension` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `version_id` (`version_id`),
KEY `platform_id` (`platform_id`),
KEY `status` (`status`),
KEY `statuschanged_idx` (`datestatuschanged`,`version_id`),
KEY `created_idx` (`created`,`version_id`),
KEY `jetpack_version_idx` (`jetpack_version`),
KEY `files_cedd2560` (`binary_components`),
KEY `files_is_packaged` (`is_packaged`),
CONSTRAINT `files_ibfk_1` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1077639 DEFAULT CHARSET=utf8
CREATE TABLE `frozen_addons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addon_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `addon_id` (`addon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8
CREATE TABLE `global_stats` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `namedate` (`name`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=330832 DEFAULT CHARSET=utf8
CREATE TABLE `groups` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`rules` text,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`notes` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50102 DEFAULT CHARSET=utf8
CREATE TABLE `groups_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`user_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `groups_users_ibfk_3` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE,
CONSTRAINT `groups_users_ibfk_4` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1522 DEFAULT CHARSET=utf8
CREATE TABLE `hubrsskeys` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rsskey` char(36) NOT NULL DEFAULT '',
`addon_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `rsskey` (`rsskey`),
UNIQUE KEY `addon_id` (`addon_id`),
UNIQUE KEY `user_id` (`user_id`),
CONSTRAINT `hubrsskeys_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `hubrsskeys_ibfk_2` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=261147 DEFAULT CHARSET=utf8
CREATE TABLE `incompatible_versions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`version_id` int(11) unsigned NOT NULL,
`app_id` int(11) unsigned NOT NULL,
`min_app_version` varchar(255) NOT NULL,
`max_app_version` varchar(255) NOT NULL,
`min_app_version_int` bigint(20) DEFAULT NULL,
`max_app_version_int` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `incompatible_versions_fef0b09d` (`version_id`),
KEY `incompatible_versions_269da59a` (`app_id`),
KEY `incompatible_versions_68156cb3` (`min_app_version_int`),
KEY `incompatible_versions_3d2f16b5` (`max_app_version_int`),
CONSTRAINT `incompatible_versions_ibfk_2` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12820 DEFAULT CHARSET=utf8
CREATE TABLE `licenses` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`text` int(11) unsigned DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`url` varchar(200) DEFAULT NULL,
`builtin` int(10) unsigned NOT NULL DEFAULT '0',
`on_form` tinyint(1) NOT NULL DEFAULT '0',
`some_rights` tinyint(1) NOT NULL DEFAULT '0',
`icons` varchar(255) DEFAULT NULL,
`name` int(11) unsigned DEFAULT NULL,
`creative_commons` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `text` (`text`),
KEY `name` (`name`),
KEY `builtin_idx` (`builtin`),
CONSTRAINT `licenses_ibfk_1` FOREIGN KEY (`text`) REFERENCES `translations` (`id`),
CONSTRAINT `licenses_ibfk_2` FOREIGN KEY (`name`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7385 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`user_id` int(11) DEFAULT NULL,
`action` smallint(6) NOT NULL,
`arguments` longtext NOT NULL,
`details` longtext,
PRIMARY KEY (`id`),
KEY `log_activity_fbfc09f1` (`user_id`),
KEY `log_activity_1bd4707b` (`action`),
KEY `created_idx` (`created`),
CONSTRAINT `user_id_refs_id_3fa7a30a` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10563448 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_addon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`addon_id` int(10) unsigned NOT NULL,
`activity_log_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `log_activity_addon_cc3d5937` (`addon_id`),
KEY `log_activity_addon_3bf68f54` (`activity_log_id`),
CONSTRAINT `activity_log_id_refs_id_9c20a926` FOREIGN KEY (`activity_log_id`) REFERENCES `log_activity` (`id`) ON DELETE CASCADE,
CONSTRAINT `addon_id_refs_id_5bfa17d1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9711821 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`activity_log_id` int(11) NOT NULL,
`comments` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `activity_log_id` (`activity_log_id`),
CONSTRAINT `log_activity_comment_ibfk_1` FOREIGN KEY (`activity_log_id`) REFERENCES `log_activity` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=920139 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_emails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`messageid` char(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `messageid` (`messageid`)
) ENGINE=InnoDB AUTO_INCREMENT=94585 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`activity_log_id` int(11) NOT NULL,
`group_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `group_id_refs_id_757b3ceb` (`group_id`),
KEY `activity_log_id_refs_id_15e06f3d` (`activity_log_id`),
CONSTRAINT `activity_log_id_refs_id_15e06f3d` FOREIGN KEY (`activity_log_id`) REFERENCES `log_activity` (`id`) ON DELETE CASCADE,
CONSTRAINT `group_id_refs_id_757b3ceb` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2194 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_tokens` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`version_id` int(11) unsigned NOT NULL,
`user_id` int(11) NOT NULL,
`uuid` char(32) NOT NULL,
`use_count` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uuid` (`uuid`),
UNIQUE KEY `version_id` (`version_id`,`user_id`),
KEY `log_activity_tokens_user` (`user_id`),
CONSTRAINT `log_activity_tokens_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `log_activity_tokens_version` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=472485 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`activity_log_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `log_activity_user_3bf68f54` (`activity_log_id`),
KEY `log_activity_user_fbfc09f1` (`user_id`),
CONSTRAINT `activity_log_id_refs_id_4f8d99d4` FOREIGN KEY (`activity_log_id`) REFERENCES `log_activity` (`id`) ON DELETE CASCADE,
CONSTRAINT `user_id_refs_id_e987c199` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10782707 DEFAULT CHARSET=utf8
CREATE TABLE `log_activity_version` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`activity_log_id` int(11) NOT NULL,
`version_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `activity_log_id` (`activity_log_id`),
KEY `version_id` (`version_id`),
CONSTRAINT `log_activity_version_ibfk_1` FOREIGN KEY (`activity_log_id`) REFERENCES `log_activity` (`id`),
CONSTRAINT `log_activity_version_ibfk_2` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1663929 DEFAULT CHARSET=utf8
CREATE TABLE `migrated_personas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`lightweight_theme_id` int(11) unsigned NOT NULL,
`getpersonas_id` int(11) NOT NULL,
`static_theme_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `migrated_personas_lightweight_theme_id_fk_addons_id` (`lightweight_theme_id`),
KEY `migrated_personas_static_theme_id_fk_addons_id` (`static_theme_id`),
KEY `migrated_personas_getpersonas_id` (`getpersonas_id`),
CONSTRAINT `migrated_personas_lightweight_theme_id_fk_addons_id` FOREIGN KEY (`lightweight_theme_id`) REFERENCES `addons` (`id`),
CONSTRAINT `migrated_personas_static_theme_id_fk_addons_id` FOREIGN KEY (`static_theme_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `monthly_pick` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`addon_id` int(11) unsigned NOT NULL,
`blurb` longtext NOT NULL,
`image` varchar(200) NOT NULL,
`locale` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `locale` (`locale`),
UNIQUE KEY `locale_2` (`locale`),
KEY `monthly_pick_cc3d5937` (`addon_id`),
CONSTRAINT `addon_id_refs_id_a94677f3` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
CREATE TABLE `personas` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL,
`persona_id` int(11) unsigned NOT NULL,
`name` int(11) unsigned DEFAULT NULL,
`description` int(11) unsigned DEFAULT NULL,
`header` varchar(64) DEFAULT NULL,
`footer` varchar(64) DEFAULT NULL,
`accentcolor` varchar(10) DEFAULT NULL,
`textcolor` varchar(10) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`display_username` varchar(255) DEFAULT NULL,
`submit` datetime DEFAULT NULL,
`approve` datetime DEFAULT NULL,
`movers` double DEFAULT NULL,
`popularity` int(11) NOT NULL DEFAULT '0',
`license` int(11) unsigned DEFAULT NULL,
`checksum` varchar(64) NOT NULL DEFAULT '',
`dupe_persona_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `personas_ibfk_1` (`addon_id`),
KEY `personas_ibfk_3` (`description`),
KEY `license_id` (`license`),
KEY `personas_persona_id` (`persona_id`),
KEY `personas_movers_idx` (`movers`),
KEY `personas_popularity_idx` (`popularity`),
KEY `author_addon_idx` (`author`,`addon_id`),
KEY `dupe_persona_id_refs_id` (`dupe_persona_id`),
KEY `personas_checksum_index` (`checksum`),
CONSTRAINT `dupe_persona_id_refs_id` FOREIGN KEY (`dupe_persona_id`) REFERENCES `personas` (`id`),
CONSTRAINT `personas_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `personas_ibfk_2` FOREIGN KEY (`name`) REFERENCES `translations` (`id`),
CONSTRAINT `personas_ibfk_3` FOREIGN KEY (`description`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=684168 DEFAULT CHARSET=utf8
CREATE TABLE `previews` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`caption` int(11) unsigned DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`sizes` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `addon_id` (`addon_id`),
KEY `previews_ibfk_2` (`caption`),
KEY `addon_position_created_idx` (`addon_id`,`position`,`created`),
CONSTRAINT `previews_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `previews_ibfk_2` FOREIGN KEY (`caption`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=208204 DEFAULT CHARSET=utf8
CREATE TABLE `replacement_addons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`guid` char(255) DEFAULT NULL,
`path` char(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `guid` (`guid`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8
CREATE TABLE `rereview_queue_theme` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`theme_id` int(11) unsigned NOT NULL,
`header` varchar(72) NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`dupe_persona_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `theme_id` (`theme_id`),
KEY `rqt_dupe_persona_id_refs_id` (`dupe_persona_id`),
CONSTRAINT `rereview_queue_theme_ibfk_1` FOREIGN KEY (`theme_id`) REFERENCES `personas` (`id`) ON DELETE CASCADE,
CONSTRAINT `rqt_dupe_persona_id_refs_id` FOREIGN KEY (`dupe_persona_id`) REFERENCES `personas` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35602 DEFAULT CHARSET=utf8
CREATE TABLE `review_whiteboard` (
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`addon_id` int(10) unsigned NOT NULL,
`private` longtext NOT NULL,
`public` longtext NOT NULL,
PRIMARY KEY (`addon_id`),
CONSTRAINT `addon_id_refs_id_3aa22f51` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `reviewer_scores` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`user_id` int(11) NOT NULL,
`addon_id` int(11) unsigned DEFAULT NULL,
`score` int(11) NOT NULL,
`note_key` smallint(6) NOT NULL DEFAULT '0',
`note` varchar(255) NOT NULL,
`version_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `reviewer_scores_addon_id_fk` (`addon_id`),
KEY `reviewer_scores_created_idx` (`created`),
KEY `reviewer_scores_user_id_idx` (`user_id`),
KEY `reviewer_scores_version_id` (`version_id`),
CONSTRAINT `reviewer_scores_addon_id_fk` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE SET NULL,
CONSTRAINT `reviewer_scores_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=547601 DEFAULT CHARSET=utf8
CREATE TABLE `reviews` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`version_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`reply_to` int(11) unsigned DEFAULT NULL,
`rating` tinyint(3) unsigned DEFAULT NULL,
`body` int(11) unsigned DEFAULT NULL,
`editorreview` tinyint(1) unsigned NOT NULL DEFAULT '0',
`flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ip_address` varchar(255) NOT NULL DEFAULT '0.0.0.0',
`addon_id` int(11) unsigned DEFAULT NULL,
`previous_count` int(11) unsigned DEFAULT '0',
`is_latest` tinyint(1) DEFAULT '1',
`deleted` tinyint(1) DEFAULT '0',
`text_body` longtext,
PRIMARY KEY (`id`),
UNIQUE KEY `reply_to` (`reply_to`),
UNIQUE KEY `one_review_per_user` (`version_id`,`user_id`,`reply_to`),
KEY `version_id` (`version_id`),
KEY `reviews_ibfk_2` (`user_id`),
KEY `reviews_ibfk_4` (`body`),
KEY `addon_id` (`addon_id`),
KEY `latest_reviews` (`reply_to`,`is_latest`,`addon_id`,`created`),
CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`),
CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `reviews_ibfk_4` FOREIGN KEY (`body`) REFERENCES `translations` (`id`),
CONSTRAINT `reviews_ibfk_5` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`),
CONSTRAINT `reviews_reply` FOREIGN KEY (`reply_to`) REFERENCES `reviews` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1192181 DEFAULT CHARSET=utf8
CREATE TABLE `reviews_moderation_flags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`review_id` int(11) unsigned NOT NULL DEFAULT '0',
`user_id` int(11) DEFAULT NULL,
`flag_name` varchar(64) NOT NULL DEFAULT 'review_flag_reason_other',
`flag_notes` varchar(100) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `index_review_user` (`review_id`,`user_id`),
KEY `index_user` (`user_id`),
KEY `index_review` (`review_id`),
KEY `index_modified` (`modified`),
CONSTRAINT `reviews_moderation_flags_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `reviews` (`id`) ON DELETE CASCADE,
CONSTRAINT `reviews_moderation_flags_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151508 DEFAULT CHARSET=utf8
CREATE TABLE `schema_version` (
`version` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `stats_addons_collections_counts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(10) unsigned NOT NULL DEFAULT '0',
`collection_id` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `addon_id` (`addon_id`),
KEY `collection_id` (`collection_id`),
KEY `count` (`count`),
KEY `date` (`date`),
CONSTRAINT `stats_addons_collections_counts_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`),
CONSTRAINT `stats_addons_collections_counts_ibfk_2` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `stats_collections` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`collection_id` int(11) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
UNIQUE KEY `collectionnamedate` (`collection_id`,`name`,`date`),
KEY `collection_id` (`collection_id`),
CONSTRAINT `stats_collections_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `stats_collections_counts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`collection_id` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `collection_id` (`collection_id`),
KEY `count` (`count`),
KEY `date` (`date`),
CONSTRAINT `stats_collections_counts_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `collections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `tags` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`tag_text` varchar(128) NOT NULL,
`denied` tinyint(1) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`restricted` tinyint(1) NOT NULL,
`num_addons` int(50) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `tag_text` (`tag_text`),
KEY `tag_blacklisted_num_addons_idx` (`denied`,`num_addons`)
) ENGINE=InnoDB AUTO_INCREMENT=191601 DEFAULT CHARSET=utf8
CREATE TABLE `theme_locks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`theme_id` int(11) unsigned NOT NULL,
`reviewer_id` int(11) NOT NULL,
`expiry` datetime NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `theme_id` (`theme_id`),
KEY `theme_locks_d0f17e2b` (`reviewer_id`),
CONSTRAINT `reviewer_id_refs_id_fk` FOREIGN KEY (`reviewer_id`) REFERENCES `users` (`id`),
CONSTRAINT `theme_id_refs_id_fk` FOREIGN KEY (`theme_id`) REFERENCES `personas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=297036 DEFAULT CHARSET=utf8
CREATE TABLE `theme_update_counts` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`count` int(11) unsigned NOT NULL DEFAULT '0',
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `theme_update_counts_addon_id_index` (`addon_id`),
KEY `theme_update_counts_count_index` (`count`),
KEY `theme_update_counts_date_index` (`date`),
KEY `theme_update_counts_addon_id_count_index` (`addon_id`,`count`),
CONSTRAINT `theme_update_counts_addon_id_key` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=360528431 DEFAULT CHARSET=utf8
CREATE TABLE `theme_update_counts_bulk` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`persona_id` int(11) unsigned NOT NULL,
`popularity` int(11) unsigned DEFAULT NULL,
`movers` double DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=325551109 DEFAULT CHARSET=utf8
CREATE TABLE `theme_user_counts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL,
`count` int(10) unsigned NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `addon_id_refs_id_ac19f783` (`addon_id`),
KEY `theme_user_counts_date_cc9034dde90789f` (`date`,`addon_id`),
CONSTRAINT `addon_id_refs_id_ac19f783` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=970158042 DEFAULT CHARSET=utf8
CREATE TABLE `theme_user_counts_20170606` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL,
`count` int(10) unsigned NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `addon_date_idx` (`addon_id`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=780914732 DEFAULT CHARSET=utf8
CREATE TABLE `translations` (
`autoid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` int(11) unsigned NOT NULL DEFAULT '0',
`locale` varchar(10) NOT NULL DEFAULT '',
`localized_string` text,
`localized_string_clean` text,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`autoid`),
UNIQUE KEY `id` (`id`,`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=15470712 DEFAULT CHARSET=utf8
CREATE TABLE `translations_seq` (
`id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `update_counts` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`count` int(11) unsigned NOT NULL DEFAULT '0',
`version` text,
`status` text,
`application` mediumtext,
`os` text,
`locale` text,
`date` date NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (`id`),
KEY `addon_id` (`addon_id`),
KEY `count` (`count`),
KEY `date` (`date`),
KEY `addon_and_count` (`addon_id`,`count`),
KEY `addon_date_idx` (`addon_id`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=90664438 DEFAULT CHARSET=utf8
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(255) DEFAULT NULL,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`display_name` varchar(255) DEFAULT NULL,
`password` varchar(255) NOT NULL DEFAULT '',
`homepage` varchar(255) DEFAULT NULL,
`display_collections` tinyint(1) unsigned NOT NULL DEFAULT '0',
`display_collections_fav` tinyint(3) unsigned DEFAULT NULL,
`deleted` tinyint(1) DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`notes` text,
`location` varchar(255) NOT NULL DEFAULT '',
`occupation` varchar(255) NOT NULL DEFAULT '',
`picture_type` varchar(75) DEFAULT NULL,
`averagerating` double DEFAULT NULL,
`last_login_ip` char(45) NOT NULL DEFAULT '',
`read_dev_agreement` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`fxa_id` varchar(128) DEFAULT NULL,
`auth_id` int(10) unsigned DEFAULT NULL,
`biography` longtext,
`public` tinyint(1) DEFAULT '0',
`email_changed` datetime DEFAULT NULL,
`basket_token` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `created` (`created`),
KEY `users_fxa_id_index` (`fxa_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14286766 DEFAULT CHARSET=utf8
CREATE TABLE `users_denied_name` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`name`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=404 DEFAULT CHARSET=utf8
CREATE TABLE `users_history` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`email` varchar(75) DEFAULT NULL,
`user_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `users_history_user_idx` (`user_id`),
KEY `users_history_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=71095 DEFAULT CHARSET=utf8
CREATE TABLE `users_notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`notification_id` int(11) NOT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`enabled` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
CONSTRAINT `users_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10743185 DEFAULT CHARSET=utf8
CREATE TABLE `users_tags_addons` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag_id` int(11) unsigned NOT NULL,
`addon_id` int(11) unsigned NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `tag_id_2` (`tag_id`,`addon_id`),
KEY `tag_id` (`tag_id`),
KEY `addon_id` (`addon_id`),
CONSTRAINT `users_tags_addons_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE,
CONSTRAINT `users_tags_addons_ibfk_3` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1206247 DEFAULT CHARSET=utf8
CREATE TABLE `validation_job` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`application_id` int(11) unsigned NOT NULL,
`curr_max_version_id` int(11) unsigned NOT NULL,
`target_version_id` int(11) unsigned NOT NULL,
`finish_email` varchar(255) DEFAULT NULL,
`completed` datetime DEFAULT NULL,
`creator_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `validation_job_398529ef` (`application_id`),
KEY `validation_job_e490d511` (`completed`),
KEY `validation_job_271f7e46` (`curr_max_version_id`),
KEY `validation_job_eb1d7e37` (`target_version_id`),
KEY `validation_job_ad376f8d` (`creator_id`),
CONSTRAINT `creator_id_refs_id_db67caad` FOREIGN KEY (`creator_id`) REFERENCES `users` (`id`),
CONSTRAINT `curr_max_version_id_refs_id_535fc21b` FOREIGN KEY (`curr_max_version_id`) REFERENCES `appversions` (`id`),
CONSTRAINT `target_version_id_refs_id_535fc21b` FOREIGN KEY (`target_version_id`) REFERENCES `appversions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8
CREATE TABLE `validation_result` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`validation_job_id` int(11) unsigned NOT NULL,
`task_error` longtext,
`completed` datetime DEFAULT NULL,
`file_id` int(11) unsigned NOT NULL,
`valid` tinyint(1) NOT NULL,
`errors` int(11) unsigned DEFAULT NULL,
`warnings` int(11) unsigned DEFAULT NULL,
`notices` int(11) unsigned DEFAULT NULL,
`validation` longtext,
PRIMARY KEY (`id`),
KEY `validation_result_61162f45` (`validation_job_id`),
KEY `validation_result_e490d511` (`completed`),
KEY `validation_result_2243e3be` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=621500 DEFAULT CHARSET=utf8
CREATE TABLE `version_previews` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime(6) NOT NULL,
`modified` datetime(6) NOT NULL,
`version_id` int(11) unsigned NOT NULL,
`sizes` longtext NOT NULL,
`position` tinyint(11) unsigned DEFAULT '0',
PRIMARY KEY (`id`),
KEY `version_previews_version_id_fk_versions_id` (`version_id`),
KEY `version_position_created_idx` (`version_id`,`position`,`created`),
CONSTRAINT `version_previews_version_id_fk_versions_id` FOREIGN KEY (`version_id`) REFERENCES `versions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=331 DEFAULT CHARSET=utf8
CREATE TABLE `versions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`addon_id` int(11) unsigned NOT NULL DEFAULT '0',
`license_id` int(11) unsigned DEFAULT NULL,
`version` varchar(255) NOT NULL DEFAULT '',
`approvalnotes` text,
`releasenotes` int(11) unsigned DEFAULT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`version_int` bigint(20) DEFAULT NULL,
`reviewed` datetime DEFAULT NULL,
`nomination` datetime DEFAULT NULL,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`source` varchar(100) DEFAULT NULL,
`channel` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `addon_id` (`addon_id`),
KEY `versions_ibfk_2` (`releasenotes`),
KEY `license_id` (`license_id`),
KEY `version_int_idx` (`version_int`),
CONSTRAINT `versions_ibfk_1` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
CONSTRAINT `versions_ibfk_2` FOREIGN KEY (`releasenotes`) REFERENCES `translations` (`id`),
CONSTRAINT `versions_ibfk_3` FOREIGN KEY (`license_id`) REFERENCES `licenses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2533157 DEFAULT CHARSET=utf8
CREATE TABLE `waffle_flag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`everyone` tinyint(1) DEFAULT NULL,
`percent` decimal(3,1) DEFAULT NULL,
`superusers` tinyint(1) NOT NULL,
`staff` tinyint(1) NOT NULL,
`authenticated` tinyint(1) NOT NULL,
`rollout` tinyint(1) NOT NULL,
`note` text NOT NULL,
`testing` tinyint(1) NOT NULL,
`languages` longtext NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8
CREATE TABLE `waffle_flag_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`flag_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `flag_id` (`flag_id`,`group_id`),
KEY `group_id_refs_id_4ea49f34` (`group_id`),
CONSTRAINT `flag_id_refs_id_8e6a807d` FOREIGN KEY (`flag_id`) REFERENCES `waffle_flag` (`id`),
CONSTRAINT `group_id_refs_id_4ea49f34` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `waffle_flag_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`flag_id` int(11) NOT NULL,
`userprofile_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `flag_id` (`flag_id`,`userprofile_id`),
KEY `user_id_refs_id_bae2dfc2` (`userprofile_id`),
CONSTRAINT `flag_id_refs_id_8fef0c12` FOREIGN KEY (`flag_id`) REFERENCES `waffle_flag` (`id`),
CONSTRAINT `flag_userprofile_id` FOREIGN KEY (`userprofile_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8
CREATE TABLE `waffle_sample` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`percent` decimal(4,1) NOT NULL,
`note` text NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
CREATE TABLE `waffle_switch` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`active` tinyint(1) NOT NULL,
`note` text NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8
CREATE TABLE `webext_permission_descriptions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`name` char(255) NOT NULL,
`description` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `webext_permission_descriptions_translation_id` (`description`),
CONSTRAINT `webext_permission_descriptions_translation_id` FOREIGN KEY (`description`) REFERENCES `translations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8
CREATE TABLE `webext_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
`permissions` longtext,
`file_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `file_id` (`file_id`),
CONSTRAINT `webext_permissions_file` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=471333 DEFAULT CHARSET=utf8
CREATE TABLE `zadmin_reindexing` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start_date` datetime NOT NULL,
`old_index` varchar(255) DEFAULT NULL,
`new_index` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`site` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `zadmin_siteevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start` date NOT NULL,
`end` date DEFAULT NULL,
`event_type` int(10) unsigned NOT NULL,
`description` varchar(255) DEFAULT NULL,
`more_info_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment