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. --- .../English.lproj/Help/topics/sample_tables.html | 374 +++++++++++++++++++++ 1 file changed, 374 insertions(+) create mode 100755 Interfaces/English.lproj/Help/topics/sample_tables.html (limited to 'Interfaces/English.lproj/Help/topics/sample_tables.html') 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 -- cgit v1.2.3