# -*- coding: utf-8 -*-
from __future__ import unicode_literals
from django.conf import settings
from django.db import models, migrations
import django.db.models.deletion
import django.utils.timezone
from misago.core.pgutils import CreatePartialIndex, CreatePartialCompositeIndex
class Migration(migrations.Migration):
dependencies = [
('misago_categories', '0001_initial'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Post',
fields=[
('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
('poster_name', models.CharField(max_length=255)),
('poster_ip', models.GenericIPAddressField()),
('original', models.TextField()),
('parsed', models.TextField()),
('checksum', models.CharField(max_length=64, default='-')),
('has_attachments', models.BooleanField(default=False)),
('pickled_attachments', models.TextField(null=True, blank=True)),
('posted_on', models.DateTimeField()),
('updated_on', models.DateTimeField()),
('edits', models.PositiveIntegerField(default=0)),
('last_editor_name', models.CharField(max_length=255, null=True, blank=True)),
('last_editor_slug', models.SlugField(max_length=255, null=True, blank=True)),
('hidden_by', models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
('hidden_by_name', models.CharField(max_length=255, null=True, blank=True)),
('hidden_by_slug', models.SlugField(max_length=255, null=True, blank=True)),
('hidden_on', models.DateTimeField(default=django.utils.timezone.now)),
('has_reports', models.BooleanField(default=False)),
('has_open_reports', models.BooleanField(default=False)),
('is_moderated', models.BooleanField(default=False, db_index=True)),
('is_hidden', models.BooleanField(default=False)),
('is_protected', models.BooleanField(default=False)),
('category', models.ForeignKey(to='misago_categories.Category')),
('last_editor', models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
('mentions', models.ManyToManyField(related_name='mention_set', to=settings.AUTH_USER_MODEL)),
('poster', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
],
options={
},
bases=(models.Model,),
),
CreatePartialIndex(
field='Post.has_open_reports',
index_name='misago_post_has_open_reports_partial',
condition='has_open_reports = TRUE',
),
CreatePartialIndex(
field='Post.is_hidden',
index_name='misago_post_is_hidden_partial',
condition='is_hidden = FALSE',
),
migrations.CreateModel(
name='Thread',
fields=[
('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
('title', models.CharField(max_length=255)),
('slug', models.CharField(max_length=255)),
('replies', models.PositiveIntegerField(default=0, db_index=True)),
('has_reported_posts', models.BooleanField(default=False)),
('has_open_reports', models.BooleanField(default=False)),
('has_moderated_posts', models.BooleanField(default=False)),
('has_hidden_posts', models.BooleanField(default=False)),
('has_events', models.BooleanField(default=False)),
('started_on', models.DateTimeField(db_index=True)),
('starter_name', models.CharField(max_length=255)),
('starter_slug', models.CharField(max_length=255)),
('last_post_on', models.DateTimeField(db_index=True)),
('last_poster_name', models.CharField(max_length=255, null=True, blank=True)),
('last_poster_slug', models.CharField(max_length=255, null=True, blank=True)),
('weight', models.PositiveIntegerField(default=0)),
('is_poll', models.BooleanField(default=False)),
('is_moderated', models.BooleanField(default=False, db_index=True)),
('is_hidden', models.BooleanField(default=False)),
('is_closed', models.BooleanField(default=False)),
],
options={
},
bases=(models.Model,),
),
CreatePartialIndex(
field='Thread.weight',
index_name='misago_thread_is_global',
condition='weight = 2',
),
CreatePartialIndex(
field='Thread.weight',
index_name='misago_thread_is_local',
condition='weight < 2',
),
migrations.CreateModel(
name='ThreadParticipant',
fields=[
('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
('thread', models.ForeignKey(to='misago_threads.Thread')),
('user', models.ForeignKey(to=settings.AUTH_USER_MODEL)),
('is_owner', models.BooleanField(default=False)),
],
options={
},
bases=(models.Model,),
),
migrations.AddField(
model_name='thread',
name='participants',
field=models.ManyToManyField(related_name='private_thread_set', through='misago_threads.ThreadParticipant', through_fields=('thread', 'user'), to=settings.AUTH_USER_MODEL),
preserve_default=True,
),
migrations.CreateModel(
name='Event',
fields=[
('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
('author_name', models.CharField(max_length=255)),
('author_slug', models.CharField(max_length=255)),
('icon', models.CharField(max_length=255)),
('occured_on', models.DateTimeField(default=django.utils.timezone.now, db_index=True)),
('message', models.CharField(max_length=255)),
('checksum', models.CharField(max_length=64, default='-')),
('is_hidden', models.BooleanField(default=False)),
('author', models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True)),
('category', models.ForeignKey(to='misago_categories.Category')),
('thread', models.ForeignKey(to='misago_threads.Thread')),
],
options={
},
bases=(models.Model,),
),
CreatePartialIndex(
field='Thread.has_reported_posts',
index_name='misago_thread_has_reported_posts_partial',
condition='has_reported_posts = TRUE',
),
CreatePartialIndex(
field='Thread.has_moderated_posts',
index_name='misago_thread_has_moderated_posts_partial',
condition='has_moderated_posts = TRUE',
),
CreatePartialIndex(
field='Thread.is_hidden',
index_name='misago_thread_is_hidden_partial',
condition='is_hidden = FALSE',
),
migrations.AddField(
model_name='post',
name='thread',
field=models.ForeignKey(to='misago_threads.Thread'),
preserve_default=True,
),
migrations.AddField(
model_name='thread',
name='first_post',
field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
preserve_default=True,
),
migrations.AddField(
model_name='thread',
name='category',
field=models.ForeignKey(to='misago_categories.Category'),
preserve_default=True,
),
migrations.AddField(
model_name='thread',
name='last_post',
field=models.ForeignKey(related_name='+', on_delete=django.db.models.deletion.SET_NULL, blank=True, to='misago_threads.Post', null=True),
preserve_default=True,
),
migrations.AddField(
model_name='thread',
name='last_poster',
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),
preserve_default=True,
),
migrations.AddField(
model_name='thread',
name='starter',
field=models.ForeignKey(on_delete=django.db.models.deletion.SET_NULL, blank=True, to=settings.AUTH_USER_MODEL, null=True),
preserve_default=True,
),
migrations.AlterIndexTogether(
name='thread',
index_together=set([
('category', 'id'),
('category', 'last_post_on'),
('category', 'replies'),
]),
),
migrations.CreateModel(
name='Subscription',
fields=[
('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
('last_read_on', models.DateTimeField(default=django.utils.timezone.now)),
('send_email', models.BooleanField(default=False)),
('category', models.ForeignKey(to='misago_categories.Category')),
('thread', models.ForeignKey(to='misago_threads.Thread')),
('user', models.ForeignKey(to=settings.AUTH_USER_MODEL)),
],
options={
},
bases=(models.Model,),
),
]