| 1 | Database structure: |
| 2 | ------------------- |
| 3 | |
| 4 | * plat/al uses a single database instead of 5. The new database is built from scratch and *must* not be x4dat. |
| 5 | * most tables of the database are prefixed by the category of the table: |
| 6 | - account -> related to user account (identifier master, password, permissions) |
| 7 | - profile -> related to the directory |
| 8 | - email, aliases, virtual -> related to email management |
| 9 | - group -> related to X.net |
| 10 | - forum -> related to innd and banana |
| 11 | - ... |
| 12 | * some table does not follow this convention and may be renamed in the future. |
| 13 | |
| 14 | * account identifiers are called uid (hruid for a human readable identifier for display purpose) |
| 15 | * profile identifiers are called pid (hrpid for a human readable identifier for display purpose) |
| 16 | |
| 17 | * most tables have been switched to innodb in order to use foreign keys in a future release. |
| 18 | |
| 19 | |
| 20 | Configuration changes: |
| 21 | ---------------------- |
| 22 | |
| 23 | * Core.dbdb must be set to the name of the new database. |
| 24 | * Banana.table_prefix is deprecated |
| 25 | |
| 26 | Affected services: |
| 27 | ------------------ |
| 28 | |
| 29 | News: |
| 30 | * authentication must use account + account_types with weakpass. |
| 31 | * forums base dropped and moved to forum_ namespace. |
| 32 | |
| 33 | |
| 34 | Email: |
| 35 | * auth_user_md5.smtppass -> accounts.weak_password. This password is NULL when empty, but a check must be added for empty passwords. |
| 36 | * auth_user_md5.mail_storage -> email_options.storage |
| 37 | * aliases.id -> aliases.uid |
| 38 | * virtual* and emails should be unchanged |