123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242 |
- """empty message
- Revision ID: 7e912759589c
- Revises:
- Create Date: 2021-02-20 16:42:13.616735
- """
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = '7e912759589c'
- down_revision = None
- branch_labels = None
- depends_on = None
- def upgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.create_table('bacteria',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('bean_valve',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('bottom_valve',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('cargo1_disinfect',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('cargo2_disinfect',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('color_machine',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('conveyor_belt1',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('conveyor_belt2',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('conveyor_belt3',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('dryer',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('heating',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('hoist',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('peeling_machine',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('relay',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('status', sa.Text(), nullable=False),
- sa.Column('test4', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('stir',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('tank_co2_sensor',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('co2', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('tank_ph_sensor',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('ph', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('tank_tem_sensor',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('tem', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('temperature',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('top_valve',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('user',
- sa.Column('userID', sa.Integer(), nullable=False),
- sa.Column('firstname', sa.String(length=30), nullable=False),
- sa.Column('lastname', sa.String(length=30), nullable=False),
- sa.Column('mail', sa.String(length=50), nullable=False),
- sa.Column('phone', sa.String(length=20), nullable=False),
- sa.Column('username', sa.String(length=30), nullable=False),
- sa.Column('password', sa.String(length=40), nullable=False),
- sa.Column('status', sa.Integer(), nullable=False),
- sa.PrimaryKeyConstraint('userID'),
- sa.UniqueConstraint('username')
- )
- op.create_table('wash_machine',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- op.create_table('water_injection',
- sa.Column('sn', sa.Integer(), nullable=False),
- sa.Column('datetime', sa.DateTime(), nullable=False),
- sa.Column('tank_num', sa.Integer(), nullable=False),
- sa.Column('duration', sa.Text(), nullable=False),
- sa.Column('start', sa.Text(), nullable=False),
- sa.Column('end', sa.Text(), nullable=False),
- sa.PrimaryKeyConstraint('sn')
- )
- # ### end Alembic commands ###
- def downgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.drop_table('water_injection')
- op.drop_table('wash_machine')
- op.drop_table('user')
- op.drop_table('top_valve')
- op.drop_table('temperature')
- op.drop_table('tank_tem_sensor')
- op.drop_table('tank_ph_sensor')
- op.drop_table('tank_co2_sensor')
- op.drop_table('stir')
- op.drop_table('relay')
- op.drop_table('peeling_machine')
- op.drop_table('hoist')
- op.drop_table('heating')
- op.drop_table('dryer')
- op.drop_table('conveyor_belt3')
- op.drop_table('conveyor_belt2')
- op.drop_table('conveyor_belt1')
- op.drop_table('color_machine')
- op.drop_table('cargo2_disinfect')
- op.drop_table('cargo1_disinfect')
- op.drop_table('bottom_valve')
- op.drop_table('bean_valve')
- op.drop_table('bacteria')
- # ### end Alembic commands ###
|