def forwards(self, orm):
if db.backend_name != 'sqlite3':
db.drop_foreign_key(u'certificados_revogacao', 'emissao_id')
db.rename_column(u'certificados_revogacao', 'emissao_id', 'emission_id')
db.rename_column(u'certificados_revogacao', 'revogacao_motivo', 'revoke_reason')
if db.backend_name != 'sqlite3':
db.alter_column(u'certificados_revogacao', 'emission_id', models.ForeignKey(to=orm['certificados.Emissao']))
def forwards(self, orm):
using_mysql = db.backend_name == 'mysql'
db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage')
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id')
except ValueError, e:
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
def forwards(self, orm):
using_mysql = db.backend_name == 'mysql'
db.rename_table('easy_thumbnails_storagenew',
'easy_thumbnails_storage')
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id')
except ValueError, e:
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
def forwards(self, orm):
db.drop_foreign_key('main_video', 'series_id')
# Renaming model 'Series' -> 'Collection'
db.rename_table('main_series', 'main_collection')
# Deleting field 'Video.series'
db.rename_column('main_video', 'series_id', 'collection_id')
db.alter_column('main_video', 'collection_id', models.ForeignKey(to=orm['main.Collection']))
def forwards(self, orm):
db.rename_table('multilingual_initiatives_initiativetranslation', 'multilingual_initiatives_initiative_translation')
try:
db.drop_foreign_key('multilingual_initiatives_initiative_translation', 'initiative_id')
except:
pass
db.rename_column('multilingual_initiatives_initiative_translation', 'initiative_id', 'master_id')
db.rename_column('multilingual_initiatives_initiative_translation', 'language', 'language_code')
db.alter_column('multilingual_initiatives_initiative_translation', 'master_id', models.ForeignKey(to=orm['multilingual_initiatives.Initiative']))
# Adding unique constraint on 'InitiativeTranslation', fields ['language_code', 'master']
db.create_unique(u'multilingual_initiatives_initiative_translation', ['language_code', 'master_id'])
def forwards(self, orm):
db.rename_table('eway_ewaytransaction', 'eway_transaction')
db.rename_table('eway_ewayresponsecode', 'eway_responsecode')
db.rename_table('eway_ewayresponsecode_transactions', 'eway_responsecode_transactions')
if db.backend_name == 'mysql':
db.drop_foreign_key('eway_responsecode_transactions', 'ewayresponsecode_id')
db.drop_foreign_key('eway_responsecode_transactions', 'ewaytransaction_id')
db.rename_column('eway_responsecode_transactions', 'ewayresponsecode_id', 'responsecode_id')
db.rename_column('eway_responsecode_transactions', 'ewaytransaction_id', 'transaction_id')
if db.backend_name == 'mysql':
db.alter_column('eway_responsecode_transactions', 'responsecode_id', models.ForeignKey(null=False, to=orm['eway.responsecode']))
db.alter_column('eway_responsecode_transactions', 'transaction_id', models.ForeignKey(null=False, to=orm['eway.transaction']))
def forwards(self, orm):
using_mysql = db.backend_name == 'mysql'
db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage')
if using_mysql:
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id')
db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id')
if using_mysql:
db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT '
'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
if using_mysql:
db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id')
db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id')
if using_mysql:
db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT '
'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
def forwards(self, orm):
rename_tables_old_to_new(db)
# SQLite3 and MySQL NOTE: Altering FK constraints are broken this
# backend, but, its OK to just rename the columns here, because
# constraints are disabled anyway.
if connection.vendor not in ('sqlite', ):
db.drop_foreign_key('aldryn_newsblog_latestentriesplugin', 'namespace_id')
db.rename_column('aldryn_newsblog_latestentriesplugin', 'namespace_id', 'app_config_id')
if connection.vendor not in ('sqlite', 'mysql', ):
db.alter_column('aldryn_newsblog_latestentriesplugin', 'app_config_id',
models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
if connection.vendor not in ('sqlite', ):
db.drop_foreign_key('aldryn_newsblog_article', 'namespace_id')
db.rename_column('aldryn_newsblog_article', 'namespace_id', 'app_config_id')
if connection.vendor not in ('sqlite', 'mysql', ):
db.alter_column('aldryn_newsblog_article', 'app_config_id',
models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
def forwards(self, orm):
# Changing field 'PublicKeyPair.fingerprint'
db.alter_column('userdata_publickeypair', 'fingerprint', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True))
try:
db.drop_foreign_key('userdata_publickeypair', 'user_id')
except:
pass
# Renaming column for 'PublicKeyPair.user' to match new field type.
db.rename_column('userdata_publickeypair', 'user_id', 'user')
# Changing field 'PublicKeyPair.user'
db.alter_column('userdata_publickeypair', 'user', self.gf('django.db.models.fields.CharField')(max_length=100))
try:
# Removing index on 'PublicKeyPair', fields ['user']
db.delete_index('userdata_publickeypair', ['user_id'])
except:
pass
def forwards(self, orm):
db.rename_table('multilingual_initiatives_initiativetranslation',
'multilingual_initiatives_initiative_translation')
try:
db.drop_foreign_key(
'multilingual_initiatives_initiative_translation',
'initiative_id')
except:
pass
db.rename_column('multilingual_initiatives_initiative_translation',
'initiative_id', 'master_id')
db.rename_column('multilingual_initiatives_initiative_translation',
'language', 'language_code')
db.alter_column(
'multilingual_initiatives_initiative_translation', 'master_id',
models.ForeignKey(to=orm['multilingual_initiatives.Initiative']))
# Adding unique constraint on 'InitiativeTranslation', fields ['language_code', 'master']
db.create_unique(u'multilingual_initiatives_initiative_translation',
['language_code', 'master_id'])
def forwards(self, orm):
using_mysql = db.backend_name == "mysql"
db.rename_table("easy_thumbnails_storagenew", "easy_thumbnails_storage")
if using_mysql:
try:
db.drop_foreign_key("easy_thumbnails_source", "storage_new_id")
except ValueError:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
# e.g MyISAM tables don't support foreign key constraints
print("Could not remove foreign key contraint: %s" % e)
db.rename_column("easy_thumbnails_source", "storage_new_id", "storage_id")
if using_mysql:
try:
db.execute(
"ALTER TABLE easy_thumbnails_source ADD CONSTRAINT "
"sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) "
"REFERENCES easy_thumbnails_storage(id)"
)
except Exception:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
print("Could not add contraint: %s" % e)
if using_mysql:
try:
db.drop_foreign_key("easy_thumbnails_thumbnail", "storage_new_id")
except ValueError:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
# e.g MyISAM tables don't support foreign key constraints
print("Could not remove foreign key contraint: %s" % e)
db.rename_column("easy_thumbnails_thumbnail", "storage_new_id", "storage_id")
if using_mysql:
try:
db.execute(
"ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT "
"thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) "
"REFERENCES easy_thumbnails_storage(id)"
)
except Exception:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
print("Could not add contraint: %s" % e)
def forwards(self, orm):
# SQLite3 NOTE: Altering FK constraints are broken this backend, but,
# its OK to just rename the columns here, because constraints are
# disabled anyway.
if connection.vendor != 'sqlite':
db.drop_foreign_key('aldryn_newsblog_latestentriesplugin',
'namespace_id')
db.rename_column('aldryn_newsblog_latestentriesplugin', 'namespace_id',
'app_config_id')
if connection.vendor != 'sqlite':
db.alter_column(
'aldryn_newsblog_latestentriesplugin', 'app_config_id',
models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
if connection.vendor != 'sqlite':
db.drop_foreign_key('aldryn_newsblog_article', 'namespace_id')
db.rename_column('aldryn_newsblog_article', 'namespace_id',
'app_config_id')
if connection.vendor != 'sqlite':
db.alter_column(
'aldryn_newsblog_article', 'app_config_id',
models.ForeignKey(orm['aldryn_newsblog.NewsBlogConfig']))
def forwards(self, orm):
# Changing field 'PublicKeyPair.fingerprint'
db.alter_column(
'userdata_publickeypair', 'fingerprint',
self.gf('django.db.models.fields.CharField')(max_length=100,
blank=True))
try:
db.drop_foreign_key('userdata_publickeypair', 'user_id')
except:
pass
# Renaming column for 'PublicKeyPair.user' to match new field type.
db.rename_column('userdata_publickeypair', 'user_id', 'user')
# Changing field 'PublicKeyPair.user'
db.alter_column(
'userdata_publickeypair', 'user',
self.gf('django.db.models.fields.CharField')(max_length=100))
try:
# Removing index on 'PublicKeyPair', fields ['user']
db.delete_index('userdata_publickeypair', ['user_id'])
except:
pass
def forwards(self, orm):
using_mysql = db.backend_name == 'mysql'
db.rename_table('easy_thumbnails_storagenew', 'easy_thumbnails_storage')
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id')
except ValueError:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
# e.g MyISAM tables don't support foreign key constraints
print("Could not remove foreign key contraint: %s" % e)
db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id')
if using_mysql:
try:
db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT '
'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
print("Could not add contraint: %s" % e)
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id')
except ValueError:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
# e.g MyISAM tables don't support foreign key constraints
print("Could not remove foreign key contraint: %s" % e)
db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id')
if using_mysql:
try:
db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT '
'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception:
e = sys.exc_info()[1] # Python 2.5 compatable "as e"
print("Could not add contraint: %s" % e)
def forwards(self, orm):
db.rename_table('hero_slider_slideritemtitle', 'hero_slider_slideritem_translation')
try:
db.drop_foreign_key('hero_slider_slideritem_translation', 'slider_item_id')
except:
pass
db.rename_column('hero_slider_slideritem_translation', 'slider_item_id', 'master_id')
db.rename_column('hero_slider_slideritem_translation', 'language', 'language_code')
db.alter_column('hero_slider_slideritem_translation', 'master_id', models.ForeignKey(to=orm['hero_slider.SliderItem']))
# Adding unique constraint on 'SliderItemTranslation', fields ['language_code', 'master']
db.create_unique('hero_slider_slideritem_translation', ['language_code', 'master_id'])
db.rename_table('hero_slider_slideritemcategorytitle', 'hero_slider_slideritemcategory_translation')
try:
db.drop_foreign_key('hero_slider_slideritemcategory_translation', 'slider_item_category_id')
except:
pass
db.rename_column('hero_slider_slideritemcategory_translation', 'slider_item_category_id', 'master_id')
db.rename_column('hero_slider_slideritemcategory_translation', 'language', 'language_code')
db.alter_column('hero_slider_slideritemcategory_translation', 'master_id', models.ForeignKey(to=orm['hero_slider.SliderItemCategory']))
# Adding unique constraint on 'SliderItemCategoryTranslation', fields ['language_code', 'master']
db.create_unique('hero_slider_slideritemcategory_translation', ['language_code', 'master_id'])
def forwards(self, orm):
# change tables and columns for Goal model
db.rename_table('good_practice_examples_goaltranslation', 'good_practice_examples_goal_translation')
try:
db.drop_foreign_key('good_practice_examples_goal_translation', 'goal_id')
except:
pass
db.rename_column('good_practice_examples_goal_translation', 'goal_id', 'master_id')
db.rename_column('good_practice_examples_goal_translation', 'language', 'language_code')
db.alter_column('good_practice_examples_goal_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.Goal']))
# change tables and columns for Sector model
db.rename_table('good_practice_examples_sectortranslation', 'good_practice_examples_sector_translation')
try:
db.drop_foreign_key('good_practice_examples_sector_translation', 'sector_id')
except:
pass
db.rename_column('good_practice_examples_sector_translation', 'sector_id', 'master_id')
db.rename_column('good_practice_examples_sector_translation', 'language', 'language_code')
db.alter_column('good_practice_examples_sector_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.sector']))
# change tables and columns for GoodPracticeExample model
db.rename_table('good_practice_examples_goodpracticeexampletranslation', 'good_practice_examples_goodpracticeexample_translation')
try:
db.drop_foreign_key('good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id')
except:
pass
db.rename_column('good_practice_examples_goodpracticeexample_translation', 'good_practice_example_id', 'master_id')
db.rename_column('good_practice_examples_goodpracticeexample_translation', 'language', 'language_code')
db.alter_column('good_practice_examples_goodpracticeexample_translation', 'master_id', models.ForeignKey(to=orm['good_practice_examples.goodpracticeexample']))
# Adding unique constraint on 'SectorTranslation', fields ['language_code', 'master']
db.create_unique(u'good_practice_examples_sector_translation', ['language_code', 'master_id'])
# Adding unique constraint on 'GoodPracticeExampleTranslation', fields ['language_code', 'master']
db.create_unique(u'good_practice_examples_goodpracticeexample_translation', ['language_code', 'master_id'])
# Adding unique constraint on 'GoalTranslation', fields ['language_code', 'master']
db.create_unique(u'good_practice_examples_goal_translation', ['language_code', 'master_id'])
def forwards(self, orm):
# change tables and columns for Goal model
db.rename_table('good_practice_examples_goaltranslation',
'good_practice_examples_goal_translation')
try:
db.drop_foreign_key('good_practice_examples_goal_translation',
'goal_id')
except:
pass
db.rename_column('good_practice_examples_goal_translation', 'goal_id',
'master_id')
db.rename_column('good_practice_examples_goal_translation', 'language',
'language_code')
db.alter_column(
'good_practice_examples_goal_translation', 'master_id',
models.ForeignKey(to=orm['good_practice_examples.Goal']))
# change tables and columns for Sector model
db.rename_table('good_practice_examples_sectortranslation',
'good_practice_examples_sector_translation')
try:
db.drop_foreign_key('good_practice_examples_sector_translation',
'sector_id')
except:
pass
db.rename_column('good_practice_examples_sector_translation',
'sector_id', 'master_id')
db.rename_column('good_practice_examples_sector_translation',
'language', 'language_code')
db.alter_column(
'good_practice_examples_sector_translation', 'master_id',
models.ForeignKey(to=orm['good_practice_examples.sector']))
# change tables and columns for GoodPracticeExample model
db.rename_table(
'good_practice_examples_goodpracticeexampletranslation',
'good_practice_examples_goodpracticeexample_translation')
try:
db.drop_foreign_key(
'good_practice_examples_goodpracticeexample_translation',
'good_practice_example_id')
except:
pass
db.rename_column(
'good_practice_examples_goodpracticeexample_translation',
'good_practice_example_id', 'master_id')
db.rename_column(
'good_practice_examples_goodpracticeexample_translation',
'language', 'language_code')
db.alter_column(
'good_practice_examples_goodpracticeexample_translation',
'master_id',
models.ForeignKey(
to=orm['good_practice_examples.goodpracticeexample']))
# Adding unique constraint on 'SectorTranslation', fields ['language_code', 'master']
db.create_unique(u'good_practice_examples_sector_translation',
['language_code', 'master_id'])
# Adding unique constraint on 'GoodPracticeExampleTranslation', fields ['language_code', 'master']
db.create_unique(
u'good_practice_examples_goodpracticeexample_translation',
['language_code', 'master_id'])
# Adding unique constraint on 'GoalTranslation', fields ['language_code', 'master']
db.create_unique(u'good_practice_examples_goal_translation',
['language_code', 'master_id'])
def backwards(self, orm):
db.drop_foreign_key('main_video', 'collection_id')
db.rename_table('main_collection', 'main_series')
db.rename_column('main_video', 'collection_id', 'series_id')
db.alter_column('main_video', 'series_id', models.ForeignKey(to=orm['main.Series']))
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
db.rename_column('easy_thumbnails_source', 'storage_new_id',
'storage_id')
if using_mysql:
try:
db.execute(
'ALTER TABLE easy_thumbnails_source ADD CONSTRAINT '
'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception, e:
print "Could not add contraint: %s" % e
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_thumbnail',
'storage_new_id')
except ValueError, e:
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id',
'storage_id')
if using_mysql:
try:
db.execute(
'ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT '
'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception, e:
print "Could not add contraint: %s" % e
def backwards(self, orm):
def forwards(self, orm):
if db.backend_name != "sqlite3":
db.drop_foreign_key('accounts_userprofile', 'country_new_id')
db.rename_column('accounts_userprofile', 'country_new_id', 'country_id')
db.drop_foreign_key('easy_thumbnails_source', 'storage_new_id')
except ValueError, e:
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
db.rename_column('easy_thumbnails_source', 'storage_new_id', 'storage_id')
if using_mysql:
try:
db.execute('ALTER TABLE easy_thumbnails_source ADD CONSTRAINT '
'sourcestorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception, e:
print "Could not add contraint: %s" % e
if using_mysql:
try:
db.drop_foreign_key('easy_thumbnails_thumbnail', 'storage_new_id')
except ValueError, e:
# e.g MyISAM tables don't support foreign key constraints
print "Could not remove foreign key contraint: %s" % e
db.rename_column('easy_thumbnails_thumbnail', 'storage_new_id', 'storage_id')
if using_mysql:
try:
db.execute('ALTER TABLE easy_thumbnails_thumbnail ADD CONSTRAINT '
'thumbnailstorage_id_fk_to_storage FOREIGN KEY (storage_id) '
'REFERENCES easy_thumbnails_storage(id)')
except Exception, e:
print "Could not add contraint: %s" % e
def backwards(self, orm):
db.rename_table('easy_thumbnails_storage', 'easy_thumbnails_storagenew')
def forwards(self, orm):
if db.backend_name != "sqlite3":
db.drop_foreign_key('accounts_shippingaddress', 'country_new_id')
db.rename_column('accounts_shippingaddress', 'country_new_id', 'country_id')
