# Pastebin b4l0fNV0
DROP VIEW IF EXISTS `USER_FULL_INFO`;
CREATE TABLE `USER_FULL_INFO` (
`nick` varchar(30)
,`username` varchar(10)
,`codepays` char(2)
,`ip` varchar(250)
,`Nombre_connexions` int(11)
,`CREATE_AT` datetime
,`LAST_CONNECT` datetime
,`sslco` int(1)
,`webirc` int(1)
,`host` varchar(60)
,`realname` blob
);
DROP TABLE IF EXISTS `USER_FULL_INFO`;