# -*- coding: utf8 -*-
## File autogenerated by SQLAutoCode
## see http://code.google.com/p/sqlautocode/

from sqlalchemy import *
from sqlalchemy.databases.sqlite import *

metadata = MetaData()


aura =  Table('aura', metadata,
    Column(u'id', SLInteger(), primary_key=1),
            Column(u'start_event_id', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'null'), for_update=False)),
            Column(u'end_event_id', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'null'), for_update=False)),
            Column(u'combat_id', SLInteger(), primary_key=0),
            Column(u'spellName', NullType(), primary_key=0),
            Column(u'destType', NullType(), primary_key=0),
            Column(u'destName', NullType(), primary_key=0),
            Column(u'spellId', NullType(), primary_key=0),
            Column(u'sourceType', NullType(), primary_key=0),
            Column(u'sourceName', NullType(), primary_key=0),
    
    
    )


combat =  Table('combat', metadata,
    Column(u'id', SLInteger(), primary_key=1),
            Column(u'start_event_id', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'close_event_id', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'end_event_id', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'size', SLInteger(), primary_key=0),
            Column(u'instance', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'encounter', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'dps_list', NullType(), primary_key=0),
            Column(u'healer_list', NullType(), primary_key=0),
            Column(u'tank_list', NullType(), primary_key=0),
            Column(u'stasis_path', NullType(), primary_key=0),
    
    
    )


event =  Table('event', metadata,
    Column(u'id', SLInteger(), primary_key=1),
            Column(u'path', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'time', SLDateTime(timezone=False), primary_key=0),
            Column(u'eventType', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'prefix', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'suffix', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceType', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceController', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceReaction', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destType', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destController', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destReaction', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceGUID', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceName', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'sourceFlags', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destGUID', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destName', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'destFlags', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'spellId', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'spellName', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'spellSchool', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'environmental', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'itemID', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'itemName', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'amount', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'extra', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'school', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'resisted', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'blocked', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'absorbed', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'critical', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'glancing', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'crushing', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'miss', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'power', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'extraSpellID', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'extraSpellName', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'extraSchool', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'aura', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'failed', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'fakeDeath', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'combat_id', SLInteger(), primary_key=0),
            Column(u'absorbType', NullType(), primary_key=0),
            Column(u'absorbName', NullType(), primary_key=0),
            Column(u'wipe', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
    
    
    )


run =  Table('run', metadata,
    Column(u'id', SLInteger(), primary_key=1),
            Column(u'time', SLDateTime(timezone=False), primary_key=0),
            Column(u'mostRecent', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'version', SLString(length=None, convert_unicode=False, assert_unicode=None), primary_key=0),
            Column(u'name', NullType(), primary_key=0),
    
    
    )


wound =  Table('wound', metadata,
    Column(u'id', SLInteger(), primary_key=1),
            Column(u'start_event_id', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'null'), for_update=False)),
            Column(u'end_event_id', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'null'), for_update=False)),
            Column(u'combat_id', SLInteger(), primary_key=0),
            Column(u'destType', NullType(), primary_key=0),
            Column(u'destName', NullType(), primary_key=0),
            Column(u'amount', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'delta', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'direction', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'dead', SLInteger(), primary_key=0, server_default=DefaultClause(text(u'0'), for_update=False)),
            Column(u'spellName', NullType(), primary_key=0),
    
    
    )