diff options
Diffstat (limited to 'Resources/Help/topics/sample_tables.html')
| -rwxr-xr-x | Resources/Help/topics/sample_tables.html | 374 |
1 files changed, 0 insertions, 374 deletions
diff --git a/Resources/Help/topics/sample_tables.html b/Resources/Help/topics/sample_tables.html deleted file mode 100755 index ba61c094..00000000 --- a/Resources/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"> - <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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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"> - 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 |