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

diff --git a/upgrade/account/00_account.sql b/upgrade/account/00_account.sql
index f580252..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,
@@ -34,6 +35,7 @@ CREATE TABLE accounts (
   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 '',
@@ -41,6 +43,7 @@ CREATE TABLE account_types (
   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,