aboutsummaryrefslogtreecommitdiffstats
path: root/Resources/Help/topics/tables.html
diff options
context:
space:
mode:
Diffstat (limited to 'Resources/Help/topics/tables.html')
-rwxr-xr-xResources/Help/topics/tables.html89
1 files changed, 89 insertions, 0 deletions
diff --git a/Resources/Help/topics/tables.html b/Resources/Help/topics/tables.html
new file mode 100755
index 00000000..3840bb26
--- /dev/null
+++ b/Resources/Help/topics/tables.html
@@ -0,0 +1,89 @@
+<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