class Migration(migrations.Migration):
dependencies = [
('zerver', '0094_realm_filter_url_validator'),
]
operations = [
migrations.RunSQL(
create_index_if_not_exist(
index_name='zerver_usermessage_unread_message_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 1) = 0',
),
reverse_sql='DROP INDEX zerver_usermessage_unread_message_id;'),
]
class Migration(migrations.Migration):
dependencies = [
('zerver', '0081_make_emoji_lowercase'),
]
operations = [
migrations.RunSQL(
create_index_if_not_exist(
index_name='zerver_usermessage_starred_message_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 2) != 0',
),
reverse_sql='DROP INDEX zerver_usermessage_starred_message_id;'),
]
class Migration(migrations.Migration):
dependencies = [
('zerver', '0098_index_has_alert_word_user_messages'),
]
operations = [
migrations.RunSQL(
create_index_if_not_exist(
index_name='zerver_usermessage_wildcard_mentioned_message_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 8) != 0 OR (flags & 16) != 0',
),
reverse_sql=
'DROP INDEX zerver_usermessage_wilcard_mentioned_message_id;'),
]
class Migration(migrations.Migration):
dependencies = [
('zerver', '0097_reactions_emoji_code'),
]
operations = [
migrations.RunSQL(
create_index_if_not_exist(
index_name='zerver_usermessage_has_alert_word_message_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 512) != 0',
),
reverse_sql=
'DROP INDEX zerver_usermessage_has_alert_word_message_id;'),
]
class Migration(migrations.Migration):
dependencies = [
('zerver', '0179_rename_to_digest_emails_enabled'),
]
operations = [
migrations.AlterField(
model_name='archivedusermessage',
name='flags',
field=bitfield.models.BitField([
'read', 'starred', 'collapsed', 'mentioned',
'wildcard_mentioned', 'summarize_in_home',
'summarize_in_stream', 'force_expand', 'force_collapse',
'has_alert_word', 'historical', 'is_private',
'active_mobile_push_notification'
],
default=0),
),
migrations.AlterField(
model_name='usermessage',
name='flags',
field=bitfield.models.BitField([
'read', 'starred', 'collapsed', 'mentioned',
'wildcard_mentioned', 'summarize_in_home',
'summarize_in_stream', 'force_expand', 'force_collapse',
'has_alert_word', 'historical', 'is_private',
'active_mobile_push_notification'
],
default=0),
),
migrations.RunSQL(
create_index_if_not_exist(
index_name=
'zerver_usermessage_active_mobile_push_notification_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 4096) != 0',
),
reverse_sql=
'DROP INDEX zerver_usermessage_active_mobile_push_notification_id;'
),
]
class Migration(migrations.Migration):
atomic = False
dependencies = [
('zerver', '0176_remove_subscription_notifications'),
]
operations = [
migrations.AlterField(
model_name='archivedusermessage',
name='flags',
field=bitfield.models.BitField([
'read', 'starred', 'collapsed', 'mentioned',
'wildcard_mentioned', 'summarize_in_home',
'summarize_in_stream', 'force_expand', 'force_collapse',
'has_alert_word', 'historical', 'is_private'
],
default=0),
),
migrations.AlterField(
model_name='usermessage',
name='flags',
field=bitfield.models.BitField([
'read', 'starred', 'collapsed', 'mentioned',
'wildcard_mentioned', 'summarize_in_home',
'summarize_in_stream', 'force_expand', 'force_collapse',
'has_alert_word', 'historical', 'is_private'
],
default=0),
),
migrations.RunSQL(
create_index_if_not_exist(
index_name='zerver_usermessage_is_private_message_id',
table_name='zerver_usermessage',
column_string='user_profile_id, message_id',
where_clause='WHERE (flags & 2048) != 0',
),
reverse_sql='DROP INDEX zerver_usermessage_is_private_message_id;'
),
migrations.RunPython(reset_is_private_flag,
reverse_code=migrations.RunPython.noop),
]
