text: # encoding: utf-8
  import datetime
  from south.db import db
  from south.v2 import SchemaMigration
  from django.db import models
  
  class Migration(SchemaMigration):
      depends_on = (
          ('catalogue', '0001_initial'),
          ('order', '0001_initial'),
      )
  
      def forwards(self, orm):
          
          # Adding model 'ConditionalOffer'
          db.create_table('offer_conditionaloffer', (
              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
              ('name', self.gf('django.db.models.fields.CharField')(max_length=128)),
              ('description', self.gf('django.db.models.fields.TextField')(null=True, blank=True)),
              ('offer_type', self.gf('django.db.models.fields.CharField')(default='Site', max_length=128)),
              ('condition', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['offer.Condition'])),
              ('benefit', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['offer.Benefit'])),
              ('start_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
              ('end_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)),
              ('priority', self.gf('django.db.models.fields.IntegerField')(default=0)),
              ('total_discount', self.gf('django.db.models.fields.DecimalField')(default='0.00', max_digits=12, decimal_places=2)),
              ('date_created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
              ('redirect_url', self.gf('oscar.models.fields.ExtendedURLField')(max_length=200, blank=True)),
          ))
          db.send_create_signal('offer', ['ConditionalOffer'])
  
          # Adding model 'Condition'
          db.create_table('offer_condition', (
              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
              ('range', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['offer.Range'])),
              ('type', self.gf('django.db.models.fields.CharField')(max_length=128)),
              ('value', self.gf('oscar.models.fields.PositiveDecimalField')(max_digits=12, decimal_places=2)),
          ))
          db.send_create_signal('offer', ['Condition'])
  
          # Adding model 'Benefit'
          db.create_table('offer_benefit', (
              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
              ('range', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['offer.Range'], null=True, blank=True)),
              ('type', self.gf('django.db.models.fields.CharField')(max_length=128)),
              ('value', self.gf('oscar.models.fields.PositiveDecimalField')(null=True, max_digits=12, decimal_places=2, blank=True)),
              ('max_affected_items', self.gf('django.db.models.fields.PositiveIntegerField')(null=True, blank=True)),
          ))
          db.send_create_signal('offer', ['Benefit'])
  
          # Adding model 'Range'
          db.create_table('offer_range', (
              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
              ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=128)),
              ('includes_all_products', self.gf('django.db.models.fields.BooleanField')(default=False)),
          ))
          db.send_create_signal('offer', ['Range'])
  
          # Adding M2M table for field included_products on 'Range'
          db.create_table('offer_range_included_products', (
              ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
              ('range', models.ForeignKey(orm['offer.range'], null=False)),
              ('product', models.ForeignKey(orm['catalogue.product'], null=False))
          ))
          db.create_unique('offer_range_included_products', ['range_id', 'product_id'])
  
          # Adding M2M table for field excluded_products on 'Range'
          db.create_table('offer_range_excluded_products', (
              ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
              ('range', models.ForeignKey(orm['offer.range'], null=False)),
              ('product', models.ForeignKey(orm['catalogue.product'], null=False))
          ))
          db.create_unique('offer_range_excluded_products', ['range_id', 'product_id'])
  
          # Adding M2M table for field classes on 'Range'
          db.create_table('offer_range_classes', (
              ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
              ('range', models.ForeignKey(orm['offer.range'], null=False)),
              ('productclass', models.ForeignKey(orm['catalogue.productclass'], null=False))
          ))
          db.create_unique('offer_range_classes', ['range_id', 'productclass_id'])
  
          # Adding M2M table for field included_categories on 'Range'
          db.create_table('offer_range_included_categories', (
              ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
              ('range', models.ForeignKey(orm['offer.range'], null=False)),
              ('category', models.ForeignKey(orm['catalogue.category'], null=False))
          ))
          db.create_unique('offer_range_included_categories', ['range_id', 'category_id'])
  
  
      def backwards(self, orm):
          
          # Deleting model 'ConditionalOffer'
          db.delete_table('offer_conditionaloffer')
  
          # Deleting model 'Condition'
          db.delete_table('offer_condition')
  
          # Deleting model 'Benefit'
          db.delete_table('offer_benefit')
  
          # Deleting model 'Range'
          db.delete_table('offer_range')
  
          # Removing M2M table for field included_products on 'Range'
          db.delete_table('offer_range_included_products')
  
          # Removing M2M table for field excluded_products on 'Range'
          db.delete_table('offer_range_excluded_products')
  
          # Removing M2M table for field classes on 'Range'
          db.delete_table('offer_range_classes')
  
          # Removing M2M table for field included_categories on 'Range'
          db.delete_table('offer_range_included_categories')
  
  
      models = {
          'catalogue.attributeentity': {
              'Meta': {'object_name': 'AttributeEntity'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '255', 'blank': 'True'}),
              'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'entities'", 'to': "orm['catalogue.AttributeEntityType']"})
          },
          'catalogue.attributeentitytype': {
              'Meta': {'object_name': 'AttributeEntityType'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '255', 'blank': 'True'})
          },
          'catalogue.attributeoption': {
              'Meta': {'object_name': 'AttributeOption'},
              'group': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'options'", 'to': "orm['catalogue.AttributeOptionGroup']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'option': ('django.db.models.fields.CharField', [], {'max_length': '255'})
          },
          'catalogue.attributeoptiongroup': {
              'Meta': {'object_name': 'AttributeOptionGroup'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '128'})
          },
          'catalogue.category': {
              'Meta': {'ordering': "['name']", 'object_name': 'Category'},
              'depth': ('django.db.models.fields.PositiveIntegerField', [], {}),
              'full_name': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'db_index': 'True'}),
              'numchild': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
              'path': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
              'slug': ('django.db.models.fields.SlugField', [], {'max_length': '1024', 'db_index': 'True'})
          },
          'catalogue.option': {
              'Meta': {'object_name': 'Option'},
              'code': ('django.db.models.fields.SlugField', [], {'max_length': '128', 'db_index': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'type': ('django.db.models.fields.CharField', [], {'default': "'Required'", 'max_length': '128'})
          },
          'catalogue.product': {
              'Meta': {'ordering': "['-date_created']", 'object_name': 'Product'},
              'attributes': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['catalogue.ProductAttribute']", 'through': "orm['catalogue.ProductAttributeValue']", 'symmetrical': 'False'}),
              'categories': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['catalogue.Category']", 'through': "orm['catalogue.ProductCategory']", 'symmetrical': 'False'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'db_index': 'True', 'blank': 'True'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'parent': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'variants'", 'null': 'True', 'to': "orm['catalogue.Product']"}),
              'product_class': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.ProductClass']", 'null': 'True'}),
              'product_options': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['catalogue.Option']", 'symmetrical': 'False', 'blank': 'True'}),
              'recommended_products': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['catalogue.Product']", 'symmetrical': 'False', 'through': "orm['catalogue.ProductRecommendation']", 'blank': 'True'}),
              'related_products': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'relations'", 'blank': 'True', 'to': "orm['catalogue.Product']"}),
              'score': ('django.db.models.fields.FloatField', [], {'default': '0.0', 'db_index': 'True'}),
              'slug': ('django.db.models.fields.SlugField', [], {'max_length': '255', 'db_index': 'True'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
              'upc': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '64', 'null': 'True', 'blank': 'True'})
          },
          'catalogue.productattribute': {
              'Meta': {'ordering': "['code']", 'object_name': 'ProductAttribute'},
              'code': ('django.db.models.fields.SlugField', [], {'max_length': '128', 'db_index': 'True'}),
              'entity_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.AttributeEntityType']", 'null': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'option_group': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.AttributeOptionGroup']", 'null': 'True', 'blank': 'True'}),
              'product_class': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'attributes'", 'null': 'True', 'to': "orm['catalogue.ProductClass']"}),
              'required': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'type': ('django.db.models.fields.CharField', [], {'default': "'text'", 'max_length': '20'})
          },
          'catalogue.productattributevalue': {
              'Meta': {'object_name': 'ProductAttributeValue'},
              'attribute': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.ProductAttribute']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'product': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Product']"}),
              'value_boolean': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'value_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
              'value_entity': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.AttributeEntity']", 'null': 'True', 'blank': 'True'}),
              'value_float': ('django.db.models.fields.FloatField', [], {'null': 'True', 'blank': 'True'}),
              'value_integer': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
              'value_option': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.AttributeOption']", 'null': 'True', 'blank': 'True'}),
              'value_richtext': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'value_text': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'})
          },
          'catalogue.productcategory': {
              'Meta': {'ordering': "['-is_canonical']", 'object_name': 'ProductCategory'},
              'category': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Category']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'is_canonical': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
              'product': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Product']"})
          },
          'catalogue.productclass': {
              'Meta': {'ordering': "['name']", 'object_name': 'ProductClass'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'options': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['catalogue.Option']", 'symmetrical': 'False', 'blank': 'True'}),
              'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '128', 'db_index': 'True'})
          },
          'catalogue.productrecommendation': {
              'Meta': {'object_name': 'ProductRecommendation'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'primary': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'primary_recommendations'", 'to': "orm['catalogue.Product']"}),
              'ranking': ('django.db.models.fields.PositiveSmallIntegerField', [], {'default': '0'}),
              'recommendation': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Product']"})
          },
          'offer.benefit': {
              'Meta': {'object_name': 'Benefit'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'max_affected_items': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True', 'blank': 'True'}),
              'range': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['offer.Range']", 'null': 'True', 'blank': 'True'}),
              'type': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'value': ('oscar.models.fields.PositiveDecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'})
          },
          'offer.condition': {
              'Meta': {'object_name': 'Condition'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'range': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['offer.Range']"}),
              'type': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'value': ('oscar.models.fields.PositiveDecimalField', [], {'max_digits': '12', 'decimal_places': '2'})
          },
          'offer.conditionaloffer': {
              'Meta': {'ordering': "['-priority']", 'object_name': 'ConditionalOffer'},
              'benefit': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['offer.Benefit']"}),
              'condition': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['offer.Condition']"}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'offer_type': ('django.db.models.fields.CharField', [], {'default': "'Site'", 'max_length': '128'}),
              'priority': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
              'redirect_url': ('oscar.models.fields.ExtendedURLField', [], {'max_length': '200', 'blank': 'True'}),
              'start_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
              'total_discount': ('django.db.models.fields.DecimalField', [], {'default': "'0.00'", 'max_digits': '12', 'decimal_places': '2'})
          },
          'offer.range': {
              'Meta': {'object_name': 'Range'},
              'classes': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'classes'", 'blank': 'True', 'to': "orm['catalogue.ProductClass']"}),
              'excluded_products': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'excludes'", 'blank': 'True', 'to': "orm['catalogue.Product']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'included_categories': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'includes'", 'blank': 'True', 'to': "orm['catalogue.Category']"}),
              'included_products': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'includes'", 'blank': 'True', 'to': "orm['catalogue.Product']"}),
              'includes_all_products': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
          }
      }
  
      complete_apps = ['offer']
  