pbp_com/apps/catalog/migrations/0001_initial.py

# -*- coding: 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 'Item'
        db.create_table(
            "catalog_item",
            (
                ("id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
                (
                    "created",
                    self.gf("django.db.models.fields.DateTimeField")(
                        auto_now_add=True, blank=True
                    ),
                ),
                (
                    "created_by",
                    self.gf("django.db.models.fields.related.ForeignKey")(
                        related_name="+", to=orm["auth.User"]
                    ),
                ),
                (
                    "last_updated",
                    self.gf("django.db.models.fields.DateTimeField")(
                        auto_now=True, auto_now_add=True, blank=True
                    ),
                ),
                (
                    "last_updated_by",
                    self.gf("django.db.models.fields.related.ForeignKey")(
                        related_name="+", to=orm["auth.User"]
                    ),
                ),
                (
                    "is_active",
                    self.gf("django.db.models.fields.BooleanField")(default=True),
                ),
                ("title", self.gf("django.db.models.fields.CharField")(max_length=50)),
                (
                    "description",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "synopsis",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "image",
                    self.gf("sorl.thumbnail.fields.ImageField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
                (
                    "price",
                    self.gf("django.db.models.fields.DecimalField")(
                        max_digits=7, decimal_places=2
                    ),
                ),
                (
                    "shipping_cost",
                    self.gf("django.db.models.fields.DecimalField")(
                        max_digits=7, decimal_places=2
                    ),
                ),
                (
                    "shipping_cost_multiple",
                    self.gf("django.db.models.fields.DecimalField")(
                        max_digits=7, decimal_places=2
                    ),
                ),
                (
                    "subclass_type",
                    self.gf("django.db.models.fields.CharField")(max_length=200),
                ),
                (
                    "sku",
                    self.gf("django.db.models.fields.SlugField")(
                        unique=True, max_length=20
                    ),
                ),
                (
                    "deleted",
                    self.gf("django.db.models.fields.BooleanField")(default=False),
                ),
                (
                    "featured",
                    self.gf("django.db.models.fields.BooleanField")(default=False),
                ),
                (
                    "tax_free",
                    self.gf("django.db.models.fields.BooleanField")(default=False),
                ),
            ),
        )
        db.send_create_signal("catalog", ["Item"])

        # Adding model 'Book'
        db.create_table(
            "catalog_book",
            (
                (
                    "item_ptr",
                    self.gf("django.db.models.fields.related.OneToOneField")(
                        to=orm["catalog.Item"], unique=True, primary_key=True
                    ),
                ),
                (
                    "short_description",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
                (
                    "authors",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "illustrator",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "publisher",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "printer",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "publish_date",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "edition",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=50, null=True, blank=True
                    ),
                ),
                (
                    "features",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
                (
                    "dimensions",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "pages",
                    self.gf("django.db.models.fields.IntegerField")(
                        null=True, blank=True
                    ),
                ),
                (
                    "isbn",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "library_of_congress_number",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "genre",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
                (
                    "author_image",
                    self.gf("sorl.thumbnail.fields.ImageField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
            ),
        )
        db.send_create_signal("catalog", ["Book"])

        # Adding model 'Movie'
        db.create_table(
            "catalog_movie",
            (
                (
                    "item_ptr",
                    self.gf("django.db.models.fields.related.OneToOneField")(
                        to=orm["catalog.Item"], unique=True, primary_key=True
                    ),
                ),
                (
                    "producer",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "music",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=200, null=True, blank=True
                    ),
                ),
                (
                    "runtime_minutes",
                    self.gf("django.db.models.fields.IntegerField")(
                        null=True, blank=True
                    ),
                ),
                (
                    "format",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "region",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=50, null=True, blank=True
                    ),
                ),
                (
                    "sound",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=50, null=True, blank=True
                    ),
                ),
                (
                    "language",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=50, null=True, blank=True
                    ),
                ),
                (
                    "captioning",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=50, null=True, blank=True
                    ),
                ),
                (
                    "genre",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
            ),
        )
        db.send_create_signal("catalog", ["Movie"])

        # Adding model 'Map'
        db.create_table(
            "catalog_map",
            (
                (
                    "item_ptr",
                    self.gf("django.db.models.fields.related.OneToOneField")(
                        to=orm["catalog.Item"], unique=True, primary_key=True
                    ),
                ),
                (
                    "dimensions",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=20, null=True, blank=True
                    ),
                ),
                (
                    "full_image",
                    self.gf("sorl.thumbnail.fields.ImageField")(
                        max_length=100, null=True, blank=True
                    ),
                ),
            ),
        )
        db.send_create_signal("catalog", ["Map"])

        # Adding model 'Subscription'
        db.create_table(
            "catalog_subscription",
            (
                (
                    "item_ptr",
                    self.gf("django.db.models.fields.related.OneToOneField")(
                        to=orm["catalog.Item"], unique=True, primary_key=True
                    ),
                ),
                (
                    "shipping_type",
                    self.gf("django.db.models.fields.CharField")(
                        default="INSTATE", max_length=10
                    ),
                ),
                (
                    "shipping_method",
                    self.gf("django.db.models.fields.CharField")(
                        default=u"REGULAR", max_length=20
                    ),
                ),
                ("duration", self.gf("django.db.models.fields.IntegerField")()),
            ),
        )
        db.send_create_signal("catalog", ["Subscription"])

        # Adding model 'ZipCode'
        db.create_table(
            "catalog_zipcode",
            (
                ("id", self.gf("django.db.models.fields.AutoField")(primary_key=True)),
                (
                    "created",
                    self.gf("django.db.models.fields.DateTimeField")(
                        auto_now_add=True, blank=True
                    ),
                ),
                (
                    "created_by",
                    self.gf("django.db.models.fields.related.ForeignKey")(
                        related_name="+", to=orm["auth.User"]
                    ),
                ),
                (
                    "last_updated",
                    self.gf("django.db.models.fields.DateTimeField")(
                        auto_now=True, auto_now_add=True, blank=True
                    ),
                ),
                (
                    "last_updated_by",
                    self.gf("django.db.models.fields.related.ForeignKey")(
                        related_name="+", to=orm["auth.User"]
                    ),
                ),
                (
                    "is_active",
                    self.gf("django.db.models.fields.BooleanField")(default=True),
                ),
                (
                    "zipcode",
                    self.gf("django.db.models.fields.CharField")(
                        unique=True, max_length=9
                    ),
                ),
                (
                    "city",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=64, null=True, blank=True
                    ),
                ),
                (
                    "state",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=2, null=True, blank=True
                    ),
                ),
                (
                    "county",
                    self.gf("django.db.models.fields.CharField")(
                        max_length=64, null=True, blank=True
                    ),
                ),
                (
                    "deleted",
                    self.gf("django.db.models.fields.BooleanField")(default=False),
                ),
            ),
        )
        db.send_create_signal("catalog", ["ZipCode"])

    def backwards(self, orm):
        # Deleting model 'Item'
        db.delete_table("catalog_item")

        # Deleting model 'Book'
        db.delete_table("catalog_book")

        # Deleting model 'Movie'
        db.delete_table("catalog_movie")

        # Deleting model 'Map'
        db.delete_table("catalog_map")

        # Deleting model 'Subscription'
        db.delete_table("catalog_subscription")

        # Deleting model 'ZipCode'
        db.delete_table("catalog_zipcode")

    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.now"},
            ),
            "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.now"},
            ),
            "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"},
            ),
        },
        "catalog.book": {
            "Meta": {"object_name": "Book", "_ormbases": ["catalog.Item"]},
            "author_image": (
                "sorl.thumbnail.fields.ImageField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "authors": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "dimensions": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "edition": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "50", "null": "True", "blank": "True"},
            ),
            "features": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "genre": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "illustrator": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "isbn": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "item_ptr": (
                "django.db.models.fields.related.OneToOneField",
                [],
                {"to": "orm['catalog.Item']", "unique": "True", "primary_key": "True"},
            ),
            "library_of_congress_number": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "pages": (
                "django.db.models.fields.IntegerField",
                [],
                {"null": "True", "blank": "True"},
            ),
            "printer": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "publish_date": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "publisher": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "short_description": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
        },
        "catalog.item": {
            "Meta": {"object_name": "Item"},
            "created": (
                "django.db.models.fields.DateTimeField",
                [],
                {"auto_now_add": "True", "blank": "True"},
            ),
            "created_by": (
                "django.db.models.fields.related.ForeignKey",
                [],
                {"related_name": "'+'", "to": "orm['auth.User']"},
            ),
            "deleted": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "False"},
            ),
            "description": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "featured": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "False"},
            ),
            "id": ("django.db.models.fields.AutoField", [], {"primary_key": "True"}),
            "image": (
                "sorl.thumbnail.fields.ImageField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "is_active": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "True"},
            ),
            "last_updated": (
                "django.db.models.fields.DateTimeField",
                [],
                {"auto_now": "True", "auto_now_add": "True", "blank": "True"},
            ),
            "last_updated_by": (
                "django.db.models.fields.related.ForeignKey",
                [],
                {"related_name": "'+'", "to": "orm['auth.User']"},
            ),
            "price": (
                "django.db.models.fields.DecimalField",
                [],
                {"max_digits": "7", "decimal_places": "2"},
            ),
            "shipping_cost": (
                "django.db.models.fields.DecimalField",
                [],
                {"max_digits": "7", "decimal_places": "2"},
            ),
            "shipping_cost_multiple": (
                "django.db.models.fields.DecimalField",
                [],
                {"max_digits": "7", "decimal_places": "2"},
            ),
            "sku": (
                "django.db.models.fields.SlugField",
                [],
                {"unique": "True", "max_length": "20"},
            ),
            "subclass_type": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200"},
            ),
            "synopsis": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "tax_free": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "False"},
            ),
            "title": ("django.db.models.fields.CharField", [], {"max_length": "50"}),
        },
        "catalog.map": {
            "Meta": {"object_name": "Map", "_ormbases": ["catalog.Item"]},
            "dimensions": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "full_image": (
                "sorl.thumbnail.fields.ImageField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "item_ptr": (
                "django.db.models.fields.related.OneToOneField",
                [],
                {"to": "orm['catalog.Item']", "unique": "True", "primary_key": "True"},
            ),
        },
        "catalog.movie": {
            "Meta": {"object_name": "Movie", "_ormbases": ["catalog.Item"]},
            "captioning": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "50", "null": "True", "blank": "True"},
            ),
            "format": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "20", "null": "True", "blank": "True"},
            ),
            "genre": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "100", "null": "True", "blank": "True"},
            ),
            "item_ptr": (
                "django.db.models.fields.related.OneToOneField",
                [],
                {"to": "orm['catalog.Item']", "unique": "True", "primary_key": "True"},
            ),
            "language": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "50", "null": "True", "blank": "True"},
            ),
            "music": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "producer": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "200", "null": "True", "blank": "True"},
            ),
            "region": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "50", "null": "True", "blank": "True"},
            ),
            "runtime_minutes": (
                "django.db.models.fields.IntegerField",
                [],
                {"null": "True", "blank": "True"},
            ),
            "sound": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "50", "null": "True", "blank": "True"},
            ),
        },
        "catalog.subscription": {
            "Meta": {"object_name": "Subscription", "_ormbases": ["catalog.Item"]},
            "duration": ("django.db.models.fields.IntegerField", [], {}),
            "item_ptr": (
                "django.db.models.fields.related.OneToOneField",
                [],
                {"to": "orm['catalog.Item']", "unique": "True", "primary_key": "True"},
            ),
            "shipping_method": (
                "django.db.models.fields.CharField",
                [],
                {"default": "u'REGULAR'", "max_length": "20"},
            ),
            "shipping_type": (
                "django.db.models.fields.CharField",
                [],
                {"default": "'INSTATE'", "max_length": "10"},
            ),
        },
        "catalog.zipcode": {
            "Meta": {"object_name": "ZipCode"},
            "city": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "64", "null": "True", "blank": "True"},
            ),
            "county": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "64", "null": "True", "blank": "True"},
            ),
            "created": (
                "django.db.models.fields.DateTimeField",
                [],
                {"auto_now_add": "True", "blank": "True"},
            ),
            "created_by": (
                "django.db.models.fields.related.ForeignKey",
                [],
                {"related_name": "'+'", "to": "orm['auth.User']"},
            ),
            "deleted": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "False"},
            ),
            "id": ("django.db.models.fields.AutoField", [], {"primary_key": "True"}),
            "is_active": (
                "django.db.models.fields.BooleanField",
                [],
                {"default": "True"},
            ),
            "last_updated": (
                "django.db.models.fields.DateTimeField",
                [],
                {"auto_now": "True", "auto_now_add": "True", "blank": "True"},
            ),
            "last_updated_by": (
                "django.db.models.fields.related.ForeignKey",
                [],
                {"related_name": "'+'", "to": "orm['auth.User']"},
            ),
            "state": (
                "django.db.models.fields.CharField",
                [],
                {"max_length": "2", "null": "True", "blank": "True"},
            ),
            "zipcode": (
                "django.db.models.fields.CharField",
                [],
                {"unique": "True", "max_length": "9"},
            ),
        },
        "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"}),
        },
    }

    complete_apps = ["catalog"]