====== Table user_auth ======

 ===== Table =====

^ Table d'origine ^ Champ d'origine ^ Table de dest. ^ Champ dest.      ^ Type champ dest. ^ Index     ^  Extra ^ Null  ^ Module ^ Modèle ^ Attribut        ^ SQL SELECT                                              ^
|                 |                 ^  user_auth     |  user_id         |  INT (11)        ^  UNIQUE  |         |  Non  |  User  |  Auth  |  user_id        |                                                         |
| users           | password        ^  user_auth     |  password        |  VARCHAR (40)    |          |         |  Non  |  User  |  Auth  |  password       |                                                         |
|                 |                 ^  user_auth     |  salt            |  VARCHAR (10)    |          |         |  Non  |  User  |  Auth  |  salt           |                                                         |
| users           | noipcheck       ^  user_auth     |  check_ip        |  BOOL (1)        |          |         |  Non  |  User  |  Auth  |  check_ip       |                                                         |
|                 |                 ^  user_auth     |  vacation_from   |  DATETIME        |          |         ^  Oui  |  User  |  Auth  |  vacation_from  |                                                         |
| users           | urlaubs_until   ^  user_auth     |  vacation_until  |  DATETIME        |          |         ^  Oui  |  User  |  Auth  |  vacation_until |                                                         |
|                 |                 ^  user_auth     |                  |  BOOL (1)        |          |         |  Non  |  User  |  Auth  |  is_in_vacation |  ''(NOW() > vacation_from AND NOW() < vacation_until)'' |
|                 |                 ^  user_auth     |  banned_from     |  DATETIME        |          |         ^  Oui  |  User  |  Auth  |  banned_from    |                                                         |
| users           | banaday         ^  user_auth     |  banned_until    |  DATETIME        |          |         ^  Oui  |  User  |  Auth  |  banned_until   |                                                         |
|                 |                 ^  user_ath      |                  |  BOOL (1)        |          |         |  Non  |  User  |  Auth  |  is_banned      |  ''(NOW() > banned_from AND NOW() < banned_until)''     |
|                 |                 ^  user_auth     |  created_at      |  DATETIME        |          |         |  Non  |  User  |  Auth  |  created_at     |                                                         |
|                 |                 ^  user_auth     |  updated_at      |  DATETIME        |          |         |  Non  |  User  |  Auth  |  updated_at     |                                                         |

===== Triggers =====

^ Evènement ^ Champ ^ Valeur ^
| CREATE | created_at | ''NOW()'' |
| CREATE | updated_at | ''NOW()'' |
^        ^            ^           ^
| UPDATE | updated_at | ''NOW()'' |

 ===== Indexes =====
^ Type ^ Champs ^ Nom ^ Extra ^
| UNIQUE | user_id | UNQ_AUTH_USER_ID | |

 ===== Champs virtuels =====
^ Type ^ Nom du champ ^ Dépendances ^ NULL ^
| BOOL | is_in_vacation | vacation_from, vacation_until | Non |
| BOOL | is_banned | banned_from, banned_until | Non |

 ===== Extra =====

^ Moteur de stockage ^ Charset ^ Interclassement ^
| InnoDB | UTF-8 | utf8_general_ci |