From 1d0c281511ce7b35c7e06475d7e147db5a656575 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 23 Sep 2009 13:29:10 +0000 Subject: Rename (currently unused) help folder. --- Interfaces/English.lproj/Help/bar.gif | Bin 0 -> 184 bytes Interfaces/English.lproj/Help/english_help idx | Bin 0 -> 6144 bytes Interfaces/English.lproj/Help/icon.gif | Bin 0 -> 1068 bytes Interfaces/English.lproj/Help/index.html | 99 ++++++ Interfaces/English.lproj/Help/sequel-pro_logo.jpg | Bin 0 -> 1932 bytes Interfaces/English.lproj/Help/topics/bar.gif | Bin 0 -> 184 bytes Interfaces/English.lproj/Help/topics/connect.html | 59 ++++ Interfaces/English.lproj/Help/topics/connect.jpg | Bin 0 -> 6812 bytes Interfaces/English.lproj/Help/topics/console.html | 48 +++ Interfaces/English.lproj/Help/topics/data.html | 92 +++++ Interfaces/English.lproj/Help/topics/dump.html | 93 +++++ Interfaces/English.lproj/Help/topics/encoding.html | 73 ++++ .../English.lproj/Help/topics/preferences.html | 58 ++++ .../English.lproj/Help/topics/preferences.jpg | Bin 0 -> 8025 bytes Interfaces/English.lproj/Help/topics/query.html | 58 ++++ .../English.lproj/Help/topics/reference.html | 212 ++++++++++++ .../English.lproj/Help/topics/sample_query.html | 81 +++++ .../English.lproj/Help/topics/sample_tables.html | 374 +++++++++++++++++++++ .../English.lproj/Help/topics/sequel-pro_logo.jpg | Bin 0 -> 1932 bytes Interfaces/English.lproj/Help/topics/syntax.html | 49 +++ Interfaces/English.lproj/Help/topics/tables.html | 89 +++++ Interfaces/English.lproj/english_help/bar.gif | Bin 184 -> 0 bytes .../English.lproj/english_help/english_help idx | Bin 6144 -> 0 bytes Interfaces/English.lproj/english_help/icon.gif | Bin 1068 -> 0 bytes Interfaces/English.lproj/english_help/index.html | 99 ------ .../English.lproj/english_help/sequel-pro_logo.jpg | Bin 1932 -> 0 bytes .../English.lproj/english_help/topics/bar.gif | Bin 184 -> 0 bytes .../English.lproj/english_help/topics/connect.html | 59 ---- .../English.lproj/english_help/topics/connect.jpg | Bin 6812 -> 0 bytes .../English.lproj/english_help/topics/console.html | 48 --- .../English.lproj/english_help/topics/data.html | 92 ----- .../English.lproj/english_help/topics/dump.html | 93 ----- .../english_help/topics/encoding.html | 73 ---- .../english_help/topics/preferences.html | 58 ---- .../english_help/topics/preferences.jpg | Bin 8025 -> 0 bytes .../English.lproj/english_help/topics/query.html | 58 ---- .../english_help/topics/reference.html | 212 ------------ .../english_help/topics/sample_query.html | 81 ----- .../english_help/topics/sample_tables.html | 374 --------------------- .../english_help/topics/sequel-pro_logo.jpg | Bin 1932 -> 0 bytes .../English.lproj/english_help/topics/syntax.html | 49 --- .../English.lproj/english_help/topics/tables.html | 89 ----- sequel-pro.xcodeproj/project.pbxproj | 8 +- 43 files changed, 1389 insertions(+), 1389 deletions(-) create mode 100644 Interfaces/English.lproj/Help/bar.gif create mode 100644 Interfaces/English.lproj/Help/english_help idx create mode 100644 Interfaces/English.lproj/Help/icon.gif create mode 100755 Interfaces/English.lproj/Help/index.html create mode 100644 Interfaces/English.lproj/Help/sequel-pro_logo.jpg create mode 100644 Interfaces/English.lproj/Help/topics/bar.gif create mode 100755 Interfaces/English.lproj/Help/topics/connect.html create mode 100644 Interfaces/English.lproj/Help/topics/connect.jpg create mode 100755 Interfaces/English.lproj/Help/topics/console.html create mode 100755 Interfaces/English.lproj/Help/topics/data.html create mode 100755 Interfaces/English.lproj/Help/topics/dump.html create mode 100755 Interfaces/English.lproj/Help/topics/encoding.html create mode 100755 Interfaces/English.lproj/Help/topics/preferences.html create mode 100644 Interfaces/English.lproj/Help/topics/preferences.jpg create mode 100755 Interfaces/English.lproj/Help/topics/query.html create mode 100755 Interfaces/English.lproj/Help/topics/reference.html create mode 100755 Interfaces/English.lproj/Help/topics/sample_query.html create mode 100755 Interfaces/English.lproj/Help/topics/sample_tables.html create mode 100644 Interfaces/English.lproj/Help/topics/sequel-pro_logo.jpg create mode 100755 Interfaces/English.lproj/Help/topics/syntax.html create mode 100755 Interfaces/English.lproj/Help/topics/tables.html delete mode 100644 Interfaces/English.lproj/english_help/bar.gif delete mode 100644 Interfaces/English.lproj/english_help/english_help idx delete mode 100644 Interfaces/English.lproj/english_help/icon.gif delete mode 100755 Interfaces/English.lproj/english_help/index.html delete mode 100644 Interfaces/English.lproj/english_help/sequel-pro_logo.jpg delete mode 100644 Interfaces/English.lproj/english_help/topics/bar.gif delete mode 100755 Interfaces/English.lproj/english_help/topics/connect.html delete mode 100644 Interfaces/English.lproj/english_help/topics/connect.jpg delete mode 100755 Interfaces/English.lproj/english_help/topics/console.html delete mode 100755 Interfaces/English.lproj/english_help/topics/data.html delete mode 100755 Interfaces/English.lproj/english_help/topics/dump.html delete mode 100755 Interfaces/English.lproj/english_help/topics/encoding.html delete mode 100755 Interfaces/English.lproj/english_help/topics/preferences.html delete mode 100644 Interfaces/English.lproj/english_help/topics/preferences.jpg delete mode 100755 Interfaces/English.lproj/english_help/topics/query.html delete mode 100755 Interfaces/English.lproj/english_help/topics/reference.html delete mode 100755 Interfaces/English.lproj/english_help/topics/sample_query.html delete mode 100755 Interfaces/English.lproj/english_help/topics/sample_tables.html delete mode 100644 Interfaces/English.lproj/english_help/topics/sequel-pro_logo.jpg delete mode 100755 Interfaces/English.lproj/english_help/topics/syntax.html delete mode 100755 Interfaces/English.lproj/english_help/topics/tables.html diff --git a/Interfaces/English.lproj/Help/bar.gif b/Interfaces/English.lproj/Help/bar.gif new file mode 100644 index 00000000..f716f3f9 Binary files /dev/null and b/Interfaces/English.lproj/Help/bar.gif differ diff --git a/Interfaces/English.lproj/Help/english_help idx b/Interfaces/English.lproj/Help/english_help idx new file mode 100644 index 00000000..beac9c4d Binary files /dev/null and b/Interfaces/English.lproj/Help/english_help idx differ diff --git a/Interfaces/English.lproj/Help/icon.gif b/Interfaces/English.lproj/Help/icon.gif new file mode 100644 index 00000000..70f30b35 Binary files /dev/null and b/Interfaces/English.lproj/Help/icon.gif differ diff --git a/Interfaces/English.lproj/Help/index.html b/Interfaces/English.lproj/Help/index.html new file mode 100755 index 00000000..265dd630 --- /dev/null +++ b/Interfaces/English.lproj/Help/index.html @@ -0,0 +1,99 @@ + + +Sequel Pro Help + + + + + + + + + +
+ + + + + + + + + +
+ + +

Sequel Pro Help

+
+ +
+ +
+ + + + + + +
+ + Topics +
+ + Connecting to a Database +
+ Managing Tables (Creation, Deletion, Changes) +
+ Data Management +
+ Performing Custom Queries +
+ Data Dumps (CSV, XML) +
+ Setting Preferences +
+ Console +
+ Encoding +
+ Table Syntax Generation +
+ SQL Table examples +
+ SQL Query examples +
+ MySQL SQL Reference +
+ + + 		+ + Sequel Pro Website +
+ + http://code.google.com/p/sequel-pro/ + +
+
+
+ Developers and Contributors +
+ Abhi Beckert, Matt Langtree, Lorenz Textor, Jeff Skrysak, Walter Lee Davis, Tristan O'Tierney, Kotaro Funakoshi, David Buxton, Stuart B. Glenn, Jason Hallford, snowhouse, MySQL Cocoa project +
+
+
+ MySQL Websites +
+ + http://www.mysql.com/ +
+ http://www.serverlogistics.com/mysql.php + +
+ +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/sequel-pro_logo.jpg b/Interfaces/English.lproj/Help/sequel-pro_logo.jpg new file mode 100644 index 00000000..18d9f2da Binary files /dev/null and b/Interfaces/English.lproj/Help/sequel-pro_logo.jpg differ diff --git a/Interfaces/English.lproj/Help/topics/bar.gif b/Interfaces/English.lproj/Help/topics/bar.gif new file mode 100644 index 00000000..f716f3f9 Binary files /dev/null and b/Interfaces/English.lproj/Help/topics/bar.gif differ diff --git a/Interfaces/English.lproj/Help/topics/connect.html b/Interfaces/English.lproj/Help/topics/connect.html new file mode 100755 index 00000000..2fbe0864 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/connect.html @@ -0,0 +1,59 @@ + + +Sequel Pro Help - Connecting to a Database + + + + + + + + +
+ + + + + + + + + +
+ +

Connecting to a Database

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+ + + + + +
+ +
    +
  • Enter at least the host (IP or domain name). To connect to a local database, enter localhost or 127.0.0.1 as host.
    • +
  • 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.
    • +
  • If you enter no port, Sequel Pro uses the default port.
    • +
  • 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.
    • +
  • You can connect to multiple databases by opening a new window (Menu File > New)
    • +
+ 		+ +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/connect.jpg b/Interfaces/English.lproj/Help/topics/connect.jpg new file mode 100644 index 00000000..e9c1ab6e Binary files /dev/null and b/Interfaces/English.lproj/Help/topics/connect.jpg differ diff --git a/Interfaces/English.lproj/Help/topics/console.html b/Interfaces/English.lproj/Help/topics/console.html new file mode 100755 index 00000000..1269dc38 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/console.html @@ -0,0 +1,48 @@ + + +Sequel Pro Help - Actions Console + + + + + + + + +
+ + + + + + + + + +
+ +

Console

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+ + + + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/data.html b/Interfaces/English.lproj/Help/topics/data.html new file mode 100755 index 00000000..14aaeb9f --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/data.html @@ -0,0 +1,92 @@ + + +Sequel Pro Help - Data Management + + + + + + + + +
+ + + + + + + + + +
+ +

Data Management

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+Adding and editing fields + + + + +
+ +
    +
  • Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.
    • +
  • 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.
    • +
  • Use the value specified in the preferences (NULL by default) to enter NULL-values.
    • +
  • Changes aren't written to the database until you deselect the row!
    • +
  • It is recommended that you edit only tables which have a primary key.
    • +
+
+ +
+
+Sorting and filtering the table content + + + + +
+ +
    +
  • To sort a table by a field, click on the header of the appropriate column in the content-view.
    • +
  • Click on it twice to sort the table in descending order.
    • +
  • Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.
    • +
  • As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)
    • +
  • If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".
    • +
+
+ +
+
+Binary Data (Images, Strings, Hex Representations) + + + + +
+ +
    +
  • Field type should be Blob or Longblob
    • +
  • To edit/enter the data, double select the field in the Content tab
    • +
  • Click on Open and load an image
    • +
  • Change to image and hex view
    • +
+
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/dump.html b/Interfaces/English.lproj/Help/topics/dump.html new file mode 100755 index 00000000..99123b69 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/dump.html @@ -0,0 +1,93 @@ + + +Sequel Pro Help - Data Dumps + + + + + + + + +
+ + + + + + + + + +
+ +

Data Dumps

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+CSV File Format Information + + + + +
+ +
    +
  • You can choose the following characters: fields enclosed, fields terminated, escaped and line ends
    • +
  • 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
    • +
  • NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.
    • +
  • When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)
    • +
  • The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer).
    • +
+
+ +
+Importing Dumps + + + + +
+ +
    +
  • Choose "File->Import" from the Sequel Pro Menu
    • +
  • You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)
    • +
+
+ + +
+Excel CSV Formatting Options +
+If you wish to export data to a CSV file for use in Excel, use the following settings: + + + + +
+ +
    +
  • Enclosed by: " (single quote)
    • +
  • Escaped by: " (single quote)
    • +
  • Line ends: \r (for Macs)
    • +
  • Delimiter: , (comma)
    • +
+
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/encoding.html b/Interfaces/English.lproj/Help/topics/encoding.html new file mode 100755 index 00000000..adaed683 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/encoding.html @@ -0,0 +1,73 @@ + + +Sequel Pro Help - Text Encoding + + + + + + + + +
+ + + + + + + + + +
+ +

Text Encoding

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+In the Preferences Pane + + + + +
+ +
    +
  • Open up the "Preferences Pane" of Sequel Pro
    • +
  • From the pull-down at the bottom left of the preferences window, labelled "Default Encoding", choose an option.
    • +
  • The encoding you choose will be the default encoding for all future databases
    • +
+
+
+In the Application Window + + + + +
+ +
    +
  • In the main application window there will be a pull-down at the bottom left of the window labelled "Encoding".
    • +
  • From the pull-down choose an encoding option.
    • +
  • The encoding you choose will be the default encoding for all future databases
    • +
+
+ + + + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/preferences.html b/Interfaces/English.lproj/Help/topics/preferences.html new file mode 100755 index 00000000..0350d76b --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/preferences.html @@ -0,0 +1,58 @@ + + +Sequel Pro Help - Setting Preferences + + + + + + + + +
+ + + + + + + + + +
+ +

Setting Preferences

+
+ +
+ +
+ + Back to the main menu +
+
+ +
+ + + + + +
+ +
    +
  • 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.
    • +
  • Choose if you want Sequel Pro to show an error message if no rows have been affected after adding or editing a row.
    • +
  • 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).
    • +
  • 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.
    • +
  • Select a value that is displayed and used to enter NULL-values.
    • +
  • Add favorites used to quickly connect to a MySQL database. Drag&drop them to change their order. Double-click to edit a favorite. Passwords are stored in the Keychain.
    • +
+ 		+ +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/preferences.jpg b/Interfaces/English.lproj/Help/topics/preferences.jpg new file mode 100644 index 00000000..64ae8e10 Binary files /dev/null and b/Interfaces/English.lproj/Help/topics/preferences.jpg differ diff --git a/Interfaces/English.lproj/Help/topics/query.html b/Interfaces/English.lproj/Help/topics/query.html new file mode 100755 index 00000000..bb628047 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/query.html @@ -0,0 +1,58 @@ + + +Sequel Pro Help - Performing Custom Queries + + + + + + + + +
+ + + + + + + + + +
+ +

Performing Custom Queries

+
+ +
+ +
+ + Back to the main menu +
+
+ + In order to perform a SQL query you must first choose the "Custom Query" tab. +
+
+ + + + +
+ +
    +
  • Enter your query and click on the "Run Query" button.
    • +
  • The result, if there is one, is displayed in the bottom view.
    • +
  • Under "Last Error Message" you can see the last error message returned by MySQL, if there is one.
    • +
  • Add your query to the favorites or select a favorite query with the favorites pop-up-button.
    • +
  • Select one of the last 20 queries with the history pop-up-button.
    • +
  • 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.
    • +
  • 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.
    • +
+
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/reference.html b/Interfaces/English.lproj/Help/topics/reference.html new file mode 100755 index 00000000..b746bed9 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/reference.html @@ -0,0 +1,212 @@ + + +Sequel Pro Help - MySQL SQL Referernce + + + + + + + + +
+ + + + + + + + + +
+ +

MySQL SQL Reference

+
+ +
+ +
+ + Back to the main menu +
+
+ + + + +
+ + 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. + +
+ +
+ + + + + +
+ + Commands +
+ CREATE DATABASE [IF NOT EXISTS] name +
+ CREATE [UNIQUE|FULLTEXT] INDEX name ON table (column,..) +
+ CREATE TABLE [IF NOT EXISTS] name +
+ DELETE FROM table [WHERE clause] [LIMIT n] +
+ DROP DATABASE [IF EXISTS] name +
+ DROP TABLE [IF EXISTS] name +
+ GRANT privilege ON table TO user +
+ INSERT [INTO] table [ (column, ...) ] VALUES (values, ...) +
+ LOAD DATA INFILE file INTO TABLE name +
+ SELECT [DISTINCT|ALL| |] FROM table [WHERE clause ] +
+ UPDATE table SET column=value,... [WHERE clause] [LIMIT n] +
+
+ Logical Operators +
+ NOT or  ! - performs a logical not +
+ OR or | | - performs a logical or +
+ XOR - performs a logical exclusive or +
+ AND or && - performs a logical and + + 		+ + Aggregate Functions +
+ AVG(expression) +
+ BIT_AND(expression) +
+ BIT_OR(expression) +
+ COUNT(expression) +
+ MAX(expression) +
+ MIN(expression) +
+ STD(expression)/STDDEV(expression) +
+ SUM(expression) +
+
+ General Functions +
+ ABS(number) +
+ ACOS(number) +
+ ADDDATE(date, INTERVAL, amount, type) +
+ ASCII(char) +
+ ASIN(number) +
+ ATAN(number) +
+ ATAN2(x, y) +
+ BENCHMARK(num, function) +
+ BIN((decimal) +
+ BIT_COUNT(number) +
+ BIT_LENGTH(number) +
+ CEILING(number) +
+ CHAR_LENGTH(string) +
+ COS(radians) +
+ COT(radians) +
+ CURDATE() +
+ CURTIME() +
+ DATABASE() +
+ DATE_FORMAT(date, format) +
+ DAYNAME(date) +
+ DAYOFMONTH(date) +
+ DAYOFWEEK(date) +
+ DAYOFYEAR(date) +
+ EXP(power) +
+ FLOOR(number) +
+ FORMAT(number, decimals) +
+ HOUR(time) +
+ LENGTH(string) +
+ LOG(number) +
+ LOWER(number) +
+ MD5(string) +
+ MINUTE(time) +
+ MONTH(date) +
+ MONTHNAME(date) +
+ NOW() +
+ PASSWORD(string) +
+ QUARTER(date) +
+ REVERSE(string) +
+ SECOND(time) +
+ SIGN(number) +
+ SPACE(number) +
+ SQRT(number) +
+ UPPER(string) +
+ VERSION() +
+ WEEK(date) +
+ WEEKDAY(date) +
+ YEAR(date) + +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/sample_query.html b/Interfaces/English.lproj/Help/topics/sample_query.html new file mode 100755 index 00000000..66b249fd --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/sample_query.html @@ -0,0 +1,81 @@ + + +Sequel Pro Help - SQL Query Examples + + + + + + + + +
+ + + + + + + + + +
+ +

SQL Query Examples

+
+ +
+ +
+ + Back to the main menu +
+
+ + + + +
+ + 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. + +
+
+
+ + + + + + + +
+ + Example SELECT Query +
+ This obtains information an account table and only returns the accounts with logins of 1 or more, + ordered alphabetically by the person's name. +
+
+ SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name +
+ +
+ + Example DELETE Query +
+ This query deletes one row of data from a product table. +
+
+ DELETE FROM products WHERE ProductID=5 LIMIT 1 +
+ +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/sample_tables.html b/Interfaces/English.lproj/Help/topics/sample_tables.html new file mode 100755 index 00000000..ba61c094 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/sample_tables.html @@ -0,0 +1,374 @@ + + +Sequel Pro Help - SQL Table Examples + + + + + + + + +
+ + + + + + + + + +
+ +

SQL Table Examples

+
+ +
+ +
+ + Back to the main menu +
+
+ + + + +
+ + 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. +
+ 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). + +
+
+
+ + + + + +
+ + Example Accounts Database Table +
+ 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. +
+
+
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ tblAccounts +
+  AccountID + + INTEGER + + 11 +
+  Name + + VARCHAR + + 200 +
+  Login + + VARCHAR + + 12 +
+  Password + + VARCHAR + + 32 +
+  Locked + + TINYINT + + +
+  LoginCount + + INTEGER + + 11 +
+  LastLogin + + DATETIME + + +
+  Created + + DATETIME + + +
+  CreatedBy + + VARCHAR + + 200 +
+  Updated + + DATETIME + +
+  UpdatedBy + + VARCHAR + + 200 +
+
+
+ * The AccountID is a PRIMARY KEY (also UNIQUE) +
+ * The Password is MD5 encrypted, hence the length of 32 +
+ * The Locked value is either zero (0) or one (1) + + 		+ + Example Products Database Table +
+ 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. +
+
+
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ tblProducts +
+  ProductID + + INTEGER + + 11 +
+  Name + + VARCHAR + + 200 +
+  ShortDescription + + VARCHAR + + 250 +
+  LongDescription + + TEXT + + +
+  Price + + DECIMAL(9,2) + + +
+  ImageURL + + VARCHAR + + 250 +
+  Locked + + TINYINT + + +
+  ViewCount + + INTEGER + + 11 +
+  LastViewed + + DATETIME + + +
+  Created + + DATETIME + + +
+  CreatedBy + + VARCHAR + + 200 +
+  Updated + + DATETIME + +
+  UpdatedBy + + VARCHAR + + 200 +
+
+
+ * The ProductID is a PRIMARY KEY (also UNIQUE) +
+ * The ImageURL points to an image of the product +
+ * The Locked value is either zero (0) or one (1) + +
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/sequel-pro_logo.jpg b/Interfaces/English.lproj/Help/topics/sequel-pro_logo.jpg new file mode 100644 index 00000000..18d9f2da Binary files /dev/null and b/Interfaces/English.lproj/Help/topics/sequel-pro_logo.jpg differ diff --git a/Interfaces/English.lproj/Help/topics/syntax.html b/Interfaces/English.lproj/Help/topics/syntax.html new file mode 100755 index 00000000..39c4da72 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/syntax.html @@ -0,0 +1,49 @@ + + +Sequel Pro Help - Table Syntax Generation + + + + + + + + +
+ + + + + + + + + +
+ +

Table Syntax Generation

+
+ +
+ +
+ + Back to the main menu +
+
+ + 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. +
+
+ + + + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/Help/topics/tables.html b/Interfaces/English.lproj/Help/topics/tables.html new file mode 100755 index 00000000..3840bb26 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/tables.html @@ -0,0 +1,89 @@ + + +Sequel Pro Help - Managing Tables + + + + + + + + +
+ + + + + + + + + +
+ +

Managing Tables

+
+ +
+ +
+ + Back to the main menu +
+
+ + In order to perform actions with tables, you must first choose the "Structure" tab. +
+
+Adding and Editing Fields + + + + +
+ +
    +
  • Add fields with the plus-button and drop them with the minus-button.
    • +
  • Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.
    • +
  • Changes aren't written to the database until you deselect the row!
    • +
  • You can also drag & drop fields to change their order (if they are not indexed).
    • +
+
+ +
+
+Adding, editing, removing and copying tables + + + + +
+ +
    +
  • Add or remove tables with the plus- and minus-buttons.
    • +
  • 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.
    • +
  • Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.
    • +
  • 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.
    • +
+
+ +
+
+Adding and editing indexes + + + + +
+ +
    +
  • Add indexes with the plus-button and drop them with the minus-button.
    • +
  • 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.
    • +
  • 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!).
    • +
+
+ + + + + \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/bar.gif b/Interfaces/English.lproj/english_help/bar.gif deleted file mode 100644 index f716f3f9..00000000 Binary files a/Interfaces/English.lproj/english_help/bar.gif and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/english_help idx b/Interfaces/English.lproj/english_help/english_help idx deleted file mode 100644 index beac9c4d..00000000 Binary files a/Interfaces/English.lproj/english_help/english_help idx and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/icon.gif b/Interfaces/English.lproj/english_help/icon.gif deleted file mode 100644 index 70f30b35..00000000 Binary files a/Interfaces/English.lproj/english_help/icon.gif and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/index.html b/Interfaces/English.lproj/english_help/index.html deleted file mode 100755 index 265dd630..00000000 --- a/Interfaces/English.lproj/english_help/index.html +++ /dev/null @@ -1,99 +0,0 @@ - - -Sequel Pro Help - - - - - - - - - -
- - - - - - - - - -
- - -

Sequel Pro Help

-
- -
- -
- - - - - - -
- - Topics -
- - Connecting to a Database -
- Managing Tables (Creation, Deletion, Changes) -
- Data Management -
- Performing Custom Queries -
- Data Dumps (CSV, XML) -
- Setting Preferences -
- Console -
- Encoding -
- Table Syntax Generation -
- SQL Table examples -
- SQL Query examples -
- MySQL SQL Reference -
- - - 		- - Sequel Pro Website -
- - http://code.google.com/p/sequel-pro/ - -
-
-
- Developers and Contributors -
- Abhi Beckert, Matt Langtree, Lorenz Textor, Jeff Skrysak, Walter Lee Davis, Tristan O'Tierney, Kotaro Funakoshi, David Buxton, Stuart B. Glenn, Jason Hallford, snowhouse, MySQL Cocoa project -
-
-
- MySQL Websites -
- - http://www.mysql.com/ -
- http://www.serverlogistics.com/mysql.php - -
- -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/sequel-pro_logo.jpg b/Interfaces/English.lproj/english_help/sequel-pro_logo.jpg deleted file mode 100644 index 18d9f2da..00000000 Binary files a/Interfaces/English.lproj/english_help/sequel-pro_logo.jpg and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/topics/bar.gif b/Interfaces/English.lproj/english_help/topics/bar.gif deleted file mode 100644 index f716f3f9..00000000 Binary files a/Interfaces/English.lproj/english_help/topics/bar.gif and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/topics/connect.html b/Interfaces/English.lproj/english_help/topics/connect.html deleted file mode 100755 index 2fbe0864..00000000 --- a/Interfaces/English.lproj/english_help/topics/connect.html +++ /dev/null @@ -1,59 +0,0 @@ - - -Sequel Pro Help - Connecting to a Database - - - - - - - - -
- - - - - - - - - -
- -

Connecting to a Database

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
- - - - - -
- -
    -
  • Enter at least the host (IP or domain name). To connect to a local database, enter localhost or 127.0.0.1 as host.
    • -
  • 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.
    • -
  • If you enter no port, Sequel Pro uses the default port.
    • -
  • 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.
    • -
  • You can connect to multiple databases by opening a new window (Menu File > New)
    • -
- 		- -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/connect.jpg b/Interfaces/English.lproj/english_help/topics/connect.jpg deleted file mode 100644 index e9c1ab6e..00000000 Binary files a/Interfaces/English.lproj/english_help/topics/connect.jpg and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/topics/console.html b/Interfaces/English.lproj/english_help/topics/console.html deleted file mode 100755 index 1269dc38..00000000 --- a/Interfaces/English.lproj/english_help/topics/console.html +++ /dev/null @@ -1,48 +0,0 @@ - - -Sequel Pro Help - Actions Console - - - - - - - - -
- - - - - - - - - -
- -

Console

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
- - - - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/data.html b/Interfaces/English.lproj/english_help/topics/data.html deleted file mode 100755 index 14aaeb9f..00000000 --- a/Interfaces/English.lproj/english_help/topics/data.html +++ /dev/null @@ -1,92 +0,0 @@ - - -Sequel Pro Help - Data Management - - - - - - - - -
- - - - - - - - - -
- -

Data Management

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
-Adding and editing fields - - - - -
- -
    -
  • Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.
    • -
  • 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.
    • -
  • Use the value specified in the preferences (NULL by default) to enter NULL-values.
    • -
  • Changes aren't written to the database until you deselect the row!
    • -
  • It is recommended that you edit only tables which have a primary key.
    • -
-
- -
-
-Sorting and filtering the table content - - - - -
- -
    -
  • To sort a table by a field, click on the header of the appropriate column in the content-view.
    • -
  • Click on it twice to sort the table in descending order.
    • -
  • Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.
    • -
  • As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)
    • -
  • If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".
    • -
-
- -
-
-Binary Data (Images, Strings, Hex Representations) - - - - -
- -
    -
  • Field type should be Blob or Longblob
    • -
  • To edit/enter the data, double select the field in the Content tab
    • -
  • Click on Open and load an image
    • -
  • Change to image and hex view
    • -
-
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/dump.html b/Interfaces/English.lproj/english_help/topics/dump.html deleted file mode 100755 index 99123b69..00000000 --- a/Interfaces/English.lproj/english_help/topics/dump.html +++ /dev/null @@ -1,93 +0,0 @@ - - -Sequel Pro Help - Data Dumps - - - - - - - - -
- - - - - - - - - -
- -

Data Dumps

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
-CSV File Format Information - - - - -
- -
    -
  • You can choose the following characters: fields enclosed, fields terminated, escaped and line ends
    • -
  • 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
    • -
  • NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.
    • -
  • When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)
    • -
  • The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer).
    • -
-
- -
-Importing Dumps - - - - -
- -
    -
  • Choose "File->Import" from the Sequel Pro Menu
    • -
  • You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)
    • -
-
- - -
-Excel CSV Formatting Options -
-If you wish to export data to a CSV file for use in Excel, use the following settings: - - - - -
- -
    -
  • Enclosed by: " (single quote)
    • -
  • Escaped by: " (single quote)
    • -
  • Line ends: \r (for Macs)
    • -
  • Delimiter: , (comma)
    • -
-
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/encoding.html b/Interfaces/English.lproj/english_help/topics/encoding.html deleted file mode 100755 index adaed683..00000000 --- a/Interfaces/English.lproj/english_help/topics/encoding.html +++ /dev/null @@ -1,73 +0,0 @@ - - -Sequel Pro Help - Text Encoding - - - - - - - - -
- - - - - - - - - -
- -

Text Encoding

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
-In the Preferences Pane - - - - -
- -
    -
  • Open up the "Preferences Pane" of Sequel Pro
    • -
  • From the pull-down at the bottom left of the preferences window, labelled "Default Encoding", choose an option.
    • -
  • The encoding you choose will be the default encoding for all future databases
    • -
-
-
-In the Application Window - - - - -
- -
    -
  • In the main application window there will be a pull-down at the bottom left of the window labelled "Encoding".
    • -
  • From the pull-down choose an encoding option.
    • -
  • The encoding you choose will be the default encoding for all future databases
    • -
-
- - - - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/preferences.html b/Interfaces/English.lproj/english_help/topics/preferences.html deleted file mode 100755 index 0350d76b..00000000 --- a/Interfaces/English.lproj/english_help/topics/preferences.html +++ /dev/null @@ -1,58 +0,0 @@ - - -Sequel Pro Help - Setting Preferences - - - - - - - - -
- - - - - - - - - -
- -

Setting Preferences

-
- -
- -
- - Back to the main menu -
-
- -
- - - - - -
- -
    -
  • 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.
    • -
  • Choose if you want Sequel Pro to show an error message if no rows have been affected after adding or editing a row.
    • -
  • 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).
    • -
  • 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.
    • -
  • Select a value that is displayed and used to enter NULL-values.
    • -
  • Add favorites used to quickly connect to a MySQL database. Drag&drop them to change their order. Double-click to edit a favorite. Passwords are stored in the Keychain.
    • -
- 		- -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/preferences.jpg b/Interfaces/English.lproj/english_help/topics/preferences.jpg deleted file mode 100644 index 64ae8e10..00000000 Binary files a/Interfaces/English.lproj/english_help/topics/preferences.jpg and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/topics/query.html b/Interfaces/English.lproj/english_help/topics/query.html deleted file mode 100755 index bb628047..00000000 --- a/Interfaces/English.lproj/english_help/topics/query.html +++ /dev/null @@ -1,58 +0,0 @@ - - -Sequel Pro Help - Performing Custom Queries - - - - - - - - -
- - - - - - - - - -
- -

Performing Custom Queries

-
- -
- -
- - Back to the main menu -
-
- - In order to perform a SQL query you must first choose the "Custom Query" tab. -
-
- - - - -
- -
    -
  • Enter your query and click on the "Run Query" button.
    • -
  • The result, if there is one, is displayed in the bottom view.
    • -
  • Under "Last Error Message" you can see the last error message returned by MySQL, if there is one.
    • -
  • Add your query to the favorites or select a favorite query with the favorites pop-up-button.
    • -
  • Select one of the last 20 queries with the history pop-up-button.
    • -
  • 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.
    • -
  • 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.
    • -
-
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/reference.html b/Interfaces/English.lproj/english_help/topics/reference.html deleted file mode 100755 index b746bed9..00000000 --- a/Interfaces/English.lproj/english_help/topics/reference.html +++ /dev/null @@ -1,212 +0,0 @@ - - -Sequel Pro Help - MySQL SQL Referernce - - - - - - - - -
- - - - - - - - - -
- -

MySQL SQL Reference

-
- -
- -
- - Back to the main menu -
-
- - - - -
- - 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. - -
- -
- - - - - -
- - Commands -
- CREATE DATABASE [IF NOT EXISTS] name -
- CREATE [UNIQUE|FULLTEXT] INDEX name ON table (column,..) -
- CREATE TABLE [IF NOT EXISTS] name -
- DELETE FROM table [WHERE clause] [LIMIT n] -
- DROP DATABASE [IF EXISTS] name -
- DROP TABLE [IF EXISTS] name -
- GRANT privilege ON table TO user -
- INSERT [INTO] table [ (column, ...) ] VALUES (values, ...) -
- LOAD DATA INFILE file INTO TABLE name -
- SELECT [DISTINCT|ALL| |] FROM table [WHERE clause ] -
- UPDATE table SET column=value,... [WHERE clause] [LIMIT n] -
-
- Logical Operators -
- NOT or  ! - performs a logical not -
- OR or | | - performs a logical or -
- XOR - performs a logical exclusive or -
- AND or && - performs a logical and - - 		- - Aggregate Functions -
- AVG(expression) -
- BIT_AND(expression) -
- BIT_OR(expression) -
- COUNT(expression) -
- MAX(expression) -
- MIN(expression) -
- STD(expression)/STDDEV(expression) -
- SUM(expression) -
-
- General Functions -
- ABS(number) -
- ACOS(number) -
- ADDDATE(date, INTERVAL, amount, type) -
- ASCII(char) -
- ASIN(number) -
- ATAN(number) -
- ATAN2(x, y) -
- BENCHMARK(num, function) -
- BIN((decimal) -
- BIT_COUNT(number) -
- BIT_LENGTH(number) -
- CEILING(number) -
- CHAR_LENGTH(string) -
- COS(radians) -
- COT(radians) -
- CURDATE() -
- CURTIME() -
- DATABASE() -
- DATE_FORMAT(date, format) -
- DAYNAME(date) -
- DAYOFMONTH(date) -
- DAYOFWEEK(date) -
- DAYOFYEAR(date) -
- EXP(power) -
- FLOOR(number) -
- FORMAT(number, decimals) -
- HOUR(time) -
- LENGTH(string) -
- LOG(number) -
- LOWER(number) -
- MD5(string) -
- MINUTE(time) -
- MONTH(date) -
- MONTHNAME(date) -
- NOW() -
- PASSWORD(string) -
- QUARTER(date) -
- REVERSE(string) -
- SECOND(time) -
- SIGN(number) -
- SPACE(number) -
- SQRT(number) -
- UPPER(string) -
- VERSION() -
- WEEK(date) -
- WEEKDAY(date) -
- YEAR(date) - -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/sample_query.html b/Interfaces/English.lproj/english_help/topics/sample_query.html deleted file mode 100755 index 66b249fd..00000000 --- a/Interfaces/English.lproj/english_help/topics/sample_query.html +++ /dev/null @@ -1,81 +0,0 @@ - - -Sequel Pro Help - SQL Query Examples - - - - - - - - -
- - - - - - - - - -
- -

SQL Query Examples

-
- -
- -
- - Back to the main menu -
-
- - - - -
- - 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. - -
-
-
- - - - - - - -
- - Example SELECT Query -
- This obtains information an account table and only returns the accounts with logins of 1 or more, - ordered alphabetically by the person's name. -
-
- SELECT * FROM accounts WHERE LoginCount > 1 ORDER BY Name -
- -
- - Example DELETE Query -
- This query deletes one row of data from a product table. -
-
- DELETE FROM products WHERE ProductID=5 LIMIT 1 -
- -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/sample_tables.html b/Interfaces/English.lproj/english_help/topics/sample_tables.html deleted file mode 100755 index ba61c094..00000000 --- a/Interfaces/English.lproj/english_help/topics/sample_tables.html +++ /dev/null @@ -1,374 +0,0 @@ - - -Sequel Pro Help - SQL Table Examples - - - - - - - - -
- - - - - - - - - -
- -

SQL Table Examples

-
- -
- -
- - Back to the main menu -
-
- - - - -
- - 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. -
- 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). - -
-
-
- - - - - -
- - Example Accounts Database Table -
- 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. -
-
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- tblAccounts -
-  AccountID - - INTEGER - - 11 -
-  Name - - VARCHAR - - 200 -
-  Login - - VARCHAR - - 12 -
-  Password - - VARCHAR - - 32 -
-  Locked - - TINYINT - - -
-  LoginCount - - INTEGER - - 11 -
-  LastLogin - - DATETIME - - -
-  Created - - DATETIME - - -
-  CreatedBy - - VARCHAR - - 200 -
-  Updated - - DATETIME - -
-  UpdatedBy - - VARCHAR - - 200 -
-
-
- * The AccountID is a PRIMARY KEY (also UNIQUE) -
- * The Password is MD5 encrypted, hence the length of 32 -
- * The Locked value is either zero (0) or one (1) - - 		- - Example Products Database Table -
- 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. -
-
-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- tblProducts -
-  ProductID - - INTEGER - - 11 -
-  Name - - VARCHAR - - 200 -
-  ShortDescription - - VARCHAR - - 250 -
-  LongDescription - - TEXT - - -
-  Price - - DECIMAL(9,2) - - -
-  ImageURL - - VARCHAR - - 250 -
-  Locked - - TINYINT - - -
-  ViewCount - - INTEGER - - 11 -
-  LastViewed - - DATETIME - - -
-  Created - - DATETIME - - -
-  CreatedBy - - VARCHAR - - 200 -
-  Updated - - DATETIME - -
-  UpdatedBy - - VARCHAR - - 200 -
-
-
- * The ProductID is a PRIMARY KEY (also UNIQUE) -
- * The ImageURL points to an image of the product -
- * The Locked value is either zero (0) or one (1) - -
- - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/sequel-pro_logo.jpg b/Interfaces/English.lproj/english_help/topics/sequel-pro_logo.jpg deleted file mode 100644 index 18d9f2da..00000000 Binary files a/Interfaces/English.lproj/english_help/topics/sequel-pro_logo.jpg and /dev/null differ diff --git a/Interfaces/English.lproj/english_help/topics/syntax.html b/Interfaces/English.lproj/english_help/topics/syntax.html deleted file mode 100755 index 39c4da72..00000000 --- a/Interfaces/English.lproj/english_help/topics/syntax.html +++ /dev/null @@ -1,49 +0,0 @@ - - -Sequel Pro Help - Table Syntax Generation - - - - - - - - -
- - - - - - - - - -
- -

Table Syntax Generation

-
- -
- -
- - Back to the main menu -
-
- - 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. -
-
- - - - - - - \ No newline at end of file diff --git a/Interfaces/English.lproj/english_help/topics/tables.html b/Interfaces/English.lproj/english_help/topics/tables.html deleted file mode 100755 index 3840bb26..00000000 --- a/Interfaces/English.lproj/english_help/topics/tables.html +++ /dev/null @@ -1,89 +0,0 @@ - - -Sequel Pro Help - Managing Tables - - - - - - - - -
- - - - - - - - - -
- -

Managing Tables

-
- -
- -
- - Back to the main menu -
-
- - In order to perform actions with tables, you must first choose the "Structure" tab. -
-
-Adding and Editing Fields - - - - -
- -
    -
  • Add fields with the plus-button and drop them with the minus-button.
    • -
  • Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.
    • -
  • Changes aren't written to the database until you deselect the row!
    • -
  • You can also drag & drop fields to change their order (if they are not indexed).
    • -
-
- -
-
-Adding, editing, removing and copying tables - - - - -
- -
    -
  • Add or remove tables with the plus- and minus-buttons.
    • -
  • 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.
    • -
  • Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.
    • -
  • 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.
    • -
-
- -
-
-Adding and editing indexes - - - - -
- -
    -
  • Add indexes with the plus-button and drop them with the minus-button.
    • -
  • 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.
    • -
  • 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!).
    • -
-
- - - - - \ No newline at end of file diff --git a/sequel-pro.xcodeproj/project.pbxproj b/sequel-pro.xcodeproj/project.pbxproj index 0decedac..54069256 100644 --- a/sequel-pro.xcodeproj/project.pbxproj +++ b/sequel-pro.xcodeproj/project.pbxproj @@ -703,7 +703,7 @@ name = "Other Frameworks"; sourceTree = ""; }; - 1703EF2A0F0B0742005BBE7E /* english_help */ = { + 1703EF2A0F0B0742005BBE7E /* Help */ = { isa = PBXGroup; children = ( 1703EF2B0F0B0742005BBE7E /* bar.gif */, @@ -713,8 +713,8 @@ 1703EF2F0F0B0742005BBE7E /* sequel-pro_logo.jpg */, 1703EF300F0B0742005BBE7E /* topics */, ); - name = english_help; - path = Interfaces/English.lproj/english_help; + name = Help; + path = Interfaces/English.lproj/Help; sourceTree = SOURCE_ROOT; }; 1703EF300F0B0742005BBE7E /* topics */ = { @@ -903,7 +903,7 @@ children = ( 1740F8370FC306C900CF3699 /* Plists */, 17E6418B0EF01FF7001BC333 /* Images */, - 1703EF2A0F0B0742005BBE7E /* english_help */, + 1703EF2A0F0B0742005BBE7E /* Help */, 1740F8360FC306AE00CF3699 /* Scripting */, 1740F8350FC3069700CF3699 /* Templates */, 384582BC0FB95C9100DDACB6 /* Localizable.strings */, -- cgit v1.2.3