Table user_auth

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

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

Type	Champs	Nom	Extra
UNIQUE	user_id	UNQ_AUTH_USER_ID

Type	Nom du champ	Dépendances	NULL
BOOL	is_in_vacation	vacation_from, vacation_until	Non
BOOL	is_banned	banned_from, banned_until	Non

Moteur de stockage	Charset	Interclassement
InnoDB	UTF-8	utf8_general_ci