# -*- 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 'SetListSongOrder'
        db.create_table('django_tours_setlistsongorder', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('song', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_discography.Song'])),
            ('concert', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_tours.Concert'])),
            ('track_number', self.gf('django.db.models.fields.IntegerField')()),
        ))
        db.send_create_signal('django_tours', ['SetListSongOrder'])

        # Adding model 'SupportingAct'
        db.create_table('django_tours_supportingact', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('act', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_discography.Band'])),
            ('start_time', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)),
            ('concert', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_tours.Concert'])),
        ))
        db.send_create_signal('django_tours', ['SupportingAct'])

        # Adding model 'Concert'
        db.create_table('django_tours_concert', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('tour', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_tours.Tour'])),
            ('venue', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['django_tours.Venue'])),
            ('date', self.gf('django.db.models.fields.DateTimeField')()),
            ('sold_out', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('on_sale_date', self.gf('django.db.models.fields.DateTimeField')(null=True, blank=True)),
            ('doors_open_time', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)),
            ('doors_open_text', self.gf('django.db.models.fields.CharField')(max_length=20, null=True, blank=True)),
            ('set_time', self.gf('django.db.models.fields.TimeField')(null=True, blank=True)),
            ('digital_ticket_url', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)),
            ('show_policy_link', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('policy_link_text', self.gf('django.db.models.fields.CharField')(max_length=25, blank=True)),
            ('policy_link_url', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)),
            ('notes', self.gf('django.db.models.fields.TextField')(blank=True)),
            ('published', self.gf('django.db.models.fields.BooleanField')(default=True)),
            ('slug', self.gf('django.db.models.fields.SlugField')(max_length=50, blank=True)),
        ))
        db.send_create_signal('django_tours', ['Concert'])

        # Adding model 'Tour'
        db.create_table('django_tours_tour', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=50)),
            ('is_current', self.gf('django.db.models.fields.BooleanField')(default=False)),
            ('start_date', self.gf('django.db.models.fields.DateField')()),
            ('end_date', self.gf('django.db.models.fields.DateField')()),
        ))
        db.send_create_signal('django_tours', ['Tour'])

        # Adding model 'Venue'
        db.create_table('django_tours_venue', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('name', self.gf('django.db.models.fields.CharField')(max_length=50)),
            ('country', self.gf('django_countries.fields.CountryField')(max_length=2)),
            ('city', self.gf('django.db.models.fields.CharField')(max_length=50)),
            ('state_or_province', self.gf('django.db.models.fields.CharField')(max_length=100)),
            ('address_1', self.gf('django.db.models.fields.CharField')(max_length=100)),
            ('address_2', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)),
            ('postal_code', self.gf('django.db.models.fields.CharField')(max_length=6)),
            ('url', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)),
            ('longitude', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=11, decimal_places=6, blank=True)),
            ('latitude', self.gf('django.db.models.fields.DecimalField')(null=True, max_digits=11, decimal_places=6, blank=True)),
        ))
        db.send_create_signal('django_tours', ['Venue'])


    def backwards(self, orm):
        # Deleting model 'SetListSongOrder'
        db.delete_table('django_tours_setlistsongorder')

        # Deleting model 'SupportingAct'
        db.delete_table('django_tours_supportingact')

        # Deleting model 'Concert'
        db.delete_table('django_tours_concert')

        # Deleting model 'Tour'
        db.delete_table('django_tours_tour')

        # Deleting model 'Venue'
        db.delete_table('django_tours_venue')


    models = {
        'django_discography.band': {
            'Meta': {'object_name': 'Band'},
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'members': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'bands'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['django_discography.Musician']"}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
            'url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'})
        },
        'django_discography.instrument': {
            'Meta': {'object_name': 'Instrument'},
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
        },
        'django_discography.musician': {
            'Meta': {'object_name': 'Musician'},
            'first_name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'instruments': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'musicians'", 'null': 'True', 'symmetrical': 'False', 'to': "orm['django_discography.Instrument']"}),
            'last_name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
        },
        'django_discography.song': {
            'Meta': {'object_name': 'Song'},
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'length': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
            'writers': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'songs'", 'symmetrical': 'False', 'to': "orm['django_discography.Musician']"})
        },
        'django_tours.concert': {
            'Meta': {'object_name': 'Concert'},
            'date': ('django.db.models.fields.DateTimeField', [], {}),
            'digital_ticket_url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'}),
            'doors_open_text': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
            'doors_open_time': ('django.db.models.fields.TimeField', [], {'null': 'True', 'blank': 'True'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
            'on_sale_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
            'policy_link_text': ('django.db.models.fields.CharField', [], {'max_length': '25', 'blank': 'True'}),
            'policy_link_url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'}),
            'published': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
            'set_time': ('django.db.models.fields.TimeField', [], {'null': 'True', 'blank': 'True'}),
            'show_policy_link': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
            'slug': ('django.db.models.fields.SlugField', [], {'max_length': '50', 'blank': 'True'}),
            'sold_out': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
            'songs': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'concerts'", 'symmetrical': 'False', 'through': "orm['django_tours.SetListSongOrder']", 'to': "orm['django_discography.Song']"}),
            'tour': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_tours.Tour']"}),
            'venue': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_tours.Venue']"})
        },
        'django_tours.setlistsongorder': {
            'Meta': {'object_name': 'SetListSongOrder'},
            'concert': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_tours.Concert']"}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'song': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_discography.Song']"}),
            'track_number': ('django.db.models.fields.IntegerField', [], {})
        },
        'django_tours.supportingact': {
            'Meta': {'object_name': 'SupportingAct'},
            'act': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_discography.Band']"}),
            'concert': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['django_tours.Concert']"}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'start_time': ('django.db.models.fields.TimeField', [], {'null': 'True', 'blank': 'True'})
        },
        'django_tours.tour': {
            'Meta': {'object_name': 'Tour'},
            'concerts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'tours'", 'symmetrical': 'False', 'through': "orm['django_tours.Concert']", 'to': "orm['django_tours.Venue']"}),
            'end_date': ('django.db.models.fields.DateField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'is_current': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
            'start_date': ('django.db.models.fields.DateField', [], {})
        },
        'django_tours.venue': {
            'Meta': {'object_name': 'Venue'},
            'address_1': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
            'address_2': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
            'city': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
            'country': ('django_countries.fields.CountryField', [], {'max_length': '2'}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'latitude': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '11', 'decimal_places': '6', 'blank': 'True'}),
            'longitude': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '11', 'decimal_places': '6', 'blank': 'True'}),
            'name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
            'postal_code': ('django.db.models.fields.CharField', [], {'max_length': '6'}),
            'state_or_province': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
            'url': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'})
        }
    }

    complete_apps = ['django_tours']