0001_initial.py 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  1. # -*- coding: utf-8 -*-
  2. from __future__ import unicode_literals
  3. from django.conf import settings
  4. from django.db import models, migrations
  5. import django.db.models.deletion
  6. import django.utils.timezone
  7. from misago.core.pgutils import CreatePartialIndex
  8. class Migration(migrations.Migration):
  9. dependencies = [
  10. ('misago_forums', '0001_initial'),
  11. migrations.swappable_dependency(settings.AUTH_USER_MODEL),
  12. ]
  13. operations = [
  14. migrations.CreateModel(
  15. name='Label',
  16. fields=[
  17. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  18. ('name', models.CharField(max_length=255)),
  19. ('slug', models.SlugField(max_length=255)),
  20. ('css_class', models.CharField(max_length=255, null=True, blank=True)),
  21. ('forums', models.ManyToManyField(to='misago_forums.Forum')),
  22. ],
  23. options={
  24. },
  25. bases=(models.Model,),
  26. ),
  27. migrations.CreateModel(
  28. name='Post',
  29. fields=[
  30. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  31. ('poster_name', models.CharField(max_length=255)),
  32. ('poster_ip', models.GenericIPAddressField()),
  33. ('original', models.TextField()),
  34. ('parsed', models.TextField()),
  35. ('checksum', models.CharField(max_length=64, default='-')),
  36. ('has_attachments', models.BooleanField(default=False)),
  37. ('pickled_attachments', models.TextField(null=True, blank=True)),
  38. ('posted_on', models.DateTimeField()),
  39. ('updated_on', models.DateTimeField()),
  40. ('edits', models.PositiveIntegerField(default=0)),
  41. ('last_editor_name', models.CharField(max_length=255, null=True, blank=True)),
  42. ('last_editor_slug', models.SlugField(max_length=255, null=True, blank=True)),
  43. ('hidden_by', models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  44. ('hidden_by_name', models.CharField(max_length=255, null=True, blank=True)),
  45. ('hidden_by_slug', models.SlugField(max_length=255, null=True, blank=True)),
  46. ('hidden_on', models.DateTimeField(default=django.utils.timezone.now)),
  47. ('is_reported', models.BooleanField(default=False)),
  48. ('is_moderated', models.BooleanField(default=False, db_index=True)),
  49. ('is_hidden', models.BooleanField(default=False)),
  50. ('is_protected', models.BooleanField(default=False)),
  51. ('forum', models.ForeignKey(to='misago_forums.Forum')),
  52. ('last_editor', models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  53. ('mentions', models.ManyToManyField(related_name='mention_set', to=settings.AUTH_USER_MODEL)),
  54. ('poster', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  55. ],
  56. options={
  57. },
  58. bases=(models.Model,),
  59. ),
  60. CreatePartialIndex(
  61. field='Post.is_reported',
  62. index_name='misago_post_is_reported_partial',
  63. condition='is_reported = TRUE',
  64. ),
  65. CreatePartialIndex(
  66. field='Post.is_hidden',
  67. index_name='misago_post_is_hidden_partial',
  68. condition='is_hidden = FALSE',
  69. ),
  70. migrations.CreateModel(
  71. name='Thread',
  72. fields=[
  73. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  74. ('title', models.CharField(max_length=255)),
  75. ('slug', models.CharField(max_length=255)),
  76. ('replies', models.PositiveIntegerField(default=0, db_index=True)),
  77. ('has_reported_posts', models.BooleanField(default=False)),
  78. ('has_moderated_posts', models.BooleanField(default=False)),
  79. ('has_hidden_posts', models.BooleanField(default=False)),
  80. ('has_events', models.BooleanField(default=False)),
  81. ('started_on', models.DateTimeField(db_index=True)),
  82. ('starter_name', models.CharField(max_length=255)),
  83. ('starter_slug', models.CharField(max_length=255)),
  84. ('last_post_on', models.DateTimeField(db_index=True)),
  85. ('last_poster_name', models.CharField(max_length=255, null=True, blank=True)),
  86. ('last_poster_slug', models.CharField(max_length=255, null=True, blank=True)),
  87. ('is_pinned', models.BooleanField(default=False, db_index=True)),
  88. ('is_poll', models.BooleanField(default=False)),
  89. ('is_moderated', models.BooleanField(default=False, db_index=True)),
  90. ('is_hidden', models.BooleanField(default=False)),
  91. ('is_closed', models.BooleanField(default=False)),
  92. ],
  93. options={
  94. },
  95. bases=(models.Model,),
  96. ),
  97. migrations.CreateModel(
  98. name='Event',
  99. fields=[
  100. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  101. ('author_name', models.CharField(max_length=255)),
  102. ('author_slug', models.CharField(max_length=255)),
  103. ('icon', models.CharField(max_length=255)),
  104. ('occured_on', models.DateTimeField(default=django.utils.timezone.now, db_index=True)),
  105. ('message', models.CharField(max_length=255)),
  106. ('checksum', models.CharField(max_length=64, default='-')),
  107. ('is_hidden', models.BooleanField(default=False)),
  108. ('author', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  109. ('forum', models.ForeignKey(to='misago_forums.Forum')),
  110. ('thread', models.ForeignKey(to='misago_threads.Thread')),
  111. ],
  112. options={
  113. },
  114. bases=(models.Model,),
  115. ),
  116. CreatePartialIndex(
  117. field='Thread.has_reported_posts',
  118. index_name='misago_thread_has_reported_posts_partial',
  119. condition='has_reported_posts = TRUE',
  120. ),
  121. CreatePartialIndex(
  122. field='Thread.has_moderated_posts',
  123. index_name='misago_thread_has_moderated_posts_partial',
  124. condition='has_moderated_posts = TRUE',
  125. ),
  126. CreatePartialIndex(
  127. field='Thread.is_hidden',
  128. index_name='misago_thread_is_hidden_partial',
  129. condition='is_hidden = FALSE',
  130. ),
  131. migrations.AddField(
  132. model_name='post',
  133. name='thread',
  134. field=models.ForeignKey(to='misago_threads.Thread'),
  135. preserve_default=True,
  136. ),
  137. migrations.AddField(
  138. model_name='thread',
  139. name='first_post',
  140. field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
  141. preserve_default=True,
  142. ),
  143. migrations.AddField(
  144. model_name='thread',
  145. name='forum',
  146. field=models.ForeignKey(to='misago_forums.Forum'),
  147. preserve_default=True,
  148. ),
  149. migrations.AddField(
  150. model_name='thread',
  151. name='last_post',
  152. field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
  153. preserve_default=True,
  154. ),
  155. migrations.AddField(
  156. model_name='thread',
  157. name='last_poster',
  158. field=models.ForeignKey(related_name='last_poster_set', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True),
  159. preserve_default=True,
  160. ),
  161. migrations.AddField(
  162. model_name='thread',
  163. name='label',
  164. field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Label', null=True),
  165. preserve_default=True,
  166. ),
  167. migrations.AddField(
  168. model_name='thread',
  169. name='starter',
  170. field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True),
  171. preserve_default=True,
  172. ),
  173. migrations.AlterIndexTogether(
  174. name='thread',
  175. index_together=set([
  176. ('forum', 'id'),
  177. ('forum', 'last_post_on'),
  178. ('forum', 'replies'),
  179. ]),
  180. ),
  181. ]