Post by Uncle Buddy on Aug 23, 2022 10:31:20 GMT -8
I forgot to do this in today's commit so here it is. Big changes since types tables and color_scheme table were moved to the global database which is treebard.db. The only tree database whose schemas are currently up-to-date with this is charles_d._gregory_family_tree.tbd and same.sql. The default_new_tree has to be caught up to gregory changes in schemas. Here's treebard.sql:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "app_setting" (app_setting_id INTEGER PRIMARY KEY, openpic_dir TEXT, default_openpic_dir TEXT NOT NULL DEFAULT 'images/openpic');
INSERT INTO app_setting VALUES(1,NULL,'images/openpic');
CREATE TABLE IF NOT EXISTS "chart_type" (chart_type_id INTEGER PRIMARY KEY, chart_types TEXT UNIQUE NOT NULL);
CREATE TABLE IF NOT EXISTS "closing_state" (closing_state_id INTEGER PRIMARY KEY, prior_tree TEXT DEFAULT null, openpic TEXT NOT NULL DEFAULT 'tree_of_life_lib_o_congress.jpg', tree_is_open BOOLEAN NOT NULL DEFAULT 0, recent_files TEXT DEFAULT "");
INSERT INTO closing_state VALUES(1,'charles_d._gregory_family_tree.tbd','tree_geo_hodan.jpg',1,'Charles D. Gregory Family Tree_+_Sample Tree');
CREATE TABLE IF NOT EXISTS "color_scheme" (color_scheme_id INTEGER PRIMARY KEY, bg TEXT NOT NULL, highlight_bg TEXT NOT NULL, head_bg TEXT NOT NULL, fg TEXT NOT NULL, built_in BOOLEAN NOT NULL DEFAULT 1, hidden BOOLEAN NOT NULL DEFAULT 0);
INSERT INTO color_scheme VALUES(1,'#061d2f','#284b80','#267d82','#71cfd5',1,0);
INSERT INTO color_scheme VALUES(2,'red','magenta','blue','yellow',1,1);
INSERT INTO color_scheme VALUES(240,'#232931','#393e46','#2E5447','#eeeeee',1,0);
INSERT INTO color_scheme VALUES(241,'#393932','#4d4545','#8d6262','#f1c5c5',1,0);
INSERT INTO color_scheme VALUES(242,'#212121','#323232','#0d7377','#7efee1',1,0);
INSERT INTO color_scheme VALUES(243,'#423030','#605656','gray','lightgray',1,0);
INSERT INTO color_scheme VALUES(244,'#a3e4db','#fed1ef','#72aef7','#333333',1,0);
INSERT INTO color_scheme VALUES(245,'#f0ece3','#dfd3c3','#c7b198','#5e5448',1,1);
INSERT INTO color_scheme VALUES(246,'#d3e4cd','#f2ddc1','#e2c2b9','#33282d',1,0);
INSERT INTO color_scheme VALUES(247,'#fff1af','#b4c6a6','#ab937b','#1c150e',1,0);
INSERT INTO color_scheme VALUES(248,'#f3f0d7','#cee5d0','#fed2aa','#1f1913',1,0);
INSERT INTO color_scheme VALUES(249,'#c8e3d4','#f6d7a7','#f6eabe','#1a1814',1,0);
INSERT INTO color_scheme VALUES(250,'#e5dcc3','#c7bea2','#aaa492','#12110f',1,0);
INSERT INTO color_scheme VALUES(251,'#faeee0','#f9e4c8','#d8d0c0','#121110',1,0);
INSERT INTO color_scheme VALUES(252,'#f3f0d7','#cee5d0','#e0c097','#1d2226',1,0);
INSERT INTO color_scheme VALUES(253,'#f3d5c0','#d4b499','#889eaf','#242426',1,0);
INSERT INTO color_scheme VALUES(254,'#ffe3e3','#e4d8dc','#c9ccd5','#21201a',1,0);
INSERT INTO color_scheme VALUES(255,'#feffe2','#f0f0cb','#dad5ab','#1c1a17',1,0);
INSERT INTO color_scheme VALUES(256,'#f4dfd0','#dad0c2','#cdbba7','#1a1615',1,0);
INSERT INTO color_scheme VALUES(257,'#f8e2cf','#f5c6aa','#fcd8d4','#0f1112',1,0);
INSERT INTO color_scheme VALUES(258,'#f1ecc3','#c9d8b6','#90a7b0','#171612',1,0);
INSERT INTO color_scheme VALUES(259,'#e6ddc6','#c3b8a3','#a19882','#1f181b',1,0);
INSERT INTO color_scheme VALUES(260,'#caf7e3','#f6dfeb','#e4bad4','#1c1a16',1,0);
INSERT INTO color_scheme VALUES(261,'#f6e6cb','#e3cdc1','#a0937d','#171a16',1,0);
INSERT INTO color_scheme VALUES(262,'#f8ede3','#bdd2b6','#798777','#171315',1,0);
INSERT INTO color_scheme VALUES(263,'#caf7e3','#f6dfeb','#e4bad4','#141414',1,0);
INSERT INTO color_scheme VALUES(264,'#f9f7cf','#f2dcbb','#bbbbbb','#151617',1,0);
INSERT INTO color_scheme VALUES(265,'#f4f4f2','#e8e8e8','#bbbfca','#170e11',1,0);
INSERT INTO color_scheme VALUES(266,'#d6e5fa','#baabda','#d77fa1','#1a0e12',1,0);
INSERT INTO color_scheme VALUES(267,'#7b6079','#506362','#de8971','#e3d8e2',1,1);
INSERT INTO color_scheme VALUES(268,'#433520','#025955','#00917c','#fde8cd',1,0);
INSERT INTO color_scheme VALUES(269,'#0d335d','#1a508b','#c1a1d3','#fff3e6',1,0);
INSERT INTO color_scheme VALUES(270,'#19456b','#11698e','#16c79a','#f8f1f1',1,0);
INSERT INTO color_scheme VALUES(271,'#424242','#a98b98','#4e3d53','#a6f0c6',1,0);
INSERT INTO color_scheme VALUES(272,'#351f39','#726a95','#485154','#a0c1b8',1,0);
INSERT INTO color_scheme VALUES(273,'#222831','#4f8a8b','#615229','#eeeeee',1,0);
INSERT INTO color_scheme VALUES(274,'#3e3838','#ae7c7c','#365e5a','#e3dada',1,0);
INSERT INTO color_scheme VALUES(275,'#305973','#ef7e56','#787371','#e6dfdc',1,1);
INSERT INTO color_scheme VALUES(276,'#041c32','#04293a','#064663','#ced7db',1,0);
INSERT INTO color_scheme VALUES(277,'#112031','#152d35','#345b63','#d4ecdd',1,0);
INSERT INTO color_scheme VALUES(278,'#334257','#476062','#548ca8','#eeeeee',1,0);
INSERT INTO color_scheme VALUES(279,'#351f39','#726a95','#485154','#a0c1b8',1,0);
INSERT INTO color_scheme VALUES(280,'#382933','#3b5249','#3d5448','#a4b494',1,0);
INSERT INTO color_scheme VALUES(281,'#4d4646','#5b5656','#47544a','#f5eaea',1,0);
INSERT INTO color_scheme VALUES(282,'#222831','#393e46','#d65a31','#eeeeee',1,1);
INSERT INTO color_scheme VALUES(283,'#33313b','#62374e','#007880','#ccbec5',1,0);
INSERT INTO color_scheme VALUES(284,'#33313b','#3c4f65','#834c69','#e6f5ff',1,0);
INSERT INTO color_scheme VALUES(285,'#272121','#363333','#e16428','#f6e9e9',1,1);
INSERT INTO color_scheme VALUES(286,'#2a2438','#352f44','#5c5470','#dbd8e3',1,0);
INSERT INTO color_scheme VALUES(287,'#a0937d','#3a6351','#5f939a','#f2edd7',1,1);
INSERT INTO color_scheme VALUES(288,'#35483a','#647d73','#7e6373','#d5e0dc',1,0);
INSERT INTO color_scheme VALUES(289,'#35483a','#647d73','#4d444b','#d5e0dc',1,0);
INSERT INTO color_scheme VALUES(290,'#34615f','#4a8a87','#486a8c','#b9ddd9',1,0);
INSERT INTO color_scheme VALUES(291,'#344140','#5a7270','#977d77','#ffffff',1,0);
INSERT INTO color_scheme VALUES(292,'#1e1e1e','#484848','#43523f','#d7d7d7',1,0);
INSERT INTO color_scheme VALUES(293,'#b8a089','#cbbaa9','#ded3c9','#2d241c',1,0);
INSERT INTO color_scheme VALUES(294,'#0C1021','#55606c','#808c9b','white',1,0);
INSERT INTO color_scheme VALUES(295,'#283133','#899ea3','#86a68b','white',1,0);
INSERT INTO color_scheme VALUES(296,'#2F343F','#424242','#212121','#AFB9C6',1,0);
INSERT INTO color_scheme VALUES(297,'#38555f','#507987','#4d598a','#ced6d9',1,0);
INSERT INTO color_scheme VALUES(298,'#151a26','#3d4b6d','#6c8093','#dadee6',1,0);
INSERT INTO color_scheme VALUES(299,'#152028','#232b32','#202945','#d8dee3',1,0);
INSERT INTO color_scheme VALUES(300,'#121212','#606782','#34393b','#99b0bb',1,0);
INSERT INTO color_scheme VALUES(301,'#121212','#403250','#34383d','#d9d5de',1,0);
INSERT INTO color_scheme VALUES(302,'#dbdde8','#b4b8cf','#8087ae','#1c1c21',1,0);
INSERT INTO color_scheme VALUES(303,'#bcd0d3','#97b7bb','#639196','#141b1c',1,0);
INSERT INTO color_scheme VALUES(314,'#f0ece3','#dfd3c3','#c7b198','#363636',0,0);
INSERT INTO color_scheme VALUES(315,'#a0937d','#3a6351','#5f939a','#f3f3f3',0,0);
INSERT INTO color_scheme VALUES(317,'#34615f','#4a8a87','#486a8c','#faeefb',0,0);
CREATE TABLE IF NOT EXISTS "default_date_format" (default_date_format_id INTEGER PRIMARY KEY, default_date_formats TEXT, default_abt TEXT, default_est TEXT, default_cal TEXT, default_bef_aft TEXT, default_bc_ad TEXT, default_os_ns TEXT, default_span TEXT, default_range TEXT);
INSERT INTO default_date_format VALUES(1,'dmy','abt','est','calc','bef/aft','BCE/CE','OS/NS','from_to','btwn_&');
CREATE TABLE IF NOT EXISTS "default_format" (default_format_id INTEGER PRIMARY KEY, default_bg TEXT, default_highlight_bg TEXT, default_head_bg TEXT, default_fg TEXT, default_output_font TEXT, default_input_font TEXT, default_font_size INTEGER);
INSERT INTO default_format VALUES(1,'#061d2f','#284b80','#267d82','#71cfd5','courier','dejavu sans mono',12);
CREATE TABLE IF NOT EXISTS "event_type" (event_type_id INTEGER PRIMARY KEY, event_types TEXT UNIQUE NOT NULL, built_in BOOLEAN NOT NULL DEFAULT 0, hidden BOOLEAN NOT NULL DEFAULT 0, couple BOOLEAN NOT NULL DEFAULT 0, after_death BOOLEAN NOT NULL DEFAULT 0, marital BOOLEAN NOT NULL DEFAULT 0);
INSERT INTO event_type VALUES(1,'birth',1,0,0,0,0);
INSERT INTO event_type VALUES(2,'marriage',1,0,1,0,1);
INSERT INTO event_type VALUES(3,'illness',1,0,0,0,0);
INSERT INTO event_type VALUES(4,'death',1,0,0,0,0);
INSERT INTO event_type VALUES(5,'burial',1,0,0,1,0);
INSERT INTO event_type VALUES(6,'occupation',1,0,0,0,0);
INSERT INTO event_type VALUES(7,'imprisonment',1,0,0,0,0);
INSERT INTO event_type VALUES(8,'deportation',1,0,0,0,0);
INSERT INTO event_type VALUES(9,'invention',1,0,0,0,0);
INSERT INTO event_type VALUES(10,'religious conversion',1,0,0,0,0);
INSERT INTO event_type VALUES(11,'wedding',1,0,1,0,1);
INSERT INTO event_type VALUES(12,'ran away from home',1,0,0,0,0);
INSERT INTO event_type VALUES(13,'residence',1,0,0,0,0);
INSERT INTO event_type VALUES(14,'autopsy',1,0,0,1,0);
INSERT INTO event_type VALUES(15,'divorce',1,0,1,0,1);
INSERT INTO event_type VALUES(16,'engagement',1,0,1,0,0);
INSERT INTO event_type VALUES(17,'annulment',1,0,1,0,1);
INSERT INTO event_type VALUES(18,'separation',1,0,1,0,1);
INSERT INTO event_type VALUES(19,'eye color',1,0,0,0,0);
INSERT INTO event_type VALUES(20,'hair color',1,0,0,0,0);
INSERT INTO event_type VALUES(21,'height',1,0,0,0,0);
INSERT INTO event_type VALUES(22,'weight',1,0,0,0,0);
INSERT INTO event_type VALUES(23,'build',1,0,0,0,0);
INSERT INTO event_type VALUES(24,'complexion',1,0,0,0,0);
INSERT INTO event_type VALUES(25,'race',1,0,0,0,0);
INSERT INTO event_type VALUES(26,'ethnic origin',1,0,0,0,0);
INSERT INTO event_type VALUES(27,'marks, scars',1,0,0,0,0);
INSERT INTO event_type VALUES(28,'disability',1,0,0,0,0);
INSERT INTO event_type VALUES(29,'condition',1,0,0,0,0);
INSERT INTO event_type VALUES(30,'religion',1,0,0,0,0);
INSERT INTO event_type VALUES(31,'career',1,0,0,0,0);
INSERT INTO event_type VALUES(32,'number of children, total',1,0,0,0,0);
INSERT INTO event_type VALUES(33,'number of children, living',1,0,0,0,0);
INSERT INTO event_type VALUES(34,'marital status',1,0,0,0,0);
INSERT INTO event_type VALUES(35,'political affiliation',1,0,0,0,0);
INSERT INTO event_type VALUES(36,'special talent',1,0,0,0,0);
INSERT INTO event_type VALUES(37,'hobby',1,0,0,0,0);
INSERT INTO event_type VALUES(38,'able to read',1,0,0,0,0);
INSERT INTO event_type VALUES(39,'able to write',1,0,0,0,0);
INSERT INTO event_type VALUES(40,'first language',1,0,0,0,0);
INSERT INTO event_type VALUES(41,'nationality',1,0,0,0,0);
INSERT INTO event_type VALUES(42,'education level',1,0,0,0,0);
INSERT INTO event_type VALUES(43,'draft registration',1,0,0,0,0);
INSERT INTO event_type VALUES(44,'legal problem',1,0,0,0,0);
INSERT INTO event_type VALUES(45,'tobacco use',1,1,0,0,0);
INSERT INTO event_type VALUES(46,'alcohol use',1,1,0,0,0);
INSERT INTO event_type VALUES(47,'drug problem',1,1,0,0,0);
INSERT INTO event_type VALUES(48,'guardianship',1,0,0,0,0);
INSERT INTO event_type VALUES(49,'inquest',1,0,0,1,0);
INSERT INTO event_type VALUES(50,'relationship',1,0,1,0,0);
INSERT INTO event_type VALUES(53,'jury duty',1,0,0,0,0);
INSERT INTO event_type VALUES(54,'baptism',1,0,0,0,0);
INSERT INTO event_type VALUES(55,'excommunication',1,0,0,0,0);
INSERT INTO event_type VALUES(56,'betrothal',1,0,1,0,0);
INSERT INTO event_type VALUES(57,'resignation',1,0,0,0,0);
INSERT INTO event_type VALUES(58,'naturalization',1,0,0,0,0);
INSERT INTO event_type VALUES(59,'marriage license',1,0,1,0,1);
INSERT INTO event_type VALUES(60,'christening',1,0,0,0,0);
INSERT INTO event_type VALUES(61,'confirmation',1,0,0,0,0);
INSERT INTO event_type VALUES(62,'cremation',1,0,0,1,0);
INSERT INTO event_type VALUES(63,'will',1,0,0,0,0);
INSERT INTO event_type VALUES(64,'retirement',1,0,0,0,0);
INSERT INTO event_type VALUES(65,'ordination',1,0,0,0,0);
INSERT INTO event_type VALUES(66,'graduation',1,0,0,0,0);
INSERT INTO event_type VALUES(67,'emigration',1,0,0,0,0);
INSERT INTO event_type VALUES(68,'probate',1,0,0,1,0);
INSERT INTO event_type VALUES(69,'enrollment',1,0,0,0,0);
INSERT INTO event_type VALUES(70,'execution',1,0,0,0,0);
INSERT INTO event_type VALUES(71,'employment',1,0,0,0,0);
INSERT INTO event_type VALUES(72,'land grant',1,0,0,0,0);
INSERT INTO event_type VALUES(73,'name change',1,0,0,0,0);
INSERT INTO event_type VALUES(74,'land purchase',1,0,0,0,0);
INSERT INTO event_type VALUES(75,'land sale',1,0,0,0,0);
INSERT INTO event_type VALUES(76,'military induction',1,0,0,0,0);
INSERT INTO event_type VALUES(77,'military enlistment',1,0,0,0,0);
INSERT INTO event_type VALUES(78,'military discharge',1,0,0,0,0);
INSERT INTO event_type VALUES(79,'military promotion',1,0,0,0,0);
INSERT INTO event_type VALUES(80,'military service',1,0,0,0,0);
INSERT INTO event_type VALUES(81,'marriage banns',1,0,1,0,0);
INSERT INTO event_type VALUES(82,'missing in action',1,0,0,0,0);
INSERT INTO event_type VALUES(83,'adoption',1,0,0,0,0);
INSERT INTO event_type VALUES(84,'reburial',1,0,0,1,0);
INSERT INTO event_type VALUES(85,'filing for divorce',1,0,1,0,1);
INSERT INTO event_type VALUES(86,'reading of the will',1,0,0,1,0);
INSERT INTO event_type VALUES(87,'exhumation',1,0,0,1,0);
INSERT INTO event_type VALUES(88,'funeral',1,0,0,1,0);
INSERT INTO event_type VALUES(89,'celebration of life',1,0,0,1,0);
INSERT INTO event_type VALUES(90,'partnership',1,0,1,0,1);
INSERT INTO event_type VALUES(91,'natural disaster',1,0,0,0,0);
INSERT INTO event_type VALUES(93,'anniversary celebration',1,0,1,0,1);
INSERT INTO event_type VALUES(95,'fosterage',1,0,0,0,0);
INSERT INTO event_type VALUES(96,'posthumous offspring',1,0,0,1,0);
INSERT INTO event_type VALUES(98,'marriage contract',1,0,1,0,1);
INSERT INTO event_type VALUES(99,'reunion',0,0,0,0,0);
INSERT INTO event_type VALUES(100,'scattering of ashes',1,0,0,1,0);
INSERT INTO event_type VALUES(101,'inurnment',1,0,0,1,0);
INSERT INTO event_type VALUES(102,'cohabitation',1,0,1,0,1);
INSERT INTO event_type VALUES(103,'living together',1,0,1,0,1);
INSERT INTO event_type VALUES(104,'wedding anniversary',1,0,1,0,1);
INSERT INTO event_type VALUES(105,'patent filing',1,0,0,0,0);
INSERT INTO event_type VALUES(106,'patent granted',1,0,0,0,0);
CREATE TABLE IF NOT EXISTS "kin_type" (kin_type_id INTEGER PRIMARY KEY, kin_types TEXT UNIQUE NOT NULL, kin_code TEXT NOT NULL, hidden BOOLEAN NOT NULL DEFAULT 0);
INSERT INTO kin_type VALUES(1,'father','B',0);
INSERT INTO kin_type VALUES(2,'mother','B',0);
INSERT INTO kin_type VALUES(3,'parent','B',1);
INSERT INTO kin_type VALUES(4,'son','E',0);
INSERT INTO kin_type VALUES(5,'daughter','E',0);
INSERT INTO kin_type VALUES(6,'child','E',0);
INSERT INTO kin_type VALUES(7,'husband','D',0);
INSERT INTO kin_type VALUES(8,'wife','D',0);
INSERT INTO kin_type VALUES(9,'spouse','D',0);
INSERT INTO kin_type VALUES(10,'mate','D',0);
INSERT INTO kin_type VALUES(11,'brother','C',0);
INSERT INTO kin_type VALUES(12,'sister','C',0);
INSERT INTO kin_type VALUES(13,'sibling','C',0);
INSERT INTO kin_type VALUES(14,'partner','D',0);
INSERT INTO kin_type VALUES(15,'common-law spouse','D',0);
INSERT INTO kin_type VALUES(16,'fiance','D',0);
INSERT INTO kin_type VALUES(17,'fiancee','D',0);
INSERT INTO kin_type VALUES(18,'boyfriend','D',0);
INSERT INTO kin_type VALUES(19,'girlfriend','D',0);
INSERT INTO kin_type VALUES(20,'lady friend','D',0);
INSERT INTO kin_type VALUES(21,'lover','D',1);
INSERT INTO kin_type VALUES(22,'mistress','D',0);
INSERT INTO kin_type VALUES(23,'betrothed','D',0);
INSERT INTO kin_type VALUES(24,'groom','D',0);
INSERT INTO kin_type VALUES(25,'bride','D',0);
INSERT INTO kin_type VALUES(26,'biological parent','B',1);
INSERT INTO kin_type VALUES(27,'biological father','B',1);
INSERT INTO kin_type VALUES(28,'biological mother','B',1);
INSERT INTO kin_type VALUES(110,'adoptive parent','B',0);
INSERT INTO kin_type VALUES(111,'adoptive father','B',0);
INSERT INTO kin_type VALUES(112,'adoptive mother','B',0);
INSERT INTO kin_type VALUES(120,'foster parent','B',0);
INSERT INTO kin_type VALUES(121,'foster father','B',0);
INSERT INTO kin_type VALUES(122,'foster mother','B',0);
INSERT INTO kin_type VALUES(128,'generic_partner1','D',0);
INSERT INTO kin_type VALUES(129,'generic_partner2','D',0);
INSERT INTO kin_type VALUES(130,'guardian','B',0);
INSERT INTO kin_type VALUES(131,'legal guardian','B',0);
CREATE TABLE IF NOT EXISTS "media_type" (media_type_id INTEGER PRIMARY KEY, media_types TEXT UNIQUE NOT NULL);
CREATE TABLE IF NOT EXISTS "name_type" (name_type_id INTEGER PRIMARY KEY, name_types TEXT UNIQUE NOT NULL, hierarchy INTEGER DEFAULT 999);
INSERT INTO name_type VALUES(1,'birth name',0);
INSERT INTO name_type VALUES(2,'also known as',3);
INSERT INTO name_type VALUES(3,'pseudonym',6);
INSERT INTO name_type VALUES(4,'ID number',16);
INSERT INTO name_type VALUES(5,'adoptive name',2);
INSERT INTO name_type VALUES(6,'married name',4);
INSERT INTO name_type VALUES(7,'handle',17);
INSERT INTO name_type VALUES(8,'alternate spelling',14);
INSERT INTO name_type VALUES(9,'mis-spelling',15);
INSERT INTO name_type VALUES(10,'legally changed name',5);
INSERT INTO name_type VALUES(11,'stage name',8);
INSERT INTO name_type VALUES(12,'nickname',9);
INSERT INTO name_type VALUES(13,'call name',10);
INSERT INTO name_type VALUES(14,'official name',11);
INSERT INTO name_type VALUES(15,'anglicized name',12);
INSERT INTO name_type VALUES(16,'unknown name',22);
INSERT INTO name_type VALUES(17,'religious order name',13);
INSERT INTO name_type VALUES(18,'other name type',19);
INSERT INTO name_type VALUES(19,'code name',18);
INSERT INTO name_type VALUES(20,'pen name',7);
INSERT INTO name_type VALUES(21,'given name',21);
INSERT INTO name_type VALUES(22,'reference name',1);
INSERT INTO name_type VALUES(23,'surname',20);
INSERT INTO name_type VALUES(24,'placeholder for name',23);
INSERT INTO name_type VALUES(25,'name at work',24);
CREATE TABLE IF NOT EXISTS "report_type" (report_type_id INTEGER PRIMARY KEY, report_types TEXT UNIQUE NOT NULL);
CREATE TABLE IF NOT EXISTS "role_type" (role_type_id INTEGER PRIMARY KEY, role_types TEXT UNIQUE NOT NULL, built_in BOOLEAN NOT NULL DEFAULT 0, hidden BOOLEAN NOT NULL DEFAULT 0);
INSERT INTO role_type VALUES(1,'religious officer',1,0);
INSERT INTO role_type VALUES(2,'justice of the peace',1,0);
INSERT INTO role_type VALUES(3,'arresting officer',1,0);
INSERT INTO role_type VALUES(4,'supervisor',1,0);
INSERT INTO role_type VALUES(5,'employer',1,0);
INSERT INTO role_type VALUES(6,'midwife',1,0);
INSERT INTO role_type VALUES(7,'bridesmaid',1,0);
INSERT INTO role_type VALUES(8,'best man',1,0);
INSERT INTO role_type VALUES(9,'bible bearer',1,0);
INSERT INTO role_type VALUES(10,'flower girl',1,0);
INSERT INTO role_type VALUES(11,'witness',1,0);
INSERT INTO role_type VALUES(12,'employee',1,0);
INSERT INTO role_type VALUES(13,'assistant',1,0);
INSERT INTO role_type VALUES(14,'roommate',1,0);
INSERT INTO role_type VALUES(15,'landlady',1,0);
INSERT INTO role_type VALUES(16,'landlord',1,0);
INSERT INTO role_type VALUES(17,'unknown',1,0);
INSERT INTO role_type VALUES(18,'foster parent',1,0);
INSERT INTO role_type VALUES(19,'makeup artist',1,0);
INSERT INTO role_type VALUES(20,'financier',1,0);
INSERT INTO role_type VALUES(21,'florist',1,0);
INSERT INTO role_type VALUES(22,'usher',1,0);
INSERT INTO role_type VALUES(23,'photographer',1,0);
INSERT INTO role_type VALUES(24,'bartender',1,0);
INSERT INTO role_type VALUES(25,'bodyguard',1,0);
INSERT INTO role_type VALUES(26,'adoptive parent',1,0);
INSERT INTO role_type VALUES(27,'hairdresser',1,0);
INSERT INTO role_type VALUES(28,'chauffeur',1,0);
INSERT INTO role_type VALUES(29,'treasurer',1,0);
INSERT INTO role_type VALUES(30,'trainer',1,0);
INSERT INTO role_type VALUES(31,'secretary',1,0);
INSERT INTO role_type VALUES(32,'navigator',1,0);
INSERT INTO role_type VALUES(39,'neighbor',1,0);
INSERT INTO role_type VALUES(40,'maid',1,0);
INSERT INTO role_type VALUES(41,'pilot',1,0);
INSERT INTO role_type VALUES(44,'mining partner',1,0);
INSERT INTO role_type VALUES(47,'legal guardian',1,0);
INSERT INTO role_type VALUES(55,'other',1,0);
INSERT INTO role_type VALUES(87,'interior decorator',1,0);
INSERT INTO role_type VALUES(88,'executioner',1,0);
INSERT INTO role_type VALUES(90,'driver',1,0);
INSERT INTO role_type VALUES(96,'host',1,0);
INSERT INTO role_type VALUES(97,'hostess',1,0);
INSERT INTO role_type VALUES(99,'farm hand',1,0);
INSERT INTO role_type VALUES(100,'ranch hand',1,0);
INSERT INTO role_type VALUES(103,'junior partner',1,0);
INSERT INTO role_type VALUES(114,'butler',1,0);
INSERT INTO role_type VALUES(115,'boarder',1,0);
INSERT INTO role_type VALUES(116,'chef',1,0);
INSERT INTO role_type VALUES(117,'patent attorney',1,0);
DELETE FROM sqlite_sequence;
COMMIT;