X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2F00_account.sql;h=26b08182176412aca9c374d5bdaa565838ad12a4;hb=9082ac5ff97d3f2ed0cf4c428c5e5cfccfef6624;hp=cc19b83c80a917f5acb84d71dd9008744afdf8f2;hpb=0511895d15129b3a24d5d8ee698f0939b848cf87;p=platal.git

diff --git a/upgrade/account/00_account.sql b/upgrade/account/00_account.sql
index cc19b83..26b0818 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,
@@ -19,6 +20,7 @@ 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',
@@ -31,15 +33,17 @@ CREATE TABLE accounts (
   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,
@@ -48,6 +52,6 @@ CREATE TABLE account_profiles (
   primary key id (uid, pid),
   key uid (uid),
   key pid (pid)
-);
+) ENGINE=InnoDB, CHARSET=utf8;
 
 # vim:set syntax=mysql: