system.sql (61660B)
1 -- 32 2 3 -- Copyright (c) 2009 Center for History and New Media 4 -- George Mason University, Fairfax, Virginia, USA 5 -- http://zotero.org 6 -- 7 -- This file is part of Zotero. 8 -- 9 -- Zotero is free software: you can redistribute it and/or modify 10 -- it under the terms of the GNU Affero General Public License as published by 11 -- the Free Software Foundation, either version 3 of the License, or 12 -- (at your option) any later version. 13 -- 14 -- Zotero is distributed in the hope that it will be useful, 15 -- but WITHOUT ANY WARRANTY; without even the implied warranty of 16 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 17 -- GNU Affero General Public License for more details. 18 -- 19 -- You should have received a copy of the GNU Affero General Public License 20 -- along with Zotero. If not, see <http://www.gnu.org/licenses/>. 21 22 23 -- This file creates system tables that can be safely wiped and reinitialized 24 -- at any time, as long as existing ids are preserved. 25 26 -- Valid item types ("book," "journalArticle," etc.) 27 DROP TABLE IF EXISTS itemTypes; 28 CREATE TABLE itemTypes ( 29 itemTypeID INTEGER PRIMARY KEY, 30 typeName TEXT, 31 templateItemTypeID INT, 32 display INT DEFAULT 1 -- 0 == hide, 1 == display, 2 == primary 33 ); 34 35 -- Populated at startup from itemTypes and customItemTypes 36 DROP TABLE IF EXISTS itemTypesCombined; 37 CREATE TABLE itemTypesCombined ( 38 itemTypeID INT NOT NULL, 39 typeName TEXT NOT NULL, 40 display INT DEFAULT 1 NOT NULL, 41 custom INT NOT NULL, 42 PRIMARY KEY (itemTypeID) 43 ); 44 45 -- Describes various types of fields and their format restrictions, 46 -- and indicates whether data should be stored as strings or integers 47 -- 48 -- unused 49 DROP TABLE IF EXISTS fieldFormats; 50 CREATE TABLE fieldFormats ( 51 fieldFormatID INTEGER PRIMARY KEY, 52 regex TEXT, 53 isInteger INT 54 ); 55 56 -- Field types for item metadata 57 DROP TABLE IF EXISTS fields; 58 CREATE TABLE fields ( 59 fieldID INTEGER PRIMARY KEY, 60 fieldName TEXT, 61 fieldFormatID INT, 62 FOREIGN KEY (fieldFormatID) REFERENCES fieldFormats(fieldFormatID) 63 ); 64 65 -- Populated at startup from fields and customFields 66 DROP TABLE IF EXISTS fieldsCombined; 67 CREATE TABLE fieldsCombined ( 68 fieldID INT NOT NULL, 69 fieldName TEXT NOT NULL, 70 label TEXT, 71 fieldFormatID INT, 72 custom INT NOT NULL, 73 PRIMARY KEY (fieldID) 74 ); 75 76 -- Defines valid fields for each itemType, their display order, and their default visibility 77 DROP TABLE IF EXISTS itemTypeFields; 78 CREATE TABLE itemTypeFields ( 79 itemTypeID INT, 80 fieldID INT, 81 hide INT, 82 orderIndex INT, 83 PRIMARY KEY (itemTypeID, orderIndex), 84 UNIQUE (itemTypeID, fieldID), 85 FOREIGN KEY (itemTypeID) REFERENCES itemTypes(itemTypeID), 86 FOREIGN KEY (fieldID) REFERENCES fields(fieldID) 87 ); 88 CREATE INDEX itemTypeFields_fieldID ON itemTypeFields(fieldID); 89 90 -- Populated at startup from itemTypeFields and customItemTypeFields 91 DROP TABLE IF EXISTS itemTypeFieldsCombined; 92 CREATE TABLE itemTypeFieldsCombined ( 93 itemTypeID INT NOT NULL, 94 fieldID INT NOT NULL, 95 hide INT, 96 orderIndex INT NOT NULL, 97 PRIMARY KEY (itemTypeID, orderIndex), 98 UNIQUE (itemTypeID, fieldID) 99 ); 100 CREATE INDEX itemTypeFieldsCombined_fieldID ON itemTypeFieldsCombined(fieldID); 101 102 -- Maps base fields to type-specific fields (e.g. publisher to label in audioRecording) 103 DROP TABLE IF EXISTS baseFieldMappings; 104 CREATE TABLE baseFieldMappings ( 105 itemTypeID INT, 106 baseFieldID INT, 107 fieldID INT, 108 PRIMARY KEY (itemTypeID, baseFieldID, fieldID), 109 FOREIGN KEY (itemTypeID) REFERENCES itemTypes(itemTypeID), 110 FOREIGN KEY (baseFieldID) REFERENCES fields(fieldID), 111 FOREIGN KEY (fieldID) REFERENCES fields(fieldID) 112 ); 113 CREATE INDEX baseFieldMappings_baseFieldID ON baseFieldMappings(baseFieldID); 114 CREATE INDEX baseFieldMappings_fieldID ON baseFieldMappings(fieldID); 115 116 -- Populated at startup from baseFieldMappings and customBaseFieldMappings 117 DROP TABLE IF EXISTS baseFieldMappingsCombined; 118 CREATE TABLE baseFieldMappingsCombined ( 119 itemTypeID INT, 120 baseFieldID INT, 121 fieldID INT, 122 PRIMARY KEY (itemTypeID, baseFieldID, fieldID) 123 ); 124 CREATE INDEX baseFieldMappingsCombined_baseFieldID ON baseFieldMappingsCombined(baseFieldID); 125 CREATE INDEX baseFieldMappingsCombined_fieldID ON baseFieldMappingsCombined(fieldID); 126 127 DROP TABLE IF EXISTS charsets; 128 CREATE TABLE charsets ( 129 charsetID INTEGER PRIMARY KEY, 130 charset TEXT UNIQUE 131 ); 132 CREATE INDEX charsets_charset ON charsets(charset); 133 134 DROP TABLE IF EXISTS fileTypes; 135 CREATE TABLE fileTypes ( 136 fileTypeID INTEGER PRIMARY KEY, 137 fileType TEXT UNIQUE 138 ); 139 CREATE INDEX fileTypes_fileType ON fileTypes(fileType); 140 141 DROP TABLE IF EXISTS fileTypeMimeTypes; 142 CREATE TABLE fileTypeMimeTypes ( 143 fileTypeID INT, 144 mimeType TEXT, 145 PRIMARY KEY (fileTypeID, mimeType), 146 FOREIGN KEY (fileTypeID) REFERENCES fileTypes(fileTypeID) 147 ); 148 CREATE INDEX fileTypeMimeTypes_mimeType ON fileTypeMimeTypes(mimeType); 149 150 -- Defines the possible creator types (contributor, editor, author) 151 DROP TABLE IF EXISTS creatorTypes; 152 CREATE TABLE creatorTypes ( 153 creatorTypeID INTEGER PRIMARY KEY, 154 creatorType TEXT 155 ); 156 157 DROP TABLE IF EXISTS itemTypeCreatorTypes; 158 CREATE TABLE itemTypeCreatorTypes ( 159 itemTypeID INT, 160 creatorTypeID INT, 161 primaryField INT, 162 PRIMARY KEY (itemTypeID, creatorTypeID), 163 FOREIGN KEY (itemTypeID) REFERENCES itemTypes(itemTypeID), 164 FOREIGN KEY (creatorTypeID) REFERENCES creatorTypes(creatorTypeID) 165 ); 166 CREATE INDEX itemTypeCreatorTypes_creatorTypeID ON itemTypeCreatorTypes(creatorTypeID); 167 168 DROP TABLE IF EXISTS syncObjectTypes; 169 CREATE TABLE syncObjectTypes ( 170 syncObjectTypeID INTEGER PRIMARY KEY, 171 name TEXT 172 ); 173 CREATE INDEX syncObjectTypes_name ON syncObjectTypes(name); 174 175 DROP TABLE IF EXISTS transactionSets; 176 CREATE TABLE transactionSets ( 177 transactionSetID INTEGER PRIMARY KEY, 178 event TEXT, 179 id INT 180 ); 181 182 DROP TABLE IF EXISTS transactions; 183 CREATE TABLE transactions ( 184 transactionID INTEGER PRIMARY KEY, 185 transactionSetID INT, 186 context TEXT, 187 action TEXT 188 ); 189 CREATE INDEX transactions_transactionSetID ON transactions(transactionSetID); 190 191 DROP TABLE IF EXISTS transactionLog; 192 CREATE TABLE transactionLog ( 193 transactionID INT, 194 field TEXT, 195 value NONE, 196 PRIMARY KEY (transactionID, field, value), 197 FOREIGN KEY (transactionID) REFERENCES transactions(transactionID) 198 ); 199 200 -- unused 201 INSERT INTO "fieldFormats" VALUES(1, '.*', 0); 202 INSERT INTO "fieldFormats" VALUES(2, '[0-9]*', 1); 203 INSERT INTO "fieldFormats" VALUES(3, '[0-9]{4}', 1); 204 205 INSERT INTO itemTypes VALUES (1,'note',NULL,0); 206 INSERT INTO itemTypes VALUES (2,'book',NULL,2); 207 INSERT INTO itemTypes VALUES (3,'bookSection',2,2); 208 INSERT INTO itemTypes VALUES (4,'journalArticle',NULL,2); 209 INSERT INTO itemTypes VALUES (5,'magazineArticle',NULL,2); 210 INSERT INTO itemTypes VALUES (6,'newspaperArticle',NULL,2); 211 INSERT INTO itemTypes VALUES (7,'thesis',NULL,1); 212 INSERT INTO itemTypes VALUES (8,'letter',NULL,1); 213 INSERT INTO itemTypes VALUES (9,'manuscript',NULL,1); 214 INSERT INTO itemTypes VALUES (10,'interview',NULL,1); 215 INSERT INTO itemTypes VALUES (11,'film',NULL,1); 216 INSERT INTO itemTypes VALUES (12,'artwork',NULL,1); 217 INSERT INTO itemTypes VALUES (13,'webpage',NULL,0); 218 INSERT INTO itemTypes VALUES (14,'attachment',NULL,0); 219 INSERT INTO itemTypes VALUES (15,'report',NULL,1); 220 INSERT INTO itemTypes VALUES (16,'bill',NULL,1); 221 INSERT INTO itemTypes VALUES (17,'case',NULL,1); 222 INSERT INTO itemTypes VALUES (18,'hearing',NULL,1); 223 INSERT INTO itemTypes VALUES (19,'patent',NULL,1); 224 INSERT INTO itemTypes VALUES (20,'statute',NULL,1); 225 INSERT INTO itemTypes VALUES (21,'email',NULL,1); 226 INSERT INTO itemTypes VALUES (22,'map',NULL,1); 227 INSERT INTO itemTypes VALUES (23,'blogPost',NULL,1); 228 INSERT INTO itemTypes VALUES (24,'instantMessage',NULL,1); 229 INSERT INTO itemTypes VALUES (25,'forumPost',NULL,1); 230 INSERT INTO itemTypes VALUES (26,'audioRecording',NULL,1); 231 INSERT INTO itemTypes VALUES (27,'presentation',NULL,1); 232 INSERT INTO itemTypes VALUES (28,'videoRecording',NULL,1); 233 INSERT INTO itemTypes VALUES (29,'tvBroadcast',NULL,1); 234 INSERT INTO itemTypes VALUES (30,'radioBroadcast',NULL,1); 235 INSERT INTO itemTypes VALUES (31,'podcast',NULL,1); 236 INSERT INTO itemTypes VALUES (32,'computerProgram',NULL,1); 237 INSERT INTO itemTypes VALUES (33,'conferencePaper',NULL,1); 238 INSERT INTO itemTypes VALUES (34,'document',NULL,2); 239 INSERT INTO itemTypes VALUES (35,'encyclopediaArticle',NULL,1); 240 INSERT INTO itemTypes VALUES (36,'dictionaryEntry',NULL,1); 241 242 INSERT INTO fields VALUES (1,'url',NULL); 243 INSERT INTO fields VALUES (2,'rights',NULL); 244 INSERT INTO fields VALUES (3,'series',NULL); 245 INSERT INTO fields VALUES (4,'volume',NULL); 246 INSERT INTO fields VALUES (5,'issue',NULL); 247 INSERT INTO fields VALUES (6,'edition',NULL); 248 INSERT INTO fields VALUES (7,'place',NULL); 249 INSERT INTO fields VALUES (8,'publisher',NULL); 250 INSERT INTO fields VALUES (10,'pages',NULL); 251 INSERT INTO fields VALUES (11,'ISBN',NULL); 252 INSERT INTO fields VALUES (12,'publicationTitle',NULL); 253 INSERT INTO fields VALUES (13,'ISSN',NULL); 254 INSERT INTO fields VALUES (14,'date',NULL); 255 INSERT INTO fields VALUES (15,'section',NULL); 256 INSERT INTO fields VALUES (18,'callNumber',NULL); 257 INSERT INTO fields VALUES (19,'archiveLocation',NULL); 258 INSERT INTO fields VALUES (21,'distributor',NULL); 259 INSERT INTO fields VALUES (22,'extra',NULL); 260 INSERT INTO fields VALUES (25,'journalAbbreviation',NULL); 261 INSERT INTO fields VALUES (26,'DOI',NULL); 262 INSERT INTO fields VALUES (27,'accessDate',NULL); 263 INSERT INTO fields VALUES (28,'seriesTitle',NULL); 264 INSERT INTO fields VALUES (29,'seriesText',NULL); 265 INSERT INTO fields VALUES (30,'seriesNumber',NULL); 266 INSERT INTO fields VALUES (31,'institution',NULL); 267 INSERT INTO fields VALUES (32,'reportType',NULL); 268 INSERT INTO fields VALUES (36,'code',NULL); 269 INSERT INTO fields VALUES (40,'session',NULL); 270 INSERT INTO fields VALUES (41,'legislativeBody',NULL); 271 INSERT INTO fields VALUES (42,'history',NULL); 272 INSERT INTO fields VALUES (43,'reporter',NULL); 273 INSERT INTO fields VALUES (44,'court',NULL); 274 INSERT INTO fields VALUES (45,'numberOfVolumes',NULL); 275 INSERT INTO fields VALUES (46,'committee',NULL); 276 INSERT INTO fields VALUES (48,'assignee',NULL); 277 INSERT INTO fields VALUES (50,'patentNumber',NULL); 278 INSERT INTO fields VALUES (51,'priorityNumbers',NULL); 279 INSERT INTO fields VALUES (52,'issueDate',NULL); 280 INSERT INTO fields VALUES (53,'references',NULL); 281 INSERT INTO fields VALUES (54,'legalStatus',NULL); 282 INSERT INTO fields VALUES (55,'codeNumber',NULL); 283 INSERT INTO fields VALUES (59,'artworkMedium',NULL); 284 INSERT INTO fields VALUES (60,'number',NULL); 285 INSERT INTO fields VALUES (61,'artworkSize',NULL); 286 INSERT INTO fields VALUES (62,'libraryCatalog',NULL); 287 INSERT INTO fields VALUES (63,'videoRecordingFormat',NULL); 288 INSERT INTO fields VALUES (64,'interviewMedium',NULL); 289 INSERT INTO fields VALUES (65,'letterType',NULL); 290 INSERT INTO fields VALUES (66,'manuscriptType',NULL); 291 INSERT INTO fields VALUES (67,'mapType',NULL); 292 INSERT INTO fields VALUES (68,'scale',NULL); 293 INSERT INTO fields VALUES (69,'thesisType',NULL); 294 INSERT INTO fields VALUES (70,'websiteType',NULL); 295 INSERT INTO fields VALUES (71,'audioRecordingFormat',NULL); 296 INSERT INTO fields VALUES (72,'label',NULL); 297 INSERT INTO fields VALUES (74,'presentationType',NULL); 298 INSERT INTO fields VALUES (75,'meetingName',NULL); 299 INSERT INTO fields VALUES (76,'studio',NULL); 300 INSERT INTO fields VALUES (77,'runningTime',NULL); 301 INSERT INTO fields VALUES (78,'network',NULL); 302 INSERT INTO fields VALUES (79,'postType',NULL); 303 INSERT INTO fields VALUES (80,'audioFileType',NULL); 304 INSERT INTO fields VALUES (81,'versionNumber',NULL); 305 INSERT INTO fields VALUES (82,'system',NULL); 306 INSERT INTO fields VALUES (83,'company',NULL); 307 INSERT INTO fields VALUES (84,'conferenceName',NULL); 308 INSERT INTO fields VALUES (85,'encyclopediaTitle',NULL); 309 INSERT INTO fields VALUES (86,'dictionaryTitle',NULL); 310 INSERT INTO fields VALUES (87,'language',NULL); 311 INSERT INTO fields VALUES (88,'programmingLanguage',NULL); 312 INSERT INTO fields VALUES (89,'university',NULL); 313 INSERT INTO fields VALUES (90,'abstractNote',NULL); 314 INSERT INTO fields VALUES (91,'websiteTitle',NULL); 315 INSERT INTO fields VALUES (92,'reportNumber',NULL); 316 INSERT INTO fields VALUES (93,'billNumber',NULL); 317 INSERT INTO fields VALUES (94,'codeVolume',NULL); 318 INSERT INTO fields VALUES (95,'codePages',NULL); 319 INSERT INTO fields VALUES (96,'dateDecided',NULL); 320 INSERT INTO fields VALUES (97,'reporterVolume',NULL); 321 INSERT INTO fields VALUES (98,'firstPage',NULL); 322 INSERT INTO fields VALUES (99,'documentNumber',NULL); 323 INSERT INTO fields VALUES (100,'dateEnacted',NULL); 324 INSERT INTO fields VALUES (101,'publicLawNumber',NULL); 325 INSERT INTO fields VALUES (102,'country',NULL); 326 INSERT INTO fields VALUES (103,'applicationNumber',NULL); 327 INSERT INTO fields VALUES (104,'forumTitle',NULL); 328 INSERT INTO fields VALUES (105,'episodeNumber',NULL); 329 INSERT INTO fields VALUES (107,'blogTitle',NULL); 330 INSERT INTO fields VALUES (108,'type',NULL); 331 INSERT INTO fields VALUES (109,'medium',NULL); 332 INSERT INTO fields VALUES (110,'title',NULL); 333 INSERT INTO fields VALUES (111,'caseName',NULL); 334 INSERT INTO fields VALUES (112,'nameOfAct',NULL); 335 INSERT INTO fields VALUES (113,'subject',NULL); 336 INSERT INTO fields VALUES (114,'proceedingsTitle',NULL); 337 INSERT INTO fields VALUES (115,'bookTitle',NULL); 338 INSERT INTO fields VALUES (116,'shortTitle',NULL); 339 INSERT INTO fields VALUES (117,'docketNumber',NULL); 340 INSERT INTO fields VALUES (118,'numPages',NULL); 341 INSERT INTO fields VALUES (119,'programTitle',NULL); 342 INSERT INTO fields VALUES (120,'issuingAuthority',NULL); 343 INSERT INTO fields VALUES (121,'filingDate',NULL); 344 INSERT INTO fields VALUES (122,'genre',NULL); 345 INSERT INTO fields VALUES (123,'archive',NULL); 346 347 INSERT INTO itemTypeFields VALUES (2, 110, NULL, 1); 348 INSERT INTO itemTypeFields VALUES (2, 90, NULL, 2); 349 INSERT INTO itemTypeFields VALUES (2, 3, NULL, 3); 350 INSERT INTO itemTypeFields VALUES (2, 30, NULL, 4); 351 INSERT INTO itemTypeFields VALUES (2, 4, NULL, 5); 352 INSERT INTO itemTypeFields VALUES (2, 45, NULL, 6); 353 INSERT INTO itemTypeFields VALUES (2, 6, NULL, 7); 354 INSERT INTO itemTypeFields VALUES (2, 7, NULL, 8); 355 INSERT INTO itemTypeFields VALUES (2, 8, NULL, 9); 356 INSERT INTO itemTypeFields VALUES (2, 14, NULL, 10); 357 INSERT INTO itemTypeFields VALUES (2, 118, NULL, 11); 358 INSERT INTO itemTypeFields VALUES (2, 87, NULL, 12); 359 INSERT INTO itemTypeFields VALUES (2, 11, NULL, 13); 360 INSERT INTO itemTypeFields VALUES (2, 116, NULL, 14); 361 INSERT INTO itemTypeFields VALUES (2, 1, NULL, 15); 362 INSERT INTO itemTypeFields VALUES (2, 27, NULL, 16); 363 INSERT INTO itemTypeFields VALUES (2, 123, NULL, 17); 364 INSERT INTO itemTypeFields VALUES (2, 19, NULL, 18); 365 INSERT INTO itemTypeFields VALUES (2, 62, NULL, 19); 366 INSERT INTO itemTypeFields VALUES (2, 18, NULL, 20); 367 INSERT INTO itemTypeFields VALUES (2, 2, NULL, 21); 368 INSERT INTO itemTypeFields VALUES (2, 22, NULL, 22); 369 INSERT INTO itemTypeFields VALUES (3, 110, NULL, 1); 370 INSERT INTO itemTypeFields VALUES (3, 90, NULL, 2); 371 INSERT INTO itemTypeFields VALUES (3, 115, NULL, 3); 372 INSERT INTO itemTypeFields VALUES (3, 3, NULL, 4); 373 INSERT INTO itemTypeFields VALUES (3, 30, NULL, 5); 374 INSERT INTO itemTypeFields VALUES (3, 4, NULL, 6); 375 INSERT INTO itemTypeFields VALUES (3, 45, NULL, 7); 376 INSERT INTO itemTypeFields VALUES (3, 6, NULL, 8); 377 INSERT INTO itemTypeFields VALUES (3, 7, NULL, 9); 378 INSERT INTO itemTypeFields VALUES (3, 8, NULL, 10); 379 INSERT INTO itemTypeFields VALUES (3, 14, NULL, 11); 380 INSERT INTO itemTypeFields VALUES (3, 10, NULL, 12); 381 INSERT INTO itemTypeFields VALUES (3, 87, NULL, 13); 382 INSERT INTO itemTypeFields VALUES (3, 11, NULL, 14); 383 INSERT INTO itemTypeFields VALUES (3, 116, NULL, 15); 384 INSERT INTO itemTypeFields VALUES (3, 1, NULL, 16); 385 INSERT INTO itemTypeFields VALUES (3, 27, NULL, 17); 386 INSERT INTO itemTypeFields VALUES (3, 123, NULL, 18); 387 INSERT INTO itemTypeFields VALUES (3, 19, NULL, 19); 388 INSERT INTO itemTypeFields VALUES (3, 62, NULL, 20); 389 INSERT INTO itemTypeFields VALUES (3, 18, NULL, 21); 390 INSERT INTO itemTypeFields VALUES (3, 2, NULL, 22); 391 INSERT INTO itemTypeFields VALUES (3, 22, NULL, 23); 392 INSERT INTO itemTypeFields VALUES (4, 110, NULL, 1); 393 INSERT INTO itemTypeFields VALUES (4, 90, NULL, 2); 394 INSERT INTO itemTypeFields VALUES (4, 12, NULL, 3); 395 INSERT INTO itemTypeFields VALUES (4, 4, NULL, 4); 396 INSERT INTO itemTypeFields VALUES (4, 5, NULL, 5); 397 INSERT INTO itemTypeFields VALUES (4, 10, NULL, 6); 398 INSERT INTO itemTypeFields VALUES (4, 14, NULL, 7); 399 INSERT INTO itemTypeFields VALUES (4, 3, NULL, 8); 400 INSERT INTO itemTypeFields VALUES (4, 28, NULL, 9); 401 INSERT INTO itemTypeFields VALUES (4, 29, NULL, 10); 402 INSERT INTO itemTypeFields VALUES (4, 25, NULL, 11); 403 INSERT INTO itemTypeFields VALUES (4, 87, NULL, 12); 404 INSERT INTO itemTypeFields VALUES (4, 26, NULL, 13); 405 INSERT INTO itemTypeFields VALUES (4, 13, NULL, 14); 406 INSERT INTO itemTypeFields VALUES (4, 116, NULL, 15); 407 INSERT INTO itemTypeFields VALUES (4, 1, NULL, 16); 408 INSERT INTO itemTypeFields VALUES (4, 27, NULL, 17); 409 INSERT INTO itemTypeFields VALUES (4, 123, NULL, 18); 410 INSERT INTO itemTypeFields VALUES (4, 19, NULL, 19); 411 INSERT INTO itemTypeFields VALUES (4, 62, NULL, 20); 412 INSERT INTO itemTypeFields VALUES (4, 18, NULL, 21); 413 INSERT INTO itemTypeFields VALUES (4, 2, NULL, 22); 414 INSERT INTO itemTypeFields VALUES (4, 22, NULL, 23); 415 INSERT INTO itemTypeFields VALUES (5, 110, NULL, 1); 416 INSERT INTO itemTypeFields VALUES (5, 90, NULL, 2); 417 INSERT INTO itemTypeFields VALUES (5, 12, NULL, 3); 418 INSERT INTO itemTypeFields VALUES (5, 4, NULL, 4); 419 INSERT INTO itemTypeFields VALUES (5, 5, NULL, 5); 420 INSERT INTO itemTypeFields VALUES (5, 14, NULL, 6); 421 INSERT INTO itemTypeFields VALUES (5, 10, NULL, 7); 422 INSERT INTO itemTypeFields VALUES (5, 87, NULL, 8); 423 INSERT INTO itemTypeFields VALUES (5, 13, NULL, 9); 424 INSERT INTO itemTypeFields VALUES (5, 116, NULL, 10); 425 INSERT INTO itemTypeFields VALUES (5, 1, NULL, 11); 426 INSERT INTO itemTypeFields VALUES (5, 27, NULL, 12); 427 INSERT INTO itemTypeFields VALUES (5, 123, NULL, 13); 428 INSERT INTO itemTypeFields VALUES (5, 19, NULL, 14); 429 INSERT INTO itemTypeFields VALUES (5, 62, NULL, 15); 430 INSERT INTO itemTypeFields VALUES (5, 18, NULL, 16); 431 INSERT INTO itemTypeFields VALUES (5, 2, NULL, 17); 432 INSERT INTO itemTypeFields VALUES (5, 22, NULL, 18); 433 INSERT INTO itemTypeFields VALUES (6, 110, NULL, 1); 434 INSERT INTO itemTypeFields VALUES (6, 90, NULL, 2); 435 INSERT INTO itemTypeFields VALUES (6, 12, NULL, 3); 436 INSERT INTO itemTypeFields VALUES (6, 7, NULL, 4); 437 INSERT INTO itemTypeFields VALUES (6, 6, NULL, 5); 438 INSERT INTO itemTypeFields VALUES (6, 14, NULL, 6); 439 INSERT INTO itemTypeFields VALUES (6, 15, NULL, 7); 440 INSERT INTO itemTypeFields VALUES (6, 10, NULL, 8); 441 INSERT INTO itemTypeFields VALUES (6, 87, NULL, 9); 442 INSERT INTO itemTypeFields VALUES (6, 116, NULL, 10); 443 INSERT INTO itemTypeFields VALUES (6, 13, NULL, 11); 444 INSERT INTO itemTypeFields VALUES (6, 1, NULL, 12); 445 INSERT INTO itemTypeFields VALUES (6, 27, NULL, 13); 446 INSERT INTO itemTypeFields VALUES (6, 123, NULL, 14); 447 INSERT INTO itemTypeFields VALUES (6, 19, NULL, 15); 448 INSERT INTO itemTypeFields VALUES (6, 62, NULL, 16); 449 INSERT INTO itemTypeFields VALUES (6, 18, NULL, 17); 450 INSERT INTO itemTypeFields VALUES (6, 2, NULL, 18); 451 INSERT INTO itemTypeFields VALUES (6, 22, NULL, 19); 452 INSERT INTO itemTypeFields VALUES (7, 110, NULL, 1); 453 INSERT INTO itemTypeFields VALUES (7, 90, NULL, 2); 454 INSERT INTO itemTypeFields VALUES (7, 69, NULL, 3); 455 INSERT INTO itemTypeFields VALUES (7, 89, NULL, 4); 456 INSERT INTO itemTypeFields VALUES (7, 7, NULL, 5); 457 INSERT INTO itemTypeFields VALUES (7, 14, NULL, 6); 458 INSERT INTO itemTypeFields VALUES (7, 118, NULL, 7); 459 INSERT INTO itemTypeFields VALUES (7, 87, NULL, 8); 460 INSERT INTO itemTypeFields VALUES (7, 116, NULL, 9); 461 INSERT INTO itemTypeFields VALUES (7, 1, NULL, 10); 462 INSERT INTO itemTypeFields VALUES (7, 27, NULL, 11); 463 INSERT INTO itemTypeFields VALUES (7, 123, NULL, 12); 464 INSERT INTO itemTypeFields VALUES (7, 19, NULL, 13); 465 INSERT INTO itemTypeFields VALUES (7, 62, NULL, 14); 466 INSERT INTO itemTypeFields VALUES (7, 18, NULL, 15); 467 INSERT INTO itemTypeFields VALUES (7, 2, NULL, 16); 468 INSERT INTO itemTypeFields VALUES (7, 22, NULL, 17); 469 INSERT INTO itemTypeFields VALUES (8, 110, NULL, 1); 470 INSERT INTO itemTypeFields VALUES (8, 90, NULL, 2); 471 INSERT INTO itemTypeFields VALUES (8, 65, NULL, 3); 472 INSERT INTO itemTypeFields VALUES (8, 14, NULL, 4); 473 INSERT INTO itemTypeFields VALUES (8, 87, NULL, 5); 474 INSERT INTO itemTypeFields VALUES (8, 116, NULL, 6); 475 INSERT INTO itemTypeFields VALUES (8, 1, NULL, 7); 476 INSERT INTO itemTypeFields VALUES (8, 27, NULL, 8); 477 INSERT INTO itemTypeFields VALUES (8, 123, NULL, 9); 478 INSERT INTO itemTypeFields VALUES (8, 19, NULL, 10); 479 INSERT INTO itemTypeFields VALUES (8, 62, NULL, 11); 480 INSERT INTO itemTypeFields VALUES (8, 18, NULL, 12); 481 INSERT INTO itemTypeFields VALUES (8, 2, NULL, 13); 482 INSERT INTO itemTypeFields VALUES (8, 22, NULL, 14); 483 INSERT INTO itemTypeFields VALUES (9, 110, NULL, 1); 484 INSERT INTO itemTypeFields VALUES (9, 90, NULL, 2); 485 INSERT INTO itemTypeFields VALUES (9, 66, NULL, 3); 486 INSERT INTO itemTypeFields VALUES (9, 7, NULL, 4); 487 INSERT INTO itemTypeFields VALUES (9, 14, NULL, 5); 488 INSERT INTO itemTypeFields VALUES (9, 118, NULL, 6); 489 INSERT INTO itemTypeFields VALUES (9, 87, NULL, 7); 490 INSERT INTO itemTypeFields VALUES (9, 116, NULL, 8); 491 INSERT INTO itemTypeFields VALUES (9, 1, NULL, 9); 492 INSERT INTO itemTypeFields VALUES (9, 27, NULL, 10); 493 INSERT INTO itemTypeFields VALUES (9, 123, NULL, 11); 494 INSERT INTO itemTypeFields VALUES (9, 19, NULL, 12); 495 INSERT INTO itemTypeFields VALUES (9, 62, NULL, 13); 496 INSERT INTO itemTypeFields VALUES (9, 18, NULL, 14); 497 INSERT INTO itemTypeFields VALUES (9, 2, NULL, 15); 498 INSERT INTO itemTypeFields VALUES (9, 22, NULL, 16); 499 INSERT INTO itemTypeFields VALUES (10, 110, NULL, 1); 500 INSERT INTO itemTypeFields VALUES (10, 90, NULL, 2); 501 INSERT INTO itemTypeFields VALUES (10, 14, NULL, 3); 502 INSERT INTO itemTypeFields VALUES (10, 64, NULL, 4); 503 INSERT INTO itemTypeFields VALUES (10, 87, NULL, 5); 504 INSERT INTO itemTypeFields VALUES (10, 116, NULL, 6); 505 INSERT INTO itemTypeFields VALUES (10, 1, NULL, 7); 506 INSERT INTO itemTypeFields VALUES (10, 27, NULL, 8); 507 INSERT INTO itemTypeFields VALUES (10, 123, NULL, 9); 508 INSERT INTO itemTypeFields VALUES (10, 19, NULL, 10); 509 INSERT INTO itemTypeFields VALUES (10, 62, NULL, 11); 510 INSERT INTO itemTypeFields VALUES (10, 18, NULL, 12); 511 INSERT INTO itemTypeFields VALUES (10, 2, NULL, 13); 512 INSERT INTO itemTypeFields VALUES (10, 22, NULL, 14); 513 INSERT INTO itemTypeFields VALUES (11, 110, NULL, 1); 514 INSERT INTO itemTypeFields VALUES (11, 90, NULL, 2); 515 INSERT INTO itemTypeFields VALUES (11, 21, NULL, 3); 516 INSERT INTO itemTypeFields VALUES (11, 14, NULL, 4); 517 INSERT INTO itemTypeFields VALUES (11, 122, NULL, 5); 518 INSERT INTO itemTypeFields VALUES (11, 63, NULL, 6); 519 INSERT INTO itemTypeFields VALUES (11, 77, NULL, 7); 520 INSERT INTO itemTypeFields VALUES (11, 87, NULL, 8); 521 INSERT INTO itemTypeFields VALUES (11, 116, NULL, 9); 522 INSERT INTO itemTypeFields VALUES (11, 1, NULL, 10); 523 INSERT INTO itemTypeFields VALUES (11, 27, NULL, 11); 524 INSERT INTO itemTypeFields VALUES (11, 123, NULL, 12); 525 INSERT INTO itemTypeFields VALUES (11, 19, NULL, 13); 526 INSERT INTO itemTypeFields VALUES (11, 62, NULL, 14); 527 INSERT INTO itemTypeFields VALUES (11, 18, NULL, 15); 528 INSERT INTO itemTypeFields VALUES (11, 2, NULL, 16); 529 INSERT INTO itemTypeFields VALUES (11, 22, NULL, 17); 530 INSERT INTO itemTypeFields VALUES (12, 110, NULL, 1); 531 INSERT INTO itemTypeFields VALUES (12, 90, NULL, 2); 532 INSERT INTO itemTypeFields VALUES (12, 59, NULL, 3); 533 INSERT INTO itemTypeFields VALUES (12, 61, NULL, 4); 534 INSERT INTO itemTypeFields VALUES (12, 14, NULL, 5); 535 INSERT INTO itemTypeFields VALUES (12, 87, NULL, 6); 536 INSERT INTO itemTypeFields VALUES (12, 116, NULL, 7); 537 INSERT INTO itemTypeFields VALUES (12, 123, NULL, 8); 538 INSERT INTO itemTypeFields VALUES (12, 19, NULL, 9); 539 INSERT INTO itemTypeFields VALUES (12, 62, NULL, 10); 540 INSERT INTO itemTypeFields VALUES (12, 18, NULL, 11); 541 INSERT INTO itemTypeFields VALUES (12, 1, NULL, 12); 542 INSERT INTO itemTypeFields VALUES (12, 27, NULL, 13); 543 INSERT INTO itemTypeFields VALUES (12, 2, NULL, 14); 544 INSERT INTO itemTypeFields VALUES (12, 22, NULL, 15); 545 INSERT INTO itemTypeFields VALUES (13, 110, NULL, 1); 546 INSERT INTO itemTypeFields VALUES (13, 90, NULL, 2); 547 INSERT INTO itemTypeFields VALUES (13, 91, NULL, 3); 548 INSERT INTO itemTypeFields VALUES (13, 70, NULL, 4); 549 INSERT INTO itemTypeFields VALUES (13, 14, NULL, 5); 550 INSERT INTO itemTypeFields VALUES (13, 116, NULL, 6); 551 INSERT INTO itemTypeFields VALUES (13, 1, NULL, 7); 552 INSERT INTO itemTypeFields VALUES (13, 27, NULL, 8); 553 INSERT INTO itemTypeFields VALUES (13, 87, NULL, 9); 554 INSERT INTO itemTypeFields VALUES (13, 2, NULL, 10); 555 INSERT INTO itemTypeFields VALUES (13, 22, NULL, 11); 556 INSERT INTO itemTypeFields VALUES (14, 110, NULL, 1); 557 INSERT INTO itemTypeFields VALUES (14, 27, NULL, 2); 558 INSERT INTO itemTypeFields VALUES (14, 1, NULL, 3); 559 INSERT INTO itemTypeFields VALUES (15, 110, NULL, 1); 560 INSERT INTO itemTypeFields VALUES (15, 90, NULL, 2); 561 INSERT INTO itemTypeFields VALUES (15, 92, NULL, 3); 562 INSERT INTO itemTypeFields VALUES (15, 32, NULL, 4); 563 INSERT INTO itemTypeFields VALUES (15, 28, NULL, 5); 564 INSERT INTO itemTypeFields VALUES (15, 7, NULL, 6); 565 INSERT INTO itemTypeFields VALUES (15, 31, NULL, 7); 566 INSERT INTO itemTypeFields VALUES (15, 14, NULL, 8); 567 INSERT INTO itemTypeFields VALUES (15, 10, NULL, 9); 568 INSERT INTO itemTypeFields VALUES (15, 87, NULL, 10); 569 INSERT INTO itemTypeFields VALUES (15, 116, NULL, 11); 570 INSERT INTO itemTypeFields VALUES (15, 1, NULL, 12); 571 INSERT INTO itemTypeFields VALUES (15, 27, NULL, 13); 572 INSERT INTO itemTypeFields VALUES (15, 123, NULL, 14); 573 INSERT INTO itemTypeFields VALUES (15, 19, NULL, 15); 574 INSERT INTO itemTypeFields VALUES (15, 62, NULL, 16); 575 INSERT INTO itemTypeFields VALUES (15, 18, NULL, 17); 576 INSERT INTO itemTypeFields VALUES (15, 2, NULL, 18); 577 INSERT INTO itemTypeFields VALUES (15, 22, NULL, 19); 578 INSERT INTO itemTypeFields VALUES (16, 110, NULL, 1); 579 INSERT INTO itemTypeFields VALUES (16, 90, NULL, 2); 580 INSERT INTO itemTypeFields VALUES (16, 93, NULL, 3); 581 INSERT INTO itemTypeFields VALUES (16, 36, NULL, 4); 582 INSERT INTO itemTypeFields VALUES (16, 94, NULL, 5); 583 INSERT INTO itemTypeFields VALUES (16, 15, NULL, 6); 584 INSERT INTO itemTypeFields VALUES (16, 95, NULL, 7); 585 INSERT INTO itemTypeFields VALUES (16, 41, NULL, 8); 586 INSERT INTO itemTypeFields VALUES (16, 40, NULL, 9); 587 INSERT INTO itemTypeFields VALUES (16, 42, NULL, 10); 588 INSERT INTO itemTypeFields VALUES (16, 14, NULL, 11); 589 INSERT INTO itemTypeFields VALUES (16, 87, NULL, 12); 590 INSERT INTO itemTypeFields VALUES (16, 1, NULL, 13); 591 INSERT INTO itemTypeFields VALUES (16, 27, NULL, 14); 592 INSERT INTO itemTypeFields VALUES (16, 116, NULL, 15); 593 INSERT INTO itemTypeFields VALUES (16, 2, NULL, 16); 594 INSERT INTO itemTypeFields VALUES (16, 22, NULL, 17); 595 INSERT INTO itemTypeFields VALUES (17, 111, NULL, 1); 596 INSERT INTO itemTypeFields VALUES (17, 90, NULL, 2); 597 INSERT INTO itemTypeFields VALUES (17, 44, NULL, 3); 598 INSERT INTO itemTypeFields VALUES (17, 96, NULL, 4); 599 INSERT INTO itemTypeFields VALUES (17, 117, NULL, 5); 600 INSERT INTO itemTypeFields VALUES (17, 43, NULL, 6); 601 INSERT INTO itemTypeFields VALUES (17, 97, NULL, 7); 602 INSERT INTO itemTypeFields VALUES (17, 98, NULL, 8); 603 INSERT INTO itemTypeFields VALUES (17, 42, NULL, 9); 604 INSERT INTO itemTypeFields VALUES (17, 87, NULL, 10); 605 INSERT INTO itemTypeFields VALUES (17, 116, NULL, 11); 606 INSERT INTO itemTypeFields VALUES (17, 1, NULL, 12); 607 INSERT INTO itemTypeFields VALUES (17, 27, NULL, 13); 608 INSERT INTO itemTypeFields VALUES (17, 2, NULL, 14); 609 INSERT INTO itemTypeFields VALUES (17, 22, NULL, 15); 610 INSERT INTO itemTypeFields VALUES (18, 110, NULL, 1); 611 INSERT INTO itemTypeFields VALUES (18, 90, NULL, 2); 612 INSERT INTO itemTypeFields VALUES (18, 46, NULL, 3); 613 INSERT INTO itemTypeFields VALUES (18, 7, NULL, 4); 614 INSERT INTO itemTypeFields VALUES (18, 8, NULL, 5); 615 INSERT INTO itemTypeFields VALUES (18, 45, NULL, 6); 616 INSERT INTO itemTypeFields VALUES (18, 99, NULL, 7); 617 INSERT INTO itemTypeFields VALUES (18, 10, NULL, 8); 618 INSERT INTO itemTypeFields VALUES (18, 41, NULL, 9); 619 INSERT INTO itemTypeFields VALUES (18, 40, NULL, 10); 620 INSERT INTO itemTypeFields VALUES (18, 42, NULL, 11); 621 INSERT INTO itemTypeFields VALUES (18, 14, NULL, 12); 622 INSERT INTO itemTypeFields VALUES (18, 87, NULL, 13); 623 INSERT INTO itemTypeFields VALUES (18, 116, NULL, 14); 624 INSERT INTO itemTypeFields VALUES (18, 1, NULL, 15); 625 INSERT INTO itemTypeFields VALUES (18, 27, NULL, 16); 626 INSERT INTO itemTypeFields VALUES (18, 2, NULL, 17); 627 INSERT INTO itemTypeFields VALUES (18, 22, NULL, 18); 628 INSERT INTO itemTypeFields VALUES (19, 110, NULL, 1); 629 INSERT INTO itemTypeFields VALUES (19, 90, NULL, 2); 630 INSERT INTO itemTypeFields VALUES (19, 7, NULL, 3); 631 INSERT INTO itemTypeFields VALUES (19, 102, NULL, 4); 632 INSERT INTO itemTypeFields VALUES (19, 48, NULL, 5); 633 INSERT INTO itemTypeFields VALUES (19, 120, NULL, 6); 634 INSERT INTO itemTypeFields VALUES (19, 50, NULL, 7); 635 INSERT INTO itemTypeFields VALUES (19, 121, NULL, 8); 636 INSERT INTO itemTypeFields VALUES (19, 10, NULL, 9); 637 INSERT INTO itemTypeFields VALUES (19, 103, NULL, 10); 638 INSERT INTO itemTypeFields VALUES (19, 51, NULL, 11); 639 INSERT INTO itemTypeFields VALUES (19, 52, NULL, 12); 640 INSERT INTO itemTypeFields VALUES (19, 53, NULL, 13); 641 INSERT INTO itemTypeFields VALUES (19, 54, NULL, 14); 642 INSERT INTO itemTypeFields VALUES (19, 87, NULL, 15); 643 INSERT INTO itemTypeFields VALUES (19, 116, NULL, 16); 644 INSERT INTO itemTypeFields VALUES (19, 1, NULL, 17); 645 INSERT INTO itemTypeFields VALUES (19, 27, NULL, 18); 646 INSERT INTO itemTypeFields VALUES (19, 2, NULL, 19); 647 INSERT INTO itemTypeFields VALUES (19, 22, NULL, 20); 648 INSERT INTO itemTypeFields VALUES (20, 112, NULL, 1); 649 INSERT INTO itemTypeFields VALUES (20, 90, NULL, 2); 650 INSERT INTO itemTypeFields VALUES (20, 36, NULL, 3); 651 INSERT INTO itemTypeFields VALUES (20, 55, NULL, 4); 652 INSERT INTO itemTypeFields VALUES (20, 101, NULL, 5); 653 INSERT INTO itemTypeFields VALUES (20, 100, NULL, 6); 654 INSERT INTO itemTypeFields VALUES (20, 10, NULL, 7); 655 INSERT INTO itemTypeFields VALUES (20, 15, NULL, 8); 656 INSERT INTO itemTypeFields VALUES (20, 40, NULL, 9); 657 INSERT INTO itemTypeFields VALUES (20, 42, NULL, 10); 658 INSERT INTO itemTypeFields VALUES (20, 87, NULL, 11); 659 INSERT INTO itemTypeFields VALUES (20, 116, NULL, 12); 660 INSERT INTO itemTypeFields VALUES (20, 1, NULL, 13); 661 INSERT INTO itemTypeFields VALUES (20, 27, NULL, 14); 662 INSERT INTO itemTypeFields VALUES (20, 2, NULL, 15); 663 INSERT INTO itemTypeFields VALUES (20, 22, NULL, 16); 664 INSERT INTO itemTypeFields VALUES (21, 113, NULL, 1); 665 INSERT INTO itemTypeFields VALUES (21, 90, NULL, 2); 666 INSERT INTO itemTypeFields VALUES (21, 14, NULL, 3); 667 INSERT INTO itemTypeFields VALUES (21, 116, NULL, 4); 668 INSERT INTO itemTypeFields VALUES (21, 1, NULL, 5); 669 INSERT INTO itemTypeFields VALUES (21, 27, NULL, 6); 670 INSERT INTO itemTypeFields VALUES (21, 87, NULL, 7); 671 INSERT INTO itemTypeFields VALUES (21, 2, NULL, 8); 672 INSERT INTO itemTypeFields VALUES (21, 22, NULL, 9); 673 INSERT INTO itemTypeFields VALUES (22, 110, NULL, 1); 674 INSERT INTO itemTypeFields VALUES (22, 90, NULL, 2); 675 INSERT INTO itemTypeFields VALUES (22, 67, NULL, 3); 676 INSERT INTO itemTypeFields VALUES (22, 68, NULL, 4); 677 INSERT INTO itemTypeFields VALUES (22, 28, NULL, 5); 678 INSERT INTO itemTypeFields VALUES (22, 6, NULL, 6); 679 INSERT INTO itemTypeFields VALUES (22, 7, NULL, 7); 680 INSERT INTO itemTypeFields VALUES (22, 8, NULL, 8); 681 INSERT INTO itemTypeFields VALUES (22, 14, NULL, 9); 682 INSERT INTO itemTypeFields VALUES (22, 87, NULL, 10); 683 INSERT INTO itemTypeFields VALUES (22, 11, NULL, 11); 684 INSERT INTO itemTypeFields VALUES (22, 116, NULL, 12); 685 INSERT INTO itemTypeFields VALUES (22, 1, NULL, 13); 686 INSERT INTO itemTypeFields VALUES (22, 27, NULL, 14); 687 INSERT INTO itemTypeFields VALUES (22, 123, NULL, 15); 688 INSERT INTO itemTypeFields VALUES (22, 19, NULL, 16); 689 INSERT INTO itemTypeFields VALUES (22, 62, NULL, 17); 690 INSERT INTO itemTypeFields VALUES (22, 18, NULL, 18); 691 INSERT INTO itemTypeFields VALUES (22, 2, NULL, 19); 692 INSERT INTO itemTypeFields VALUES (22, 22, NULL, 20); 693 INSERT INTO itemTypeFields VALUES (23, 110, NULL, 1); 694 INSERT INTO itemTypeFields VALUES (23, 90, NULL, 2); 695 INSERT INTO itemTypeFields VALUES (23, 107, NULL, 3); 696 INSERT INTO itemTypeFields VALUES (23, 70, NULL, 4); 697 INSERT INTO itemTypeFields VALUES (23, 14, NULL, 5); 698 INSERT INTO itemTypeFields VALUES (23, 1, NULL, 6); 699 INSERT INTO itemTypeFields VALUES (23, 27, NULL, 7); 700 INSERT INTO itemTypeFields VALUES (23, 87, NULL, 8); 701 INSERT INTO itemTypeFields VALUES (23, 116, NULL, 9); 702 INSERT INTO itemTypeFields VALUES (23, 2, NULL, 10); 703 INSERT INTO itemTypeFields VALUES (23, 22, NULL, 11); 704 INSERT INTO itemTypeFields VALUES (24, 110, NULL, 1); 705 INSERT INTO itemTypeFields VALUES (24, 90, NULL, 2); 706 INSERT INTO itemTypeFields VALUES (24, 14, NULL, 3); 707 INSERT INTO itemTypeFields VALUES (24, 87, NULL, 4); 708 INSERT INTO itemTypeFields VALUES (24, 116, NULL, 5); 709 INSERT INTO itemTypeFields VALUES (24, 1, NULL, 6); 710 INSERT INTO itemTypeFields VALUES (24, 27, NULL, 7); 711 INSERT INTO itemTypeFields VALUES (24, 2, NULL, 8); 712 INSERT INTO itemTypeFields VALUES (24, 22, NULL, 9); 713 INSERT INTO itemTypeFields VALUES (25, 110, NULL, 1); 714 INSERT INTO itemTypeFields VALUES (25, 90, NULL, 2); 715 INSERT INTO itemTypeFields VALUES (25, 104, NULL, 3); 716 INSERT INTO itemTypeFields VALUES (25, 79, NULL, 4); 717 INSERT INTO itemTypeFields VALUES (25, 14, NULL, 5); 718 INSERT INTO itemTypeFields VALUES (25, 87, NULL, 6); 719 INSERT INTO itemTypeFields VALUES (25, 116, NULL, 7); 720 INSERT INTO itemTypeFields VALUES (25, 1, NULL, 8); 721 INSERT INTO itemTypeFields VALUES (25, 27, NULL, 9); 722 INSERT INTO itemTypeFields VALUES (25, 2, NULL, 10); 723 INSERT INTO itemTypeFields VALUES (25, 22, NULL, 11); 724 INSERT INTO itemTypeFields VALUES (26, 110, NULL, 1); 725 INSERT INTO itemTypeFields VALUES (26, 90, NULL, 2); 726 INSERT INTO itemTypeFields VALUES (26, 71, NULL, 3); 727 INSERT INTO itemTypeFields VALUES (26, 28, NULL, 4); 728 INSERT INTO itemTypeFields VALUES (26, 4, NULL, 5); 729 INSERT INTO itemTypeFields VALUES (26, 45, NULL, 6); 730 INSERT INTO itemTypeFields VALUES (26, 7, NULL, 7); 731 INSERT INTO itemTypeFields VALUES (26, 72, NULL, 8); 732 INSERT INTO itemTypeFields VALUES (26, 14, NULL, 9); 733 INSERT INTO itemTypeFields VALUES (26, 77, NULL, 10); 734 INSERT INTO itemTypeFields VALUES (26, 87, NULL, 11); 735 INSERT INTO itemTypeFields VALUES (26, 11, NULL, 12); 736 INSERT INTO itemTypeFields VALUES (26, 116, NULL, 13); 737 INSERT INTO itemTypeFields VALUES (26, 123, NULL, 14); 738 INSERT INTO itemTypeFields VALUES (26, 19, NULL, 15); 739 INSERT INTO itemTypeFields VALUES (26, 62, NULL, 16); 740 INSERT INTO itemTypeFields VALUES (26, 18, NULL, 17); 741 INSERT INTO itemTypeFields VALUES (26, 1, NULL, 18); 742 INSERT INTO itemTypeFields VALUES (26, 27, NULL, 19); 743 INSERT INTO itemTypeFields VALUES (26, 2, NULL, 20); 744 INSERT INTO itemTypeFields VALUES (26, 22, NULL, 21); 745 INSERT INTO itemTypeFields VALUES (27, 110, NULL, 1); 746 INSERT INTO itemTypeFields VALUES (27, 90, NULL, 2); 747 INSERT INTO itemTypeFields VALUES (27, 74, NULL, 3); 748 INSERT INTO itemTypeFields VALUES (27, 14, NULL, 4); 749 INSERT INTO itemTypeFields VALUES (27, 7, NULL, 5); 750 INSERT INTO itemTypeFields VALUES (27, 75, NULL, 6); 751 INSERT INTO itemTypeFields VALUES (27, 1, NULL, 7); 752 INSERT INTO itemTypeFields VALUES (27, 27, NULL, 8); 753 INSERT INTO itemTypeFields VALUES (27, 87, NULL, 9); 754 INSERT INTO itemTypeFields VALUES (27, 116, NULL, 10); 755 INSERT INTO itemTypeFields VALUES (27, 2, NULL, 11); 756 INSERT INTO itemTypeFields VALUES (27, 22, NULL, 12); 757 INSERT INTO itemTypeFields VALUES (28, 110, NULL, 1); 758 INSERT INTO itemTypeFields VALUES (28, 90, NULL, 2); 759 INSERT INTO itemTypeFields VALUES (28, 63, NULL, 3); 760 INSERT INTO itemTypeFields VALUES (28, 28, NULL, 4); 761 INSERT INTO itemTypeFields VALUES (28, 4, NULL, 5); 762 INSERT INTO itemTypeFields VALUES (28, 45, NULL, 6); 763 INSERT INTO itemTypeFields VALUES (28, 7, NULL, 7); 764 INSERT INTO itemTypeFields VALUES (28, 76, NULL, 8); 765 INSERT INTO itemTypeFields VALUES (28, 14, NULL, 9); 766 INSERT INTO itemTypeFields VALUES (28, 77, NULL, 10); 767 INSERT INTO itemTypeFields VALUES (28, 87, NULL, 11); 768 INSERT INTO itemTypeFields VALUES (28, 11, NULL, 12); 769 INSERT INTO itemTypeFields VALUES (28, 116, NULL, 13); 770 INSERT INTO itemTypeFields VALUES (28, 1, NULL, 14); 771 INSERT INTO itemTypeFields VALUES (28, 27, NULL, 15); 772 INSERT INTO itemTypeFields VALUES (28, 123, NULL, 16); 773 INSERT INTO itemTypeFields VALUES (28, 19, NULL, 17); 774 INSERT INTO itemTypeFields VALUES (28, 62, NULL, 18); 775 INSERT INTO itemTypeFields VALUES (28, 18, NULL, 19); 776 INSERT INTO itemTypeFields VALUES (28, 2, NULL, 20); 777 INSERT INTO itemTypeFields VALUES (28, 22, NULL, 21); 778 INSERT INTO itemTypeFields VALUES (29, 110, NULL, 1); 779 INSERT INTO itemTypeFields VALUES (29, 90, NULL, 2); 780 INSERT INTO itemTypeFields VALUES (29, 119, NULL, 3); 781 INSERT INTO itemTypeFields VALUES (29, 105, NULL, 4); 782 INSERT INTO itemTypeFields VALUES (29, 63, NULL, 5); 783 INSERT INTO itemTypeFields VALUES (29, 7, NULL, 6); 784 INSERT INTO itemTypeFields VALUES (29, 78, NULL, 7); 785 INSERT INTO itemTypeFields VALUES (29, 14, NULL, 8); 786 INSERT INTO itemTypeFields VALUES (29, 77, NULL, 9); 787 INSERT INTO itemTypeFields VALUES (29, 87, NULL, 10); 788 INSERT INTO itemTypeFields VALUES (29, 116, NULL, 11); 789 INSERT INTO itemTypeFields VALUES (29, 1, NULL, 12); 790 INSERT INTO itemTypeFields VALUES (29, 27, NULL, 13); 791 INSERT INTO itemTypeFields VALUES (29, 123, NULL, 14); 792 INSERT INTO itemTypeFields VALUES (29, 19, NULL, 15); 793 INSERT INTO itemTypeFields VALUES (29, 62, NULL, 16); 794 INSERT INTO itemTypeFields VALUES (29, 18, NULL, 17); 795 INSERT INTO itemTypeFields VALUES (29, 2, NULL, 18); 796 INSERT INTO itemTypeFields VALUES (29, 22, NULL, 19); 797 INSERT INTO itemTypeFields VALUES (30, 110, NULL, 1); 798 INSERT INTO itemTypeFields VALUES (30, 90, NULL, 2); 799 INSERT INTO itemTypeFields VALUES (30, 119, NULL, 3); 800 INSERT INTO itemTypeFields VALUES (30, 105, NULL, 4); 801 INSERT INTO itemTypeFields VALUES (30, 71, NULL, 5); 802 INSERT INTO itemTypeFields VALUES (30, 7, NULL, 6); 803 INSERT INTO itemTypeFields VALUES (30, 78, NULL, 7); 804 INSERT INTO itemTypeFields VALUES (30, 14, NULL, 8); 805 INSERT INTO itemTypeFields VALUES (30, 77, NULL, 9); 806 INSERT INTO itemTypeFields VALUES (30, 87, NULL, 10); 807 INSERT INTO itemTypeFields VALUES (30, 116, NULL, 11); 808 INSERT INTO itemTypeFields VALUES (30, 1, NULL, 12); 809 INSERT INTO itemTypeFields VALUES (30, 27, NULL, 13); 810 INSERT INTO itemTypeFields VALUES (30, 123, NULL, 14); 811 INSERT INTO itemTypeFields VALUES (30, 19, NULL, 15); 812 INSERT INTO itemTypeFields VALUES (30, 62, NULL, 16); 813 INSERT INTO itemTypeFields VALUES (30, 18, NULL, 17); 814 INSERT INTO itemTypeFields VALUES (30, 2, NULL, 18); 815 INSERT INTO itemTypeFields VALUES (30, 22, NULL, 19); 816 INSERT INTO itemTypeFields VALUES (31, 110, NULL, 1); 817 INSERT INTO itemTypeFields VALUES (31, 90, NULL, 2); 818 INSERT INTO itemTypeFields VALUES (31, 28, NULL, 3); 819 INSERT INTO itemTypeFields VALUES (31, 105, NULL, 4); 820 INSERT INTO itemTypeFields VALUES (31, 80, NULL, 5); 821 INSERT INTO itemTypeFields VALUES (31, 77, NULL, 6); 822 INSERT INTO itemTypeFields VALUES (31, 1, NULL, 7); 823 INSERT INTO itemTypeFields VALUES (31, 27, NULL, 8); 824 INSERT INTO itemTypeFields VALUES (31, 87, NULL, 9); 825 INSERT INTO itemTypeFields VALUES (31, 116, NULL, 10); 826 INSERT INTO itemTypeFields VALUES (31, 2, NULL, 11); 827 INSERT INTO itemTypeFields VALUES (31, 22, NULL, 12); 828 INSERT INTO itemTypeFields VALUES (32, 110, NULL, 1); 829 INSERT INTO itemTypeFields VALUES (32, 90, NULL, 2); 830 INSERT INTO itemTypeFields VALUES (32, 28, NULL, 3); 831 INSERT INTO itemTypeFields VALUES (32, 81, NULL, 4); 832 INSERT INTO itemTypeFields VALUES (32, 14, NULL, 5); 833 INSERT INTO itemTypeFields VALUES (32, 82, NULL, 6); 834 INSERT INTO itemTypeFields VALUES (32, 7, NULL, 7); 835 INSERT INTO itemTypeFields VALUES (32, 83, NULL, 8); 836 INSERT INTO itemTypeFields VALUES (32, 88, NULL, 9); 837 INSERT INTO itemTypeFields VALUES (32, 11, NULL, 10); 838 INSERT INTO itemTypeFields VALUES (32, 116, NULL, 11); 839 INSERT INTO itemTypeFields VALUES (32, 1, NULL, 12); 840 INSERT INTO itemTypeFields VALUES (32, 2, NULL, 13); 841 INSERT INTO itemTypeFields VALUES (32, 123, NULL, 14); 842 INSERT INTO itemTypeFields VALUES (32, 19, NULL, 15); 843 INSERT INTO itemTypeFields VALUES (32, 62, NULL, 16); 844 INSERT INTO itemTypeFields VALUES (32, 18, NULL, 17); 845 INSERT INTO itemTypeFields VALUES (32, 27, NULL, 18); 846 INSERT INTO itemTypeFields VALUES (32, 22, NULL, 19); 847 INSERT INTO itemTypeFields VALUES (33, 110, NULL, 1); 848 INSERT INTO itemTypeFields VALUES (33, 90, NULL, 2); 849 INSERT INTO itemTypeFields VALUES (33, 14, NULL, 3); 850 INSERT INTO itemTypeFields VALUES (33, 114, NULL, 4); 851 INSERT INTO itemTypeFields VALUES (33, 84, NULL, 5); 852 INSERT INTO itemTypeFields VALUES (33, 7, NULL, 6); 853 INSERT INTO itemTypeFields VALUES (33, 8, NULL, 7); 854 INSERT INTO itemTypeFields VALUES (33, 4, NULL, 8); 855 INSERT INTO itemTypeFields VALUES (33, 10, NULL, 9); 856 INSERT INTO itemTypeFields VALUES (33, 3, NULL, 10); 857 INSERT INTO itemTypeFields VALUES (33, 87, NULL, 11); 858 INSERT INTO itemTypeFields VALUES (33, 26, NULL, 12); 859 INSERT INTO itemTypeFields VALUES (33, 11, NULL, 13); 860 INSERT INTO itemTypeFields VALUES (33, 116, NULL, 14); 861 INSERT INTO itemTypeFields VALUES (33, 1, NULL, 15); 862 INSERT INTO itemTypeFields VALUES (33, 27, NULL, 16); 863 INSERT INTO itemTypeFields VALUES (33, 123, NULL, 17); 864 INSERT INTO itemTypeFields VALUES (33, 19, NULL, 18); 865 INSERT INTO itemTypeFields VALUES (33, 62, NULL, 19); 866 INSERT INTO itemTypeFields VALUES (33, 18, NULL, 20); 867 INSERT INTO itemTypeFields VALUES (33, 2, NULL, 21); 868 INSERT INTO itemTypeFields VALUES (33, 22, NULL, 22); 869 INSERT INTO itemTypeFields VALUES (34, 110, NULL, 1); 870 INSERT INTO itemTypeFields VALUES (34, 90, NULL, 2); 871 INSERT INTO itemTypeFields VALUES (34, 8, NULL, 3); 872 INSERT INTO itemTypeFields VALUES (34, 14, NULL, 4); 873 INSERT INTO itemTypeFields VALUES (34, 87, NULL, 5); 874 INSERT INTO itemTypeFields VALUES (34, 116, NULL, 6); 875 INSERT INTO itemTypeFields VALUES (34, 1, NULL, 7); 876 INSERT INTO itemTypeFields VALUES (34, 27, NULL, 8); 877 INSERT INTO itemTypeFields VALUES (34, 123, NULL, 9); 878 INSERT INTO itemTypeFields VALUES (34, 19, NULL, 10); 879 INSERT INTO itemTypeFields VALUES (34, 62, NULL, 11); 880 INSERT INTO itemTypeFields VALUES (34, 18, NULL, 12); 881 INSERT INTO itemTypeFields VALUES (34, 2, NULL, 13); 882 INSERT INTO itemTypeFields VALUES (34, 22, NULL, 14); 883 INSERT INTO itemTypeFields VALUES (35, 110, NULL, 1); 884 INSERT INTO itemTypeFields VALUES (35, 90, NULL, 2); 885 INSERT INTO itemTypeFields VALUES (35, 85, NULL, 3); 886 INSERT INTO itemTypeFields VALUES (35, 3, NULL, 4); 887 INSERT INTO itemTypeFields VALUES (35, 30, NULL, 5); 888 INSERT INTO itemTypeFields VALUES (35, 4, NULL, 6); 889 INSERT INTO itemTypeFields VALUES (35, 45, NULL, 7); 890 INSERT INTO itemTypeFields VALUES (35, 6, NULL, 8); 891 INSERT INTO itemTypeFields VALUES (35, 7, NULL, 9); 892 INSERT INTO itemTypeFields VALUES (35, 8, NULL, 10); 893 INSERT INTO itemTypeFields VALUES (35, 14, NULL, 11); 894 INSERT INTO itemTypeFields VALUES (35, 10, NULL, 12); 895 INSERT INTO itemTypeFields VALUES (35, 11, NULL, 13); 896 INSERT INTO itemTypeFields VALUES (35, 116, NULL, 14); 897 INSERT INTO itemTypeFields VALUES (35, 1, NULL, 15); 898 INSERT INTO itemTypeFields VALUES (35, 27, NULL, 16); 899 INSERT INTO itemTypeFields VALUES (35, 87, NULL, 17); 900 INSERT INTO itemTypeFields VALUES (35, 123, NULL, 18); 901 INSERT INTO itemTypeFields VALUES (35, 19, NULL, 19); 902 INSERT INTO itemTypeFields VALUES (35, 62, NULL, 20); 903 INSERT INTO itemTypeFields VALUES (35, 18, NULL, 21); 904 INSERT INTO itemTypeFields VALUES (35, 2, NULL, 22); 905 INSERT INTO itemTypeFields VALUES (35, 22, NULL, 23); 906 INSERT INTO itemTypeFields VALUES (36, 110, NULL, 1); 907 INSERT INTO itemTypeFields VALUES (36, 90, NULL, 2); 908 INSERT INTO itemTypeFields VALUES (36, 86, NULL, 3); 909 INSERT INTO itemTypeFields VALUES (36, 3, NULL, 4); 910 INSERT INTO itemTypeFields VALUES (36, 30, NULL, 5); 911 INSERT INTO itemTypeFields VALUES (36, 4, NULL, 6); 912 INSERT INTO itemTypeFields VALUES (36, 45, NULL, 7); 913 INSERT INTO itemTypeFields VALUES (36, 6, NULL, 8); 914 INSERT INTO itemTypeFields VALUES (36, 7, NULL, 9); 915 INSERT INTO itemTypeFields VALUES (36, 8, NULL, 10); 916 INSERT INTO itemTypeFields VALUES (36, 14, NULL, 11); 917 INSERT INTO itemTypeFields VALUES (36, 10, NULL, 12); 918 INSERT INTO itemTypeFields VALUES (36, 87, NULL, 13); 919 INSERT INTO itemTypeFields VALUES (36, 11, NULL, 14); 920 INSERT INTO itemTypeFields VALUES (36, 116, NULL, 15); 921 INSERT INTO itemTypeFields VALUES (36, 1, NULL, 16); 922 INSERT INTO itemTypeFields VALUES (36, 27, NULL, 17); 923 INSERT INTO itemTypeFields VALUES (36, 123, NULL, 18); 924 INSERT INTO itemTypeFields VALUES (36, 19, NULL, 19); 925 INSERT INTO itemTypeFields VALUES (36, 62, NULL, 20); 926 INSERT INTO itemTypeFields VALUES (36, 18, NULL, 21); 927 INSERT INTO itemTypeFields VALUES (36, 2, NULL, 22); 928 INSERT INTO itemTypeFields VALUES (36, 22, NULL, 23); 929 930 931 INSERT INTO baseFieldMappings VALUES (16, 4, 94); -- bill/volume/codeVolume 932 INSERT INTO baseFieldMappings VALUES (17, 4, 97); -- case/volume/reporterVolume 933 INSERT INTO baseFieldMappings VALUES (7, 8, 89); -- thesis/publisher/university 934 INSERT INTO baseFieldMappings VALUES (11, 8, 21); -- film/publisher/distributor 935 INSERT INTO baseFieldMappings VALUES (15, 8, 31); -- report/publisher/institution 936 INSERT INTO baseFieldMappings VALUES (26, 8, 72); -- audioRecording/publisher/label 937 INSERT INTO baseFieldMappings VALUES (28, 8, 76); -- videoRecording/publisher/studio 938 INSERT INTO baseFieldMappings VALUES (29, 8, 78); -- tvBroadcast/publisher/network 939 INSERT INTO baseFieldMappings VALUES (30, 8, 78); -- radioBroadcast/publisher/network 940 INSERT INTO baseFieldMappings VALUES (32, 8, 83); -- computerProgram/publisher/company 941 INSERT INTO baseFieldMappings VALUES (16, 10, 95); -- bill/pages/codePages 942 INSERT INTO baseFieldMappings VALUES (17, 10, 98); -- case/pages/firstPage 943 INSERT INTO baseFieldMappings VALUES (3, 12, 115); -- bookSection/publicationTitle/bookTitle 944 INSERT INTO baseFieldMappings VALUES (33, 12, 114); -- conferencePaper/publicationTitle/proceedingsTitle 945 INSERT INTO baseFieldMappings VALUES (13, 12, 91); -- webpage/publicationTitle/websiteTitle 946 INSERT INTO baseFieldMappings VALUES (23, 12, 107); -- blogPost/publicationTitle/blogTitle 947 INSERT INTO baseFieldMappings VALUES (25, 12, 104); -- forumPost/publicationTitle/forumTitle 948 INSERT INTO baseFieldMappings VALUES (29, 12, 119); -- tvBroadcast/publicationTitle/programTitle 949 INSERT INTO baseFieldMappings VALUES (30, 12, 119); -- radioBroadcast/publicationTitle/programTitle 950 INSERT INTO baseFieldMappings VALUES (35, 12, 85); -- encyclopediaEntry/publicationTitle/encyclopediaTitle 951 INSERT INTO baseFieldMappings VALUES (36, 12, 86); -- dictionaryEntry/publicationTitle/dictionaryTitle 952 INSERT INTO baseFieldMappings VALUES (17, 14, 96); -- case/date/dateDecided 953 INSERT INTO baseFieldMappings VALUES (19, 14, 52); -- patent/date/issueDate 954 INSERT INTO baseFieldMappings VALUES (20, 14, 100); -- statute/date/dateEnacted 955 INSERT INTO baseFieldMappings VALUES (15, 60, 92); -- report/number/reportNumber 956 INSERT INTO baseFieldMappings VALUES (16, 60, 93); -- bill/number/billNumber 957 INSERT INTO baseFieldMappings VALUES (17, 60, 117); -- case/number/docketNumber 958 INSERT INTO baseFieldMappings VALUES (18, 60, 99); -- hearing/number/documentNumber 959 INSERT INTO baseFieldMappings VALUES (19, 60, 50); -- patent/number/patentNumber 960 INSERT INTO baseFieldMappings VALUES (20, 60, 101); -- statute/number/publicLawNumber 961 INSERT INTO baseFieldMappings VALUES (29, 60, 105); -- tvBroadcast/number/episodeNumber 962 INSERT INTO baseFieldMappings VALUES (30, 60, 105); -- radioBroadcast/number/episodeNumber 963 INSERT INTO baseFieldMappings VALUES (31, 60, 105); -- podcast/number/episodeNumber 964 INSERT INTO baseFieldMappings VALUES (7, 108, 69); -- thesis/type/thesisType 965 INSERT INTO baseFieldMappings VALUES (8, 108, 65); -- letter/type/letterType 966 INSERT INTO baseFieldMappings VALUES (9, 108, 66); -- manuscript/type/manuscriptType 967 INSERT INTO baseFieldMappings VALUES (11, 108, 122); -- film/type/genre 968 INSERT INTO baseFieldMappings VALUES (13, 108, 70); -- webpage/type/websiteType 969 INSERT INTO baseFieldMappings VALUES (15, 108, 32); -- report/type/reportType 970 INSERT INTO baseFieldMappings VALUES (22, 108, 67); -- map/type/mapType 971 INSERT INTO baseFieldMappings VALUES (23, 108, 70); -- blogPost/type/websiteType 972 INSERT INTO baseFieldMappings VALUES (25, 108, 79); -- forumPost/type/postType 973 INSERT INTO baseFieldMappings VALUES (27, 108, 74); -- presentation/type/presentationType 974 INSERT INTO baseFieldMappings VALUES (10, 109, 64); -- interview/medium/interviewMedium 975 INSERT INTO baseFieldMappings VALUES (11, 109, 63); -- film/medium/videoRecordingFormat 976 INSERT INTO baseFieldMappings VALUES (12, 109, 59); -- artwork/medium/artworkMedium 977 INSERT INTO baseFieldMappings VALUES (26, 109, 71); -- audioRecording/medium/audioRecordingFormat 978 INSERT INTO baseFieldMappings VALUES (28, 109, 63); -- videoRecording/medium/videoRecordingFormat 979 INSERT INTO baseFieldMappings VALUES (29, 109, 63); -- tvBroadcast/medium/videoRecodingMedium 980 INSERT INTO baseFieldMappings VALUES (30, 109, 71); -- radioBroadcast/medium/audioRecordingFormat 981 INSERT INTO baseFieldMappings VALUES (31, 109, 80); -- podcast/medium/audioFileType 982 INSERT INTO baseFieldMappings VALUES (17, 110, 111); -- case/title/caseName 983 INSERT INTO baseFieldMappings VALUES (20, 110, 112); -- statute/title/nameOfAct 984 INSERT INTO baseFieldMappings VALUES (21, 110, 113); -- email/title/subject 985 986 INSERT INTO creatorTypes VALUES(1, "author"); 987 INSERT INTO creatorTypes VALUES(2, "contributor"); 988 INSERT INTO creatorTypes VALUES(3, "editor"); 989 INSERT INTO creatorTypes VALUES(4, "translator"); 990 INSERT INTO creatorTypes VALUES(5, "seriesEditor"); 991 INSERT INTO creatorTypes VALUES(6, "interviewee"); 992 INSERT INTO creatorTypes VALUES(7, "interviewer"); 993 INSERT INTO creatorTypes VALUES(8, "director"); 994 INSERT INTO creatorTypes VALUES(9, "scriptwriter"); 995 INSERT INTO creatorTypes VALUES(10, "producer"); 996 INSERT INTO creatorTypes VALUES(11, "castMember"); 997 INSERT INTO creatorTypes VALUES(12, "sponsor"); 998 INSERT INTO creatorTypes VALUES(13, "counsel"); 999 INSERT INTO creatorTypes VALUES(14, "inventor"); 1000 INSERT INTO creatorTypes VALUES(15, "attorneyAgent"); 1001 INSERT INTO creatorTypes VALUES(16, "recipient"); 1002 INSERT INTO creatorTypes VALUES(17, "performer"); 1003 INSERT INTO creatorTypes VALUES(18, "composer"); 1004 INSERT INTO creatorTypes VALUES(19, "wordsBy"); 1005 INSERT INTO creatorTypes VALUES(20, "cartographer"); 1006 INSERT INTO creatorTypes VALUES(21, "programmer"); 1007 INSERT INTO creatorTypes VALUES(22, "artist"); 1008 INSERT INTO creatorTypes VALUES(23, "commenter"); 1009 INSERT INTO creatorTypes VALUES(24, "presenter"); 1010 INSERT INTO creatorTypes VALUES(25, "guest"); 1011 INSERT INTO creatorTypes VALUES(26, "podcaster"); 1012 INSERT INTO creatorTypes VALUES(27, "reviewedAuthor"); 1013 INSERT INTO creatorTypes VALUES(28, "cosponsor"); 1014 INSERT INTO creatorTypes VALUES(29, "bookAuthor"); 1015 1016 INSERT INTO itemTypeCreatorTypes VALUES(2,1,1); 1017 INSERT INTO itemTypeCreatorTypes VALUES(2,2,0); 1018 INSERT INTO itemTypeCreatorTypes VALUES(2,3,0); 1019 INSERT INTO itemTypeCreatorTypes VALUES(2,4,0); 1020 INSERT INTO itemTypeCreatorTypes VALUES(2,5,0); 1021 INSERT INTO itemTypeCreatorTypes VALUES(3,1,1); 1022 INSERT INTO itemTypeCreatorTypes VALUES(3,2,0); 1023 INSERT INTO itemTypeCreatorTypes VALUES(3,3,0); 1024 INSERT INTO itemTypeCreatorTypes VALUES(3,29,0); 1025 INSERT INTO itemTypeCreatorTypes VALUES(3,4,0); 1026 INSERT INTO itemTypeCreatorTypes VALUES(3,5,0); 1027 INSERT INTO itemTypeCreatorTypes VALUES(4,1,1); 1028 INSERT INTO itemTypeCreatorTypes VALUES(4,2,0); 1029 INSERT INTO itemTypeCreatorTypes VALUES(4,3,0); 1030 INSERT INTO itemTypeCreatorTypes VALUES(4,4,0); 1031 INSERT INTO itemTypeCreatorTypes VALUES(4,27,0); 1032 INSERT INTO itemTypeCreatorTypes VALUES(5,1,1); 1033 INSERT INTO itemTypeCreatorTypes VALUES(5,2,0); 1034 INSERT INTO itemTypeCreatorTypes VALUES(5,4,0); 1035 INSERT INTO itemTypeCreatorTypes VALUES(5,27,0); 1036 INSERT INTO itemTypeCreatorTypes VALUES(6,1,1); 1037 INSERT INTO itemTypeCreatorTypes VALUES(6,2,0); 1038 INSERT INTO itemTypeCreatorTypes VALUES(6,4,0); 1039 INSERT INTO itemTypeCreatorTypes VALUES(6,27,0); 1040 INSERT INTO itemTypeCreatorTypes VALUES(7,1,1); 1041 INSERT INTO itemTypeCreatorTypes VALUES(7,2,0); 1042 INSERT INTO itemTypeCreatorTypes VALUES(8,1,1); 1043 INSERT INTO itemTypeCreatorTypes VALUES(8,2,0); 1044 INSERT INTO itemTypeCreatorTypes VALUES(8,16,0); 1045 INSERT INTO itemTypeCreatorTypes VALUES(9,1,1); 1046 INSERT INTO itemTypeCreatorTypes VALUES(9,2,0); 1047 INSERT INTO itemTypeCreatorTypes VALUES(9,4,0); 1048 INSERT INTO itemTypeCreatorTypes VALUES(10,6,1); 1049 INSERT INTO itemTypeCreatorTypes VALUES(10,2,0); 1050 INSERT INTO itemTypeCreatorTypes VALUES(10,7,0); 1051 INSERT INTO itemTypeCreatorTypes VALUES(10,4,0); 1052 INSERT INTO itemTypeCreatorTypes VALUES(11,8,1); 1053 INSERT INTO itemTypeCreatorTypes VALUES(11,2,0); 1054 INSERT INTO itemTypeCreatorTypes VALUES(11,9,0); 1055 INSERT INTO itemTypeCreatorTypes VALUES(11,10,0); 1056 INSERT INTO itemTypeCreatorTypes VALUES(12,22,1); 1057 INSERT INTO itemTypeCreatorTypes VALUES(12,2,0); 1058 INSERT INTO itemTypeCreatorTypes VALUES(13,1,1); 1059 INSERT INTO itemTypeCreatorTypes VALUES(13,2,0); 1060 INSERT INTO itemTypeCreatorTypes VALUES(13,4,0); 1061 INSERT INTO itemTypeCreatorTypes VALUES(15,1,1); 1062 INSERT INTO itemTypeCreatorTypes VALUES(15,2,0); 1063 INSERT INTO itemTypeCreatorTypes VALUES(15,4,0); 1064 INSERT INTO itemTypeCreatorTypes VALUES(15,5,0); 1065 INSERT INTO itemTypeCreatorTypes VALUES(16,12,1); 1066 INSERT INTO itemTypeCreatorTypes VALUES(16,28,0); 1067 INSERT INTO itemTypeCreatorTypes VALUES(16,2,0); 1068 INSERT INTO itemTypeCreatorTypes VALUES(17,1,1); 1069 INSERT INTO itemTypeCreatorTypes VALUES(17,13,0); 1070 INSERT INTO itemTypeCreatorTypes VALUES(17,2,0); 1071 INSERT INTO itemTypeCreatorTypes VALUES(18,2,1); 1072 INSERT INTO itemTypeCreatorTypes VALUES(19,14,1); 1073 INSERT INTO itemTypeCreatorTypes VALUES(19,15,0); 1074 INSERT INTO itemTypeCreatorTypes VALUES(19,2,0); 1075 INSERT INTO itemTypeCreatorTypes VALUES(20,1,1); 1076 INSERT INTO itemTypeCreatorTypes VALUES(20,2,0); 1077 INSERT INTO itemTypeCreatorTypes VALUES(21,1,1); 1078 INSERT INTO itemTypeCreatorTypes VALUES(21,2,0); 1079 INSERT INTO itemTypeCreatorTypes VALUES(21,16,0); 1080 INSERT INTO itemTypeCreatorTypes VALUES(22,20,1); 1081 INSERT INTO itemTypeCreatorTypes VALUES(22,2,0); 1082 INSERT INTO itemTypeCreatorTypes VALUES(22,5,0); 1083 INSERT INTO itemTypeCreatorTypes VALUES(23,1,1); 1084 INSERT INTO itemTypeCreatorTypes VALUES(23,23,0); 1085 INSERT INTO itemTypeCreatorTypes VALUES(23,2,0); 1086 INSERT INTO itemTypeCreatorTypes VALUES(24,1,1); 1087 INSERT INTO itemTypeCreatorTypes VALUES(24,2,0); 1088 INSERT INTO itemTypeCreatorTypes VALUES(24,16,0); 1089 INSERT INTO itemTypeCreatorTypes VALUES(25,1,1); 1090 INSERT INTO itemTypeCreatorTypes VALUES(25,2,0); 1091 INSERT INTO itemTypeCreatorTypes VALUES(26,2,0); 1092 INSERT INTO itemTypeCreatorTypes VALUES(26,17,1); 1093 INSERT INTO itemTypeCreatorTypes VALUES(26,18,0); 1094 INSERT INTO itemTypeCreatorTypes VALUES(26,19,0); 1095 INSERT INTO itemTypeCreatorTypes VALUES(27,24,1); 1096 INSERT INTO itemTypeCreatorTypes VALUES(27,2,0); 1097 INSERT INTO itemTypeCreatorTypes VALUES(28,8,1); 1098 INSERT INTO itemTypeCreatorTypes VALUES(28,9,0); 1099 INSERT INTO itemTypeCreatorTypes VALUES(28,10,0); 1100 INSERT INTO itemTypeCreatorTypes VALUES(28,11,0); 1101 INSERT INTO itemTypeCreatorTypes VALUES(28,2,0); 1102 INSERT INTO itemTypeCreatorTypes VALUES(29,8,1); 1103 INSERT INTO itemTypeCreatorTypes VALUES(29,9,0); 1104 INSERT INTO itemTypeCreatorTypes VALUES(29,10,0); 1105 INSERT INTO itemTypeCreatorTypes VALUES(29,11,0); 1106 INSERT INTO itemTypeCreatorTypes VALUES(29,2,0); 1107 INSERT INTO itemTypeCreatorTypes VALUES(29,25,0); 1108 INSERT INTO itemTypeCreatorTypes VALUES(30,8,1); 1109 INSERT INTO itemTypeCreatorTypes VALUES(30,9,0); 1110 INSERT INTO itemTypeCreatorTypes VALUES(30,10,0); 1111 INSERT INTO itemTypeCreatorTypes VALUES(30,11,0); 1112 INSERT INTO itemTypeCreatorTypes VALUES(30,2,0); 1113 INSERT INTO itemTypeCreatorTypes VALUES(30,25,0); 1114 INSERT INTO itemTypeCreatorTypes VALUES(31,26,1); 1115 INSERT INTO itemTypeCreatorTypes VALUES(31,2,0); 1116 INSERT INTO itemTypeCreatorTypes VALUES(31,25,0); 1117 INSERT INTO itemTypeCreatorTypes VALUES(32,21,1); 1118 INSERT INTO itemTypeCreatorTypes VALUES(32,2,0); 1119 INSERT INTO itemTypeCreatorTypes VALUES(33, 1, 1); 1120 INSERT INTO itemTypeCreatorTypes VALUES(33, 2, 0); 1121 INSERT INTO itemTypeCreatorTypes VALUES(33, 3, 0); 1122 INSERT INTO itemTypeCreatorTypes VALUES(33, 4, 0); 1123 INSERT INTO itemTypeCreatorTypes VALUES(33, 5, 0); 1124 INSERT INTO itemTypeCreatorTypes VALUES(34,1,1); 1125 INSERT INTO itemTypeCreatorTypes VALUES(34,2,0); 1126 INSERT INTO itemTypeCreatorTypes VALUES(34,3,0); 1127 INSERT INTO itemTypeCreatorTypes VALUES(34,4,0); 1128 INSERT INTO itemTypeCreatorTypes VALUES(34,27,0); 1129 INSERT INTO itemTypeCreatorTypes VALUES(35,1,1); 1130 INSERT INTO itemTypeCreatorTypes VALUES(35,2,0); 1131 INSERT INTO itemTypeCreatorTypes VALUES(35,3,0); 1132 INSERT INTO itemTypeCreatorTypes VALUES(35,4,0); 1133 INSERT INTO itemTypeCreatorTypes VALUES(35,5,0); 1134 INSERT INTO itemTypeCreatorTypes VALUES(36,1,1); 1135 INSERT INTO itemTypeCreatorTypes VALUES(36,2,0); 1136 INSERT INTO itemTypeCreatorTypes VALUES(36,3,0); 1137 INSERT INTO itemTypeCreatorTypes VALUES(36,4,0); 1138 INSERT INTO itemTypeCreatorTypes VALUES(36,5,0); 1139 1140 INSERT INTO "charsets" VALUES (1, "utf-8"); 1141 INSERT INTO "charsets" VALUES (2, "big5"); 1142 INSERT INTO "charsets" VALUES (3, "euc-jp"); 1143 INSERT INTO "charsets" VALUES (4, "euc-kr"); 1144 INSERT INTO "charsets" VALUES (5, "gb18030"); 1145 INSERT INTO "charsets" VALUES (6, "gbk"); 1146 INSERT INTO "charsets" VALUES (7, "ibm866"); 1147 INSERT INTO "charsets" VALUES (8, "iso-2022-jp"); 1148 INSERT INTO "charsets" VALUES (9, "iso-8859-2"); 1149 INSERT INTO "charsets" VALUES (10, "iso-8859-3"); 1150 INSERT INTO "charsets" VALUES (11, "iso-8859-4"); 1151 INSERT INTO "charsets" VALUES (12, "iso-8859-5"); 1152 INSERT INTO "charsets" VALUES (13, "iso-8859-6"); 1153 INSERT INTO "charsets" VALUES (14, "iso-8859-7"); 1154 INSERT INTO "charsets" VALUES (15, "iso-8859-8"); 1155 INSERT INTO "charsets" VALUES (16, "iso-8859-8-i"); 1156 INSERT INTO "charsets" VALUES (17, "iso-8859-10"); 1157 INSERT INTO "charsets" VALUES (18, "iso-8859-13"); 1158 INSERT INTO "charsets" VALUES (19, "iso-8859-14"); 1159 INSERT INTO "charsets" VALUES (20, "iso-8859-15"); 1160 INSERT INTO "charsets" VALUES (21, "iso-8859-16"); 1161 INSERT INTO "charsets" VALUES (22, "koi8-r"); 1162 INSERT INTO "charsets" VALUES (23, "koi8-u"); 1163 INSERT INTO "charsets" VALUES (24, "macintosh"); 1164 INSERT INTO "charsets" VALUES (25, "replacement"); 1165 INSERT INTO "charsets" VALUES (26, "shift_jis"); 1166 INSERT INTO "charsets" VALUES (27, "utf-16be"); 1167 INSERT INTO "charsets" VALUES (28, "utf-16le"); 1168 INSERT INTO "charsets" VALUES (29, "windows-874"); 1169 INSERT INTO "charsets" VALUES (30, "windows-1250"); 1170 INSERT INTO "charsets" VALUES (31, "windows-1251"); 1171 INSERT INTO "charsets" VALUES (32, "windows-1252"); 1172 INSERT INTO "charsets" VALUES (33, "windows-1253"); 1173 INSERT INTO "charsets" VALUES (34, "windows-1254"); 1174 INSERT INTO "charsets" VALUES (35, "windows-1255"); 1175 INSERT INTO "charsets" VALUES (36, "windows-1256"); 1176 INSERT INTO "charsets" VALUES (37, "windows-1257"); 1177 INSERT INTO "charsets" VALUES (38, "windows-1258"); 1178 INSERT INTO "charsets" VALUES (39, "x-mac-cyrillic"); 1179 INSERT INTO "charsets" VALUES (40, "x-user-defined"); 1180 1181 INSERT INTO "fileTypes" VALUES(1, 'webpage'); 1182 INSERT INTO "fileTypes" VALUES(2, 'image'); 1183 INSERT INTO "fileTypes" VALUES(3, 'pdf'); 1184 INSERT INTO "fileTypes" VALUES(4, 'audio'); 1185 INSERT INTO "fileTypes" VALUES(5, 'video'); 1186 INSERT INTO "fileTypes" VALUES(6, 'document'); 1187 INSERT INTO "fileTypes" VALUES(7, 'presentation'); 1188 1189 -- webpage 1190 INSERT INTO "fileTypeMIMETypes" VALUES(1, 'text/html'); 1191 -- image 1192 INSERT INTO "fileTypeMIMETypes" VALUES(2, 'image/'); 1193 INSERT INTO "fileTypeMIMETypes" VALUES(2, 'application/vnd.oasis.opendocument.graphics'); 1194 INSERT INTO "fileTypeMIMETypes" VALUES(2, 'application/vnd.oasis.opendocument.image'); 1195 -- pdf 1196 INSERT INTO "fileTypeMIMETypes" VALUES(3, 'application/pdf'); 1197 -- audio 1198 INSERT INTO "fileTypeMIMETypes" VALUES(4, 'audio/'); 1199 INSERT INTO "fileTypeMIMETypes" VALUES(4, 'x-pn-realaudio'); 1200 INSERT INTO "fileTypeMIMETypes" VALUES(4, 'application/ogg'); 1201 INSERT INTO "fileTypeMIMETypes" VALUES(4, 'application/x-killustrator'); 1202 -- video 1203 INSERT INTO "fileTypeMIMETypes" VALUES(5, 'video/'); 1204 INSERT INTO "fileTypeMIMETypes" VALUES(5, 'application/x-shockwave-flash'); 1205 -- document 1206 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'text/plain'); 1207 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/rtf'); 1208 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/msword'); 1209 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'text/xml'); 1210 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/postscript'); 1211 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/wordperfect5.1'); 1212 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/x-latex'); 1213 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/x-tex'); 1214 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/x-kword'); 1215 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/x-kspread'); 1216 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/x-kchart'); 1217 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/vnd.oasis.opendocument.chart'); 1218 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/vnd.oasis.opendocument.database'); 1219 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/vnd.oasis.opendocument.formula'); 1220 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/vnd.oasis.opendocument.spreadsheet'); 1221 INSERT INTO "fileTypeMIMETypes" VALUES(6, 'application/vnd.oasis.opendocument.text'); 1222 -- presentation 1223 INSERT INTO "fileTypeMIMETypes" VALUES(7, 'application/powerpoint'); 1224 INSERT INTO "fileTypeMIMETypes" VALUES(7, 'application/vnd.oasis.opendocument.presentation'); 1225 INSERT INTO "fileTypeMIMETypes" VALUES(7, 'application/x-kpresenter'); 1226 INSERT INTO "fileTypeMIMETypes" VALUES(7, 'application/vnd.ms-powerpoint'); 1227 1228 INSERT INTO "syncObjectTypes" VALUES(1, 'collection'); 1229 INSERT INTO "syncObjectTypes" VALUES(2, 'creator'); 1230 INSERT INTO "syncObjectTypes" VALUES(3, 'item'); 1231 INSERT INTO "syncObjectTypes" VALUES(4, 'search'); 1232 INSERT INTO "syncObjectTypes" VALUES(5, 'tag'); 1233 INSERT INTO "syncObjectTypes" VALUES(6, 'relation'); 1234 INSERT INTO "syncObjectTypes" VALUES(7, 'setting');