Add a table to store workflow states

1 files changed, 28 insertions, 0 deletions

diff --git a/src/mailman/database/alembic/versions/2bb9b382198_workflow_state_table.py b/src/mailman/database/alembic/versions/2bb9b382198_workflow_state_table.py
new file mode 100644
index 000000000..23b3adebb
--- /dev/null
+++ b/src/mailman/database/alembic/versions/2bb9b382198_workflow_state_table.py
@@ -0,0 +1,28 @@
+"""Workflow state table
+
+Revision ID: 2bb9b382198
+Revises: 16c2b25c7b
+Create Date: 2015-03-25 18:09:18.338790
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '2bb9b382198'
+down_revision = '16c2b25c7b'
+
+from alembic import op
+import sqlalchemy as sa
+
+
+def upgrade():
+    op.create_table('workflowstate',
+        sa.Column('name', sa.Unicode(), nullable=False),
+        sa.Column('key', sa.Unicode(), nullable=False),
+        sa.Column('step', sa.Unicode(), nullable=False),
+        sa.Column('data', sa.Unicode(), nullable=True),
+        sa.PrimaryKeyConstraint('name', 'key')
+    )
+
+
+def downgrade():
+    op.drop_table('workflowstate')