osqa 开源问答软件

# encoding: utf-8 import datetime from south.db import db from south.v2 import SchemaMigration from django.db import models class Migration(SchemaMigration): def forwards(self, orm): # Adding model 'User' db.create_table('forum_user', ( ('website', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)), ('user_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['auth.User'], unique=True, primary_key=True)), ('hide_ignored_questions', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('is_approved', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('email_isvalid', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('real_name', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)), ('about', self.gf('django.db.models.fields.TextField')(blank=True)), ('silver', self.gf('django.db.models.fields.SmallIntegerField')(default=0)), ('date_of_birth', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('reputation', self.gf('django.db.models.fields.PositiveIntegerField')(default=1)), ('gravatar', self.gf('django.db.models.fields.CharField')(max_length=32)), ('location', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)), ('tag_filter_setting', self.gf('django.db.models.fields.CharField')(default='ignored', max_length=16)), ('gold', self.gf('django.db.models.fields.SmallIntegerField')(default=0)), ('last_seen', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('email_key', self.gf('django.db.models.fields.CharField')(max_length=32, null=True)), ('bronze', self.gf('django.db.models.fields.SmallIntegerField')(default=0)), ('questions_per_page', self.gf('django.db.models.fields.SmallIntegerField')(default=10)), )) db.send_create_signal('forum', ['User']) # Adding model 'Activity' db.create_table(u'activity', ( ('is_auditted', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')()), ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['forum.User'])), ('content_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'])), ('active_at', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('activity_type', self.gf('django.db.models.fields.SmallIntegerField')()), )) db.send_create_signal('forum', ['Activity']) # Adding model 'SubscriptionSettings' db.create_table('forum_subscriptionsettings', ( ('questions_asked', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('questions_viewed', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('notify_comments', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('new_question', self.gf('django.db.models.fields.CharField')(default='d', max_length=1)), ('all_questions', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('new_question_watched_tags', self.gf('django.db.models.fields.CharField')(default='i', max_length=1)), ('questions_answered', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('notify_comments_own_post', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('questions_commented', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('subscribed_questions', self.gf('django.db.models.fields.CharField')(default='i', max_length=1)), ('notify_reply_to_comments', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('member_joins', self.gf('django.db.models.fields.CharField')(default='n', max_length=1)), ('user', self.gf('django.db.models.fields.related.OneToOneField')(related_name='subscription_settings', unique=True, to=orm['forum.User'])), ('notify_answers', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('enable_notifications', self.gf('django.db.models.fields.BooleanField')(default=True, blank=True)), ('all_questions_watched_tags', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('notify_accepted', self.gf('django.db.models.fields.BooleanField')(default=False, blank=True)), )) db.send_create_signal('forum', ['SubscriptionSettings']) # Adding model 'ValidationHash' db.create_table('forum_validationhash', ( ('hash_code', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)), ('seed', self.gf('django.db.models.fields.CharField')(max_length=12)), ('expiration', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime(2010, 4, 7, 10, 36, 23, 812000))), ('type', self.gf('django.db.models.fields.CharField')(max_length=12)), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['forum.User'])), )) db.send_create_signal('forum', ['ValidationHash']) # Adding unique constraint on 'ValidationHash', fields ['user', 'type'] db.create_unique('forum_validationhash', ['user_id', 'type']) # Adding model 'AuthKeyUserAssociation' db.create_table('forum_authkeyuserassociation', ( ('added_at', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('user', self.gf('django.db.models.fields.related.ForeignKey')(related_name='auth_keys', to=orm['forum.User'])), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('key', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)), ('provider', self.gf('django.db.models.fields.CharField')(max_length=64)), )) db.send_create_signal('forum', ['AuthKeyUserAssociation']) # Adding model 'Vote' db.create_table(u'vote', ( ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')()), ('voted_at', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)), ('user', self.gf('django.db.models.fields.related.ForeignKey')(related_name='votes', to=orm['forum.User'])), ('content_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'])), ('vote', self.gf('django.db.models.fields.SmallIntegerField')()), ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), )) db.send_create_signal('forum', ['Vote']) # Adding unique constraint on 'Vote', fields ['content_type', 'object_id', 'user'] db.create_unique(u'vote', ['content_type_id', 'object_id', 'user_id']) # Adding model 'FlaggedItem' db.create_table(u'flagged_item', ( ('object_id', self.gf('django.db.models.fields.PositiveIntegerField')()), ('flagged_at', self.gf('django.db.models.fields.DateTimeField')(defa