def forwards(self, orm):
if AUTH_USER == 'test_app.CustomUser':
# Adding model 'CustomUser'
db.create_table('test_app_customuser', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('password', self.gf('django.db.models.fields.CharField')(max_length=128)),
('last_login', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
('is_superuser', self.gf('django.db.models.fields.BooleanField')(default=False)),
('username', self.gf('django.db.models.fields.CharField')(unique=True, max_length=100)),
('email', self.gf('django.db.models.fields.EmailField')(max_length=75)),
('is_staff', self.gf('django.db.models.fields.BooleanField')(default=False)),
('is_active', self.gf('django.db.models.fields.BooleanField')(default=True)),
('date_joined', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
))
db.send_create_signal('test_app', ['CustomUser'])
# Adding M2M table for field groups on 'CustomUser'
m2m_table_name = db.shorten_name('test_app_customuser_groups')
db.create_table(m2m_table_name, (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('customuser', models.ForeignKey(orm['test_app.customuser'], null=False)),
('group', models.ForeignKey(orm['auth.group'], null=False))
))
db.create_unique(m2m_table_name, ['customuser_id', 'group_id'])
# Adding M2M table for field user_permissions on 'CustomUser'
m2m_table_name = db.shorten_name('test_app_customuser_user_permissions')
db.create_table(m2m_table_name, (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('customuser', models.ForeignKey(orm['test_app.customuser'], null=False)),
('permission', models.ForeignKey(orm['auth.permission'], null=False))
))
db.create_unique(m2m_table_name, ['customuser_id', 'permission_id'])
# Adding model 'CustomProfile'
db.create_table('test_app_customprofile', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('signature', self.gf('django.db.models.fields.TextField')(max_length=1024, blank=True)),
('signature_html', self.gf('django.db.models.fields.TextField')(max_length=1054, blank=True)),
('time_zone', self.gf('django.db.models.fields.FloatField')(default=3.0)),
('language', self.gf('django.db.models.fields.CharField')(default='en-us', max_length=10, blank=True)),
('show_signatures', self.gf('django.db.models.fields.BooleanField')(default=True)),
('post_count', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('avatar', self.gf(get_image_field_full_name())(max_length=100, null=True, blank=True)),
('autosubscribe', self.gf('django.db.models.fields.BooleanField')(default=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(related_name='pybb_customprofile', unique=True, to=orm[AUTH_USER])),
))
db.send_create_signal('test_app', ['CustomProfile'])
class Migration(SchemaMigration):
def forwards(self, orm):
# Adding field 'Category.hidden'
db.add_column(
'pybb_category',
'hidden',
self.gf('django.db.models.fields.BooleanField')(default=False),
keep_default=False)
# Adding field 'Forum.hidden'
db.add_column(
'pybb_forum',
'hidden',
self.gf('django.db.models.fields.BooleanField')(default=False),
keep_default=False)
def backwards(self, orm):
# Deleting field 'Category.hidden'
db.delete_column('pybb_category', 'hidden')
# Deleting field 'Forum.hidden'
db.delete_column('pybb_forum', 'hidden')
models = {
'auth.group': {
'Meta': {
'object_name': 'Group'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'unique': 'True',
'max_length': '80'
}),
'permissions':
('django.db.models.fields.related.ManyToManyField', [], {
'to': "orm['auth.Permission']",
'symmetrical': 'False',
'blank': 'True'
})
},
'auth.permission': {
'Meta': {
'ordering':
"('content_type__app_label', 'content_type__model', 'codename')",
'unique_together': "(('content_type', 'codename'),)",
'object_name': 'Permission'
},
'codename': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'content_type':
('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['contenttypes.ContentType']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '50'
})
},
'contenttypes.contenttype': {
'Meta': {
'ordering': "('name',)",
'unique_together': "(('app_label', 'model'),)",
'object_name': 'ContentType',
'db_table': "'django_content_type'"
},
'app_label': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'model': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '100'
})
},
'pybb.attachment': {
'Meta': {
'object_name': 'Attachment'
},
'content_type': ('django.db.models.fields.CharField', [], {
'max_length': '255'
}),
'hash': ('django.db.models.fields.CharField', [], {
'db_index': 'True',
'max_length': '40',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.TextField', [], {}),
'path': ('django.db.models.fields.CharField', [], {
'max_length': '255'
}),
'post': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'attachments'",
'to': "orm['pybb.Post']"
}),
'size': ('django.db.models.fields.IntegerField', [], {})
},
'pybb.category': {
'Meta': {
'ordering': "['position']",
'object_name': 'Category'
},
'hidden': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '80'
}),
'position': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
})
},
'pybb.forum': {
'Meta': {
'ordering': "['position']",
'object_name': 'Forum'
},
'category': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'forums'",
'to': "orm['pybb.Category']"
}),
'description': ('django.db.models.fields.TextField', [], {
'blank': 'True'
}),
'hidden': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'moderators':
('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'to': "orm['%s']" % AUTH_USER,
'null': 'True',
'blank': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '80'
}),
'position': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'readed_by':
('django.db.models.fields.related.ManyToManyField', [], {
'related_name': "'readed_forums'",
'symmetrical': 'False',
'through': "orm['pybb.ForumReadTracker']",
'to': "orm['%s']" % AUTH_USER
}),
'topic_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True',
'blank': 'True'
})
},
'pybb.forumreadtracker': {
'Meta': {
'object_name': 'ForumReadTracker'
},
'forum': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['pybb.Forum']",
'null': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'time_stamp': ('django.db.models.fields.DateTimeField', [], {
'auto_now': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
})
},
'pybb.post': {
'Meta': {
'ordering': "['created']",
'object_name': 'Post'
},
'body': ('django.db.models.fields.TextField', [], {}),
'body_html': ('django.db.models.fields.TextField', [], {}),
'body_text': ('django.db.models.fields.TextField', [], {}),
'created': ('django.db.models.fields.DateTimeField', [], {
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'markup': ('django.db.models.fields.CharField', [], {
'default': "'bbcode'",
'max_length': '15'
}),
'topic': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'posts'",
'to': "orm['pybb.Topic']"
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'posts'",
'to': "orm['%s']" % AUTH_USER
}),
'user_ip': ('django.db.models.fields.IPAddressField', [], {
'default': "'0.0.0.0'",
'max_length': '15',
'blank': 'True'
})
},
'pybb.profile': {
'Meta': {
'object_name': 'Profile'
},
'avatar': (get_image_field_full_name(), [], {
'max_length': '100',
'null': 'True',
'blank': 'True'
}),
'ban_status': ('django.db.models.fields.SmallIntegerField', [], {
'default': '0'
}),
'ban_till': ('django.db.models.fields.DateTimeField', [], {
'default': 'None',
'null': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'language': ('django.db.models.fields.CharField', [], {
'max_length': '10',
'blank': 'True'
}),
'markup': ('django.db.models.fields.CharField', [], {
'default': "'bbcode'",
'max_length': '15'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'show_signatures': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'signature': ('django.db.models.fields.TextField', [], {
'max_length': '1024',
'blank': 'True'
}),
'signature_html': ('django.db.models.fields.TextField', [], {
'max_length': '1054',
'blank': 'True'
}),
'time_zone': ('django.db.models.fields.FloatField', [], {
'default': '3.0'
}),
'user': ('annoying.fields.AutoOneToOneField', [], {
'related_name': "'pybb_profile'",
'unique': 'True',
'to': "orm['%s']" % AUTH_USER
})
},
'pybb.topic': {
'Meta': {
'ordering': "['-created']",
'object_name': 'Topic'
},
'closed': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'created': ('django.db.models.fields.DateTimeField', [], {
'null': 'True'
}),
'forum': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'topics'",
'to': "orm['pybb.Forum']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '255'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'readed_by':
('django.db.models.fields.related.ManyToManyField', [], {
'related_name': "'readed_topics'",
'symmetrical': 'False',
'through': "orm['pybb.TopicReadTracker']",
'to': "orm['%s']" % AUTH_USER
}),
'sticky': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'subscribers':
('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'related_name': "'subscriptions'",
'blank': 'True',
'to': "orm['%s']" % AUTH_USER
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
}),
'views': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
})
},
'pybb.topicreadtracker': {
'Meta': {
'object_name': 'TopicReadTracker'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'time_stamp': ('django.db.models.fields.DateTimeField', [], {
'auto_now': 'True',
'blank': 'True'
}),
'topic': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['pybb.Topic']",
'null': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
})
}
}
models.update(get_user_frozen_models(AUTH_USER))
complete_apps = ['pybb']
def forwards(self, orm):
if AUTH_USER == 'test_app.CustomUser':
# Adding model 'CustomUser'
db.create_table('test_app_customuser', (
('id', self.gf('django.db.models.fields.AutoField')(
primary_key=True)),
('password',
self.gf('django.db.models.fields.CharField')(max_length=128)),
('last_login',
self.gf('django.db.models.fields.DateTimeField')(
default=datetime.datetime.now)),
('is_superuser',
self.gf('django.db.models.fields.BooleanField')(
default=False)),
('username', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=100)),
('email',
self.gf('django.db.models.fields.EmailField')(max_length=75)),
('is_staff', self.gf('django.db.models.fields.BooleanField')(
default=False)),
('is_active', self.gf('django.db.models.fields.BooleanField')(
default=True)),
('date_joined',
self.gf('django.db.models.fields.DateTimeField')(
default=datetime.datetime.now)),
))
db.send_create_signal('test_app', ['CustomUser'])
# Adding M2M table for field groups on 'CustomUser'
m2m_table_name = db.shorten_name('test_app_customuser_groups')
db.create_table(
m2m_table_name,
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('customuser',
models.ForeignKey(orm['test_app.customuser'], null=False)),
('group', models.ForeignKey(orm['auth.group'], null=False))))
db.create_unique(m2m_table_name, ['customuser_id', 'group_id'])
# Adding M2M table for field user_permissions on 'CustomUser'
m2m_table_name = db.shorten_name(
'test_app_customuser_user_permissions')
db.create_table(
m2m_table_name,
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('customuser',
models.ForeignKey(orm['test_app.customuser'], null=False)),
('permission',
models.ForeignKey(orm['auth.permission'], null=False))))
db.create_unique(m2m_table_name,
['customuser_id', 'permission_id'])
# Adding model 'CustomProfile'
db.create_table('test_app_customprofile', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('signature', self.gf('django.db.models.fields.TextField')(
max_length=1024, blank=True)),
('signature_html', self.gf('django.db.models.fields.TextField')(
max_length=1054, blank=True)),
('time_zone',
self.gf('django.db.models.fields.FloatField')(default=3.0)),
('language', self.gf('django.db.models.fields.CharField')(
default='en-us', max_length=10, blank=True)),
('show_signatures',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('post_count', self.gf('django.db.models.fields.IntegerField')(
default=0, blank=True)),
('avatar', self.gf(get_image_field_full_name())(
max_length=100, null=True, blank=True)),
('autosubscribe',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(
related_name='pybb_customprofile',
unique=True,
to=orm[AUTH_USER])),
))
db.send_create_signal('test_app', ['CustomProfile'])
class Migration(SchemaMigration):
def forwards(self, orm):
if AUTH_USER == 'test_app.CustomUser':
# Adding model 'CustomUser'
db.create_table('test_app_customuser', (
('id', self.gf('django.db.models.fields.AutoField')(
primary_key=True)),
('password',
self.gf('django.db.models.fields.CharField')(max_length=128)),
('last_login',
self.gf('django.db.models.fields.DateTimeField')(
default=datetime.datetime.now)),
('is_superuser',
self.gf('django.db.models.fields.BooleanField')(
default=False)),
('username', self.gf('django.db.models.fields.CharField')(
unique=True, max_length=100)),
('email',
self.gf('django.db.models.fields.EmailField')(max_length=75)),
('is_staff', self.gf('django.db.models.fields.BooleanField')(
default=False)),
('is_active', self.gf('django.db.models.fields.BooleanField')(
default=True)),
('date_joined',
self.gf('django.db.models.fields.DateTimeField')(
default=datetime.datetime.now)),
))
db.send_create_signal('test_app', ['CustomUser'])
# Adding M2M table for field groups on 'CustomUser'
m2m_table_name = db.shorten_name('test_app_customuser_groups')
db.create_table(
m2m_table_name,
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('customuser',
models.ForeignKey(orm['test_app.customuser'], null=False)),
('group', models.ForeignKey(orm['auth.group'], null=False))))
db.create_unique(m2m_table_name, ['customuser_id', 'group_id'])
# Adding M2M table for field user_permissions on 'CustomUser'
m2m_table_name = db.shorten_name(
'test_app_customuser_user_permissions')
db.create_table(
m2m_table_name,
(('id',
models.AutoField(
verbose_name='ID', primary_key=True, auto_created=True)),
('customuser',
models.ForeignKey(orm['test_app.customuser'], null=False)),
('permission',
models.ForeignKey(orm['auth.permission'], null=False))))
db.create_unique(m2m_table_name,
['customuser_id', 'permission_id'])
# Adding model 'CustomProfile'
db.create_table('test_app_customprofile', (
('id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('signature', self.gf('django.db.models.fields.TextField')(
max_length=1024, blank=True)),
('signature_html', self.gf('django.db.models.fields.TextField')(
max_length=1054, blank=True)),
('time_zone',
self.gf('django.db.models.fields.FloatField')(default=3.0)),
('language', self.gf('django.db.models.fields.CharField')(
default='en-us', max_length=10, blank=True)),
('show_signatures',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('post_count', self.gf('django.db.models.fields.IntegerField')(
default=0, blank=True)),
('avatar', self.gf(get_image_field_full_name())(
max_length=100, null=True, blank=True)),
('autosubscribe',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('user', self.gf('django.db.models.fields.related.OneToOneField')(
related_name='pybb_customprofile',
unique=True,
to=orm[AUTH_USER])),
))
db.send_create_signal('test_app', ['CustomProfile'])
def backwards(self, orm):
if AUTH_USER == 'test_app.CustomUser':
# Deleting model 'CustomUser'
db.delete_table('test_app_customuser')
# Removing M2M table for field groups on 'CustomUser'
db.delete_table(db.shorten_name('test_app_customuser_groups'))
# Removing M2M table for field user_permissions on 'CustomUser'
db.delete_table(
db.shorten_name('test_app_customuser_user_permissions'))
# Deleting model 'CustomProfile'
db.delete_table('test_app_customprofile')
models = {
'auth.group': {
'Meta': {
'object_name': 'Group'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'unique': 'True',
'max_length': '80'
}),
'permissions':
('django.db.models.fields.related.ManyToManyField', [], {
'to': "orm['auth.Permission']",
'symmetrical': 'False',
'blank': 'True'
})
},
'auth.permission': {
'Meta': {
'ordering':
"('content_type__app_label', 'content_type__model', 'codename')",
'unique_together': "(('content_type', 'codename'),)",
'object_name': 'Permission'
},
'codename': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'content_type':
('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['contenttypes.ContentType']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '50'
})
},
'contenttypes.contenttype': {
'Meta': {
'ordering': "('name',)",
'unique_together': "(('app_label', 'model'),)",
'object_name': 'ContentType',
'db_table': "'django_content_type'"
},
'app_label': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'model': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '100'
})
},
'test_app.customprofile': {
'Meta': {
'object_name': 'CustomProfile'
},
'autosubscribe': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'avatar': (get_image_field_full_name(), [], {
'max_length': '100',
'null': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'language': ('django.db.models.fields.CharField', [], {
'default': "'en-us'",
'max_length': '10',
'blank': 'True'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'show_signatures': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'signature': ('django.db.models.fields.TextField', [], {
'max_length': '1024',
'blank': 'True'
}),
'signature_html': ('django.db.models.fields.TextField', [], {
'max_length': '1054',
'blank': 'True'
}),
'time_zone': ('django.db.models.fields.FloatField', [], {
'default': '3.0'
}),
'user': ('django.db.models.fields.related.OneToOneField', [], {
'related_name': "'pybb_customprofile'",
'unique': 'True',
'to': "orm['%s']" % AUTH_USER
})
},
}
if AUTH_USER == 'test_app.CustomUser':
models['test_app.customuser'] = {
'Meta': {
'object_name': 'CustomUser'
},
'date_joined': ('django.db.models.fields.DateTimeField', [], {
'default': 'datetime.datetime.now'
}),
'email': ('django.db.models.fields.EmailField', [], {
'max_length': '75'
}),
'groups': ('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'related_name': "'user_set'",
'blank': 'True',
'to': "orm['auth.Group']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'is_active': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'is_staff': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'is_superuser': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'last_login': ('django.db.models.fields.DateTimeField', [], {
'default': 'datetime.datetime.now'
}),
'password': ('django.db.models.fields.CharField', [], {
'max_length': '128'
}),
'user_permissions':
('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'related_name': "'user_set'",
'blank': 'True',
'to': "orm['auth.Permission']"
}),
'username': ('django.db.models.fields.CharField', [], {
'unique': 'True',
'max_length': '100'
})
}
else:
models.update(get_user_frozen_models(AUTH_USER))
complete_apps = ['test_app']
def backwards(self, orm):
# Adding field 'Profile.avatar'
db.add_column('pybb_profile', 'avatar', self.gf(get_image_field_full_name())(max_length=100, null=True, blank=True))
class Migration(DataMigration):
def forwards(self, orm):
# Note: Remember to use orm['appname.ModelName'] rather than "from appname.models..."
for dup_group in orm['pybb.TopicReadTracker'].objects.values('topic', 'user')\
.annotate(Count('topic'), Count('user'))\
.filter(topic__count__gt=1):
for dup in orm['pybb.TopicReadTracker'].objects.filter(topic=dup_group['topic'], user=dup_group['user'])\
.order_by('-time_stamp')[1:]:
dup.delete()
for dup_group in orm['pybb.ForumReadTracker'].objects.values('forum', 'user')\
.annotate(Count('forum'), Count('user'))\
.filter(forum__count__gt=1):
for dup in orm['pybb.ForumReadTracker'].objects.filter(topic=dup_group['forum'], user=dup_group['user'])\
.order_by('-time_stamp')[1:]:
dup.delete()
def backwards(self, orm):
"Write your backwards methods here."
pass
models = {
'auth.group': {
'Meta': {
'object_name': 'Group'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'unique': 'True',
'max_length': '80'
}),
'permissions':
('django.db.models.fields.related.ManyToManyField', [], {
'to': "orm['auth.Permission']",
'symmetrical': 'False',
'blank': 'True'
})
},
'auth.permission': {
'Meta': {
'ordering':
"('content_type__app_label', 'content_type__model', 'codename')",
'unique_together': "(('content_type', 'codename'),)",
'object_name': 'Permission'
},
'codename': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'content_type':
('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['contenttypes.ContentType']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '50'
})
},
'contenttypes.contenttype': {
'Meta': {
'ordering': "('name',)",
'unique_together': "(('app_label', 'model'),)",
'object_name': 'ContentType',
'db_table': "'django_content_type'"
},
'app_label': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'model': ('django.db.models.fields.CharField', [], {
'max_length': '100'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '100'
})
},
'pybb.attachment': {
'Meta': {
'object_name': 'Attachment'
},
'file': ('django.db.models.fields.files.FileField', [], {
'max_length': '100'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'post': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'attachments'",
'to': "orm['pybb.Post']"
}),
'size': ('django.db.models.fields.IntegerField', [], {})
},
'pybb.category': {
'Meta': {
'ordering': "['position']",
'object_name': 'Category'
},
'hidden': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '80'
}),
'position': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
})
},
'pybb.forum': {
'Meta': {
'ordering': "['position']",
'object_name': 'Forum'
},
'category': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'forums'",
'to': "orm['pybb.Category']"
}),
'description': ('django.db.models.fields.TextField', [], {
'blank': 'True'
}),
'headline': ('django.db.models.fields.TextField', [], {
'null': 'True',
'blank': 'True'
}),
'hidden': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'moderators':
('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'to': "orm['%s']" % AUTH_USER,
'null': 'True',
'blank': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '80'
}),
'position': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'readed_by':
('django.db.models.fields.related.ManyToManyField', [], {
'related_name': "'readed_forums'",
'symmetrical': 'False',
'through': "orm['pybb.ForumReadTracker']",
'to': "orm['%s']" % AUTH_USER
}),
'topic_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True',
'blank': 'True'
})
},
'pybb.forumreadtracker': {
'Meta': {
'object_name': 'ForumReadTracker'
},
'forum': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['pybb.Forum']",
'null': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'time_stamp': ('django.db.models.fields.DateTimeField', [], {
'auto_now': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
})
},
'pybb.pollanswer': {
'Meta': {
'object_name': 'PollAnswer'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'text': ('django.db.models.fields.CharField', [], {
'max_length': '255'
}),
'topic': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'poll_answers'",
'to': "orm['pybb.Topic']"
})
},
'pybb.pollansweruser': {
'Meta': {
'unique_together': "(('poll_answer', 'user'),)",
'object_name': 'PollAnswerUser'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'poll_answer': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'users'",
'to': "orm['pybb.PollAnswer']"
}),
'timestamp': ('django.db.models.fields.DateTimeField', [], {
'auto_now_add': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'poll_answers'",
'to': "orm['%s']" % AUTH_USER
})
},
'pybb.post': {
'Meta': {
'ordering': "['created']",
'object_name': 'Post'
},
'body': ('django.db.models.fields.TextField', [], {}),
'body_html': ('django.db.models.fields.TextField', [], {}),
'body_text': ('django.db.models.fields.TextField', [], {}),
'created': ('django.db.models.fields.DateTimeField', [], {
'db_index': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'on_moderation': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'topic': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'posts'",
'to': "orm['pybb.Topic']"
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'posts'",
'to': "orm['%s']" % AUTH_USER
}),
'user_ip': ('django.db.models.fields.IPAddressField', [], {
'default': "'0.0.0.0'",
'max_length': '15',
'blank': 'True'
})
},
'pybb.profile': {
'Meta': {
'object_name': 'Profile'
},
'autosubscribe': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'avatar': (get_image_field_full_name(), [], {
'max_length': '100',
'null': 'True',
'blank': 'True'
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'language': ('django.db.models.fields.CharField', [], {
'default': "'en-us'",
'max_length': '10',
'blank': 'True'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'show_signatures': ('django.db.models.fields.BooleanField', [], {
'default': 'True'
}),
'signature': ('django.db.models.fields.TextField', [], {
'max_length': '1024',
'blank': 'True'
}),
'signature_html': ('django.db.models.fields.TextField', [], {
'max_length': '1054',
'blank': 'True'
}),
'time_zone': ('django.db.models.fields.FloatField', [], {
'default': '3.0'
}),
'user': ('annoying.fields.AutoOneToOneField', [], {
'related_name': "'pybb_profile'",
'unique': 'True',
'to': "orm['%s']" % AUTH_USER
})
},
'pybb.topic': {
'Meta': {
'ordering': "['-created']",
'object_name': 'Topic'
},
'closed': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'created': ('django.db.models.fields.DateTimeField', [], {
'null': 'True'
}),
'forum': ('django.db.models.fields.related.ForeignKey', [], {
'related_name': "'topics'",
'to': "orm['pybb.Forum']"
}),
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'name': ('django.db.models.fields.CharField', [], {
'max_length': '255'
}),
'on_moderation': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'poll_question': ('django.db.models.fields.TextField', [], {
'null': 'True',
'blank': 'True'
}),
'poll_type': ('django.db.models.fields.IntegerField', [], {
'default': '0'
}),
'post_count': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
}),
'readed_by':
('django.db.models.fields.related.ManyToManyField', [], {
'related_name': "'readed_topics'",
'symmetrical': 'False',
'through': "orm['pybb.TopicReadTracker']",
'to': "orm['%s']" % AUTH_USER
}),
'sticky': ('django.db.models.fields.BooleanField', [], {
'default': 'False'
}),
'subscribers':
('django.db.models.fields.related.ManyToManyField', [], {
'symmetrical': 'False',
'related_name': "'subscriptions'",
'blank': 'True',
'to': "orm['%s']" % AUTH_USER
}),
'updated': ('django.db.models.fields.DateTimeField', [], {
'null': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
}),
'views': ('django.db.models.fields.IntegerField', [], {
'default': '0',
'blank': 'True'
})
},
'pybb.topicreadtracker': {
'Meta': {
'object_name': 'TopicReadTracker'
},
'id': ('django.db.models.fields.AutoField', [], {
'primary_key': 'True'
}),
'time_stamp': ('django.db.models.fields.DateTimeField', [], {
'auto_now': 'True',
'blank': 'True'
}),
'topic': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['pybb.Topic']",
'null': 'True',
'blank': 'True'
}),
'user': ('django.db.models.fields.related.ForeignKey', [], {
'to': "orm['%s']" % AUTH_USER
})
}
}
models.update(get_user_frozen_models(AUTH_USER))
complete_apps = ['pybb']
symmetrical = True
def forwards(self, orm):
# Adding field 'Profile.avatar'
db.add_column('pybb_profile', 'avatar', self.gf(get_image_field_full_name())(max_length=100, null=True, blank=True), keep_default=False)
def forwards(self, orm):
# Adding model 'Post'
db.create_table('pybb_post', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('body', self.gf('django.db.models.fields.TextField')()),
('body_html', self.gf('django.db.models.fields.TextField')()),
('body_text', self.gf('django.db.models.fields.TextField')()),
('topic', self.gf('django.db.models.fields.related.ForeignKey')(related_name='posts', to=orm['pybb.Topic'])),
('user', self.gf('django.db.models.fields.related.ForeignKey')(related_name='posts', to=orm[AUTH_USER])),
('created', self.gf('django.db.models.fields.DateTimeField')(db_index=True, blank=True)),
('updated', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('user_ip', self.gf('django.db.models.fields.IPAddressField')(default='0.0.0.0', max_length=15, blank=True)),
('markup', self.gf('django.db.models.fields.CharField')(max_length=15)),
))
db.send_create_signal('pybb', ['Post'])
# Adding model 'Category'
db.create_table('pybb_category', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('name', self.gf('django.db.models.fields.CharField')(max_length=80)),
('position', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
))
db.send_create_signal('pybb', ['Category'])
# Adding model 'Forum'
db.create_table('pybb_forum', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('category', self.gf('django.db.models.fields.related.ForeignKey')(related_name='forums', to=orm['pybb.Category'])),
('name', self.gf('django.db.models.fields.CharField')(max_length=80)),
('position', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('description', self.gf('django.db.models.fields.TextField')(blank=True)),
('updated', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
('post_count', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('topic_count', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
))
db.send_create_signal('pybb', ['Forum'])
# Adding model 'Profile'
db.create_table('pybb_profile', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('signature', self.gf('django.db.models.fields.TextField')(max_length=1024, blank=True)),
('signature_html', self.gf('django.db.models.fields.TextField')(max_length=1054, blank=True)),
('time_zone', self.gf('django.db.models.fields.FloatField')(default=3.0)),
('language', self.gf('django.db.models.fields.CharField')(default='en-us', max_length=10, blank=True)),
('show_signatures', self.gf('django.db.models.fields.BooleanField')(default=True)),
('post_count', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('avatar', self.gf(get_image_field_full_name())(max_length=100, null=True, blank=True)),
('user', self.gf('annoying.fields.AutoOneToOneField')(related_name='pybb_profile', unique=True, to=orm[AUTH_USER])),
('markup', self.gf('django.db.models.fields.CharField')(max_length=15)),
('ban_status', self.gf('django.db.models.fields.SmallIntegerField')(default=0)),
('ban_till', self.gf('django.db.models.fields.DateTimeField')(default=None, null=True, blank=True)),
))
db.send_create_signal('pybb', ['Profile'])
# Adding model 'Attachment'
db.create_table('pybb_attachment', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('post', self.gf('django.db.models.fields.related.ForeignKey')(related_name='attachments', to=orm['pybb.Post'])),
('size', self.gf('django.db.models.fields.IntegerField')()),
('hash', self.gf('django.db.models.fields.CharField')(blank=True, default='', max_length=40, db_index=True)),
('content_type', self.gf('django.db.models.fields.CharField')(max_length=255)),
('name', self.gf('django.db.models.fields.TextField')()),
('path', self.gf('django.db.models.fields.CharField')(max_length=255)),
))
db.send_create_signal('pybb', ['Attachment'])
# Adding model 'ReadTracking'
db.create_table('pybb_readtracking', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm[AUTH_USER])),
('topics', self.gf('django.db.models.fields.TextField')(null=True)),
('last_read', self.gf('django.db.models.fields.DateTimeField')(null=True)),
))
db.send_create_signal('pybb', ['ReadTracking'])
# Adding model 'Topic'
db.create_table('pybb_topic', (
('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('forum', self.gf('django.db.models.fields.related.ForeignKey')(related_name='topics', to=orm['pybb.Forum'])),
('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
('created', self.gf('django.db.models.fields.DateTimeField')(null=True)),
('updated', self.gf('django.db.models.fields.DateTimeField')(null=True)),
('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm[AUTH_USER])),
('views', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
('sticky', self.gf('django.db.models.fields.BooleanField')(default=False)),
('closed', self.gf('django.db.models.fields.BooleanField')(default=False)),
('post_count', self.gf('django.db.models.fields.IntegerField')(default=0, blank=True)),
))
db.send_create_signal('pybb', ['Topic'])
# Adding M2M table for field subscribers on 'Topic'
db.create_table('pybb_topic_subscribers', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('topic', models.ForeignKey(orm['pybb.topic'], null=False)),
(AUTH_USER_COLUMN, models.ForeignKey(orm[AUTH_USER], null=False))
))
db.create_unique('pybb_topic_subscribers', ['topic_id', '%s_id' % AUTH_USER_COLUMN])
# Adding M2M table for field moderators on 'Forum'
db.create_table('pybb_forum_moderators', (
('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
('forum', models.ForeignKey(orm['pybb.forum'], null=False)),
(AUTH_USER_COLUMN, models.ForeignKey(orm[AUTH_USER], null=False))
))
db.create_unique('pybb_forum_moderators', ['forum_id', '%s_id' % AUTH_USER_COLUMN])
