104   old_encryption tinyint(1) NOT NULL DEFAULT 0,

   104   old_encryption tinyint(1) NOT NULL DEFAULT 0,

   105   temp_password text,

   105   temp_password text,

   106   temp_password_time int(12) NOT NULL DEFAULT 0,

   106   temp_password_time int(12) NOT NULL DEFAULT 0,

   107   user_coppa tinyint(1) NOT NULL DEFAULT 0,

   107   user_coppa tinyint(1) NOT NULL DEFAULT 0,

   108   user_lang smallint(5) NOT NULL,

   108   user_lang smallint(5) NOT NULL,

   109   PRIMARY KEY  (user_id)

   111   PRIMARY KEY  (user_id)

   110 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

   112 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

   111 

   113 

   112 CREATE TABLE {{TABLE_PREFIX}}users_extra(

   114 CREATE TABLE {{TABLE_PREFIX}}users_extra(

   113   user_id mediumint(8) NOT NULL,

   115   user_id mediumint(8) NOT NULL,