diff options
Diffstat (limited to 'dumpfm/out.py')
| -rw-r--r-- | dumpfm/out.py | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/dumpfm/out.py b/dumpfm/out.py new file mode 100644 index 0000000..32e805e --- /dev/null +++ b/dumpfm/out.py @@ -0,0 +1,23 @@ +# -*- 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) + |