From 0f586da34dac2c764a12055158e4929cf69340a1 Mon Sep 17 00:00:00 2001 From: abhibeckert Date: Fri, 4 Apr 2008 11:37:36 +0000 Subject: Initial import from (slightly modified) CocoaMySQL v0.7b4 --- .../english_help/topics/sample_tables.html | 374 +++++++++++++++++++++ 1 file changed, 374 insertions(+) create mode 100755 English.lproj/english_help/topics/sample_tables.html (limited to 'English.lproj/english_help/topics/sample_tables.html') diff --git a/English.lproj/english_help/topics/sample_tables.html b/English.lproj/english_help/topics/sample_tables.html new file mode 100755 index 00000000..908f55aa --- /dev/null +++ b/English.lproj/english_help/topics/sample_tables.html @@ -0,0 +1,374 @@ + + +CocoaMySQL 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