#!/usr/bin/python3

import sqlalchemy as sa

#from use_database import engine
metadata = sa.MetaData()


zones = sa.Table(
    'zones',
    metadata,
    sa.Column('name', sa.VARCHAR(collation='utf8_unicode_ci', length=15), nullable=False),
    sa.Column('zone_number', sa.Integer(), primary_key=True, nullable=False),
    sa.Column('description', sa.VARCHAR(collation='utf8_unicode_ci', length=40), nullable=False),
    sa.Column('gpio', sa.Integer(), nullable=False),
    sa.Column('enabled', sa.Boolean(), nullable=False),
    sa.Column('running', sa.Boolean(), nullable=False),
)