[index] [minor] add indexes
diff --git a/patches/1311/p01_cleanup.py b/patches/1311/p01_cleanup.py
index e4953e6..3fd798a 100644
--- a/patches/1311/p01_cleanup.py
+++ b/patches/1311/p01_cleanup.py
@@ -1,3 +1,6 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
+# License: GNU General Public License v3. See license.txt
+
import webnotes
def execute():
diff --git a/patches/1311/p02_index_singles.py b/patches/1311/p02_index_singles.py
new file mode 100644
index 0000000..94fb197
--- /dev/null
+++ b/patches/1311/p02_index_singles.py
@@ -0,0 +1,10 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
+# License: GNU General Public License v3. See license.txt
+
+def execute():
+ import webnotes
+ if not webnotes.conn.sql("""show index from `tabSingles`
+ where Key_name="singles_doctype_field_index" """):
+ webnotes.conn.commit()
+ webnotes.conn.sql("""alter table `tabSingles`
+ add index singles_doctype_field_index(`doctype`, `field`)""")
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 5227118..d37ed4c 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -241,4 +241,8 @@
"execute:webnotes.reload_doc('website', 'doctype', 'table_of_contents') #2013-11-13",
"execute:webnotes.reload_doc('website', 'doctype', 'web_page') #2013-11-13",
"execute:webnotes.bean('Style Settings').save() #2013-11-13",
+ "execute:webnotes.reload_doc('home', 'doctype', 'feed') #2013-11-15",
+ "execute:webnotes.reload_doc('core', 'doctype', 'defaultvalue') #2013-11-15",
+ "execute:webnotes.reload_doc('core', 'doctype', 'comment') #2013-11-15",
+ "patches.1311.p02_index_singles",
]
\ No newline at end of file