-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
-- +-------------------------------------------------+
-- $Id: indexint_small_en.sql,v 1.5 2007-08-29 08:36:31 touraine37 Exp $

truncate table pclassement;
truncate table indexint;

-- 
-- Contenu de la table `indexint`
-- 

INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (1, '000', 'Generalities', ' 000 generalities ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (2, '010', 'Bibliography ', ' 010 bibliography ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (3, '020', 'Library Science ', ' 020 library science ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (4, '030', 'Encyclopedias ', ' 030 encyclopedias ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (5, '040', 'Unassigned ', ' 040 unassigned ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (6, '050', 'Magazines ', ' 050 magazines ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (7, '060', 'Organizations, museums ', ' 060 organizations museums ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (8, '070', 'Journalism ', ' 070 journalism ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (9, '080', 'General collections ', ' 080 general collections ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (10, '090', 'Manuscripts, rare books ', ' 090 manuscripts rare books ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (11, '100', 'Philosophy ', ' 100 philosophy ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (12, '110', 'Metaphysics ', ' 110 metaphysics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (13, '120', 'Epistemology ', ' 120 epistemology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (14, '130', 'Paranormal Phenomena ', ' 130 paranormal phenomena ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (15, '140', 'Specific philosophies ', ' 140 specific philosophies ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (16, '150', 'Psychology ', ' 150 psychology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (17, '160', 'Logic ', ' 160 logic ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (18, '170', 'Ethics ', ' 170 ethics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (19, '180', 'Ancient philosophy ', ' 180 ancient philosophy ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (20, '190', 'Modern philosophy ', ' 190 modern philosophy ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (21, '200', 'Religion ', ' 200 religion ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (22, '210', 'Natural theology ', ' 210 natural theology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (23, '220', 'Bible ', ' 220 bible ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (24, '230', 'Christian theology ', ' 230 christian theology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (25, '240', 'Christian moral theology ', ' 240 christian moral theology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (26, '250', 'Christian orders ', ' 250 christian orders ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (27, '260', 'Christian social theology ', ' 260 christian social theology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (28, '270', 'Christian Church History ', ' 270 christian church history ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (29, '280', 'Christian denominations ', ' 280 christian denominations ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (30, '290', 'Other religions ', ' 290 other religions ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (31, '300', 'Social Science ', ' 300 social science ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (32, '310', 'General statistics ', ' 310 general statistics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (33, '320', 'Political science ', ' 320 political science ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (34, '330', 'Economics ', ' 330 economics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (35, '340', 'Law ', ' 340 law ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (36, '350', 'Public administration ', ' 350 public administration ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (37, '360', 'Social services ', ' 360 social services ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (38, '370', 'Education ', ' 370 education ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (39, '380', 'Commerce, transport ', ' 380 commerce transport ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (40, '390', 'Customs, folklore ', ' 390 customs folklore ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (41, '400', 'Language ', ' 400 language ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (42, '410', 'Linguistics ', ' 410 linguistics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (43, '420', 'English ', ' 420 english ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (44, '430', 'German ', ' 430 german ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (45, '440', 'French ', ' 440 french ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (46, '450', 'Italian, Romanian ', ' 450 italian romanian ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (47, '460', 'Spanish, Portuguese ', ' 460 spanish portuguese ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (48, '470', 'Latin ', ' 470 latin ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (49, '480', 'Classical Greek ', ' 480 classical greek ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (50, '490', 'Other languages ', ' 490 other languages ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (51, '500', 'Science ', ' 500 science ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (52, '510', 'Mathematics ', ' 510 mathematics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (53, '520', 'Astronomy ', ' 520 astronomy ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (54, '530', 'Physics ', ' 530 physics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (55, '540', 'Chemistry ', ' 540 chemistry ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (56, '550', 'Earth sciences ', ' 550 earth sciences ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (57, '560', 'Paleontology ', ' 560 paleontology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (58, '570', 'Life sciences ', ' 570 life sciences ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (59, '580', 'Botany ', ' 580 botany ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (60, '590', 'Zoology ', ' 590 zoology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (61, '600', 'Technology ', ' 600 technology ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (62, '610', 'Medicine ', ' 610 medicine ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (63, '620', 'Engineering ', ' 620 engineering ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (64, '630', 'Agriculture ', ' 630 agriculture ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (65, '640', 'Home economics ', ' 640 home economics ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (66, '650', 'Management ', ' 650 management ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (67, '660', 'Chemical engineering ', ' 660 chemical engineering ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (68, '670', 'Manufacturing ', ' 670 manufacturing ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (69, '680', 'Specific industries ', ' 680 specific industries ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (70, '690', 'Buildings ', ' 690 buildings ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (71, '700', 'Arts, Entertainment ', ' 700 arts entertainment ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (72, '710', 'Civic & landscape art ', ' 710 civic landscape art ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (73, '720', 'Architecture ', ' 720 architecture ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (74, '730', 'Plastic arts, Sculpture ', ' 730 plastic arts sculpture ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (75, '740', 'Drawing, decorative arts ', ' 740 drawing decorative arts ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (76, '750', 'Painting ', ' 750 painting ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (77, '760', 'Graphic arts, Printmaking ', ' 760 graphic arts printmaking ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (78, '770', 'Photography ', ' 770 photography ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (79, '780', 'Music ', ' 780 music ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (80, '790', 'Recreation, performing arts ', ' 790 recreation performing arts ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (81, '800', 'Literature ', ' 800 literature ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (82, '810', 'American ', ' 810 american ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (83, '820', 'English ', ' 820 english ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (84, '830', 'German ', ' 830 german ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (85, '840', 'French ', ' 840 french ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (86, '850', 'Italian, Romanian ', ' 850 italian romanian ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (87, '860', 'Spanish, Portuguese ', ' 860 spanish portuguese ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (88, '870', 'Latin ', ' 870 latin ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (89, '880', 'Classical Greek ', ' 880 classical greek ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (90, '890', 'Other literatures ', ' 890 other literatures ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (91, '900', 'Geography & History ', ' 900 geography history ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (92, '910', 'Geography & travel ', ' 910 geography travel ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (93, '920', 'Biography, genealogy ', ' 920 biography genealogy ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (94, '930', 'History of ancient world ', ' 930 history of ancient world ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (95, '940', 'History of Europe ', ' 940 history of europe ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (96, '950', 'History of Asia ', ' 950 history of asia ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (97, '960', 'History of Africa ', ' 960 history of africa ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (98, '970', 'History of North America ', ' 970 history of north america ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (99, '980', 'History of South America ', ' 980 history of south america ', 1);
INSERT INTO indexint (indexint_id, indexint_name, indexint_comment, index_indexint, num_pclass) VALUES (100, '990', 'History of other areas ', ' 990 history of other areas ', 1);

-- 
-- Contenu de la table `pclassement`
-- 

INSERT INTO pclassement (id_pclass, name_pclass, typedoc) VALUES (1, 'English light Dewey', 'abcdefgijklmr');
