Skip to content

Instantly share code, notes, and snippets.

@benjamn
Created February 17, 2011 07:14
Show Gist options
  • Save benjamn/831208 to your computer and use it in GitHub Desktop.
Save benjamn/831208 to your computer and use it in GitHub Desktop.
diff --git a/web/lib/a/schema_defs.py b/web/lib/a/schema_defs.py
index bfcb336..530e8fb 100644
--- a/web/lib/a/schema_defs.py
+++ b/web/lib/a/schema_defs.py
@@ -4091,4 +4091,37 @@ defs = [
ENGINE=InnoDB DEFAULT CHARSET=utf8''', 'log_db'),
(868, '''ALTER TABLE flagged_flash_client_ids ADD INDEX(time)''', 'log_db'),
+
+ # Avoid errors updating due to limited text column sizes.
+ (869, '''ALTER TABLE answer_comment MODIFY content longtext not null'''),
+ (870, '''ALTER TABLE question_comment MODIFY content longtext not null'''),
+ (871, '''ALTER TABLE operation MODIFY data_json longtext not null'''),
+ (872, '''ALTER TABLE question MODIFY details longtext not null'''),
+ (873, '''ALTER TABLE answer MODIFY content longtext not null'''),
+ (874, '''ALTER TABLE xlog MODIFY content longtext not null'''),
+ (875, '''ALTER TABLE thread_msg MODIFY content longtext not null'''),
+ (876, '''ALTER TABLE recent_errors MODIFY content longtext not null'''),
+ (877, '''ALTER TABLE user_profile MODIFY bio longtext not null'''),
+ (878, '''ALTER TABLE suggested_questions MODIFY msg longtext not null'''),
+ (879, '''ALTER TABLE suggested_questions_to_email MODIFY msg longtext not null'''),
+ (880, '''ALTER TABLE delayed_task_queue MODIFY data longtext not null'''),
+ (881, '''ALTER TABLE zlog MODIFY content longtext not null'''),
+ (882, '''ALTER TABLE interview_questions_pending MODIFY details longtext not null'''),
+ (883, '''ALTER TABLE draft_answer MODIFY content longtext not null'''),
+ (884, '''ALTER TABLE pycache MODIFY var_code longtext not null'''),
+ (885, '''ALTER TABLE draft_thread_msg MODIFY content longtext not null'''),
+ (886, '''ALTER TABLE admin_log MODIFY data_json longtext not null'''),
+ (887, '''ALTER TABLE post MODIFY content longtext not null'''),
+ (888, '''ALTER TABLE post_comment MODIFY content longtext not null'''),
+ (889, '''ALTER TABLE post_draft MODIFY content longtext not null'''),
+ (890, '''ALTER TABLE user_disclaimer MODIFY content longtext not null'''),
+ (891, '''ALTER TABLE page_perf_tracking MODIFY results_json longtext not null'''),
+ (892, '''ALTER TABLE query_log MODIFY results longtext not null'''),
+ (893, '''ALTER TABLE classifier_files MODIFY data_json longtext not null'''),
+
+ # These used to be mediumtext.
+ (894, '''ALTER TABLE suggested_answer MODIFY content longtext not null'''),
+ (895, '''ALTER TABLE topic_rules MODIFY rules longtext not null'''),
+ (896, '''ALTER TABLE post_suggested_edit_content MODIFY content longtext not null'''),
+
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment