0001_initial.py 13 KB

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