projects / platal.git / blame
| Commit | Line | Data |
|---|---|---|
| f8185297 FB |
1 | Database structure: |
| 2 | ------------------- | |
| 7d15f750 | 3 | |
| f8185297 FB |
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. | |
| 7d15f750 FB |
18 | |
| 19 | ||
| 20 | Configuration changes: | |
| 21 | ---------------------- | |
| 22 | ||
| f8185297 FB |
23 | * Core.dbdb must be set to the name of the new database. |
| 24 | * Banana.table_prefix is deprecated | |
| 7d15f750 FB |
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. | |
| 0511895d FB |
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. | |
| 58a4e6bb | 36 | * auth_user_md5.mail_storage -> email_options.storage |
| f8185297 FB |
37 | * aliases.id -> aliases.uid |
| 38 | * virtual* and emails should be unchanged |