← Back to branch summary

~ubuntu-branches/ubuntu/quantal/mysql-workbench/quantal

« back to all changes in this revision

Viewing changes to modules/wb.model/res/wb_model_reporting/HTML_Detailed_Frames.tpl/table_details.html.tpl

  • Committer: Package Import Robot
  • Author(s): Dmitry Smirnov
  • Date: 2012-03-01 21:57:30 UTC
  • Revision ID: package-import@ubuntu.com-20120301215730-o7y8av8y38n162ro
Tags: upstream-5.2.38+dfsg
Import upstream version 5.2.38+dfsg

Show diffs side-by-side

added added

removed removed

Lines of Context:
modules/wb.model/res/wb_model_reporting/HTML_Detailed_Frames.tpl/table_details.html.tpl
 
1
<html xmlns="http://www.w3.org/1999/xhtml">
 
2
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
 
3
<head>
 
4
  <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
 
5
  <title>{{TITLE}} - Table Details</title>
 
6
  <link rel="stylesheet" type="text/css" media="screen" href="{{STYLE_NAME}}.css">
 
7
</head>
 
8
  
 
9
<body class="tbl_detail_page">
 
10
{{#SCHEMATA}}
 
11
 
 
12
  <a name="Schema_{{SCHEMA_ID}}">
 
13
    <div class="schema_header">Schema {{SCHEMA_NAME}} <div class="small_text">({{SCHEMA_NUMBER}}/{{SCHEMA_COUNT}})</div></div>
 
14
  </a>
 
15
{{#DDL_LISTING}}
 
16
  <div class="table_body">
 
17
    <div class="subitem_header">DDL script</div>
 
18
    <table class="subitems_table" border="0" cellpadding="2" cellspacing="" width="100%">
 
19
      <tr>
 
20
        <td class="ddl_field"><pre>{{DDL_SCRIPT}}</pre></td>
 
21
      </tr>
 
22
    </table>
 
23
  </div>
 
24
{{/DDL_LISTING}}
 
25
{{#TABLES}}
 
26
  <a name="Table_{{TABLE_ID}}">
 
27
    <div class="table_header">Table {{TABLE_NAME}} <div class="small_text">({{TABLE_NUMBER}}/{{TABLE_COUNT}})</div></div>
 
28
  </a>
 
29
  <div class="table_body">
 
30
        
 
31
        <!-- Table properties -->
 
32
        <div class="subitem_header">Table Properties</div>
 
33
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="0" width="100%">
 
34
     <colgroup>
 
35
        <col width="20%" />
 
36
        <col width="*" />
 
37
        <col width="20%" />
 
38
        <col width="*" />
 
39
     </colgroup>
 
40
    <tr>
 
41
      <td class="details-property-name">Average Row Length</td>
 
42
      <td class="details-property-value">{{TABLE_AVG_ROW_LENGTH}}</td>
 
43
      <td class="details-property-name">Use Check Sum</td>
 
44
      <td class="details-property-value">{{TABLE_USE_CHECKSUM}}</td>
 
45
    </tr>
 
46
    <tr>
 
47
      <td class="details-property-name">Connection String</td>
 
48
      <td class="details-property-value">{{TABLE_CONNECTION_STRING}}</td>
 
49
      <td class="details-property-name">Default Character Set</td>
 
50
      <td class="details-property-value">{{TABLE_CHARSET}}</td>
 
51
    </tr>
 
52
    <tr>
 
53
      <td class="details-property-name">Default Collation</td>
 
54
      <td class="details-property-value">{{TABLE_COLLATION}}</td>
 
55
      <td class="details-property-name">Delay Key Updates</td>
 
56
      <td class="details-property-value">{{TABLE_DELAY_KEY_UPDATES}}</td>
 
57
    </tr>
 
58
    <tr>
 
59
      <td class="details-property-name">Minimal Row Count</td>
 
60
      <td class="details-property-value">{{TABLE_MIN_ROW_COUNT}}</td>
 
61
      <td class="details-property-name">Maximum Row Count</td>
 
62
      <td class="details-property-value">{{TABLE_MAX_ROW_COUNT}}</td>
 
63
    </tr>
 
64
    <tr>
 
65
      <td class="details-property-name">Union Tables</td>
 
66
      <td class="details-property-value">{{TABLE_UNION_TABLES}}</td>
 
67
      <td class="details-property-name">Merge Method</td>
 
68
      <td class="details-property-value">{{TABLE_MERGE_METHOD}}</td>
 
69
    </tr>
 
70
    <tr>
 
71
      <td class="details-property-name">Pack Keys</td>
 
72
      <td class="details-property-value">{{TABLE_PACK_KEYS}}</td>
 
73
      <td class="details-property-name">Has Password</td>
 
74
      <td class="details-property-value">{{TABLE_HAS_PASSWORD}}</td>
 
75
    </tr>
 
76
    <tr>
 
77
      <td class="details-property-name">Data Directory</td>
 
78
      <td class="details-property-value">{{TABLE_DATA_DIR}}</td>
 
79
      <td class="details-property-name">Index Directory</td>
 
80
      <td class="details-property-value">{{TABLE_INDEX_DIR}}</td>
 
81
    </tr>
 
82
    <tr>
 
83
      <td class="details-property-name">Engine</td>
 
84
      <td class="details-property-value">{{TABLE_ENGINE}}</td>
 
85
      <td class="details-property-name">Row Format</td>
 
86
      <td class="details-property-value">{{TABLE_ROW_FORMAT}}</td>
 
87
    </tr>
 
88
  </table>
 
89
 
 
90
{{#PARTITION_LISTING}}
 
91
  <div class="subitem_header">Partitions</div>
 
92
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="0" width="100%">
 
93
     <colgroup>
 
94
        <col width="20%" />
 
95
        <col width="*" />
 
96
        <col width="50%" />
 
97
        <col width="*" />
 
98
     </colgroup>
 
99
    <tr>
 
100
      <td class="subitem_table_head">Kind</td>
 
101
      <td class="subitem_table_head">Type</td>
 
102
      <td class="subitem_table_head">Parameters</td>
 
103
      <td class="subitem_table_head">Count</td>
 
104
    </tr>
 
105
    <tr>
 
106
      <td class="details-property-name">Partition</td>
 
107
      <td class="subitem_table_field">{{PARTITION_TYPE}}</td>
 
108
      <td class="subitem_table_field">{{PARTITION_EXPRESSION}}</td>
 
109
      <td class="subitem_table_field">{{PARTITION_COUNT}}</td>
 
110
    </tr>
 
111
    <tr>
 
112
      <td class="details-property-name">Sub Partition</td>
 
113
      <td class="subitem_table_field">{{PARTITION_SUB_TYPE}}</td>
 
114
      <td class="subitem_table_field">{{PARTITION_SUB_EXPRESSION}}</td>
 
115
      <td class="subitem_table_field">{{PARTITION_SUB_COUNT}}</td>
 
116
    </tr>
 
117
  </table>
 
118
  <div class="subitem_header">Partition Definitions</div>
 
119
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="0" width="100%">
 
120
    <tr>
 
121
      <td class="subitem_table_head">Partition</td>
 
122
      <td class="subitem_table_head">Value</td>
 
123
      <td class="subitem_table_head">Data Directory</td>
 
124
      <td class="subitem_table_head">Index Directory</td>
 
125
      <td class="subitem_table_head">Min Rows</td>
 
126
      <td class="subitem_table_head">Max Rows</td>
 
127
      <td class="subitem_table_head">Comment</td>
 
128
    </tr>
 
129
{{#PARTITIONS}}
 
130
    <tr>
 
131
      <td class="subitem_table_field">{{PARTITION_NAME}}</td>
 
132
      <td class="subitem_table_field">{{PARTITION_VALUE}}</td>
 
133
      <td class="subitem_table_field">{{PARTITION_DATA_DIR}}</td>
 
134
      <td class="subitem_table_field">{{PARTITION_INDEX_DIR}}</td>
 
135
      <td class="subitem_table_field">{{PARTITION_MIN_ROW_COUNT}}</td>
 
136
      <td class="subitem_table_field">{{PARTITION_MAX_ROW_COUNT}}</td>
 
137
      <td class="subitem_table_field">{{PARTITION_COMMENT}}</td>
 
138
    </tr>
 
139
{{#PARTITION_SUB_PARTITIONS}}
 
140
    <tr>
 
141
      <td class="details-sub-property-value">{{PARTITION_SUB_NAME}}</td>
 
142
      <td class="subitem_table_field">{{PARTITION_SUB_VALUE}}</td>
 
143
      <td class="subitem_table_field">{{PARTITION_SUB_DATA_DIR}}</td>
 
144
      <td class="subitem_table_field">{{PARTITION_SUB_INDEX_DIR}}</td>
 
145
      <td class="subitem_table_field">{{PARTITION_SUB_MIN_ROW_COUNT}}</td>
 
146
      <td class="subitem_table_field">{{PARTITION_SUB_MAX_ROW_COUNT}}</td>
 
147
      <td class="subitem_table_field">{{PARTITION_SUB_COMMENT}}</td>
 
148
    </tr>
 
149
{{/PARTITION_SUB_PARTITIONS}}
 
150
 
 
151
{{/PARTITIONS}}
 
152
  </table>
 
153
{{/PARTITION_LISTING}}
 
154
        
 
155
{{#COLUMNS_LISTING}}
 
156
  <div class="subitem_header">Columns</div>
 
157
  
 
158
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="0" width="100%">
 
159
    <tr>
 
160
      <td class="subitem_table_head">Key</td>
 
161
      <td class="subitem_table_head">Column Name</td>
 
162
      <td class="subitem_table_head">Datatype</td>
 
163
      <td class="subitem_table_head">Not Null</td>
 
164
      <td class="subitem_table_head">Default</td>
 
165
      <td class="subitem_table_head">Comment</td>
 
166
    </tr>
 
167
{{#COLUMNS}}
 
168
    <tr>
 
169
      <td class="subitem_table_field">{{COLUMN_KEY}}</td>
 
170
      <td class="subitem_table_field">{{COLUMN_NAME}}</td>
 
171
      <td class="subitem_table_field">{{COLUMN_DATATYPE}}</td>
 
172
      <td class="subitem_table_field">{{COLUMN_NOTNULL}}</td>
 
173
      <td class="subitem_table_field">{{COLUMN_DEFAULTVALUE}}</td>
 
174
      <td class="subitem_table_field">{{COLUMN_COMMENT}}</td>
 
175
    </tr>
 
176
{{/COLUMNS}}
 
177
  </table>
 
178
{{/COLUMNS_LISTING}}
 
179
{{#INDICES_LISTING}}
 
180
  <div class="subitem_header">Indices</div>
 
181
  
 
182
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="0" width="100%">
 
183
    <tr>
 
184
      <td class="subitem_table_head">Index Name</td>
 
185
      <td class="subitem_table_head">Columns</td>
 
186
      <td class="subitem_table_head">Primary</td>
 
187
      <td class="subitem_table_head">Unique</td>
 
188
      <td class="subitem_table_head">Type</td>
 
189
      <td class="subitem_table_head">Kind</td>
 
190
      <td class="subitem_table_head">Comment</td>
 
191
    </tr>
 
192
{{#INDICES}}
 
193
    <tr>
 
194
      <td class="subitem_table_field">{{INDEX_NAME}}</td>
 
195
      <td class="subitem_table_field"><table border="0" cellpadding="2" cellspacing="0" width="100%">
 
196
{{#INDICES_COLUMNS}}
 
197
          <tr>
 
198
            <td class="subitem_table_field">{{INDEX_COLUMN_NAME}}</td>
 
199
            <td class="subitem_table_field">{{INDEX_COLUMN_ORDER}}</td>
 
200
            <td class="subitem_table_field">{{INDEX_COLUMN_COMMENT}}</td>
 
201
          </tr>
 
202
{{/INDICES_COLUMNS}}
 
203
        </table></td>
 
204
      <td class="subitem_table_field">{{INDEX_PRIMARY}}</td>
 
205
      <td class="subitem_table_field">{{INDEX_UNIQUE}}</td>
 
206
      <td class="subitem_table_field">{{INDEX_TYPE}}</td>
 
207
      <td class="subitem_table_field">{{INDEX_KIND}}</td>
 
208
      <td class="subitem_table_field">{{INDEX_COMMENT}}</td>
 
209
    </tr>
 
210
{{/INDICES}}
 
211
  </table>
 
212
{{/INDICES_LISTING}}
 
213
{{#REL_LISTING}}
 
214
  <div class="subitem_header">Relationships</div>
 
215
  
 
216
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="" width="100%">
 
217
    <tr>
 
218
      <td class="subitem_table_head">Relationship Name</td>
 
219
      <td class="subitem_table_head">Relationship Type</td>
 
220
      <td class="subitem_table_head">Parent Table</td>
 
221
      <td class="subitem_table_head">Child Table</td>
 
222
      <td class="subitem_table_head">Card.</td>
 
223
    </tr>
 
224
{{#REL}}
 
225
    <tr>
 
226
      <td class="subitem_table_field">{{REL_NAME}}</td>
 
227
      <td class="subitem_table_field">{{REL_TYPE}}</td>
 
228
      <td class="subitem_table_field">{{REL_PARENTTABLE}}</td>
 
229
      <td class="subitem_table_field">{{REL_CHILDTABLE}}</td>
 
230
      <td class="subitem_table_field">{{REL_CARD}}</td>
 
231
    </tr>
 
232
{{/REL}}
 
233
  </table>
 
234
{{/REL_LISTING}}
 
235
 
 
236
{{#TABLE_COMMENT_LISTING}}
 
237
  <div class="subitem_header">Table Comments</div>
 
238
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="" width="100%">
 
239
    <tr>
 
240
      <td class="subitem_table_field">{{TABLE_COMMENT}}</td>
 
241
    </tr>
 
242
  </table>
 
243
{{/TABLE_COMMENT_LISTING}}
 
244
{{#DDL_LISTING}}
 
245
  <div class="subitem_header">DDL script</div>
 
246
  <table class="subitems_table" border="0" cellpadding="2" cellspacing="" width="100%">
 
247
    <tr>
 
248
      <td class="ddl_field"><pre>{{DDL_SCRIPT}}</pre></td>
 
249
    </tr>
 
250
  </table>
 
251
{{/DDL_LISTING}}
 
252
  </div>
 
253
{{/TABLES}}
 
254
 
 
255
{{/SCHEMATA}}
 
256
</body>
 
257
</html>