"""initial revision

Revision ID: 214042a242bb
Revises:
Create Date: 2016-01-20 20:15:04.850747

"""

# revision identifiers, used by Alembic.
revision = '214042a242bb'
down_revision = None
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('users',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
    sa.Column('role', postgresql.ENUM(u'guest', u'member', u'admin', name='role_types'), server_default=sa.text(u"'member'::role_types"), autoincrement=False, nullable=False),
    sa.Column('is_active', sa.BOOLEAN(), server_default=sa.text(u'true'), autoincrement=False, nullable=False),
    sa.Column('username', sa.VARCHAR(length=24), autoincrement=False, nullable=True),
    sa.Column('email', sa.VARCHAR(length=255), server_default=sa.text(u"''::character varying"), autoincrement=False, nullable=False),
    sa.Column('password', sa.VARCHAR(length=128), server_default=sa.text(u"''::character varying"), autoincrement=False, nullable=False),
    sa.Column('payment_id', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
    sa.Column('cancelled_subscription_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('sign_in_count', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('current_sign_in_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('current_sign_in_ip', sa.VARCHAR(length=45), autoincrement=False, nullable=True),
    sa.Column('last_sign_in_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('last_sign_in_ip', sa.VARCHAR(length=45), autoincrement=False, nullable=True),
    sa.Column('locale', sa.VARCHAR(length=5), server_default=sa.text(u"'en'::character varying"), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'users_pkey'),
    postgresql_ignore_search_path=False
    )
    op.create_table('invoices',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('plan', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
    sa.Column('receipt_number', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
    sa.Column('description', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
    sa.Column('period_start_on', sa.DATE(), autoincrement=False, nullable=True),
    sa.Column('period_end_on', sa.DATE(), autoincrement=False, nullable=True),
    sa.Column('currency', sa.VARCHAR(length=8), autoincrement=False, nullable=True),
    sa.Column('tax', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('tax_percent', postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=True),
    sa.Column('total', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('brand', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.Column('last4', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('exp_date', sa.DATE(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'invoices_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('id', name=u'invoices_pkey')
    )
    op.create_table('issues',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('status', postgresql.ENUM(u'unread', u'open', u'contacted', u'closed', name='status_types'), server_default=sa.text(u"'unread'::status_types"), autoincrement=False, nullable=False),
    sa.Column('label', postgresql.ENUM(u'login', u'signup', u'billing', u'email', u'request', u'other', name='label_types'), server_default=sa.text(u"'login'::label_types"), autoincrement=False, nullable=False),
    sa.Column('email', sa.VARCHAR(length=255), server_default=sa.text(u"''::character varying"), autoincrement=False, nullable=False),
    sa.Column('question', sa.TEXT(), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=u'issues_pkey')
    )
    op.create_table('credit_cards',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('brand', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.Column('last4', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('exp_date', sa.DATE(), autoincrement=False, nullable=True),
    sa.Column('is_expiring', sa.BOOLEAN(), server_default=sa.text(u'false'), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'credit_cards_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('id', name=u'credit_cards_pkey')
    )
    op.create_table('coupons',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('code', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.Column('duration', postgresql.ENUM(u'forever', u'once', u'repeating', name='duration_types'), server_default=sa.text(u"'forever'::duration_types"), autoincrement=False, nullable=False),
    sa.Column('amount_off', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('percent_off', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('currency', sa.VARCHAR(length=8), autoincrement=False, nullable=True),
    sa.Column('duration_in_months', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('max_redemptions', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('redeem_by', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('times_redeemed', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('valid', sa.BOOLEAN(), server_default=sa.text(u'true'), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'coupons_pkey')
    )
    op.create_table('subscriptions',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('plan', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
    sa.Column('coupon', sa.VARCHAR(length=32), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'subscriptions_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('id', name=u'subscriptions_pkey')
    )
    op.create_table('widgets',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('guid', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('name', sa.VARCHAR(length=128), autoincrement=False, nullable=False),
    sa.Column('options', postgresql.JSON(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'widgets_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('id', name=u'widgets_pkey')
    )
    op.create_table('widget_files',
    sa.Column('created_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('updated_on', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True),
    sa.Column('guid', sa.VARCHAR(length=36), autoincrement=False, nullable=False),
    sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'widget_files_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('guid', name=u'widget_files_pkey')
    )
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('widget_files')
    op.drop_table('widgets')
    op.drop_table('subscriptions')
    op.drop_table('coupons')
    op.drop_table('credit_cards')
    op.drop_table('issues')
    op.drop_table('invoices')
    op.drop_table('users')
    for t in ['duration_types', 'label_types', 'role_types', 'status_types']:
        op.execute('drop type ' + t)
    ### end Alembic commands ###