X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F00_account.sql;h=e8523d343dbdb1dc32386910a8b272b50c759c4d;hb=4ca15c312b905eea712b71d077c7a8b24f9d3b01;hp=241cb8d7bd3c37a5d88f5551a9616eda335c4b7c;hpb=f0cd349e916b22734c1f64edb63a248ca9988d93;p=platal.git

diff --git a/upgrade/account/00_account.sql b/upgrade/account/00_account.sql
index 241cb8d..e8523d3 100644
--- a/upgrade/account/00_account.sql
+++ b/upgrade/account/00_account.sql
@@ -5,12 +5,13 @@ CREATE TABLE accounts (
 
   # Account type and state
   type varchar(16) default null,
-  is_admim bool default false,
+  is_admin bool default false,
   state enum('pending', 'active', 'disabled') not null default 'pending',
 
   # Access
   password char(40) default null,
   token varchar(32) default null,
+  weak_password varchar(256) default null,
   registration_date datetime not null,
 
   # Administrative tools
@@ -18,11 +19,13 @@ CREATE TABLE accounts (
   comment varchar(255) default null,
 
   # User settings
+  email varchar(255) default null,
   full_name varchar(255) default null,
   display_name varchar(255) default null,
   sex enum('female', 'male') not null default 'male',
-  mail_format enum('plain', 'html') not null default 'html',
+  email_format enum('text', 'html') not null default 'html',
   skin varchar(32) default null,
+  last_version varchar(16) not null,
 
   primary key uid (uid),
   unique key hruid (hruid),