schema.sql
changeset 209 8a00247d1dee
parent 205 c4542792db2b
child 210 2b283402e4e4
equal deleted inserted replaced
208:c75ad574b56d 209:8a00247d1dee
   102   activation_key varchar(40) NOT NULL DEFAULT 0,
   102   activation_key varchar(40) NOT NULL DEFAULT 0,
   103   old_encryption tinyint(1) NOT NULL DEFAULT 0,
   103   old_encryption tinyint(1) NOT NULL DEFAULT 0,
   104   temp_password text,
   104   temp_password text,
   105   temp_password_time int(12) NOT NULL DEFAULT 0,
   105   temp_password_time int(12) NOT NULL DEFAULT 0,
   106   user_coppa tinyint(1) NOT NULL DEFAULT 0,
   106   user_coppa tinyint(1) NOT NULL DEFAULT 0,
       
   107   user_lang smallint(5) NOT NULL,
   107   PRIMARY KEY  (user_id)
   108   PRIMARY KEY  (user_id)
   108 ) CHARACTER SET `utf8`;
   109 ) CHARACTER SET `utf8`;
   109 
   110 
   110 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   111 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   111   user_id mediumint(8) NOT NULL,
   112   user_id mediumint(8) NOT NULL,