www

commit 3b402c564cb3bb4a41a9486f8522c8793dfdd2fb
parent 49068d1d3578542163847e721c59a5ed5e82578e
Author: Dan Stillman <dstillman@zotero.org>
Date:   Sat,  6 Feb 2016 04:12:07 -0500

Closes #900, Change fields order for cases in system.sql

Diffstat:
M
chrome/content/zotero/xpcom/schema.js
 | 
11
+++++++++++
M
resource/schema/system.sql
 | 
14
+++++++-------
M
resource/schema/userdata.sql
 | 
2
+-

3 files changed, 19 insertions(+), 8 deletions(-)
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -2203,6 +2203,17 @@ Zotero.Schema = new function(){
 				
 				yield Zotero.DB.queryAsync("DELETE FROM version WHERE schema LIKE ?", "storage_%");
 			}
+			
+			if (i == 82) {
+				yield Zotero.DB.queryAsync("DELETE FROM itemTypeFields WHERE itemTypeID=17 AND orderIndex BETWEEN 3 AND 9");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 44, NULL, 3)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 96, NULL, 4)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 117, NULL, 5)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 43, NULL, 6)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 97, NULL, 7)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 98, NULL, 8)");
+				yield Zotero.DB.queryAsync("INSERT INTO itemTypeFields VALUES (17, 42, NULL, 9)");
+			}
 		}
 		
 		yield _updateDBVersion('userdata', toVersion);
diff --git a/resource/schema/system.sql b/resource/schema/system.sql
@@ -594,13 +594,13 @@ INSERT INTO itemTypeFields VALUES (16, 2, NULL, 16);
 INSERT INTO itemTypeFields VALUES (16, 22, NULL, 17);
 INSERT INTO itemTypeFields VALUES (17, 111, NULL, 1);
 INSERT INTO itemTypeFields VALUES (17, 90, NULL, 2);
-INSERT INTO itemTypeFields VALUES (17, 43, NULL, 3);
-INSERT INTO itemTypeFields VALUES (17, 97, NULL, 4);
-INSERT INTO itemTypeFields VALUES (17, 44, NULL, 5);
-INSERT INTO itemTypeFields VALUES (17, 117, NULL, 6);
-INSERT INTO itemTypeFields VALUES (17, 98, NULL, 7);
-INSERT INTO itemTypeFields VALUES (17, 42, NULL, 8);
-INSERT INTO itemTypeFields VALUES (17, 96, NULL, 9);
+INSERT INTO itemTypeFields VALUES (17, 44, NULL, 3);
+INSERT INTO itemTypeFields VALUES (17, 96, NULL, 4);
+INSERT INTO itemTypeFields VALUES (17, 117, NULL, 5);
+INSERT INTO itemTypeFields VALUES (17, 43, NULL, 6);
+INSERT INTO itemTypeFields VALUES (17, 97, NULL, 7);
+INSERT INTO itemTypeFields VALUES (17, 98, NULL, 8);
+INSERT INTO itemTypeFields VALUES (17, 42, NULL, 9);
 INSERT INTO itemTypeFields VALUES (17, 87, NULL, 10);
 INSERT INTO itemTypeFields VALUES (17, 116, NULL, 11);
 INSERT INTO itemTypeFields VALUES (17, 1, NULL, 12);
diff --git a/resource/schema/userdata.sql b/resource/schema/userdata.sql
@@ -1,4 +1,4 @@
--- 81
+-- 82
 
 -- Copyright (c) 2009 Center for History and New Media
 --                    George Mason University, Fairfax, Virginia, USA