0001_initial.py 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224
  1. # -*- coding: utf-8 -*-
  2. from __future__ import unicode_literals
  3. import django.db.models.deletion
  4. import django.utils.timezone
  5. from django.conf import settings
  6. from django.db import migrations, models
  7. from misago.core.pgutils import CreatePartialIndex
  8. class Migration(migrations.Migration):
  9. dependencies = [
  10. ('auth', '0001_initial'),
  11. ('misago_acl', '0001_initial'),
  12. ]
  13. operations = [
  14. migrations.CreateModel(
  15. name='User',
  16. fields=[
  17. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  18. ('password', models.CharField(max_length=128, verbose_name='password')),
  19. ('last_login', models.DateTimeField(default=django.utils.timezone.now, verbose_name='last login')),
  20. ('username', models.CharField(max_length=30)),
  21. ('slug', models.CharField(unique=True, max_length=30)),
  22. ('email', models.EmailField(max_length=255, db_index=True)),
  23. ('email_hash', models.CharField(unique=True, max_length=32)),
  24. ('joined_on', models.DateTimeField(default=django.utils.timezone.now, verbose_name='joined on')),
  25. ('joined_from_ip', models.GenericIPAddressField()),
  26. ('last_ip', models.GenericIPAddressField(null=True, blank=True)),
  27. ('is_hiding_presence', models.BooleanField(default=False)),
  28. ('title', models.CharField(max_length=255, null=True, blank=True)),
  29. ('requires_activation', models.PositiveIntegerField(default=0)),
  30. ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into admin sites.', verbose_name='staff status')),
  31. ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
  32. ('acl_key', models.CharField(max_length=12, null=True, blank=True)),
  33. ('groups', models.ManyToManyField(related_query_name='user', related_name='user_set', to='auth.Group', blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of his/her group.', verbose_name='groups')),
  34. ('roles', models.ManyToManyField(to='misago_acl.Role')),
  35. ('user_permissions', models.ManyToManyField(related_query_name='user', related_name='user_set', to='auth.Permission', blank=True, help_text='Specific permissions for this user.', verbose_name='user permissions')),
  36. ('is_avatar_locked', models.BooleanField(default=False)),
  37. ('avatar_hash', models.CharField(max_length=8, default='-')),
  38. ('avatar_crop', models.CharField(max_length=255, null=True, blank=True)),
  39. ('avatar_lock_user_message', models.TextField(null=True, blank=True)),
  40. ('avatar_lock_staff_message', models.TextField(null=True, blank=True)),
  41. ('is_signature_locked', models.BooleanField(default=False)),
  42. ('signature', models.TextField(null=True, blank=True)),
  43. ('signature_parsed', models.TextField(null=True, blank=True)),
  44. ('signature_checksum', models.CharField(max_length=64, null=True, blank=True)),
  45. ('signature_lock_user_message', models.TextField(null=True, blank=True)),
  46. ('signature_lock_staff_message', models.TextField(null=True, blank=True)),
  47. ('warning_level', models.PositiveIntegerField(default=0)),
  48. ('warning_level_update_on', models.DateTimeField(null=True, blank=True)),
  49. ('following', models.PositiveIntegerField(default=0)),
  50. ('followers', models.PositiveIntegerField(default=0)),
  51. ('new_notifications', models.PositiveIntegerField(default=0)),
  52. ('limits_private_thread_invites_to', models.PositiveIntegerField(default=0)),
  53. ('unread_private_threads', models.PositiveIntegerField(default=0)),
  54. ('sync_unread_private_threads', models.BooleanField(default=False)),
  55. ('subscribe_to_started_threads', models.PositiveIntegerField(default=0)),
  56. ('subscribe_to_replied_threads', models.PositiveIntegerField(default=0)),
  57. ('threads', models.PositiveIntegerField(default=0)),
  58. ('posts', models.PositiveIntegerField(default=0, db_index=True)),
  59. ('last_posted_on', models.DateTimeField(null=True, blank=True)),
  60. ('last_searched_on', models.DateTimeField(null=True, blank=True)),
  61. ],
  62. options={
  63. 'abstract': False,
  64. },
  65. bases=(models.Model,),
  66. ),
  67. CreatePartialIndex(
  68. field='User.is_staff',
  69. index_name='misago_users_user_is_staff_partial',
  70. condition='is_staff = TRUE',
  71. ),
  72. CreatePartialIndex(
  73. field='User.requires_activation',
  74. index_name='misago_users_user_requires_activation_partial',
  75. condition='requires_activation > 0',
  76. ),
  77. migrations.CreateModel(
  78. name='Online',
  79. fields=[
  80. ('current_ip', models.GenericIPAddressField()),
  81. ('last_click', models.DateTimeField(default=django.utils.timezone.now)),
  82. ('user', models.OneToOneField(related_name='online_tracker', primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
  83. ],
  84. options={
  85. },
  86. bases=(models.Model,),
  87. ),
  88. migrations.CreateModel(
  89. name='UsernameChange',
  90. fields=[
  91. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  92. ('changed_by_username', models.CharField(max_length=30)),
  93. ('changed_on', models.DateTimeField(default=django.utils.timezone.now)),
  94. ('new_username', models.CharField(max_length=255)),
  95. ('old_username', models.CharField(max_length=255)),
  96. ('changed_by', models.ForeignKey(related_name='user_renames', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  97. ('user', models.ForeignKey(related_name='namechanges', to=settings.AUTH_USER_MODEL)),
  98. ],
  99. options={
  100. 'get_latest_by': b'changed_on',
  101. },
  102. bases=(models.Model,),
  103. ),
  104. migrations.CreateModel(
  105. name='Rank',
  106. fields=[
  107. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  108. ('name', models.CharField(max_length=255)),
  109. ('slug', models.CharField(unique=True, max_length=255)),
  110. ('description', models.TextField(null=True, blank=True)),
  111. ('title', models.CharField(max_length=255, null=True, blank=True)),
  112. ('css_class', models.CharField(max_length=255, null=True, blank=True)),
  113. ('is_default', models.BooleanField(default=False)),
  114. ('is_tab', models.BooleanField(default=False)),
  115. ('order', models.IntegerField(default=0)),
  116. ('roles', models.ManyToManyField(to='misago_acl.Role', null=True, blank=True)),
  117. ],
  118. options={
  119. 'get_latest_by': b'order',
  120. },
  121. bases=(models.Model,),
  122. ),
  123. migrations.AddField(
  124. model_name='user',
  125. name='rank',
  126. field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to_field='id', blank=True, to='misago_users.Rank', null=True),
  127. preserve_default=True,
  128. ),
  129. migrations.AddField(
  130. model_name='user',
  131. name='follows',
  132. field=models.ManyToManyField(related_name='followed_by', to=settings.AUTH_USER_MODEL),
  133. preserve_default=True,
  134. ),
  135. migrations.AddField(
  136. model_name='user',
  137. name='blocks',
  138. field=models.ManyToManyField(related_name='blocked_by', to=settings.AUTH_USER_MODEL),
  139. preserve_default=True,
  140. ),
  141. migrations.CreateModel(
  142. name='ActivityRanking',
  143. fields=[
  144. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  145. ('user', models.ForeignKey(related_name='+', to=settings.AUTH_USER_MODEL)),
  146. ('score', models.PositiveIntegerField(default=0, db_index=True)),
  147. ],
  148. options={
  149. },
  150. bases=(models.Model,),
  151. ),
  152. migrations.CreateModel(
  153. name='Ban',
  154. fields=[
  155. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  156. ('check_type', models.PositiveIntegerField(default=0, db_index=True)),
  157. ('banned_value', models.CharField(max_length=255, db_index=True)),
  158. ('user_message', models.TextField(null=True, blank=True)),
  159. ('staff_message', models.TextField(null=True, blank=True)),
  160. ('expires_on', models.DateTimeField(null=True, blank=True, db_index=True)),
  161. ('is_checked', models.BooleanField(default=True, db_index=True)),
  162. ],
  163. bases=(models.Model,),
  164. ),
  165. migrations.CreateModel(
  166. name='BanCache',
  167. fields=[
  168. ('user_message', models.TextField(null=True, blank=True)),
  169. ('staff_message', models.TextField(null=True, blank=True)),
  170. ('bans_version', models.PositiveIntegerField(default=0)),
  171. ('expires_on', models.DateTimeField(null=True, blank=True)),
  172. ('ban', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_users.Ban', null=True)),
  173. ('user', models.OneToOneField(related_name='ban_cache', primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
  174. ],
  175. options={
  176. },
  177. bases=(models.Model,),
  178. ),
  179. migrations.CreateModel(
  180. name='WarningLevel',
  181. fields=[
  182. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  183. ('name', models.CharField(max_length=255)),
  184. ('level', models.PositiveIntegerField(default=1, db_index=True)),
  185. ('length_in_minutes', models.PositiveIntegerField(default=0)),
  186. ('restricts_posting_replies', models.PositiveIntegerField(default=0)),
  187. ('restricts_posting_threads', models.PositiveIntegerField(default=0)),
  188. ],
  189. options={
  190. },
  191. bases=(models.Model,),
  192. ),
  193. migrations.CreateModel(
  194. name='UserWarning',
  195. fields=[
  196. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  197. ('reason', models.TextField(null=True, blank=True)),
  198. ('given_on', models.DateTimeField(default=django.utils.timezone.now)),
  199. ('giver_username', models.CharField(max_length=255)),
  200. ('giver_slug', models.CharField(max_length=255)),
  201. ('is_canceled', models.BooleanField(default=False)),
  202. ('canceled_on', models.DateTimeField(null=True, blank=True)),
  203. ('canceler_username', models.CharField(max_length=255)),
  204. ('canceler_slug', models.CharField(max_length=255)),
  205. ('canceler', models.ForeignKey(related_name='warnings_canceled', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  206. ('giver', models.ForeignKey(related_name='warnings_given', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  207. ('user', models.ForeignKey(related_name='warnings', to=settings.AUTH_USER_MODEL)),
  208. ],
  209. options={
  210. },
  211. bases=(models.Model,),
  212. ),
  213. CreatePartialIndex(
  214. field='UserWarning.is_canceled',
  215. index_name='misago_userwarning_is_canceled_partial',
  216. condition='is_canceled = FALSE',
  217. ),
  218. ]