Python db.delete_table函数代码示例

    def forwards(self, orm):
        
        # Deleting model 'AJeansSize'
        db.delete_table('core_ajeanssize')

        # Deleting model 'AColor'
        db.delete_table('core_acolor')

    def backwards(self, orm):

        # Deleting model 'ExerciseWidget'
        db.delete_table('askbot_exercisewidget')

        # Deleting model 'AskWidget'
        db.delete_table('askbot_askwidget')

    def backwards(self, orm):
        
        # Deleting field 'ExampleModel.fk_field'
        db.delete_column('xml_examplemodel', 'fk_field_id')

        # Removing M2M table for field mm_field on 'ExampleModel'
        db.delete_table('xml_examplemodel_mm_field')

 def forwards(self, orm):
     
     # Deleting field 'SavedSearch.openid_user'
     db.delete_column('localtv_savedsearch', 'openid_user_id')
     
     # Deleting field 'OpenIdUser.status'
     db.delete_column('localtv_openiduser', 'status')
     
     # Deleting field 'Watch.openid_user'
     db.delete_column('localtv_watch', 'openid_user_id')
     
     # Deleting field 'OpenIdUser.superuser'
     db.delete_column('localtv_openiduser', 'superuser')
     
     # Deleting field 'OpenIdUser.nickname'
     db.delete_column('localtv_openiduser', 'nickname')
     
     # Deleting field 'OpenIdUser.email'
     db.delete_column('localtv_openiduser', 'email')
     
     # Deleting field 'Feed.openid_user'
     db.delete_column('localtv_feed', 'openid_user_id')
     
     # Deleting field 'Video.openid_user'
     db.delete_column('localtv_video', 'openid_user_id')
     
     # Dropping ManyToManyField 'SiteLocation.admins'
     db.delete_table('localtv_sitelocation_admins')
     
     # Changing field 'OpenIdUser.user'
     # (to signature: django.db.models.fields.related.OneToOneField(to=orm['auth.User'], unique=True))
     db.alter_column('localtv_openiduser', 'user_id', orm['localtv.openiduser:user'])

    def backwards(self, orm):
        
        # Deleting model 'ActivityGroup'
        db.delete_table('timepiece_activitygroup')

        # Removing M2M table for field activities on 'ActivityGroup'
        db.delete_table('timepiece_activitygroup_activities')

    def backwards(self, orm):
        # Removing M2M table for field supervisors on 'SupportGroup'
        db.delete_table('live_support_supportgroup_supervisors')


        # Changing field 'Chat.hash_key'
        db.alter_column('live_support_chat', 'hash_key', self.gf('django.db.models.fields.CharField')(default='', max_length=64, unique=True))

    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 backwards(self, orm):

        # Removing unique constraint on 'GroupBookmark', fields ['project', 'user', 'group']
        db.delete_unique('sentry_groupbookmark', ['project_id', 'user_id', 'group_id'])

        # Deleting model 'GroupBookmark'
        db.delete_table('sentry_groupbookmark')

    def backwards(self, orm):
        # Deleting model 'Category'
        db.delete_table('dashboard_category')

        # Deleting field 'JenkinsFailuresMetric.category'
        db.delete_column('dashboard_jenkinsfailuresmetric', 'category_id')

        # Deleting field 'JenkinsFailuresMetric.position'
        db.delete_column('dashboard_jenkinsfailuresmetric', 'position')

        # Deleting field 'GithubItemCountMetric.category'
        db.delete_column('dashboard_githubitemcountmetric', 'category_id')

        # Deleting field 'GithubItemCountMetric.position'
        db.delete_column('dashboard_githubitemcountmetric', 'position')

        # Deleting field 'RSSFeedMetric.category'
        db.delete_column('dashboard_rssfeedmetric', 'category_id')

        # Deleting field 'RSSFeedMetric.position'
        db.delete_column('dashboard_rssfeedmetric', 'position')

        # Deleting field 'TracTicketMetric.category'
        db.delete_column('dashboard_tracticketmetric', 'category_id')

        # Deleting field 'TracTicketMetric.position'
        db.delete_column('dashboard_tracticketmetric', 'position')

    def backwards(self, orm):
        
        # Adding model 'RssChannel'
        db.create_table('subscriptions_rsschannel', (
            ('recipient', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal('subscriptions', ['RssChannel'])

        # Adding model 'SearchSubscription'
        db.create_table('subscriptions_searchsubscription', (
            ('query', self.gf('django.db.models.fields.TextField')()),
            ('subscription_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['subscriptions.Subscription'], unique=True, primary_key=True)),
        ))
        db.send_create_signal('subscriptions', ['SearchSubscription'])

        # Adding model 'EmailChannel'
        db.create_table('subscriptions_emailchannel', (
            ('recipient', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True)),
            ('email', self.gf('django.db.models.fields.CharField')(max_length=256)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal('subscriptions', ['EmailChannel'])

        # Adding model 'SmsChannel'
        db.create_table('subscriptions_smschannel', (
            ('recipient', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], null=True)),
            ('number', self.gf('django.db.models.fields.CharField')(max_length=32)),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('carrier', self.gf('django.db.models.fields.CharField')(max_length=32)),
        ))
        db.send_create_signal('subscriptions', ['SmsChannel'])

        # Deleting model 'SubscriptionDispatchRecord'
        db.delete_table('subscriptions_subscriptiondispatchrecord')

    def backwards(self, orm):
        
        # Adding field 'Project.private'
        db.add_column('gitlog_project', 'private', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False)

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

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

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

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

        # Removing M2M table for field writable on 'Project'
        db.delete_table('gitlog_project_writable')

        # Removing M2M table for field readonly on 'Project'
        db.delete_table('gitlog_project_readonly')

        # User chose to not deal with backwards NULL issues for 'Project.owner'
        raise RuntimeError("Cannot reverse this migration. 'Project.owner' and its values cannot be restored.")

    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 backwards(self, orm):
        # Deleting model 'IncentiveFee'
        db.delete_table('hedgefunds_incentivefee')


        # Changing field 'StudentTeam.rate'
        db.alter_column('hedgefunds_studentteam', 'rate', self.gf('django.db.models.fields.IntegerField')())

    def backwards(self, orm):
        
        # Removing unique constraint on 'NewsTranslation', fields ['content_type', 'object_id', 'language']
        db.delete_unique('reviewapp_newstranslation', ['content_type_id', 'object_id', 'language'])

        # Deleting model 'NewsTranslation'
        db.delete_table('reviewapp_newstranslation')

 def forwards(self, orm):
     
     # Deleting field 'File.public'
     db.delete_column('cmsplugin_file', 'public_id')
     
     # Deleting model 'filepublic'
     db.delete_table('cmsplugin_filepublic')