def forwards(self, orm): # Adding index on 'BlogPost', fields ['object_id'] db.create_index(u'posts_blogpost', ['object_id']) # Changing field 'BlogPost.content_type' db.alter_column(u'posts_blogpost', 'content_type_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['contenttypes.ContentType'], null=True))
def forwards(self, orm): # Deleting model 'DirectorsGenres' db.delete_table(u'directors_genres') # Deleting model 'MoviesGenres' db.delete_table(u'movies_genres') # Deleting model 'MoviesDirectors' db.delete_table(u'movies_directors') # Deleting model 'Directors' db.delete_table(u'directors') # Renaming column for 'Roles.movie_id' to match new field type. db.rename_column(u'roles', 'movie_id', 'movie_id_id') # Changing field 'Roles.movie_id' db.alter_column(u'roles', 'movie_id_id', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['step_game.Movies'])) # Adding index on 'Roles', fields ['movie_id'] db.create_index(u'roles', ['movie_id_id']) # Renaming column for 'Roles.actor_id' to match new field type. db.rename_column(u'roles', 'actor_id', 'actor_id_id') # Changing field 'Roles.actor_id' db.alter_column(u'roles', 'actor_id_id', self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['step_game.Actors'])) # Adding index on 'Roles', fields ['actor_id'] db.create_index(u'roles', ['actor_id_id'])
def forwards(self, orm): # Deleting field 'Work.is_taksim' db.delete_column(u'makam_work', 'is_taksim') # Adding field 'Recording.has_taksim' db.add_column(u'makam_recording', 'has_taksim', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding field 'Recording.has_gazel' db.add_column(u'makam_recording', 'has_gazel', self.gf('django.db.models.fields.BooleanField')(default=False), keep_default=False) # Adding M2M table for field makam on 'Recording' m2m_table_name = db.shorten_name(u'makam_recording_makam') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('recording', models.ForeignKey(orm[u'makam.recording'], null=False)), ('makam', models.ForeignKey(orm[u'makam.makam'], null=False)) )) db.create_unique(m2m_table_name, ['recording_id', 'makam_id']) # Changing field 'Recording.title' db.alter_column(u'makam_recording', 'title', self.gf('django.db.models.fields.CharField')(max_length=200)) # Adding index on 'Artist', fields ['dummy'] db.create_index(u'makam_artist', ['dummy'])
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 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 forwards(self, orm): # Adding model 'Faction' db.create_table('representative_faction', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)), ('short', self.gf('django.db.models.fields.CharField')(max_length=32, null=True)), )) db.send_create_signal('representative', ['Faction']) # Deleting field 'Representative.faction_en' db.delete_column('representative_representative', 'faction_en') # Deleting field 'Representative.faction_ka' db.delete_column('representative_representative', 'faction_ka') # Renaming column for 'Representative.faction' to match new field type. db.rename_column('representative_representative', 'faction', 'faction_id') # Changing field 'Representative.faction' db.alter_column('representative_representative', 'faction_id', self.gf('django.db.models.fields.related.ForeignKey')(null=True, to=orm['representative.Faction'])) # Adding index on 'Representative', fields ['faction'] db.create_index('representative_representative', ['faction_id']) # Removing M2M table for field parties on 'Cabinet' db.delete_table(db.shorten_name('representative_cabinet_parties')) # Adding M2M table for field factions on 'Cabinet' m2m_table_name = db.shorten_name('representative_cabinet_factions') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('cabinet', models.ForeignKey(orm['representative.cabinet'], null=False)), ('faction', models.ForeignKey(orm['representative.faction'], null=False)) )) db.create_unique(m2m_table_name, ['cabinet_id', 'faction_id'])
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 forwards(self, orm): # Changing field 'Page.titre_url' db.alter_column('story_page', 'titre_url', self.gf('django.db.models.fields.SlugField')(max_length=50)) # Adding index on 'Page', fields ['titre_url'] db.create_index('story_page', ['titre_url'])
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): # Changing field 'InstitutionDetails.number_id' db.alter_column('edumanage_institutiondetails', 'number_id', self.gf('django.db.models.fields.PositiveIntegerField')(max_length=6, null=True, blank=True)) # Deleting field 'InstRealmMon.instid' db.delete_column('edumanage_instrealmmon', 'instid_id') # Renaming column for 'InstRealmMon.realm' to match new field type. db.rename_column('edumanage_instrealmmon', 'realm', 'realm_id') # Changing field 'InstRealmMon.realm' # WORKAROUND NEEDED # This migration breaks with PostgreSQL with: # ERROR: column "realm_id" cannot be cast automatically to type integer # HINT: Specify a USING expression to perform the conversion. # STATEMENT: ALTER TABLE "edumanage_instrealmmon" ALTER COLUMN "realm_id" TYPE integer, # ALTER COLUMN "realm_id" SET NOT NULL, ALTER COLUMN "realm_id" DROP DEFAULT; # This is a known problem: http://south.aeracode.org/ticket/484 # (PostgreSQL will not automatically convert and conversion must be provided with the USING clause) # Workaround: For PostgreSQL invoke a direct SQL statement amended with a USING clause to do the converion explicitly. # Credits: # * http://codeinthehole.com/writing/altering-postgres-table-columns-with-south/ # * http://stackoverflow.com/questions/13170570/change-type-of-varchar-field-to-integer-cannot-be-cast-automatically-to-type-i if ( db._get_connection().vendor == "postgresql" ): db.execute('ALTER TABLE "edumanage_instrealmmon" ALTER COLUMN "realm_id" TYPE integer USING (trim(realm_id)::integer), ALTER COLUMN "realm_id" SET NOT NULL, ALTER COLUMN "realm_id" DROP DEFAULT;') else: db.alter_column('edumanage_instrealmmon', 'realm_id', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['edumanage.InstRealm'])) # Adding index on 'InstRealmMon', fields ['realm'] db.create_index('edumanage_instrealmmon', ['realm_id']) # Changing field 'InstRealmMon.mon_type' db.alter_column('edumanage_instrealmmon', 'mon_type', self.gf('django.db.models.fields.CharField')(max_length=16))
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, orm): # Adding field 'City.type' db.add_column('locations_city', 'type', self.gf('django.db.models.fields.CharField')(default='primary', max_length='15', db_index=True), keep_default=False) # Adding field 'City.normalized' db.add_column('locations_city', 'normalized', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['locations.City'], null=True, blank=True), keep_default=False) # Adding index on 'City', fields ['name'] db.create_index('locations_city', ['name']) # Adding field 'State.type' db.add_column('locations_state', 'type', self.gf('django.db.models.fields.CharField')(default='primary', max_length='15', db_index=True), keep_default=False) # Adding field 'State.normalized' db.add_column('locations_state', 'normalized', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['locations.State'], null=True, blank=True), keep_default=False) # Adding index on 'State', fields ['name'] db.create_index('locations_state', ['name']) # Adding field 'Country.type' db.add_column('locations_country', 'type', self.gf('django.db.models.fields.CharField')(default='primary', max_length='15', db_index=True), keep_default=False) # Adding field 'Country.normalized' db.add_column('locations_country', 'normalized', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['locations.Country'], null=True, blank=True), keep_default=False)
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 backwards(self, orm): # Adding index on 'Species', fields ['name'] db.create_index(u'backend_species', ['name']) # Adding index on 'Species', fields ['name_en'] db.create_index(u'backend_species', ['name_en']) # Adding index on 'Species', fields ['name_it'] db.create_index(u'backend_species', ['name_it']) # Adding index on 'Species', fields ['name_fr'] db.create_index(u'backend_species', ['name_fr']) # Adding index on 'Individual', fields ['name'] db.create_index(u'backend_individual', ['name']) # Adding field 'Area.codezone' db.add_column(u'backend_area', 'codezone', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True), keep_default=False) # Adding M2M table for field species on 'Area' m2m_table_name = db.shorten_name(u'backend_area_species') db.create_table(m2m_table_name, ( ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)), ('area', models.ForeignKey(orm[u'backend.area'], null=False)), ('species', models.ForeignKey(orm[u'backend.species'], null=False)) )) db.create_unique(m2m_table_name, ['area_id', 'species_id']) # Changing field 'Snowing.observer' db.alter_column(u'backend_snowing', 'observer_id', self.gf('select2.fields.ForeignKey')(to=orm['backend.Observer'], search_field=''))
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): # Adding model 'FlatImages' db.create_table(u'image_quality_tagging_flatimages', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('flat_id', self.gf('django.db.models.fields.IntegerField')()), ('service', self.gf('django.db.models.fields.CharField')(max_length=50)), ('image_name', self.gf('django.db.models.fields.CharField')(max_length=255)), ('image_encoded', self.gf('django.db.models.fields.CharField')(max_length=255)), )) db.send_create_signal('image_quality_tagging', ['FlatImages']) # Adding unique constraint on 'FlatImages', fields ['flat_id', 'image_encoded'] db.create_unique(u'image_quality_tagging_flatimages', ['flat_id', 'image_encoded']) # Adding model 'FlatImageTag' db.create_table(u'image_quality_tagging_flatimagetag', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('uid', self.gf('django.db.models.fields.CharField')(max_length=50)), ('flat_id', self.gf('django.db.models.fields.IntegerField')()), ('image_encoded', self.gf('django.db.models.fields.CharField')(max_length=255)), ('img_wall', self.gf('django.db.models.fields.IntegerField')(null=True)), ('img_cleanliness', self.gf('django.db.models.fields.IntegerField')(null=True)), ('img_spacious', self.gf('django.db.models.fields.IntegerField')(null=True)), ('img_flat_overall', self.gf('django.db.models.fields.IntegerField')(null=True)), ('img_windows_size', self.gf('django.db.models.fields.IntegerField')(null=True)), )) db.send_create_signal('image_quality_tagging', ['FlatImageTag']) # Adding unique constraint on 'FlatImageTag', fields ['uid', 'image_encoded'] db.create_unique(u'image_quality_tagging_flatimagetag', ['uid', 'image_encoded']) # Adding index on 'FlatImageTag', fields ['uid', 'image_encoded'] db.create_index(u'image_quality_tagging_flatimagetag', ['uid', 'image_encoded'])
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 handle_app(self, app, **options): appname = app.__name__ print 'handling app %s' % appname for obj in [getattr(app, name) for name in dir(app)]: if not isclass(obj): continue if not issubclass(obj, models.Model): continue if not is_multilingual_model(obj): continue print 'altering model %s' % obj table = obj._meta.translation_model._meta.db_table db.debug = True db.add_column(table, 'language_code', models.CharField(max_length=15, blank=True, choices=get_language_choices(), db_index=True) ) # migrate the model # This is TERRIBLE for performance, but whatever... print 'migrating data' tempfield = models.IntegerField(blank=False, null=False, choices=get_language_choices(), db_index=False) tempfield.contribute_to_class(obj._meta.translation_model, 'language_id') for row in obj.objects.all(): for translation in row.translations.all(): translation.language_code = get_code_by_id(translation.language_id) translation.save() db.create_index(table, ['language_code', 'master_id']) print 'deleting language_id column' db.delete_unique(table, ['language_id', 'master_id']) db.delete_column(table, 'language_id')
def forwards(self, orm): # Adding index on 'FileSearch', fields ['id_group'] db.create_index('yandex_filesearch', ['id_group']) # Adding index on 'MessageSearch', fields ['id_group'] db.create_index('yandex_messagesearch', ['id_group'])
def forwards(self, orm): # Adding index on 'ScriptDB', fields ['db_key'] db.create_index('scripts_scriptdb', ['db_key']) # Adding index on 'ScriptAttribute', fields ['db_key'] db.create_index('scripts_scriptattribute', ['db_key'])
def forwards(self, orm): # Changing field 'Spell.altname' db.alter_column('spell', 'altname', self.gf('django.db.models.fields.SlugField')(max_length=64)) # Adding index on 'Spell', fields ['altname'] db.create_index('spell', ['altname'])
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)
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 forwards(self, orm): # Adding index on 'ShortUrl', fields ['short'] db.create_index('tweets_shorturl', ['short']) # Adding index on 'CanonicalUrl', fields ['url'] db.create_index('tweets_canonicalurl', ['url'])
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): # 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): 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 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): # 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 backwards(self, orm): # Adding index on 'PaperSubmission', fields ['slug'] db.create_index(u'papers_papersubmission', ['slug']) # Changing field 'PaperSubmission.slug' db.alter_column(u'papers_papersubmission', 'slug', self.gf('django.db.models.fields.SlugField')(max_length=100))
def backwards(self, orm): # Removing unique constraint on 'Product', fields ['name'] db.delete_unique(u'core_product', ['name']) # Adding index on 'Product', fields ['name'] db.create_index(u'core_product', ['name'])
def forwards(self, orm): # Adding index on 'Tag', fields ['tag'] db.create_index(u'inboxen_tag', ['tag'])
def forwards(self, orm): # Adding model 'MessageServer' db.create_table('server_messageserver', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('text', self.gf('django.db.models.fields.TextField')(null=True, blank=True)), ('date', self.gf('django.db.models.fields.DateTimeField')(blank=True)), )) db.send_create_signal('server', ['MessageServer']) # Adding model 'Migration' db.create_table('server_migration', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('computer', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['server.Computer'])), ('version', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['server.Version'])), ('date', self.gf('django.db.models.fields.DateTimeField')(blank=True)), )) db.send_create_signal('server', ['Migration']) #insert Migrations qry = Update.objects.values('computer', 'version').annotate(date=Min('date')) for q in qry: o_migration = Mig() o_migration.computer_id = q.get('computer') o_migration.version_id = q.get('version') o_migration.date = q.get('date') o_migration.save() # Adding model 'Platform' db.create_table('server_platform', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('name', self.gf('django.db.models.fields.CharField')( max_length=50, unique=True, null=True, blank=True)), )) db.send_create_signal('server', ['Platform']) #insert Platforms o_Platform = Platform() o_Platform.id = 1 o_Platform.name = "Windows" o_Platform.save() o_Platform = Platform() o_Platform.id = 2 o_Platform.name = "Linux" o_Platform.save() # Adding model 'Notification' db.create_table('server_notification', ( ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('date', self.gf('django.db.models.fields.DateTimeField')(blank=True)), ('notification', self.gf('django.db.models.fields.TextField')( null=True, blank=True)), ('checked', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal('server', ['Notification']) # Deleting field 'Property.after_insert' db.delete_column('server_property', 'after_insert') # Deleting field 'Property.before_insert' db.delete_column('server_property', 'before_insert') # Renaming column for 'Version.platform' to match new field type. db.rename_column('server_version', 'platform', 'platform_id') # Changing field 'Version.platform' db.alter_column( 'server_version', 'platform_id', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['server.Platform'])) # Adding index on 'Version', fields ['platform'] db.create_index('server_version', ['platform_id']) # Adding field 'Computer.datehardware' db.add_column( 'server_computer', 'datehardware', self.gf('django.db.models.fields.DateTimeField')(null=True), keep_default=False) # Adding field 'Checking.alert' db.add_column( 'server_checking', 'alert', self.gf('django.db.models.fields.BooleanField')(default=True), keep_default=False) # Changing field 'Update.version' db.alter_column( 'server_update', 'version_id', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['server.Version'], null=True)) # Changing field 'Message.text' db.alter_column( 'server_message', 'text', self.gf('django.db.models.fields.TextField')(null=True)) # Changing field 'UserProfile.version' db.alter_column( 'server_userprofile', 'version_id', self.gf('django.db.models.fields.related.ForeignKey')( to=orm['server.Version'], null=True))
def forwards(self, orm): db.create_index('events_entry', ['slug', 'creation_date'])
def forwards(self, orm): # Adding index on 'ConfirmationCode', fields ['code'] db.create_index('activities_confirmationcode', ['code'])
def forwards(self, orm): # Adding index on 'WorkflowInstanceLogEntry', fields ['datetime'] db.create_index(u'document_states_workflowinstancelogentry', ['datetime'])
def forwards(self, orm): # Adding index on 'Viaggio', fields ['data'] db.create_index('tam_viaggio', ['data'])
def forwards(self, orm): db.create_index('sentry_groupedmessage', ['project_id', 'checksum'])
def forwards(self, orm): # Adding index on 'Course', fields ['number'] db.create_index(u'course_catalog_course', ['number']) # Adding index on 'Subject', fields ['abbreviation'] db.create_index(u'course_catalog_subject', ['abbreviation'])
def forwards(self, orm): # Adding index on 'CustomUser', fields ['is_active'] db.create_index(u'accounts_customuser', ['is_active'])
def backwards(self, orm): # Adding index on 'Feed', fields ['guid'] db.create_index(u'planet_feed', ['guid'])
def forwards(self, orm): # Adding index on 'GroupedMessage', fields ['times_seen'] db.create_index('sentry_groupedmessage', ['times_seen'])
def forwards(self, orm): # Adding index on 'Reading', fields ['user_id'] db.create_index('readings_reading', ['user_id'])
def forwards(self, orm): # Adding index on 'Location', fields ['has_tree'] db.create_index('mapping_location', ['has_tree'])
def forwards(self, orm): if not db.backend_name in ('mysql', 'sqlite'): # Adding index on 'ApiKey', fields ['key'] db.create_index('tastypie_apikey', ['key'])
def forwards(self, orm): # Adding index on 'Comment', fields ['ugq'] db.create_index(u'canvas_comment', ['ugq'])
def forwards(self, orm): db.create_index('teams_task', ['team_id', 'completed'])
def backwards(self, orm): # Adding index on 'HitGroupStatus', fields ['group_id'] db.create_index('main_hitgroupstatus', ['group_id'])
def forwards(self, orm): # Adding index on 'TeamMember', fields ['role'] db.create_index('teams_teammember', ['role'])
def forwards(self, orm): # Adding model 'TagKey' db.create_table(u'tagstore_tagkey', ( ('id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')( primary_key=True)), ('project_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('environment_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( null=True)), ('key', self.gf('django.db.models.fields.CharField')(max_length=32)), ('values_seen', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( default=0)), ('status', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( default=0)), )) db.send_create_signal('tagstore', ['TagKey']) # Adding unique constraint on 'TagKey', fields ['project_id', 'environment_id', 'key'] db.create_unique(u'tagstore_tagkey', ['project_id', 'environment_id', 'key']) # Adding model 'GroupTagValue' db.create_table(u'tagstore_grouptagvalue', ( ('id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')( primary_key=True)), ('project_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('group_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('environment_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( null=True)), ('times_seen', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( default=0)), ('_key', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagKey'], db_column='key_id')), ('_value', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagValue'], db_column='value_id')), ('last_seen', self.gf('django.db.models.fields.DateTimeField')( null=True, db_index=True)), ('first_seen', self.gf('django.db.models.fields.DateTimeField')( null=True, db_index=True)), )) db.send_create_signal('tagstore', ['GroupTagValue']) # Adding unique constraint on 'GroupTagValue', fields ['project_id', # 'group_id', 'environment_id', '_key', '_value'] db.create_unique( u'tagstore_grouptagvalue', ['project_id', 'group_id', 'environment_id', 'key_id', 'value_id']) # Adding index on 'GroupTagValue', fields ['project_id', '_key', '_value', 'last_seen'] db.create_index(u'tagstore_grouptagvalue', ['project_id', 'key_id', 'value_id', 'last_seen']) # Adding model 'GroupTagKey' db.create_table(u'tagstore_grouptagkey', ( ('id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')( primary_key=True)), ('project_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('group_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('environment_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( null=True)), ('_key', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagKey'], db_column='key_id')), ('values_seen', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( default=0)), )) db.send_create_signal('tagstore', ['GroupTagKey']) # Adding unique constraint on 'GroupTagKey', fields ['project_id', # 'group_id', 'environment_id', '_key'] db.create_unique( u'tagstore_grouptagkey', ['project_id', 'group_id', 'environment_id', 'key_id']) # Adding model 'EventTag' db.create_table(u'tagstore_eventtag', ( ('id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')( primary_key=True)), ('project_id', self.gf( 'sentry.db.models.fields.bounded.BoundedPositiveIntegerField') ()), ('environment_id', self.gf( 'sentry.db.models.fields.bounded.BoundedPositiveIntegerField') ()), ('group_id', self.gf( 'sentry.db.models.fields.bounded.BoundedPositiveIntegerField') ()), ('event_id', self.gf( 'sentry.db.models.fields.bounded.BoundedPositiveIntegerField') ()), ('key', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagKey'], db_column='key_id')), ('value', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagValue'], db_column='value_id')), ('date_added', self.gf('django.db.models.fields.DateTimeField')(db_index=True)), )) db.send_create_signal('tagstore', ['EventTag']) # Adding unique constraint on 'EventTag', fields ['event_id', 'key', 'value'] db.create_unique(u'tagstore_eventtag', ['event_id', 'key_id', 'value_id']) # Adding index on 'EventTag', fields ['project_id', 'key', 'value'] db.create_index(u'tagstore_eventtag', ['project_id', 'key_id', 'value_id']) # Adding index on 'EventTag', fields ['group_id', 'key', 'value'] db.create_index(u'tagstore_eventtag', ['group_id', 'key_id', 'value_id']) # Adding index on 'EventTag', fields ['environment_id', 'key', 'value'] db.create_index(u'tagstore_eventtag', ['environment_id', 'key_id', 'value_id']) # Adding model 'TagValue' db.create_table(u'tagstore_tagvalue', ( ('id', self.gf('sentry.db.models.fields.bounded.BoundedBigAutoField')( primary_key=True)), ('project_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( db_index=True)), ('environment_id', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( null=True)), ('_key', self.gf('sentry.db.models.fields.foreignkey.FlexibleForeignKey')( to=orm['tagstore.TagKey'], db_column='key_id')), ('value', self.gf('django.db.models.fields.CharField')(max_length=200)), ('data', self.gf('sentry.db.models.fields.gzippeddict.GzippedDictField')( null=True, blank=True)), ('times_seen', self. gf('sentry.db.models.fields.bounded.BoundedPositiveIntegerField')( default=0)), ('last_seen', self.gf('django.db.models.fields.DateTimeField')( null=True, db_index=True)), ('first_seen', self.gf('django.db.models.fields.DateTimeField')( null=True, db_index=True)), )) db.send_create_signal('tagstore', ['TagValue']) # Adding unique constraint on 'TagValue', fields ['project_id', # 'environment_id', '_key', 'value'] db.create_unique(u'tagstore_tagvalue', ['project_id', 'environment_id', 'key_id', 'value']) # Adding index on 'TagValue', fields ['project_id', '_key', 'last_seen'] db.create_index(u'tagstore_tagvalue', ['project_id', 'key_id', 'last_seen'])
def forwards(self): db.add_column("sa_administrativedomain", "default_pool", DocumentReferenceField("self", null=True, blank=True)) db.create_index("sa_administrativedomain", ["default_pool"], unique=False, db_tablespace="")
def backwards(self, orm): # Changing field 'User.username' db.alter_column('auth_user', 'username', models.CharField(max_length=35)) db.alter_column('auth_user', 'email', models.CharField(max_length=75)) db.create_index('auth_user', ['email'], unique=False)
def forwards(self): db.create_index("ip_address", ["address"], db_tablespace="")
def forwards(self, orm): # Adding index on 'Domain', fields ['name'] db.create_index('dnd_domain', ['name']) # Adding index on 'Feat', fields ['name'] db.create_index('dnd_feat', ['name']) # Adding index on 'DndEdition', fields ['name'] db.create_index('dnd_dndedition', ['name']) # Adding index on 'Spell', fields ['name'] db.create_index('dnd_spell', ['name']) # Adding index on 'CharacterClass', fields ['name'] db.create_index('dnd_characterclass', ['name']) # Adding index on 'Skill', fields ['name'] db.create_index('dnd_skill', ['name']) # Adding index on 'Rulebook', fields ['name'] db.create_index('dnd_rulebook', ['name']) # Adding index on 'SpellDescriptor', fields ['name'] db.create_index('dnd_spelldescriptor', ['name'])
def forwards(self, orm): # Adding index on 'Zipcode', fields ['code'] db.create_index(u'healers_zipcode', ['code']) # Adding index on 'Address', fields ['postal_code'] db.create_index(u'healers_address', ['postal_code'])
def forwards(self, orm): # Adding index on 'Message', fields ['mail_message_id'] db.create_index('paloma_message', ['mail_message_id']) # Adding unique constraint on 'Message', fields ['mail_message_id'] db.create_unique('paloma_message', ['mail_message_id'])
def forwards(self, orm): # Adding Index 'PaymentInfo' db.create_index('gsocial_paymentinfo', ['osuser_id'])
def forwards(self, orm): # Adding index on 'Attachment', fields ['tag'] db.create_index('attachments_attachment', ['tag'])
def forwards(self, orm): # Adding index on 'Post', fields ['thread', 'add_date'] db.create_index(u'forum_post', ['thread_id', 'add_date'])
def forwards(self, orm): # on some systmes this constraint is created. try: db.delete_foreign_key('tko_iteration_result', 'test_idx') except ValueError as e: logging.warning( "Failed to delete foreign key on tko_interation_result, it likely doesn't exist" ) # Removing primary key constraint on tko_iteration_result, allowing more than one keval per test db.delete_primary_key('tko_iteration_result') db.create_index('tko_iteration_result', ['test_idx']) create_perf_view = """ CREATE OR REPLACE VIEW `tko_perf_view` AS SELECT `tko_tests`.`test_idx` AS `test_idx`, `tko_tests`.`job_idx` AS `job_idx`, `tko_tests`.`test` AS `test`, `tko_tests`.`subdir` AS `subdir`, `tko_tests`.`kernel_idx` AS `kernel_idx`, `tko_tests`.`status` AS `status`,`tko_tests`.`reason` AS `reason`, `tko_tests`.`machine_idx` AS `machine_idx`, `tko_tests`.`started_time` AS `test_started_time`, `tko_tests`.`finished_time` AS `test_finished_time`, `tko_jobs`.`tag` AS `job_tag`, `tko_jobs`.`label` AS `job_label`, `tko_jobs`.`username` AS `job_username`, `tko_jobs`.`queued_time` AS `job_queued_time`, `tko_jobs`.`started_time` AS `job_started_time`, `tko_jobs`.`finished_time` AS `job_finished_time`, `tko_machines`.`hostname` AS `machine_hostname`, `tko_machines`.`machine_group` AS `machine_group`, `tko_machines`.`owner` AS `machine_owner`, `tko_kernels`.`kernel_hash` AS `kernel_hash`, `tko_kernels`.`base` AS `kernel_base`, `tko_kernels`.`printable` AS `kernel_printable`, `tko_status`.`word` AS `status_word`, `tko_iteration_result`.`iteration` AS `iteration`, `tko_iteration_result`.`attribute` AS `iteration_key`, `tko_iteration_result`.`value` AS `iteration_value` FROM ( ( ( ( ( `tko_tests` join `tko_jobs` ON ((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) JOIN `tko_machines` ON ((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`)) ) JOIN `tko_kernels` ON ((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`)) ) JOIN `tko_status` on ((`tko_status`.`status_idx` = `tko_tests`.`status`)) ) JOIN `tko_iteration_result` ON ((`tko_iteration_result`.`test_idx` = `tko_tests`.`test_idx`)) ); """ db.execute(create_perf_view) create_perf_view_2 = """ CREATE OR REPLACE VIEW `tko_perf_view_2` AS SELECT `tko_tests`.`test_idx` AS `test_idx`, `tko_tests`.`job_idx` AS `job_idx`, `tko_tests`.`test` AS `test_name`, `tko_tests`.`subdir` AS `subdir`, `tko_tests`.`kernel_idx` AS `kernel_idx`, `tko_tests`.`status` AS `status_idx`, `tko_tests`.`reason` AS `reason`, `tko_tests`.`machine_idx` AS `machine_idx`, `tko_tests`.`started_time` AS `test_started_time`, `tko_tests`.`finished_time` AS `test_finished_time`, `tko_jobs`.`tag` AS `job_tag`, `tko_jobs`.`label` AS `job_name`, `tko_jobs`.`username` AS `job_owner`, `tko_jobs`.`queued_time` AS `job_queued_time`, `tko_jobs`.`started_time` AS `job_started_time`, `tko_jobs`.`finished_time` AS `job_finished_time`, `tko_machines`.`hostname` AS `hostname`, `tko_machines`.`machine_group` AS `platform`, `tko_machines`.`owner` AS `machine_owner`, `tko_kernels`.`kernel_hash` AS `kernel_hash`, `tko_kernels`.`base` AS `kernel_base`, `tko_kernels`.`printable` AS `kernel`, `tko_status`.`word` AS `status`, `tko_iteration_result`.`iteration` AS `iteration`, `tko_iteration_result`.`attribute` AS `iteration_key`, `tko_iteration_result`.`value` AS `iteration_value` FROM ( ( ( ( ( `tko_tests` LEFT JOIN `tko_jobs` ON ((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`)) ) LEFT JOIN `tko_machines` ON ((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`)) ) LEFT JOIN `tko_kernels` ON ((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`)) ) LEFT JOIN `tko_status` ON ((`tko_status`.`status_idx` = `tko_tests`.`status`)) ) LEFT JOIN `tko_iteration_result` ON ((`tko_iteration_result`.`test_idx` = `tko_tests`.`test_idx`)) ) """ db.execute(create_perf_view_2)