X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=view%2Ftemplates%2Fstructure.tpl;h=f6a647b791a807f67b8c3e3c976c8f31a834d8f5;hb=f5f2076a2d5ec4d8229f168a9a3f66dc2d0bde6c;hp=3ec9ba9b2d5d03dd98e41c5e06be274e38343be3;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git

diff --git a/view/templates/structure.tpl b/view/templates/structure.tpl
index 3ec9ba9b2d..f6a647b791 100644
--- a/view/templates/structure.tpl
+++ b/view/templates/structure.tpl
@@ -1,10 +1,31 @@
-Table {{$name}}
+Table {{$name nofilter}}
 ===========
 
-{{$comment}}
+{{$comment nofilter}}
+
+Fields
+------
 
 {{foreach $fields as $field}}
-| {{$field.name}} | {{$field.comment}} | {{$field.type}} | {{$field.null}} | {{$field.primary}} | {{$field.default}} | {{$field.extra}} |
+| {{$field.name nofilter}} | {{$field.comment nofilter}} | {{$field.type nofilter}} | {{$field.null nofilter}} | {{$field.primary nofilter}} | {{$field.default nofilter}} | {{$field.extra nofilter}} |
+{{/foreach}}
+
+Indexes
+------------
+
+{{foreach $indexes as $index}}
+| {{$index.name nofilter}} | {{$index.fields nofilter}} |
+{{/foreach}}
+
+{{if $foreign}}
+Foreign Keys
+------------
+
+| Field | Target Table | Target Field |
+|-------|--------------|--------------|
+{{foreach $foreign as $key}}
+| {{$key.field nofilter}} | [{{$key.targettable nofilter}}](help/database/db_{{$key.targettable nofilter}}) | {{$key.targetfield nofilter}} |
 {{/foreach}}
+{{/if}}
 
 Return to [database documentation](help/database)