Python db.create_index函数代码示例

    def forwards(self, orm):
        # Deleting field 'UserProfile.occupation'
        db.delete_column('auth_userprofile', 'occupation')

        # Deleting field 'UserProfile.telephone_number'
        db.delete_column('auth_userprofile', 'telephone_number')

        # Deleting field 'UserProfile.date_of_birth'
        db.delete_column('auth_userprofile', 'date_of_birth')

        # Deleting field 'UserProfile.country'
        db.delete_column('auth_userprofile', 'country')

        # Adding field 'UserProfile.year_of_birth'
        db.add_column('auth_userprofile', 'year_of_birth',
                      self.gf('django.db.models.fields.IntegerField')(
                          db_index=True, null=True, blank=True),
                      keep_default=False)

        # Adding field 'UserProfile.level_of_education'
        db.add_column('auth_userprofile', 'level_of_education',
                      self.gf('django.db.models.fields.CharField')(
                          db_index=True, max_length=6, null=True, blank=True),
                      keep_default=False)

        # Adding field 'UserProfile.goals'
        db.add_column('auth_userprofile', 'goals',
                      self.gf('django.db.models.fields.TextField')(
                          null=True, blank=True),
                      keep_default=False)

        # Adding index on 'UserProfile', fields ['gender']
        db.create_index('auth_userprofile', ['gender'])

    def forwards(self, orm):
        
        # Deleting field 'SellerRateChart.ext_category_id'
        db.delete_column('catalog_sellerratechart', 'ext_category_id')

        # Deleting field 'SellerRateChart.ext_category_name'
        db.delete_column('catalog_sellerratechart', 'ext_category_name')

        # Deleting field 'SellerRateChart.unit_list_price'
        db.delete_column('catalog_sellerratechart', 'unit_list_price')

        # Deleting field 'SellerRateChart.unit_offer_price'
        db.delete_column('catalog_sellerratechart', 'unit_offer_price')

        # Deleting field 'SellerRateChart.old_id'
        db.delete_column('catalog_sellerratechart', 'old_id')

        # Deleting field 'SellerRateChart.unit_transfer_price'
        db.delete_column('catalog_sellerratechart', 'unit_transfer_price')

        # Adding field 'SellerRateChart.list_price'
        db.add_column('catalog_sellerratechart', 'list_price', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=10, decimal_places=2), keep_default=False)

        # Adding field 'SellerRateChart.transfer_price'
        db.add_column('catalog_sellerratechart', 'transfer_price', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=10, decimal_places=2), keep_default=False)

        # Adding field 'SellerRateChart.offer_price'
        db.add_column('catalog_sellerratechart', 'offer_price', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=10, decimal_places=2), keep_default=False)

        # Adding field 'SellerRateChart.status'
        db.add_column('catalog_sellerratechart', 'status', self.gf('django.db.models.fields.CharField')(default='active', max_length=25, db_index=True), keep_default=False)

        # Adding index on 'SellerRateChart', fields ['sku']
        db.create_index('catalog_sellerratechart', ['sku'])

    def backwards(self, orm):
        # Adding index on 'PurpleRobotDevice', fields ['device_id']
        db.create_index(u'purple_robot_app_purplerobotdevice', ['device_id'])


        # Changing field 'PurpleRobotDevice.device_id'
        db.alter_column(u'purple_robot_app_purplerobotdevice', 'device_id', self.gf('django.db.models.fields.SlugField')(max_length=256, unique=True))

    def backwards(self, orm):
        # Adding index on 'Tag', fields ['tipo_tags']
        db.create_index(u"usuario_tag", ["tipo_tags_id"])

        # Adding model 'Tipo_Tag'
        db.create_table(
            u"usuario_tipo_tag",
            (
                ("tabela", self.gf("django.db.models.fields.CharField")(max_length=100)),
                (u"id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
                ("tipo", self.gf("django.db.models.fields.CharField")(max_length=100)),
            ),
        )
        db.send_create_signal(u"usuario", ["Tipo_Tag"])

        # Removing M2M table for field comcopia on 'Tag'
        db.delete_table(db.shorten_name(u"usuario_tag_comcopia"))

        # Renaming column for 'Tag.tipo_tags' to match new field type.
        db.rename_column(u"usuario_tag", "tipo_tags", "tipo_tags_id")
        # Changing field 'Tag.tipo_tags'
        db.alter_column(
            u"usuario_tag",
            "tipo_tags_id",
            self.gf("django.db.models.fields.related.ForeignKey")(to=orm["usuario.Tipo_Tag"]),
        )

 def forwards(self):
     
     # Model 'ArticleCategory'
     db.create_table('articles_articlecategory', (
         ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
         ('name', models.CharField(_("Name"), max_length=255)),
         ('slug', models.SlugField(_("Slug"), max_length=255, unique=True)),
         ('theme', models.CharField(_("Colour Theme"), max_length=10, choices=THEME_CHOICES)),
         ('featured', models.BooleanField(_("Featured"), default=False)),
     ))
     
     # Mock Models
     ArticleCategory = db.mock_model(model_name='ArticleCategory', db_table='articles_articlecategory', db_tablespace='', pk_field_name='id', pk_field_type=models.AutoField, pk_field_args=[], pk_field_kwargs={})
     
     # Model 'Article'
     db.create_table('articles_article', (
         ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
         ('title', models.CharField(_("Title"), max_length=255)),
         ('slug', models.SlugField(_("Slug"), max_length=255)),
         ('summary', models.TextField(_("Summary"), blank=True)),
         ('body', models.TextField(_("Body"), blank=True)),
         ('category', models.ForeignKey(ArticleCategory, verbose_name=_("Category"))),
         ('tags', TagField(_("Tags"))),
         ('featured', models.BooleanField(_("Featured"), default=False)),
         ('published', models.BooleanField(_("Published"), default=True)),
         ('publication_date', models.DateTimeField(_("Publication Date"), default=datetime.now)),
         ('expiration_date', models.DateTimeField(_("Expiration Date"), blank=True, null=True)),
         ('creation_date', models.DateTimeField(_("Creation Date"), editable=False, auto_now_add=True)),
         ('modification_date', models.DateTimeField(_("Modification Date"), editable=False, auto_now=True)),
         ('view_count', models.PositiveIntegerField(_("View Count"), editable=False, default=0)),
     ))
     db.create_index('articles_article', ['slug','publication_date','category_id'], unique=True, db_tablespace='')
     
     
     db.send_create_signal('articles', ['ArticleCategory','Article'])

    def forwards(self, orm):
        # Adding model 'RawStatistics'
        db.create_table('user_billing_raw_statistics', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('insert_time', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
            ('data', self.gf('django.db.models.fields.TextField')()),
        ))
        #db.send_create_signal(u'user_billing', ['RawStatistics'])

        # Adding model 'RawStatisticsIndex'
        db.create_table('user_billing_raw_statistics_index', (
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('year', self.gf('django.db.models.fields.IntegerField')()),
            ('month', self.gf('django.db.models.fields.IntegerField')()),
            ('meter', self.gf('django.db.models.fields.CharField')(max_length=64)),
            ('user_id', self.gf('django.db.models.fields.CharField')(max_length=64)),
            ('fetched', self.gf('django.db.models.fields.BooleanField')(default=False, db_index=True)),
            ('raw_statistics', self.gf('django.db.models.fields.related.OneToOneField')(default=-1, to=orm['user_billing.RawStatistics'], unique=True)),
            ('billed', self.gf('django.db.models.fields.BooleanField')(default=False, db_index=True)),
        ))
        #db.send_create_signal(u'user_billing', ['RawStatisticsIndex'])

        # Adding unique constraint on 'RawStatisticsIndex', fields ['user_id', 'month', 'meter', 'year']
        db.create_unique('user_billing_raw_statistics_index', ['user_id', 'month', 'meter', 'year'])

        # Adding index on 'RawStatisticsIndex', fields ['user_id', 'month', 'meter', 'year']
        db.create_index('user_billing_raw_statistics_index', ['user_id', 'month', 'meter', 'year'])

    def forwards(self, orm):

        # Renaming column for 'iSCSITarget.iscsi_target_portalgroup' to match new field type.
        db.rename_column("services_iscsitarget", "iscsi_target_portalgroup", "iscsi_target_portalgroup_id")
        # Changing field 'iSCSITarget.iscsi_target_portalgroup'
        db.alter_column(
            "services_iscsitarget",
            "iscsi_target_portalgroup_id",
            self.gf("django.db.models.fields.related.ForeignKey")(to=orm["services.iSCSITargetPortal"]),
        )

        # Adding index on 'iSCSITarget', fields ['iscsi_target_portalgroup']
        db.create_index("services_iscsitarget", ["iscsi_target_portalgroup_id"])

        # Renaming column for 'iSCSITarget.iscsi_target_initiatorgroup' to match new field type.
        db.rename_column("services_iscsitarget", "iscsi_target_initiatorgroup", "iscsi_target_initiatorgroup_id")
        # Changing field 'iSCSITarget.iscsi_target_initiatorgroup'
        db.alter_column(
            "services_iscsitarget",
            "iscsi_target_initiatorgroup_id",
            self.gf("django.db.models.fields.related.ForeignKey")(to=orm["services.iSCSITargetAuthorizedInitiator"]),
        )

        # Adding index on 'iSCSITarget', fields ['iscsi_target_initiatorgroup']
        db.create_index("services_iscsitarget", ["iscsi_target_initiatorgroup_id"])

    def forwards(self, orm):
        
        # Adding index on 'Feed', fields ['active_subscribers']
        db.create_index('feeds', ['active_subscribers'])

        # Adding index on 'Feed', fields ['active']
        db.create_index('feeds', ['active'])

    def backwards(self, orm):
        # Adding index on 'PageContent', fields ['key']
        db.create_index(u'apollo_pagecontent', ['key'])


        # Changing field 'PageContent.key'
        db.alter_column(u'apollo_pagecontent', 'key', self.gf('django.db.models.fields.SlugField')(max_length=50))

    def forwards(self, orm):

        # Changing field 'Category.slug'
        db.alter_column('qa_category', 'slug', self.gf('django.db.models.fields.SlugField')(unique=True, max_length=255))

        # Changing field 'Category.name'
        db.alter_column('qa_category', 'name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255))

        # Changing field 'Reference.name'
        db.alter_column('qa_reference', 'name', self.gf('django.db.models.fields.CharField')(max_length=255))

        # Changing field 'Test.name'
        db.alter_column('qa_test', 'name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255))

        if 'sql_server' in engine:
            sql_server_idxs = (('qa_testlist', 'name'), ('qa_testlistcycle', 'name'),)
            for table_name, column_name in sql_server_idxs:
                try:
                    db.drop_index(table_name, column_name)
                except:
                    pass
                # sqlserver_utils.drop_index(db,table_name,column_name)

        # Changing field 'TestList.name'
        db.alter_column('qa_testlist', 'name', self.gf('django.db.models.fields.CharField')(max_length=255))

        # Changing field 'TestListCycle.name'
        db.alter_column('qa_testlistcycle', 'name', self.gf('django.db.models.fields.CharField')(max_length=255))

        if 'sql_server' in engine:
            for table_name, column_name in sql_server_idxs:
                db.create_index(table_name, [column_name])

    def forwards(self, orm):
        db.alter_column('core_placement', 'publishable_id', models.ForeignKey(orm['core.Publishable'], null=False))
        db.create_index('core_placement', ['publishable_id'])

        db.delete_unique('core_placement', ('target_ct_id', 'target_id', 'category_id'))
        db.delete_column('core_placement', 'target_ct_id')
        db.delete_column('core_placement', 'target_id')

    def forwards(self, orm):

        # Adding model 'ProjectDomain'
        db.create_table('sentry_projectdomain', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('project', self.gf('django.db.models.fields.related.ForeignKey')(related_name='domain_set', to=orm['sentry.Project'])),
            ('domain', self.gf('django.db.models.fields.CharField')(max_length=128)),
        ))
        db.send_create_signal('sentry', ['ProjectDomain'])

        # Adding unique constraint on 'ProjectDomain', fields ['project', 'domain']
        db.create_unique('sentry_projectdomain', ['project_id', 'domain'])

        sid = transaction.savepoint()
        try:
            # Adding index on 'Message', fields ['checksum']
            db.create_index('sentry_message', ['checksum'])
        except:
            transaction.savepoint_rollback(sid)

        sid = transaction.savepoint()
        try:
            # Adding index on 'Message', fields ['checksum']
            db.create_index('sentry_groupedmessage', ['checksum'])
        except:
            transaction.savepoint_rollback(sid)

    def forwards(self, orm):

        # Adding index on 'EntityTypeName', fields ['language_code']
        db.create_index("places_entitytypename", ["language_code"])

        # Adding index on 'EntityGroupName', fields ['language_code']
        db.create_index("places_entitygroupname", ["language_code"])

    def forwards(self, orm):
        # Deleting field 'Banner.width'
        db.delete_column(u'banners_banner', 'width')

        # Deleting field 'Banner.height'
        db.delete_column(u'banners_banner', 'height')

        # Adding field 'Banner.is_active'
        db.add_column(u'banners_banner', 'is_active',
                      self.gf('django.db.models.fields.BooleanField')(default=True),
                      keep_default=False)

        # Adding field 'Placement.name'
        db.add_column(u'banners_placement', 'name',
                      self.gf('django.db.models.fields.CharField')(default=u'', max_length=255),
                      keep_default=False)

        # Adding field 'Placement.is_active'
        db.add_column(u'banners_placement', 'is_active',
                      self.gf('django.db.models.fields.BooleanField')(default=True),
                      keep_default=False)

        # Adding field 'Zone.is_active'
        db.add_column(u'banners_zone', 'is_active',
                      self.gf('django.db.models.fields.BooleanField')(default=True),
                      keep_default=False)

        # Adding index on 'Zone', fields ['english_name']
        db.create_index(u'banners_zone', ['english_name'])

    def forwards(self, orm):
        
        # Adding model 'WeightBased'
        db.create_table('shipping_weightbased', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('code', self.gf('django.db.models.fields.SlugField')(unique=True, max_length=128, db_index=True)),
            ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=128)),
            ('description', self.gf('django.db.models.fields.TextField')(blank=True)),
            ('upper_charge', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=12, decimal_places=2)),
        ))
        db.send_create_signal('shipping', ['WeightBased'])

        # Changing field 'OrderAndItemCharges.code'
        db.alter_column('shipping_orderanditemcharges', 'code', self.gf('django.db.models.fields.SlugField')(unique=True, max_length=128))

        # Adding index on 'OrderAndItemCharges', fields ['code']
        db.create_index('shipping_orderanditemcharges', ['code'])

        # Adding unique constraint on 'OrderAndItemCharges', fields ['name']
        db.create_unique('shipping_orderanditemcharges', ['name'])

        # Deleting field 'WeightBand.method_code'
        db.delete_column('shipping_weightband', 'method_code')

        # Adding field 'WeightBand.method'
        db.add_column('shipping_weightband', 'method',
                      self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='bands', to=orm['shipping.WeightBased']), keep_default=False)