X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_addon.md;h=7233b80095d13b077a3f169c688b8ff140bc0d4c;hb=bbbbf8fd6b7dec11ddc32304e33a3648568c9625;hp=cd8a3d44a62bf83b10170db3e8e8e5147d5630b6;hpb=c845415a99ebc348103815a7b2c55b15c75cdd24;p=friendica.git

diff --git a/doc/database/db_addon.md b/doc/database/db_addon.md
index cd8a3d44a6..7233b80095 100644
--- a/doc/database/db_addon.md
+++ b/doc/database/db_addon.md
@@ -1,17 +1,29 @@
 Table addon
 ===========
 
-| Field         | Description                                   | Type       | Null | Key | Default | Extra           |
-| ------------- | --------------------------------------------- | ---------- | ---- | --- | ------- | --------------- |
-| id            |                                               | int(11)    | NO   | PRI | NULL    | auto_increment  |
-| name          | addon base (file)name                        | char(255)  | NO   |     |         |                 |
-| version       | currently unused                              | char(255)  | NO   |     |         |                 |
-| installed     | currently always 1                            | tinyint(1) | NO   |     | 0       |                 |
-| hidden        | currently unused                              | tinyint(1) | NO   |     | 0       |                 |
-| timestamp     | file timestamp to check for reloads           | bigint(20) | NO   |     | 0       |                 |
-| plugin_admin  | 1 = has admin config, 0 = has no admin config | tinyint(1) | NO   |     | 0       |                 |
+registered addons
+
+Fields
+------
+
+| Field        | Description                                   | Type         | Null | Key | Default | Extra          |
+| ------------ | --------------------------------------------- | ------------ | ---- | --- | ------- | -------------- |
+| id           |                                               | int unsigned | NO   | PRI | NULL    | auto_increment |
+| name         | addon base (file)name                         | varchar(50)  | NO   |     |         |                |
+| version      | currently unused                              | varchar(50)  | NO   |     |         |                |
+| installed    | currently always 1                            | boolean      | NO   |     | 0       |                |
+| hidden       | currently unused                              | boolean      | NO   |     | 0       |                |
+| timestamp    | file timestamp to check for reloads           | int unsigned | NO   |     | 0       |                |
+| plugin_admin | 1 = has admin config, 0 = has no admin config | boolean      | NO   |     | 0       |                |
+
+Indexes
+------------
+
+| Name           | Fields          |
+| -------------- | --------------- |
+| PRIMARY        | id              |
+| installed_name | installed, name |
+| name           | UNIQUE, name    |
 
-Notes:
-These are addons which have been enabled by the site administrator on the addon page
 
 Return to [database documentation](help/database)