"""empty message

Revision ID: 413cde7843f0
Revises: 
Create Date: 2026-01-09 10:32:07.899048

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '413cde7843f0'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('anomali1',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('v_rms_magnitude', sa.Float(), nullable=True),
    sa.Column('a_peak_magnitude', sa.Integer(), nullable=True),
    sa.Column('sicaklik', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali2',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('sicaklik1', sa.Integer(), nullable=True),
    sa.Column('sicaklik12', sa.Integer(), nullable=True),
    sa.Column('sicaklik24', sa.Integer(), nullable=True),
    sa.Column('ana_motor_akimi', sa.Float(), nullable=True),
    sa.Column('ana_motor_hizi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_hizi', sa.Float(), nullable=True),
    sa.Column('eriyik_basinci', sa.Float(), nullable=True),
    sa.Column('cekici_hizi', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali3',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('sicaklik1', sa.Integer(), nullable=True),
    sa.Column('sicaklik12', sa.Integer(), nullable=True),
    sa.Column('sicaklik24', sa.Integer(), nullable=True),
    sa.Column('ana_motor_akimi', sa.Float(), nullable=True),
    sa.Column('ana_motor_hizi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_hizi', sa.Float(), nullable=True),
    sa.Column('eriyik_basinci', sa.Float(), nullable=True),
    sa.Column('cekici_hizi', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali4',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('v_rms_magnitude', sa.Float(), nullable=True),
    sa.Column('a_peak_magnitude', sa.Integer(), nullable=True),
    sa.Column('sicaklik', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali5',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('v_rms_magnitude', sa.Float(), nullable=True),
    sa.Column('a_peak_magnitude', sa.Integer(), nullable=True),
    sa.Column('sicaklik', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali6',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('v_rms_magnitude', sa.Float(), nullable=True),
    sa.Column('a_peak_magnitude', sa.Integer(), nullable=True),
    sa.Column('sicaklik', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali7',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('sicaklik1', sa.Integer(), nullable=True),
    sa.Column('sicaklik12', sa.Integer(), nullable=True),
    sa.Column('sicaklik24', sa.Integer(), nullable=True),
    sa.Column('ana_motor_akimi', sa.Float(), nullable=True),
    sa.Column('ana_motor_hizi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_hizi', sa.Float(), nullable=True),
    sa.Column('eriyik_basinci', sa.Float(), nullable=True),
    sa.Column('cekici_hizi', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('anomali8',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('sicaklik1', sa.Integer(), nullable=True),
    sa.Column('sicaklik12', sa.Integer(), nullable=True),
    sa.Column('sicaklik24', sa.Integer(), nullable=True),
    sa.Column('ana_motor_akimi', sa.Float(), nullable=True),
    sa.Column('ana_motor_hizi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_hizi', sa.Float(), nullable=True),
    sa.Column('eriyik_basinci', sa.Float(), nullable=True),
    sa.Column('cekici_hizi', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('bolumler',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('adi', sa.String(length=120), nullable=True),
    sa.Column('kodu', sa.String(length=120), nullable=True),
    sa.Column('aciklama', sa.Text(), nullable=True),
    sa.Column('nasil', sa.Integer(), nullable=True),
    sa.Column('durum', sa.Integer(), nullable=True),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('hatlar',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('adi', sa.String(length=120), nullable=True),
    sa.Column('kodu', sa.String(length=120), nullable=True),
    sa.Column('bolum_id', sa.Integer(), nullable=True),
    sa.Column('aciklama', sa.Text(), nullable=True),
    sa.Column('toplam_uretim', sa.Double(), nullable=True),
    sa.Column('durum', sa.Integer(), nullable=True),
    sa.Column('nasil', sa.Integer(), nullable=True),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('is_emirleri',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('adi', sa.String(length=120), nullable=True),
    sa.Column('kodu', sa.String(length=120), nullable=True),
    sa.Column('aciklama', sa.Text(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('urun_id', sa.Integer(), nullable=True),
    sa.Column('baslangic_ts', sa.DateTime(), nullable=True),
    sa.Column('durum', sa.Integer(), nullable=True),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('kullanicilar',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('ad_soyad', sa.String(length=50), nullable=False),
    sa.Column('kullanici_adi', sa.String(length=50), nullable=False),
    sa.Column('telefon', sa.String(length=50), nullable=True),
    sa.Column('eposta', sa.String(length=120), nullable=False),
    sa.Column('parola', sa.String(length=120), nullable=False),
    sa.Column('rol_num', sa.Integer(), nullable=False),
    sa.Column('durum', sa.Integer(), nullable=False),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('eposta'),
    sa.UniqueConstraint('kullanici_adi'),
    sa.UniqueConstraint('telefon')
    )
    op.create_table('musteriler',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('kodu', sa.String(length=120), nullable=True),
    sa.Column('adi_soyadi', sa.String(length=120), nullable=True),
    sa.Column('telefon', sa.String(length=50), nullable=True),
    sa.Column('eposta', sa.String(length=120), nullable=True),
    sa.Column('aciklama', sa.Text(), nullable=True),
    sa.Column('durum', sa.Integer(), nullable=True),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('parola_sifirlama_tokenleri',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('kullanici_id', sa.Integer(), nullable=False),
    sa.Column('token', sa.String(length=64), nullable=False),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('sensorler',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('tc1', sa.Integer(), nullable=True),
    sa.Column('tc2', sa.Integer(), nullable=True),
    sa.Column('tc3', sa.Integer(), nullable=True),
    sa.Column('tc4', sa.Integer(), nullable=True),
    sa.Column('tc5', sa.Integer(), nullable=True),
    sa.Column('tc6', sa.Integer(), nullable=True),
    sa.Column('tc7', sa.Integer(), nullable=True),
    sa.Column('tc8', sa.Integer(), nullable=True),
    sa.Column('tc9', sa.Integer(), nullable=True),
    sa.Column('tc10', sa.Integer(), nullable=True),
    sa.Column('tc11', sa.Integer(), nullable=True),
    sa.Column('tc12', sa.Integer(), nullable=True),
    sa.Column('tc13', sa.Integer(), nullable=True),
    sa.Column('tc14', sa.Integer(), nullable=True),
    sa.Column('tc15', sa.Integer(), nullable=True),
    sa.Column('tc16', sa.Integer(), nullable=True),
    sa.Column('tc17', sa.Integer(), nullable=True),
    sa.Column('tc18', sa.Integer(), nullable=True),
    sa.Column('tc19', sa.Integer(), nullable=True),
    sa.Column('tc20', sa.Integer(), nullable=True),
    sa.Column('tc21', sa.Integer(), nullable=True),
    sa.Column('tc22', sa.Integer(), nullable=True),
    sa.Column('tc23', sa.Integer(), nullable=True),
    sa.Column('tc24', sa.Integer(), nullable=True),
    sa.Column('sicaklik1', sa.Integer(), nullable=True),
    sa.Column('sicaklik2', sa.Integer(), nullable=True),
    sa.Column('sicaklik3', sa.Integer(), nullable=True),
    sa.Column('sicaklik4', sa.Integer(), nullable=True),
    sa.Column('sicaklik5', sa.Integer(), nullable=True),
    sa.Column('sicaklik6', sa.Integer(), nullable=True),
    sa.Column('sicaklik7', sa.Integer(), nullable=True),
    sa.Column('sicaklik8', sa.Integer(), nullable=True),
    sa.Column('sicaklik9', sa.Integer(), nullable=True),
    sa.Column('sicaklik10', sa.Integer(), nullable=True),
    sa.Column('sicaklik11', sa.Integer(), nullable=True),
    sa.Column('sicaklik12', sa.Integer(), nullable=True),
    sa.Column('sicaklik13', sa.Integer(), nullable=True),
    sa.Column('sicaklik14', sa.Integer(), nullable=True),
    sa.Column('sicaklik15', sa.Integer(), nullable=True),
    sa.Column('sicaklik16', sa.Integer(), nullable=True),
    sa.Column('sicaklik17', sa.Integer(), nullable=True),
    sa.Column('sicaklik18', sa.Integer(), nullable=True),
    sa.Column('sicaklik19', sa.Integer(), nullable=True),
    sa.Column('sicaklik20', sa.Integer(), nullable=True),
    sa.Column('sicaklik21', sa.Integer(), nullable=True),
    sa.Column('sicaklik22', sa.Integer(), nullable=True),
    sa.Column('sicaklik23', sa.Integer(), nullable=True),
    sa.Column('sicaklik24', sa.Integer(), nullable=True),
    sa.Column('sicaklik25', sa.Integer(), nullable=True),
    sa.Column('sicaklik26', sa.Integer(), nullable=True),
    sa.Column('sicaklik27', sa.Integer(), nullable=True),
    sa.Column('sicaklik28', sa.Integer(), nullable=True),
    sa.Column('hata_orani', sa.Float(), nullable=True),
    sa.Column('ana_motor_hizi', sa.Float(), nullable=True),
    sa.Column('ana_motor_akimi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_hizi', sa.Float(), nullable=True),
    sa.Column('cizgi_motor_akimi', sa.Float(), nullable=True),
    sa.Column('cekici_hizi', sa.Float(), nullable=True),
    sa.Column('eriyik_basinci', sa.Float(), nullable=True),
    sa.Column('vakum_tanki1', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('silo_sistemleri',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('silo1', sa.Float(), nullable=True),
    sa.Column('silo2', sa.Float(), nullable=True),
    sa.Column('silo3', sa.Float(), nullable=True),
    sa.Column('proses_su_giris', sa.Float(), nullable=True),
    sa.Column('proses_su_cikis', sa.Float(), nullable=True),
    sa.Column('ic_ortam_isisi', sa.Float(), nullable=True),
    sa.Column('hava_tank_basinci', sa.Float(), nullable=True),
    sa.Column('su_seviyesi', sa.Float(), nullable=True),
    sa.Column('su_basinci', sa.Float(), nullable=True),
    sa.Column('chiller1', sa.Float(), nullable=True),
    sa.Column('chiller2', sa.Float(), nullable=True),
    sa.Column('pompa1', sa.Float(), nullable=True),
    sa.Column('pompa2', sa.Float(), nullable=True),
    sa.Column('pompa3', sa.Float(), nullable=True),
    sa.Column('pompa4', sa.Float(), nullable=True),
    sa.Column('pompa5', sa.Float(), nullable=True),
    sa.Column('pompa6', sa.Float(), nullable=True),
    sa.Column('pompa7', sa.Float(), nullable=True),
    sa.Column('pompa8', sa.Float(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('titresim_verileri',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('tarih', sa.DateTime(), nullable=True),
    sa.Column('hat_id', sa.Integer(), nullable=True),
    sa.Column('is_emri_id', sa.Integer(), nullable=True),
    sa.Column('v_rms_x', sa.Float(), nullable=True),
    sa.Column('v_rms_y', sa.Float(), nullable=True),
    sa.Column('v_rms_z', sa.Float(), nullable=True),
    sa.Column('v_rms_magnitude', sa.Float(), nullable=True),
    sa.Column('scale_v_rms', sa.Float(), nullable=True),
    sa.Column('a_peak_x', sa.Integer(), nullable=True),
    sa.Column('a_peak_y', sa.Integer(), nullable=True),
    sa.Column('a_peak_z', sa.Integer(), nullable=True),
    sa.Column('a_peak_magnitude', sa.Integer(), nullable=True),
    sa.Column('a_rms_x', sa.Integer(), nullable=True),
    sa.Column('a_rms_y', sa.Integer(), nullable=True),
    sa.Column('a_rms_z', sa.Integer(), nullable=True),
    sa.Column('a_rms_magnitude', sa.Integer(), nullable=True),
    sa.Column('olcekleme_a_peak_v_rms', sa.Float(), nullable=True),
    sa.Column('sicaklik', sa.Float(), nullable=True),
    sa.Column('olcekleme_sicaklik', sa.Float(), nullable=True),
    sa.Column('cihaz_durumu', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('urunler',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('adi', sa.String(length=120), nullable=True),
    sa.Column('kodu', sa.String(length=120), nullable=True),
    sa.Column('aciklama', sa.Text(), nullable=True),
    sa.Column('durum', sa.Integer(), nullable=True),
    sa.Column('olusturma_ts', sa.DateTime(), nullable=True),
    sa.Column('guncelleme_ts', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('urunler')
    op.drop_table('titresim_verileri')
    op.drop_table('silo_sistemleri')
    op.drop_table('sensorler')
    op.drop_table('parola_sifirlama_tokenleri')
    op.drop_table('musteriler')
    op.drop_table('kullanicilar')
    op.drop_table('is_emirleri')
    op.drop_table('hatlar')
    op.drop_table('bolumler')
    op.drop_table('anomali8')
    op.drop_table('anomali7')
    op.drop_table('anomali6')
    op.drop_table('anomali5')
    op.drop_table('anomali4')
    op.drop_table('anomali3')
    op.drop_table('anomali2')
    op.drop_table('anomali1')
    # ### end Alembic commands ###