added some new scripts

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)
+