Page MenuHomePhabricator
Create Task
Maniphest T286552

Mailman3 schema change: Switch autoresponse_text fields to Text
Closed, ResolvedPublic
Actions

Description

Just like T281444: Deploy schema change making mailman3.mailinglist info column bigger, we need to make these fields bigger. This was reviewed and merged upstream already: https://gitlab.com/mailman/mailman/-/merge_requests/888.

ALTER TABLE mailinglist MODIFY autoresponse_owner_text TEXT COLLATE utf8mb4_bin NULL;

ALTER TABLE mailinglist MODIFY autoresponse_postings_text TEXT COLLATE utf8mb4_bin NULL;

ALTER TABLE mailinglist MODIFY autoresponse_request_text TEXT COLLATE utf8mb4_bin NULL;
  • Where: mailman3 on m5
  • When: no code dependency, but we will need to announce a time as it will require Mailman3 downtime
  • Backwards compatible: yes
  • Tested already: Locally yes, still need to test in Cloud VPS

Related Objects
Search...

Event Timeline

Legoktm created this task.Jul 13 2021, 11:54 AM
Legoktm added a project: Schema-change.
LSobanski triaged this task as Medium priority.Jul 13 2021, 12:20 PM
LSobanski moved this task from Triage to Blocked on the DBA board.
LSobanski subscribed.

Let us know when full tested and ready to go. Preferably after the DC switch back as our schedule is pretty full until then.

RobH moved this task from Backlog to Mailman v3 on the Wikimedia-Mailing-lists board.Aug 18 2021, 5:55 PM
Marostegui subscribed.Oct 28 2021, 6:39 AM

@Legoktm did you get to test this in cloud vps?

Stashbot added a comment.Nov 26 2021, 1:51 PM

Mentioned in SAL (#wikimedia-cloud) [2021-11-26T13:51:43Z] <Amir1> running T286552 schema changes in the cloud

Ladsgroup added a comment.Nov 26 2021, 1:52 PM

I ran it in the cloud. So far everything looks good.

Ladsgroup added a comment.Nov 26 2021, 2:00 PM

Added a massive text to auto response and it worked fine meaning the schema change fixes the issue. I think we can move forward with announcing downtime and running the schema change.

Marostegui added a comment.Nov 26 2021, 2:08 PM

Sounds good to me, I can help with the deployment :)

Marostegui moved this task from Blocked to Ready on the DBA board.Nov 26 2021, 2:08 PM
Marostegui added a comment.Dec 7 2021, 9:32 AM

m5 hosts downtimed for 2h.
Reminder: db2078 is down due to T296930, the schema change will arrive there via replication once it is back up.

Marostegui claimed this task.Dec 7 2021, 9:33 AM
Marostegui moved this task from Ready to In progress on the DBA board.
Marostegui added a comment.Dec 7 2021, 9:49 AM

Current table schema:

CREATE TABLE `mailinglist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `list_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mail_host` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `list_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `allow_list_posts` tinyint(1) DEFAULT NULL,
  `include_rfc2369_headers` tinyint(1) DEFAULT NULL,
  `advertised` tinyint(1) DEFAULT NULL,
  `anonymous_list` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `next_request_id` int(11) DEFAULT NULL,
  `next_digest_number` int(11) DEFAULT NULL,
  `digest_last_sent_at` datetime DEFAULT NULL,
  `volume` int(11) DEFAULT NULL,
  `last_post_at` datetime DEFAULT NULL,
  `accept_these_nonmembers` blob DEFAULT NULL,
  `admin_immed_notify` tinyint(1) DEFAULT NULL,
  `admin_notify_mchanges` tinyint(1) DEFAULT NULL,
  `administrivia` tinyint(1) DEFAULT NULL,
  `archive_policy` int(11) DEFAULT NULL,
  `autoresponse_grace_period` datetime DEFAULT NULL,
  `autorespond_owner` int(11) DEFAULT NULL,
  `autoresponse_owner_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `autorespond_postings` int(11) DEFAULT NULL,
  `autoresponse_postings_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `autorespond_requests` int(11) DEFAULT NULL,
  `autoresponse_request_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `filter_action` int(11) DEFAULT NULL,
  `filter_content` tinyint(1) DEFAULT NULL,
  `collapse_alternatives` tinyint(1) DEFAULT NULL,
  `convert_html_to_plaintext` tinyint(1) DEFAULT NULL,
  `bounce_info_stale_after` datetime DEFAULT NULL,
  `bounce_matching_headers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `bounce_notify_owner_on_disable` tinyint(1) DEFAULT NULL,
  `bounce_notify_owner_on_removal` tinyint(1) DEFAULT NULL,
  `bounce_score_threshold` int(11) DEFAULT NULL,
  `bounce_you_are_disabled_warnings` int(11) DEFAULT NULL,
  `bounce_you_are_disabled_warnings_interval` datetime DEFAULT NULL,
  `forward_unrecognized_bounces_to` int(11) DEFAULT NULL,
  `process_bounces` tinyint(1) DEFAULT NULL,
  `dmarc_mitigate_action` int(11) DEFAULT NULL,
  `dmarc_mitigate_unconditionally` tinyint(1) DEFAULT NULL,
  `dmarc_moderation_notice` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `dmarc_wrapped_message_text` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `default_member_action` int(11) DEFAULT NULL,
  `default_nonmember_action` int(11) DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `digests_enabled` tinyint(1) DEFAULT NULL,
  `digest_is_default` tinyint(1) DEFAULT NULL,
  `digest_send_periodic` tinyint(1) DEFAULT NULL,
  `digest_size_threshold` float DEFAULT NULL,
  `digest_volume_frequency` int(11) DEFAULT NULL,
  `discard_these_nonmembers` blob DEFAULT NULL,
  `emergency` tinyint(1) DEFAULT NULL,
  `encode_ascii_prefixes` tinyint(1) DEFAULT NULL,
  `first_strip_reply_to` tinyint(1) DEFAULT NULL,
  `forward_auto_discards` tinyint(1) DEFAULT NULL,
  `gateway_to_mail` tinyint(1) DEFAULT NULL,
  `gateway_to_news` tinyint(1) DEFAULT NULL,
  `hold_these_nonmembers` blob DEFAULT NULL,
  `info` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `linked_newsgroup` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `max_days_to_hold` int(11) DEFAULT NULL,
  `max_message_size` int(11) DEFAULT NULL,
  `max_num_recipients` int(11) DEFAULT NULL,
  `member_moderation_notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `moderator_password` blob DEFAULT NULL,
  `newsgroup_moderation` int(11) DEFAULT NULL,
  `nntp_prefix_subject_too` tinyint(1) DEFAULT NULL,
  `nonmember_rejection_notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `obscure_addresses` tinyint(1) DEFAULT NULL,
  `owner_chain` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `owner_pipeline` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `personalize` int(11) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `posting_chain` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `posting_pipeline` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `preferred_language` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `reject_these_nonmembers` blob DEFAULT NULL,
  `reply_goes_to_list` int(11) DEFAULT NULL,
  `reply_to_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `require_explicit_destination` tinyint(1) DEFAULT NULL,
  `respond_to_post_requests` tinyint(1) DEFAULT NULL,
  `member_roster_visibility` int(11) DEFAULT NULL,
  `scrub_nondigest` tinyint(1) DEFAULT NULL,
  `send_goodbye_message` tinyint(1) DEFAULT NULL,
  `send_welcome_message` tinyint(1) DEFAULT NULL,
  `subject_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `subscription_policy` int(11) DEFAULT NULL,
  `topics` blob DEFAULT NULL,
  `topics_bodylines_limit` int(11) DEFAULT NULL,
  `topics_enabled` tinyint(1) DEFAULT NULL,
  `unsubscription_policy` int(11) DEFAULT NULL,
  `usenet_watermark` int(11) DEFAULT NULL,
  `archive_rendering_mode` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_mailinglist_list_id` (`list_id`),
  KEY `ix_mailinglist_mail_host` (`mail_host`),
  KEY `ix_mailinglist_list_name` (`list_name`),
  CONSTRAINT `CONSTRAINT_1` CHECK (`allow_list_posts` in (0,1)),
  CONSTRAINT `CONSTRAINT_2` CHECK (`include_rfc2369_headers` in (0,1)),
  CONSTRAINT `CONSTRAINT_3` CHECK (`advertised` in (0,1)),
  CONSTRAINT `CONSTRAINT_4` CHECK (`anonymous_list` in (0,1)),
  CONSTRAINT `CONSTRAINT_5` CHECK (`admin_immed_notify` in (0,1)),
  CONSTRAINT `CONSTRAINT_6` CHECK (`admin_notify_mchanges` in (0,1)),
  CONSTRAINT `CONSTRAINT_7` CHECK (`administrivia` in (0,1)),
  CONSTRAINT `CONSTRAINT_8` CHECK (`filter_content` in (0,1)),
  CONSTRAINT `CONSTRAINT_9` CHECK (`collapse_alternatives` in (0,1)),
  CONSTRAINT `CONSTRAINT_10` CHECK (`convert_html_to_plaintext` in (0,1)),
  CONSTRAINT `CONSTRAINT_11` CHECK (`bounce_notify_owner_on_disable` in (0,1)),
  CONSTRAINT `CONSTRAINT_12` CHECK (`bounce_notify_owner_on_removal` in (0,1)),
  CONSTRAINT `CONSTRAINT_13` CHECK (`process_bounces` in (0,1)),
  CONSTRAINT `CONSTRAINT_14` CHECK (`dmarc_mitigate_unconditionally` in (0,1)),
  CONSTRAINT `CONSTRAINT_15` CHECK (`digests_enabled` in (0,1)),
  CONSTRAINT `CONSTRAINT_16` CHECK (`digest_is_default` in (0,1)),
  CONSTRAINT `CONSTRAINT_17` CHECK (`digest_send_periodic` in (0,1)),
  CONSTRAINT `CONSTRAINT_18` CHECK (`emergency` in (0,1)),
  CONSTRAINT `CONSTRAINT_19` CHECK (`encode_ascii_prefixes` in (0,1)),
  CONSTRAINT `CONSTRAINT_20` CHECK (`first_strip_reply_to` in (0,1)),
  CONSTRAINT `CONSTRAINT_21` CHECK (`forward_auto_discards` in (0,1)),
  CONSTRAINT `CONSTRAINT_22` CHECK (`gateway_to_mail` in (0,1)),
  CONSTRAINT `CONSTRAINT_23` CHECK (`gateway_to_news` in (0,1)),
  CONSTRAINT `CONSTRAINT_24` CHECK (`nntp_prefix_subject_too` in (0,1)),
  CONSTRAINT `CONSTRAINT_25` CHECK (`obscure_addresses` in (0,1)),
  CONSTRAINT `CONSTRAINT_26` CHECK (`require_explicit_destination` in (0,1)),
  CONSTRAINT `CONSTRAINT_27` CHECK (`respond_to_post_requests` in (0,1)),
  CONSTRAINT `CONSTRAINT_28` CHECK (`scrub_nondigest` in (0,1)),
  CONSTRAINT `CONSTRAINT_29` CHECK (`send_goodbye_message` in (0,1)),
  CONSTRAINT `CONSTRAINT_30` CHECK (`send_welcome_message` in (0,1)),
  CONSTRAINT `CONSTRAINT_31` CHECK (`topics_enabled` in (0,1))
) ENGINE=InnoDB AUTO_INCREMENT=745 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Stashbot added a comment.Dec 7 2021, 10:01 AM

Mentioned in SAL (#wikimedia-operations) [2021-12-07T10:01:02Z] <marostegui> Deploy schema change on mailman (m5) T286552

Marostegui added a comment.Dec 7 2021, 10:02 AM
root@db1132.eqiad.wmnet[mailman3]> ALTER TABLE mailinglist MODIFY autoresponse_owner_text TEXT COLLATE utf8mb4_bin NULL; ALTER TABLE mailinglist MODIFY autoresponse_postings_text TEXT COLLATE utf8mb4_bin NULL; ALTER TABLE mailinglist MODIFY autoresponse_request_text TEXT COLLATE utf8mb4_bin NULL;
Query OK, 714 rows affected (0.067 sec)
Records: 714  Duplicates: 0  Warnings: 0

Query OK, 714 rows affected (0.041 sec)
Records: 714  Duplicates: 0  Warnings: 0

Query OK, 714 rows affected (0.045 sec)
Records: 714  Duplicates: 0  Warnings: 0

New table schema

CREATE TABLE `mailinglist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `list_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `mail_host` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `list_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `allow_list_posts` tinyint(1) DEFAULT NULL,
  `include_rfc2369_headers` tinyint(1) DEFAULT NULL,
  `advertised` tinyint(1) DEFAULT NULL,
  `anonymous_list` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `next_request_id` int(11) DEFAULT NULL,
  `next_digest_number` int(11) DEFAULT NULL,
  `digest_last_sent_at` datetime DEFAULT NULL,
  `volume` int(11) DEFAULT NULL,
  `last_post_at` datetime DEFAULT NULL,
  `accept_these_nonmembers` blob DEFAULT NULL,
  `admin_immed_notify` tinyint(1) DEFAULT NULL,
  `admin_notify_mchanges` tinyint(1) DEFAULT NULL,
  `administrivia` tinyint(1) DEFAULT NULL,
  `archive_policy` int(11) DEFAULT NULL,
  `autoresponse_grace_period` datetime DEFAULT NULL,
  `autorespond_owner` int(11) DEFAULT NULL,
  `autoresponse_owner_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `autorespond_postings` int(11) DEFAULT NULL,
  `autoresponse_postings_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `autorespond_requests` int(11) DEFAULT NULL,
  `autoresponse_request_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `filter_action` int(11) DEFAULT NULL,
  `filter_content` tinyint(1) DEFAULT NULL,
  `collapse_alternatives` tinyint(1) DEFAULT NULL,
  `convert_html_to_plaintext` tinyint(1) DEFAULT NULL,
  `bounce_info_stale_after` datetime DEFAULT NULL,
  `bounce_matching_headers` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `bounce_notify_owner_on_disable` tinyint(1) DEFAULT NULL,
  `bounce_notify_owner_on_removal` tinyint(1) DEFAULT NULL,
  `bounce_score_threshold` int(11) DEFAULT NULL,
  `bounce_you_are_disabled_warnings` int(11) DEFAULT NULL,
  `bounce_you_are_disabled_warnings_interval` datetime DEFAULT NULL,
  `forward_unrecognized_bounces_to` int(11) DEFAULT NULL,
  `process_bounces` tinyint(1) DEFAULT NULL,
  `dmarc_mitigate_action` int(11) DEFAULT NULL,
  `dmarc_mitigate_unconditionally` tinyint(1) DEFAULT NULL,
  `dmarc_moderation_notice` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `dmarc_wrapped_message_text` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `default_member_action` int(11) DEFAULT NULL,
  `default_nonmember_action` int(11) DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `digests_enabled` tinyint(1) DEFAULT NULL,
  `digest_is_default` tinyint(1) DEFAULT NULL,
  `digest_send_periodic` tinyint(1) DEFAULT NULL,
  `digest_size_threshold` float DEFAULT NULL,
  `digest_volume_frequency` int(11) DEFAULT NULL,
  `discard_these_nonmembers` blob DEFAULT NULL,
  `emergency` tinyint(1) DEFAULT NULL,
  `encode_ascii_prefixes` tinyint(1) DEFAULT NULL,
  `first_strip_reply_to` tinyint(1) DEFAULT NULL,
  `forward_auto_discards` tinyint(1) DEFAULT NULL,
  `gateway_to_mail` tinyint(1) DEFAULT NULL,
  `gateway_to_news` tinyint(1) DEFAULT NULL,
  `hold_these_nonmembers` blob DEFAULT NULL,
  `info` text CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `linked_newsgroup` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `max_days_to_hold` int(11) DEFAULT NULL,
  `max_message_size` int(11) DEFAULT NULL,
  `max_num_recipients` int(11) DEFAULT NULL,
  `member_moderation_notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `moderator_password` blob DEFAULT NULL,
  `newsgroup_moderation` int(11) DEFAULT NULL,
  `nntp_prefix_subject_too` tinyint(1) DEFAULT NULL,
  `nonmember_rejection_notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `obscure_addresses` tinyint(1) DEFAULT NULL,
  `owner_chain` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `owner_pipeline` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `personalize` int(11) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `posting_chain` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `posting_pipeline` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `preferred_language` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `reject_these_nonmembers` blob DEFAULT NULL,
  `reply_goes_to_list` int(11) DEFAULT NULL,
  `reply_to_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `require_explicit_destination` tinyint(1) DEFAULT NULL,
  `respond_to_post_requests` tinyint(1) DEFAULT NULL,
  `member_roster_visibility` int(11) DEFAULT NULL,
  `scrub_nondigest` tinyint(1) DEFAULT NULL,
  `send_goodbye_message` tinyint(1) DEFAULT NULL,
  `send_welcome_message` tinyint(1) DEFAULT NULL,
  `subject_prefix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `subscription_policy` int(11) DEFAULT NULL,
  `topics` blob DEFAULT NULL,
  `topics_bodylines_limit` int(11) DEFAULT NULL,
  `topics_enabled` tinyint(1) DEFAULT NULL,
  `unsubscription_policy` int(11) DEFAULT NULL,
  `usenet_watermark` int(11) DEFAULT NULL,
  `archive_rendering_mode` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_mailinglist_list_id` (`list_id`),
  KEY `ix_mailinglist_mail_host` (`mail_host`),
  KEY `ix_mailinglist_list_name` (`list_name`),
  CONSTRAINT `CONSTRAINT_1` CHECK (`allow_list_posts` in (0,1)),
  CONSTRAINT `CONSTRAINT_2` CHECK (`include_rfc2369_headers` in (0,1)),
  CONSTRAINT `CONSTRAINT_3` CHECK (`advertised` in (0,1)),
  CONSTRAINT `CONSTRAINT_4` CHECK (`anonymous_list` in (0,1)),
  CONSTRAINT `CONSTRAINT_5` CHECK (`admin_immed_notify` in (0,1)),
  CONSTRAINT `CONSTRAINT_6` CHECK (`admin_notify_mchanges` in (0,1)),
  CONSTRAINT `CONSTRAINT_7` CHECK (`administrivia` in (0,1)),
  CONSTRAINT `CONSTRAINT_8` CHECK (`filter_content` in (0,1)),
  CONSTRAINT `CONSTRAINT_9` CHECK (`collapse_alternatives` in (0,1)),
  CONSTRAINT `CONSTRAINT_10` CHECK (`convert_html_to_plaintext` in (0,1)),
  CONSTRAINT `CONSTRAINT_11` CHECK (`bounce_notify_owner_on_disable` in (0,1)),
  CONSTRAINT `CONSTRAINT_12` CHECK (`bounce_notify_owner_on_removal` in (0,1)),
  CONSTRAINT `CONSTRAINT_13` CHECK (`process_bounces` in (0,1)),
  CONSTRAINT `CONSTRAINT_14` CHECK (`dmarc_mitigate_unconditionally` in (0,1)),
  CONSTRAINT `CONSTRAINT_15` CHECK (`digests_enabled` in (0,1)),
  CONSTRAINT `CONSTRAINT_16` CHECK (`digest_is_default` in (0,1)),
  CONSTRAINT `CONSTRAINT_17` CHECK (`digest_send_periodic` in (0,1)),
  CONSTRAINT `CONSTRAINT_18` CHECK (`emergency` in (0,1)),
  CONSTRAINT `CONSTRAINT_19` CHECK (`encode_ascii_prefixes` in (0,1)),
  CONSTRAINT `CONSTRAINT_20` CHECK (`first_strip_reply_to` in (0,1)),
  CONSTRAINT `CONSTRAINT_21` CHECK (`forward_auto_discards` in (0,1)),
  CONSTRAINT `CONSTRAINT_22` CHECK (`gateway_to_mail` in (0,1)),
  CONSTRAINT `CONSTRAINT_23` CHECK (`gateway_to_news` in (0,1)),
  CONSTRAINT `CONSTRAINT_24` CHECK (`nntp_prefix_subject_too` in (0,1)),
  CONSTRAINT `CONSTRAINT_25` CHECK (`obscure_addresses` in (0,1)),
  CONSTRAINT `CONSTRAINT_26` CHECK (`require_explicit_destination` in (0,1)),
  CONSTRAINT `CONSTRAINT_27` CHECK (`respond_to_post_requests` in (0,1)),
  CONSTRAINT `CONSTRAINT_28` CHECK (`scrub_nondigest` in (0,1)),
  CONSTRAINT `CONSTRAINT_29` CHECK (`send_goodbye_message` in (0,1)),
  CONSTRAINT `CONSTRAINT_30` CHECK (`send_welcome_message` in (0,1)),
  CONSTRAINT `CONSTRAINT_31` CHECK (`topics_enabled` in (0,1))
) ENGINE=InnoDB AUTO_INCREMENT=745 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Marostegui closed this task as Resolved.Dec 7 2021, 10:03 AM

All done!

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits