coredata.sql

--  ***** BEGIN LICENSE BLOCK *****
--  
--  This file is part of the Zotero Data Server.
--  
--  Copyright © 2010 Center for History and New Media
--                   George Mason University, Fairfax, Virginia, USA
--                   http://zotero.org
--  
--  This program is free software: you can redistribute it and/or modify
--  it under the terms of the GNU Affero General Public License as published by
--  the Free Software Foundation, either version 3 of the License, or
--  (at your option) any later version.
--  
--  This program is distributed in the hope that it will be useful,
--  but WITHOUT ANY WARRANTY; without even the implied warranty of
--  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
--  GNU Affero General Public License for more details.
--  
--  You should have received a copy of the GNU Affero General Public License
--  along with this program.  If not, see <http://www.gnu.org/licenses/>.
--  
--  ***** END LICENSE BLOCK *****

BEGIN;

DELETE FROM charsets;
DELETE FROM itemTypes;
DELETE FROM fields;
DELETE FROM creatorTypes;

INSERT INTO `itemTypes` (`itemTypeID`, `itemTypeName`, `custom`) VALUES
(1, 'note', 0),
(2, 'book', 0),
(3, 'bookSection', 0),
(4, 'journalArticle', 0),
(5, 'magazineArticle', 0),
(6, 'newspaperArticle', 0),
(7, 'thesis', 0),
(8, 'letter', 0),
(9, 'manuscript', 0),
(10, 'interview', 0),
(11, 'film', 0),
(12, 'artwork', 0),
(13, 'webpage', 0),
(14, 'attachment', 0),
(15, 'report', 0),
(16, 'bill', 0),
(17, 'case', 0),
(18, 'hearing', 0),
(19, 'patent', 0),
(20, 'statute', 0),
(21, 'email', 0),
(22, 'map', 0),
(23, 'blogPost', 0),
(24, 'instantMessage', 0),
(25, 'forumPost', 0),
(26, 'audioRecording', 0),
(27, 'presentation', 0),
(28, 'videoRecording', 0),
(29, 'tvBroadcast', 0),
(30, 'radioBroadcast', 0),
(31, 'podcast', 0),
(32, 'computerProgram', 0),
(33, 'conferencePaper', 0),
(34, 'document', 0),
(35, 'encyclopediaArticle', 0),
(36, 'dictionaryEntry', 0),
(37, 'annotation', 0),
(10001, 'nsfReviewer', 1);

INSERT INTO `creatorTypes` (`creatorTypeID`, `creatorTypeName`, `custom`) VALUES
(1, 'author', 0),
(2, 'contributor', 0),
(3, 'editor', 0),
(4, 'translator', 0),
(5, 'seriesEditor', 0),
(6, 'interviewee', 0),
(7, 'interviewer', 0),
(8, 'director', 0),
(9, 'scriptwriter', 0),
(10, 'producer', 0),
(11, 'castMember', 0),
(12, 'sponsor', 0),
(13, 'counsel', 0),
(14, 'inventor', 0),
(15, 'attorneyAgent', 0),
(16, 'recipient', 0),
(17, 'performer', 0),
(18, 'composer', 0),
(19, 'wordsBy', 0),
(20, 'cartographer', 0),
(21, 'programmer', 0),
(22, 'artist', 0),
(23, 'commenter', 0),
(24, 'presenter', 0),
(25, 'guest', 0),
(26, 'podcaster', 0),
(27, 'reviewedAuthor', 0),
(28, 'cosponsor', 0),
(29, 'bookAuthor', 0);


INSERT INTO `fields` (`fieldID`, `fieldName`, `fieldFormatID`, `custom`) VALUES
(1, 'url', NULL, 0),
(2, 'rights', NULL, 0),
(3, 'series', NULL, 0),
(4, 'volume', NULL, 0),
(5, 'issue', NULL, 0),
(6, 'edition', NULL, 0),
(7, 'place', NULL, 0),
(8, 'publisher', NULL, 0),
(10, 'pages', NULL, 0),
(11, 'ISBN', NULL, 0),
(12, 'publicationTitle', NULL, 0),
(13, 'ISSN', NULL, 0),
(14, 'date', NULL, 0),
(15, 'section', NULL, 0),
(18, 'callNumber', NULL, 0),
(19, 'archiveLocation', NULL, 0),
(21, 'distributor', NULL, 0),
(22, 'extra', NULL, 0),
(25, 'journalAbbreviation', NULL, 0),
(26, 'DOI', NULL, 0),
(27, 'accessDate', NULL, 0),
(28, 'seriesTitle', NULL, 0),
(29, 'seriesText', NULL, 0),
(30, 'seriesNumber', NULL, 0),
(31, 'institution', NULL, 0),
(32, 'reportType', NULL, 0),
(36, 'code', NULL, 0),
(40, 'session', NULL, 0),
(41, 'legislativeBody', NULL, 0),
(42, 'history', NULL, 0),
(43, 'reporter', NULL, 0),
(44, 'court', NULL, 0),
(45, 'numberOfVolumes', NULL, 0),
(46, 'committee', NULL, 0),
(48, 'assignee', NULL, 0),
(50, 'patentNumber', NULL, 0),
(51, 'priorityNumbers', NULL, 0),
(52, 'issueDate', NULL, 0),
(53, 'references', NULL, 0),
(54, 'legalStatus', NULL, 0),
(55, 'codeNumber', NULL, 0),
(59, 'artworkMedium', NULL, 0),
(60, 'number', NULL, 0),
(61, 'artworkSize', NULL, 0),
(62, 'libraryCatalog', NULL, 0),
(63, 'videoRecordingFormat', NULL, 0),
(64, 'interviewMedium', NULL, 0),
(65, 'letterType', NULL, 0),
(66, 'manuscriptType', NULL, 0),
(67, 'mapType', NULL, 0),
(68, 'scale', NULL, 0),
(69, 'thesisType', NULL, 0),
(70, 'websiteType', NULL, 0),
(71, 'audioRecordingFormat', NULL, 0),
(72, 'label', NULL, 0),
(74, 'presentationType', NULL, 0),
(75, 'meetingName', NULL, 0),
(76, 'studio', NULL, 0),
(77, 'runningTime', NULL, 0),
(78, 'network', NULL, 0),
(79, 'postType', NULL, 0),
(80, 'audioFileType', NULL, 0),
(81, 'versionNumber', NULL, 0),
(82, 'system', NULL, 0),
(83, 'company', NULL, 0),
(84, 'conferenceName', NULL, 0),
(85, 'encyclopediaTitle', NULL, 0),
(86, 'dictionaryTitle', NULL, 0),
(87, 'language', NULL, 0),
(88, 'programmingLanguage', NULL, 0),
(89, 'university', NULL, 0),
(90, 'abstractNote', NULL, 0),
(91, 'websiteTitle', NULL, 0),
(92, 'reportNumber', NULL, 0),
(93, 'billNumber', NULL, 0),
(94, 'codeVolume', NULL, 0),
(95, 'codePages', NULL, 0),
(96, 'dateDecided', NULL, 0),
(97, 'reporterVolume', NULL, 0),
(98, 'firstPage', NULL, 0),
(99, 'documentNumber', NULL, 0),
(100, 'dateEnacted', NULL, 0),
(101, 'publicLawNumber', NULL, 0),
(102, 'country', NULL, 0),
(103, 'applicationNumber', NULL, 0),
(104, 'forumTitle', NULL, 0),
(105, 'episodeNumber', NULL, 0),
(107, 'blogTitle', NULL, 0),
(108, 'type', NULL, 0),
(109, 'medium', NULL, 0),
(110, 'title', NULL, 0),
(111, 'caseName', NULL, 0),
(112, 'nameOfAct', NULL, 0),
(113, 'subject', NULL, 0),
(114, 'proceedingsTitle', NULL, 0),
(115, 'bookTitle', NULL, 0),
(116, 'shortTitle', NULL, 0),
(117, 'docketNumber', NULL, 0),
(118, 'numPages', NULL, 0),
(119, 'programTitle', NULL, 0),
(120, 'issuingAuthority', NULL, 0),
(121, 'filingDate', NULL, 0),
(122, 'genre', NULL, 0),
(123, 'archive', NULL, 0),
(10001, 'name', NULL, 1),
(10002, 'address', NULL, 1),
(10003, 'telephone', NULL, 1),
(10004, 'email', NULL, 1),
(10005, 'homepage', NULL, 1),
(10006, 'discipline', NULL, 1),
(10007, 'nsfID', NULL, 1),
(10008, 'dateSent', NULL, 1),
(10009, 'dateDue', NULL, 1),
(10010, 'accepted', NULL, 1),
(10011, 'programDirector', NULL, 1);

INSERT INTO `itemTypeCreatorTypes` (`itemTypeID`, `creatorTypeID`, `primaryField`) VALUES
(2, 1, 1),
(2, 2, 0),
(2, 3, 0),
(2, 4, 0),
(2, 5, 0),
(3, 1, 1),
(3, 2, 0),
(3, 3, 0),
(3, 4, 0),
(3, 5, 0),
(3, 29, 0),
(4, 1, 1),
(4, 2, 0),
(4, 3, 0),
(4, 4, 0),
(4, 27, 0),
(5, 1, 1),
(5, 2, 0),
(5, 4, 0),
(5, 27, 0),
(6, 1, 1),
(6, 2, 0),
(6, 4, 0),
(6, 27, 0),
(7, 1, 1),
(7, 2, 0),
(8, 1, 1),
(8, 2, 0),
(8, 16, 0),
(9, 1, 1),
(9, 2, 0),
(9, 4, 0),
(10, 2, 0),
(10, 4, 0),
(10, 6, 1),
(10, 7, 0),
(11, 2, 0),
(11, 8, 1),
(11, 9, 0),
(11, 10, 0),
(12, 2, 0),
(12, 22, 1),
(13, 1, 1),
(13, 2, 0),
(13, 4, 0),
(15, 1, 1),
(15, 2, 0),
(15, 4, 0),
(15, 5, 0),
(16, 2, 0),
(16, 12, 1),
(16, 28, 0),
(17, 1, 1),
(17, 2, 0),
(17, 13, 0),
(18, 2, 1),
(19, 2, 0),
(19, 14, 1),
(19, 15, 0),
(20, 1, 1),
(20, 2, 0),
(21, 1, 1),
(21, 2, 0),
(21, 16, 0),
(22, 2, 0),
(22, 5, 0),
(22, 20, 1),
(23, 1, 1),
(23, 2, 0),
(23, 23, 0),
(24, 1, 1),
(24, 2, 0),
(24, 16, 0),
(25, 1, 1),
(25, 2, 0),
(26, 2, 0),
(26, 17, 1),
(26, 18, 0),
(26, 19, 0),
(27, 2, 0),
(27, 24, 1),
(28, 2, 0),
(28, 8, 1),
(28, 9, 0),
(28, 10, 0),
(28, 11, 0),
(29, 2, 0),
(29, 8, 1),
(29, 9, 0),
(29, 10, 0),
(29, 11, 0),
(29, 25, 0),
(30, 2, 0),
(30, 8, 1),
(30, 9, 0),
(30, 10, 0),
(30, 11, 0),
(30, 25, 0),
(31, 2, 0),
(31, 25, 0),
(31, 26, 1),
(32, 2, 0),
(32, 21, 1),
(33, 1, 1),
(33, 2, 0),
(33, 3, 0),
(33, 4, 0),
(33, 5, 0),
(34, 1, 1),
(34, 2, 0),
(34, 3, 0),
(34, 4, 0),
(34, 27, 0),
(35, 1, 1),
(35, 2, 0),
(35, 3, 0),
(35, 4, 0),
(35, 5, 0),
(36, 1, 1),
(36, 2, 0),
(36, 3, 0),
(36, 4, 0),
(36, 5, 0);

INSERT INTO `itemTypeFields` (`itemTypeID`, `fieldID`, `hide`, `orderIndex`) VALUES
(2, 1, 0, 15),
(2, 2, 0, 21),
(2, 3, 0, 3),
(2, 4, 0, 5),
(2, 6, 0, 7),
(2, 7, 0, 8),
(2, 8, 0, 9),
(2, 11, 0, 13),
(2, 14, 0, 10),
(2, 18, 0, 20),
(2, 19, 0, 18),
(2, 22, 0, 22),
(2, 27, 0, 16),
(2, 30, 0, 4),
(2, 45, 0, 6),
(2, 62, 0, 19),
(2, 87, 0, 12),
(2, 90, 0, 2),
(2, 110, 0, 1),
(2, 116, 0, 14),
(2, 118, 0, 11),
(2, 123, 0, 17),
(3, 1, 0, 16),
(3, 2, 0, 22),
(3, 3, 0, 4),
(3, 4, 0, 6),
(3, 6, 0, 8),
(3, 7, 0, 9),
(3, 8, 0, 10),
(3, 10, 0, 12),
(3, 11, 0, 14),
(3, 14, 0, 11),
(3, 18, 0, 21),
(3, 19, 0, 19),
(3, 22, 0, 23),
(3, 27, 0, 17),
(3, 30, 0, 5),
(3, 45, 0, 7),
(3, 62, 0, 20),
(3, 87, 0, 13),
(3, 90, 0, 2),
(3, 110, 0, 1),
(3, 115, 0, 3),
(3, 116, 0, 15),
(3, 123, 0, 18),
(4, 1, 0, 16),
(4, 2, 0, 22),
(4, 3, 0, 8),
(4, 4, 0, 4),
(4, 5, 0, 5),
(4, 10, 0, 6),
(4, 12, 0, 3),
(4, 13, 0, 14),
(4, 14, 0, 7),
(4, 18, 0, 21),
(4, 19, 0, 19),
(4, 22, 0, 23),
(4, 25, 0, 11),
(4, 26, 0, 13),
(4, 27, 0, 17),
(4, 28, 0, 9),
(4, 29, 0, 10),
(4, 62, 0, 20),
(4, 87, 0, 12),
(4, 90, 0, 2),
(4, 110, 0, 1),
(4, 116, 0, 15),
(4, 123, 0, 18),
(5, 1, 0, 11),
(5, 2, 0, 17),
(5, 4, 0, 4),
(5, 5, 0, 5),
(5, 10, 0, 7),
(5, 12, 0, 3),
(5, 13, 0, 9),
(5, 14, 0, 6),
(5, 18, 0, 16),
(5, 19, 0, 14),
(5, 22, 0, 18),
(5, 27, 0, 12),
(5, 62, 0, 15),
(5, 87, 0, 8),
(5, 90, 0, 2),
(5, 110, 0, 1),
(5, 116, 0, 10),
(5, 123, 0, 13),
(6, 1, 0, 12),
(6, 2, 0, 18),
(6, 6, 0, 5),
(6, 7, 0, 4),
(6, 10, 0, 8),
(6, 12, 0, 3),
(6, 13, 0, 11),
(6, 14, 0, 6),
(6, 15, 0, 7),
(6, 18, 0, 17),
(6, 19, 0, 15),
(6, 22, 0, 19),
(6, 27, 0, 13),
(6, 62, 0, 16),
(6, 87, 0, 9),
(6, 90, 0, 2),
(6, 110, 0, 1),
(6, 116, 0, 10),
(6, 123, 0, 14),
(7, 1, 0, 10),
(7, 2, 0, 16),
(7, 7, 0, 5),
(7, 14, 0, 6),
(7, 18, 0, 15),
(7, 19, 0, 13),
(7, 22, 0, 17),
(7, 27, 0, 11),
(7, 62, 0, 14),
(7, 69, 0, 3),
(7, 87, 0, 8),
(7, 89, 0, 4),
(7, 90, 0, 2),
(7, 110, 0, 1),
(7, 116, 0, 9),
(7, 118, 0, 7),
(7, 123, 0, 12),
(8, 1, 0, 7),
(8, 2, 0, 13),
(8, 14, 0, 4),
(8, 18, 0, 12),
(8, 19, 0, 10),
(8, 22, 0, 14),
(8, 27, 0, 8),
(8, 62, 0, 11),
(8, 65, 0, 3),
(8, 87, 0, 5),
(8, 90, 0, 2),
(8, 110, 0, 1),
(8, 116, 0, 6),
(8, 123, 0, 9),
(9, 1, 0, 9),
(9, 2, 0, 15),
(9, 7, 0, 4),
(9, 14, 0, 5),
(9, 18, 0, 14),
(9, 19, 0, 12),
(9, 22, 0, 16),
(9, 27, 0, 10),
(9, 62, 0, 13),
(9, 66, 0, 3),
(9, 87, 0, 7),
(9, 90, 0, 2),
(9, 110, 0, 1),
(9, 116, 0, 8),
(9, 118, 0, 6),
(9, 123, 0, 11),
(10, 1, 0, 7),
(10, 2, 0, 13),
(10, 14, 0, 3),
(10, 18, 0, 12),
(10, 19, 0, 10),
(10, 22, 0, 14),
(10, 27, 0, 8),
(10, 62, 0, 11),
(10, 64, 0, 4),
(10, 87, 0, 5),
(10, 90, 0, 2),
(10, 110, 0, 1),
(10, 116, 0, 6),
(10, 123, 0, 9),
(11, 1, 0, 10),
(11, 2, 0, 16),
(11, 14, 0, 4),
(11, 18, 0, 15),
(11, 19, 0, 13),
(11, 21, 0, 3),
(11, 22, 0, 17),
(11, 27, 0, 11),
(11, 62, 0, 14),
(11, 63, 0, 6),
(11, 77, 0, 7),
(11, 87, 0, 8),
(11, 90, 0, 2),
(11, 110, 0, 1),
(11, 116, 0, 9),
(11, 122, 0, 5),
(11, 123, 0, 12),
(12, 1, 0, 12),
(12, 2, 0, 14),
(12, 14, 0, 5),
(12, 18, 0, 11),
(12, 19, 0, 9),
(12, 22, 0, 15),
(12, 27, 0, 13),
(12, 59, 0, 3),
(12, 61, 0, 4),
(12, 62, 0, 10),
(12, 87, 0, 6),
(12, 90, 0, 2),
(12, 110, 0, 1),
(12, 116, 0, 7),
(12, 123, 0, 8),
(13, 1, 0, 7),
(13, 2, 0, 10),
(13, 14, 0, 5),
(13, 22, 0, 11),
(13, 27, 0, 8),
(13, 70, 0, 4),
(13, 87, 0, 9),
(13, 90, 0, 2),
(13, 91, 0, 3),
(13, 110, 0, 1),
(13, 116, 0, 6),
(14, 1, 0, 3),
(14, 27, 0, 2),
(14, 110, 0, 1),
(15, 1, 0, 12),
(15, 2, 0, 18),
(15, 7, 0, 6),
(15, 10, 0, 9),
(15, 14, 0, 8),
(15, 18, 0, 17),
(15, 19, 0, 15),
(15, 22, 0, 19),
(15, 27, 0, 13),
(15, 28, 0, 5),
(15, 31, 0, 7),
(15, 32, 0, 4),
(15, 62, 0, 16),
(15, 87, 0, 10),
(15, 90, 0, 2),
(15, 92, 0, 3),
(15, 110, 0, 1),
(15, 116, 0, 11),
(15, 123, 0, 14),
(16, 1, 0, 13),
(16, 2, 0, 16),
(16, 14, 0, 11),
(16, 15, 0, 6),
(16, 22, 0, 17),
(16, 27, 0, 14),
(16, 36, 0, 4),
(16, 40, 0, 9),
(16, 41, 0, 8),
(16, 42, 0, 10),
(16, 87, 0, 12),
(16, 90, 0, 2),
(16, 93, 0, 3),
(16, 94, 0, 5),
(16, 95, 0, 7),
(16, 110, 0, 1),
(16, 116, 0, 15),
(17, 1, 0, 12),
(17, 2, 0, 14),
(17, 22, 0, 15),
(17, 27, 0, 13),
(17, 42, 0, 8),
(17, 43, 0, 3),
(17, 44, 0, 5),
(17, 87, 0, 10),
(17, 90, 0, 2),
(17, 96, 0, 9),
(17, 97, 0, 4),
(17, 98, 0, 7),
(17, 111, 0, 1),
(17, 116, 0, 11),
(17, 117, 0, 6),
(18, 1, 0, 15),
(18, 2, 0, 17),
(18, 7, 0, 4),
(18, 8, 0, 5),
(18, 10, 0, 8),
(18, 14, 0, 12),
(18, 22, 0, 18),
(18, 27, 0, 16),
(18, 40, 0, 10),
(18, 41, 0, 9),
(18, 42, 0, 11),
(18, 45, 0, 6),
(18, 46, 0, 3),
(18, 87, 0, 13),
(18, 90, 0, 2),
(18, 99, 0, 7),
(18, 110, 0, 1),
(18, 116, 0, 14),
(19, 1, 0, 17),
(19, 2, 0, 19),
(19, 7, 0, 3),
(19, 10, 0, 9),
(19, 22, 0, 20),
(19, 27, 0, 18),
(19, 48, 0, 5),
(19, 50, 0, 7),
(19, 51, 0, 11),
(19, 52, 0, 12),
(19, 53, 0, 13),
(19, 54, 0, 14),
(19, 87, 0, 15),
(19, 90, 0, 2),
(19, 102, 0, 4),
(19, 103, 0, 10),
(19, 110, 0, 1),
(19, 116, 0, 16),
(19, 120, 0, 6),
(19, 121, 0, 8),
(20, 1, 0, 13),
(20, 2, 0, 15),
(20, 10, 0, 7),
(20, 15, 0, 8),
(20, 22, 0, 16),
(20, 27, 0, 14),
(20, 36, 0, 3),
(20, 40, 0, 9),
(20, 42, 0, 10),
(20, 55, 0, 4),
(20, 87, 0, 11),
(20, 90, 0, 2),
(20, 100, 0, 6),
(20, 101, 0, 5),
(20, 112, 0, 1),
(20, 116, 0, 12),
(21, 1, 0, 5),
(21, 2, 0, 8),
(21, 14, 0, 3),
(21, 22, 0, 9),
(21, 27, 0, 6),
(21, 87, 0, 7),
(21, 90, 0, 2),
(21, 113, 0, 1),
(21, 116, 0, 4),
(22, 1, 0, 13),
(22, 2, 0, 19),
(22, 6, 0, 6),
(22, 7, 0, 7),
(22, 8, 0, 8),
(22, 11, 0, 11),
(22, 14, 0, 9),
(22, 18, 0, 18),
(22, 19, 0, 16),
(22, 22, 0, 20),
(22, 27, 0, 14),
(22, 28, 0, 5),
(22, 62, 0, 17),
(22, 67, 0, 3),
(22, 68, 0, 4),
(22, 87, 0, 10),
(22, 90, 0, 2),
(22, 110, 0, 1),
(22, 116, 0, 12),
(22, 123, 0, 15),
(23, 1, 0, 6),
(23, 2, 0, 10),
(23, 14, 0, 5),
(23, 22, 0, 11),
(23, 27, 0, 7),
(23, 70, 0, 4),
(23, 87, 0, 8),
(23, 90, 0, 2),
(23, 107, 0, 3),
(23, 110, 0, 1),
(23, 116, 0, 9),
(24, 1, 0, 6),
(24, 2, 0, 8),
(24, 14, 0, 3),
(24, 22, 0, 9),
(24, 27, 0, 7),
(24, 87, 0, 4),
(24, 90, 0, 2),
(24, 110, 0, 1),
(24, 116, 0, 5),
(25, 1, 0, 8),
(25, 2, 0, 10),
(25, 14, 0, 5),
(25, 22, 0, 11),
(25, 27, 0, 9),
(25, 79, 0, 4),
(25, 87, 0, 6),
(25, 90, 0, 2),
(25, 104, 0, 3),
(25, 110, 0, 1),
(25, 116, 0, 7),
(26, 1, 0, 18),
(26, 2, 0, 20),
(26, 4, 0, 5),
(26, 7, 0, 7),
(26, 11, 0, 12),
(26, 14, 0, 9),
(26, 18, 0, 17),
(26, 19, 0, 15),
(26, 22, 0, 21),
(26, 27, 0, 19),
(26, 28, 0, 4),
(26, 45, 0, 6),
(26, 62, 0, 16),
(26, 71, 0, 3),
(26, 72, 0, 8),
(26, 77, 0, 10),
(26, 87, 0, 11),
(26, 90, 0, 2),
(26, 110, 0, 1),
(26, 116, 0, 13),
(26, 123, 0, 14),
(27, 1, 0, 7),
(27, 2, 0, 11),
(27, 7, 0, 5),
(27, 14, 0, 4),
(27, 22, 0, 12),
(27, 27, 0, 8),
(27, 74, 0, 3),
(27, 75, 0, 6),
(27, 87, 0, 9),
(27, 90, 0, 2),
(27, 110, 0, 1),
(27, 116, 0, 10),
(28, 1, 0, 14),
(28, 2, 0, 20),
(28, 4, 0, 5),
(28, 7, 0, 7),
(28, 11, 0, 12),
(28, 14, 0, 9),
(28, 18, 0, 19),
(28, 19, 0, 17),
(28, 22, 0, 21),
(28, 27, 0, 15),
(28, 28, 0, 4),
(28, 45, 0, 6),
(28, 62, 0, 18),
(28, 63, 0, 3),
(28, 76, 0, 8),
(28, 77, 0, 10),
(28, 87, 0, 11),
(28, 90, 0, 2),
(28, 110, 0, 1),
(28, 116, 0, 13),
(28, 123, 0, 16),
(29, 1, 0, 12),
(29, 2, 0, 18),
(29, 7, 0, 6),
(29, 14, 0, 8),
(29, 18, 0, 17),
(29, 19, 0, 15),
(29, 22, 0, 19),
(29, 27, 0, 13),
(29, 62, 0, 16),
(29, 63, 0, 5),
(29, 77, 0, 9),
(29, 78, 0, 7),
(29, 87, 0, 10),
(29, 90, 0, 2),
(29, 105, 0, 4),
(29, 110, 0, 1),
(29, 116, 0, 11),
(29, 119, 0, 3),
(29, 123, 0, 14),
(30, 1, 0, 12),
(30, 2, 0, 18),
(30, 7, 0, 6),
(30, 14, 0, 8),
(30, 18, 0, 17),
(30, 19, 0, 15),
(30, 22, 0, 19),
(30, 27, 0, 13),
(30, 62, 0, 16),
(30, 71, 0, 5),
(30, 77, 0, 9),
(30, 78, 0, 7),
(30, 87, 0, 10),
(30, 90, 0, 2),
(30, 105, 0, 4),
(30, 110, 0, 1),
(30, 116, 0, 11),
(30, 119, 0, 3),
(30, 123, 0, 14),
(31, 1, 0, 7),
(31, 2, 0, 11),
(31, 22, 0, 12),
(31, 27, 0, 8),
(31, 28, 0, 3),
(31, 77, 0, 6),
(31, 80, 0, 5),
(31, 87, 0, 9),
(31, 90, 0, 2),
(31, 105, 0, 4),
(31, 110, 0, 1),
(31, 116, 0, 10),
(32, 1, 0, 12),
(32, 2, 0, 13),
(32, 7, 0, 7),
(32, 11, 0, 10),
(32, 14, 0, 5),
(32, 18, 0, 17),
(32, 19, 0, 15),
(32, 22, 0, 19),
(32, 27, 0, 18),
(32, 28, 0, 3),
(32, 62, 0, 16),
(32, 81, 0, 4),
(32, 82, 0, 6),
(32, 83, 0, 8),
(32, 88, 0, 9),
(32, 90, 0, 2),
(32, 110, 0, 1),
(32, 116, 0, 11),
(32, 123, 0, 14),
(33, 1, 0, 15),
(33, 2, 0, 21),
(33, 3, 0, 10),
(33, 4, 0, 8),
(33, 7, 0, 6),
(33, 8, 0, 7),
(33, 10, 0, 9),
(33, 11, 0, 13),
(33, 14, 0, 3),
(33, 18, 0, 20),
(33, 19, 0, 18),
(33, 22, 0, 22),
(33, 26, 0, 12),
(33, 27, 0, 16),
(33, 62, 0, 19),
(33, 84, 0, 5),
(33, 87, 0, 11),
(33, 90, 0, 2),
(33, 110, 0, 1),
(33, 114, 0, 4),
(33, 116, 0, 14),
(33, 123, 0, 17),
(34, 1, 0, 7),
(34, 2, 0, 13),
(34, 8, 0, 3),
(34, 14, 0, 4),
(34, 18, 0, 12),
(34, 19, 0, 10),
(34, 22, 0, 14),
(34, 27, 0, 8),
(34, 62, 0, 11),
(34, 87, 0, 5),
(34, 90, 0, 2),
(34, 110, 0, 1),
(34, 116, 0, 6),
(34, 123, 0, 9),
(35, 1, 0, 15),
(35, 2, 0, 22),
(35, 3, 0, 4),
(35, 4, 0, 6),
(35, 6, 0, 8),
(35, 7, 0, 9),
(35, 8, 0, 10),
(35, 10, 0, 12),
(35, 11, 0, 13),
(35, 14, 0, 11),
(35, 18, 0, 21),
(35, 19, 0, 19),
(35, 22, 0, 23),
(35, 27, 0, 16),
(35, 30, 0, 5),
(35, 45, 0, 7),
(35, 62, 0, 20),
(35, 85, 0, 3),
(35, 87, 0, 17),
(35, 90, 0, 2),
(35, 110, 0, 1),
(35, 116, 0, 14),
(35, 123, 0, 18),
(36, 1, 0, 16),
(36, 2, 0, 22),
(36, 3, 0, 4),
(36, 4, 0, 6),
(36, 6, 0, 8),
(36, 7, 0, 9),
(36, 8, 0, 10),
(36, 10, 0, 12),
(36, 11, 0, 14),
(36, 14, 0, 11),
(36, 18, 0, 21),
(36, 19, 0, 19),
(36, 22, 0, 23),
(36, 27, 0, 17),
(36, 30, 0, 5),
(36, 45, 0, 7),
(36, 62, 0, 20),
(36, 86, 0, 3),
(36, 87, 0, 13),
(36, 90, 0, 2),
(36, 110, 0, 1),
(36, 116, 0, 15),
(36, 123, 0, 18),
(10001, 31, 0, 4),
(10001, 10001, 0, 1),
(10001, 10002, 0, 2),
(10001, 10003, 0, 3),
(10001, 10004, 0, 5),
(10001, 10005, 0, 6),
(10001, 10006, 0, 7),
(10001, 10007, 0, 8),
(10001, 10008, 0, 9),
(10001, 10009, 0, 10),
(10001, 10010, 0, 11),
(10001, 10011, 0, 12);

INSERT INTO `baseFieldMappings` (`itemTypeID`, `baseFieldID`, `fieldID`) VALUES
(10001, 1, 10005),
(16, 4, 94),
(17, 4, 97),
(7, 8, 89),
(11, 8, 21),
(15, 8, 31),
(26, 8, 72),
(28, 8, 76),
(30, 8, 78),
(32, 8, 83),
(16, 10, 95),
(17, 10, 98),
(3, 12, 115),
(13, 12, 91),
(23, 12, 107),
(25, 12, 104),
(29, 12, 119),
(30, 12, 119),
(33, 12, 114),
(35, 12, 85),
(36, 12, 86),
(17, 14, 96),
(19, 14, 52),
(20, 14, 100),
(10001, 14, 10008),
(15, 60, 92),
(16, 60, 93),
(17, 60, 117),
(18, 60, 99),
(19, 60, 50),
(20, 60, 101),
(29, 60, 105),
(30, 60, 105),
(31, 60, 105),
(7, 108, 69),
(8, 108, 65),
(9, 108, 66),
(11, 108, 122),
(13, 108, 70),
(15, 108, 32),
(22, 108, 67),
(23, 108, 70),
(25, 108, 79),
(27, 108, 74),
(10, 109, 64),
(11, 109, 63),
(12, 109, 59),
(26, 109, 71),
(28, 109, 63),
(29, 109, 63),
(30, 109, 71),
(31, 109, 80),
(17, 110, 111),
(20, 110, 112),
(21, 110, 113),
(10001, 110, 10001);

INSERT INTO `charsets` (`charsetID`, `charset`) VALUES
(50, 'adobe-symbol-encoding'),
(51, 'ansi_x3.4-1968'),
(52, 'ansi_x3.4-1986'),
(2, 'ascii'),
(53, 'big5'),
(54, 'chinese'),
(55, 'cn-big5'),
(56, 'cn-gb'),
(57, 'cn-gb-isoir165'),
(58, 'cp367'),
(59, 'cp819'),
(60, 'cp850'),
(61, 'cp852'),
(62, 'cp855'),
(63, 'cp857'),
(64, 'cp862'),
(65, 'cp864'),
(66, 'cp866'),
(67, 'csascii'),
(68, 'csbig5'),
(69, 'cseuckr'),
(70, 'cseucpkdfmtjapanese'),
(71, 'csgb2312'),
(72, 'cshalfwidthkatakana'),
(73, 'cshppsmath'),
(74, 'csiso103t618bit'),
(75, 'csiso159jisx02121990'),
(76, 'csiso2022jp'),
(77, 'csiso2022jp2'),
(78, 'csiso2022kr'),
(79, 'csiso58gb231280'),
(80, 'csisolatin4'),
(81, 'csisolatincyrillic'),
(82, 'csisolatingreek'),
(83, 'cskoi8r'),
(84, 'csksc56011987'),
(85, 'csshiftjis'),
(86, 'csunicode11'),
(87, 'csunicode11utf7'),
(88, 'csunicodeascii'),
(89, 'csunicodelatin1'),
(90, 'cswindows31latin5'),
(91, 'cyrillic'),
(92, 'ecma-118'),
(93, 'elot_928'),
(94, 'euc-jp'),
(95, 'euc-kr'),
(96, 'extended_unix_code_packed_format_for_japanese'),
(97, 'gb2312'),
(98, 'gb_2312-80'),
(99, 'greek'),
(100, 'greek8'),
(101, 'hz-gb-2312'),
(102, 'ibm367'),
(103, 'ibm819'),
(104, 'ibm850'),
(105, 'ibm852'),
(106, 'ibm855'),
(107, 'ibm857'),
(108, 'ibm862'),
(109, 'ibm864'),
(110, 'ibm866'),
(111, 'iso-10646'),
(112, 'iso-10646-j-1'),
(113, 'iso-10646-ucs-2'),
(114, 'iso-10646-ucs-4'),
(115, 'iso-10646-ucs-basic'),
(116, 'iso-10646-unicode-latin1'),
(117, 'iso-2022-jp'),
(118, 'iso-2022-jp-2'),
(119, 'iso-2022-kr'),
(25, 'iso-8859-1'),
(26, 'iso-8859-1-windows-3.0-latin-1'),
(27, 'iso-8859-1-windows-3.1-latin-1'),
(28, 'iso-8859-15'),
(29, 'iso-8859-2'),
(30, 'iso-8859-2-windows-latin-2'),
(31, 'iso-8859-3'),
(32, 'iso-8859-4'),
(33, 'iso-8859-5'),
(34, 'iso-8859-5-windows-latin-5'),
(35, 'iso-8859-6'),
(36, 'iso-8859-7'),
(37, 'iso-8859-8'),
(38, 'iso-8859-9'),
(120, 'iso-ir-100'),
(121, 'iso-ir-101'),
(122, 'iso-ir-103'),
(123, 'iso-ir-110'),
(124, 'iso-ir-126'),
(125, 'iso-ir-144'),
(126, 'iso-ir-149'),
(127, 'iso-ir-159'),
(128, 'iso-ir-58'),
(129, 'iso-ir-6'),
(130, 'iso646-us'),
(12, 'iso8859-1'),
(13, 'iso8859-15'),
(14, 'iso_646.irv:1991'),
(15, 'iso_8859-1'),
(16, 'iso_8859-1:1987'),
(17, 'iso_8859-2'),
(18, 'iso_8859-2:1987'),
(19, 'iso_8859-4'),
(20, 'iso_8859-4:1988'),
(21, 'iso_8859-5'),
(22, 'iso_8859-5:1988'),
(23, 'iso_8859-7'),
(24, 'iso_8859-7:1987'),
(131, 'jis_x0201'),
(132, 'jis_x0208-1983'),
(133, 'jis_x0212-1990'),
(134, 'koi8-r'),
(135, 'korean'),
(139, 'ksc5601'),
(140, 'ksc_5601'),
(136, 'ks_c_5601'),
(137, 'ks_c_5601-1987'),
(138, 'ks_c_5601-1989'),
(39, 'l1'),
(40, 'l2'),
(41, 'l4'),
(42, 'latin1'),
(43, 'latin2'),
(44, 'latin4'),
(141, 'ms_kanji'),
(142, 'shift_jis'),
(143, 't.61'),
(144, 't.61-8bit'),
(145, 'unicode-1-1-utf-7'),
(146, 'unicode-1-1-utf-8'),
(147, 'unicode-2-0-utf-7'),
(9, 'us'),
(10, 'us-ascii'),
(11, 'utf-7'),
(1, 'utf-8'),
(3, 'windows-1250'),
(4, 'windows-1251'),
(5, 'windows-1252'),
(6, 'windows-1253'),
(7, 'windows-1254'),
(8, 'windows-1257'),
(148, 'windows-31j'),
(149, 'x-cns11643-1'),
(150, 'x-cns11643-1110'),
(151, 'x-cns11643-2'),
(152, 'x-cp1250'),
(153, 'x-cp1251'),
(154, 'x-cp1253'),
(155, 'x-dectech'),
(156, 'x-dingbats'),
(157, 'x-euc-jp'),
(158, 'x-euc-tw'),
(159, 'x-gb2312-11'),
(160, 'x-imap4-modified-utf7'),
(161, 'x-jisx0208-11'),
(162, 'x-ksc5601-11'),
(45, 'x-mac-ce'),
(46, 'x-mac-cyrillic'),
(47, 'x-mac-greek'),
(48, 'x-mac-roman'),
(49, 'x-mac-turkish'),
(163, 'x-sjis'),
(164, 'x-tis620'),
(165, 'x-unicode-2-0-utf-7'),
(166, 'x-x-big5'),
(167, 'x0201'),
(168, 'x0212');


COMMIT;