----------------------
error - running syncdb
----------------------

OperationalError: (1050, "Table 'memorial_music' already exists")

------
models
------

from django.conf import settings
from django.contrib.auth.models import User, Group
from django.db import models

from photologue.models import Gallery, Photo

import mptt


class Memorial(models.Model):
    background = models.ManyToManyField(Photo)
    description = models.TextField(blank=True, null=True)
    friends = models.BooleanField(blank=True, default=True)
    media_auto = models.BooleanField(blank=True, default=True)
    music = models.ManyToManyField('MemorialMusic')
    music_auto = models.BooleanField(blank=True, default=True)
    music_vol = models.PositiveIntegerField(blank=True, default=100, null=True)
    name = models.CharField(max_length=750, null=True)
    public = models.IntegerField(blank=True, default=1)
    status = models.BooleanField(blank=True, default=True)
    user = models.ManyToManyField(User)
    video = models.IntegerField(blank=True)
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = u'memorial'
        verbose_name = 'Memorial'
        get_latest_by = 'modified'


class MemorialBackgroundCat(models.Model):
    group = models.ForeignKey(Gallery)
    parent = models.ForeignKey('self', null=True, blank=True, related_name='children')
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = u'memorial_background_category'
        verbose_name = 'Memorial Background Category'
        verbose_name_plural = 'Memorial Background Categories'
        get_latest_by = 'modified'

mptt.register(MemorialBackgroundCat)


#Reference for Photos inside of Memorials
class MemorialToPhotos(models.Model):
    memorial = models.ManyToManyField('Memorial')
    media = models.ManyToManyField(Photo)
    order = models.PositiveIntegerField(max_length=11, blank=True)
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = u'memorial_media'
        verbose_name = 'Photo by Memorial'
        verbose_name_plural = 'Photos by Memorial'
        ordering = ['order']
        get_latest_by = 'modified'


def generate_mp3_filename(instance, filename):
    import hashlib, datetime
    now = datetime.datetime.now().isoformat()
    return settings.MUSIC_DIR + hashlib.sha1(now + filename).hexdigest() + '.mp3'

class MemorialMusic(models.Model):
    category = models.ManyToManyField('MemorialMusicCat')
    name = models.CharField(max_length=750, blank=True)
    status = models.BooleanField(blank=True, default=True)
    file = models.FileField(upload_to=generate_mp3_filename)
    file_name = models.CharField(max_length=256)
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = u'memorial_music'
        verbose_name = 'Memorial Music Library'
        verbose_name_plural = 'Memorial Music Libraries'
        get_latest_by = 'modified'


class MemorialMusicCat(models.Model):
    name = models.CharField(max_length=256)
    status = models.BooleanField(blank=True, default=True)
    parent = models.ForeignKey('self', null=True, blank=True, related_name='children')
    created = models.DateTimeField(auto_now_add=True)
    modified = models.DateTimeField(auto_now=True)
    class Meta:
        db_table = u'memorial_music_category'
        verbose_name = 'Memorial Music Category'
        verbose_name_plural = 'Memorial Music Categories'
        get_latest_by = 'modified'

mptt.register(MemorialMusicCat)