from django.db import models

class AuthUser(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField()
    is_superuser = models.IntegerField()
    username = models.CharField(unique=True, max_length=30)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    email = models.CharField(max_length=75)
    is_staff = models.IntegerField()
    is_active = models.IntegerField()
    is_group_admin = models.IntegerField()
    date_joined = models.DateTimeField()
    role = models.CharField(max_length=45)
    lang = models.CharField(max_length=45)

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthGroup(models.Model):
    id = models.IntegerField(primary_key=True)  # AutoField?
    name = models.CharField(unique=True, max_length=80)

    class Meta:
        managed = False
        db_table = 'auth_group'

class UserActions(models.Model):
    iduser_actions = models.IntegerField(db_column='idUser_actions', primary_key=True)  # Field name made lowercase.
    timestamp = models.DateTimeField(db_column='Timestamp', blank=True, null=True)  # Field name made lowercase.
    username = models.CharField(db_column='Username', max_length=45, blank=True)  # Field name made lowercase.
    useraction_short = models.CharField(db_column='UserAction_short', max_length=45, blank=True)  # Field name made lowercase.
    useraction_long = models.CharField(db_column='UserAction_long', max_length=145, blank=True)  # Field name made lowercase.
    actiontype = models.CharField(db_column='ActionType', max_length=45)  # Field name made lowercase.
    lldevice_id = models.CharField(db_column='LLDevice_ID', max_length=45, blank=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'User_actions'