Python db.create_unique函数代码示例

    def forwards(self, orm):
        # Adding model 'User'
        db.create_table('auth_user', (
            (u'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=30)),
            ('first_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
            ('last_name', self.gf('django.db.models.fields.CharField')(max_length=30, blank=True)),
            ('email', self.gf('django.db.models.fields.EmailField')(max_length=75, blank=True)),
            ('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(u'accounts', ['User'])

        # Adding M2M table for field groups on 'User'
        m2m_table_name = db.shorten_name('auth_user_groups')
        db.create_table(m2m_table_name, (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('user', models.ForeignKey(orm[u'accounts.user'], null=False)),
            ('group', models.ForeignKey(orm[u'auth.group'], null=False))
        ))
        db.create_unique(m2m_table_name, ['user_id', 'group_id'])

        # Adding M2M table for field user_permissions on 'User'
        m2m_table_name = db.shorten_name('auth_user_user_permissions')
        db.create_table(m2m_table_name, (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('user', models.ForeignKey(orm[u'accounts.user'], null=False)),
            ('permission', models.ForeignKey(orm[u'auth.permission'], null=False))
        ))
        db.create_unique(m2m_table_name, ['user_id', 'permission_id'])

    def forwards(self, orm):
        # Adding field 'Profile.subscribe_any_translation'
        db.add_column('accounts_profile', 'subscribe_any_translation',
                      self.gf('django.db.models.fields.BooleanField')(default=False),
                      keep_default=False)

        # Adding field 'Profile.subscribe_new_string'
        db.add_column('accounts_profile', 'subscribe_new_string',
                      self.gf('django.db.models.fields.BooleanField')(default=False),
                      keep_default=False)

        # Adding field 'Profile.subscribe_new_suggestion'
        db.add_column('accounts_profile', 'subscribe_new_suggestion',
                      self.gf('django.db.models.fields.BooleanField')(default=False),
                      keep_default=False)

        # Adding field 'Profile.subscribe_new_contributor'
        db.add_column('accounts_profile', 'subscribe_new_contributor',
                      self.gf('django.db.models.fields.BooleanField')(default=False),
                      keep_default=False)

        # Adding M2M table for field subscriptions on 'Profile'
        db.create_table('accounts_profile_subscriptions', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('profile', models.ForeignKey(orm['accounts.profile'], null=False)),
            ('project', models.ForeignKey(orm['trans.project'], null=False))
        ))
        db.create_unique('accounts_profile_subscriptions', ['profile_id', 'project_id'])

    def forwards(self, orm):
        # Adding model 'User'
        db.create_table(u'rt_user_user', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('username', self.gf('django.db.models.fields.CharField')(max_length=255)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
            ('email', self.gf('django.db.models.fields.EmailField')(max_length=75)),
            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
            ('modified_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
        ))
        db.send_create_signal(u'rt_user', ['User'])

        # Adding model 'Group'
        db.create_table(u'rt_user_group', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
            ('modified_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
        ))
        db.send_create_signal(u'rt_user', ['Group'])

        # Adding M2M table for field members on 'Group'
        m2m_table_name = db.shorten_name(u'rt_user_group_members')
        db.create_table(m2m_table_name, (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('group', models.ForeignKey(orm[u'rt_user.group'], null=False)),
            ('user', models.ForeignKey(orm[u'rt_user.user'], null=False))
        ))
        db.create_unique(m2m_table_name, ['group_id', 'user_id'])

    def forwards(self, orm):
        # Adding model 'Poll'
        db.create_table(u'polls_poll', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('question', self.gf('django.db.models.fields.CharField')(max_length=200)),
            ('pub_date', self.gf('django.db.models.fields.DateTimeField')()),
        ))
        db.send_create_signal(u'polls', ['Poll'])

        # Adding model 'Voter'
        db.create_table(u'polls_voter', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('voterID', self.gf('django.db.models.fields.CharField')(max_length=200)),
        ))
        db.send_create_signal(u'polls', ['Voter'])

        # Adding model 'Choice'
        db.create_table(u'polls_choice', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('poll', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['polls.Poll'])),
            ('choice_text', self.gf('django.db.models.fields.CharField')(max_length=200)),
            ('votes', self.gf('django.db.models.fields.IntegerField')(default=0)),
        ))
        db.send_create_signal(u'polls', ['Choice'])

        # Adding M2M table for field voters on 'Choice'
        m2m_table_name = db.shorten_name(u'polls_choice_voters')
        db.create_table(m2m_table_name, (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('choice', models.ForeignKey(orm[u'polls.choice'], null=False)),
            ('voter', models.ForeignKey(orm[u'polls.voter'], null=False))
        ))
        db.create_unique(m2m_table_name, ['choice_id', 'voter_id'])

    def forwards(self, orm):
        
        # Deleting field 'LegAction.minutes'
        db.delete_column('phillyleg_legaction', 'minutes_id')

        # Adding unique constraint on 'LegMinutes', fields ['id']
        db.create_unique('phillyleg_legminutes', ['id'])

    def backwards(self, orm):
        
        # Changing field 'Task.model_solution'
        db.alter_column('tasks_task', 'model_solution_id', self.gf('django.db.models.fields.related.OneToOneField')(unique=True, null=True, to=orm['solutions.Solution']))

        # Adding unique constraint on 'Task', fields ['model_solution']
        db.create_unique('tasks_task', ['model_solution_id'])

    def forwards(self, orm):
        
        # Deleting model 'NodeProductReports'
        db.delete_table('ilsgateway_nodeproductreports')

        # Adding model 'NodeProductReport'
        db.create_table('ilsgateway_nodeproductreport', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('product', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.Product'])),
            ('node', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.Node'])),
            ('report_type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ilsgateway.ProductReportType'])),
            ('quantity', self.gf('django.db.models.fields.IntegerField')()),
        ))
        db.send_create_signal('ilsgateway', ['NodeProductReport'])

        # Removing M2M table for field child_nodes on 'Node'
        db.delete_table('ilsgateway_node_child_nodes')

        # Adding M2M table for field child_node on 'Node'
        db.create_table('ilsgateway_node_child_node', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('from_node', models.ForeignKey(orm['ilsgateway.node'], null=False)),
            ('to_node', models.ForeignKey(orm['ilsgateway.node'], null=False))
        ))
        db.create_unique('ilsgateway_node_child_node', ['from_node_id', 'to_node_id'])

    def forwards(self, orm):
        # Deleting field 'SponsorshipLevel.content_type'
        db.delete_column(u'camp_sponsorshiplevel', 'content_type_id')

        # Deleting field 'SponsorshipLevel.object_id'
        db.delete_column(u'camp_sponsorshiplevel', 'object_id')

        # Adding M2M table for field events on 'SponsorshipLevel'
        db.create_table(u'camp_sponsorshiplevel_events', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('sponsorshiplevel', models.ForeignKey(orm[u'camp.sponsorshiplevel'], null=False)),
            ('event', models.ForeignKey(orm[u'sked.event'], null=False))
        ))
        db.create_unique(u'camp_sponsorshiplevel_events', ['sponsorshiplevel_id', 'event_id'])

        # Deleting field 'Sponsor.content_type'
        db.delete_column(u'camp_sponsor', 'content_type_id')

        # Deleting field 'Sponsor.object_id'
        db.delete_column(u'camp_sponsor', 'object_id')

        # Adding field 'Sponsor.event'
        db.add_column(u'camp_sponsor', 'event',
                      self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='sponsors', to=orm['sked.Event']),
                      keep_default=False)

    def backwards(self, orm):
        
        # Adding field 'SMARTTest.smarttest_disk'
        db.add_column('system_smarttest', 'smarttest_disk', self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='smarttestdisk', to=orm['storage.Disk']), keep_default=False)

        # Adding unique constraint on 'SMARTTest', fields ['smarttest_type', 'smarttest_disk']
        db.create_unique('system_smarttest', ['smarttest_type', 'smarttest_disk_id'])

    def forwards(self, orm):
        # Deleting model 'SkipQuestion'
        db.delete_table(u'questionnaire_skipquestion')

        # Adding model 'MultipleResponseAnswer'
        db.create_table(u'questionnaire_multipleresponseanswer', (
            (u'answer_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['questionnaire.Answer'], unique=True, primary_key=True)),
        ))
        db.send_create_signal('questionnaire', ['MultipleResponseAnswer'])

        # Adding M2M table for field response on 'MultipleResponseAnswer'
        db.create_table(u'questionnaire_multipleresponseanswer_response', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('multipleresponseanswer', models.ForeignKey(orm['questionnaire.multipleresponseanswer'], null=False)),
            ('questionoption', models.ForeignKey(orm['questionnaire.questionoption'], null=False))
        ))
        db.create_unique(u'questionnaire_multipleresponseanswer_response', ['multipleresponseanswer_id', 'questionoption_id'])

        # Adding model 'SkipRule'
        db.create_table(u'questionnaire_skiprule', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('created', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, blank=True)),
            ('modified', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now, blank=True)),
            ('root_question', self.gf('django.db.models.fields.related.ForeignKey')(related_name='root_skip_rules', to=orm['questionnaire.Question'])),
            ('response', self.gf('django.db.models.fields.related.ForeignKey')(related_name='skip_rules', to=orm['questionnaire.QuestionOption'])),
            ('skip_question', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='skip_rules', null=True, to=orm['questionnaire.Question'])),
            ('skip_subsection', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['questionnaire.SubSection'], null=True, blank=True)),
            ('subsection', self.gf('django.db.models.fields.related.ForeignKey')(related_name='skip_rules', to=orm['questionnaire.SubSection'])),
        ))
        db.send_create_signal('questionnaire', ['SkipRule'])

    def forwards(self, orm):
        # Adding model 'Collection'
        db.create_table('collection_collection', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=100)),
            ('description', self.gf('django.db.models.fields.TextField')(blank=True)),
            ('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'])),
            ('creation_date', self.gf('django.db.models.fields.DateTimeField')()),
            ('modified_date', self.gf('django.db.models.fields.DateTimeField')()),
            ('is_public', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('is_locked', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('parent', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['collection.Collection'], null=True, blank=True)),
            ('creation_info', self.gf('django.db.models.fields.CharField')(max_length=200)),
        ))
        db.send_create_signal('collection', ['Collection'])

        # Adding unique constraint on 'Collection', fields ['owner', 'name']
        db.create_unique('collection_collection', ['owner_id', 'name'])

        # Adding M2M table for field images on 'Collection'
        db.create_table('collection_collection_images', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('collection', models.ForeignKey(orm['collection.collection'], null=False)),
            ('image', models.ForeignKey(orm['catamidb.image'], null=False))
        ))
        db.create_unique('collection_collection_images', ['collection_id', 'image_id'])

    def forwards(self, orm):
        
        # Adding model 'RaceSpeed'
        db.create_table('dnd_racespeed', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('type', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dnd.RaceSpeedType'])),
            ('speed', self.gf('django.db.models.fields.PositiveSmallIntegerField')()),
        ))
        db.send_create_signal('dnd', ['RaceSpeed'])

        # Adding model 'RaceSpeedType'
        db.create_table('dnd_racespeedtype', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=32, db_index=True)),
            ('extra', self.gf('django.db.models.fields.CharField')(max_length=32, null=True, blank=True)),
        ))
        db.send_create_signal('dnd', ['RaceSpeedType'])

        # Deleting field 'Race.base_land_speed'
        db.delete_column('dnd_race', 'base_land_speed')

        # Adding field 'Race.combat'
        db.add_column('dnd_race', 'combat', self.gf('django.db.models.fields.TextField')(default='', blank=True), keep_default=False)

        # Adding M2M table for field speeds on 'Race'
        db.create_table('dnd_race_speeds', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('race', models.ForeignKey(orm['dnd.race'], null=False)),
            ('racespeed', models.ForeignKey(orm['dnd.racespeed'], null=False))
        ))
        db.create_unique('dnd_race_speeds', ['race_id', 'racespeed_id'])

    def forwards(self, orm):
        # Adding model 'DesLookbook'
        db.create_table(u'catalogue_deslookbook', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('designer', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['designer.Designer'], null=True, blank=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=128, unique=True, null=True)),
            ('description', self.gf('django.db.models.fields.TextField')()),
        ))
        db.send_create_signal(u'catalogue', ['DesLookbook'])

        # Adding M2M table for field products on 'DesLookbook'
        m2m_table_name = db.shorten_name(u'catalogue_deslookbook_products')
        db.create_table(m2m_table_name, (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('deslookbook', models.ForeignKey(orm[u'catalogue.deslookbook'], null=False)),
            ('product', models.ForeignKey(orm[u'catalogue.product'], null=False))
        ))
        db.create_unique(m2m_table_name, ['deslookbook_id', 'product_id'])

        # Adding field 'Product.designer'
        db.add_column(u'catalogue_product', 'designer',
                      self.gf('django.db.models.fields.related.ForeignKey')(to=orm['designer.Designer'], null=True, blank=True),
                      keep_default=False)

        # Adding field 'Product.video'
        db.add_column(u'catalogue_product', 'video',
                      self.gf('django.db.models.fields.files.FileField')(max_length=100, null=True, blank=True),
                      keep_default=False)

    def forwards(self, orm):
        
        # Adding model 'EntryTranslation'
        db.create_table('happy_blog_entry_translation', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('title', self.gf('django.db.models.fields.CharField')(max_length=256)),
            ('slug', self.gf('django.db.models.fields.CharField')(max_length=256)),
            ('content', self.gf('tinymce.models.HTMLField')(blank=True)),
            ('language_code', self.gf('django.db.models.fields.CharField')(max_length=15, db_index=True)),
            ('master', self.gf('django.db.models.fields.related.ForeignKey')(related_name='translatable', null=True, to=orm['happy_blog.Entry'])),
        ))
        db.send_create_signal('happy_blog', ['EntryTranslation'])

        # Adding unique constraint on 'EntryTranslation', fields ['language_code', 'master']
        db.create_unique('happy_blog_entry_translation', ['language_code', 'master_id'])

        # Adding model 'Entry'
        db.create_table('happy_blog_entry', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('pub_date', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
            ('published', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('author', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True, blank=True)),
            ('gallery', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['simplegallery.Gallery'], null=True, blank=True)),
        ))
        db.send_create_signal('happy_blog', ['Entry'])

        # Adding model 'LatestBlogEntriesPlugin'
        db.create_table('cmsplugin_latestblogentriesplugin', (
            ('cmsplugin_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['cms.CMSPlugin'], unique=True, primary_key=True)),
            ('count', self.gf('django.db.models.fields.IntegerField')(default=25)),
        ))
        db.send_create_signal('happy_blog', ['LatestBlogEntriesPlugin'])

    def forwards(self, orm):
        
        # Deleting field 'Project.private'
        db.delete_column('gitlog_project', 'private')

        # Deleting field 'Project.source'
        db.delete_column('gitlog_project', 'source')

        # Adding field 'Project.public'
        db.add_column('gitlog_project', 'public', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False)

        # Adding field 'Project.url'
        db.add_column('gitlog_project', 'url', self.gf('django.db.models.fields.URLField')(max_length=30, null=True, blank=True), keep_default=False)

        # Adding field 'Project.description'
        db.add_column('gitlog_project', 'description', self.gf('django.db.models.fields.TextField')(null=True, blank=True), keep_default=False)

        # Adding M2M table for field writable on 'Project'
        db.create_table('gitlog_project_writable', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('project', models.ForeignKey(orm['gitlog.project'], null=False)),
            ('user', models.ForeignKey(orm['auth.user'], null=False))
        ))
        db.create_unique('gitlog_project_writable', ['project_id', 'user_id'])

        # Adding M2M table for field readonly on 'Project'
        db.create_table('gitlog_project_readonly', (
            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
            ('project', models.ForeignKey(orm['gitlog.project'], null=False)),
            ('user', models.ForeignKey(orm['auth.user'], null=False))
        ))
        db.create_unique('gitlog_project_readonly', ['project_id', 'user_id'])

        # Changing field 'Project.owner'
        db.alter_column('gitlog_project', 'owner_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['auth.User']))