0001_initial.py 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
  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(db_index=True)),
  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='ThreadParticipant',
  99. fields=[
  100. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  101. ('level', models.PositiveIntegerField(default=1)),
  102. ('thread', models.ForeignKey(to='misago_threads.Thread')),
  103. ('user', models.ForeignKey(to=settings.AUTH_USER_MODEL)),
  104. ('replies', models.PositiveIntegerField(default=0)),
  105. ('last_post_on', models.DateTimeField(null=True, blank=True)),
  106. ('last_poster', models.ForeignKey(settings.AUTH_USER_MODEL, related_name='+', null=True, blank=True, on_delete=django.db.models.deletion.SET_NULL)),
  107. ('last_poster_name', models.CharField(max_length=255, null=True, blank=True)),
  108. ('last_poster_slug', models.CharField(max_length=255, null=True, blank=True)),
  109. ],
  110. options={
  111. },
  112. bases=(models.Model,),
  113. ),
  114. migrations.AddField(
  115. model_name='thread',
  116. name='participants',
  117. field=models.ManyToManyField(related_name='private_thread_set', through='misago_threads.ThreadParticipant', through_fields=('thread', 'user'), to=settings.AUTH_USER_MODEL),
  118. preserve_default=True,
  119. ),
  120. migrations.CreateModel(
  121. name='Event',
  122. fields=[
  123. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  124. ('author_name', models.CharField(max_length=255)),
  125. ('author_slug', models.CharField(max_length=255)),
  126. ('icon', models.CharField(max_length=255)),
  127. ('occured_on', models.DateTimeField(default=django.utils.timezone.now, db_index=True)),
  128. ('message', models.CharField(max_length=255)),
  129. ('checksum', models.CharField(max_length=64, default='-')),
  130. ('is_hidden', models.BooleanField(default=False)),
  131. ('author', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
  132. ('forum', models.ForeignKey(to='misago_forums.Forum')),
  133. ('thread', models.ForeignKey(to='misago_threads.Thread')),
  134. ],
  135. options={
  136. },
  137. bases=(models.Model,),
  138. ),
  139. CreatePartialIndex(
  140. field='Thread.has_reported_posts',
  141. index_name='misago_thread_has_reported_posts_partial',
  142. condition='has_reported_posts = TRUE',
  143. ),
  144. CreatePartialIndex(
  145. field='Thread.has_moderated_posts',
  146. index_name='misago_thread_has_moderated_posts_partial',
  147. condition='has_moderated_posts = TRUE',
  148. ),
  149. CreatePartialIndex(
  150. field='Thread.is_hidden',
  151. index_name='misago_thread_is_hidden_partial',
  152. condition='is_hidden = FALSE',
  153. ),
  154. migrations.AddField(
  155. model_name='post',
  156. name='thread',
  157. field=models.ForeignKey(to='misago_threads.Thread'),
  158. preserve_default=True,
  159. ),
  160. migrations.AddField(
  161. model_name='thread',
  162. name='first_post',
  163. field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
  164. preserve_default=True,
  165. ),
  166. migrations.AddField(
  167. model_name='thread',
  168. name='forum',
  169. field=models.ForeignKey(to='misago_forums.Forum'),
  170. preserve_default=True,
  171. ),
  172. migrations.AddField(
  173. model_name='thread',
  174. name='last_post',
  175. field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
  176. preserve_default=True,
  177. ),
  178. migrations.AddField(
  179. model_name='thread',
  180. name='last_poster',
  181. 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),
  182. preserve_default=True,
  183. ),
  184. migrations.AddField(
  185. model_name='thread',
  186. name='label',
  187. field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Label', null=True),
  188. preserve_default=True,
  189. ),
  190. migrations.AddField(
  191. model_name='thread',
  192. name='starter',
  193. field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True),
  194. preserve_default=True,
  195. ),
  196. migrations.AlterIndexTogether(
  197. name='thread',
  198. index_together=set([
  199. ('forum', 'id'),
  200. ('forum', 'last_post_on'),
  201. ('forum', 'replies'),
  202. ]),
  203. ),
  204. ]