0001_initial.py 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  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_tmp', models.ImageField(max_length=255, upload_to=misago.users.avatars.store.upload_to, null=True, blank=True)),
  46. ('avatar_src', models.ImageField(max_length=255, 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(max_length=255, upload_to=misago.users.avatars.store.upload_to)),
  170. ],
  171. ),
  172. migrations.CreateModel(
  173. name='AvatarGallery',
  174. fields=[
  175. ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  176. ('gallery', models.CharField(max_length=255)),
  177. ('image', models.ImageField(max_length=255, upload_to=misago.users.avatars.store.upload_to)),
  178. ],
  179. options={
  180. 'ordering': ['gallery', 'name'],
  181. },
  182. ),
  183. migrations.CreateModel(
  184. name='Ban',
  185. fields=[
  186. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  187. ('check_type', models.PositiveIntegerField(default=0, db_index=True)),
  188. ('banned_value', models.CharField(max_length=255, db_index=True)),
  189. ('user_message', models.TextField(null=True, blank=True)),
  190. ('staff_message', models.TextField(null=True, blank=True)),
  191. ('expires_on', models.DateTimeField(null=True, blank=True, db_index=True)),
  192. ('is_checked', models.BooleanField(default=True, db_index=True)),
  193. ],
  194. bases=(models.Model,),
  195. ),
  196. migrations.CreateModel(
  197. name='BanCache',
  198. fields=[
  199. ('user_message', models.TextField(null=True, blank=True)),
  200. ('staff_message', models.TextField(null=True, blank=True)),
  201. ('bans_version', models.PositiveIntegerField(default=0)),
  202. ('expires_on', models.DateTimeField(null=True, blank=True)),
  203. ('ban', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_users.Ban', null=True)),
  204. ('user', models.OneToOneField(related_name='ban_cache', primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)),
  205. ],
  206. options={
  207. },
  208. bases=(models.Model,),
  209. ),
  210. migrations.CreateModel(
  211. name='WarningLevel',
  212. fields=[
  213. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  214. ('name', models.CharField(max_length=255)),
  215. ('level', models.PositiveIntegerField(default=1, db_index=True)),
  216. ('length_in_minutes', models.PositiveIntegerField(default=0)),
  217. ('restricts_posting_replies', models.PositiveIntegerField(default=0)),
  218. ('restricts_posting_threads', models.PositiveIntegerField(default=0)),
  219. ],
  220. options={
  221. },
  222. bases=(models.Model,),
  223. ),
  224. migrations.CreateModel(
  225. name='UserWarning',
  226. fields=[
  227. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  228. ('reason', models.TextField(null=True, blank=True)),
  229. ('given_on', models.DateTimeField(default=django.utils.timezone.now)),
  230. ('giver_username', models.CharField(max_length=255)),
  231. ('giver_slug', models.CharField(max_length=255)),
  232. ('is_canceled', models.BooleanField(default=False)),
  233. ('canceled_on', models.DateTimeField(null=True, blank=True)),
  234. ('canceler_username', models.CharField(max_length=255)),
  235. ('canceler_slug', models.CharField(max_length=255)),
  236. ('canceler', models.ForeignKey(related_name='warnings_canceled', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  237. ('giver', models.ForeignKey(related_name='warnings_given', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  238. ('user', models.ForeignKey(related_name='warnings', to=settings.AUTH_USER_MODEL)),
  239. ],
  240. options={
  241. },
  242. bases=(models.Model,),
  243. ),
  244. CreatePartialIndex(
  245. field='UserWarning.is_canceled',
  246. index_name='misago_userwarning_is_canceled_partial',
  247. condition='is_canceled = FALSE',
  248. ),
  249. ]