schema.sql
changeset 30 7e8fd44b36b0
parent 27 dd659f6ba891
child 32 4d87aad3c4c0
equal deleted inserted replaced
29:e5484a9e0818 30:7e8fd44b36b0
   101   account_active tinyint(1) NOT NULL DEFAULT 0,
   101   account_active tinyint(1) NOT NULL DEFAULT 0,
   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   PRIMARY KEY  (user_id)
   107   PRIMARY KEY  (user_id)
   107 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   108 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   108 
   109 
   109 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   110 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   110   user_id mediumint(8) NOT NULL,
   111   user_id mediumint(8) NOT NULL,