def forwards(self, orm):
db.rename_table("text_text", "cmsplugin_text")
db.rename_table("text_publictext", "cmsplugin_textpublic")
db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public'])
db.drop_primary_key("cmsplugin_textpublic")
db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",))
def backwards(self, orm):
db.drop_primary_key("cmsplugin_snippetptrpublic")
db.rename_column("cmsplugin_snippetptrpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_snippetptrpublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_snippetptr", "snippet_snippetptr")
db.rename_table("cmsplugin_snippetptrpublic", "snippet_publicsnippetptr")
db.alter_column('cmsplugin_snippetptr', 'public_id', orm['snippet.snippetptr:public'])
def forwards(self, orm):
"Make remote_id Primary Key"
# Remove PK from Album
db.delete_foreign_key('vkontakte_photos_photo', 'album_id')
photos = orm.Photo.objects.only('album').all() #
for p in photos:
album = orm.Album.objects.get(id=p.album_id)
p.album_id = album.remote_id
p.save()
db.delete_primary_key('vkontakte_photos_album')
#db.delete_column(u'vkontakte_photos_album', u'id')
db.create_primary_key('vkontakte_photos_album', ['remote_id'])
db.alter_column('vkontakte_photos_photo', 'album_id', models.ForeignKey(
orm['vkontakte_photos.Album'], null=True, blank=True))
# Remove PK from Photo
# Remove Foreign key from Comments and likes
db.delete_foreign_key('vkontakte_photos_comment', 'photo_id')
db.delete_foreign_key('vkontakte_photos_photo_like_users', 'photo_id')
db.delete_primary_key('vkontakte_photos_photo')
#db.delete_column(u'vkontakte_photos_photo', u'id')
# Create Primary Keys
db.create_primary_key('vkontakte_photos_photo', ['remote_id'])
def backwards(self, orm):
db.drop_primary_key("cmsplugin_googlemappublic")
db.rename_column("cmsplugin_googlemappublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_googlemappublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_googlemap", "googlemap_googlemap")
db.rename_table("cmsplugin_googlemappublic", "googlemap_publicgooglemap")
db.alter_column('cmsplugin_googlemap', 'public_id', orm['googlemap.googlemap:public'])
def backwards(self, orm):
db.drop_primary_key("cmsplugin_picturepublic")
db.rename_column("cmsplugin_picturepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_picturepublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_picture", "picture_picture")
db.rename_table("cmsplugin_picturepublic", "picture_publicpicture")
db.alter_column('cmsplugin_picture', 'public_id', orm['picture.picture:public'])
def test_primary_key(self):
"""
Test the primary key operations
"""
# SQLite backend doesn't support this yet.
if db.backend_name == "sqlite3":
return
db.create_table(
"test_pk",
[
("id", models.IntegerField(primary_key=True)),
("new_pkey", models.IntegerField()),
("eggs", models.IntegerField(unique=True)),
],
)
db.execute_deferred_sql()
# Remove the default primary key, and make eggs it
db.drop_primary_key("test_pk")
db.create_primary_key("test_pk", "new_pkey")
# Try inserting a now-valid row pair
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)")
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)")
db.delete_table("test_pk")
def forwards(self, orm):
# Deleting field 'BaseSection.status'
db.delete_column('section_basesection', 'status')
# Deleting field 'BaseSection.slug'
db.delete_column('section_basesection', 'slug')
# Deleting field 'BaseSection.main_image'
db.delete_column('section_basesection', 'main_image')
# Deleting field 'BaseSection.id'
db.delete_column('section_basesection', 'id')
for field in (
'name',
'description',
'plain_description',
):
for lang, lang_name in settings.LANGUAGES:
db.delete_column('section_basesection',
get_real_fieldname(field, lang))
# Swapping primary key from id to basecontent_ptr_id
db.create_primary_key('section_basesection', ['basecontent_ptr_id'])
# Add new foreign key to section_basesection_related_content.basesection_id
db.alter_column(
'section_basesection_related_content', 'basesection_id',
models.ForeignKey(orm['section.BaseSection'],
null=False,
blank=False))
def backwards(self, orm):
db.rename_column('pricing_volume_type_resource', 'resource_ptr_id',
'resource_id')
db.delete_column('pricing_volume_type_resource', u'id')
db.alter_column(
'pricing_volume_type_resource', 'os_volume_type_id',
self.gf('django.db.models.fields.CharField')(unique=True,
max_length=36,
db_index=False))
db.delete_index('pricing_volume_type_resource', ['os_volume_type_id'])
db.rename_column('pricing_volume_type_resource', 'os_volume_type_id',
'os_type_id')
db.create_primary_key('pricing_volume_type_resource', ['os_type_id'])
db.add_column(
'pricing_volume_type_resource', 'description',
self.gf('django.db.models.fields.CharField')(max_length=100))
db.alter_column(
'pricing_instance_flavor_resource', 'id',
self.gf('django.db.models.fields.IntegerField')(primary_key=True))
db.delete_index('pricing_instance_flavor_resource',
['os_instance_type_id'])
db.rename_column('pricing_instance_flavor_resource',
'os_instance_type_id', 'os_flavor_id')
db.rename_column('pricing_instance_flavor_resource',
'resourcebase_ptr_id', 'resource_id')
db.alter_column(
'pricing_instance_flavor_resource', 'resource_id',
self.gf('django.db.models.fields.IntegerField')(blank=False))
db.delete_column('pricing_instance_flavor_resource', u'id')
db.create_primary_key('pricing_instance_flavor_resource',
['os_flavor_id'])
db.add_column(
'pricing_instance_flavor_resource', 'description',
self.gf('django.db.models.fields.CharField')(max_length=100))
def backwards(self, orm):
db.drop_primary_key("cmsplugin_linkpublic")
db.rename_column("cmsplugin_linkpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_linkpublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_link", "link_link")
db.rename_table("cmsplugin_linkpublic", "link_publiclink")
db.alter_column('cmsplugin_link', 'public_id', orm['link.link:public'])
def forwards(self, orm):
"Make remote_id Primary Key"
# Remove PK from Album
db.delete_foreign_key('vkontakte_photos_photo', 'album_id')
photos = orm.Photo.objects.only('album').all() #
for p in photos:
album = orm.Album.objects.get(id=p.album_id)
p.album_id = album.remote_id
p.save()
db.delete_primary_key('vkontakte_photos_album')
#db.delete_column(u'vkontakte_photos_album', u'id')
db.create_primary_key('vkontakte_photos_album', ['remote_id'])
db.alter_column(
'vkontakte_photos_photo', 'album_id',
models.ForeignKey(orm['vkontakte_photos.Album'],
null=True,
blank=True))
# Remove PK from Photo
# Remove Foreign key from Comments and likes
db.delete_foreign_key('vkontakte_photos_comment', 'photo_id')
db.delete_foreign_key('vkontakte_photos_photo_like_users', 'photo_id')
db.delete_primary_key('vkontakte_photos_photo')
#db.delete_column(u'vkontakte_photos_photo', u'id')
# Create Primary Keys
db.create_primary_key('vkontakte_photos_photo', ['remote_id'])
def backwards(self, orm):
# Deleting field 'FeaturedEmail.id'
db.delete_column('cg_channel_featured_email', 'id')
db.create_primary_key('cg_channel_featured_email',
['channel_id', 'timestamp'])
def backwards(self, orm):
db.drop_primary_key("cmsplugin_filepublic")
db.rename_column("cmsplugin_filepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_filepublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_file", "file_file")
db.rename_table("cmsplugin_filepublic", "file_publicfile")
db.alter_column('cmsplugin_file', 'public_id', orm['file.file:public'])
def backwards(self, orm):
db.drop_primary_key("cmsplugin_flashpublic")
db.rename_column("cmsplugin_flashpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_flashpublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_flash", "flash_flash")
db.rename_table("cmsplugin_flashpublic", "flash_publicflash")
db.alter_column('cmsplugin_flash', 'public_id', orm['flash.flash:public'])
def backwards(self, orm):
db.delete_foreign_key('cmsplugin_googlemap' ,'public_id')
db.drop_primary_key("cmsplugin_googlemappublic")
db.rename_column("cmsplugin_googlemappublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_googlemappublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_googlemap", "googlemap_googlemap")
db.rename_table("cmsplugin_googlemappublic", "googlemap_publicgooglemap")
db.alter_column('googlemap_googlemap', 'public_id', orm['googlemap.googlemap:public'])
def backwards(self, orm):
# Deleting field 'Rating.id'
db.delete_column('cg_channel_rating', 'id')
db.delete_index('cg_channel_rating', 'user_id')
db.delete_index('cg_channel_rating', 'channel_id')
db.create_primary_key('cg_channel_rating', ('channel_id', 'user_id'))
def backwards(self, orm):
# Deleting field 'Subsite.id'
db.delete_column(u'brainstorm_subsite', u'id')
# Changing field 'Subsite.slug'
db.alter_column(u'brainstorm_subsite', 'slug', self.gf('django.db.models.fields.SlugField')(max_length=50, primary_key=True))
# Adding primary key on 'Subsite', fields ['slug']
db.create_primary_key(u'brainstorm_subsite', ['slug'])
def backwards(self, orm):
# Deleting field 'AddedChannel.id'
db.delete_column('cg_channel_added', 'id')
db.delete_index('cg_channel_added', 'user_id')
db.delete_index('cg_channel_added', 'channel_id')
db.create_primary_key('cg_channel_added', ('channel_id', 'user_id'))
def backwards(self, orm):
db.delete_foreign_key('cmsplugin_link', 'public_id')
db.drop_primary_key("cmsplugin_linkpublic")
db.rename_column("cmsplugin_linkpublic", "cmspluginpublic_ptr_id",
"publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_linkpublic",
("publiccmsplugin_ptr_id", ))
db.rename_table("cmsplugin_link", "link_link")
db.rename_table("cmsplugin_linkpublic", "link_publiclink")
db.alter_column('link_link', 'public_id', orm['link.link:public'])
def backwards(self, orm):
db.delete_foreign_key('cmsplugin_text' ,'public_id')
db.drop_primary_key("cmsplugin_textpublic")
db.rename_column("cmsplugin_textpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_textpublic", ("publiccmsplugin_ptr_id",))
db.foreign_key_sql('cmsplugin_text' ,'public_id', 'cmsplugin_textpublic', "publiccmsplugin_ptr_id")
db.rename_table("cmsplugin_text", "text_text")
db.rename_table("cmsplugin_textpublic", "text_publictext")
db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public'])
def backwards(self, orm):
drop_tko_perf_view = """
DROP VIEW IF EXISTS tko_perf_view
"""
db.execute(drop_tko_perf_view)
drop_tko_perf_view_2 = """
DROP VIEW IF EXISTS tko_perf_view_2
"""
db.execute(drop_tko_perf_view_2)
db.delete_index('tko_iteration_result', 'test_idx')
db.create_primary_key('tko_iteration_result', ['test_idx'])
def backwards(self, orm):
try:
db.delete_foreign_key("cmsplugin_file", "public_id")
except:
pass
db.drop_primary_key("cmsplugin_filepublic")
db.rename_column("cmsplugin_filepublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_filepublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_file", "file_file")
db.rename_table("cmsplugin_filepublic", "file_publicfile")
db.alter_column("file_file", "public_id", orm["file.file:public"])
def backwards(self, orm):
# Deleting field 'Subsite.id'
db.delete_column(u'brainstorm_subsite', u'id')
# Changing field 'Subsite.slug'
db.alter_column(
u'brainstorm_subsite', 'slug',
self.gf('django.db.models.fields.SlugField')(max_length=50,
primary_key=True))
# Adding primary key on 'Subsite', fields ['slug']
db.create_primary_key(u'brainstorm_subsite', ['slug'])
def backwards(self, orm):
try:
db.delete_foreign_key('cmsplugin_flash' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_flashpublic")
db.rename_column("cmsplugin_flashpublic", "cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_flashpublic", ("publiccmsplugin_ptr_id",))
db.rename_table("cmsplugin_flash", "flash_flash")
db.rename_table("cmsplugin_flashpublic", "flash_publicflash")
db.alter_column('flash_flash', 'public_id', orm['flash.flash:public'])
def forwards(self, orm):
# Changing field 'AssetCategory.id' (serial)
# to 'AssetCategory.slug' (slugfield)
db.add_column('ralph_assets_assetcategory', 'slug',
self.gf('django.db.models.fields.SlugField')(default='slug',
unique=False, max_length=100),
keep_default=False)
db.add_column('ralph_assets_asset', 'category_new_id',
self.gf('django.db.models.fields.SlugField')(null=True,
unique=False, max_length=100, db_index=False))
db.add_column('ralph_assets_assetcategory', 'parent_new_id',
self.gf('django.db.models.fields.SlugField')(null=True,
unique=False, max_length=100, db_index=False))
db.add_column('ralph_assets_assetmodel', 'category_new_id',
self.gf('django.db.models.fields.SlugField')(null=True,
unique=False, max_length=100, db_index=False))
db.start_transaction()
for id in db.execute(
'SELECT id FROM ralph_assets_assetcategory WHERE parent_id IS NULL'):
self.update_slug_and_child(id)
db.commit_transaction()
db.create_unique(u'ralph_assets_assetcategory', ['slug'])
db.delete_foreign_key("ralph_assets_asset", "category_id")
db.delete_foreign_key("ralph_assets_assetmodel", "category_id")
db.delete_foreign_key("ralph_assets_assetcategory", "parent_id")
db.delete_column('ralph_assets_assetcategory', 'parent_id')
db.delete_column('ralph_assets_assetcategory', 'id')
db.create_primary_key("ralph_assets_assetcategory", ["slug"])
db.send_create_signal('ralph_assets', ['ralph_assets_assetcategory'])
db.rename_column('ralph_assets_assetcategory', 'parent_new_id', 'parent_id')
db.delete_column('ralph_assets_asset', 'category_id')
db.rename_column('ralph_assets_asset', 'category_new_id', 'category_id')
db.delete_column('ralph_assets_assetmodel', 'category_id')
db.rename_column('ralph_assets_assetmodel', 'category_new_id', 'category_id')
db.create_index('ralph_assets_assetcategory', ['parent_id'], unique=False)
db.create_index('ralph_assets_asset', ['category_id'], unique=False)
db.create_index('ralph_assets_assetmodel', ['category_id'], unique=False)
sql = db.foreign_key_sql('ralph_assets_asset',
'category_id', 'ralph_assets_assetcategory', 'slug')
db.execute(sql)
sql = db.foreign_key_sql('ralph_assets_assetmodel',
'category_id', 'ralph_assets_assetcategory', 'slug')
db.execute(sql)
sql = db.foreign_key_sql('ralph_assets_assetcategory',
'parent_id', 'ralph_assets_assetcategory', 'slug')
db.execute(sql)
try:
db.delete_unique('ralph_assets_assetcategory', ['name'])
except ValueError:
pass
def backwards(self, orm):
drop_tko_perf_view = """
DROP VIEW IF EXISTS tko_perf_view
"""
db.execute(drop_tko_perf_view)
drop_tko_perf_view_2 = """
DROP VIEW IF EXISTS tko_perf_view_2
"""
db.execute(drop_tko_perf_view_2)
db.delete_index('tko_iteration_result', 'test_idx')
db.create_primary_key('tko_iteration_result', ['test_idx'])
def backwards(self, orm):
db.delete_foreign_key('cmsplugin_snippetptr', 'public_id')
db.drop_primary_key("cmsplugin_snippetptrpublic")
db.rename_column("cmsplugin_snippetptrpublic",
"cmspluginpublic_ptr_id", "publiccmsplugin_ptr_id")
db.create_primary_key("cmsplugin_snippetptrpublic",
("publiccmsplugin_ptr_id", ))
db.rename_table("cmsplugin_snippetptr", "snippet_snippetptr")
db.rename_table("cmsplugin_snippetptrpublic",
"snippet_publicsnippetptr")
db.alter_column('snippet_snippetptr', 'public_id',
orm['snippet.snippetptr:public'])
def forwards(self, orm):
db.rename_table("text_text", "cmsplugin_text")
db.rename_table("text_publictext", "cmsplugin_textpublic")
db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.alter_column("cmsplugin_text", "public_id", orm["text.text:public"])
try:
db.delete_foreign_key("cmsplugin_text", "public_id")
except:
pass
db.drop_primary_key("cmsplugin_textpublic")
db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql("cmsplugin_text", "public_id", "cmsplugin_textpublic", "cmspluginpublic_ptr_id")
def backwards(self, orm):
# Removing unique constraint on 'LeaderboardStanding', fields ['ranking', 'metric']
db.delete_unique(u'links_leaderboardstanding', ['ranking', 'metric'])
# Deleting field 'LeaderboardStanding.id'
db.delete_column(u'links_leaderboardstanding', u'id')
# Changing field 'LeaderboardStanding.ranking'
db.alter_column(u'links_leaderboardstanding', 'ranking', self.gf('django.db.models.fields.PositiveIntegerField')(primary_key=True))
# Adding primary key index on 'LeaderboardStanding', fiels['ranking']
db.create_primary_key(u'links_leaderboardstanding', [u'ranking'])
def forwards(self, orm):
db.rename_table("snippet_snippetptr", "cmsplugin_snippetptr")
db.rename_table("snippet_publicsnippetptr", "cmsplugin_snippetptrpublic")
db.alter_column('cmsplugin_snippetptr', 'public_id', orm['snippet.snippetptr:public'])
try:
db.delete_foreign_key('cmsplugin_snippetptr' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_snippetptrpublic")
db.rename_column("cmsplugin_snippetptrpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.create_primary_key("cmsplugin_snippetptrpublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_snippetptr' ,'public_id', 'cmsplugin_snippetptrpublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
if not table_exists('microsite_microsite'):
# Adding model 'MicroSite'
db.create_table('microsite_microsite', (
('basesection_ptr', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['section.BaseSection'], unique=True, primary_key=True)),
))
db.send_create_signal('microsite', ['MicroSite'])
else:
db.delete_primary_key('microsite_microsite')
db.create_primary_key('microsite_microsite', ['basesection_ptr_id'])
db.delete_column('microsite_microsite', 'section_ptr_id')
db.alter_column('microsite_microsite', 'basesection_ptr_id', models.ForeignKey(orm['section.BaseSection'], null=False, blank=False))
db.delete_table('section_section')
def forwards(self, orm):
db.rename_table("file_file", "cmsplugin_file")
db.rename_table("file_publicfile", "cmsplugin_filepublic")
db.alter_column('cmsplugin_file', 'public_id', orm['file.file:public'])
try:
db.delete_foreign_key('cmsplugin_file' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_filepublic")
db.rename_column("cmsplugin_filepublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.create_primary_key("cmsplugin_filepublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_file' ,'public_id', 'cmsplugin_filepublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
db.rename_table("picture_picture", "cmsplugin_picture")
db.rename_table("picture_publicpicture", "cmsplugin_picturepublic")
db.rename_column("cmsplugin_picturepublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.alter_column('cmsplugin_picture', 'public_id', orm['picture.picture:public'])
try:
db.delete_foreign_key('cmsplugin_picture' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_picturepublic")
db.create_primary_key("cmsplugin_picturepublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_picture' ,'public_id', 'cmsplugin_picturepublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
db.rename_table("googlemap_googlemap", "cmsplugin_googlemap")
db.rename_table("googlemap_publicgooglemap", "cmsplugin_googlemappublic")
db.alter_column('cmsplugin_googlemap', 'public_id', orm['googlemap.googlemap:public'])
try:
db.delete_foreign_key('cmsplugin_googlemap' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_googlemappublic")
db.rename_column("cmsplugin_googlemappublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.create_primary_key("cmsplugin_googlemappublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_googlemap' ,'public_id', 'cmsplugin_googlemappublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
db.rename_table("link_link", "cmsplugin_link")
db.rename_table("link_publiclink", "cmsplugin_linkpublic")
db.alter_column('cmsplugin_link', 'public_id', orm['link.link:public'])
try:
db.delete_foreign_key('cmsplugin_link' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_linkpublic")
db.rename_column("cmsplugin_linkpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.create_primary_key("cmsplugin_linkpublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_link' ,'public_id', 'cmsplugin_linkpublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
db.rename_table("text_text", "cmsplugin_text")
db.rename_table("text_publictext", "cmsplugin_textpublic")
db.rename_column("cmsplugin_textpublic", "publiccmsplugin_ptr_id", "cmspluginpublic_ptr_id")
db.alter_column('cmsplugin_text', 'public_id', orm['text.text:public'])
try:
db.delete_foreign_key('cmsplugin_text' ,'public_id')
except:
pass
db.drop_primary_key("cmsplugin_textpublic")
db.create_primary_key("cmsplugin_textpublic", ("cmspluginpublic_ptr_id",))
db.foreign_key_sql('cmsplugin_text' ,'public_id', 'cmsplugin_textpublic', 'cmspluginpublic_ptr_id')
def forwards(self, orm):
# create assessment answer model
db.create_table(
u'scorystapp_submission',
((u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('assessment',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['scorystapp.Assessment'])),
('course_user1',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['scorystapp.CourseUser'], null=True, blank=True)),
('released1',
self.gf('django.db.models.fields.BooleanField')(default=False)),
('page_count1',
self.gf('django.db.models.fields.IntegerField')()),
('pdf1', self.gf('django.db.models.fields.files.FileField')(
max_length=100))))
db.send_create_signal(u'scorystapp', ['Submission'])
# add submission_ptr field for primary key
db.add_column(u'scorystapp_examanswer',
'submission_ptr',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['scorystapp.Submission'], null=True),
keep_default=False)
# create assessment that corresponds to each exam
db.start_transaction()
for exam_answer in orm.ExamAnswer.objects.all():
submission = orm.Submission(id=exam_answer.id,
course_user1=exam_answer.course_user,
released1=exam_answer.released,
assessment=exam_answer.exam,
page_count1=exam_answer.page_count,
pdf1=exam_answer.pdf)
submission.save()
exam_answer.submission_ptr = submission
exam_answer.save()
db.commit_transaction()
# convert submission_ptr_id to primary key
db.create_unique(u'scorystapp_examanswer', ['submission_ptr_id'])
db.delete_column(u'scorystapp_examanswer', u'id')
db.create_primary_key(u'scorystapp_examanswer', [u'submission_ptr_id'])
# delete exam answer columns that we put into assessment answer
db.delete_column(u'scorystapp_examanswer', 'course_user_id')
db.delete_column(u'scorystapp_examanswer', 'released')
db.delete_column(u'scorystapp_examanswer', 'exam_id')
def backwards(self, orm):
# Removing unique constraint on 'LeaderboardStanding', fields ['ranking', 'metric']
db.delete_unique(u'links_leaderboardstanding', ['ranking', 'metric'])
# Deleting field 'LeaderboardStanding.id'
db.delete_column(u'links_leaderboardstanding', u'id')
# Changing field 'LeaderboardStanding.ranking'
db.alter_column(
u'links_leaderboardstanding', 'ranking',
self.gf('django.db.models.fields.PositiveIntegerField')(
primary_key=True))
# Adding primary key index on 'LeaderboardStanding', fiels['ranking']
db.create_primary_key(u'links_leaderboardstanding', [u'ranking'])
def forwards(self, orm):
# OMFG Get ready, we're going to change the primary key!
# Doing bad things, disabling triggers
db.execute("ALTER TABLE brainstorm_idea DISABLE TRIGGER ALL;")
# Dropping foreign key constraint
db.delete_foreign_key('brainstorm_idea', 'subsite_id')
db.execute('DROP INDEX brainstorm_idea_subsite_id_like')
db.delete_index('brainstorm_idea', ['subsite_id'])
# Removing primary key on 'Subsite', fields ['slug']
db.delete_primary_key(u'brainstorm_subsite')
# Adding primary key field 'Subsite.id'
db.add_column(u'brainstorm_subsite', u'id',
self.gf('django.db.models.fields.IntegerField')(blank=True, null=True))
# WOW. Have to manually create AutoFields. Thanks Django!
db.execute('CREATE SEQUENCE brainstorm_subsite_id_seq;')
db.execute("UPDATE brainstorm_subsite SET id = nextval('brainstorm_subsite_id_seq');")
db.execute("ALTER TABLE brainstorm_subsite ALTER COLUMN id SET DEFAULT nextval('brainstorm_subsite_id_seq');")
db.execute('ALTER SEQUENCE brainstorm_subsite_id_seq OWNED BY brainstorm_subsite.id;')
db.execute("SELECT setval('brainstorm_subsite_id_seq', q.i) FROM(SELECT MAX(id) i FROM brainstorm_subsite) q;")
# Now make it the pk
db.create_primary_key('brainstorm_subsite', ['id'])
# Updating foreign key values
db.execute('''UPDATE brainstorm_idea idea
SET subsite_id = subsite.id
FROM brainstorm_subsite subsite
WHERE(idea.subsite_id = subsite.slug);''')
# Casting the fk to an integer
db.execute("ALTER TABLE brainstorm_idea ALTER COLUMN subsite_id TYPE integer USING CAST(subsite_id AS integer);")
# Re-adding foreign key constraint
fk_sql = db.foreign_key_sql('brainstorm_idea', 'subsite_id', 'brainstorm_subsite', 'id')
db.execute(fk_sql)
# Changing field 'Subsite.slug' to a plain old slugfield
db.alter_column(u'brainstorm_subsite', 'slug', self.gf('django.db.models.fields.SlugField')(max_length=50))
# Adding unique constraint on 'Subsite', fields ['slug']
db.create_unique(u'brainstorm_subsite', ['slug'])
# Re-enabling triggers
db.execute("ALTER TABLE brainstorm_idea ENABLE TRIGGER ALL;")
def backwards(self, orm):
db.rename_column('pricing_volume_type_resource', 'resource_ptr_id', 'resource_id')
db.delete_column('pricing_volume_type_resource', u'id')
db.alter_column('pricing_volume_type_resource', 'os_volume_type_id', self.gf('django.db.models.fields.CharField')(unique=True, max_length=36, db_index=False))
db.delete_index('pricing_volume_type_resource', ['os_volume_type_id'])
db.rename_column('pricing_volume_type_resource', 'os_volume_type_id', 'os_type_id')
db.create_primary_key('pricing_volume_type_resource', ['os_type_id'])
db.add_column('pricing_volume_type_resource', 'description', self.gf('django.db.models.fields.CharField')(max_length=100))
db.alter_column('pricing_instance_flavor_resource', 'id', self.gf('django.db.models.fields.IntegerField')(primary_key=True))
db.delete_index('pricing_instance_flavor_resource', ['os_instance_type_id'])
db.rename_column('pricing_instance_flavor_resource', 'os_instance_type_id', 'os_flavor_id')
db.rename_column('pricing_instance_flavor_resource', 'resourcebase_ptr_id', 'resource_id')
db.alter_column('pricing_instance_flavor_resource', 'resource_id', self.gf('django.db.models.fields.IntegerField')(blank=False))
db.delete_column('pricing_instance_flavor_resource', u'id')
db.create_primary_key('pricing_instance_flavor_resource', ['os_flavor_id'])
db.add_column('pricing_instance_flavor_resource', 'description', self.gf('django.db.models.fields.CharField')(max_length=100))
def forwards(self, orm):
# create assessment model
db.create_table(u'scorystapp_assessment', (
(u'id',
self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('course1', self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['scorystapp.Course'])),
('name1',
self.gf('django.db.models.fields.CharField')(max_length=200)),
('grade_down1',
self.gf('django.db.models.fields.BooleanField')(default=True)),
('cap_score1',
self.gf('django.db.models.fields.BooleanField')(default=True)),
))
db.send_create_signal(u'scorystapp', ['Assessment'])
# add assessment_ptr field for primary key
db.add_column(u'scorystapp_exam',
'assessment_ptr',
self.gf('django.db.models.fields.related.ForeignKey')(
to=orm['scorystapp.Assessment'], null=True),
keep_default=False)
# create assessment that corresponds to each exam
for exam in orm.Exam.objects.all():
# maintain exam ID so foreign key relationships don't fail
assessment = orm.Assessment(id=exam.id,
course1=exam.course,
name1=exam.name,
grade_down1=exam.grade_down,
cap_score1=exam.cap_score)
assessment.save()
exam.assessment_ptr = assessment
exam.save()
# convert assessment_ptr to primary key
db.create_unique(u'scorystapp_exam', ['assessment_ptr_id'])
db.delete_column(u'scorystapp_exam', u'id')
db.create_primary_key(u'scorystapp_exam', [u'assessment_ptr_id'])
# delete exam columns that we put into assessment
db.delete_column(u'scorystapp_exam', 'course_id')
db.delete_column(u'scorystapp_exam', 'grade_down')
db.delete_column(u'scorystapp_exam', 'name')
db.delete_column(u'scorystapp_exam', 'cap_score')
def test_primary_key(self):
"""
Test the primary key operations
"""
db.create_table("test_pk", [
('id', models.IntegerField(primary_key=True)),
('new_pkey', models.IntegerField()),
('eggs', models.IntegerField(unique=True)),
])
db.execute_deferred_sql()
# Remove the default primary key, and make eggs it
db.delete_primary_key("test_pk")
db.create_primary_key("test_pk", "new_pkey")
# Try inserting a now-valid row pair
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)")
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)")
db.delete_table("test_pk")
def test_primary_key(self):
"""
Test the primary key operations
"""
db.create_table("test_pk", [
('id', models.IntegerField(primary_key=True)),
('new_pkey', models.IntegerField()),
('eggs', models.IntegerField(unique=True)),
])
db.execute_deferred_sql()
# Remove the default primary key, and make eggs it
db.delete_primary_key("test_pk")
db.create_primary_key("test_pk", "new_pkey")
# Try inserting a now-valid row pair
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)")
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)")
db.delete_table("test_pk")
def test_primary_key(self):
"""
Test the primary key operations
"""
db.create_table(
"test_pk",
[
("id", models.IntegerField(primary_key=True)),
("new_pkey", models.IntegerField()),
("eggs", models.IntegerField(unique=True)),
],
)
db.execute_deferred_sql()
db.start_transaction()
# Remove the default primary key, and make eggs it
db.drop_primary_key("test_pk")
db.create_primary_key("test_pk", "new_pkey")
# Try inserting a now-valid row pair
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3), (1, 3, 4)")
db.rollback_transaction()
db.delete_table("test_pk")
def forwards(self, orm):
# Deleting field 'BaseSection.status'
db.delete_column('section_basesection', 'status')
# Deleting field 'BaseSection.slug'
db.delete_column('section_basesection', 'slug')
# Deleting field 'BaseSection.main_image'
db.delete_column('section_basesection', 'main_image')
# Deleting field 'BaseSection.id'
db.delete_column('section_basesection', 'id')
for field in ('name', 'description', 'plain_description', ):
for lang, lang_name in settings.LANGUAGES:
db.delete_column('section_basesection', get_real_fieldname(field, lang))
# Swapping primary key from id to basecontent_ptr_id
db.create_primary_key('section_basesection', ['basecontent_ptr_id'])
# Add new foreign key to section_basesection_related_content.basesection_id
db.alter_column('section_basesection_related_content', 'basesection_id', models.ForeignKey(orm['section.BaseSection'], null=False, blank=False))
def test_primary_key(self):
"""
Test the primary key operations
"""
# SQLite backend doesn't support this yet.
if db.backend_name == "sqlite3":
return
db.create_table("test_pk", [
('id', models.IntegerField(primary_key=True)),
('new_pkey', models.IntegerField()),
('eggs', models.IntegerField(unique=True)),
])
db.execute_deferred_sql()
# Remove the default primary key, and make eggs it
db.drop_primary_key("test_pk")
db.create_primary_key("test_pk", "new_pkey")
# Try inserting a now-valid row pair
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 2, 3)")
db.execute("INSERT INTO test_pk (id, new_pkey, eggs) VALUES (1, 3, 4)")
db.delete_table("test_pk")
def forwards(self, orm):
# create assessment answer model
db.create_table(u'scorystapp_submission', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('assessment', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['scorystapp.Assessment'])),
('course_user1', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['scorystapp.CourseUser'], null=True, blank=True)),
('released1', self.gf('django.db.models.fields.BooleanField')(default=False)),
('page_count1', self.gf('django.db.models.fields.IntegerField')()),
('pdf1', self.gf('django.db.models.fields.files.FileField')(max_length=100))
))
db.send_create_signal(u'scorystapp', ['Submission'])
# add submission_ptr field for primary key
db.add_column(u'scorystapp_examanswer', 'submission_ptr',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['scorystapp.Submission'], null=True),
keep_default=False)
# create assessment that corresponds to each exam
db.start_transaction()
for exam_answer in orm.ExamAnswer.objects.all():
submission = orm.Submission(id=exam_answer.id, course_user1=exam_answer.course_user,
released1=exam_answer.released, assessment=exam_answer.exam, page_count1=exam_answer.page_count,
pdf1=exam_answer.pdf)
submission.save()
exam_answer.submission_ptr = submission
exam_answer.save()
db.commit_transaction()
# convert submission_ptr_id to primary key
db.create_unique(u'scorystapp_examanswer', ['submission_ptr_id'])
db.delete_column(u'scorystapp_examanswer', u'id')
db.create_primary_key(u'scorystapp_examanswer', [u'submission_ptr_id'])
# delete exam answer columns that we put into assessment answer
db.delete_column(u'scorystapp_examanswer', 'course_user_id')
db.delete_column(u'scorystapp_examanswer', 'released')
db.delete_column(u'scorystapp_examanswer', 'exam_id')
def forwards(self, orm):
# create assessment model
db.create_table(u'scorystapp_assessment', (
(u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
('course1', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['scorystapp.Course'])),
('name1', self.gf('django.db.models.fields.CharField')(max_length=200)),
('grade_down1', self.gf('django.db.models.fields.BooleanField')(default=True)),
('cap_score1', self.gf('django.db.models.fields.BooleanField')(default=True)),
))
db.send_create_signal(u'scorystapp', ['Assessment'])
# add assessment_ptr field for primary key
db.add_column(u'scorystapp_exam', 'assessment_ptr',
self.gf('django.db.models.fields.related.ForeignKey')(to=orm['scorystapp.Assessment'], null=True),
keep_default=False)
# create assessment that corresponds to each exam
for exam in orm.Exam.objects.all():
# maintain exam ID so foreign key relationships don't fail
assessment = orm.Assessment(id=exam.id, course1=exam.course, name1=exam.name,
grade_down1=exam.grade_down, cap_score1=exam.cap_score)
assessment.save()
exam.assessment_ptr = assessment
exam.save()
# convert assessment_ptr to primary key
db.create_unique(u'scorystapp_exam', ['assessment_ptr_id'])
db.delete_column(u'scorystapp_exam', u'id')
db.create_primary_key(u'scorystapp_exam', [u'assessment_ptr_id'])
# delete exam columns that we put into assessment
db.delete_column(u'scorystapp_exam', 'course_id')
db.delete_column(u'scorystapp_exam', 'grade_down')
db.delete_column(u'scorystapp_exam', 'name')
db.delete_column(u'scorystapp_exam', 'cap_score')
def backwards(self, orm):
db.delete_foreign_key('invapp_bagaction', 'bag_id')
db.delete_primary_key('invapp_bag')
# Deleting field 'Bag.id'
db.delete_column(u'invapp_bag', u'id')
db.execute('DROP SEQUENCE invapp_bag_id_seq')
# Changing field 'Bag.bagname'
db.alter_column(u'invapp_bag', 'bagname', self.gf('django.db.models.fields.TextField')(primary_key=True))
db.create_primary_key(u'invapp_bag', ['bagname'])
db.delete_column(u'invapp_bagaction', 'bag_id')
db.add_column(u'invapp_bagaction', 'bag_id', self.gf('django.db.models.fields.TextField')())
sql = db.foreign_key_sql('invapp_bagaction', 'bag_id', 'invapp_bag', 'bagname')
db.execute(sql)
db.create_unique('invapp_bagaction', ['bag_id', 'action', 'timestamp'])
def forwards(self, orm):
# set new primary key for maps_map
db.delete_column('maps_map', 'id')
db.create_primary_key('maps_map', ['resourcebase_ptr_id'])
# set fk for maps_maplayer
db.alter_column('maps_maplayer', 'map_id', models.ForeignKey(orm['maps.map'], null=True, blank=True))
def forwards_publishable(self, orm):
'''
creation of publishable objects
TODO: sync publish_from
'''
# move the data
# db.execute('''
# INSERT INTO
# `core_publishable` (old_id, content_type_id, %(cols_to)s)
# SELECT
# a.id, ct.id, %(cols_from)s
# FROM
# `%(table)s` a, `django_content_type` ct
# WHERE
# ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s';
# ''' % self.substitute
# )
# add link to parent
db.add_column(self.table, 'publishable_ptr',
models.IntegerField(null=True, blank=True))
# update the link
# db.execute('''
# UPDATE
# `core_publishable` pub
# JOIN `%(table)s` art ON (art.`id` = pub.`old_id`)
# JOIN `django_content_type` ct ON (pub.`content_type_id` = ct.`id` AND ct.`app_label` = '%(app_label)s' AND ct.`model` = '%(model)s')
# SET
# art.`publishable_ptr` = pub.`id`;
# ''' % self.substitute
# )
# remove constraints from all models reffering to us
# self.alter_self_foreignkeys(orm)
# drop primary key
db.alter_column(self.table, 'id', models.IntegerField())
db.drop_primary_key(self.table)
# replace it with a link to parent
db.rename_column(self.table, 'publishable_ptr', 'publishable_ptr_id')
db.alter_column(
self.table, 'publishable_ptr_id',
models.ForeignKey(orm['core.Publishable'], unique=True))
db.create_primary_key(self.table, 'publishable_ptr_id')
# make it a FK
# db.execute(
# 'ALTER TABLE `%s` ADD CONSTRAINT `publishable_ptr_id_refs_id_%s` FOREIGN KEY (`publishable_ptr_id`) REFERENCES `core_publishable` (`id`);' % (
# self.table,
# abs(hash((self.table, 'core_publishable'))),
# )
# )
# move data, that were pointing to us
# self.move_self_foreignkeys(orm)
# drop duplicate columns
db.delete_column(self.table, 'id')
for column in self.cols_from:
db.delete_column(self.table, column)
def forwards(self, orm):
# Deleting model 'QuestionRevision'
db.delete_table(u'question_revision')
# Deleting model 'AnswerRevision'
db.delete_table(u'answer_revision')
# Deleting field 'Answer.vote_up_count'
db.delete_column(u'answer', 'vote_up_count')
# Deleting field 'Answer.author'
db.delete_column(u'answer', 'author_id')
# Deleting field 'Answer.deleted'
db.delete_column(u'answer', 'deleted')
# Deleting field 'Answer.question'
db.delete_column(u'answer', 'question_id')
# Deleting field 'Answer.html'
db.delete_column(u'answer', 'html')
# Deleting field 'Answer.offensive_flag_count'
db.delete_column(u'answer', 'offensive_flag_count')
# Deleting field 'Answer.deleted_by'
db.delete_column(u'answer', 'deleted_by_id')
# Deleting field 'Answer.comment_count'
db.delete_column(u'answer', 'comment_count')
# Deleting field 'Answer.score'
db.delete_column(u'answer', 'score')
# Deleting field 'Answer.vote_down_count'
db.delete_column(u'answer', 'vote_down_count')
# Deleting field 'Answer.added_at'
db.delete_column(u'answer', 'added_at')
# Deleting field 'Answer.last_edited_by'
db.delete_column(u'answer', 'last_edited_by_id')
# Deleting field 'Answer.deleted_at'
db.delete_column(u'answer', 'deleted_at')
# Deleting field 'Answer.id'
db.delete_column(u'answer', 'id')
# Deleting field 'Answer.last_edited_at'
db.delete_column(u'answer', 'last_edited_at')
# Changing field 'Answer.node_ptr'
db.alter_column(u'answer', 'node_ptr_id', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['forum.Node'], unique=True))
db.create_primary_key(u'answer', ['node_ptr_id'])
# Deleting field 'Question.vote_up_count'
db.delete_column(u'question', 'vote_up_count')
# Deleting field 'Question.offensive_flag_count'
db.delete_column(u'question', 'offensive_flag_count')
# Deleting field 'Question.summary'
db.delete_column(u'question', 'summary')
# Deleting field 'Question.id'
db.delete_column(u'question', 'id')
# Deleting field 'Question.deleted_at'
db.delete_column(u'question', 'deleted_at')
# Deleting field 'Question.score'
db.delete_column(u'question', 'score')
# Deleting field 'Question.author'
db.delete_column(u'question', 'author_id')
# Deleting field 'Question.comment_count'
db.delete_column(u'question', 'comment_count')
# Deleting field 'Question.html'
db.delete_column(u'question', 'html')
# Deleting field 'Question.vote_down_count'
db.delete_column(u'question', 'vote_down_count')
# Deleting field 'Question.last_edited_by'
db.delete_column(u'question', 'last_edited_by_id')
# Deleting field 'Question.deleted'
db.delete_column(u'question', 'deleted')
# Deleting field 'Question.tagnames'
db.delete_column(u'question', 'tagnames')
# Deleting field 'Question.title'
db.delete_column(u'question', 'title')
# Deleting field 'Question.added_at'
db.delete_column(u'question', 'added_at')
# Deleting field 'Question.deleted_by'
db.delete_column(u'question', 'deleted_by_id')
# Deleting field 'Question.last_edited_at'
db.delete_column(u'question', 'last_edited_at')
# Removing M2M table for field followed_by on 'Question'
db.delete_table('question_followed_by')
# Removing M2M table for field tags on 'Question'
db.delete_table('question_tags')
# Changing field 'Question.node_ptr'
db.alter_column(u'question', 'node_ptr_id', self.gf('django.db.models.fields.related.OneToOneField')(to=orm['forum.Node'], unique=True))
db.create_primary_key(u'question', ['node_ptr_id'])
def forwards(self, orm):
# OMFG Get ready, we're going to change the primary key!
# Doing bad things, disabling triggers
db.execute("ALTER TABLE brainstorm_idea DISABLE TRIGGER ALL;")
# Dropping foreign key constraint
db.delete_foreign_key('brainstorm_idea', 'subsite_id')
db.execute('DROP INDEX brainstorm_idea_subsite_id_like')
db.delete_index('brainstorm_idea', ['subsite_id'])
# Removing primary key on 'Subsite', fields ['slug']
db.delete_primary_key(u'brainstorm_subsite')
# Adding primary key field 'Subsite.id'
db.add_column(
u'brainstorm_subsite', u'id',
self.gf('django.db.models.fields.IntegerField')(blank=True,
null=True))
# WOW. Have to manually create AutoFields. Thanks Django!
db.execute('CREATE SEQUENCE brainstorm_subsite_id_seq;')
db.execute(
"UPDATE brainstorm_subsite SET id = nextval('brainstorm_subsite_id_seq');"
)
db.execute(
"ALTER TABLE brainstorm_subsite ALTER COLUMN id SET DEFAULT nextval('brainstorm_subsite_id_seq');"
)
db.execute(
'ALTER SEQUENCE brainstorm_subsite_id_seq OWNED BY brainstorm_subsite.id;'
)
db.execute(
"SELECT setval('brainstorm_subsite_id_seq', q.i) FROM(SELECT MAX(id) i FROM brainstorm_subsite) q;"
)
# Now make it the pk
db.create_primary_key('brainstorm_subsite', ['id'])
# Updating foreign key values
db.execute('''UPDATE brainstorm_idea idea
SET subsite_id = subsite.id
FROM brainstorm_subsite subsite
WHERE(idea.subsite_id = subsite.slug);''')
# Casting the fk to an integer
db.execute(
"ALTER TABLE brainstorm_idea ALTER COLUMN subsite_id TYPE integer USING CAST(subsite_id AS integer);"
)
# Re-adding foreign key constraint
fk_sql = db.foreign_key_sql('brainstorm_idea', 'subsite_id',
'brainstorm_subsite', 'id')
db.execute(fk_sql)
# Changing field 'Subsite.slug' to a plain old slugfield
db.alter_column(
u'brainstorm_subsite', 'slug',
self.gf('django.db.models.fields.SlugField')(max_length=50))
# Adding unique constraint on 'Subsite', fields ['slug']
db.create_unique(u'brainstorm_subsite', ['slug'])
# Re-enabling triggers
db.execute("ALTER TABLE brainstorm_idea ENABLE TRIGGER ALL;")
def forwards(self, orm):
# Deleting field id
db.delete_column('layers_layer', 'id')
# set new primary key for layers_layer
db.create_primary_key('layers_layer', ['resourcebase_ptr_id'])
