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)
