c5374e4c9019d2b22513f53867edd3f1802a8630
kent
  Fri Apr 19 13:17:42 2013 -0700
Adding docs and test cases for index and autoincrement feature.
diff --git src/hg/autoSql/doc.as src/hg/autoSql/doc.as
index 5883e03..b60ee33 100644
--- src/hg/autoSql/doc.as
+++ src/hg/autoSql/doc.as
@@ -1,17 +1,17 @@
 table addressBook
 "A simple address book"
     (
-    string name;  "Name - first or last or both, we don't care"
+    string name primary;  "Name - first or last or both, we don't care"
     string address;  "Street address"
-    string city;  "City"
+    string city index[6];  "City"
     uint zipCode;  "A zip code is always positive, so can be unsigned"
-    char[2] state;  "Just store the abbreviation for the state"
+    char[2] state index;  "Just store the abbreviation for the state"
     )
 
 table symbolCols
 "example of enum and set symbolic columns"
     (
-    int id;                                          "unique id"
+    int id primary auto;                                          "unique id"
     enum(male, female) sex;                          "enumerated column"
-    set(cProg,javaProg,pythonProg,awkProg) skills;   "set column"
+    set(cProg,javaProg,pythonProg,awkProg) skills index;   "set column"
     )