X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=view%2Ftemplates%2Fstructure.tpl;h=f6a647b791a807f67b8c3e3c976c8f31a834d8f5;hb=78a8ed6fe77318387cae300f8a3a415477d241b5;hp=7b1569e37d9d50e2276902c6e604961f45ec0f6e;hpb=fd30df7300d9de5b2316b86ccc38053cec69dfe1;p=friendica.git

diff --git a/view/templates/structure.tpl b/view/templates/structure.tpl
index 7b1569e37d..f6a647b791 100644
--- a/view/templates/structure.tpl
+++ b/view/templates/structure.tpl
@@ -1,9 +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)