X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F00_account.sql;h=cc73aea92aee6da544b2e33bc197072cf3237c46;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=28f59160edd51e03e20d6b5f210ac648d6b75b44;hpb=0eeb71ec33bfa129ce99b9aa8b2905b925806731;p=platal.git

diff --git a/upgrade/account/00_account.sql b/upgrade/account/00_account.sql
index 28f5916..cc73aea 100644
--- a/upgrade/account/00_account.sql
+++ b/upgrade/account/00_account.sql
@@ -1,3 +1,4 @@
+DROP TABLE IF EXISTS accounts;
 CREATE TABLE accounts (
   # Account identifier and type
   uid int(6) not null auto_increment,
@@ -5,11 +6,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
@@ -17,32 +20,38 @@ CREATE TABLE accounts (
   comment varchar(255) default null,
 
   # User settings
-  name varchar(255) default null,
+  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',
-  skin varchar(32) default null,
+  email_format enum('text', 'html') not null default 'html',
+  skin tinyint(1) unsigned default null,
+  last_version varchar(16) not null,
 
   primary key uid (uid),
   unique key hruid (hruid),
-  key name (name),
+  key full_name (full_name),
   key state (state),
   key type (type)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
+DROP TABLE IF EXISTS account_types;
 CREATE TABLE account_types (
   type varchar(16) not null,
   perms set('mail', 'groups', 'forums', 'list', 'search', 'portal') default '',
 
   primary key type (type)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
+DROP TABLE IF EXISTS account_profiles;
 CREATE TABLE account_profiles (
   uid int(6) not null,
   pid int(6) not null,
+  perms set('owner') not null default '',
 
   primary key id (uid, pid),
   key uid (uid),
   key pid (pid)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
 # vim:set syntax=mysql: