BEGIN TRANSACTION;
CREATE TABLE skill_groups (
	id INTEGER PRIMARY KEY NOT NULL,
	name TEXT
);
INSERT INTO "skill_groups" VALUES(100,'Athletic');
INSERT INTO "skill_groups" VALUES(200,'Combat');
INSERT INTO "skill_groups" VALUES(300,'Covert/Urban');
INSERT INTO "skill_groups" VALUES(400,'Knowledge');
INSERT INTO "skill_groups" VALUES(500,'Magic');
INSERT INTO "skill_groups" VALUES(501,'Gramarye');
INSERT INTO "skill_groups" VALUES(600,'Professional');
INSERT INTO "skill_groups" VALUES(700,'Scouting/Survival');
INSERT INTO "skill_groups" VALUES(800,'Social');
CREATE TABLE skills(
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	name TEXT,
	description TEXT
);
INSERT INTO "skills" VALUES(1,'Acrobatics/Tumbling','moving your body gracefully and successfully through difficult maneuvers, such as rolls, tumbles, leaps, springing to your feet, etc.');
INSERT INTO "skills" VALUES(2,'Aerial Acrobatics','swinging from ropes, chandeliers, vines, trapezes, rigging, etc., safely and accurately.');
INSERT INTO "skills" VALUES(3,'Balance','keeping one''s equilibrium in awkward physical situations, such as tightrope walking, beam walking, crossing a stream on a log, etc.');
INSERT INTO "skills" VALUES(4,'Boating','small boat handling.');
INSERT INTO "skills" VALUES(6,'Climbing','climbing, either natural formations such as cliffs and trees, or man-made ones such as stone, brick, etc., (but not sheer) walls.');
INSERT INTO "skills" VALUES(8,'Equestrian Acrobatics','performing acrobatic mounts, dismounts, trick riding, etc. This skill cannot be higher than your Riding skill.');
INSERT INTO "skills" VALUES(9,'Throwing','throwing things accurately, but not specifically optimized to do damage. That is, it''s not a combat skill, though it could be used as one, with -1 to damage-dealing ability.');
INSERT INTO "skills" VALUES(10,'Whittling','carving wood into useful or aesthetic shapes.');
INSERT INTO "skills" VALUES(12,'Juggling','juggling anything you can lift. See also Performing.');
INSERT INTO "skills" VALUES(13,'Jumping','jumping for distance and accuracy.');
INSERT INTO "skills" VALUES(14,'Knot-tying','tying functional and/or ornamental knots for various purposes. [Default=Mediocre]');
INSERT INTO "skills" VALUES(15,'Move Quietly','moving without attracting attention. Opposed by Perception.');
INSERT INTO "skills" VALUES(18,'Riding','riding and controlling a horse (or other riding animal - specify) comfortably, safely, and with precision.');
INSERT INTO "skills" VALUES(19,'Running','you practice a lot - better speed than non- runners, as well as distance.');
INSERT INTO "skills" VALUES(20,'Sleight of Hand','manipulating small objects cleverly in your hands so as to conceal what you are actually doing with them.');
INSERT INTO "skills" VALUES(21,'Sport','each sport is a separate skill - hurling, lacrosse, etc.');
INSERT INTO "skills" VALUES(22,'Swimming','moving yourself in water without danger of drowning.');
INSERT INTO "skills" VALUES(23,'Team Acrobatics','working with others trained in this skill to perform acrobatic maneuvers such as stacking, vaulting, trapeze work, etc.');
INSERT INTO "skills" VALUES(24,'Throwing','throwing things accurately, but not specifically optimized to do damage. That is, it''s not a combat skill, though it could be used as one, with -1 to damage-dealing ability.');
INSERT INTO "skills" VALUES(25,'Alchemy','knowledge of and the ability to create elixirs and talismans of magical power. See Magic. [Default=None]');
INSERT INTO "skills" VALUES(27,'Animal Handling','managing animals in many situations.');
INSERT INTO "skills" VALUES(28,'Animal Training','training animals for specific tasks.');
INSERT INTO "skills" VALUES(29,'Arcane Lore','knowledge of occult things - otherworldly stories, legends, etc.');
INSERT INTO "skills" VALUES(30,'Area Knowledge','knowledge of a given area. The larger the area, the more shallow the knowledge.');
INSERT INTO "skills" VALUES(31,'Armorer','making, altering, and repairing armor. [Default=Terrible]');
INSERT INTO "skills" VALUES(32,'Artist','creating aesthetically pleasing art in a given medium. Each medium is a separate skill.');
INSERT INTO "skills" VALUES(33,'Astrology','this is either simple astronomy or an actual potent forecasting and divination tool - ask the GM.');
INSERT INTO "skills" VALUES(34,'Barroom Savvy','like Urban Survival, but very specific to barrooms.');
INSERT INTO "skills" VALUES(36,'Barter/Haggle','raising or reducing prices, depending on whether you''re selling or buying. Opposed by the other person''s Barter/Haggle skill.');
INSERT INTO "skills" VALUES(37,'Basketry','making baskets and other woven products from bark, grasses, and other plant materials. Includes a knowledge of materials, market prices, etc.');
INSERT INTO "skills" VALUES(38,'Bluff','misleading people into thinking you will perform an action you have no intention of performing. Opposed by Reasoning.');
INSERT INTO "skills" VALUES(39,'Bookkeeping','knowledge of accounting practices - requires Literacy and some math ability.');
INSERT INTO "skills" VALUES(40,'Botany','broad knowledge of plants - their habitats, growing needs, uses, dangers, etc. See Herb Lore, Farming, Basketry, Poisons, etc., for more specific skills.');
INSERT INTO "skills" VALUES(41,'Bow','using and caring for a bow and arrows, either longbow or short bow. [Default=Terrible]');
INSERT INTO "skills" VALUES(42,'Bowyer/Fletcher','making bows and arrows, including harvesting the appropriate material. [Default=Terrible]');
INSERT INTO "skills" VALUES(43,'Brawling','fighting without weapons.');
INSERT INTO "skills" VALUES(44,'Camaraderie','being entertaining in social settings, such as at a bar, at a party, around a campfire, etc., which can gain someone''s confidence and approval.');
INSERT INTO "skills" VALUES(45,'Camouflage','blending in with your surroundings so you don''t stand out. Primarily used in natural settings - use Disguise in urban settings. (However, a case could be made for using Camouflage skill to hide in an alley, for example.)');
INSERT INTO "skills" VALUES(46,'Camping','similar to Survival, but requires some tools, such as blankets, pots, an axe, a tent, etc. In return, it allows greater comfort and quality of life in the wild.');
INSERT INTO "skills" VALUES(47,'Carpentry','working with wood, to make anything from houses to furniture to cabinets.');
INSERT INTO "skills" VALUES(48,'Club/Mace','using a club or mace as a combat weapon.');
INSERT INTO "skills" VALUES(49,'Con','making people believe in some plan or product you are pushing.');
INSERT INTO "skills" VALUES(50,'Cooking','preparing tasty and nourishing food.');
INSERT INTO "skills" VALUES(51,'Counseling','comforting the afflicted, restoring good emotional health, helping people through grief, etc.');
INSERT INTO "skills" VALUES(52,'Courtesan','professional pleasure giving.');
INSERT INTO "skills" VALUES(53,'Crossbow','using a crossbow effectively in combat. [Default=Mediocre]');
INSERT INTO "skills" VALUES(54,'Dancing','dancing aesthetically. See Performing.');
INSERT INTO "skills" VALUES(55,'Detect Lies','telling when someone is lying. Opposed by Lies/Pretense.');
INSERT INTO "skills" VALUES(56,'Detect Traps','determining if a given area has a trap of some sort set, and what type.');
INSERT INTO "skills" VALUES(57,'Disarm Traps','deactivating a trap without harm. This may or may not cause noise, however ...');
INSERT INTO "skills" VALUES(58,'Disguise','passing for someone else under visual inspection. There is a penalty for serious inspection, of course. Opposed by Reasoning, though no roll is needed if the observer has no reason to be suspicious.');
INSERT INTO "skills" VALUES(59,'Engineer','designing and making tools, structures, sewer systems, etc.');
INSERT INTO "skills" VALUES(60,'Etiquette','knowledge of good manners in any society, and the ability to carry them out. Not as specific as Savoir-Faire, but gives a broader base for knowledge.');
INSERT INTO "skills" VALUES(61,'Evaluate Goods','a general skill to assess the value of something. It won''t be as accurate as a specific Professional skill (for example, a Potter will be a better judge of Pottery than someone with this skill, but as a broad skill allows a good general knowledge.');
INSERT INTO "skills" VALUES(62,'Falconry','training and controlling a raptor for sport and hunting.');
INSERT INTO "skills" VALUES(63,'Farming','raising crops and/or livestock, and everything associated with that: soil preparation, planting, weeding, tending, harvest, drying, storage, markets, etc.');
INSERT INTO "skills" VALUES(64,'Fast-draw','readying a weapon for combat use effectively instantly. A different skill for each weapon, and some weapons cannot be fast-drawn.');
INSERT INTO "skills" VALUES(65,'Fast-talk','convincing someone of something, which, upon reflection, they may realize isn''t true. Fast-talk doesn''t create lasting belief - see the Con skill for that. Opposed by Reasoning.');
INSERT INTO "skills" VALUES(66,'Find Hidden','locating concealed doors, compartments, catches, etc.');
INSERT INTO "skills" VALUES(67,'First aid','administering emergency medical treatment knowledgeably.');
INSERT INTO "skills" VALUES(68,'Fishing','catching fish for food, sale, barter, or sport.');
INSERT INTO "skills" VALUES(69,'Flail','using a flail as a weapon.');
INSERT INTO "skills" VALUES(70,'Flatter','making people like you by complimenting them to the point they begin to trust your judgement. Opposed by Willpower.');
INSERT INTO "skills" VALUES(71,'Flirt/Vamp','arousing sexual interest in an appropriate subject, for whatever reason. Opposed by Willpower.');
INSERT INTO "skills" VALUES(72,'Forgery','making fake documents and/or signatures that look authentic.');
INSERT INTO "skills" VALUES(73,'Gambling','gaming for money. Note that some gambling includes games of skill, and others games of chance - this skill helps largely with the former, and knowledge of the latter, including a good estimate of the odds. Also the ability to cheat at games, and spot cheaters.');
INSERT INTO "skills" VALUES(74,'Geography','broader than Area Knowledge, Geography is the knowledge of general topography, terrain nature, biomes, etc.');
INSERT INTO "skills" VALUES(75,'Heraldry/Court Rituals','knowledge of signs, symbols, and devices used to denote rank and family of the nobility. Also knowledge of court rituals, such as how many trumpet calls to announce a king as opposed to a duke, etc.');
INSERT INTO "skills" VALUES(76,'Herb Lore','knowledge of, preparation of, dosage of, and dangers of using herbs as medicinal agents. While it may tell you which herbs to avoid, this skill does not go into specific poisons - see Poisons for that skill. See Botany for a broader knowledge of plants.');
INSERT INTO "skills" VALUES(78,'Hide Traces','hiding any traces that people or animals used an area. This includes hiding tracks as well as camping areas.');
INSERT INTO "skills" VALUES(79,'History','knowledge of historical figures and events. This can be a broad and shallow skill, such as World History, or a narrower and deeper skill, such as history of a specific state.');
INSERT INTO "skills" VALUES(80,'Hunting','hunting and killing animals for food, hides, sport, or whatever.');
INSERT INTO "skills" VALUES(81,'Infiltrate','slipping into a guarded camp, either by pretending to have a right to be there or simply by avoiding all contact.');
INSERT INTO "skills" VALUES(82,'Inn Keeping','the knowledge of running a hotel or inn: includes kitchen, bar-keeping, maid service, stable, etc.');
INSERT INTO "skills" VALUES(83,'Interrogate','extracting information from an unwilling subject. There are two basic types of interrogators: those who get their subjects to trust them, and those who psychologically abuse them. Chose one type. Opposed by Willpower.');
INSERT INTO "skills" VALUES(84,'Intimidate','psychologically brow beating someone else into doing your will. Does not involve any physical component. Opposed by Willpower.');
INSERT INTO "skills" VALUES(85,'Jeweler','making and evaluating jewelry. Includes assessment of gems, gold, silver, etc.');
INSERT INTO "skills" VALUES(86,'Knife','using a knife in combat, but not necessarily to throw it.');
INSERT INTO "skills" VALUES(87,'Knife Throwing','throwing a knife accurately and with force.');
INSERT INTO "skills" VALUES(88,'Lance','using a lance (a type of hand-held spear used from horseback). Does not include the Riding skill.');
INSERT INTO "skills" VALUES(89,'Language','speaking and understanding a language. Every character knows their native language well at no cost - take this skill to learn foreign languages. Each language learned is a separate skill, though some similar languages may not require separate skills in order to make onesself understood (e.g. Terran Swedish and Danish). [Default=None]');
INSERT INTO "skills" VALUES(90,'Leatherwork','working with leather - includes tanning, preparation, tooling, sewing, etc.');
INSERT INTO "skills" VALUES(91,'Legal Process','knowledge of legal matters. [Default=Terrible]');
INSERT INTO "skills" VALUES(92,'Legends/Stories','knowledge of legends and stories, either as a source for entertainment, wisdom, or clues to treasure hunting, etc.');
INSERT INTO "skills" VALUES(93,'Lie/Pretense','dissembling your true intentions, origins, or role from others. Opposed by Detect Lies.');
INSERT INTO "skills" VALUES(94,'Lip reading','seeing what people are saying by watching their lips move.');
INSERT INTO "skills" VALUES(95,'Literacy','reading and writing. Each language is a different skill.');
INSERT INTO "skills" VALUES(97,'Map Sketching','creating reasonably accurate and readable maps from observation.');
INSERT INTO "skills" VALUES(98,'Masonry','working with stone.');
INSERT INTO "skills" VALUES(99,'Medicine','diagnosing and treating injuries and diseases in humans and other sentient beings.');
INSERT INTO "skills" VALUES(100,'Merchant','broad knowledge of what it takes to be in the business of selling or trading, either retail or wholesale.');
INSERT INTO "skills" VALUES(101,'Mimic Animal Noises','making a noise which sounds like a specific animal.');
INSERT INTO "skills" VALUES(102,'Musician','mastery of an instrument (which may be voice). Each instrument is a different skill. See Performing.');
INSERT INTO "skills" VALUES(103,'Navigation','finding your way based on the stars, position of the sun, map-reading, etc.');
INSERT INTO "skills" VALUES(104,'Observation','trained ability to notice and remember things - conscious application of Perception and memory. The player''s notes are the character''s memory.');
INSERT INTO "skills" VALUES(105,'One-handed Axe','using small axes as combat weapons.');
INSERT INTO "skills" VALUES(106,'One-handed Sword','using any sword designed to be used with one hand.');
INSERT INTO "skills" VALUES(107,'Oratory','keeping the focus of a group of people through speaking, and attempting to sway them to your point of view. Opposed by group''s average Reasoning-1.');
INSERT INTO "skills" VALUES(108,'Parley/Negotiate','reaching a compromise solution.');
INSERT INTO "skills" VALUES(109,'Performing','stage presence - actively entertaining people. You''ll need another skill to actually entertain with, such as Juggler, Storyteller, Musician, etc. A musician without the Performing skill may be skilled at producing music, but lacks "audience connection" and won''t be as popular as a musician with good Performing skill.');
INSERT INTO "skills" VALUES(110,'Persuade','convincing an individual of your point of view. Opposed by Reasoning.');
INSERT INTO "skills" VALUES(111,'Pick Locks','opening locks without the correct key. Penalty of -1 with improvised lockpicks. Difficult locks may have an additional penalty.');
INSERT INTO "skills" VALUES(112,'Pick Pockets','removing items from an individual''s pockets, belt, purse, etc., without them noticing it. Opposed by Perception. [Default=Terrible]');
INSERT INTO "skills" VALUES(113,'Pike','using a very long hand-held spear as a weapon - most useful in formations, especially against cavalry.');
INSERT INTO "skills" VALUES(114,'Poisons','knowledge, use, preparation, and dosage of various poisons.');
INSERT INTO "skills" VALUES(115,'Politics','knowledge of the political situation in a given area. May be for a broad area, such the entire known world, or a more focused area, such as Europe or a given city. In the latter case, the knowledge is more detailed.');
INSERT INTO "skills" VALUES(116,'Pottery','making pots, plates, bowls, etc., from clay. Includes the ability to assess the value of other potters'' work, knowledge of good clay sources, etc.');
INSERT INTO "skills" VALUES(117,'Read Opponent','roughly estimating a given opponent''s skill level in combat. An exceptionally good result may even reveal a particular combat "style," if appropriate for the setting.');
INSERT INTO "skills" VALUES(118,'Repartee','delivering witty sayings, usually double entendres, which cannot be construed as libelous but carry hidden insults or stings.');
INSERT INTO "skills" VALUES(119,'Salesmanship','selling someone something. Opposed by Willpower.');
INSERT INTO "skills" VALUES(120,'Savoir-Faire','functioning smoothly, without social blunders, in any upper or middle class setting.');
INSERT INTO "skills" VALUES(121,'Seamanship','assisting in any task on a large sailing vessel.');
INSERT INTO "skills" VALUES(122,'Shady Contacts','knowledge of the underworld, or, in a strange city, at least general underworld habits and likeliest places to contact fences, etc., without offending them.');
INSERT INTO "skills" VALUES(123,'Shield','using a shield or buckler in combat, both on offense and defense. [Default=Mediocre]');
INSERT INTO "skills" VALUES(124,'Shiphandling','directing seamen to correctly handle a large sailing ship. Includes piloting and navigation skills. [Default=Terrible]');
INSERT INTO "skills" VALUES(125,'Shopkeeping','running a shop of some sort - knowledge of basic bookkeeping, sources of materials, rotation of stock, general prices, sales techniques, etc.');
INSERT INTO "skills" VALUES(126,'Sling','using a sling in combat. [Default=Terrible]');
INSERT INTO "skills" VALUES(127,'Smithy','working metal into tools, weapons, ornaments, etc. [Default=Terrible]');
INSERT INTO "skills" VALUES(128,'Spear','using a spear in combat, but not including throwing it accurately or powerfully.');
INSERT INTO "skills" VALUES(129,'Spear Throwing','throwing a spear powerfully and accurately.');
INSERT INTO "skills" VALUES(130,'Staff','using a staff as a weapon.');
INSERT INTO "skills" VALUES(131,'Storytelling','entertaining by recounting stories, either from your past or from other sources. Storytelling without the Performing skill is more likely to be successful in a bar or other personal setting than in a professional setting.');
INSERT INTO "skills" VALUES(132,'Streetwise','Savoir-Faire for the lower classes.');
INSERT INTO "skills" VALUES(133,'Survival','surviving in the wilds (per major terrain type, e.g. woodlands, desert, suburbia). Includes basic fire making, food procurement, and shelter construction. Won''t be fancy, but you''ll be alive.');
INSERT INTO "skills" VALUES(134,'Tactics','knowledge of the best way to arrange a group of warriors so as to take best advantage of the situation, terrain, their skills, etc. Also reading an opposing group''s tactical sophistication level.');
INSERT INTO "skills" VALUES(135,'Tailing','following someone without their noticing. Opposed by Perception.');
INSERT INTO "skills" VALUES(136,'Tailor','turning cloth into clothes, as well as mending clothing. Can also make other items out of cloth, such as tents.');
INSERT INTO "skills" VALUES(137,'Teaching','imparting knowledge or skills to others.');
INSERT INTO "skills" VALUES(138,'Teamster','handling an animal or team of animals pulling a wagon, carriage, coach, etc.');
INSERT INTO "skills" VALUES(139,'Thaumatology','the knowledge of magic spells, results, abilities, etc. Does not require any Magical Ability. [Default=None]');
INSERT INTO "skills" VALUES(141,'Theater','the skills and knowledge associated with the theater: acting, directing, management of props, sets, the house, the stage, etc. Not the same as pretending to be someone else offstage - see Lie/Pretense for that skill.');
INSERT INTO "skills" VALUES(142,'Theology/Myths/Rituals','knowledge of a specific religion''s beliefs, dogma, and rituals. It may also be Comparative Theology, in which case the knowledge is broader - covers more than one religion - but shallower.');
INSERT INTO "skills" VALUES(143,'Tracking','following animals or sentient beings in terrain where they might leave traces. Of limited use in urban areas, it is more a nature skill.');
INSERT INTO "skills" VALUES(144,'Trail Blazing','finding an optimum route through wilderness, and marking your trail, either obviously or subtly.');
INSERT INTO "skills" VALUES(145,'Two-handed Axe','using any two-handed axe designed as a weapon.');
INSERT INTO "skills" VALUES(146,'Two-handed Sword','using any two-handed sword as a weapon.');
INSERT INTO "skills" VALUES(147,'Urban Survival','the skill of the urban poor: where to find free or cheap food, shelter and clothing; what parts of the city to avoid, who not to offend, etc.');
INSERT INTO "skills" VALUES(148,'Ventriloquism','"throwing your voice" so as to make it sound as if it comes from somewhere else. Also disguising your voice.');
INSERT INTO "skills" VALUES(149,'Veterinarian','diagnosing and treating animal injuries and diseases.');
INSERT INTO "skills" VALUES(150,'Weather Sense','predicting the weather for the near future.');
INSERT INTO "skills" VALUES(151,'Weaving','spinning yarn from wool or plants, then making cloth from yarn.');
INSERT INTO "skills" VALUES(152,'Woods Lore','knowledge of woodland animals, plants, cycles, etc.');
INSERT INTO "skills" VALUES(153,'Zoology','knowledge of animal behavior, habits, diets, capabilities, etc.');
INSERT INTO "skills" VALUES(154,'Computer operation','General usage of current computer technologies. [Default=None]');
INSERT INTO "skills" VALUES(155,'Computer programming','Ability to tell computers what to do (assumes familiarity with the given computer type, proper tools available, etc.). [Default=None]');
INSERT INTO "skills" VALUES(156,'College: Breaking','Allows working of magics from the Breaking College.');
INSERT INTO "skills" VALUES(157,'College: Communication','Allows working of magics from the Communication College.');
INSERT INTO "skills" VALUES(158,'College: Control','Allows working of magics from the Control College.');
INSERT INTO "skills" VALUES(159,'College: Creation','Allows working of magics from the Creation College.');
INSERT INTO "skills" VALUES(160,'College: Enchantement','Allows working of magics from the Enchantement College.');
INSERT INTO "skills" VALUES(161,'College: Enhancement','Allows working of magics from the Enhancement College.');
INSERT INTO "skills" VALUES(162,'College: Healing','Allows working of magics from the Healing College.');
INSERT INTO "skills" VALUES(163,'College: Knowledge','Allows working of magics from the Knowledge College.');
INSERT INTO "skills" VALUES(164,'College: Movement','Allows working of magics from the Movement College.');
INSERT INTO "skills" VALUES(165,'College: Protection','Allows working of magics from the Protection College.');
INSERT INTO "skills" VALUES(166,'College: Transformation','Allows working of magics from the Transformation College.');
INSERT INTO "skills" VALUES(167,'College: Transmutation','Allows working of magics from the Transmutation College.');
INSERT INTO "skills" VALUES(168,'Realm: Air','Allows working of magics from the Air Realm.');
INSERT INTO "skills" VALUES(169,'Realm: Animal','Allows working of magics from the Animal Realm.');
INSERT INTO "skills" VALUES(170,'Realm: Body','Allows working of magics from the Body Realm.');
INSERT INTO "skills" VALUES(171,'Realm: Earth','Allows working of magics from the Earth Realm.');
INSERT INTO "skills" VALUES(172,'Realm: Fire','Allows working of magics from the Fire Realm.');
INSERT INTO "skills" VALUES(173,'Realm: Illusion','Allows working of magics from the Illusion Realm.');
INSERT INTO "skills" VALUES(174,'Realm: Magic','Allows working of magics from the Magic Realm.');
INSERT INTO "skills" VALUES(175,'Realm: Mind','Allows working of magics from the Mind Realm.');
INSERT INTO "skills" VALUES(176,'Realm: Plant','Allows working of magics from the Plant Realm.');
INSERT INTO "skills" VALUES(177,'Realm: Spirit','Allows working of magics from the Spirit Realm.');
INSERT INTO "skills" VALUES(178,'Realm: Water','Allows working of magics from the Water Realm.');
INSERT INTO "skills" VALUES(179,'Realm: Weather','Allows working of magics from the Weather Realm.');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('skills',179);
CREATE TABLE skills_to_groups(skill_id INTEGER, group_id INTEGER);
INSERT INTO "skills_to_groups" VALUES(1,100);
INSERT INTO "skills_to_groups" VALUES(2,100);
INSERT INTO "skills_to_groups" VALUES(3,100);
INSERT INTO "skills_to_groups" VALUES(4,100);
INSERT INTO "skills_to_groups" VALUES(4,700);
INSERT INTO "skills_to_groups" VALUES(6,100);
INSERT INTO "skills_to_groups" VALUES(6,300);
INSERT INTO "skills_to_groups" VALUES(8,100);
INSERT INTO "skills_to_groups" VALUES(9,100);
INSERT INTO "skills_to_groups" VALUES(10,100);
INSERT INTO "skills_to_groups" VALUES(10,600);
INSERT INTO "skills_to_groups" VALUES(12,100);
INSERT INTO "skills_to_groups" VALUES(13,100);
INSERT INTO "skills_to_groups" VALUES(14,100);
INSERT INTO "skills_to_groups" VALUES(14,700);
INSERT INTO "skills_to_groups" VALUES(15,100);
INSERT INTO "skills_to_groups" VALUES(15,300);
INSERT INTO "skills_to_groups" VALUES(15,700);
INSERT INTO "skills_to_groups" VALUES(18,100);
INSERT INTO "skills_to_groups" VALUES(19,100);
INSERT INTO "skills_to_groups" VALUES(20,100);
INSERT INTO "skills_to_groups" VALUES(21,100);
INSERT INTO "skills_to_groups" VALUES(22,100);
INSERT INTO "skills_to_groups" VALUES(23,100);
INSERT INTO "skills_to_groups" VALUES(24,100);
INSERT INTO "skills_to_groups" VALUES(25,400);
INSERT INTO "skills_to_groups" VALUES(25,500);
INSERT INTO "skills_to_groups" VALUES(27,600);
INSERT INTO "skills_to_groups" VALUES(28,600);
INSERT INTO "skills_to_groups" VALUES(29,400);
INSERT INTO "skills_to_groups" VALUES(30,400);
INSERT INTO "skills_to_groups" VALUES(31,600);
INSERT INTO "skills_to_groups" VALUES(32,600);
INSERT INTO "skills_to_groups" VALUES(33,400);
INSERT INTO "skills_to_groups" VALUES(34,300);
INSERT INTO "skills_to_groups" VALUES(34,800);
INSERT INTO "skills_to_groups" VALUES(36,800);
INSERT INTO "skills_to_groups" VALUES(37,600);
INSERT INTO "skills_to_groups" VALUES(38,800);
INSERT INTO "skills_to_groups" VALUES(39,600);
INSERT INTO "skills_to_groups" VALUES(40,400);
INSERT INTO "skills_to_groups" VALUES(41,200);
INSERT INTO "skills_to_groups" VALUES(42,600);
INSERT INTO "skills_to_groups" VALUES(43,200);
INSERT INTO "skills_to_groups" VALUES(44,800);
INSERT INTO "skills_to_groups" VALUES(45,700);
INSERT INTO "skills_to_groups" VALUES(46,700);
INSERT INTO "skills_to_groups" VALUES(47,600);
INSERT INTO "skills_to_groups" VALUES(48,200);
INSERT INTO "skills_to_groups" VALUES(49,800);
INSERT INTO "skills_to_groups" VALUES(50,600);
INSERT INTO "skills_to_groups" VALUES(51,600);
INSERT INTO "skills_to_groups" VALUES(52,600);
INSERT INTO "skills_to_groups" VALUES(53,200);
INSERT INTO "skills_to_groups" VALUES(54,600);
INSERT INTO "skills_to_groups" VALUES(55,300);
INSERT INTO "skills_to_groups" VALUES(56,300);
INSERT INTO "skills_to_groups" VALUES(57,300);
INSERT INTO "skills_to_groups" VALUES(58,300);
INSERT INTO "skills_to_groups" VALUES(59,600);
INSERT INTO "skills_to_groups" VALUES(60,800);
INSERT INTO "skills_to_groups" VALUES(61,400);
INSERT INTO "skills_to_groups" VALUES(62,600);
INSERT INTO "skills_to_groups" VALUES(63,600);
INSERT INTO "skills_to_groups" VALUES(64,200);
INSERT INTO "skills_to_groups" VALUES(65,800);
INSERT INTO "skills_to_groups" VALUES(66,300);
INSERT INTO "skills_to_groups" VALUES(67,400);
INSERT INTO "skills_to_groups" VALUES(68,700);
INSERT INTO "skills_to_groups" VALUES(69,200);
INSERT INTO "skills_to_groups" VALUES(70,800);
INSERT INTO "skills_to_groups" VALUES(71,800);
INSERT INTO "skills_to_groups" VALUES(72,300);
INSERT INTO "skills_to_groups" VALUES(73,600);
INSERT INTO "skills_to_groups" VALUES(74,400);
INSERT INTO "skills_to_groups" VALUES(75,400);
INSERT INTO "skills_to_groups" VALUES(76,400);
INSERT INTO "skills_to_groups" VALUES(76,700);
INSERT INTO "skills_to_groups" VALUES(78,700);
INSERT INTO "skills_to_groups" VALUES(79,400);
INSERT INTO "skills_to_groups" VALUES(80,700);
INSERT INTO "skills_to_groups" VALUES(81,300);
INSERT INTO "skills_to_groups" VALUES(82,600);
INSERT INTO "skills_to_groups" VALUES(83,800);
INSERT INTO "skills_to_groups" VALUES(84,800);
INSERT INTO "skills_to_groups" VALUES(85,600);
INSERT INTO "skills_to_groups" VALUES(86,200);
INSERT INTO "skills_to_groups" VALUES(87,200);
INSERT INTO "skills_to_groups" VALUES(88,200);
INSERT INTO "skills_to_groups" VALUES(89,400);
INSERT INTO "skills_to_groups" VALUES(90,600);
INSERT INTO "skills_to_groups" VALUES(91,400);
INSERT INTO "skills_to_groups" VALUES(92,400);
INSERT INTO "skills_to_groups" VALUES(93,800);
INSERT INTO "skills_to_groups" VALUES(94,300);
INSERT INTO "skills_to_groups" VALUES(95,400);
INSERT INTO "skills_to_groups" VALUES(95,500);
INSERT INTO "skills_to_groups" VALUES(97,700);
INSERT INTO "skills_to_groups" VALUES(98,600);
INSERT INTO "skills_to_groups" VALUES(99,400);
INSERT INTO "skills_to_groups" VALUES(100,600);
INSERT INTO "skills_to_groups" VALUES(101,700);
INSERT INTO "skills_to_groups" VALUES(102,600);
INSERT INTO "skills_to_groups" VALUES(103,700);
INSERT INTO "skills_to_groups" VALUES(104,700);
INSERT INTO "skills_to_groups" VALUES(105,200);
INSERT INTO "skills_to_groups" VALUES(106,200);
INSERT INTO "skills_to_groups" VALUES(107,800);
INSERT INTO "skills_to_groups" VALUES(108,800);
INSERT INTO "skills_to_groups" VALUES(109,600);
INSERT INTO "skills_to_groups" VALUES(110,800);
INSERT INTO "skills_to_groups" VALUES(111,300);
INSERT INTO "skills_to_groups" VALUES(112,300);
INSERT INTO "skills_to_groups" VALUES(113,200);
INSERT INTO "skills_to_groups" VALUES(114,300);
INSERT INTO "skills_to_groups" VALUES(115,400);
INSERT INTO "skills_to_groups" VALUES(116,600);
INSERT INTO "skills_to_groups" VALUES(117,200);
INSERT INTO "skills_to_groups" VALUES(118,800);
INSERT INTO "skills_to_groups" VALUES(119,800);
INSERT INTO "skills_to_groups" VALUES(120,800);
INSERT INTO "skills_to_groups" VALUES(121,600);
INSERT INTO "skills_to_groups" VALUES(122,300);
INSERT INTO "skills_to_groups" VALUES(123,200);
INSERT INTO "skills_to_groups" VALUES(124,600);
INSERT INTO "skills_to_groups" VALUES(125,600);
INSERT INTO "skills_to_groups" VALUES(126,200);
INSERT INTO "skills_to_groups" VALUES(127,600);
INSERT INTO "skills_to_groups" VALUES(128,200);
INSERT INTO "skills_to_groups" VALUES(129,200);
INSERT INTO "skills_to_groups" VALUES(130,200);
INSERT INTO "skills_to_groups" VALUES(131,800);
INSERT INTO "skills_to_groups" VALUES(132,300);
INSERT INTO "skills_to_groups" VALUES(133,700);
INSERT INTO "skills_to_groups" VALUES(134,200);
INSERT INTO "skills_to_groups" VALUES(135,300);
INSERT INTO "skills_to_groups" VALUES(136,600);
INSERT INTO "skills_to_groups" VALUES(137,600);
INSERT INTO "skills_to_groups" VALUES(138,600);
INSERT INTO "skills_to_groups" VALUES(139,400);
INSERT INTO "skills_to_groups" VALUES(139,500);
INSERT INTO "skills_to_groups" VALUES(141,600);
INSERT INTO "skills_to_groups" VALUES(142,400);
INSERT INTO "skills_to_groups" VALUES(143,700);
INSERT INTO "skills_to_groups" VALUES(144,700);
INSERT INTO "skills_to_groups" VALUES(145,200);
INSERT INTO "skills_to_groups" VALUES(146,200);
INSERT INTO "skills_to_groups" VALUES(147,300);
INSERT INTO "skills_to_groups" VALUES(148,300);
INSERT INTO "skills_to_groups" VALUES(149,400);
INSERT INTO "skills_to_groups" VALUES(150,400);
INSERT INTO "skills_to_groups" VALUES(151,600);
INSERT INTO "skills_to_groups" VALUES(152,700);
INSERT INTO "skills_to_groups" VALUES(153,400);
INSERT INTO "skills_to_groups" VALUES(154,600);
INSERT INTO "skills_to_groups" VALUES(155,600);
INSERT INTO "skills_to_groups" VALUES(156,501);
INSERT INTO "skills_to_groups" VALUES(157,501);
INSERT INTO "skills_to_groups" VALUES(158,501);
INSERT INTO "skills_to_groups" VALUES(159,501);
INSERT INTO "skills_to_groups" VALUES(160,501);
INSERT INTO "skills_to_groups" VALUES(161,501);
INSERT INTO "skills_to_groups" VALUES(162,501);
INSERT INTO "skills_to_groups" VALUES(163,501);
INSERT INTO "skills_to_groups" VALUES(164,501);
INSERT INTO "skills_to_groups" VALUES(165,501);
INSERT INTO "skills_to_groups" VALUES(166,501);
INSERT INTO "skills_to_groups" VALUES(167,501);
INSERT INTO "skills_to_groups" VALUES(168,501);
INSERT INTO "skills_to_groups" VALUES(169,501);
INSERT INTO "skills_to_groups" VALUES(170,501);
INSERT INTO "skills_to_groups" VALUES(171,501);
INSERT INTO "skills_to_groups" VALUES(172,501);
INSERT INTO "skills_to_groups" VALUES(173,501);
INSERT INTO "skills_to_groups" VALUES(174,501);
INSERT INTO "skills_to_groups" VALUES(175,501);
INSERT INTO "skills_to_groups" VALUES(176,501);
INSERT INTO "skills_to_groups" VALUES(177,501);
INSERT INTO "skills_to_groups" VALUES(178,501);
INSERT INTO "skills_to_groups" VALUES(179,501);
CREATE TABLE gifts (
	id INTEGER PRIMARY KEY NOT NULL,
	name TEXT,
	description TEXT
);
INSERT INTO "gifts" VALUES(1,'Ambidexterity','you can use either hand equally well. Great for those times when you''re wounded in an arm ...');
INSERT INTO "gifts" VALUES(2,'Attractive','you''re good looking - either handsome, beautiful, pretty, or whatever level you wish. (Warning: the more attractive you are, the more power you have over susceptible people, true, but the more likely you are to be abducted, etc.)');
INSERT INTO "gifts" VALUES(3,'Beautiful speaking voice','+1 to NPC reactions. Also works for a singing voice if you take a Musical skill.');
INSERT INTO "gifts" VALUES(4,'Charisma','people tend to like you, believe you, and are willing to follow your lead.');
INSERT INTO "gifts" VALUES(5,'Common Sense','when you are about to do something incredibly stupid that will harm yourself or the party, the GM will warn you.');
INSERT INTO "gifts" VALUES(6,'Contacts *','you know some influential or knowledgeable people who can supply you with information.');
INSERT INTO "gifts" VALUES(7,'Danger Sense','the GM will make a Situational roll - on a Good or better result, you''ll be warned of some imminent danger.');
INSERT INTO "gifts" VALUES(8,'Divine Favor','the ability to cast Clerical Magic (if available in your campaign). [Costs two Gifts]');
INSERT INTO "gifts" VALUES(9,'Empathy with Animals','animals trust you and domesticated ones tend to obey you. Cruelty to animals nullifies this Gift');
INSERT INTO "gifts" VALUES(10,'Familiar','only available to characters with some for of magical Gift, like Magical Power or Magical Talent. You have a magical familiar, which may talk, aid you in spell-casting and other tasks. This is an NPC played by the GM');
INSERT INTO "gifts" VALUES(11,'Favors due *','some people owe you favors, which you may collect. Each favor you collect must be approved by the GM.');
INSERT INTO "gifts" VALUES(12,'Focused','you are at +1 to any lengthy task, but don''t notice things outside this task, such as that brigand about to skewer you ...');
INSERT INTO "gifts" VALUES(13,'Good Memory','you have an unusually good memory. The player may take notes during the game and act as if the character remembered them.');
INSERT INTO "gifts" VALUES(14,'Good Reputation *','you are well known as a hero, healer, leader, fighter for justice, etc.');
INSERT INTO "gifts" VALUES(15,'High Status','you are of the gentry or religious class - or nobility if you take this Gift twice.');
INSERT INTO "gifts" VALUES(16,'Innate Magic','you have an inborn talent for a specific magical ability');
INSERT INTO "gifts" VALUES(17,'Intuition','you have a feeling about what option to take when confronted with a choice. The GM will make a Situational roll in secret.');
INSERT INTO "gifts" VALUES(18,'Lucky','once per hour (real time), you may reroll a bad dice roll, and choose the better of the two rolls.');
INSERT INTO "gifts" VALUES(19,'Magic Resistance','you are resistant to direct magic: +3 to Willpower in any Opposed rolls versus magic.');
INSERT INTO "gifts" VALUES(20,'Magical Power','the ability to perform magical feats through the study of magic');
INSERT INTO "gifts" VALUES(21,'Never forgets a ____','fill in the blank with name, face, or whatever the GM will allow.');
INSERT INTO "gifts" VALUES(22,'Never Gets Lost','you always know which way is North, and can retrace your route with a little effort.');
INSERT INTO "gifts" VALUES(23,'Night Vision','you see well in dim light, but not in absolute darkness, of course.');
INSERT INTO "gifts" VALUES(24,'Pain Tolerance','ignore wound penalties at Hurt, and you are only at -1 at Very Hurt.');
INSERT INTO "gifts" VALUES(25,'Patron *','someone in power likes you. This can be simply a letter of recommendation, or it can be a favor granted.');
INSERT INTO "gifts" VALUES(26,'Perfect Timing','if someone says to open the gate in five minutes, you''ll do it within two seconds of that time. Also valuable in performing.');
INSERT INTO "gifts" VALUES(27,'Peripheral Vision','you can see further to the sides than most people - less easily attacked from the side-rear.');
INSERT INTO "gifts" VALUES(28,'Quick Reflexes','not easily surprised by any physical attack, and you adjust quickly to shifting footing.');
INSERT INTO "gifts" VALUES(29,'Rank *','you have the right to command others in an organized body of soldiers or police.');
INSERT INTO "gifts" VALUES(30,'Rapid Healing','you heal twice as fast from wounds - but not magically fast.');
INSERT INTO "gifts" VALUES(31,'Resistant to Poison','poison has only half effect on you.');
INSERT INTO "gifts" VALUES(32,'Tough Hide','subtract 1 from each amount of damage you take.');
INSERT INTO "gifts" VALUES(33,'Veteran','you''re experienced - add one level to each of three skills that are currently at Fair or Mediocre.');
INSERT INTO "gifts" VALUES(34,'Wealthy','you start with more money than the average starting character. This can be in cash and/or equipment');
CREATE TABLE faults (
	id INTEGER PRIMARY KEY NOT NULL,
	name TEXT,
	description TEXT
);
INSERT INTO "faults" VALUES(1,'Absent-Minded','your attention tends to wander if bored.');
INSERT INTO "faults" VALUES(2,'Annoying Voice','you sound terrible. This can take the form of a particularly high pitch, a hard-to-understand gruff sound, or a habit of under-enunciating');
INSERT INTO "faults" VALUES(3,'Appearance','your appearance is off-putting in some way, whether ugly or unkempt.');
INSERT INTO "faults" VALUES(4,'Bad Back','you are limited in what you can lift.');
INSERT INTO "faults" VALUES(5,'Bad Eyesight','you don''t see very well - pick one: poor distance or up-close vision');
INSERT INTO "faults" VALUES(6,'Berserker','in combat you go all-out, with no concern for your own life or limb, and even less concern for those around you');
INSERT INTO "faults" VALUES(7,'Bloodlust','you love blood. Those who know about this are likely to react negatively to you');
INSERT INTO "faults" VALUES(8,'Blunt and Tactless','you have no social skills in dealing with sensitive people');
INSERT INTO "faults" VALUES(9,'Clumsy','you tend to drop/spill/bump into/break things at inopportune moments');
INSERT INTO "faults" VALUES(10,'Code of Honor','your actions are constrained by your personal behavior code.');
INSERT INTO "faults" VALUES(11,'Color Blindness','you confuse lots of colors.');
INSERT INTO "faults" VALUES(12,'Combat Paralysis','you need a Good or better Health roll in order to act in a dangerous situation.');
INSERT INTO "faults" VALUES(13,'Compulsive       ','You are at -3 Willpower to avoid engaging in some particularly annoying, odious, or potentially behaviour. Some examples include');
INSERT INTO "faults" VALUES(14,'Compulsive Carousing','you are at -3 Willpower to resist a good time.');
INSERT INTO "faults" VALUES(15,'Compulsive Curiosity','you are at -3 Willpower to resist exploring something new or unusual');
INSERT INTO "faults" VALUES(16,'Compulsive Gambling','your are at -3 Willpower to resist a gambling game.');
INSERT INTO "faults" VALUES(17,'Compulsive Generosity','you are at -3 Willpower to resist giving things away to those perceived to be needier than you.');
INSERT INTO "faults" VALUES(18,'Compulsive Lying','you are at -3 Willpower to avoid lying just for fun');
INSERT INTO "faults" VALUES(19,'Coward','you take very good care of yourself');
INSERT INTO "faults" VALUES(20,'Delusions','the world doesn''t work the way you think it does, in some important way.');
INSERT INTO "faults" VALUES(21,'Dependent','you''re responsible for someone unable to care for themselves adequately.');
INSERT INTO "faults" VALUES(22,'Duty','you must perform active duty a certain amount of time.');
INSERT INTO "faults" VALUES(23,'Dwarfism','you are very short for your race.');
INSERT INTO "faults" VALUES(24,'Easily Distractible','did you say something');
INSERT INTO "faults" VALUES(25,'Easy to Read','you give away your thoughts and feelings to any who care to observe you.');
INSERT INTO "faults" VALUES(26,'Enemy','there is someone who wants to kill, imprison, or otherwise trouble you.');
INSERT INTO "faults" VALUES(27,'Fanatic Patriot','your country, right or wrong');
INSERT INTO "faults" VALUES(28,'Frightens Animals','you have an aura that animals find terrifying. People who have or work with animals may inherently mistrust you if their animals are unsettled by you');
INSERT INTO "faults" VALUES(29,'Garrulous','you won''t shut up');
INSERT INTO "faults" VALUES(30,'Getting old','and all that implies');
INSERT INTO "faults" VALUES(31,'Glutton','you''re hungry');
INSERT INTO "faults" VALUES(32,'Goes Berserk if Wounded','you''re a danger to your friends, even');
INSERT INTO "faults" VALUES(33,'Greedy','you want more');
INSERT INTO "faults" VALUES(34,'Grouchy','you''re usually irritated and try to spread the mood');
INSERT INTO "faults" VALUES(35,'Gullible','-3 to Reasoning to believe an unknown "fact.');
INSERT INTO "faults" VALUES(36,'Hard of Hearing','what');
INSERT INTO "faults" VALUES(37,'Honesty','you hate to break a law. See Truthfulness for not liking to lie');
INSERT INTO "faults" VALUES(38,'Humanitarian','you help the needy for no pay');
INSERT INTO "faults" VALUES(39,'Idealist','you''re not grounded in reality');
INSERT INTO "faults" VALUES(40,'Impulsive','you act before thinking');
INSERT INTO "faults" VALUES(41,'Intolerant','you hate a certain type of person');
INSERT INTO "faults" VALUES(42,'Jealous of Anyone Getting More Attention','you have to be the star');
INSERT INTO "faults" VALUES(43,'Lame','you limp, which can affect speed and agility');
INSERT INTO "faults" VALUES(44,'Lazy','you work hard at avoiding work');
INSERT INTO "faults" VALUES(45,'Lechery','you''re overly fond of the appropriate sex');
INSERT INTO "faults" VALUES(46,'Loyal to Companions','you won''t abandon, cheat, hide treasure from, etc., the party members. This one may be mandatory');
INSERT INTO "faults" VALUES(47,'Magic Susceptibility','you are at -3 to oppose hostile magic');
INSERT INTO "faults" VALUES(48,'Melancholy','life is so sad');
INSERT INTO "faults" VALUES(49,'Miserliness','you hate to let go of money and other valuables');
INSERT INTO "faults" VALUES(50,'Mute','you can''t speak');
INSERT INTO "faults" VALUES(51,'Night Blindness','you see poorly in dim light');
INSERT INTO "faults" VALUES(52,'Nosy','your neighbor''s business is yours');
INSERT INTO "faults" VALUES(53,'Obese','you waddle');
INSERT INTO "faults" VALUES(54,'Obsession','you must do it, or have it, or whatever');
INSERT INTO "faults" VALUES(55,'Offensive Habits','too many to list. Some of the other Faults listed actually fall under this category, such as Nosy, Grouchy, Garrulous, etc');
INSERT INTO "faults" VALUES(56,'Offensive Odor','you stink. Badly');
INSERT INTO "faults" VALUES(57,'One Eye','you lack depth vision and can be blindsided, literally');
INSERT INTO "faults" VALUES(58,'One Hand','it works overtime');
INSERT INTO "faults" VALUES(59,'Outlaw','you''re wanted by the law');
INSERT INTO "faults" VALUES(60,'Overconfident','you know you can''t fail');
INSERT INTO "faults" VALUES(61,'Owe favors','you owe someone favors, and they''ll ask you for them sometime');
INSERT INTO "faults" VALUES(62,'Pain Intolerant','you''re at -1 if Scratched, -2 if Hurt, and -3 if Very Hurt.');
INSERT INTO "faults" VALUES(63,'Phobias','there are lots of these - you''re at -3 Willpower to avoid acting out of control in certain situations: snakes, darkness, heights, cats, falling, crowds, spiders, open or closed spaces, magic, loud noises, etc.');
INSERT INTO "faults" VALUES(64,'Poor','you start with less equipment and cash, and if you don''t buy off this Fault, will always lose any you gain.');
INSERT INTO "faults" VALUES(65,'Practical Joker','you can''t resist. Somebody''s gonna hurt you someday.');
INSERT INTO "faults" VALUES(66,'Primitive','you''re from a more primitive society and have trouble getting a mental grasp around common technologies. Alternately, you shun technology on moral grounds and refuse to use any items above a certain technology level');
INSERT INTO "faults" VALUES(67,'Proud','many things are beneath your dignity.');
INSERT INTO "faults" VALUES(68,'Quick to take offense','you''re thin-skinned.');
INSERT INTO "faults" VALUES(69,'Quick-Tempered','you blow up when crossed.');
INSERT INTO "faults" VALUES(70,'Quixotic','you vigorously champion lost causes.');
INSERT INTO "faults" VALUES(71,'Reckless Bravery','you take no thought for your safety in dangerous situations.');
INSERT INTO "faults" VALUES(72,'Reputation','you''re well known as some sort of louse.');
INSERT INTO "faults" VALUES(73,'Secret','if it''s revealed, you''ll be embarrassed, arrested, or worse - maybe that warrant out for your arrest, or your second spouse?');
INSERT INTO "faults" VALUES(74,'Self-defense Pacifist','you''ll fight, but you''ll never start a fight - no preemptive strikes.');
INSERT INTO "faults" VALUES(75,'Shyness','you never want to talk to strangers.');
INSERT INTO "faults" VALUES(76,'Social Stigma','you''re obviously from some low-caste group.');
INSERT INTO "faults" VALUES(77,'Stubborn','you don''t easily admit you''re wrong. Has nothing to do with Willpower.');
INSERT INTO "faults" VALUES(78,'Susceptibility to Poison','you''re at -3 to Health in Opposed rolls for poison.');
INSERT INTO "faults" VALUES(79,'Trickster','you regularly have to take a risk to thwart some villain, even if just a petty one.');
INSERT INTO "faults" VALUES(80,'Truthfulness','you can''t tell a believable lie.');
INSERT INTO "faults" VALUES(81,'Unlucky','if something bad happens to someone in the party, it''s you.');
INSERT INTO "faults" VALUES(82,'Vain','you''re the best-looking and/or finest person in the world. Aren''t your companions lucky?');
INSERT INTO "faults" VALUES(83,'Vow','you''re committed to some action.');
INSERT INTO "faults" VALUES(84,'Worry Wart','you wring your hands a lot.');
INSERT INTO "faults" VALUES(85,'Xenophobia','you dislike and fear people different from the folks you grew up with.');
INSERT INTO "faults" VALUES(86,'Youth','you''re so young no one takes you seriously. Also, lose one level each from three skills - you just haven''t had time to develop everything that well yet. The GM may require that Young characters start with fewer skill points than normal PCs (or lose on level from each skill!), and have no skills higher than Fair.');
CREATE VIEW v_skills_full AS
SELECT skills.name || ' (' ||skill_groups.name||') - '||skills.description
FROM skills LEFT OUTER JOIN skill_groups, skills_to_groups
ON skills.id=skills_to_groups.skill_id
AND skill_groups.id=skills_to_groups.group_id
ORDER BY skills.name;
COMMIT;