aboutsummaryrefslogtreecommitdiffstats
path: root/English.lproj/english_help
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2008-12-10 16:52:52 +0000
committerstuconnolly <stuart02@gmail.com>2008-12-10 16:52:52 +0000
commitfab9a6506cd04ec8f840c98772a80c44a79c74a7 (patch)
tree3cd483487bef381c934717f10df71d306c7eaf97 /English.lproj/english_help
parent4c3b208fad0572d8d1a79bba1bd1b8147fd0f8a6 (diff)
downloadsequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.tar.gz
sequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.tar.bz2
sequelpro-fab9a6506cd04ec8f840c98772a80c44a79c74a7.zip
MERGED r262:266 from branches/stuart02 to trunk to include new project structure.
Diffstat (limited to 'English.lproj/english_help')
-rw-r--r--English.lproj/english_help/bar.gifbin184 -> 0 bytes
-rw-r--r--English.lproj/english_help/english_help idxbin6144 -> 0 bytes
-rw-r--r--English.lproj/english_help/icon.gifbin1068 -> 0 bytes
-rwxr-xr-xEnglish.lproj/english_help/index.html99
-rw-r--r--English.lproj/english_help/sequel-pro_logo.jpgbin1932 -> 0 bytes
-rw-r--r--English.lproj/english_help/topics/bar.gifbin184 -> 0 bytes
-rwxr-xr-xEnglish.lproj/english_help/topics/connect.html59
-rw-r--r--English.lproj/english_help/topics/connect.jpgbin6812 -> 0 bytes
-rwxr-xr-xEnglish.lproj/english_help/topics/console.html48
-rwxr-xr-xEnglish.lproj/english_help/topics/data.html92
-rwxr-xr-xEnglish.lproj/english_help/topics/dump.html93
-rwxr-xr-xEnglish.lproj/english_help/topics/encoding.html73
-rwxr-xr-xEnglish.lproj/english_help/topics/preferences.html58
-rw-r--r--English.lproj/english_help/topics/preferences.jpgbin8025 -> 0 bytes
-rwxr-xr-xEnglish.lproj/english_help/topics/query.html58
-rwxr-xr-xEnglish.lproj/english_help/topics/reference.html212
-rwxr-xr-xEnglish.lproj/english_help/topics/sample_query.html81
-rwxr-xr-xEnglish.lproj/english_help/topics/sample_tables.html374
-rw-r--r--English.lproj/english_help/topics/sequel-pro_logo.jpgbin1932 -> 0 bytes
-rwxr-xr-xEnglish.lproj/english_help/topics/syntax.html49
-rwxr-xr-xEnglish.lproj/english_help/topics/tables.html89
21 files changed, 0 insertions, 1385 deletions
diff --git a/English.lproj/english_help/bar.gif b/English.lproj/english_help/bar.gif
deleted file mode 100644
index f716f3f9..00000000
--- a/English.lproj/english_help/bar.gif
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/english_help idx b/English.lproj/english_help/english_help idx
deleted file mode 100644
index beac9c4d..00000000
--- a/English.lproj/english_help/english_help idx
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/icon.gif b/English.lproj/english_help/icon.gif
deleted file mode 100644
index 70f30b35..00000000
--- a/English.lproj/english_help/icon.gif
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/index.html b/English.lproj/english_help/index.html
deleted file mode 100755
index 265dd630..00000000
--- a/English.lproj/english_help/index.html
+++ /dev/null
@@ -1,99 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help</title>
-<meta name="AppleTitle" content="Sequel Pro Help">
-<meta NAME="AppleIcon" CONTENT="icon.gif">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial" size="-1">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="70">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left">
- <h1>Sequel Pro Help</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-
-<table border="0" cellpadding="2" cellspacing="2" width="100%">
- <tr>
- <td width="50%" valign="top">
- <font face="Lucida Grande,Geneva,Arial">
- <b>Topics</b>
- <br>
- <font size="-1">
- <a href="topics/connect.html">Connecting to a Database</a>
- <br>
- <a href="topics/tables.html">Managing Tables (Creation, Deletion, Changes)</a>
- <br>
- <a href="topics/data.html">Data Management</a>
- <br>
- <a href="topics/query.html">Performing Custom Queries</a>
- <br>
- <a href="topics/dump.html">Data Dumps (CSV, XML)</a>
- <br>
- <a href="topics/preferences.html">Setting Preferences</a>
- <br>
- <a href="topics/console.html">Console</a>
- <br>
- <a href="topics/encoding.html">Encoding</a>
- <br>
- <a href="topics/syntax.html">Table Syntax Generation</a>
- <br>
- <a href="topics/sample_tables.html">SQL Table examples</a>
- <br>
- <a href="topics/sample_query.html">SQL Query examples</a>
- <br>
- <a href="topics/reference.html">MySQL SQL Reference</a>
- <br>
- </font>
- </font>
- </td>
- <td width="50%" valign="top">
- <font face="Lucida Grande,Geneva,Arial">
- <b>Sequel Pro Website</b>
- <br>
- <font size="-1">
- <a href="http://code.google.com/p/sequel-pro/">http://code.google.com/p/sequel-pro/</a>
- </font>
- <br>
- <br>
- <hr>
- <b>Developers and Contributors</b>
- <br>
- <font size="-1">Abhi Beckert, Matt Langtree, Lorenz Textor, Jeff Skrysak, Walter Lee Davis, Tristan O'Tierney, Kotaro Funakoshi, David Buxton, Stuart B. Glenn, Jason Hallford, <a href="http://www.snowhouse.co.uk/">snowhouse</a>, <a href="http://mysql-cocoa.sourceforge.net/">MySQL Cocoa project</a></font>
- <br>
- <br>
- <hr>
- <b>MySQL Websites</b>
- <br>
- <font size="-1">
- <a href="http://www.mysql.com/">http://www.mysql.com/</a>
- <br>
- <a href="http://www.serverlogistics.com/mysql.php">http://www.serverlogistics.com/mysql.php</a>
- </font>
- <br>
- </font>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/sequel-pro_logo.jpg b/English.lproj/english_help/sequel-pro_logo.jpg
deleted file mode 100644
index 18d9f2da..00000000
--- a/English.lproj/english_help/sequel-pro_logo.jpg
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/topics/bar.gif b/English.lproj/english_help/topics/bar.gif
deleted file mode 100644
index f716f3f9..00000000
--- a/English.lproj/english_help/topics/bar.gif
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/topics/connect.html b/English.lproj/english_help/topics/connect.html
deleted file mode 100755
index 2fbe0864..00000000
--- a/English.lproj/english_help/topics/connect.html
+++ /dev/null
@@ -1,59 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Connecting to a Database</title>
-<meta name="AppleTitle" content="Connecting to a Database">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Connecting to a Database</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;In order to work with a database and its tables, you must first be connected to it. The database connection screen appears at the start of the program.
-<br>
-<br>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Enter at least the host (IP or domain name). To connect to a local database, enter localhost or 127.0.0.1 as host.</li>
- <li>If you enter a database, it will be selected when the connection to the server is established. Otherwise you can select one of the databases on the server afterwards.</li>
- <li>If you enter no port, Sequel Pro uses the default port.</li>
- <li>Choose "Save to favorites..." in the favorites popup-button to save a connection. Passwords are stored in the Keychain. To edit favorites open the Preferences.</li>
- <li>You can connect to multiple databases by opening a new window (Menu File > New)</li>
- </ul>
- </td>
- <td width="255" valign="top" align="center">
- <img src="connect.jpg" width="220" height="199" border="0">
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/connect.jpg b/English.lproj/english_help/topics/connect.jpg
deleted file mode 100644
index e9c1ab6e..00000000
--- a/English.lproj/english_help/topics/connect.jpg
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/topics/console.html b/English.lproj/english_help/topics/console.html
deleted file mode 100755
index 1269dc38..00000000
--- a/English.lproj/english_help/topics/console.html
+++ /dev/null
@@ -1,48 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Actions Console</title>
-<meta name="AppleTitle" content="Actions Console">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Console</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;The Console at the bottom of Sequel Pro lists all of the actions you made in the current session accompanied by a timestamp.
-It can be shown or hidden using the toolbar icon at the top that says "Show/Hide Console". You can also clear
-the console by using the "Clear Console" button. If those two icons are not located in your toolbar then right-click
-in the toolbar area and select "Customize Toolbar..." from the menu. You should then see a window
-of icons which you can add to your Sequel Pro toolbar including the two mentioned above.
-<br>
-<br>
-
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/data.html b/English.lproj/english_help/topics/data.html
deleted file mode 100755
index 14aaeb9f..00000000
--- a/English.lproj/english_help/topics/data.html
+++ /dev/null
@@ -1,92 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Data Management</title>
-<meta name="AppleTitle" content="Data Management">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Data Management</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;In order to view, add, modify, or change data (rows) in your database tables you must either be in the "Content" tab or the "Custom Query" tab.
-<br>
-<br>
-<b>Adding and editing fields</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.</li>
- <li>Edit entries by double-clicking on the value you want to change. If the button with the three lines on it is clicked, double clicking on a value opens a sheet where you can edit it. This is preferred to edit large entries or entries with multiple lines.</li>
- <li>Use the value specified in the preferences (NULL by default) to enter NULL-values.</li>
- <li><font color="red">Changes aren't written to the database until you deselect the row!</font></li>
- <li>It is recommended that you edit only tables which have a primary key.</li>
- </ul>
- </td>
- </tr>
-</table>
-
-<br>
-<br>
-<b>Sorting and filtering the table content</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>To sort a table by a field, click on the header of the appropriate column in the content-view.</li>
- <li>Click on it twice to sort the table in descending order.</li>
- <li>Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.</li>
- <li>As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)</li>
- <li>If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".</li>
- </ul>
- </td>
- </tr>
-</table>
-
-<br>
-<br>
-<b>Binary Data (Images, Strings, Hex Representations)</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Field type should be Blob or Longblob</li>
- <li>To edit/enter the data, double select the field in the Content tab</li>
- <li>Click on Open and load an image</li>
- <li>Change to image and hex view</li>
- </ul>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/dump.html b/English.lproj/english_help/topics/dump.html
deleted file mode 100755
index 99123b69..00000000
--- a/English.lproj/english_help/topics/dump.html
+++ /dev/null
@@ -1,93 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Data Dumps</title>
-<meta name="AppleTitle" content="Data Dumps">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Data Dumps</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;In order to perform actions with data dumps, you must use the "File->Import; File->Export" menu options of Sequel Pro. A variety
-of exports/dumps can be performed: Sequel Pro dump, Export of Table Content Results (csv or xml format), Export of Custom
-Query Results (csv or xml format), or Export of Multiple Table data (csv or xml format). On the other hand, you can only import a
-Sequel Pro dump or a CSV file.
-<br>
-<br>
-<b>CSV File Format Information</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>You can choose the following characters: fields enclosed, fields terminated, escaped and line ends</li>
- <li>The following characters are escaped: the escaped-character itself, the line ends character, the enclosed character (if given) and the fields terminated character if no enclosed character is given</li>
- <li>NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.</li>
- <li>When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)</li>
- <li>The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer). </li>
- </ul>
- </td>
- </tr>
-</table>
-
-<br>
-<b>Importing Dumps</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Choose "File->Import" from the Sequel Pro Menu</li>
- <li>You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)</li>
- </ul>
- </td>
- </tr>
-</table>
-
-
-<br>
-<b>Excel CSV Formatting Options</b>
-<br>
-If you wish to export data to a CSV file for use in Excel, use the following settings:
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Enclosed by: " (single quote)</li>
- <li>Escaped by: " (single quote)</li>
- <li>Line ends: \r (for Macs)</li>
- <li>Delimiter: , (comma)</li>
- </ul>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/encoding.html b/English.lproj/english_help/topics/encoding.html
deleted file mode 100755
index adaed683..00000000
--- a/English.lproj/english_help/topics/encoding.html
+++ /dev/null
@@ -1,73 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Text Encoding</title>
-<meta name="AppleTitle" content="Text Encoding">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Text Encoding</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;You may choose the type of encoding for the data (text) that is stored in your MySQL database. There are two
-places to choose the encoding: the Preferences pane or the encoding pull-down bar at the bottom left of the application window. There
-are over 20 encodings for you to choose from.
-<br>
-<br>
-<b>In the Preferences Pane</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Open up the "Preferences Pane" of Sequel Pro</li>
- <li>From the pull-down at the bottom left of the preferences window, labelled "Default Encoding", choose an option.</li>
- <li>The encoding you choose will be the default encoding for all future databases</li>
- </ul>
- </td>
- </tr>
-</table>
-<br>
-<b>In the Application Window</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>In the main application window there will be a pull-down at the bottom left of the window labelled "Encoding".</li>
- <li>From the pull-down choose an encoding option.</li>
- <li>The encoding you choose will be the default encoding for all future databases</li>
- </ul>
- </td>
- </tr>
-</table>
-
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/preferences.html b/English.lproj/english_help/topics/preferences.html
deleted file mode 100755
index 0350d76b..00000000
--- a/English.lproj/english_help/topics/preferences.html
+++ /dev/null
@@ -1,58 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Setting Preferences</title>
-<meta name="AppleTitle" content="Setting Preferences">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Setting Preferences</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-<br>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Choose if you want to reload the table after adding, editing or removing a row. If you reload it, you will be sure that the entries showed by Sequel Pro correspond to the entries in the MySQL database, but editing tables will become slow with big tables.</li>
- <li>Choose if you want Sequel Pro to show an error message if no rows have been affected after adding or editing a row.</li>
- <li>Choose if you want to display the values of blob and text fields (especially with big tables this can speed up the interface significantly because Sequel Pro will load only the blob and text fields of the rows you will be editing).</li>
- <li>Choose if you want to limit the rows returned by the MySQL server. You can limit the result to a given number of rows to speed up the interface.</li>
- <li>Select a value that is displayed and used to enter NULL-values.</li>
- <li>Add favorites used to quickly connect to a MySQL database. Drag&amp;drop them to change their order. Double-click to edit a favorite. Passwords are stored in the Keychain.</li>
- </ul>
- </td>
- <td width="350" valign="top" align="center">
- <img src="preferences.jpg" width="350" height="160" border="0">
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/preferences.jpg b/English.lproj/english_help/topics/preferences.jpg
deleted file mode 100644
index 64ae8e10..00000000
--- a/English.lproj/english_help/topics/preferences.jpg
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/topics/query.html b/English.lproj/english_help/topics/query.html
deleted file mode 100755
index bb628047..00000000
--- a/English.lproj/english_help/topics/query.html
+++ /dev/null
@@ -1,58 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Performing Custom Queries</title>
-<meta name="AppleTitle" content="Performing Custom Queries">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Performing Custom Queries</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;In order to perform a SQL query you must first choose the "Custom Query" tab.
-<br>
-<br>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Enter your query and click on the "Run Query" button.</li>
- <li>The result, if there is one, is displayed in the bottom view.</li>
- <li>Under "Last Error Message" you can see the last error message returned by MySQL, if there is one.</li>
- <li>Add your query to the favorites or select a favorite query with the favorites pop-up-button.</li>
- <li>Select one of the last 20 queries with the history pop-up-button.</li>
- <li>You can perform custom queries out of your favorite text editor by using the services menu (Services > Sequel Pro > Perform selection as MySQL query). Sequel Pro uses the last opened window to perform the query.</li>
- <li>If you perferm a query out of a different text editor, be sure that Sequel Pro is already loaded and has at least one window open.</li>
- </ul>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/reference.html b/English.lproj/english_help/topics/reference.html
deleted file mode 100755
index b746bed9..00000000
--- a/English.lproj/english_help/topics/reference.html
+++ /dev/null
@@ -1,212 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - MySQL SQL Referernce</title>
-<meta name="AppleTitle" content="SQL Reference">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>MySQL SQL Reference</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-<table border="0" width="95%">
- <tr>
- <td>
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- In the following commands and functions, any italicized text should be replaced by a variable
- or name of your choice. Any text within brackets ( [ and ] ) is optional. This is only a short reference
- of the SQL commands supported in MySQL. It is NOT the full list and also may not be complete
- nor up-to-date.
- </font>
- </td>
- </tr>
-</table>
-
-<br>
-<table border="0" cellpadding="5" cellspacing="2" width="100%">
- <tr>
- <td width="60%" valign="top">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Commands</b>
- <br>
- CREATE DATABASE [IF NOT EXISTS] <i>name</i>
- <br>
- CREATE [UNIQUE|FULLTEXT] INDEX <i>name</i> ON <i>table</i> (<i>column</i>,..)
- <br>
- CREATE TABLE [IF NOT EXISTS] <i>name</i>
- <br>
- DELETE FROM <i>table</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>]
- <br>
- DROP DATABASE [IF EXISTS] <i>name</i>
- <br>
- DROP TABLE [IF EXISTS] <i>name</i>
- <br>
- GRANT <i>privilege</i> ON <i>table</i> TO <i>user</i>
- <br>
- INSERT [INTO] <i>table</i> [ (column, ...) ] VALUES (values, ...)
- <br>
- LOAD DATA INFILE <i>file</i> INTO TABLE <i>name</i>
- <br>
- SELECT [DISTINCT|ALL| |] FROM <i>table</i> [WHERE <i>clause</i> ]
- <br>
- UPDATE <i>table</i> SET <i>column=value,...</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>]
- <br>
- <br>
- <b>Logical Operators</b>
- <br>
- NOT <i>or</i>&nbsp; ! - performs a logical not
- <br>
- OR <i>or</i> | | - performs a logical or
- <br>
- XOR - performs a logical exclusive or
- <br>
- AND <i>or</i> &amp;&amp; - performs a logical and
- </font>
- </td>
- <td width="40%" valign="top">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Aggregate Functions</b>
- <br>
- AVG(<i>expression</i>)
- <br>
- BIT_AND(<i>expression</i>)
- <br>
- BIT_OR(<i>expression</i>)
- <br>
- COUNT(<i>expression</i>)
- <br>
- MAX(<i>expression</i>)
- <br>
- MIN(<i>expression</i>)
- <br>
- STD(<i>expression</i>)/STDDEV(<i>expression</i>)
- <br>
- SUM(<i>expression</i>)
- <br>
- <br>
- <b>General Functions</b>
- <br>
- ABS(<i>number</i>)
- <br>
- ACOS(<i>number</i>)
- <br>
- ADDDATE(<i>date</i>, INTERVAL, <i>amount</i>, <i>type</i>)
- <br>
- ASCII(<i>char</i>)
- <br>
- ASIN(<i>number</i>)
- <br>
- ATAN(<i>number</i>)
- <br>
- ATAN2(x, y)
- <br>
- BENCHMARK(<i>num</i>, <i>function</i>)
- <br>
- BIN((<i>decimal</i>)
- <br>
- BIT_COUNT(<i>number</i>)
- <br>
- BIT_LENGTH(<i>number</i>)
- <br>
- CEILING(<i>number</i>)
- <br>
- CHAR_LENGTH(<i>string</i>)
- <br>
- COS(<i>radians</i>)
- <br>
- COT(<i>radians</i>)
- <br>
- CURDATE()
- <br>
- CURTIME()
- <br>
- DATABASE()
- <br>
- DATE_FORMAT(<i>date</i>, <i>format</i>)
- <br>
- DAYNAME(<i>date</i>)
- <br>
- DAYOFMONTH(<i>date</i>)
- <br>
- DAYOFWEEK(<i>date</i>)
- <br>
- DAYOFYEAR(<i>date</i>)
- <br>
- EXP(<i>power</i>)
- <br>
- FLOOR(<i>number</i>)
- <br>
- FORMAT(<i>number</i>, <i>decimals</i>)
- <br>
- HOUR(<i>time</i>)
- <br>
- LENGTH(<i>string</i>)
- <br>
- LOG(<i>number</i>)
- <br>
- LOWER(<i>number</i>)
- <br>
- MD5(<i>string</i>)
- <br>
- MINUTE(<i>time</i>)
- <br>
- MONTH(<i>date</i>)
- <br>
- MONTHNAME(<i>date</i>)
- <br>
- NOW()
- <br>
- PASSWORD(<i>string</i>)
- <br>
- QUARTER(<i>date</i>)
- <br>
- REVERSE(<i>string</i>)
- <br>
- SECOND(<i>time</i>)
- <br>
- SIGN(<i>number</i>)
- <br>
- SPACE(<i>number</i>)
- <br>
- SQRT(<i>number</i>)
- <br>
- UPPER(<i>string</i>)
- <br>
- VERSION()
- <br>
- WEEK(<i>date</i>)
- <br>
- WEEKDAY(<i>date</i>)
- <br>
- YEAR(<i>date</i>)
- </font>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/sample_query.html b/English.lproj/english_help/topics/sample_query.html
deleted file mode 100755
index 66b249fd..00000000
--- a/English.lproj/english_help/topics/sample_query.html
+++ /dev/null
@@ -1,81 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - SQL Query Examples</title>
-<meta name="AppleTitle" content="SQL Query Examples">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>SQL Query Examples</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-<table border="0" width="95%">
- <tr>
- <td>
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- The following queries are only examples and any use of these queries in a company or critical environment
- signifies the prior knowledge and acceptance, on behalf of the implentor, that the authors of this software are not liable for damages or losses in use of these queries.
- No guarantees are made as to the quality or reliabity of the queries listed below. They are listed to help database designers/creators in their
- work by showing an example.
- </font>
- </td>
- </tr>
-</table>
-<br>
-<br>
-<table border="0" cellpadding="5" cellspacing="10" width="100%" align="center">
- <tr>
- <td valign="top" bgcolor="#EAEAEA">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Example SELECT Query</b>
- <hr>
- This obtains information an account table and only returns the accounts with logins of 1 or more,
- ordered alphabetically by the person's name.
- <br>
- <br>
- <b>SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name</b>
- <br>
- </font>
- </td>
- </tr>
- <tr>
- <td valign="top" bgcolor="#EAEAEA">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Example DELETE Query</b>
- <hr>
- This query deletes one row of data from a product table.
- <br>
- <br>
- <b>DELETE FROM products WHERE ProductID=5 LIMIT 1</b>
- <br>
- </font>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/sample_tables.html b/English.lproj/english_help/topics/sample_tables.html
deleted file mode 100755
index ba61c094..00000000
--- a/English.lproj/english_help/topics/sample_tables.html
+++ /dev/null
@@ -1,374 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - SQL Table Examples</title>
-<meta name="AppleTitle" content="SQL Table Examples">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>SQL Table Examples</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-<table border="0" width="95%">
- <tr>
- <td>
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- The following tables are only examples and any use of these tables in a company or critical environment
- signifies the prior knowledge and acceptance, on behalf of the implentor, that the authors of this software are not liable for damages or losses in use of these tables.
- No guarantees are made as to the quality or reliabity of the table designs listed below. They are listed to help database designers/creators in their
- work by showing an example.
- <br>
- The schema used is non-standard. It shows the table name above three columns. The first is the name of the variable, the second
- is the type of that variable, and the third is the size (if necessary).
- </font>
- </td>
- </tr>
-</table>
-<br>
-<br>
-<table border="0" cellpadding="5" cellspacing="10" width="100%" align="center">
- <tr>
- <td width="50%" valign="top" bgcolor="#EAEAEA">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Example Accounts Database Table</b>
- <hr>
- This table was designed for a custom system needing user accounts where they
- could have a login and password to a website. It tracks logins, modifications to
- the data and who created the account. It also allows the account to be locked out.
- The password should be MD5 encrypted and stored in the database that way.
- <br>
- <br>
- <center>
- <table width="80%" bgcolor="black" cellspacing="2" border="1" align="center">
- <tr>
- <td bgcolor="white" align="center" colspan="3"><font size="-1">
- tblAccounts
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;AccountID
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- INTEGER
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 11
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Name
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Login
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 12
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Password
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 32
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Locked
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- TINYINT
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;LoginCount
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- INTEGER
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 11
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;LastLogin
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Created
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;CreatedBy
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Updated
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;UpdatedBy
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- </table>
- </center>
- <br>
- * The AccountID is a PRIMARY KEY (also UNIQUE)
- <br>
- * The Password is MD5 encrypted, hence the length of 32
- <br>
- * The Locked value is either zero (0) or one (1)
- </font>
- </td>
- <td width="50%" valign="top" bgcolor="#EAEAEA">
- <font face="Lucida Grande,Geneva,Arial" size="-1">
- <b>Example Products Database Table</b>
- <hr>
- This table was designed to store basic production information, possibly in a
- small business database or online shopping cart. It is highly recommended
- that this table be customized to your needs.
- <br>
- <br>
- <center>
- <table width="80%" bgcolor="black" cellspacing="2" border="1" align="center">
- <tr>
- <td bgcolor="white" align="center" colspan="3"><font size="-1">
- tblProducts
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;ProductID
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- INTEGER
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 11
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Name
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;ShortDescription
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 250
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;LongDescription
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- TEXT
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Price
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DECIMAL(9,2)
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;ImageURL
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 250
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Locked
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- TINYINT
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;ViewCount
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- INTEGER
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 11
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;LastViewed
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Created
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
-
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;CreatedBy
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;Updated
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- DATETIME
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- </font></td>
- </tr>
- <tr>
- <td width="50%" bgcolor="white"><font size="-1">
- &nbsp;UpdatedBy
- </font></td>
- <td width="35%" bgcolor="white" align="center"><font size="-1">
- VARCHAR
- </font></td>
- <td width="15%" bgcolor="white" align="center"><font size="-1">
- 200
- </font></td>
- </tr>
- </table>
- </center>
- <br>
- * The ProductID is a PRIMARY KEY (also UNIQUE)
- <br>
- * The ImageURL points to an image of the product
- <br>
- * The Locked value is either zero (0) or one (1)
- </font>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/sequel-pro_logo.jpg b/English.lproj/english_help/topics/sequel-pro_logo.jpg
deleted file mode 100644
index 18d9f2da..00000000
--- a/English.lproj/english_help/topics/sequel-pro_logo.jpg
+++ /dev/null
Binary files differ
diff --git a/English.lproj/english_help/topics/syntax.html b/English.lproj/english_help/topics/syntax.html
deleted file mode 100755
index 39c4da72..00000000
--- a/English.lproj/english_help/topics/syntax.html
+++ /dev/null
@@ -1,49 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Table Syntax Generation</title>
-<meta name="AppleTitle" content="Table Syntax Generation">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Table Syntax Generation</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;If you would like to generate a SQL output of your table's syntax (column types, sizes, keys, table name, etc..) use
-the "Create Table Syntax" icon at the top of the application in the Sequel Pro Toolbar area. You can then use that text to
-create a copy of the table in another database or it may also serve as a backup of the table's schema. If the "Create Table Syntax" icon is
-not located in your toolbar then right-click
-in the toolbar area and select "Customize Toolbar..." from the menu. You should then see a window
-of icons which you can add to your Sequel Pro toolbar including the one mentioned above.
-<br>
-<br>
-
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
diff --git a/English.lproj/english_help/topics/tables.html b/English.lproj/english_help/topics/tables.html
deleted file mode 100755
index 3840bb26..00000000
--- a/English.lproj/english_help/topics/tables.html
+++ /dev/null
@@ -1,89 +0,0 @@
-<html>
-<head>
-<title>Sequel Pro Help - Managing Tables</title>
-<meta name="AppleTitle" content="Managing Tables">
-<meta name="AppleFont" content="Lucida Grande">
-<meta ROBOTS="robots" CONTENT="anchors">
-</head>
-<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
-
-<font face="Lucida Grande,Geneva,Arial">
-
-<br>
-
-<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
- <tr>
- <td align="left" valign="top" width="70">
- <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
- </td>
- <td align="left"><h1>Managing Tables</h1>
- </td>
- </tr>
- <tr>
- <td colspan="2">
- <img src="bar.gif" width="100%" height="20">
- </td>
- </tr>
-</table>
-
-<br>
-<font size="-1">
-&nbsp;<a href="../index.html">Back to the main menu</a>
-<br>
-<br>
-
-&nbsp;In order to perform actions with tables, you must first choose the "Structure" tab.
-<br>
-<br>
-<b>Adding and Editing Fields</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Add fields with the plus-button and drop them with the minus-button.</li>
- <li>Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.</li>
- <li><font color="red">Changes aren't written to the database until you deselect the row!</font></li>
- <li>You can also drag &amp; drop fields to change their order (if they are not indexed).</li>
- </ul>
- </td>
- </tr>
-</table>
-
-<br>
-<br>
-<b>Adding, editing, removing and copying tables</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Add or remove tables with the plus- and minus-buttons.</li>
- <li>If you add a table, Sequel Pro creates a field called "id" because a table must have at least one column. You can change or delete this field afterwards.</li>
- <li>Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.</li>
- <li>Select a table and hit the copy button under the list of tables to copy it. If you mark "Copy table content", the new table will also contain all entries of the old table.</li>
- </ul>
- </td>
- </tr>
-</table>
-
-<br>
-<br>
-<b>Adding and editing indexes</b>
-<table border="0" cellpadding="5" cellspacing="0" width="100%">
- <tr>
- <td bgcolor="#fff8dc" valign="top">
- <font size="-1" face="Lucida Grande,Geneva,Arial">
- <ul>
- <li>Add indexes with the plus-button and drop them with the minus-button.</li>
- <li>Select "Key Type", "Key Name" and "Indexed Columns" in the sheet. If you don't specify a key name, the column name is used as name.</li>
- <li>If you want to make an index of more than one column, enter them in the appropriated field separated by commas (without whitespace after the comma!).</li>
- </ul>
- </td>
- </tr>
-</table>
-
-</font>
-
-</body>
-</html> \ No newline at end of file
912' href='#n2912'>2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171 3172 3173 3174 3175 3176 3177 3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255 3256 3257 3258 3259 3260 3261 3262 3263 3264 3265 3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279 3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292 3293 3294 3295 3296 3297 3298 3299 3300 3301 3302 3303 3304 3305 3306 3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324 3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338 3339 3340 3341 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373 3374 3375 3376 3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405 3406 3407 3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419 3420 3421 3422 3423 3424 3425 3426 3427 3428 3429 3430 3431 3432 3433 3434 3435 3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447 3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507 3508 3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527 3528 3529 3530 3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561 3562 3563 3564 3565 3566 3567 3568 3569 3570 3571 3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783 3784 3785 3786 3787 3788 3789 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802 3803 3804 3805 3806 3807 3808 3809 3810 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821 3822 3823 3824 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 3838 3839 3840 3841 3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852 3853 3854 3855 3856 3857 3858 3859 3860 3861 3862 3863 3864 3865 3866 3867 3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883 3884 3885 3886 3887 3888 3889 3890 3891 3892 3893 3894 3895 3896 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 3910 3911 3912 3913 3914 3915 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 3930 3931 3932 3933 3934 3935 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951 3952 3953 3954 3955 3956 3957 3958 3959 3960 3961 3962 3963 3964 3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986 3987 3988 3989 3990 3991 3992 3993 3994 3995 3996 3997 3998 3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020 4021 4022 4023 4024 4025 4026 4027 4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048 4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 4081 4082 4083 4084 4085 4086 4087 4088 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4128 4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 4140 4141 4142 4143 4144 4145 4146 4147 4148 4149 4150 4151 4152 4153 4154 4155 4156 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172 4173 4174 4175 4176 4177 4178 4179 4180 4181 4182 4183 4184 4185 4186 4187 4188 4189 4190 4191 4192 4193 4194 4195 4196 4197 4198 4199 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 4275 4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290 4291 4292 4293 4294 4295 4296 4297 4298 4299 4300 4301 4302 4303 4304