commit c59dcdc0a6572369e3b7ca5755ce39746543c452
parent 589f1a6f2034b3c22225690a2ead15d4f1a5e4e2
Author: Dan Stillman <dstillman@zotero.org>
Date: Thu, 5 Oct 2006 22:27:29 +0000
New item types, fields, creator types, and the glue to make them work
If anyone's out there, now would be the time to test this.
Missing icons for the new types -- I could try to get some of those now, or we could just launch. Maybe we'll just launch. But really, might want to test this. Just sayin'.
Diffstat:
9 files changed, 784 insertions(+), 226 deletions(-)
diff --git a/chrome/content/zotero/itemPane.js b/chrome/content/zotero/itemPane.js
@@ -94,17 +94,6 @@ var ZoteroItemPane = new function()
_tagsBox = document.getElementById('editpane-tags');
_relatedBox = document.getElementById('editpane-related');
- var creatorTypes = Zotero.CreatorTypes.getTypes();
- for(var i = 0; i < creatorTypes.length; i++)
- {
- var menuitem = document.createElement("menuitem");
- menuitem.setAttribute("label",Zotero.getString('creatorTypes.'+creatorTypes[i]['name']));
- menuitem.setAttribute("typeid",creatorTypes[i]['id']);
- if(creatorTypes[i]['id'] == 0)
- menuitem.setAttribute("selected",true);
- _creatorTypeMenu.appendChild(menuitem);
- }
-
var itemTypes = Zotero.ItemTypes.getTypes();
for(var i = 0; i<itemTypes.length; i++)
if(itemTypes[i]['name'] != 'note' && itemTypes[i]['name'] != 'attachment')
@@ -216,6 +205,32 @@ var ZoteroItemPane = new function()
}
document.getElementById('tb-openurl').setAttribute('disabled', !openURL);
+ // Clear and rebuild creator type menu
+ while(_creatorTypeMenu.hasChildNodes())
+ {
+ _creatorTypeMenu.removeChild(_creatorTypeMenu.firstChild);
+ }
+
+ var creatorTypes = Zotero.CreatorTypes.getTypesForItemType(_itemBeingEdited.getType());
+ var localized = [];
+ for (var i in creatorTypes)
+ {
+ localized[creatorTypes[i]['name']]
+ = Zotero.getString('creatorTypes.' + creatorTypes[i]['name']);
+ }
+
+ for (var i in localized)
+ {
+ var menuitem = document.createElement("menuitem");
+ menuitem.setAttribute("label", localized[i]);
+ menuitem.setAttribute("typeid", Zotero.CreatorTypes.getID(i));
+ _creatorTypeMenu.appendChild(menuitem);
+ }
+
+
+ //
+ // Clear and rebuild metadata fields
+ //
while(_dynamicFields.hasChildNodes())
_dynamicFields.removeChild(_dynamicFields.firstChild);
@@ -265,7 +280,7 @@ var ZoteroItemPane = new function()
else
{
// Add default row
- addCreatorRow('', '', 1, false, true, true);
+ addCreatorRow('', '', false, false, true, true);
}
var focusMode = 'info';
@@ -451,6 +466,12 @@ var ZoteroItemPane = new function()
}
}
+ // Use the first entry in the drop-down for the default type
+ if (!typeID)
+ {
+ typeID = _creatorTypeMenu.childNodes[0].getAttribute('typeid');
+ }
+
var label = document.createElement("toolbarbutton");
label.setAttribute("label",Zotero.getString('creatorTypes.'+Zotero.CreatorTypes.getName(typeID))+":");
label.setAttribute("popup","creatorTypeMenu");
@@ -524,7 +545,7 @@ var ZoteroItemPane = new function()
}
else
{
- _enablePlusButton(addButton);
+ _enablePlusButton(addButton, typeID);
}
hbox.appendChild(addButton);
@@ -643,11 +664,12 @@ var ZoteroItemPane = new function()
button.setAttribute('onclick', false);
}
- function _enablePlusButton(button)
+ function _enablePlusButton(button, creatorTypeID)
{
button.setAttribute('disabled', false);
button.setAttribute("class","clicky");
- button.setAttribute("onclick","ZoteroItemPane.disableButton(this); ZoteroItemPane.addCreatorRow('','',1,false,true);");
+ button.setAttribute("onclick",
+ "ZoteroItemPane.disableButton(this); ZoteroItemPane.addCreatorRow('',''," + (creatorTypeID ? creatorTypeID : 'false') + ",false,true);");
}
function createValueElement(valueText, fieldName, tabindex)
diff --git a/chrome/content/zotero/xpcom/attachments.js b/chrome/content/zotero/xpcom/attachments.js
@@ -113,7 +113,9 @@ Zotero.Attachments = new function(){
var attachmentItem = Zotero.Items.getNewItemByType(Zotero.ItemTypes.getID('attachment'));
attachmentItem.setField('title', title);
attachmentItem.setField('url', url);
- // TODO: access date
+ // DEBUG: this should probably insert access date too so as to
+ // create a proper item, but at the moment this is only called by
+ // translate.js, which sets the metadata fields itself
attachmentItem.save();
var itemID = attachmentItem.getID();
diff --git a/chrome/content/zotero/xpcom/data_access.js b/chrome/content/zotero/xpcom/data_access.js
@@ -2909,10 +2909,28 @@ Zotero.CreatorTypes = new function(){
Zotero.CachedTypes.apply(this, arguments);
this.constructor.prototype = new Zotero.CachedTypes();
+ this.getTypesForItemType = getTypesForItemType;
+ this.getPrimaryIDForType = getPrimaryIDForType;
+
this._typeDesc = 'creator type';
this._idCol = 'creatorTypeID';
this._nameCol = 'creatorType';
this._table = 'creatorTypes';
+
+ function getTypesForItemType(itemTypeID){
+ var sql = "SELECT creatorTypeID AS id, creatorType AS name "
+ + "FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes "
+ // DEBUG: sort needs to be on localized strings in itemPane.js
+ // (though still put primary field at top)
+ + "WHERE itemTypeID=? ORDER BY primaryField=1 DESC, name";
+ return Zotero.DB.query(sql, itemTypeID);
+ }
+
+ function getPrimaryIDForType(itemTypeID){
+ var sql = "SELECT creatorTypeID FROM itemTypeCreatorTypes "
+ + "WHERE itemTypeID=? AND primaryField=1";
+ return Zotero.DB.valueQuery(sql, itemTypeID);
+ }
}
diff --git a/chrome/content/zotero/xpcom/itemTreeView.js b/chrome/content/zotero/xpcom/itemTreeView.js
@@ -335,7 +335,30 @@ Zotero.ItemTreeView.prototype.getImageSrc = function(row, col)
}
}
- return "chrome://zotero/skin/treeitem-"+itemType+".png";
+ // DEBUG: only have icons for some types so far
+ switch (itemType)
+ {
+ case 'attachment-file':
+ case 'attachment-link':
+ case 'attachment-snapshot':
+ case 'attachment-web-link':
+ case 'artwork':
+ case 'book':
+ case 'bookSection':
+ case 'film':
+ case 'interview':
+ case 'journalArticle':
+ case 'letter':
+ case 'magazineArticle':
+ case 'manuscript':
+ case 'newspaperArticle':
+ case 'note':
+ case 'thesis':
+ case 'webpage':
+ return "chrome://zotero/skin/treeitem-"+itemType+".png";
+ }
+
+ return "chrome://zotero/skin/treeitem.png";
}
}
diff --git a/chrome/content/zotero/xpcom/schema.js b/chrome/content/zotero/xpcom/schema.js
@@ -534,6 +534,15 @@ Zotero.Schema = new function(){
Zotero.DB.query("INSERT INTO creators SELECT * FROM creatorsTemp");
Zotero.DB.query("DROP TABLE creatorsTemp");
}
+
+ if (i==7){
+ Zotero.DB.query("DELETE FROM itemData WHERE fieldID=17");
+ Zotero.DB.query("UPDATE itemData SET fieldID=64 WHERE fieldID=20");
+ Zotero.DB.query("UPDATE itemData SET fieldID=69 WHERE fieldID=24 AND itemID IN (SELECT itemID FROM items WHERE itemTypeID=7)");
+ Zotero.DB.query("UPDATE itemData SET fieldID=65 WHERE fieldID=24 AND itemID IN (SELECT itemID FROM items WHERE itemTypeID=8)");
+ Zotero.DB.query("UPDATE itemData SET fieldID=66 WHERE fieldID=24 AND itemID IN (SELECT itemID FROM items WHERE itemTypeID=9)");
+ Zotero.DB.query("UPDATE itemData SET fieldID=59 WHERE fieldID=24 AND itemID IN (SELECT itemID FROM items WHERE itemTypeID=12)");
+ }
}
_updateSchema('userdata');
diff --git a/chrome/locale/en-US/zotero/zotero.properties b/chrome/locale/en-US/zotero/zotero.properties
@@ -37,16 +37,47 @@ pane.item.attachments.count.singular = %1 attachment
pane.item.attachments.count.plural = %1 attachments
pane.item.attachments.select = Select a File
+itemTypes.note = Note
+itemTypes.attachment = Attachment
+itemTypes.book = Book
+itemTypes.bookSection = Book Section
+itemTypes.journalArticle = Journal Article
+itemTypes.magazineArticle = Magazine Article
+itemTypes.newspaperArticle = Newspaper Article
+itemTypes.thesis = Thesis
+itemTypes.letter = Letter
+itemTypes.manuscript = Manuscript
+itemTypes.interview = Interview
+itemTypes.film = Film
+itemTypes.artwork = Artwork
+itemTypes.webpage = Web Page
+itemTypes.report = Report
+itemTypes.bill = Bill
+itemTypes.case = Case
+itemTypes.hearing = Hearing
+itemTypes.patent = Patent
+itemTypes.statute = Statute
+itemTypes.email = E-mail
+itemTypes.map = Map
+itemTypes.blogPost = Blog Post
+itemTypes.instantMessage = Instant Message
+itemTypes.forumPost = Forum Post
+itemTypes.audioRecording = Audio Recording
+itemTypes.presentation = Presentation
+itemTypes.videoRecording = Video Recording
+itemTypes.tvBroadcast = TV Broadcast
+itemTypes.radioBroadcast = Radio Broadcast
+itemTypes.podcast = Podcast
+itemTypes.computerProgram = Computer Program
+
itemFields.title = Title
itemFields.dateAdded = Date Added
itemFields.dateModified = Modified
itemFields.source = Source
-itemFields.rights = Rights
itemFields.notes = Notes
+itemFields.url = URL
+itemFields.rights = Rights
itemFields.series = Series
-itemFields.seriesNumber = Series Number
-itemFields.seriesTitle = Series Title
-itemFields.seriesText = Series Text
itemFields.volume = Volume
itemFields.issue = Issue
itemFields.edition = Edition
@@ -54,41 +85,89 @@ itemFields.place = Place
itemFields.publisher = Publisher
itemFields.pages = Pages
itemFields.ISBN = ISBN
-itemFields.publicationTitle = Publication
+itemFields.publicationTitle = Publication
itemFields.ISSN = ISSN
itemFields.date = Date
itemFields.section = Section
-itemFields.accessionNumber = Accession No
-itemFields.archiveLocation = Location in Archive
-itemFields.medium = Medium
-itemFields.distributor = Distributor
-itemFields.url = URL
-itemFields.type = Type
itemFields.callNumber = Call Number
+itemFields.archiveLocation = Loc. in Archive
+itemFields.distributor = Distributor
itemFields.extra = Extra
itemFields.journalAbbreviation = Journal Abbr
itemFields.DOI = DOI
itemFields.accessDate = Accessed
-
-itemTypes.note = Note
-itemTypes.book = Book
-itemTypes.bookSection = Book Section
-itemTypes.journalArticle = Journal Article
-itemTypes.magazineArticle = Magazine Article
-itemTypes.newspaperArticle = Newspaper Article
-itemTypes.thesis = Thesis
-itemTypes.letter = Letter
-itemTypes.manuscript = Manuscript
-itemTypes.interview = Interview
-itemTypes.film = Film
-itemTypes.artwork = Artwork
-itemTypes.webpage = Web Page
-itemTypes.attachment = Attachment
+itemFields.seriesTitle = Series Title
+itemFields.seriesText = Series Text
+itemFields.seriesNumber = Series Number
+itemFields.institution = Institution
+itemFields.reportType = Report Type
+itemFields.code = Code
+itemFields.session = Session
+itemFields.legislativeBody = Legislative Body
+itemFields.history = History
+itemFields.reporter = Reporter
+itemFields.court = Court
+itemFields.numberOfVolumes = Number of Volumes
+itemFields.committee = Committee
+itemFields.assignee = Assignee
+itemFields.patentNumber = Patent Number
+itemFields.priorityNumbers = Priority Numbers
+itemFields.issueDate = Issue Date
+itemFields.references = References
+itemFields.legalStatus = Legal Status
+itemFields.codeNumber = Code Number
+itemFields.artworkMedium = Artwork Medium
+itemFields.number = Number
+itemFields.artworkSize = Artwork Size
+itemFields.repository = Repository
+itemFields.videoRecordingType = Recording Type
+itemFields.interviewMedium = Medium
+itemFields.letterType = Type
+itemFields.manuscriptType = Type
+itemFields.mapType = Type
+itemFields.scale = Scale
+itemFields.thesisType = Type
+itemFields.websiteType = Website Type
+itemFields.audioRecordingType = Recording Type
+itemFields.label = Label
+itemFields.presentationType = Type
+itemFields.meetingName = Meeting Name
+itemFields.studio = Studio
+itemFields.runningTime = Running Time
+itemFields.network = Network
+itemFields.postType = Post Type
+itemFields.audioFileType = File Type
+itemFields.version = Version
+itemFields.system = System
+itemFields.company = Company
creatorTypes.author = Author
creatorTypes.contributor = Contributor
creatorTypes.editor = Editor
creatorTypes.translator = Translator
+creatorTypes.seriesEditor = Series Editor
+creatorTypes.interviewee = Interview With
+creatorTypes.interviewer = Interviewer
+creatorTypes.director = Director
+creatorTypes.scriptwriter = Scriptwriter
+creatorTypes.producer = Producer
+creatorTypes.castMember = Cast Member
+creatorTypes.sponsor = Sponsor
+creatorTypes.counsel = Counsel
+creatorTypes.inventor = Inventor
+creatorTypes.attorneyAgent = Attorney/Agent
+creatorTypes.recipient = Recipient
+creatorTypes.performer = Performer
+creatorTypes.composer = Composer
+creatorTypes.wordsBy = Words By
+creatorTypes.cartographer = Cartographer
+creatorTypes.programmer = Programmer
+creatorTypes.reviewedAuthor = Reviewed Author
+creatorTypes.artist = Artist
+creatorTypes.commenter = Commenter
+creatorTypes.presenter = Presenter
+creatorTypes.guest = Guest
+creatorTypes.podcaster = Podcaster
ingester.scraping = Saving Item...
ingester.scrapeComplete = Item Saved.
diff --git a/chrome/skin/default/zotero/treeitem.png b/chrome/skin/default/zotero/treeitem.png
Binary files differ.
diff --git a/system.sql b/system.sql
@@ -1,4 +1,4 @@
--- 5
+-- 6
-- This file creates system tables that can be safely wiped and reinitialized
-- at any time, as long as existing ids are preserved.
@@ -76,6 +76,16 @@
creatorType TEXT
);
+DROP TABLE IF EXISTS itemTypeCreatorTypes;
+CREATE TABLE itemTypeCreatorTypes (
+ itemTypeID INT,
+ creatorTypeID INT,
+ primaryField INT,
+ PRIMARY KEY (itemTypeID, creatorTypeID),
+ FOREIGN KEY (itemTypeID) REFERENCES itemTypes(itemTypeID),
+ FOREIGN KEY (creatorTypeID) REFERENCES creatorTypes(creatorTypeID)
+);
+
DROP TABLE IF EXISTS transactionSets;
CREATE TABLE transactionSets (
transactionSetID INTEGER PRIMARY KEY,
@@ -107,183 +117,584 @@
INSERT INTO "fieldFormats" VALUES(2, '[0-9]*', 1);
INSERT INTO "fieldFormats" VALUES(3, '[0-9]{4}', 1);
- INSERT INTO itemTypes VALUES (1,'note',NULL,0);
- INSERT INTO itemTypes VALUES (2,'book',NULL,2);
- INSERT INTO itemTypes VALUES (3,'bookSection',2,2);
- INSERT INTO itemTypes VALUES (4,'journalArticle',NULL,2);
- INSERT INTO itemTypes VALUES (5,'magazineArticle',NULL,2);
- INSERT INTO itemTypes VALUES (6,'newspaperArticle',NULL,2);
- INSERT INTO itemTypes VALUES (7,'thesis',NULL,1);
- INSERT INTO itemTypes VALUES (8,'letter',NULL,1);
- INSERT INTO itemTypes VALUES (9,'manuscript',NULL,1);
- INSERT INTO itemTypes VALUES (10,'interview',NULL,1);
- INSERT INTO itemTypes VALUES (11,'film',NULL,1);
- INSERT INTO itemTypes VALUES (12,'artwork',NULL,1);
- INSERT INTO itemTypes VALUES (13,'webpage',NULL,0);
- INSERT INTO itemTypes VALUES (14,'attachment',NULL,0);
+INSERT INTO itemTypes VALUES (1,'note',NULL,0);
+INSERT INTO itemTypes VALUES (2,'book',NULL,2);
+INSERT INTO itemTypes VALUES (3,'bookSection',2,2);
+INSERT INTO itemTypes VALUES (4,'journalArticle',NULL,2);
+INSERT INTO itemTypes VALUES (5,'magazineArticle',NULL,2);
+INSERT INTO itemTypes VALUES (6,'newspaperArticle',NULL,2);
+INSERT INTO itemTypes VALUES (7,'thesis',NULL,1);
+INSERT INTO itemTypes VALUES (8,'letter',NULL,1);
+INSERT INTO itemTypes VALUES (9,'manuscript',NULL,1);
+INSERT INTO itemTypes VALUES (10,'interview',NULL,1);
+INSERT INTO itemTypes VALUES (11,'film',NULL,1);
+INSERT INTO itemTypes VALUES (12,'artwork',NULL,1);
+INSERT INTO itemTypes VALUES (13,'webpage',NULL,0);
+INSERT INTO itemTypes VALUES (14,'attachment',NULL,0);
+INSERT INTO itemTypes VALUES (15,'report',NULL,1);
+INSERT INTO itemTypes VALUES (16,'bill',NULL,1);
+INSERT INTO itemTypes VALUES (17,'case',NULL,1);
+INSERT INTO itemTypes VALUES (18,'hearing',NULL,1);
+INSERT INTO itemTypes VALUES (19,'patent',NULL,1);
+INSERT INTO itemTypes VALUES (20,'statute',NULL,1);
+INSERT INTO itemTypes VALUES (21,'email',NULL,1);
+INSERT INTO itemTypes VALUES (22,'map',NULL,1);
+INSERT INTO itemTypes VALUES (23,'blogPost',NULL,1);
+INSERT INTO itemTypes VALUES (24,'instantMessage',NULL,1);
+INSERT INTO itemTypes VALUES (25,'forumPost',NULL,1);
+INSERT INTO itemTypes VALUES (26,'audioRecording',NULL,1);
+INSERT INTO itemTypes VALUES (27,'presentation',NULL,1);
+INSERT INTO itemTypes VALUES (28,'videoRecording',NULL,1);
+INSERT INTO itemTypes VALUES (29,'tvBroadcast',NULL,1);
+INSERT INTO itemTypes VALUES (30,'radioBroadcast',NULL,1);
+INSERT INTO itemTypes VALUES (31,'podcast',NULL,1);
+INSERT INTO itemTypes VALUES (32,'computerProgram',NULL,1);
- INSERT INTO fields VALUES (1,'url',NULL);
- INSERT INTO fields VALUES (2,'rights',NULL);
- INSERT INTO fields VALUES (3,'series',NULL);
- INSERT INTO fields VALUES (4,'volume',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 (10,'pages',NULL);
- INSERT INTO fields VALUES (11,'ISBN',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);
- INSERT INTO fields VALUES (17,'accessionNumber',NULL);
- INSERT INTO fields VALUES (18,'callNumber',NULL);
- INSERT INTO fields VALUES (19,'archiveLocation',NULL);
- INSERT INTO fields VALUES (20,'medium',NULL);
- INSERT INTO fields VALUES (21,'distributor',NULL);
- INSERT INTO fields VALUES (22,'extra',NULL);
- INSERT INTO fields VALUES (24,'type',NULL);
- INSERT INTO fields VALUES (25,'journalAbbreviation',NULL);
- INSERT INTO fields VALUES (26,'DOI',NULL);
- INSERT INTO fields VALUES (27,'accessDate',NULL);
- INSERT INTO fields VALUES (28,'seriesTitle',NULL);
- INSERT INTO fields VALUES (29,'seriesText',NULL);
- INSERT INTO fields VALUES (30,'seriesNumber',NULL);
+INSERT INTO fields VALUES (1,'url',NULL);
+INSERT INTO fields VALUES (2,'rights',NULL);
+INSERT INTO fields VALUES (3,'series',NULL);
+INSERT INTO fields VALUES (4,'volume',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 (10,'pages',NULL);
+INSERT INTO fields VALUES (11,'ISBN',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);
+INSERT INTO fields VALUES (18,'callNumber',NULL);
+INSERT INTO fields VALUES (19,'archiveLocation',NULL);
+INSERT INTO fields VALUES (21,'distributor',NULL);
+INSERT INTO fields VALUES (22,'extra',NULL);
+INSERT INTO fields VALUES (25,'journalAbbreviation',NULL);
+INSERT INTO fields VALUES (26,'DOI',NULL);
+INSERT INTO fields VALUES (27,'accessDate',NULL);
+INSERT INTO fields VALUES (28,'seriesTitle',NULL);
+INSERT INTO fields VALUES (29,'seriesText',NULL);
+INSERT INTO fields VALUES (30,'seriesNumber',NULL);
+INSERT INTO fields VALUES (31,'institution',NULL);
+INSERT INTO fields VALUES (32,'reportType',NULL);
+INSERT INTO fields VALUES (36,'code',NULL);
+INSERT INTO fields VALUES (40,'session',NULL);
+INSERT INTO fields VALUES (41,'legislativeBody',NULL);
+INSERT INTO fields VALUES (42,'history',NULL);
+INSERT INTO fields VALUES (43,'reporter',NULL);
+INSERT INTO fields VALUES (44,'court',NULL);
+INSERT INTO fields VALUES (45,'numberOfVolumes',NULL);
+INSERT INTO fields VALUES (46,'committee',NULL);
+INSERT INTO fields VALUES (48,'assignee',NULL);
+INSERT INTO fields VALUES (50,'patentNumber',NULL);
+INSERT INTO fields VALUES (51,'priorityNumbers',NULL);
+INSERT INTO fields VALUES (52,'issueDate',NULL);
+INSERT INTO fields VALUES (53,'references',NULL);
+INSERT INTO fields VALUES (54,'legalStatus',NULL);
+INSERT INTO fields VALUES (55,'codeNumber',NULL);
+INSERT INTO fields VALUES (59,'artworkMedium',NULL);
+INSERT INTO fields VALUES (60,'number',NULL);
+INSERT INTO fields VALUES (61,'artworkSize',NULL);
+INSERT INTO fields VALUES (62,'repository',NULL);
+INSERT INTO fields VALUES (63,'videoRecordingType',NULL);
+INSERT INTO fields VALUES (64,'interviewMedium',NULL);
+INSERT INTO fields VALUES (65,'letterType',NULL);
+INSERT INTO fields VALUES (66,'manuscriptType',NULL);
+INSERT INTO fields VALUES (67,'mapType',NULL);
+INSERT INTO fields VALUES (68,'scale',NULL);
+INSERT INTO fields VALUES (69,'thesisType',NULL);
+INSERT INTO fields VALUES (70,'websiteType',NULL);
+INSERT INTO fields VALUES (71,'audioRecordingType',NULL);
+INSERT INTO fields VALUES (72,'label',NULL);
+INSERT INTO fields VALUES (74,'presentationType',NULL);
+INSERT INTO fields VALUES (75,'meetingName',NULL);
+INSERT INTO fields VALUES (76,'studio',NULL);
+INSERT INTO fields VALUES (77,'runningTime',NULL);
+INSERT INTO fields VALUES (78,'network',NULL);
+INSERT INTO fields VALUES (79,'postType',NULL);
+INSERT INTO fields VALUES (80,'audioFileType',NULL);
+INSERT INTO fields VALUES (81,'version',NULL);
+INSERT INTO fields VALUES (82,'system',NULL);
+INSERT INTO fields VALUES (83,'company',NULL);
+
+INSERT INTO itemTypeFields VALUES (2, 3, NULL, 1);
+INSERT INTO itemTypeFields VALUES (2, 30, NULL, 2);
+INSERT INTO itemTypeFields VALUES (2, 4, NULL, 3);
+INSERT INTO itemTypeFields VALUES (2, 45, NULL, 4);
+INSERT INTO itemTypeFields VALUES (2, 6, NULL, 5);
+INSERT INTO itemTypeFields VALUES (2, 7, NULL, 6);
+INSERT INTO itemTypeFields VALUES (2, 8, NULL, 7);
+INSERT INTO itemTypeFields VALUES (2, 14, NULL, 8);
+INSERT INTO itemTypeFields VALUES (2, 10, NULL, 9);
+INSERT INTO itemTypeFields VALUES (2, 11, NULL, 10);
+INSERT INTO itemTypeFields VALUES (2, 18, NULL, 11);
+INSERT INTO itemTypeFields VALUES (2, 19, NULL, 12);
+INSERT INTO itemTypeFields VALUES (2, 62, NULL, 13);
+INSERT INTO itemTypeFields VALUES (2, 2, NULL, 14);
+INSERT INTO itemTypeFields VALUES (2, 1, NULL, 15);
+INSERT INTO itemTypeFields VALUES (2, 27, NULL, 16);
+INSERT INTO itemTypeFields VALUES (2, 22, NULL, 17);
+INSERT INTO itemTypeFields VALUES (3, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (3, 3, NULL, 2);
+INSERT INTO itemTypeFields VALUES (3, 30, NULL, 3);
+INSERT INTO itemTypeFields VALUES (3, 4, NULL, 4);
+INSERT INTO itemTypeFields VALUES (3, 45, NULL, 5);
+INSERT INTO itemTypeFields VALUES (3, 6, NULL, 6);
+INSERT INTO itemTypeFields VALUES (3, 7, NULL, 7);
+INSERT INTO itemTypeFields VALUES (3, 8, NULL, 8);
+INSERT INTO itemTypeFields VALUES (3, 14, NULL, 9);
+INSERT INTO itemTypeFields VALUES (3, 10, NULL, 10);
+INSERT INTO itemTypeFields VALUES (3, 11, NULL, 11);
+INSERT INTO itemTypeFields VALUES (3, 18, NULL, 12);
+INSERT INTO itemTypeFields VALUES (3, 19, NULL, 13);
+INSERT INTO itemTypeFields VALUES (3, 62, NULL, 14);
+INSERT INTO itemTypeFields VALUES (3, 2, NULL, 15);
+INSERT INTO itemTypeFields VALUES (3, 1, NULL, 16);
+INSERT INTO itemTypeFields VALUES (3, 27, NULL, 17);
+INSERT INTO itemTypeFields VALUES (3, 22, NULL, 18);
+INSERT INTO itemTypeFields VALUES (4, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (4, 4, NULL, 2);
+INSERT INTO itemTypeFields VALUES (4, 5, NULL, 3);
+INSERT INTO itemTypeFields VALUES (4, 10, NULL, 4);
+INSERT INTO itemTypeFields VALUES (4, 14, NULL, 5);
+INSERT INTO itemTypeFields VALUES (4, 3, NULL, 6);
+INSERT INTO itemTypeFields VALUES (4, 28, NULL, 7);
+INSERT INTO itemTypeFields VALUES (4, 29, NULL, 8);
+INSERT INTO itemTypeFields VALUES (4, 25, NULL, 9);
+INSERT INTO itemTypeFields VALUES (4, 26, NULL, 10);
+INSERT INTO itemTypeFields VALUES (4, 13, NULL, 11);
+INSERT INTO itemTypeFields VALUES (4, 18, NULL, 12);
+INSERT INTO itemTypeFields VALUES (4, 19, NULL, 13);
+INSERT INTO itemTypeFields VALUES (4, 62, NULL, 14);
+INSERT INTO itemTypeFields VALUES (4, 2, NULL, 15);
+INSERT INTO itemTypeFields VALUES (4, 1, NULL, 16);
+INSERT INTO itemTypeFields VALUES (4, 27, NULL, 17);
+INSERT INTO itemTypeFields VALUES (4, 22, NULL, 18);
+INSERT INTO itemTypeFields VALUES (5, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (5, 4, NULL, 2);
+INSERT INTO itemTypeFields VALUES (5, 5, NULL, 3);
+INSERT INTO itemTypeFields VALUES (5, 14, NULL, 4);
+INSERT INTO itemTypeFields VALUES (5, 10, NULL, 5);
+INSERT INTO itemTypeFields VALUES (5, 13, NULL, 6);
+INSERT INTO itemTypeFields VALUES (5, 18, NULL, 7);
+INSERT INTO itemTypeFields VALUES (5, 19, NULL, 8);
+INSERT INTO itemTypeFields VALUES (5, 62, NULL, 9);
+INSERT INTO itemTypeFields VALUES (5, 2, NULL, 10);
+INSERT INTO itemTypeFields VALUES (5, 1, NULL, 11);
+INSERT INTO itemTypeFields VALUES (5, 27, NULL, 12);
+INSERT INTO itemTypeFields VALUES (5, 22, NULL, 13);
+INSERT INTO itemTypeFields VALUES (6, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (6, 6, NULL, 2);
+INSERT INTO itemTypeFields VALUES (6, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (6, 15, NULL, 4);
+INSERT INTO itemTypeFields VALUES (6, 10, NULL, 5);
+INSERT INTO itemTypeFields VALUES (6, 13, NULL, 6);
+INSERT INTO itemTypeFields VALUES (6, 18, NULL, 7);
+INSERT INTO itemTypeFields VALUES (6, 19, NULL, 8);
+INSERT INTO itemTypeFields VALUES (6, 62, NULL, 9);
+INSERT INTO itemTypeFields VALUES (6, 2, NULL, 10);
+INSERT INTO itemTypeFields VALUES (6, 1, NULL, 11);
+INSERT INTO itemTypeFields VALUES (6, 27, NULL, 12);
+INSERT INTO itemTypeFields VALUES (6, 22, NULL, 13);
+INSERT INTO itemTypeFields VALUES (7, 69, NULL, 1);
+INSERT INTO itemTypeFields VALUES (7, 8, NULL, 2);
+INSERT INTO itemTypeFields VALUES (7, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (7, 10, NULL, 4);
+INSERT INTO itemTypeFields VALUES (7, 18, NULL, 5);
+INSERT INTO itemTypeFields VALUES (7, 19, NULL, 6);
+INSERT INTO itemTypeFields VALUES (7, 62, NULL, 7);
+INSERT INTO itemTypeFields VALUES (7, 2, NULL, 8);
+INSERT INTO itemTypeFields VALUES (7, 1, NULL, 9);
+INSERT INTO itemTypeFields VALUES (7, 27, NULL, 10);
+INSERT INTO itemTypeFields VALUES (7, 22, NULL, 11);
+INSERT INTO itemTypeFields VALUES (8, 65, NULL, 1);
+INSERT INTO itemTypeFields VALUES (8, 14, NULL, 2);
+INSERT INTO itemTypeFields VALUES (8, 18, NULL, 3);
+INSERT INTO itemTypeFields VALUES (8, 19, NULL, 4);
+INSERT INTO itemTypeFields VALUES (8, 62, NULL, 5);
+INSERT INTO itemTypeFields VALUES (8, 2, NULL, 6);
+INSERT INTO itemTypeFields VALUES (8, 1, NULL, 7);
+INSERT INTO itemTypeFields VALUES (8, 27, NULL, 8);
+INSERT INTO itemTypeFields VALUES (8, 22, NULL, 9);
+INSERT INTO itemTypeFields VALUES (9, 66, NULL, 1);
+INSERT INTO itemTypeFields VALUES (9, 7, NULL, 2);
+INSERT INTO itemTypeFields VALUES (9, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (9, 10, NULL, 4);
+INSERT INTO itemTypeFields VALUES (9, 18, NULL, 5);
+INSERT INTO itemTypeFields VALUES (9, 19, NULL, 6);
+INSERT INTO itemTypeFields VALUES (9, 62, NULL, 7);
+INSERT INTO itemTypeFields VALUES (9, 2, NULL, 8);
+INSERT INTO itemTypeFields VALUES (9, 1, NULL, 9);
+INSERT INTO itemTypeFields VALUES (9, 27, NULL, 10);
+INSERT INTO itemTypeFields VALUES (9, 22, NULL, 11);
+INSERT INTO itemTypeFields VALUES (10, 14, NULL, 1);
+INSERT INTO itemTypeFields VALUES (10, 64, NULL, 2);
+INSERT INTO itemTypeFields VALUES (10, 18, NULL, 3);
+INSERT INTO itemTypeFields VALUES (10, 19, NULL, 4);
+INSERT INTO itemTypeFields VALUES (10, 62, NULL, 5);
+INSERT INTO itemTypeFields VALUES (10, 2, NULL, 6);
+INSERT INTO itemTypeFields VALUES (10, 1, NULL, 7);
+INSERT INTO itemTypeFields VALUES (10, 27, NULL, 8);
+INSERT INTO itemTypeFields VALUES (10, 22, NULL, 9);
+INSERT INTO itemTypeFields VALUES (11, 21, NULL, 1);
+INSERT INTO itemTypeFields VALUES (11, 63, NULL, 2);
+INSERT INTO itemTypeFields VALUES (11, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (11, 77, NULL, 4);
+INSERT INTO itemTypeFields VALUES (11, 18, NULL, 5);
+INSERT INTO itemTypeFields VALUES (11, 19, NULL, 6);
+INSERT INTO itemTypeFields VALUES (11, 62, NULL, 7);
+INSERT INTO itemTypeFields VALUES (11, 2, NULL, 8);
+INSERT INTO itemTypeFields VALUES (11, 1, NULL, 9);
+INSERT INTO itemTypeFields VALUES (11, 27, NULL, 10);
+INSERT INTO itemTypeFields VALUES (11, 22, NULL, 11);
+INSERT INTO itemTypeFields VALUES (12, 59, NULL, 1);
+INSERT INTO itemTypeFields VALUES (12, 61, NULL, 2);
+INSERT INTO itemTypeFields VALUES (12, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (12, 18, NULL, 4);
+INSERT INTO itemTypeFields VALUES (12, 19, NULL, 5);
+INSERT INTO itemTypeFields VALUES (12, 62, NULL, 6);
+INSERT INTO itemTypeFields VALUES (12, 2, NULL, 7);
+INSERT INTO itemTypeFields VALUES (12, 1, NULL, 8);
+INSERT INTO itemTypeFields VALUES (12, 27, NULL, 9);
+INSERT INTO itemTypeFields VALUES (12, 22, NULL, 10);
+INSERT INTO itemTypeFields VALUES (13, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (13, 70, NULL, 2);
+INSERT INTO itemTypeFields VALUES (13, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (13, 1, NULL, 4);
+INSERT INTO itemTypeFields VALUES (13, 27, NULL, 5);
+INSERT INTO itemTypeFields VALUES (13, 2, NULL, 6);
+INSERT INTO itemTypeFields VALUES (13, 22, NULL, 7);
+INSERT INTO itemTypeFields VALUES (14, 27, NULL, 1);
+INSERT INTO itemTypeFields VALUES (14, 1, NULL, 2);
+INSERT INTO itemTypeFields VALUES (15, 60, NULL, 1);
+INSERT INTO itemTypeFields VALUES (15, 32, NULL, 2);
+INSERT INTO itemTypeFields VALUES (15, 28, NULL, 3);
+INSERT INTO itemTypeFields VALUES (15, 7, NULL, 4);
+INSERT INTO itemTypeFields VALUES (15, 31, NULL, 5);
+INSERT INTO itemTypeFields VALUES (15, 14, NULL, 6);
+INSERT INTO itemTypeFields VALUES (15, 10, NULL, 7);
+INSERT INTO itemTypeFields VALUES (15, 18, NULL, 8);
+INSERT INTO itemTypeFields VALUES (15, 19, NULL, 9);
+INSERT INTO itemTypeFields VALUES (15, 62, NULL, 10);
+INSERT INTO itemTypeFields VALUES (15, 2, NULL, 11);
+INSERT INTO itemTypeFields VALUES (15, 1, NULL, 12);
+INSERT INTO itemTypeFields VALUES (15, 27, NULL, 13);
+INSERT INTO itemTypeFields VALUES (15, 22, NULL, 14);
+INSERT INTO itemTypeFields VALUES (16, 60, NULL, 1);
+INSERT INTO itemTypeFields VALUES (16, 36, NULL, 2);
+INSERT INTO itemTypeFields VALUES (16, 4, NULL, 3);
+INSERT INTO itemTypeFields VALUES (16, 15, NULL, 4);
+INSERT INTO itemTypeFields VALUES (16, 10, NULL, 5);
+INSERT INTO itemTypeFields VALUES (16, 41, NULL, 6);
+INSERT INTO itemTypeFields VALUES (16, 40, NULL, 7);
+INSERT INTO itemTypeFields VALUES (16, 42, NULL, 8);
+INSERT INTO itemTypeFields VALUES (16, 14, NULL, 9);
+INSERT INTO itemTypeFields VALUES (16, 2, NULL, 10);
+INSERT INTO itemTypeFields VALUES (16, 1, NULL, 11);
+INSERT INTO itemTypeFields VALUES (16, 27, NULL, 12);
+INSERT INTO itemTypeFields VALUES (16, 22, NULL, 13);
+INSERT INTO itemTypeFields VALUES (17, 43, NULL, 1);
+INSERT INTO itemTypeFields VALUES (17, 4, NULL, 2);
+INSERT INTO itemTypeFields VALUES (17, 44, NULL, 3);
+INSERT INTO itemTypeFields VALUES (17, 10, NULL, 4);
+INSERT INTO itemTypeFields VALUES (17, 42, NULL, 5);
+INSERT INTO itemTypeFields VALUES (17, 14, NULL, 6);
+INSERT INTO itemTypeFields VALUES (17, 2, NULL, 7);
+INSERT INTO itemTypeFields VALUES (17, 1, NULL, 8);
+INSERT INTO itemTypeFields VALUES (17, 27, NULL, 9);
+INSERT INTO itemTypeFields VALUES (17, 22, NULL, 10);
+INSERT INTO itemTypeFields VALUES (18, 46, NULL, 1);
+INSERT INTO itemTypeFields VALUES (18, 7, NULL, 2);
+INSERT INTO itemTypeFields VALUES (18, 8, NULL, 3);
+INSERT INTO itemTypeFields VALUES (18, 45, NULL, 4);
+INSERT INTO itemTypeFields VALUES (18, 60, NULL, 5);
+INSERT INTO itemTypeFields VALUES (18, 10, NULL, 6);
+INSERT INTO itemTypeFields VALUES (18, 41, NULL, 7);
+INSERT INTO itemTypeFields VALUES (18, 40, NULL, 8);
+INSERT INTO itemTypeFields VALUES (18, 42, NULL, 9);
+INSERT INTO itemTypeFields VALUES (18, 14, NULL, 10);
+INSERT INTO itemTypeFields VALUES (18, 2, NULL, 11);
+INSERT INTO itemTypeFields VALUES (18, 1, NULL, 12);
+INSERT INTO itemTypeFields VALUES (18, 27, NULL, 13);
+INSERT INTO itemTypeFields VALUES (18, 22, NULL, 14);
+INSERT INTO itemTypeFields VALUES (19, 7, NULL, 1);
+INSERT INTO itemTypeFields VALUES (19, 48, NULL, 2);
+INSERT INTO itemTypeFields VALUES (19, 60, NULL, 3);
+INSERT INTO itemTypeFields VALUES (19, 14, NULL, 4);
+INSERT INTO itemTypeFields VALUES (19, 10, NULL, 5);
+INSERT INTO itemTypeFields VALUES (19, 50, NULL, 6);
+INSERT INTO itemTypeFields VALUES (19, 51, NULL, 7);
+INSERT INTO itemTypeFields VALUES (19, 52, NULL, 8);
+INSERT INTO itemTypeFields VALUES (19, 53, NULL, 9);
+INSERT INTO itemTypeFields VALUES (19, 54, NULL, 10);
+INSERT INTO itemTypeFields VALUES (19, 2, NULL, 11);
+INSERT INTO itemTypeFields VALUES (19, 1, NULL, 12);
+INSERT INTO itemTypeFields VALUES (19, 27, NULL, 13);
+INSERT INTO itemTypeFields VALUES (19, 22, NULL, 14);
+INSERT INTO itemTypeFields VALUES (20, 36, NULL, 1);
+INSERT INTO itemTypeFields VALUES (20, 55, NULL, 2);
+INSERT INTO itemTypeFields VALUES (20, 60, NULL, 3);
+INSERT INTO itemTypeFields VALUES (20, 14, NULL, 4);
+INSERT INTO itemTypeFields VALUES (20, 10, NULL, 5);
+INSERT INTO itemTypeFields VALUES (20, 15, NULL, 6);
+INSERT INTO itemTypeFields VALUES (20, 40, NULL, 7);
+INSERT INTO itemTypeFields VALUES (20, 42, NULL, 8);
+INSERT INTO itemTypeFields VALUES (20, 2, NULL, 9);
+INSERT INTO itemTypeFields VALUES (20, 1, NULL, 10);
+INSERT INTO itemTypeFields VALUES (20, 27, NULL, 11);
+INSERT INTO itemTypeFields VALUES (20, 22, NULL, 12);
+INSERT INTO itemTypeFields VALUES (21, 14, NULL, 1);
+INSERT INTO itemTypeFields VALUES (21, 2, NULL, 2);
+INSERT INTO itemTypeFields VALUES (21, 1, NULL, 3);
+INSERT INTO itemTypeFields VALUES (21, 27, NULL, 4);
+INSERT INTO itemTypeFields VALUES (21, 22, NULL, 5);
+INSERT INTO itemTypeFields VALUES (22, 67, NULL, 1);
+INSERT INTO itemTypeFields VALUES (22, 68, NULL, 2);
+INSERT INTO itemTypeFields VALUES (22, 28, NULL, 3);
+INSERT INTO itemTypeFields VALUES (22, 6, NULL, 4);
+INSERT INTO itemTypeFields VALUES (22, 7, NULL, 5);
+INSERT INTO itemTypeFields VALUES (22, 8, NULL, 6);
+INSERT INTO itemTypeFields VALUES (22, 14, NULL, 7);
+INSERT INTO itemTypeFields VALUES (22, 11, NULL, 8);
+INSERT INTO itemTypeFields VALUES (22, 18, NULL, 9);
+INSERT INTO itemTypeFields VALUES (22, 19, NULL, 10);
+INSERT INTO itemTypeFields VALUES (22, 62, NULL, 11);
+INSERT INTO itemTypeFields VALUES (22, 2, NULL, 12);
+INSERT INTO itemTypeFields VALUES (22, 1, NULL, 13);
+INSERT INTO itemTypeFields VALUES (22, 27, NULL, 14);
+INSERT INTO itemTypeFields VALUES (22, 22, NULL, 15);
+INSERT INTO itemTypeFields VALUES (23, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (23, 70, NULL, 2);
+INSERT INTO itemTypeFields VALUES (23, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (23, 1, NULL, 4);
+INSERT INTO itemTypeFields VALUES (23, 27, NULL, 5);
+INSERT INTO itemTypeFields VALUES (23, 2, NULL, 6);
+INSERT INTO itemTypeFields VALUES (23, 22, NULL, 7);
+INSERT INTO itemTypeFields VALUES (24, 14, NULL, 1);
+INSERT INTO itemTypeFields VALUES (24, 2, NULL, 2);
+INSERT INTO itemTypeFields VALUES (24, 1, NULL, 3);
+INSERT INTO itemTypeFields VALUES (24, 27, NULL, 4);
+INSERT INTO itemTypeFields VALUES (24, 22, NULL, 5);
+INSERT INTO itemTypeFields VALUES (25, 12, NULL, 1);
+INSERT INTO itemTypeFields VALUES (25, 79, NULL, 2);
+INSERT INTO itemTypeFields VALUES (25, 14, NULL, 3);
+INSERT INTO itemTypeFields VALUES (25, 2, NULL, 4);
+INSERT INTO itemTypeFields VALUES (25, 1, NULL, 5);
+INSERT INTO itemTypeFields VALUES (25, 27, NULL, 6);
+INSERT INTO itemTypeFields VALUES (25, 22, NULL, 7);
+INSERT INTO itemTypeFields VALUES (26, 71, NULL, 1);
+INSERT INTO itemTypeFields VALUES (26, 28, NULL, 2);
+INSERT INTO itemTypeFields VALUES (26, 4, NULL, 3);
+INSERT INTO itemTypeFields VALUES (26, 45, NULL, 4);
+INSERT INTO itemTypeFields VALUES (26, 7, NULL, 5);
+INSERT INTO itemTypeFields VALUES (26, 72, NULL, 6);
+INSERT INTO itemTypeFields VALUES (26, 14, NULL, 7);
+INSERT INTO itemTypeFields VALUES (26, 77, NULL, 8);
+INSERT INTO itemTypeFields VALUES (26, 11, NULL, 9);
+INSERT INTO itemTypeFields VALUES (26, 18, NULL, 10);
+INSERT INTO itemTypeFields VALUES (26, 19, NULL, 11);
+INSERT INTO itemTypeFields VALUES (26, 62, NULL, 12);
+INSERT INTO itemTypeFields VALUES (26, 2, NULL, 13);
+INSERT INTO itemTypeFields VALUES (26, 1, NULL, 14);
+INSERT INTO itemTypeFields VALUES (26, 27, NULL, 15);
+INSERT INTO itemTypeFields VALUES (26, 22, NULL, 16);
+INSERT INTO itemTypeFields VALUES (27, 74, NULL, 1);
+INSERT INTO itemTypeFields VALUES (27, 7, NULL, 2);
+INSERT INTO itemTypeFields VALUES (27, 75, NULL, 3);
+INSERT INTO itemTypeFields VALUES (28, 63, NULL, 1);
+INSERT INTO itemTypeFields VALUES (28, 28, NULL, 2);
+INSERT INTO itemTypeFields VALUES (28, 4, NULL, 3);
+INSERT INTO itemTypeFields VALUES (28, 45, NULL, 4);
+INSERT INTO itemTypeFields VALUES (28, 7, NULL, 5);
+INSERT INTO itemTypeFields VALUES (28, 76, NULL, 6);
+INSERT INTO itemTypeFields VALUES (28, 14, NULL, 7);
+INSERT INTO itemTypeFields VALUES (28, 77, NULL, 8);
+INSERT INTO itemTypeFields VALUES (28, 11, NULL, 9);
+INSERT INTO itemTypeFields VALUES (28, 18, NULL, 10);
+INSERT INTO itemTypeFields VALUES (28, 19, NULL, 11);
+INSERT INTO itemTypeFields VALUES (28, 62, NULL, 12);
+INSERT INTO itemTypeFields VALUES (28, 2, NULL, 13);
+INSERT INTO itemTypeFields VALUES (28, 1, NULL, 14);
+INSERT INTO itemTypeFields VALUES (28, 27, NULL, 15);
+INSERT INTO itemTypeFields VALUES (28, 22, NULL, 16);
+INSERT INTO itemTypeFields VALUES (29, 28, NULL, 1);
+INSERT INTO itemTypeFields VALUES (29, 60, NULL, 2);
+INSERT INTO itemTypeFields VALUES (29, 63, NULL, 3);
+INSERT INTO itemTypeFields VALUES (29, 7, NULL, 4);
+INSERT INTO itemTypeFields VALUES (29, 78, NULL, 5);
+INSERT INTO itemTypeFields VALUES (29, 14, NULL, 6);
+INSERT INTO itemTypeFields VALUES (29, 77, NULL, 7);
+INSERT INTO itemTypeFields VALUES (29, 18, NULL, 8);
+INSERT INTO itemTypeFields VALUES (29, 19, NULL, 9);
+INSERT INTO itemTypeFields VALUES (29, 62, NULL, 10);
+INSERT INTO itemTypeFields VALUES (29, 2, NULL, 11);
+INSERT INTO itemTypeFields VALUES (29, 1, NULL, 12);
+INSERT INTO itemTypeFields VALUES (29, 27, NULL, 13);
+INSERT INTO itemTypeFields VALUES (29, 22, NULL, 14);
+INSERT INTO itemTypeFields VALUES (30, 28, NULL, 1);
+INSERT INTO itemTypeFields VALUES (30, 60, NULL, 2);
+INSERT INTO itemTypeFields VALUES (30, 71, NULL, 3);
+INSERT INTO itemTypeFields VALUES (30, 7, NULL, 4);
+INSERT INTO itemTypeFields VALUES (30, 78, NULL, 5);
+INSERT INTO itemTypeFields VALUES (30, 14, NULL, 6);
+INSERT INTO itemTypeFields VALUES (30, 77, NULL, 7);
+INSERT INTO itemTypeFields VALUES (30, 18, NULL, 8);
+INSERT INTO itemTypeFields VALUES (30, 19, NULL, 9);
+INSERT INTO itemTypeFields VALUES (30, 62, NULL, 10);
+INSERT INTO itemTypeFields VALUES (30, 2, NULL, 11);
+INSERT INTO itemTypeFields VALUES (30, 1, NULL, 12);
+INSERT INTO itemTypeFields VALUES (30, 27, NULL, 13);
+INSERT INTO itemTypeFields VALUES (30, 22, NULL, 14);
+INSERT INTO itemTypeFields VALUES (31, 28, NULL, 1);
+INSERT INTO itemTypeFields VALUES (31, 60, NULL, 2);
+INSERT INTO itemTypeFields VALUES (31, 80, NULL, 3);
+INSERT INTO itemTypeFields VALUES (31, 77, NULL, 4);
+INSERT INTO itemTypeFields VALUES (31, 2, NULL, 5);
+INSERT INTO itemTypeFields VALUES (31, 1, NULL, 6);
+INSERT INTO itemTypeFields VALUES (31, 27, NULL, 7);
+INSERT INTO itemTypeFields VALUES (31, 22, NULL, 8);
+INSERT INTO itemTypeFields VALUES (32, 28, NULL, 1);
+INSERT INTO itemTypeFields VALUES (32, 81, NULL, 2);
+INSERT INTO itemTypeFields VALUES (32, 82, NULL, 3);
+INSERT INTO itemTypeFields VALUES (32, 7, NULL, 4);
+INSERT INTO itemTypeFields VALUES (32, 83, NULL, 5);
+INSERT INTO itemTypeFields VALUES (32, 11, NULL, 6);
+INSERT INTO itemTypeFields VALUES (32, 18, NULL, 7);
+INSERT INTO itemTypeFields VALUES (32, 19, NULL, 8);
+INSERT INTO itemTypeFields VALUES (32, 62, NULL, 9);
+INSERT INTO itemTypeFields VALUES (32, 2, NULL, 10);
+INSERT INTO itemTypeFields VALUES (32, 1, NULL, 11);
+INSERT INTO itemTypeFields VALUES (32, 27, NULL, 12);
+INSERT INTO itemTypeFields VALUES (32, 22, NULL, 13);
+
+INSERT INTO creatorTypes VALUES(1, "author");
+INSERT INTO creatorTypes VALUES(2, "contributor");
+INSERT INTO creatorTypes VALUES(3, "editor");
+INSERT INTO creatorTypes VALUES(4, "translator");
+INSERT INTO creatorTypes VALUES(5, "seriesEditor");
+INSERT INTO creatorTypes VALUES(6, "interviewee");
+INSERT INTO creatorTypes VALUES(7, "interviewer");
+INSERT INTO creatorTypes VALUES(8, "director");
+INSERT INTO creatorTypes VALUES(9, "scriptwriter");
+INSERT INTO creatorTypes VALUES(10, "producer");
+INSERT INTO creatorTypes VALUES(11, "castMember");
+INSERT INTO creatorTypes VALUES(12, "sponsor");
+INSERT INTO creatorTypes VALUES(13, "counsel");
+INSERT INTO creatorTypes VALUES(14, "inventor");
+INSERT INTO creatorTypes VALUES(15, "attorneyAgent");
+INSERT INTO creatorTypes VALUES(16, "recipient");
+INSERT INTO creatorTypes VALUES(17, "performer");
+INSERT INTO creatorTypes VALUES(18, "composer");
+INSERT INTO creatorTypes VALUES(19, "wordsBy");
+INSERT INTO creatorTypes VALUES(20, "cartographer");
+INSERT INTO creatorTypes VALUES(21, "programmer");
+INSERT INTO creatorTypes VALUES(22, "artist");
+INSERT INTO creatorTypes VALUES(23, "commenter");
+INSERT INTO creatorTypes VALUES(24, "presenter");
+INSERT INTO creatorTypes VALUES(25, "guest");
+INSERT INTO creatorTypes VALUES(26, "podcaster");
+INSERT INTO creatorTypes VALUES(27, "reviewedAuthor");
+
+INSERT INTO itemTypeCreatorTypes VALUES(2,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(2,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(2,3,0);
+INSERT INTO itemTypeCreatorTypes VALUES(2,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(2,5,0);
+INSERT INTO itemTypeCreatorTypes VALUES(3,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(3,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(3,3,0);
+INSERT INTO itemTypeCreatorTypes VALUES(3,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(3,5,0);
+INSERT INTO itemTypeCreatorTypes VALUES(4,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(4,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(4,3,0);
+INSERT INTO itemTypeCreatorTypes VALUES(4,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(4,27,0);
+INSERT INTO itemTypeCreatorTypes VALUES(5,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(5,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(5,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(5,27,0);
+INSERT INTO itemTypeCreatorTypes VALUES(6,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(6,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(6,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(6,27,0);
+INSERT INTO itemTypeCreatorTypes VALUES(7,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(7,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(8,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(8,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(8,16,0);
+INSERT INTO itemTypeCreatorTypes VALUES(9,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(9,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(9,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(10,6,1);
+INSERT INTO itemTypeCreatorTypes VALUES(10,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(10,7,0);
+INSERT INTO itemTypeCreatorTypes VALUES(10,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(11,8,1);
+INSERT INTO itemTypeCreatorTypes VALUES(11,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(11,9,0);
+INSERT INTO itemTypeCreatorTypes VALUES(11,10,0);
+INSERT INTO itemTypeCreatorTypes VALUES(12,22,1);
+INSERT INTO itemTypeCreatorTypes VALUES(12,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(13,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(13,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(13,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(15,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(15,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(15,4,0);
+INSERT INTO itemTypeCreatorTypes VALUES(15,5,0);
+INSERT INTO itemTypeCreatorTypes VALUES(16,12,1);
+INSERT INTO itemTypeCreatorTypes VALUES(16,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(17,13,1);
+INSERT INTO itemTypeCreatorTypes VALUES(17,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(18,2,1);
+INSERT INTO itemTypeCreatorTypes VALUES(19,14,1);
+INSERT INTO itemTypeCreatorTypes VALUES(19,15,0);
+INSERT INTO itemTypeCreatorTypes VALUES(19,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(20,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(20,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(21,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(21,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(21,16,0);
+INSERT INTO itemTypeCreatorTypes VALUES(22,20,1);
+INSERT INTO itemTypeCreatorTypes VALUES(22,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(22,5,0);
+INSERT INTO itemTypeCreatorTypes VALUES(23,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(23,23,0);
+INSERT INTO itemTypeCreatorTypes VALUES(23,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(24,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(24,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(24,16,0);
+INSERT INTO itemTypeCreatorTypes VALUES(25,1,1);
+INSERT INTO itemTypeCreatorTypes VALUES(25,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(26,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(26,17,1);
+INSERT INTO itemTypeCreatorTypes VALUES(26,18,0);
+INSERT INTO itemTypeCreatorTypes VALUES(26,19,0);
+INSERT INTO itemTypeCreatorTypes VALUES(27,24,1);
+INSERT INTO itemTypeCreatorTypes VALUES(27,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(28,8,1);
+INSERT INTO itemTypeCreatorTypes VALUES(28,9,0);
+INSERT INTO itemTypeCreatorTypes VALUES(28,10,0);
+INSERT INTO itemTypeCreatorTypes VALUES(28,11,0);
+INSERT INTO itemTypeCreatorTypes VALUES(28,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(29,8,1);
+INSERT INTO itemTypeCreatorTypes VALUES(29,9,0);
+INSERT INTO itemTypeCreatorTypes VALUES(29,10,0);
+INSERT INTO itemTypeCreatorTypes VALUES(29,11,0);
+INSERT INTO itemTypeCreatorTypes VALUES(29,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(29,25,0);
+INSERT INTO itemTypeCreatorTypes VALUES(30,8,1);
+INSERT INTO itemTypeCreatorTypes VALUES(30,9,0);
+INSERT INTO itemTypeCreatorTypes VALUES(30,10,0);
+INSERT INTO itemTypeCreatorTypes VALUES(30,11,0);
+INSERT INTO itemTypeCreatorTypes VALUES(30,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(30,25,0);
+INSERT INTO itemTypeCreatorTypes VALUES(31,26,1);
+INSERT INTO itemTypeCreatorTypes VALUES(31,2,0);
+INSERT INTO itemTypeCreatorTypes VALUES(31,25,0);
+INSERT INTO itemTypeCreatorTypes VALUES(32,21,1);
+INSERT INTO itemTypeCreatorTypes VALUES(32,2,0);
- INSERT INTO itemTypeFields VALUES (2, 3, NULL, 1);
- INSERT INTO itemTypeFields VALUES (2, 30, NULL, 2);
- INSERT INTO itemTypeFields VALUES (2, 4, NULL, 3);
- INSERT INTO itemTypeFields VALUES (2, 5, NULL, 4);
- INSERT INTO itemTypeFields VALUES (2, 6, NULL, 5);
- INSERT INTO itemTypeFields VALUES (2, 7, NULL, 6);
- INSERT INTO itemTypeFields VALUES (2, 8, NULL, 7);
- INSERT INTO itemTypeFields VALUES (2, 14, NULL, 8);
- INSERT INTO itemTypeFields VALUES (2, 10, NULL, 9);
- INSERT INTO itemTypeFields VALUES (2, 11, NULL, 10);
- INSERT INTO itemTypeFields VALUES (2, 18, NULL, 11);
- INSERT INTO itemTypeFields VALUES (2, 17, NULL, 12);
- INSERT INTO itemTypeFields VALUES (2, 2, NULL, 13);
- INSERT INTO itemTypeFields VALUES (2, 1, NULL, 14);
- INSERT INTO itemTypeFields VALUES (2, 27, NULL, 15);
- INSERT INTO itemTypeFields VALUES (2, 22, NULL, 16);
- INSERT INTO itemTypeFields VALUES (3, 12, NULL, 1);
- INSERT INTO itemTypeFields VALUES (3, 3, NULL, 2);
- INSERT INTO itemTypeFields VALUES (3, 30, NULL, 3);
- INSERT INTO itemTypeFields VALUES (3, 4, NULL, 4);
- INSERT INTO itemTypeFields VALUES (3, 5, NULL, 5);
- INSERT INTO itemTypeFields VALUES (3, 6, NULL, 6);
- INSERT INTO itemTypeFields VALUES (3, 7, NULL, 7);
- INSERT INTO itemTypeFields VALUES (3, 8, NULL, 8);
- INSERT INTO itemTypeFields VALUES (3, 14, NULL, 9);
- INSERT INTO itemTypeFields VALUES (3, 10, NULL, 10);
- INSERT INTO itemTypeFields VALUES (3, 11, NULL, 11);
- INSERT INTO itemTypeFields VALUES (3, 18, NULL, 12);
- INSERT INTO itemTypeFields VALUES (3, 17, NULL, 13);
- INSERT INTO itemTypeFields VALUES (3, 2, NULL, 14);
- INSERT INTO itemTypeFields VALUES (3, 1, NULL, 15);
- INSERT INTO itemTypeFields VALUES (3, 27, NULL, 16);
- INSERT INTO itemTypeFields VALUES (3, 22, NULL, 17);
- INSERT INTO itemTypeFields VALUES (4, 12, NULL, 1);
- INSERT INTO itemTypeFields VALUES (4, 4, NULL, 2);
- INSERT INTO itemTypeFields VALUES (4, 5, NULL, 3);
- INSERT INTO itemTypeFields VALUES (4, 10, NULL, 4);
- INSERT INTO itemTypeFields VALUES (4, 14, NULL, 5);
- INSERT INTO itemTypeFields VALUES (4, 3, NULL, 6);
- INSERT INTO itemTypeFields VALUES (4, 28, NULL, 7);
- INSERT INTO itemTypeFields VALUES (4, 29, NULL, 8);
- INSERT INTO itemTypeFields VALUES (4, 25, NULL, 9);
- INSERT INTO itemTypeFields VALUES (4, 26, NULL, 10);
- INSERT INTO itemTypeFields VALUES (4, 13, NULL, 11);
- INSERT INTO itemTypeFields VALUES (4, 18, NULL, 12);
- INSERT INTO itemTypeFields VALUES (4, 17, NULL, 13);
- INSERT INTO itemTypeFields VALUES (4, 2, NULL, 14);
- INSERT INTO itemTypeFields VALUES (4, 1, NULL, 15);
- INSERT INTO itemTypeFields VALUES (4, 27, NULL, 16);
- INSERT INTO itemTypeFields VALUES (4, 22, NULL, 17);
- INSERT INTO itemTypeFields VALUES (5, 12, NULL, 1);
- INSERT INTO itemTypeFields VALUES (5, 14, NULL, 2);
- INSERT INTO itemTypeFields VALUES (5, 10, NULL, 3);
- INSERT INTO itemTypeFields VALUES (5, 13, NULL, 4);
- INSERT INTO itemTypeFields VALUES (5, 18, NULL, 5);
- INSERT INTO itemTypeFields VALUES (5, 17, NULL, 6);
- INSERT INTO itemTypeFields VALUES (5, 2, NULL, 7);
- INSERT INTO itemTypeFields VALUES (5, 1, NULL, 8);
- INSERT INTO itemTypeFields VALUES (5, 27, NULL, 9);
- INSERT INTO itemTypeFields VALUES (5, 22, NULL, 10);
- INSERT INTO itemTypeFields VALUES (6, 12, NULL, 1);
- INSERT INTO itemTypeFields VALUES (6, 6, NULL, 2);
- INSERT INTO itemTypeFields VALUES (6, 14, NULL, 3);
- INSERT INTO itemTypeFields VALUES (6, 15, NULL, 4);
- INSERT INTO itemTypeFields VALUES (6, 10, NULL, 5);
- INSERT INTO itemTypeFields VALUES (6, 13, NULL, 6);
- INSERT INTO itemTypeFields VALUES (6, 18, NULL, 7);
- INSERT INTO itemTypeFields VALUES (6, 17, NULL, 8);
- INSERT INTO itemTypeFields VALUES (6, 2, NULL, 9);
- INSERT INTO itemTypeFields VALUES (6, 1, NULL, 10);
- INSERT INTO itemTypeFields VALUES (6, 27, NULL, 11);
- INSERT INTO itemTypeFields VALUES (6, 22, NULL, 12);
- INSERT INTO itemTypeFields VALUES (7, 8, NULL, 1);
- INSERT INTO itemTypeFields VALUES (7, 24, NULL, 2);
- INSERT INTO itemTypeFields VALUES (7, 14, NULL, 3);
- INSERT INTO itemTypeFields VALUES (7, 10, NULL, 4);
- INSERT INTO itemTypeFields VALUES (7, 18, NULL, 5);
- INSERT INTO itemTypeFields VALUES (7, 17, NULL, 6);
- INSERT INTO itemTypeFields VALUES (7, 2, NULL, 7);
- INSERT INTO itemTypeFields VALUES (7, 1, NULL, 8);
- INSERT INTO itemTypeFields VALUES (7, 27, NULL, 9);
- INSERT INTO itemTypeFields VALUES (7, 22, NULL, 10);
- INSERT INTO itemTypeFields VALUES (8, 24, NULL, 1);
- INSERT INTO itemTypeFields VALUES (8, 14, NULL, 2);
- INSERT INTO itemTypeFields VALUES (8, 19, NULL, 3);
- INSERT INTO itemTypeFields VALUES (8, 18, NULL, 4);
- INSERT INTO itemTypeFields VALUES (8, 17, NULL, 5);
- INSERT INTO itemTypeFields VALUES (8, 2, NULL, 6);
- INSERT INTO itemTypeFields VALUES (8, 1, NULL, 7);
- INSERT INTO itemTypeFields VALUES (8, 27, NULL, 8);
- INSERT INTO itemTypeFields VALUES (8, 22, NULL, 9);
- INSERT INTO itemTypeFields VALUES (9, 24, NULL, 1);
- INSERT INTO itemTypeFields VALUES (9, 7, NULL, 2);
- INSERT INTO itemTypeFields VALUES (9, 14, NULL, 3);
- INSERT INTO itemTypeFields VALUES (9, 19, NULL, 4);
- INSERT INTO itemTypeFields VALUES (9, 18, NULL, 5);
- INSERT INTO itemTypeFields VALUES (9, 17, NULL, 6);
- INSERT INTO itemTypeFields VALUES (9, 2, NULL, 7);
- INSERT INTO itemTypeFields VALUES (9, 1, NULL, 8);
- INSERT INTO itemTypeFields VALUES (9, 27, NULL, 9);
- INSERT INTO itemTypeFields VALUES (9, 22, NULL, 10);
- INSERT INTO itemTypeFields VALUES (10, 14, NULL, 1);
- INSERT INTO itemTypeFields VALUES (10, 20, NULL, 2);
- INSERT INTO itemTypeFields VALUES (10, 19, NULL, 3);
- INSERT INTO itemTypeFields VALUES (10, 18, NULL, 4);
- INSERT INTO itemTypeFields VALUES (10, 17, NULL, 5);
- INSERT INTO itemTypeFields VALUES (10, 2, NULL, 6);
- INSERT INTO itemTypeFields VALUES (10, 1, NULL, 7);
- INSERT INTO itemTypeFields VALUES (10, 27, NULL, 8);
- INSERT INTO itemTypeFields VALUES (10, 22, NULL, 9);
- INSERT INTO itemTypeFields VALUES (11, 21, NULL, 1);
- INSERT INTO itemTypeFields VALUES (11, 14, NULL, 2);
- INSERT INTO itemTypeFields VALUES (11, 18, NULL, 3);
- INSERT INTO itemTypeFields VALUES (11, 17, NULL, 4);
- INSERT INTO itemTypeFields VALUES (11, 2, NULL, 5);
- INSERT INTO itemTypeFields VALUES (11, 1, NULL, 6);
- INSERT INTO itemTypeFields VALUES (11, 27, NULL, 7);
- INSERT INTO itemTypeFields VALUES (11, 22, NULL, 8);
- INSERT INTO itemTypeFields VALUES (12, 24, NULL, 1);
- INSERT INTO itemTypeFields VALUES (12, 14, NULL, 2);
- INSERT INTO itemTypeFields VALUES (12, 18, NULL, 3);
- INSERT INTO itemTypeFields VALUES (12, 17, NULL, 4);
- INSERT INTO itemTypeFields VALUES (12, 2, NULL, 5);
- INSERT INTO itemTypeFields VALUES (12, 1, NULL, 6);
- INSERT INTO itemTypeFields VALUES (12, 27, NULL, 7);
- INSERT INTO itemTypeFields VALUES (12, 22, NULL, 8);
- INSERT INTO itemTypeFields VALUES (13, 14, NULL, 2);
- INSERT INTO itemTypeFields VALUES (13, 1, NULL, 3);
- INSERT INTO itemTypeFields VALUES (13, 27, NULL, 4);
- INSERT INTO itemTypeFields VALUES (13, 2, NULL, 5);
- INSERT INTO itemTypeFields VALUES (13, 22, NULL, 6);
- INSERT INTO itemTypeFields VALUES (14, 27, NULL, 1);
- INSERT INTO itemTypeFields VALUES (14, 1, NULL, 2);
-
INSERT INTO "fileTypes" VALUES(1, 'webpage');
INSERT INTO "fileTypes" VALUES(2, 'image');
INSERT INTO "fileTypes" VALUES(3, 'pdf');
@@ -498,9 +909,3 @@
INSERT INTO "charsets" VALUES(166, 'x-x-big5');
INSERT INTO "charsets" VALUES(167, 'x0201');
INSERT INTO "charsets" VALUES(168, 'x0212');
-
- INSERT INTO "creatorTypes" VALUES(1, "author");
- INSERT INTO "creatorTypes" VALUES(2, "contributor");
- INSERT INTO "creatorTypes" VALUES(3, "editor");
- INSERT INTO "creatorTypes" VALUES(4, "translator");
-
diff --git a/userdata.sql b/userdata.sql
@@ -1,4 +1,4 @@
--- 6
+-- 7
-- This file creates tables containing user-specific data -- any changes
-- to existing tables made here must be mirrored in transition steps in
