Indexes and foreign keys added

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

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