| | 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 |
projects / platal.git / blame_incremental