X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=view%2Ftemplates%2Fstructure.tpl;h=f6a647b791a807f67b8c3e3c976c8f31a834d8f5;hb=b4b9a6a34a243ad5774b30350e5c772e0986cb6c;hp=15049ab5755a96dd04b6e5756c61dee1a7ceaafc;hpb=a827f948c867ceebf60d82b0740032512be23302;p=friendica.git

diff --git a/view/templates/structure.tpl b/view/templates/structure.tpl
index 15049ab575..f6a647b791 100644
--- a/view/templates/structure.tpl
+++ b/view/templates/structure.tpl
@@ -1,11 +1,31 @@
-Table {{$name}}
+Table {{$name nofilter}}
 ===========
-{{$comment}}
 
-| Field | Description | Type | Null | Key | Default | Extra |
-| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
+{{$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)