Extremely basic forum tables and browsing.

[zzz-spline-forum.git] / migration / versions / 001_Create_basic_forum_tables.py

diff --git a/migration/versions/001_Create_basic_forum_tables.py b/migration/versions/001_Create_basic_forum_tables.py
new file mode 100644 (file)
index 0000000..4949fe1
--- /dev/null
+++ b/migration/versions/001_Create_basic_forum_tables.py
@@ -0,0 +1,35 @@
+from sqlalchemy import *
+from migrate import *
+
+from sqlalchemy.ext.declarative import declarative_base
+TableBase = declarative_base(bind=migrate_engine)
+
+
+class Forum(TableBase):
+    __tablename__ = 'forums'
+    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False)
+    name = Column(Unicode(133), nullable=False)
+
+class Thread(TableBase):
+    __tablename__ = 'threads'
+    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False)
+    forum_id = Column(Integer, ForeignKey('forums.id'), nullable=False)
+    subject = Column(Unicode(133), nullable=False)
+
+class Post(TableBase):
+    __tablename__ = 'posts'
+    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False)
+    thread_id = Column(Integer, ForeignKey('threads.id'), nullable=False)
+    posted_time = Column(DateTime, nullable=False)
+    content = Column(Unicode(5120), nullable=False)
+
+
+def upgrade():
+    Forum.__table__.create()
+    Thread.__table__.create()
+    Post.__table__.create()
+
+def downgrade():
+    Post.__table__.drop()
+    Thread.__table__.drop()
+    Forum.__table__.drop()