[patch] [minor] unsubmit serial nos if submitted
diff --git a/patches/patch_list.py b/patches/patch_list.py
index f0a26d2..7041ba8 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -217,4 +217,5 @@
"patches.september_2013.p03_move_website_to_framework",
"execute:webnotes.bean('Style Settings').save() #2013-09-19",
"execute:webnotes.conn.set_value('Accounts Settings', None, 'frozen_accounts_modifier', 'Accounts Manager') # 2013-09-24",
+ "patches.september_2013.p04_unsubmit_serial_nos",
]
\ No newline at end of file
diff --git a/patches/september_2013/p04_unsubmit_serial_nos.py b/patches/september_2013/p04_unsubmit_serial_nos.py
new file mode 100644
index 0000000..ded4e4d
--- /dev/null
+++ b/patches/september_2013/p04_unsubmit_serial_nos.py
@@ -0,0 +1,7 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+import webnotes
+def execute():
+ webnotes.conn.sql("""update `tabSerial No` set docstatus=0 where docstatus=1""")
\ No newline at end of file