@@ -0,0 +1,1898 @@
+%22%22%22add input_output and pathway table%0A%0ARevision ID: b94662e3f67e%0ARevises: 2c69b03d20fc%0ACreate Date: 2021-11-22 11:03:42.036716%0A%0A%22%22%22%0A%0A# revision identifiers, used by Alembic.%0Arevision = 'b94662e3f67e'%0Adown_revision = '2c69b03d20fc'%0A%0Afrom alembic import op%0Aimport sqlalchemy as sa%0Aimport geoalchemy2 as ga%0A%0A%0Adef upgrade():%0A    op.create_table(%0A        'input_output',%0A        sa.Column('id', sa.BIGINT(), nullable=False),%0A        sa.Column('uri', sa.TEXT(), nullable=False),%0A        sa.Column('name', sa.TEXT(), nullable=False),%0A        sa.Column('coord', ga.Geography(geometry_type='POINT', srid=4326, spatial_index=False), nullable=True),%0A        sa.Column('stop_code', sa.TEXT(), nullable=True),%0A        sa.Column('parent_station', sa.TEXT(), nullable=True),%0A        sa.PrimaryKeyConstraint('id'),%0A        schema='navitia',%0A    )%0A    op.create_table(%0A        'pathway',%0A        sa.Column('id', sa.BIGINT(), nullable=False),%0A        sa.Column('uri', sa.TEXT(), nullable=False),%0A        sa.Column('name', sa.TEXT(), nullable=False),%0A        sa.Column('from_stop_id', sa.TEXT(), nullable=False),%0A        sa.Column('to_stop_id', sa.TEXT(), nullable=False),%0A        sa.Column('pathway_mode', sa.TEXT(), nullable=False),%0A        sa.Column('is_bidirectional', sa.TEXT(), nullable=False),%0A        sa.Column('length', sa.TEXT(), nullable=True),%0A        sa.Column('traversal_time', sa.TEXT(), nullable=True),%0A        sa.Column('stair_count', sa.TEXT(), nullable=True),%0A        sa.Column('max_slope', sa.TEXT(), nullable=True),%0A        sa.Column('min_width', sa.TEXT(), nullable=True),%0A        sa.Column('signposted_as', sa.TEXT(), nullable=True),%0A        sa.Column('reversed_signposted_as', sa.TEXT(), nullable=True),%0A        sa.PrimaryKeyConstraint('id'),%0A        schema='navitia',%0A    )%0A%0A%0Adef downgrade():%0A    op.drop_table('input_output', schema='navitia')%0A    op.drop_table('pathway', schema='navitia')%0A

add db model