www

commit d4acec8a7732dd6869c77f022f1c255a71f8e1f0
parent fc589a37cfaade0aab9f1ba37b8990a5d9c288e3
Author: Dan Stillman <dstillman@zotero.org>
Date:   Sun,  6 Aug 2006 16:10:28 +0000

Addresses #111, minor modifications to field list schema, and http://chnm.grouphub.com/P2995041

Still some outstanding questions on Basecamp, though


Diffstat:
M
chrome/chromeFiles/content/scholar/xpcom/schema.js
 | 
4
++--
M
chrome/chromeFiles/locale/en-US/scholar/scholar.properties
 | 
9
+++++----
M
schema.sql
 | 
21
++++++++++++---------

3 files changed, 19 insertions(+), 15 deletions(-)
diff --git a/chrome/chromeFiles/content/scholar/xpcom/schema.js b/chrome/chromeFiles/content/scholar/xpcom/schema.js
@@ -391,7 +391,7 @@ Scholar.Schema = new function(){
 		//
 		// Change this value to match the schema version
 		//
-		var toVersion = 32;
+		var toVersion = 33;
 		
 		if (toVersion != _getSchemaSQLVersion()){
 			throw('Schema version does not match version in _migrateSchema()');
@@ -415,7 +415,7 @@ Scholar.Schema = new function(){
 				}
 			}
 			
-			if (i==32){
+			if (i==33){
 				_initializeSchema();
 			}
 		}
diff --git a/chrome/chromeFiles/locale/en-US/scholar/scholar.properties b/chrome/chromeFiles/locale/en-US/scholar/scholar.properties
@@ -34,16 +34,16 @@ itemFields.dateModified 		= Modified
 itemFields.source       		= Source
 itemFields.rights       		= Rights
 itemFields.notes       			= Notes
-itemFields.series       		= Series
+itemFields.seriesTitle    		= Series Title
 itemFields.volume       		= Volume
-itemFields.number       		= Number
+itemFields.issue	       		= Issue
 itemFields.edition      		= Edition
 itemFields.place        		= Place
 itemFields.publisher    		= Publisher
 itemFields.year         		= Year
 itemFields.pages        		= Pages
 itemFields.ISBN         		= ISBN
-itemFields.publication  		= Publication
+itemFields.publicationTitle	= Publication Title
 itemFields.ISSN         		= ISSN
 itemFields.date					= Date
 itemFields.section				= Section
@@ -57,7 +57,8 @@ itemFields.type					= Type
 itemFields.callNumber			= Call Number
 itemFields.extra				= Extra
 itemFields.journalAbbreviation	= Journal Abbreviation
-itemFields.DOIName				= DOI Name
+itemFields.DOI					= DOI
+itemFields.lastModified			= Last Modified
 
 itemTypes.note					= Note
 itemTypes.book					= Book
diff --git a/schema.sql b/schema.sql
@@ -1,4 +1,4 @@
--- 32
+-- 33
 
     DROP TABLE IF EXISTS version;
     CREATE TABLE version (
@@ -262,16 +262,16 @@
     
     INSERT INTO fields VALUES (1,'source',NULL);
     INSERT INTO fields VALUES (2,'rights',NULL);
-    INSERT INTO fields VALUES (3,'series',NULL);
+    INSERT INTO fields VALUES (3,'seriesTitle',NULL);
     INSERT INTO fields VALUES (4,'volume',NULL);
-    INSERT INTO fields VALUES (5,'number',NULL);
+    INSERT INTO fields VALUES (5,'issue',NULL);
     INSERT INTO fields VALUES (6,'edition',NULL);
     INSERT INTO fields VALUES (7,'place',NULL);
     INSERT INTO fields VALUES (8,'publisher',NULL);
     INSERT INTO fields VALUES (9,'year',3);
     INSERT INTO fields VALUES (10,'pages',NULL);
     INSERT INTO fields VALUES (11,'ISBN',NULL);
-    INSERT INTO fields VALUES (12,'publication',NULL);
+    INSERT INTO fields VALUES (12,'publicationTitle',NULL);
     INSERT INTO fields VALUES (13,'ISSN',NULL);
     INSERT INTO fields VALUES (14,'date',NULL);
     INSERT INTO fields VALUES (15,'section',NULL);
@@ -285,7 +285,9 @@
     INSERT INTO fields VALUES (23,'url',NULL);
     INSERT INTO fields VALUES (24,'type',NULL);
     INSERT INTO fields VALUES (25,'journalAbbreviation',NULL);
-    INSERT INTO fields VALUES (26,'DOIName',NULL);
+    INSERT INTO fields VALUES (26,'DOI',NULL);
+    INSERT INTO fields VALUES (27,'accessDate',NULL);
+    INSERT INTO fields VALUES (28,'lastModified',NULL);
     
     INSERT INTO "itemTypeFields" VALUES(2, 1, 12);
     INSERT INTO "itemTypeFields" VALUES(2, 2, 13);
@@ -360,9 +362,8 @@
     INSERT INTO "itemTypeFields" VALUES(12, 2, 6);
     INSERT INTO "itemTypeFields" VALUES(12, 24, 1);
     INSERT INTO "itemTypeFields" VALUES(12, 14, 2);
-    INSERT INTO "itemTypeFields" VALUES(13, 1, 3);
-    INSERT INTO "itemTypeFields" VALUES(13, 2, 4);
-    INSERT INTO "itemTypeFields" VALUES(13, 14, 2);
+    INSERT INTO "itemTypeFields" VALUES(13, 1, 4);
+    INSERT INTO "itemTypeFields" VALUES(13, 2, 5);
     INSERT INTO "itemTypeFields" VALUES(13, 23, 1);
     INSERT INTO "itemTypeFields" VALUES(12, 18, 3);
     INSERT INTO "itemTypeFields" VALUES(2, 18, 10);
@@ -396,9 +397,11 @@
     INSERT INTO "itemTypeFields" VALUES(6, 22, 11);
     INSERT INTO "itemTypeFields" VALUES(7, 18, 5);
     INSERT INTO "itemTypeFields" VALUES(7, 22, 9);
-    INSERT INTO "itemTypeFields" VALUES(13, 22, 5);
+    INSERT INTO "itemTypeFields" VALUES(13, 22, 6);
     INSERT INTO "itemTypeFields" VALUES(4, 25, 5);
     INSERT INTO "itemTypeFields" VALUES(4, 26, 6);
+    INSERT INTO "itemTypeFields" VALUES(13, 27, 3);
+    INSERT INTO "itemTypeFields" VALUES(13, 28, 2);
     
     INSERT INTO "charsets" VALUES(1, 'utf-8');
     INSERT INTO "charsets" VALUES(2, 'ascii');