from sqlalchemy import Column, BigInteger, Integer, Enum, Text, String, TIMESTAMP, ForeignKey, Index
from sqlalchemy.sql import func
from extensions import db  # adjust if Base lives elsewhere

class Log(db.Model):
    __tablename__ = 'logs'
    __table_args__ = (
        Index('user_id', 'user_id'),
        Index('idx_logs_created', 'created_at'),
    )

    id = Column(BigInteger, primary_key=True, autoincrement=True, comment='日志ID')
    user_id = Column(Integer, ForeignKey('users.id', ondelete='SET NULL'), comment='用户ID')
    type = Column(Enum('access', 'error', 'behavior', 'system',
                       name='logs_type_enum'), nullable=False, comment='日志类型')
    content = Column(Text, nullable=False, comment='日志内容')
    ip = Column(String(45), nullable=True, comment='IP地址')
    created_at = Column(TIMESTAMP, server_default=func.current_timestamp(),
                        nullable=True, comment='记录时间')