projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
New script for formatting AX education.
[platal.git]
/
upgrade
/
account
/
01_profiles.sql
diff --git
a/upgrade/account/01_profiles.sql
b/upgrade/account/01_profiles.sql
index
02fa34b
..
040e3ee
100644
(file)
--- a/
upgrade/account/01_profiles.sql
+++ b/
upgrade/account/01_profiles.sql
@@
-1,3
+1,4
@@
+drop table if exists profiles;
create table profiles (
# Profile identifiers
pid int(6) not null auto_increment,
create table profiles (
# Profile identifiers
pid int(6) not null auto_increment,
@@
-27,6
+28,9
@@
create table profiles (
nationality2 char(2) default null,
nationality3 char(2) default null,
nationality2 char(2) default null,
nationality3 char(2) default null,
+ # Directory informations
+ email_directory varchar(255) default null,
+
# Last modification date (for notifications)
last_change date not null,
# Last modification date (for notifications)
last_change date not null,
@@
-37,6
+41,6
@@
create table profiles (
key nationality1 (nationality1),
key nationality2 (nationality2),
key nationality3 (nationality3)
key nationality1 (nationality1),
key nationality2 (nationality2),
key nationality3 (nationality3)
-);
+)
ENGINE=InnoDB, CHARSET=utf8
;
# vim:set syntax=mysql:
# vim:set syntax=mysql: