aboutsummaryrefslogtreecommitdiffstats
path: root/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'Resources')
-rw-r--r--Resources/English.lproj/sequel-pro-print-template.html57
-rw-r--r--Resources/sequel-pro-mysql-help-template.html61
2 files changed, 81 insertions, 37 deletions
diff --git a/Resources/English.lproj/sequel-pro-print-template.html b/Resources/English.lproj/sequel-pro-print-template.html
index 9fe2fe29..6265a3f8 100644
--- a/Resources/English.lproj/sequel-pro-print-template.html
+++ b/Resources/English.lproj/sequel-pro-print-template.html
@@ -24,14 +24,22 @@
color: #000000;
}
+ h1 {
+ font-size: 14px;
+ }
+
+ h2 {
+ font-size: 11px;
+ }
+
table, th, td {
border: 0.1em solid #000000;
}
table {
+ width: 100%;
border-collapse: collapse;
border-spacing: 0;
- width: 100%;
}
th, td {
@@ -39,8 +47,13 @@
}
th {
- background-color: #E5E5E5;
+ text-align: left;
font-weight: bold;
+ background-color: #E5E5E5;
+ }
+
+ td {
+ font-family: {{font}};
}
tr > td {
@@ -54,19 +67,26 @@
tr.odd > td {
background-color: #FFFFFF;
}
+
+ code {
+ font-family: Monaco;
+ }
</style>
</head>
<body>
+ <h1>{{c.table}}</h1>
+
<p>
- {% if c.table %}<b>Table:</b> {{c.table}}<br>{% /if %}
- <b>Connection:</b> {{c.username}}{% if c.username %}@{% /if %}{{c.hostname}}{% if c.port %}:{% /if %}{{c.port}}/{{c.database}}<br>
- <b>Generated on:</b> {% now | date_format: "dd MMM yyyy 'at' HH:mm:ss" %} by {{c.version}}<br>
- {% if c.query %}<b>SQL query:</b> {{c.query}}{% /if %}
- <br>
+ <strong>Connection:</strong> {{c.username}}{% if c.username %}@{% /if %}{{c.hostname}}{% if c.port %}:{% /if %}{{c.port}}/{{c.database}}<br />
+ <strong>Generated on:</strong> {% now | date_format: "dd MMM yyyy 'at' HH:mm:ss" %} by {{c.version}}<br />
+ {% if c.query %}<br /><strong>SQL query:</strong> <code>{{c.query}}</code>{% /if %}
+ <br />
</p>
- <table id="table_results" class="data">
+ <h2>{{title}}</h2>
+
+ <table class="data">
<thead>
<tr>
{% for column in columns %}<th>{{ column }}</th>{% /for %}
@@ -80,7 +100,26 @@
</tr>
{% /for %}
</tbody>
-</table>
+ </table><br />
+
+ {% if indexes %}
+ <h2>Table Indexes</h2><br />
+
+ <table class="data">
+ <thead>
+ <tr>
+ {% for indexColumn in indexColumns %}<th>{{ indexColumn }}</th>{% /for %}
+ </tr>
+ </thead>
+ <tbody>
+ {% for index in indexes %}
+ <tr {% cycle 'class="odd" ' 'class="even" ' %}>
+ {% for cell in index %}<td>{{ cell }}</td>{% /for %}
+ </tr>
+ {% /for %}
+ </tbody>
+ </table>
+ {% /if %}
</body>
</html>
diff --git a/Resources/sequel-pro-mysql-help-template.html b/Resources/sequel-pro-mysql-help-template.html
index 13f14e3d..214c2623 100644
--- a/Resources/sequel-pro-mysql-help-template.html
+++ b/Resources/sequel-pro-mysql-help-template.html
@@ -1,34 +1,39 @@
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
-<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
-<style type="text/css" media="all">
- body {
- margin: 2px;
- padding: 10px;
- font-family:'Helvetica';
- font-size:9pt;
- }
- h2 {
- }
- ul {
- }
- li {
- }
- .internallink {
- color:#6A81DD;
- text-decoration:none;
- }
- .description {
- font-family:Monaco;
- }
- .example {
- font-family:Courier;
- }
- .header {
- padding-bottom:5px;
- }
-</style>
+ <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+
+ <style type="text/css" media="all">
+ body {
+ margin: 2px;
+ padding: 10px;
+ font-family:'Helvetica';
+ font-size:9pt;
+ }
+
+ h2 {}
+
+ ul {}
+
+ li {}
+
+ .internallink {
+ color: #6A81DD;
+ text-decoration: none;
+ }
+
+ .description {
+ font-family: Monaco;
+ }
+
+ .example {
+ font-family: Courier;
+ }
+
+ .header {
+ padding-bottom: 5px;
+ }
+ </style>
</head>
<body>
%@