text: # encoding: utf-8
  import datetime
  from south.db import db
  from south.v2 import SchemaMigration
  from django.db import models
  
  class Migration(SchemaMigration):
  
      def forwards(self, orm):
  
          # Adding model 'ProductAlert'
          db.create_table('customer_productalert', (
              ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
              ('product', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['catalogue.Product'])),
              ('user', self.gf('django.db.models.fields.related.ForeignKey')(blank=True, related_name='alerts', null=True, to=orm['auth.User'])),
              ('email', self.gf('django.db.models.fields.EmailField')(db_index=True, max_length=75, null=True, blank=True)),
              ('key', self.gf('django.db.models.fields.CharField')(max_length=128, null=True, db_index=True)),
              ('status', self.gf('django.db.models.fields.CharField')(default='Active', max_length=20)),
              ('date_created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
              ('date_confirmed', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
              ('date_cancelled', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
              ('date_closed', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
          ))
          db.send_create_signal('customer', ['ProductAlert'])
  
  
      def backwards(self, orm):
  
          # Deleting model 'ProductAlert'
          db.delete_table('customer_productalert')
  
  
      models = {
          'auth.group': {
              'Meta': {'object_name': 'Group'},
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
              'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
          },
          'auth.permission': {
              'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
              'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
          },
          'auth.user': {
              'Meta': {'object_name': 'User'},
              'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2012, 9, 26, 13, 49, 39, 401244)'}),
              'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
              'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
              'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
              'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
              'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(2012, 9, 26, 13, 49, 39, 401151)'}),
              'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
              'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
              'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
              'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
          },
          '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': "['full_name']", 'object_name': 'Category'},
              'depth': ('django.db.models.fields.PositiveIntegerField', [], {}),
              'description': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'full_name': ('django.db.models.fields.CharField', [], {'max_length': '1024', 'db_index': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'image': ('django.db.models.fields.files.ImageField', [], {'max_length': '100', 'null': 'True', 'blank': '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', [], {'unique': 'True', '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'}),
              'is_discountable': ('django.db.models.fields.BooleanField', [], {'default': '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'}),
              'status': ('django.db.models.fields.CharField', [], {'db_index': 'True', 'max_length': '128', 'null': 'True', 'blank': 'True'}),
              'title': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
              'upc': ('django.db.models.fields.CharField', [], {'max_length': '64', 'unique': 'True', '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', [], {'related_name': "'attribute_values'", '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'}),
              'requires_shipping': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
              'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '128', 'db_index': 'True'}),
              'track_stock': ('django.db.models.fields.BooleanField', [], {'default': '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']"})
          },
          'contenttypes.contenttype': {
              'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
              'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
          },
          'customer.communicationeventtype': {
              'Meta': {'object_name': 'CommunicationEventType'},
              'category': ('django.db.models.fields.CharField', [], {'default': "u'Order related'", 'max_length': '255'}),
              'code': ('django.db.models.fields.SlugField', [], {'max_length': '128', 'db_index': 'True'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'date_updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
              'email_body_html_template': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'email_body_template': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'email_subject_template': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
              'sms_template': ('django.db.models.fields.CharField', [], {'max_length': '170', 'blank': 'True'})
          },
          'customer.email': {
              'Meta': {'object_name': 'Email'},
              'body_html': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
              'body_text': ('django.db.models.fields.TextField', [], {}),
              'date_sent': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'subject': ('django.db.models.fields.TextField', [], {'max_length': '255'}),
              'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'emails'", 'to': "orm['auth.User']"})
          },
          'customer.notification': {
              'Meta': {'ordering': "('-date_sent',)", 'object_name': 'Notification'},
              'body': ('django.db.models.fields.TextField', [], {}),
              'category': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
              'date_read': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
              'date_sent': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'location': ('django.db.models.fields.CharField', [], {'default': "'Inbox'", 'max_length': '32'}),
              'recipient': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'notifications'", 'to': "orm['auth.User']"}),
              'sender': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'null': 'True'}),
              'subject': ('django.db.models.fields.CharField', [], {'max_length': '255'})
          },
          'customer.productalert': {
              'Meta': {'object_name': 'ProductAlert'},
              'date_cancelled': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              'date_closed': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              'date_confirmed': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
              'date_created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
              'email': ('django.db.models.fields.EmailField', [], {'db_index': 'True', 'max_length': '75', 'null': 'True', 'blank': 'True'}),
              'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
              'key': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'db_index': 'True'}),
              'product': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['catalogue.Product']"}),
              'status': ('django.db.models.fields.CharField', [], {'default': "'Active'", 'max_length': '20'}),
              'user': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'alerts'", 'null': 'True', 'to': "orm['auth.User']"})
          }
      }
  
      complete_apps = ['customer']
  