X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Faccount%2FREADME;h=50cc04974a4002ab0efef7a1631a476d05ecfb0a;hb=ffa74e04b6601533bd0daa1974fb8b5a538cd956;hp=8ab4c372aa20d998baece1e6e13d049cfb7a4b98;hpb=fb813fb52d5ab65ca9a5b92b5cb9089523380d79;p=platal.git diff --git a/upgrade/account/README b/upgrade/account/README index 8ab4c37..50cc049 100644 --- a/upgrade/account/README +++ b/upgrade/account/README @@ -1,15 +1,27 @@ -DataBase upgrade: ------------------ +Database structure: +------------------- -* Activate forums database drop +* plat/al uses a single database instead of 5. The new database is built from scratch and *must* not be x4dat. +* most tables of the database are prefixed by the category of the table: + - account -> related to user account (identifier master, password, permissions) + - profile -> related to the directory + - email, aliases, virtual -> related to email management + - group -> related to X.net + - forum -> related to innd and banana + - ... +* some table does not follow this convention and may be renamed in the future. + +* account identifiers are called uid (hruid for a human readable identifier for display purpose) +* profile identifiers are called pid (hrpid for a human readable identifier for display purpose) + +* most tables have been switched to innodb in order to use foreign keys in a future release. Configuration changes: ---------------------- -[Banana] -* table_prefix deprecated - +* Core.dbdb must be set to the name of the new database. +* Banana.table_prefix is deprecated Affected services: ------------------ @@ -22,3 +34,5 @@ News: Email: * auth_user_md5.smtppass -> accounts.weak_password. This password is NULL when empty, but a check must be added for empty passwords. * auth_user_md5.mail_storage -> email_options.storage +* aliases.id -> aliases.uid +* virtual* and emails should be unchanged