src/hg/makeDb/doc/sacCer2.txt 1.14

Index: src/hg/makeDb/doc/sacCer2.txt
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/makeDb/doc/sacCer2.txt,v
retrieving revision 1.13
retrieving revision 1.14
diff -b -B -U 4 -r1.13 -r1.14
--- src/hg/makeDb/doc/sacCer2.txt	15 Jul 2009 14:05:50 -0000	1.13
+++ src/hg/makeDb/doc/sacCer2.txt	22 Jul 2009 17:35:50 -0000	1.14
@@ -1349,5 +1349,15 @@
 	mysql> delete from sgdToName where name= "YGR272C";
 	mysql> delete from sgdToName where name= "YLR157W-A";
 	mysql> delete from sgdToName where name= "YLR157W-C";
 	mysql> delete from sgdToName where name= "YNL097C-A";
+
+############################################################################
+# for some unknown reason, indexes missing on chrM_gold and chrM_gap
+#	maybe because they have only one and zero items ?
+#		(DONE - 2009-07-21 - Hiram)
+    hgsql -e "alter table chrM_gold add index chromStart (chromStart);" sacCer2
+    hgsql -e "alter table chrM_gold add index bin (bin);" sacCer2
+    hgsql -e "alter table chrM_gold add index frag (frag(9));" sacCer2
+    hgsql -e "alter table chrM_gap add index chromStart (chromStart);" sacCer2
+    hgsql -e "alter table chrM_gap add index bin (bin);" sacCer2
 ############################################################################