add column webpage in the user table

1 files changed, 25 insertions, 0 deletions

diff --git a/migrations/versions/16f8fc3cf0cc_add_column_webpage_in_the_user_table.py b/migrations/versions/16f8fc3cf0cc_add_column_webpage_in_the_user_table.py
new file mode 100644
index 00000000..4ff875b7
--- /dev/null
+++ b/migrations/versions/16f8fc3cf0cc_add_column_webpage_in_the_user_table.py
@@ -0,0 +1,25 @@
+"""add column webpage in the user table
+
+Revision ID: 16f8fc3cf0cc
+Revises: 957d4c5b8ac9
+Create Date: 2016-09-21 08:00:27.160357
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '16f8fc3cf0cc'
+down_revision = '957d4c5b8ac9'
+branch_labels = None
+depends_on = None
+
+from alembic import op
+import sqlalchemy as sa
+
+
+def upgrade():
+    op.add_column('user', sa.Column('webpage',
+                                        sa.String(), default=""))
+
+
+def downgrade():
+    op.drop_column('user', 'webpage')