Merge pull request #11076 from tobiasd/20211207-messagespo

[friendica.git] / view / templates / structure.tpl

diff --git a/view/templates/structure.tpl b/view/templates/structure.tpl
index 91ba2eb315e29f084a0e7ea2327a4e72bf6f9779..f6a647b791a807f67b8c3e3c976c8f31a834d8f5 100644 (file)
--- 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.notnull}} | {{$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)