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 |