1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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)
|
