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

from sqlalchemy import *
from sqlalchemy.dialects.postgresql import *

metadata = MetaData()
messages = Table('messages', metadata,*[
    Column('message_id', INTEGER(), primary_key=True, nullable=False, default=text(u'nextval(\'"public".messages_message_id_seq\'::regclass)')),
    Column('user_id', INTEGER(), primary_key=False, nullable=False),
    Column('room_id', INTEGER(), primary_key=False, nullable=False),
    Column('content', TEXT(), primary_key=False, nullable=False),
    Column('created_on', TIMESTAMP(), primary_key=False, nullable=False, default=text(u'now()')),
    Column('is_image', BOOLEAN(), primary_key=False),
    Column('is_text', BOOLEAN(), primary_key=False, nullable=False, default=text(u'false')),
    CheckConstraint('messages.is_image IN (:param_1, :param_2)'),
    ForeignKeyConstraint(['user_id'], [u'public.users.user_id'], name=u'messages_user_id_fkey'),
    ForeignKeyConstraint(['room_id'], [u'public.rooms.room_id'], name=u'messages_room_id_fkey'),
    CheckConstraint('messages.is_text IN (:param_1, :param_2)'),])
Index('messages_room_id_created_on_idx', messages.c.room_id, messages.c.created_on, unique=False)
Index('messages_user_created_on_image_only_idx', messages.c.user_id, messages.c.created_on, unique=False)