Python db.add_column函数代码示例

    def forwards(self, orm):
        
        # Adding field 'Project.programme'
        db.add_column('projects_project', 'programme', self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['programmes.Programme']), keep_default=False)

        # Removing M2M table for field programme on 'Project'
        db.delete_table('projects_project_programme')

    def forwards(self, orm):
        
        # Adding field 'Image.textPosition'
        db.add_column('cmsplugin_s3slider_image', 'textPosition', self.gf('django.db.models.fields.CharField')(default='bottom', max_length=6), keep_default=False)

        # Adding field 'Image.text'
        db.add_column('cmsplugin_s3slider_image', 'text', self.gf('django.db.models.fields.CharField')(default='', max_length=2047, blank=True), keep_default=False)

    def forwards(self, orm):

        # Adding field 'Group.time_spent_total'
        db.add_column('sentry_groupedmessage', 'time_spent_total', self.gf('django.db.models.fields.FloatField')(default=0), keep_default=False)

        # Adding field 'Group.time_spent_count'
        db.add_column('sentry_groupedmessage', 'time_spent_count', self.gf('django.db.models.fields.IntegerField')(default=0), keep_default=False)

 def backwards(self, orm):
     
     # Deleting field 'BugzillaUrl.tracker'
     db.delete_column('customs_bugzillaurl', 'tracker_id')
     
     # Adding field 'BugzillaUrl.bugzilla_tracker'
     db.add_column('customs_bugzillaurl', 'bugzilla_tracker', orm['customs.bugzillaurl:bugzilla_tracker'])

    def forwards(self, orm):
        
        # Adding field 'Link.created_on'
        db.add_column('projects_link', 'created_on', self.gf('django.db.models.fields.DateTimeField')(default=datetime.date(2010, 11, 29), auto_now_add=True, blank=True), keep_default=False)

        # Adding field 'Project.created_on'
        db.add_column('projects_project', 'created_on', self.gf('django.db.models.fields.DateTimeField')(default=datetime.date(2010, 11, 29), auto_now_add=True, blank=True), keep_default=False)

    def forwards(self, orm):
        
        # Adding field 'Plan.spreedly_site_name'
        db.add_column('spreedly_plan', 'spreedly_site_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True), keep_default=False)

        # Adding field 'Subscription.spreedly_site_name'
        db.add_column('spreedly_subscription', 'spreedly_site_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True), keep_default=False)

    def backwards(self, orm):

        # Changing field 'Ingredient.name'
        db.alter_column(u'dishes_ingredient', 'name', self.gf('django.db.models.fields.CharField')(max_length=30))
        # Adding field 'Dish.new'
        db.add_column(u'dishes_dish', 'new',
                      self.gf('django.db.models.fields.BooleanField')(default=False),
                      keep_default=False)

        # Deleting field 'Dish.photo'
        db.delete_column(u'dishes_dish', 'photo')

        # Deleting field 'Dish.likes'
        db.delete_column(u'dishes_dish', 'likes')


        # Changing field 'Dish.flavors'
        db.alter_column(u'dishes_dish', 'flavors', self.gf('django.db.models.fields.CharField')(max_length=50))

        # Changing field 'Dish.cuisine'
        db.alter_column(u'dishes_dish', 'cuisine', self.gf('django.db.models.fields.CharField')(max_length=30))

        # Changing field 'Dish.name'
        db.alter_column(u'dishes_dish', 'name', self.gf('django.db.models.fields.CharField')(max_length=30))

        # Changing field 'Dish.prep_time'
        db.alter_column(u'dishes_dish', 'prep_time', self.gf('django.db.models.fields.FloatField')())

    def forwards(self, orm):
        
        # Deleting field 'StorageItem.date'
        db.delete_column('recipemonkeyapp_storageitem', 'date')

        # Adding field 'StorageItem.date_added'
        db.add_column('recipemonkeyapp_storageitem', 'date_added', self.gf('django.db.models.fields.DateField')(auto_now_add=True, null=True, blank=True), keep_default=False)

    def forwards(self, orm):
        # Adding field 'Product.price'
        db.add_column(u'products_product', 'price',
                      self.gf('django.db.models.fields.related.ForeignKey')(default=1, to=orm['products.Price']),
                      keep_default=False)

        # Adding field 'Product.employee_price'
        db.add_column(u'products_product', 'employee_price',
                      self.gf('django.db.models.fields.related.ForeignKey')(default=1, related_name='employee_products', to=orm['products.Price']),
                      keep_default=False)


        # Changing field 'Sale.size'
        db.alter_column(u'products_sale', 'size_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Size']))

        # Changing field 'Sale.color'
        db.alter_column(u'products_sale', 'color_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Color']))

        # Changing field 'Sale.price'
        db.alter_column(u'products_sale', 'price_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Price']))

        # Changing field 'Sale.sex'
        db.alter_column(u'products_sale', 'sex_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Sex']))

        # Changing field 'Delivery.color'
        db.alter_column(u'products_delivery', 'color_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Color']))

        # Changing field 'Delivery.sex'
        db.alter_column(u'products_delivery', 'sex_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Sex']))

        # Changing field 'Delivery.size'
        db.alter_column(u'products_delivery', 'size_id', self.gf('smart_selects.db_fields.ChainedForeignKey')(to=orm['products.Size']))

    def forwards(self, orm):
        
        # Adding field 'CommitmentMember.social_email2'
        db.add_column('activities_commitmentmember', 'social_email2', self.gf('django.db.models.fields.TextField')(null=True, blank=True), keep_default=False)

        # Adding field 'ActivityMember.social_email2'
        db.add_column('activities_activitymember', 'social_email2', self.gf('django.db.models.fields.TextField')(null=True, blank=True), keep_default=False)

    def backwards(self, orm):
        # Deleting field 'SpokeAboutUs.spoke_source_uid'
        db.delete_column(u'spokeaboutus_spokeaboutus', 'spoke_source_uid')


        # User chose to not deal with backwards NULL issues for 'SpokeSource.name'
        raise RuntimeError("Cannot reverse this migration. 'SpokeSource.name' and its values cannot be restored.")
        # Adding field 'SpokeSource.icon'
        db.add_column(u'spokeaboutus_spokesource', 'icon',
                      self.gf('django.db.models.fields.files.ImageField')(max_length=100, null=True, blank=True),
                      keep_default=False)

        # Deleting field 'SpokeSource.spoke_source'
        db.delete_column(u'spokeaboutus_spokesource', 'spoke_source')

        # Deleting field 'SpokeSource.limit'
        db.delete_column(u'spokeaboutus_spokesource', 'limit')

        # Deleting field 'SpokeSource.search_query'
        db.delete_column(u'spokeaboutus_spokesource', 'search_query')

        # Deleting field 'SpokeSource.periodicity'
        db.delete_column(u'spokeaboutus_spokesource', 'periodicity')

        # Deleting field 'SpokeSource.updated'
        db.delete_column(u'spokeaboutus_spokesource', 'updated')

    def forwards(self, orm):
        
        # Adding field 'ScheduledTask.last_execution'
        db.add_column('scheduler_scheduledtask', 'last_execution', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True), keep_default=False)

        # Changing field 'ScheduledTask.next_execution'
        db.alter_column('scheduler_scheduledtask', 'next_execution', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True))

    def forwards(self, orm):
        
        # Adding field 'Document.replaces'
        db.add_column('indivo_document', 'replaces', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['indivo.Document'], null=True), keep_default=False)

        # Adding field 'Document.processed'
        db.add_column('indivo_document', 'processed', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False)

    def forwards(self, orm):

        if was_applied(__file__, 'old_app'):
            return
        
        # Adding field 'Something.new_value'
        db.add_column('old_app_something', 'new_value', self.gf('django.db.models.fields.IntegerField')(default=0), keep_default=False)

    def backwards(self, orm):
        # Adding model 'Customer'
        db.create_table(u'attendees_customer', (
            ('conference', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['conference.Conference'], null=True, on_delete=models.PROTECT)),
            ('is_exported', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('email', self.gf('django.db.models.fields.EmailField')(max_length=250)),
            ('date_added', self.gf('django.db.models.fields.DateTimeField')(default=datetime.datetime.now)),
            ('customer_number', self.gf('django.db.models.fields.IntegerField')(blank=True)),
            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal(u'attendees', ['Customer'])

        # Adding unique constraint on 'Customer', fields ['customer_number', 'conference']
        db.create_unique(u'attendees_customer', ['customer_number', 'conference_id'])


        # User chose to not deal with backwards NULL issues for 'Purchase.customer'
        raise RuntimeError("Cannot reverse this migration. 'Purchase.customer' and its values cannot be restored.")
        
        # The following code is provided here to aid in writing a correct migration        # Adding field 'Purchase.customer'
        db.add_column(u'attendees_purchase', 'customer',
                      self.gf('django.db.models.fields.related.ForeignKey')(to=orm['attendees.Customer']),
                      keep_default=False)

        # Deleting field 'Purchase.email'
        db.delete_column(u'attendees_purchase', 'email')