from sqlalchemy import Boolean, Column, Integer, String, Date
from database import Base

class Server(Base):
    __tablename__ = "servers"

    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, nullable=False)
    ip_address = Column(String, nullable=False)
    dns_name = Column(String)
    guest_os = Column(String, nullable=False)
    service_date = Column(Date)
    automatic_updates = Column(Boolean, default=False)
    zabbix = Column(Boolean, default=False)
    other_info = Column(String)
    archived_date = Column(Date, nullable=True)
    server_type = Column(String, nullable=False, default='Virtuaalinen')  # Uusi sarake

class OsEol(Base):
    __tablename__ = "os_eol"

    os_name = Column(String, primary_key=True)
    eol_date = Column(Date, nullable=False)
    extended_eol_date = Column(Date, nullable=True)
    notes = Column(String, nullable=True)