-- This is the schema for BYOO (Build Your Own Ogre) apps. -- It requires a "recent" version of sqlite3 (probably something released -- in 2017 or later). PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; -- "Gear" is anything which can be attached to an Ogre other -- than its own treads (those are accounted for in each Ogre's -- base stats). CREATE TABLE gear ( id integer primary KEY autoincrement DEFAULT NULL, sortOrder float default 0.0, name text UNIQUE NOT NULL default '', shortName text UNIQUE default NULL, attack integer default 0, range integer default 0, defense integer default 0, ciscos tinyint(2) default 0, isOfficial integer default 0, notes text DEFAULT '', -- The following are hints for the layout of record forms -- and input fields. countPerRow integer default 15, -- number of items per row in a record form countGroupBy integer default 3, -- group items in sets of this many. -- countGroupBy 3 with countPerRow of 6 and a count of 12 "should" -- render as 2 rows: -- ooo ooo -- ooo ooo -- (Alternately, we should maybe interpret countPerRow to mean the number of -- groups per row?) countHintMax integer default 10 -- Max count for input field ); INSERT INTO gear VALUES(1,-20.0,'Main Batteries','MB',4,3,4,24,1,NULL,15,3,15); INSERT INTO gear VALUES(2,-19.0,'Secondary Batteries','SB',3,2,3,15,1,NULL,15,3,15); INSERT INTO gear VALUES(3,0.0,'Tertiary Batteries','TB',2,1,2,5,0,NULL,15,3,20); INSERT INTO gear VALUES(4,-15.499999999999999999,'Missiles, Internal','Msl-I',6,5,0,6,1,'Cannot be attacked separately.',10,4,40); INSERT INTO gear VALUES(5,-17.999999999999999999,'Missiles, External','Msl-E',6,5,3,12,1,NULL,10,4,20); INSERT INTO gear VALUES(6,-16.0,'Missile Racks','Msl-Rack',0,0,4,8,1,'Each one destroyed also destroys one Msl-I.',15,3,10); INSERT INTO gear VALUES(7,-10.0,'Anti-Personnel Guns','AP',1,1,1,2,1,'Usable against Infantry and D0 targets only',16,3,30); INSERT INTO gear VALUES(8,-1.0,'Tow Gear','TowGear',0,0,0,3,1,'Use per the rules in the Ogre Reinforcements Pack',15,3,1); INSERT INTO gear VALUES(100,1.1000000000000000888,'Rocket Salvo, Internal','RktS-I',3,4,0,3,0,'Fired just as internal missiles - requires a Rocket Salvo Rack',10,4,40); INSERT INTO gear VALUES(101,1.0,'Rocket Salvo, External','RktS-E',3,4,2,5,0,'Fired just as external missiles.',10,4,40); INSERT INTO gear VALUES(102,1.1999999999999999555,'Rocket Salvo Rack','RktS-Rack',0,0,3,5,0,'Fires RktS-I''s, each sold separately. Each one destroyed also destroys one RktS-I.',15,3,10); INSERT INTO gear VALUES(103,4.0,'Medium Howitzer','MedHWZ',6,6,5,65,0,'Optional Rule: move _or_ fire.',10,3,10); INSERT INTO gear VALUES(104,5.0,'Howitzer','HWZ',6,8,4,100,0,'Optional Rule: move _or_ fire.',10,3,3); INSERT INTO gear VALUES(105,6.0,'Long Tom','LTOM',4,12,4,120,0,'Optional Rule: move _or_ fire.',15,3,2); INSERT INTO gear VALUES(106,100.99999999999999999,'Cruise Missile, Internal','CMI',0,0,0,40,0,'Optional Rule: move _or_ fire.',15,3,4); INSERT INTO gear VALUES(107,100.0,'Cruise Missile Launcher','CML',0,0,6,60,0,NULL,15,3,2); INSERT INTO gear VALUES(109,110.0,'Engineering Arm','EA',0,0,4,5,0,NULL,15,3,4); INSERT INTO gear VALUES(110,200.0,'Suicide Bomb','HariKari',0,0,0,60,0,'Cannot be attacked separately. Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.',1,1,1); INSERT INTO gear VALUES(111,198.99999999999999999,'Cargo Bay','Cargo',0,0,3,4,0,'Holds up to four Size units of armor or four infantry squads. Destruction destroys cargo. Use normal riding rules except that infantry cannot attack from the bay.',15,4,2); INSERT INTO gear VALUES(112,198.0,'Infantry Bay','InfBay',0,0,4,3,0,'Holds three of any infantry, including Heavy Infantry or other large INF types. Inf destroyed if InfBay is destroyed. Use normal riding rules except that infantry cannot attack from the bay.',15,3,4); INSERT INTO gear VALUES(113,0.5,'Long-Range AP Guns','LRAP',1,2,1,3,0,'Usable against Infantry and D0 targets only',16,3,30); CREATE TABLE ogre( -- Ogre Ciscos cost: -- Cost := 2 * Treads -- Cost += (Cost of each Gear item) -- FinalCost := 5.357 * Cost / (10 - Ogre.MP) -- -- Cisco/SJG Conversions: -- Ciscos / 10 == Cisco Armor Unit Equivalence -- Ciscos * 0.6 = Approx SJG VP cost id integer primary KEY autoincrement DEFAULT NULL, lastUpdated text DEFAULT current_timestamp, name text UNIQUE NOT NULL COLLATE NOCASE, -- Reminder: nickname cannot be UNIQUE because it's normally -- empty. nickname text default NULL, isOfficial integer default 0, sizeClass integer default 7, mp integer default 0, tump integer default 0, ciscos integer default 0, ciscosFudge integer default 0, icon text default 'default.png', submitter text default NULL, notes text default NULL, UNIQUE (name) ); INSERT INTO ogre VALUES(1,'2009-08-04 20:44:25','Mark I',NULL,1,5,3,5,47.450000000000002843,0,'MarkI.png',NULL,NULL); INSERT INTO ogre VALUES(2,'2009-08-04 20:44:25','Mark II',NULL,1,6,3,10,96.430000000000006821,0,'MarkII.png',NULL,NULL); INSERT INTO ogre VALUES(3,'2009-08-04 20:44:25','Mark III',NULL,1,7,3,15,163.77000000000001022,0,'MarkIII.png',NULL,NULL); INSERT INTO ogre VALUES(4,'2009-08-04 20:44:25','Fencer',NULL,1,8,3,15,220.40000000000000569,0,'Fencer.png',NULL,NULL); INSERT INTO ogre VALUES(5,'2009-08-04 20:44:25','Mark IV',NULL,1,8,4,15,271.42000000000001591,0,'MarkIV.png',NULL,NULL); INSERT INTO ogre VALUES(6,'2009-08-04 20:44:25','Mark V',NULL,1,8,3,20,270.910000000000025,0,'MarkV.png',NULL,NULL); INSERT INTO ogre VALUES(7,'2009-08-04 20:44:25','Mark VI',NULL,1,9,3,25,367.33999999999997498,0,'MarkVI.png',NULL,NULL); INSERT INTO ogre VALUES(8,'2009-08-04 20:44:25','Mark IIIb',NULL,1,7,3,16,205.09999999999999431,0,'MarkIIIb.png',NULL,NULL); INSERT INTO ogre VALUES(9,'2009-08-04 20:44:25','Doppelsoldner',NULL,1,9,3,20,348.97000000000002728,0,'Doppelsoldner.png',NULL,NULL); INSERT INTO ogre VALUES(10,'2009-08-04 20:44:25','Ninja',NULL,1,7,4,10,183.91999999999998749,0,'Ninja.png',NULL,'All attackers get -1 to-hit except Infantry in an overrun.'); INSERT INTO ogre VALUES(11,'2010-01-08 14:29:25','Mark VI (2008)',NULL,1,9,3,24,352.80000000000001137,NULL,'MarkVI.png',NULL,replace('The Ogre Miniatures Update, released in 2008, drastically re-spec''d the Mark VI.\n\nThe Update is available for free download at:\n\nhttp://e23.sjgames.com/item.html?id=SJG37-5002','\n',char(10))); INSERT INTO ogre VALUES(20,'2009-08-05 00:47:09','Goliath',NULL,1,7,4,10,125,NULL,'default-nolabel.png','Stephan','Explodes as per chart at http://www.sjgames.com/ogre/articles/goliath.html.'); INSERT INTO ogre VALUES(100,'2009-08-04 20:44:25','Flower',NULL,0,8,4,15,226.78000000000000113,NULL,'Flower.png','Stephan Beal','A refitted Mark IV built for quick strikes against smaller targets or protecting higher-priority Ogres from would-be attackers.'); INSERT INTO ogre VALUES(101,'2009-08-04 20:44:25','Der Hammer',NULL,0,7,2,15,243.06999999999999318,0,'default.png','Stephan',NULL); INSERT INTO ogre VALUES(106,'2009-08-04 20:44:25','Charlie Bravo',NULL,0,7,4,8,133.93000000000000682,0,'default.png','Jon Glenn','This lightly armed Ogre is designed as a sentient Combat Engineering machine. It was a Combine design, but the Paneuros had a similar vehicle called the BPO. (Bekampfen Pioneer Ogre)'); INSERT INTO ogre VALUES(107,'2009-08-04 20:44:25','iFencer',NULL,0,8,3,16,238.77000000000001022,0,'Fencer.png','Imre A. Szabo','An improved Fencer design.'); INSERT INTO ogre VALUES(108,'2009-08-04 20:44:25','Free Love',NULL,0,8,2,25,294.62999999999999545,0,'FreeLove.png','Stephan',NULL); INSERT INTO ogre VALUES(109,'2009-08-04 20:44:25','Cruiser',NULL,0,7,3,12,238.77000000000001022,0,'default.png','Stephan',NULL); INSERT INTO ogre VALUES(110,'2009-08-04 20:44:25','Minuteman',NULL,0,8,4,10,137.5,0,'default.png','Stephan','Infantry support unit, built to get men into The Thick quickly and safely.'); INSERT INTO ogre VALUES(111,'2009-08-04 20:44:25','Model II-T','The Minivan',0,6,3,10,80.359999999999999435,0,'MarkII.png','Stephan',NULL); INSERT INTO ogre VALUES(112,'2009-08-04 20:44:25','Willie Winkie','Winkie',0,8,4,10,508.92000000000001593,0,'Doppelsoldner.png','Dilletante',NULL); INSERT INTO ogre VALUES(113,'2009-08-04 20:44:25','Marco',NULL,0,7,3,12,116.31999999999999318,0,'Flower-nolabel.png','Stephan','A slightly-lighter, reworked Mark III.'); INSERT INTO ogre VALUES(114,'2009-08-04 20:44:25','Katana','Katana',0,7,4,8,150.88999999999998635,0,'default.png','Francisco Cestero','The Katanas and the slightly larger Samurai were the most common OGRE designs in Nihon''s arsenal. The Katana''s comprised the striking arm with their expendable missiles while the Samurai was designed for more staying power. Both the Katana and Samurai''s were designed to take on the Combine Mark-III, the Samurai slightly more powerful, the Katana slightly less. Both had exceptional speed which made the Nihon Empire unique in having the only high speed line units of the war.'); INSERT INTO ogre VALUES(116,'2009-08-04 20:44:25','Lamer',NULL,0,8,3,18,221.93000000000000682,0,'MarkV-nolabel.png','Stephan','Close-up slammer-hammer. Got problems with infantry walls? Let Lamer spell an end to them for you.'); INSERT INTO ogre VALUES(117,'2009-08-04 20:44:25','Mark IIIb - Cisco',NULL,0,7,3,12,186.72999999999998977,0,'MarkIIIb.png','Cisco',NULL); INSERT INTO ogre VALUES(118,'2009-08-04 20:44:25','Flower-S',NULL,0,8,3,15,182.90000000000000568,NULL,'Flower.png','Stephan Beal','A Support version of the Flower. More guns at the cost of speed. The Flower-S excels at protecting other Ogres from close-up attacks. Used in conjunction with a missile-based Ogre, the FLower can make a great defense partner.'); INSERT INTO ogre VALUES(121,'2009-08-04 20:44:25','Mark V-m',NULL,0,8,3,20,303.05000000000001136,0,'MarkV-nolabel.png','George Leritte','This is a missile rack armed Mark V.'); INSERT INTO ogre VALUES(122,'2009-08-04 20:44:25','Mark III-m',NULL,0,7,3,15,174.49000000000000909,0,'MarkIII-nolabel.png','George Leritte','This is a missile rack armed Mark III.'); INSERT INTO ogre VALUES(126,'2009-08-04 20:44:25','Wolf',NULL,0,8,3,12,287.75,0,'default.png','Herb Diehr',NULL); INSERT INTO ogre VALUES(127,'2009-08-04 20:44:25','Trooper',NULL,0,5,4,5,73.209999999999993748,0,'MarkI-nolabel.png','Doug Pappert','A slightly beefed up MK 1.'); INSERT INTO ogre VALUES(130,'2009-08-04 20:44:25','Blackeye','Blackie',0,6,3,10,93.359999999999999428,NULL,'MarkII-nolabel.png','Stephan Beal',NULL); INSERT INTO ogre VALUES(131,'2009-08-04 20:44:25','Blossom','Spitball',0,6,3,10,108.6700000000000017,NULL,'MarkII-nolabel.png','Stephan Beal','It''s to go into an area and fire a one- or two-shot volley at mid-range targets, or to snipe if it can get away with it.'); INSERT INTO ogre VALUES(132,'2009-08-04 20:44:25','Buggy',NULL,0,6,4,8,112.5,NULL,'MarkII-nolabel.png','Stephan Beal','A faster model of the Blackeye.'); INSERT INTO ogre VALUES(133,'2009-08-04 20:44:25','Buggy II',NULL,0,8,4,12,203.56999999999999318,NULL,'MarkIV-nolabel.png','Stephan Beal',NULL); INSERT INTO ogre VALUES(134,'2009-08-04 20:44:25','Mark VII (Variant)','Behemoth',0,9,2,1,369.62999999999999545,NULL,'default.png','Scott "Clu" Nelson',NULL); INSERT INTO ogre VALUES(136,'2009-08-04 20:44:25','Bombard','Mad Bomber',0,7,4,20,383.92000000000001591,NULL,'MarkIII.png','Scott "Clu" Nelson','A fast Ogre that''s hard to stop. It can push into enemy territory and Nuc its target. Carries a backup missile, just in case the first one is shot down.'); INSERT INTO ogre VALUES(137,'2009-08-04 20:44:25','Cyclops','Red-Eye',0,7,4,10,408.92000000000001593,0,'default.png','Scott Clu Nelson',NULL); INSERT INTO ogre VALUES(138,'2009-08-04 20:44:25','Mk VI Megascout','Dasher',0,9,6,10,482.12999999999999545,0,'MarkVI-nolabel.png','Drew Dreasler',NULL); INSERT INTO ogre VALUES(140,'2009-08-04 20:44:25','Mk VII WarWagon','WarOgre',0,7,3,25,378.05000000000001136,0,'default.png','Bill J',NULL); INSERT INTO ogre VALUES(141,'2009-08-04 20:44:25','WarWagon Mk2','WW2',0,9,3,30,497.4399999999999977,0,'default.png',NULL,NULL); INSERT INTO ogre VALUES(142,'2009-08-04 20:44:25','Fence Jumper','Jumper',0,8,6,5,423.19999999999998864,0,'Fencer-nolabel.png','Ross Winn','This unit is used primarily as a support unit to other ogres. Especially usefuk in urban settings.'); INSERT INTO ogre VALUES(144,'2009-08-04 20:44:25','Mark1r/Vandal','Slasher',0,5,4,4,66.069999999999993178,0,'default.png','Christian Okane','A modified mark 1 intended for raiding behind enemy lines. Chewing up supply and repair units in hit and run raids.'); INSERT INTO ogre VALUES(145,'2009-08-04 20:44:25','Mark Ib',NULL,0,5,3,5,55.869999999999997442,0,'MarkI.png','Michael Powers','An attempt at up-gunning the Mark One; added a smaller turret with a secondary-class weapon. This version still proved too fragile for the cost, though the additional weapon proved useful enough to warrant the multi-gun design used in later Ogres.'); INSERT INTO ogre VALUES(147,'2009-08-04 20:44:25','Mark If',NULL,0,5,3,5,46.679999999999999714,0,'MarkI.png','Michael Powers','An anti-personnel variant of the Mark One, used mostly by Internal Security for riot-control work. These Ogres were withdrawn from duty after several units became confused and began identifying _all_ humans as potential targets.'); INSERT INTO ogre VALUES(148,'2009-08-04 20:44:25','Mark Ic',NULL,0,5,3,5,55.10000000000000142,0,'MarkI.png','Michael Powers','Another attempt at creating a Mark One that was a significant force on its own, this version replaced the main cannon with several launchers for tactical missiles. While this gave it more versatility and greater range, it was still not durable enough to complete a mission without support.'); INSERT INTO ogre VALUES(149,'2009-08-04 20:44:25','Mark IIc',NULL,0,6,3,10,91.829999999999998294,0,'MarkII.png','Michael Powers','This version replaced the secondary cannon with a pair of external missiles as a feasibility study. It proved effective, and the missiles were included in the next generation of Ogres.'); INSERT INTO ogre VALUES(150,'2009-08-04 20:44:25','Mark V-IYF','Inyoface',0,8,3,20,217.34000000000000341,0,'MarkV-nolabel.png','Stephan Beal','This Mark V variant is intentded to be covered by longer-ranged units, or to provide cover for them.'); INSERT INTO ogre VALUES(151,'2009-08-04 20:44:25','Oni Mk. II','Long Tom',0,6,6,6,241.06000000000000226,0,'Spartan-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(152,'2009-08-04 20:44:25','Fiver',NULL,0,8,3,20,241.06999999999999318,0,'MarkV-nolabel.png','Stephan Beal','Refitted Mark V, with more blasting power, and fewer guns.'); INSERT INTO ogre VALUES(153,'2011-03-13 11:11:40','Journeyman PC','Jammy',0,8,4,10,122.31999999999999317,NULL,'MarkIV-nolabel.png','Stephan Beal','The Journeyman is a cargo unit made to get Infantry where they are needed, and quickly. It will not stand up long to combat, but can defend itself for a few minutes with it''s small array of rockets and tertiary cannon. In addition to its infantry bays, it may carry 3 infantry on its hull, per the standard GEV rules for carrying infantry.'); INSERT INTO ogre VALUES(154,'2009-08-04 20:44:25','Ninja/Vulcan',NULL,0,7,4,11,188.38999999999998635,NULL,'Ninja.png','Allen Smith','-1 to hit from all attacks except Infantry in an overrun. I''m currently working on a GURPS Ogre version of this, which is even more of a cross between a Vulcan and a Ninja.'); INSERT INTO ogre VALUES(155,'2009-08-04 20:44:25','Fast Assult Mk III','Dragster',0,7,6,5,206.2400000000000091,0,'default.png','Daniel Gallant',NULL); INSERT INTO ogre VALUES(156,'2009-08-04 20:44:25','Merkava III-B',NULL,0,7,3,15,182.13999999999998635,0,'MarkIIIb-nolabel.png','Sean Bayan Schoonmaker','Functionally identical to the Mark III-B, but built by the Israelis under license. The Merkava does, however, look somewhat different, with a lower, wider chassis more suitable to desert warfare'); INSERT INTO ogre VALUES(157,'2009-08-04 20:44:25','Mk III Zunder','The Zunder',0,7,4,10,373.19999999999998862,0,'MarkIII-nolabel.png','Tom Zunder',NULL); INSERT INTO ogre VALUES(158,'2009-08-04 20:44:25','Mk V - ATDR "Piercer"','Piercer',0,8,3,20,215.05000000000001137,0,'default.png','Scott Weber','Designed by the NA Combine, the Ogre Mk V ATDR (Advance Troop Deployment & Recovery) was an uncharacteristically defensive development of Ogre combat philosophy. The ATDR model was intended to serve as a frontline breeching vehicle and mobile emplacement. Its primary purpose was to work in concert with other ATDR units, establish a safe deployment zone for conventional troops and conduct repairs on damaged frontline armor units while defending the established deployment zone. Twenty ATDR units were produced for use during the short-lived ''St. Petersburg Offensive''. However, the adjusted behavioral programming used to recondition standard Mk V Combat Control Centers proved itself to be far too aggressive for the intended battlefield application of the ATDR. Ultimately, the ATDR program was scrapped and the existing Mk V ATDR units were reassigned to the South American & Antarctic Theatres.'); INSERT INTO ogre VALUES(159,'2009-08-04 20:44:25','Hunter-Killer','Mike',0,8,3,10,211.97999999999998976,0,'default.png','S. Ventura','This model is designed specifically to seek out and destroy heavy targets.'); INSERT INTO ogre VALUES(160,'2009-08-04 20:44:25','Mark III r',NULL,0,7,3,15,149.22999999999998977,0,'default.png','fizz','Experimental APC variant. For deep penetration of special forces.'); INSERT INTO ogre VALUES(162,'2009-08-04 20:44:25','Steel Oni',NULL,0,7,3,15,194.37999999999999545,0,'default.png','Andrew Gelbman','This was the smaller of Japan''s two OGRE designs. First saw action in 2074 during the Battle of Hong Kong. This unit is based on the American Mark III-B.'); INSERT INTO ogre VALUES(163,'2009-08-04 20:44:25','Golem',NULL,0,7,3,15,196.68000000000000681,0,'default.png','Andrew Gelbman','The Golem was Israel''s OGRE design, more than a match for most Mark III designs, the IDF deployed these in 2073 though they remained secret until 2075 when an Iraqi/PanEuropean force violated Israel''s self-declared "security zone" in eastern Jordan. The Golem is a solid design, though very few became self-aware and none went rogue.'); INSERT INTO ogre VALUES(164,'2009-08-04 20:44:25','Fencer (Cannonical)',NULL,0,7,3,15,220.40000000000000569,0,'default.png','Andrew Gelbman','The Fencer was PanEurope''s first indigenous OGRE design. Introduced in 2084, it was a compromise between stolen Anglo-American technology received after the Fall of Britain and research done in Germany to copy Combine Cybertanks.'); INSERT INTO ogre VALUES(165,'2009-08-04 20:44:25','Steel Samurai',NULL,0,8,4,15,301.7799999999999727,0,'default.png','Andrew Gelbman','The Steel Samurai was the larger of Japan''s two OGRE designs, introduced in 2084 it was very successful against both Chinese "Dragon" super tanks and American Mk IV/V OGREs'); INSERT INTO ogre VALUES(167,'2009-08-04 20:44:25','scroflagon',NULL,0,8,4,15,249.9900000000000091,0,'Fencer.png',NULL,NULL); INSERT INTO ogre VALUES(168,'2009-08-04 20:44:25','scroflago',NULL,0,9,3,20,361.20999999999997952,0,'MarkVI.png',NULL,NULL); INSERT INTO ogre VALUES(169,'2009-08-04 20:44:25','Longarm',NULL,0,7,3,14,182.13999999999998635,0,'MarkIII.png',NULL,NULL); INSERT INTO ogre VALUES(170,'2009-08-04 20:44:25','MK III-H',NULL,0,7,3,14,186.72999999999998977,0,'MarkIII.png',NULL,NULL); INSERT INTO ogre VALUES(172,'2009-08-04 20:44:25','Mark I-LR','Sitting Bull',0,5,3,6,52.039999999999999149,0,'MarkI.png','Kirk Hunt','Late in the Last War, one city state was able to improve a "found OGRE" to this configuration.'); INSERT INTO ogre VALUES(173,'2009-08-04 20:44:25','Mark I-at','Cochise',0,5,3,6,61.219999999999998863,0,'MarkI.png','Kirk Hunt','A brother to the Sitting Bull this improved configuration made for a potent combatant.'); INSERT INTO ogre VALUES(174,'2009-08-04 20:44:25','Mark I-as','Geronimo',0,5,3,6,61.219999999999998863,0,'MarkI.png','Kirk Hunt','Like "Sitting Bull" and "Cochise" the upgrades to this "found" OGRE were one of a kind. Includes the "Stealth Module" (-1 to hit from all attacks except Infantry in an overrun) for improved battlefield survivability rather than raids.'); INSERT INTO ogre VALUES(175,'2009-08-04 20:44:25','PHALANX','stubby',0,7,3,4,135.46000000000000796,0,'default.png','erick',NULL); INSERT INTO ogre VALUES(176,'2009-08-04 20:44:25','MARK IBGF','BIGFOOT',0,5,4,25,232.13999999999998635,0,'default.png','MARTIN EVANS',NULL); INSERT INTO ogre VALUES(180,'2009-08-04 20:44:25','Steel Demon (ONI)','ONI',0,7,3,15,194.37999999999999545,0,'MarkIIIb-nolabel.png','George Leritte','The smaller of the Nihon Empire''s Ogre designs. This comes from GURPS Ogre (from SJ Games). Note that the secondary batteries have the same range as the main batteries.'); INSERT INTO ogre VALUES(181,'2009-08-05 15:22:53','Steel Warrior','SAMURAI',0,8,3,20,270.910000000000025,NULL,'MarkV-nolabel.png','George Leritte','The larger of the Nihon Empire''s Ogre designs. This comes from GURPS Ogre (from SJ Games). Note that the secondary batteries have the same range as the main batteries.'); INSERT INTO ogre VALUES(184,'2009-08-04 20:44:25','COMBINE U-21','DESTROYER',0,7,4,15,412.49000000000000908,0,'MarkIII.png','JOE FLYNN','COMBINE''S TAKE ON THE GOLIATH. WITH ADDED PUNCH'); INSERT INTO ogre VALUES(188,'2009-08-04 20:44:25','MARK II-D','DEMOLISHER',0,7,3,15,260.95999999999997954,0,'MarkII.png','MARTIN EVANS',NULL); INSERT INTO ogre VALUES(189,'2009-08-04 20:44:25','MARK I-B','BEHEMOTH',0,5,4,5,233.03000000000000113,0,'MarkI.png','MARTIN EVANS',NULL); INSERT INTO ogre VALUES(191,'2011-06-07 14:07:10','RLADC','Porcupine',0,9,2,25,494.85000000000002274,NULL,'Doppelsoldner-nolabel.png','Durendal5150',replace('The RLADC or "Rear Line Area Denial Crawler," Is less an ogre in the true sense as a firebase on treads, designed primarily for defense, it''s purpose to guard vital areas from the front, slowly backing away as it pummels the enemy from beyond their effective range.\n\nThe unit is also equipped to tow additional trailers of ammunition or equipment, as well as men to set them up. It''s oversized power plant is capable of powering nearby laser batteries if necessary.\n\n(Ideally, the Unit would carry it''s own Laser system and Anti-Air capabilities.)\n\nBased on a design for a UEC "Area Denial Command Unit," vehicle for my own work. <.<','\n',char(10))); INSERT INTO ogre VALUES(193,'2009-08-04 20:44:25','Grunt',NULL,0,5,3,10,86.480000000000003977,0,'MarkI.png','Doug Pappert',NULL); INSERT INTO ogre VALUES(194,'2009-08-04 20:44:25','Dagger',NULL,0,6,3,8,81.890000000000000568,0,'MarkII-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(195,'2009-08-04 20:44:25','Dagger/b',NULL,0,6,3,8,74.230000000000003978,0,'MarkII-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(196,'2009-08-04 20:44:25','Warhammer',NULL,0,7,3,12,142.34000000000000341,0,'MarkIII-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(197,'2009-08-04 20:44:25','MARK-VIII','BOLO',0,7,4,20,479.44999999999998864,0,'MarkVI.png','FLYNN','BOLO DARE I SAY MORE!'); INSERT INTO ogre VALUES(201,'2009-08-04 20:44:25','Dragon','False Ogre',0,7,3,15,144.63999999999998635,0,'MarkIII.png','Keith Johnson','Based off of the false Cybertank in GURPS Ogre, pg. 16'); INSERT INTO ogre VALUES(203,'2009-08-04 20:44:25','OM-Fencer',NULL,0,8,3,16,224.9900000000000091,0,'Fencer.png','Imre A. Szabo','The Ogre Minitures Fencer with 48 treads...'); INSERT INTO ogre VALUES(204,'2009-08-04 20:44:25','Mark VIa',NULL,0,9,3,24,417.85000000000002274,0,'MarkVI.png','Imre A. Szabo','Assault version of the Mark VI'); INSERT INTO ogre VALUES(206,'2009-08-04 20:44:25','mark IV B',NULL,0,8,4,5,199.99000000000000908,0,'MarkIV-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(208,'2009-08-04 20:44:25','Mark IV A',NULL,0,8,4,15,271.42000000000001591,0,'MarkIV.png',NULL,NULL); INSERT INTO ogre VALUES(209,'2009-08-04 20:44:25','Mark III A',NULL,0,7,3,15,163.77000000000001022,0,'MarkIII.png',NULL,NULL); INSERT INTO ogre VALUES(211,'2009-08-04 20:44:25','Mark II A',NULL,0,6,3,10,95.659999999999996587,0,'MarkII.png',NULL,NULL); INSERT INTO ogre VALUES(212,'2009-08-04 20:44:25','Mark V A',NULL,0,8,3,20,270.910000000000025,0,'MarkV.png',NULL,NULL); INSERT INTO ogre VALUES(213,'2009-08-04 20:44:25','Havok','Havok',0,9,4,20,423.19999999999998864,0,'default.png','Nomad','There were only four of these ogres produced, all by the Combine. They are very tough and optimized for striking at long range.'); INSERT INTO ogre VALUES(214,'2009-08-04 20:44:25','Harbinger','Harbinger',0,7,4,12,241.06999999999999318,0,'MarkIV-nolabel.png','Nomad','Speed 4, 2 main batteries, and 2 missile racks make this a tough opponent. It''s only weakness is a relatively few 48 tread units. It''s between a mark III and mark IV in size and programmed for cunning and hit and run tactics.'); INSERT INTO ogre VALUES(215,'2009-08-04 20:44:25','Mark IV-iiia Transport','Connestoga',0,8,4,15,204.46000000000000796,0,'default.png','Adam C. Lipscomb','This variant was created to facilitate delivering engineering and specialized assault infantry elements to combat zones. It has 3 infantry bays and a cargo bay capable of holding 1 armor unit or 3 squads of infantry.'); INSERT INTO ogre VALUES(216,'2009-08-04 20:44:25','MK 2x1a','Pounder',0,6,2,10,77.010000000000005115,0,'Spartan.png',NULL,NULL); INSERT INTO ogre VALUES(217,'2009-08-04 20:44:25','Vagabond Class','the Poet',0,8,4,12,267.85000000000002272,0,'default.png','george ibarra',NULL); INSERT INTO ogre VALUES(219,'2009-08-04 20:44:25','Mark IV C',NULL,0,8,4,15,270.5299999999999727,0,'MarkIV.png',NULL,NULL); INSERT INTO ogre VALUES(220,'2009-08-04 20:44:25','Mark V C',NULL,0,8,3,20,270.910000000000025,0,'MarkV.png',NULL,NULL); INSERT INTO ogre VALUES(221,'2009-08-04 20:44:25','Fencer A',NULL,0,8,3,15,207.38999999999998635,0,'Fencer.png',NULL,NULL); INSERT INTO ogre VALUES(222,'2009-08-04 20:44:25','Mk A1E3','the Gator',0,9,4,25,496.42000000000001593,0,'default.png','will W.',NULL); INSERT INTO ogre VALUES(225,'2009-08-04 20:44:25','Mark IV-R','Ravager',0,8,4,15,254.46000000000000796,0,'Lancer-nolabel.png','R.A.Gordon',NULL); INSERT INTO ogre VALUES(226,'2009-08-04 20:44:25','Guardian',NULL,0,6,3,10,195.90999999999999659,0,'MarkIII-nolabel.png','R.A.Gordon',NULL); INSERT INTO ogre VALUES(228,'2009-08-04 20:44:25','Mk VIII mod a1','Longbow',0,8,4,15,426.76999999999998183,0,'MarkV-nolabel.png','Jim C','A long range missile tosser. You can have my nukes when you pry them from my cold dead chassis!'); INSERT INTO ogre VALUES(229,'2009-08-04 20:44:25','Mk VII Mod a1','Quiver',0,6,4,10,296.42000000000001591,0,'MarkIII-nolabel.png','Jim C','A fast supply variant for the Mk VIII a1 Longbow. If the Mk VII a1 and a Mk VIII a1 sit in a hex together for one turn, the Quiver can reload 20 missiles. Two turns for a full reload. To help keep the offensive rolling. The Quiver then returns for more reloads.'); INSERT INTO ogre VALUES(230,'2009-08-04 20:44:25','Mk1-turtle',NULL,0,5,4,20,233.03000000000000113,0,'default.png','Mike',NULL); INSERT INTO ogre VALUES(231,'2009-08-04 20:44:25','Reaper',NULL,0,9,2,20,190.16999999999998749,0,'Fencer-nolabel.png','R.A.Gordon',NULL); INSERT INTO ogre VALUES(232,'2009-08-04 20:44:25','Vulcan Mk. I','Victors',0,7,3,15,108.6700000000000017,NULL,'default-nolabel.png','Stephen Blount','Because, incredibly, there wasn''t one up already. There should probably be a "drone bay" much like an infantry bay.'); INSERT INTO ogre VALUES(234,'2009-08-04 20:44:25','Light Horse',NULL,0,7,4,10,128.56999999999999317,0,'default.png','Scott Nelson',NULL); INSERT INTO ogre VALUES(235,'2009-08-04 20:44:25','Firedance','Splat',0,5,4,20,287.49000000000000909,NULL,'MarkI-nolabel.png','Mike Dugan','Firedance was envisioned as a platfrom to kill vehicles, not to take on heavier units like other OGREs. '); INSERT INTO ogre VALUES(236,'2009-08-04 20:44:25','Scorpion',NULL,0,8,4,15,414.26999999999998183,0,'default.png','Mike',NULL); INSERT INTO ogre VALUES(237,'2009-08-04 20:44:25','Hunter-MkI','Hunter',0,8,3,10,165.30000000000001136,0,'Doppelsoldner.png','Vernon Burt','Just want a record sheet O can test the concept of an Ogre-Hunter on'); INSERT INTO ogre VALUES(239,'2009-08-04 20:44:25','Mk-4-FS-a',NULL,0,8,4,12,533.01999999999998183,0,'default.png','Mike','Fire Support Ogre, ver 1'); INSERT INTO ogre VALUES(241,'2009-08-04 20:44:25','Mk-4-FS-b-4',NULL,0,8,4,12,461.58999999999997497,0,'default.png','Mike','Fire Support Ogre, ver 2a'); INSERT INTO ogre VALUES(243,'2009-08-04 20:44:25','Mk-4-FS-C-5',NULL,0,8,4,12,394.62999999999999545,0,'default.png','Mike','Fire Support Ogre, ver 3a'); INSERT INTO ogre VALUES(245,'2009-08-04 20:44:25','Mk-4-MS-a',NULL,0,8,4,12,390.17000000000001591,0,'default.png','Mike','Missile Support Ogre, ver 1'); INSERT INTO ogre VALUES(246,'2009-08-04 20:44:25','Mk-4-CA',NULL,0,8,4,15,450.87999999999999545,0,'default.png','Mike','City Assault Ogre, the Ogre smashes its way in and drops the infantry (''Dx3'') to hold the town until reinforcements can arrive - hopefully.'); INSERT INTO ogre VALUES(247,'2009-08-04 20:44:25','Grunt2','TG',0,7,4,2,36.60999999999999943,0,'default.png',NULL,NULL); INSERT INTO ogre VALUES(248,'2009-08-04 20:44:25','Mk VI (IP)','Devastator',0,9,3,30,532.63999999999998634,0,'MarkVI-nolabel.png','Mike Raper','Built by the Combine after the appearance of the Dopplesoldner on the field in Paneurope. Exessive expense and difficulty in production lead to only building two of these machines, who named themselves Donner and Blitzen, much to the chagrin of the upper echelon Combine military command.'); INSERT INTO ogre VALUES(249,'2009-08-04 20:44:25','M-2','Bradley',0,6,4,10,127.68000000000000682,0,'MarkI-nolabel.png','Mike Raper','Designed as a heavy troop transport and scout vehicle. The M2 has two infantry bays, plus decent anti-infantry weapons. Its speed is it''s main strength...it is not designed for combat with heavy armor units, but to deliver armored infantry into hostile fire zones they may otherwise be unable to reach.'); INSERT INTO ogre VALUES(250,'2009-08-04 20:44:25','Stock',NULL,0,7,3,15,163.77000000000001022,0,'default.png','Chris Tate',NULL); INSERT INTO ogre VALUES(251,'2009-08-04 20:44:25','Lancer',NULL,0,9,3,22,310.70999999999997954,0,'Doppelsoldner.png',NULL,NULL); INSERT INTO ogre VALUES(252,'2009-08-04 20:44:25','I (au)','Red-Back',0,5,4,5,92.849999999999994317,0,'default.png','Brian','Packed to the gills, this Ogre was quite a supprise.'); INSERT INTO ogre VALUES(254,'2009-08-04 20:44:25','Mk I (au)','Red-Back',0,5,4,5,92.849999999999994317,0,'default.png','Brian','Packed to the gills, this Ogre was quite a supprise.'); INSERT INTO ogre VALUES(255,'2009-08-04 20:44:25','MK3','Pitcher',0,7,4,12,272.31000000000000226,0,'default.png','Avaheil D''otter','The Pitcher was intended as a cheaper version of the fencer using rocket salvos instead of missles. While the external missles helped, the effectiveness was questionable and only a few of these units were produced. One sucess came from an engagement with a swarm of LGEV''s where the high speed, multiple attacks and long range were quite effective'); INSERT INTO ogre VALUES(257,'2009-08-04 20:44:25','Titan 6',NULL,0,9,3,25,362.75,0,'MarkVI.png',NULL,NULL); INSERT INTO ogre VALUES(260,'2009-08-04 20:44:25','Chaos Ogre Mark I','Chaos Ogre',0,8,4,15,282.13999999999998635,0,'MarkIV-nolabel.png','Nick Kiest',NULL); INSERT INTO ogre VALUES(262,'2009-08-04 20:44:25','Mk-1','Purple rain',0,6,2,20,141.96000000000000795,0,'MarkII.png','Krakatoa','This model wasnt designed as a penetrator, he doesnt work alone. His existance was made to create a mobile artillery support to any attacking force, withouth costing too much to build'); INSERT INTO ogre VALUES(263,'2009-08-04 20:44:25','anti-tank',NULL,0,6,3,10,123.20999999999999374,0,'MarkII.png','Krakatoa',NULL); INSERT INTO ogre VALUES(264,'2009-08-04 20:44:25','Mark III Miniatures',NULL,0,7,3,16,168.36000000000001364,0,'MarkIII.png',NULL,NULL); INSERT INTO ogre VALUES(265,'2009-08-04 20:44:25','Vulcan Mk. II','Super Vulcan',0,7,3,15,120.15000000000000568,NULL,'MarkIII-nolabel.png','Maksim-Smelchak',replace('The Vulcan Mk. II was the air transportable version of the Vulcan based of an two segmented early prototype version of what became the MK. III OGRE.\nIts light armament is only meant to discourage scouting infantry or GEV skirmishers. Two engineering arms allow the ogre to quickly assemble air-dropped OGREs along with its'' small army of worker drones that stow in the cargo bays. The exact quantity of drones was never officially established and often depended on availibility of manufacture. At least two units (multiple android drones) were required for standard operation with more adding to the speed of OGRE manufacture. The two secondary batteries are emplaced in turrets with retractible cherry picker arms that double as laser welders under low power due to an ingenious combi-design.\nLike the Mk. III OGRE, the Super Vulcan Mk. II is fit into two sections with the front mounting the engineering arms, secondary batteries, the AI, and 5 of the AP units while the rear section held cargo units for spare parts, the drone complement, a small back-up AI computer with limited intelligence, a tow hook, and 3 AP batteries. The front section did retain the characteristic OGRE conning tower/sensor suite, which with any luck would inform the Mk.II Super Vulcan of enemy forces with enough time to evade the marauders.\nAn interesting feature of the unit is that the front and rear segments could be detached although inly the front segment has true AI capability. The rear segment could operate under a human operator''s guidance or under its'' own limited secondary AI brain. The best part about the segmentation feature of the two modules was that this feature made the Mk. II Super Vulcan easily air-portable by larger transport assets such as the C-5 Galaxy''s successor, the C-25 Howard Hughes or "Howie" as it was known to the troops. A few "Howies" could move a Mk.II Super Vulcan and 3 MK. III OGRE "raiding package" package deep into enemy territory assuming hostile interceptors couldn''t find them. The "Howie''s" low observability technology and all weather terrain follwing sensor suite made the Mk. II Super Vulcan/C-25 "Howie" a valuable asset for the North American Combine. Mk. II Super Vulcans were originally created by the Israellis who built the Mk. II as a field mobile repair shop for its'' self-contained tank battallions, which kept many marauders away because Israel could quickly power project large armies with or without OGRE support over long diatances into the heart of Arabia if need be for retaliation. Mk. IIs have operated in many missions included field assembly of OGREs, field repair, and as combat engineers among their other missions. Paneuropean Russian/Soviet units were very fond of their copied Mk. II Super Vulcans and frequently deployed them into large regimental level OGRE raiding groups supported by armor battalions. These same Russian units drove the NAC invaders off of the "Continent" before the end of the war.','\n',char(10))); INSERT INTO ogre VALUES(266,'2009-08-05 15:21:50','Tremendous','Atomic Horror',0,9,4,20,552.65999999999996816,NULL,'MarkVI-nolabel.png','Blade',NULL); INSERT INTO ogre VALUES(269,'2009-08-04 20:44:25','Blackeye v2','Blackie 2',0,6,3,10,101.78000000000000113,NULL,'MarkII-nolabel.png','Stephan Beal','Intended primarily for light escort jobs.'); INSERT INTO ogre VALUES(270,'2010-02-23 20:18:03','Blackeye v2.1','Blackie 2.10',0,6,3,12,111.73000000000000397,NULL,'MarkII-nolabel.png','Stephan Beal','A slight variation on the Blackeye v2.0, with one more SB, no AP, and two fewer RktS-E.'); INSERT INTO ogre VALUES(271,'2009-08-04 20:44:25','Spraycan',NULL,0,6,3,10,90.299999999999997161,NULL,'Flower-nolabel.png','Stephan Beal','Spraycan''s sole purpose is hosing down infantry. Little ones, big ones, fast ones, slow ones.'); INSERT INTO ogre VALUES(273,'2009-09-05 22:26:50','Mark III-SGB-A0',NULL,0,7,3,15,163.77000000000001022,NULL,'MarkIII-nolabel.png','Stephan Beal','Another experimental form of the Mark III, intended for the same missions as the original model.'); INSERT INTO ogre VALUES(276,'2010-02-13 18:24:48','MK III-T','Hedgehog',0,7,3,14,162.24000000000000909,NULL,'MarkIII.png','Rlyehable','The Ogre Mk III-T was implemented by some of the Factory-States. It simply upgrades the 8 AP guns to 4 Tertiary guns to provide additional anti-vehicle protection from swarms of light vehicles.'); INSERT INTO ogre VALUES(277,'2010-02-14 08:33:05','Fencer-B',NULL,0,8,3,15,234.18000000000000681,NULL,'Fencer.png','Ry',NULL); INSERT INTO ogre VALUES(278,'2011-04-21 13:03:43','Mark I Bolt','Bolt',0,5,3,5,56.630000000000002557,NULL,'MarkI.png','Herb Diehr','Experimental version made when Mk III came out.'); INSERT INTO ogre VALUES(279,'2011-04-21 13:06:21','Copy of Copy of Mark I',NULL,0,5,3,5,47.450000000000002843,NULL,'MarkI.png',NULL,'Experimental version mde when Mk III came out.'); INSERT INTO ogre VALUES(280,'2011-06-28 23:22:29','$Copyme',NULL,0,5,3,5,NULL,NULL,'default.png',NULL,'Intended to be copied as a starting point for new ogres.'); INSERT INTO ogre VALUES(281,'2014-01-24 23:34:28','Mark III-p','Porcupine',0,7,3,15,172.94999999999998862,NULL,'MarkIII-nolabel.png','sum1els','This modified Mark III may have seen use in specialized engagements, but its line was short-lived and records are sparse.'); INSERT INTO ogre VALUES(282,'2015-01-10 11:08:20','Markish 3A',NULL,0,7,3,16,206.62999999999999544,NULL,'MarkIIIb-nolabel.png',NULL,NULL); INSERT INTO ogre VALUES(284,'2017-03-13 17:28:48','Blossom 2','Spitfire',0,7,3,15,143.87000000000000454,NULL,'MarkIII-nolabel.png','Stephan Beal','A larger variant of the Blossom, with more missiles.'); CREATE TABLE gearToOgre ( oid int(10) NOT NULL, gid int(10) NOT NULL REFERENCES gear(id), c int(10) NOT NULL, UNIQUE(oid,gid) ON CONFLICT REPLACE, FOREIGN KEY(oid) REFERENCES ogre(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY(gid) REFERENCES gear(id) ON UPDATE CASCADE ON DELETE CASCADE ); CREATE INDEX xg2o_oid on gearToOgre(oid); CREATE INDEX xg2o_gid on gearToOgre(gid); INSERT INTO gearToOgre VALUES(5,7,8); INSERT INTO gearToOgre VALUES(1,7,4); INSERT INTO gearToOgre VALUES(101,104,2); INSERT INTO gearToOgre VALUES(101,103,1); INSERT INTO gearToOgre VALUES(101,7,4); INSERT INTO gearToOgre VALUES(101,2,2); INSERT INTO gearToOgre VALUES(3,7,8); INSERT INTO gearToOgre VALUES(3,5,2); INSERT INTO gearToOgre VALUES(3,2,4); INSERT INTO gearToOgre VALUES(2,7,6); INSERT INTO gearToOgre VALUES(2,2,2); INSERT INTO gearToOgre VALUES(5,6,3); INSERT INTO gearToOgre VALUES(5,4,15); INSERT INTO gearToOgre VALUES(5,2,2); INSERT INTO gearToOgre VALUES(4,7,8); INSERT INTO gearToOgre VALUES(4,6,4); INSERT INTO gearToOgre VALUES(4,4,20); INSERT INTO gearToOgre VALUES(4,2,2); INSERT INTO gearToOgre VALUES(6,7,12); INSERT INTO gearToOgre VALUES(6,5,6); INSERT INTO gearToOgre VALUES(6,2,6); INSERT INTO gearToOgre VALUES(7,7,16); INSERT INTO gearToOgre VALUES(7,6,2); INSERT INTO gearToOgre VALUES(7,4,20); INSERT INTO gearToOgre VALUES(7,2,6); INSERT INTO gearToOgre VALUES(3,1,1); INSERT INTO gearToOgre VALUES(1,1,1); INSERT INTO gearToOgre VALUES(2,1,1); INSERT INTO gearToOgre VALUES(5,1,1); INSERT INTO gearToOgre VALUES(6,1,2); INSERT INTO gearToOgre VALUES(7,1,3); INSERT INTO gearToOgre VALUES(106,3,4); INSERT INTO gearToOgre VALUES(106,7,6); INSERT INTO gearToOgre VALUES(106,5,2); INSERT INTO gearToOgre VALUES(106,2,2); INSERT INTO gearToOgre VALUES(107,6,4); INSERT INTO gearToOgre VALUES(107,4,20); INSERT INTO gearToOgre VALUES(107,1,2); INSERT INTO gearToOgre VALUES(110,112,3); INSERT INTO gearToOgre VALUES(110,109,1); INSERT INTO gearToOgre VALUES(108,104,3); INSERT INTO gearToOgre VALUES(109,106,3); INSERT INTO gearToOgre VALUES(109,107,1); INSERT INTO gearToOgre VALUES(109,2,4); INSERT INTO gearToOgre VALUES(110,101,6); INSERT INTO gearToOgre VALUES(110,8,1); INSERT INTO gearToOgre VALUES(110,7,6); INSERT INTO gearToOgre VALUES(110,2,1); INSERT INTO gearToOgre VALUES(108,101,2); INSERT INTO gearToOgre VALUES(108,2,2); INSERT INTO gearToOgre VALUES(111,2,2); INSERT INTO gearToOgre VALUES(111,7,6); INSERT INTO gearToOgre VALUES(111,112,1); INSERT INTO gearToOgre VALUES(112,1,2); INSERT INTO gearToOgre VALUES(112,2,6); INSERT INTO gearToOgre VALUES(112,5,6); INSERT INTO gearToOgre VALUES(112,7,10); INSERT INTO gearToOgre VALUES(112,8,1); INSERT INTO gearToOgre VALUES(112,3,3); INSERT INTO gearToOgre VALUES(112,101,7); INSERT INTO gearToOgre VALUES(112,100,2); INSERT INTO gearToOgre VALUES(112,103,3); INSERT INTO gearToOgre VALUES(112,112,2); INSERT INTO gearToOgre VALUES(113,102,2); INSERT INTO gearToOgre VALUES(113,100,4); INSERT INTO gearToOgre VALUES(113,3,4); INSERT INTO gearToOgre VALUES(113,7,4); INSERT INTO gearToOgre VALUES(113,2,2); INSERT INTO gearToOgre VALUES(114,7,6); INSERT INTO gearToOgre VALUES(114,5,2); INSERT INTO gearToOgre VALUES(114,2,3); INSERT INTO gearToOgre VALUES(116,3,4); INSERT INTO gearToOgre VALUES(116,7,12); INSERT INTO gearToOgre VALUES(116,5,4); INSERT INTO gearToOgre VALUES(116,2,6); INSERT INTO gearToOgre VALUES(8,1,2); INSERT INTO gearToOgre VALUES(8,2,4); INSERT INTO gearToOgre VALUES(8,5,4); INSERT INTO gearToOgre VALUES(8,7,8); INSERT INTO gearToOgre VALUES(117,1,2); INSERT INTO gearToOgre VALUES(117,2,4); INSERT INTO gearToOgre VALUES(117,5,4); INSERT INTO gearToOgre VALUES(117,7,8); INSERT INTO gearToOgre VALUES(121,7,12); INSERT INTO gearToOgre VALUES(121,6,3); INSERT INTO gearToOgre VALUES(121,4,15); INSERT INTO gearToOgre VALUES(121,2,6); INSERT INTO gearToOgre VALUES(121,1,2); INSERT INTO gearToOgre VALUES(122,7,8); INSERT INTO gearToOgre VALUES(122,6,1); INSERT INTO gearToOgre VALUES(122,4,5); INSERT INTO gearToOgre VALUES(122,2,4); INSERT INTO gearToOgre VALUES(122,1,1); INSERT INTO gearToOgre VALUES(114,1,1); INSERT INTO gearToOgre VALUES(126,1,4); INSERT INTO gearToOgre VALUES(126,2,2); INSERT INTO gearToOgre VALUES(126,5,2); INSERT INTO gearToOgre VALUES(126,7,12); INSERT INTO gearToOgre VALUES(126,103,2); INSERT INTO gearToOgre VALUES(127,101,2); INSERT INTO gearToOgre VALUES(127,7,4); INSERT INTO gearToOgre VALUES(127,1,1); INSERT INTO gearToOgre VALUES(150,101,4); INSERT INTO gearToOgre VALUES(150,7,12); INSERT INTO gearToOgre VALUES(150,1,5); INSERT INTO gearToOgre VALUES(137,105,2); INSERT INTO gearToOgre VALUES(137,3,4); INSERT INTO gearToOgre VALUES(137,7,6); INSERT INTO gearToOgre VALUES(137,6,2); INSERT INTO gearToOgre VALUES(137,4,6); INSERT INTO gearToOgre VALUES(137,2,2); INSERT INTO gearToOgre VALUES(137,1,1); INSERT INTO gearToOgre VALUES(138,1,4); INSERT INTO gearToOgre VALUES(138,2,8); INSERT INTO gearToOgre VALUES(138,5,2); INSERT INTO gearToOgre VALUES(140,1,6); INSERT INTO gearToOgre VALUES(140,4,24); INSERT INTO gearToOgre VALUES(140,6,4); INSERT INTO gearToOgre VALUES(140,7,12); INSERT INTO gearToOgre VALUES(141,3,6); INSERT INTO gearToOgre VALUES(141,7,12); INSERT INTO gearToOgre VALUES(141,6,4); INSERT INTO gearToOgre VALUES(141,4,20); INSERT INTO gearToOgre VALUES(141,2,8); INSERT INTO gearToOgre VALUES(142,2,6); INSERT INTO gearToOgre VALUES(142,4,15); INSERT INTO gearToOgre VALUES(142,6,5); INSERT INTO gearToOgre VALUES(142,7,10); INSERT INTO gearToOgre VALUES(142,3,2); INSERT INTO gearToOgre VALUES(142,112,2); INSERT INTO gearToOgre VALUES(141,1,6); INSERT INTO gearToOgre VALUES(149,7,6); INSERT INTO gearToOgre VALUES(149,5,2); INSERT INTO gearToOgre VALUES(149,1,1); INSERT INTO gearToOgre VALUES(148,102,2); INSERT INTO gearToOgre VALUES(148,100,8); INSERT INTO gearToOgre VALUES(148,7,4); INSERT INTO gearToOgre VALUES(147,7,8); INSERT INTO gearToOgre VALUES(147,2,1); INSERT INTO gearToOgre VALUES(145,7,2); INSERT INTO gearToOgre VALUES(145,2,1); INSERT INTO gearToOgre VALUES(145,1,1); INSERT INTO gearToOgre VALUES(144,7,6); INSERT INTO gearToOgre VALUES(144,2,2); INSERT INTO gearToOgre VALUES(151,7,4); INSERT INTO gearToOgre VALUES(151,104,1); INSERT INTO gearToOgre VALUES(152,100,12); INSERT INTO gearToOgre VALUES(152,7,12); INSERT INTO gearToOgre VALUES(152,5,2); INSERT INTO gearToOgre VALUES(152,1,4); INSERT INTO gearToOgre VALUES(152,102,3); INSERT INTO gearToOgre VALUES(155,1,1); INSERT INTO gearToOgre VALUES(155,2,2); INSERT INTO gearToOgre VALUES(155,4,4); INSERT INTO gearToOgre VALUES(155,6,2); INSERT INTO gearToOgre VALUES(156,1,2); INSERT INTO gearToOgre VALUES(156,2,4); INSERT INTO gearToOgre VALUES(156,5,2); INSERT INTO gearToOgre VALUES(156,7,8); INSERT INTO gearToOgre VALUES(157,104,2); INSERT INTO gearToOgre VALUES(157,7,6); INSERT INTO gearToOgre VALUES(157,5,4); INSERT INTO gearToOgre VALUES(157,2,2); INSERT INTO gearToOgre VALUES(157,1,2); INSERT INTO gearToOgre VALUES(158,1,2); INSERT INTO gearToOgre VALUES(158,2,4); INSERT INTO gearToOgre VALUES(158,5,2); INSERT INTO gearToOgre VALUES(158,7,8); INSERT INTO gearToOgre VALUES(158,109,1); INSERT INTO gearToOgre VALUES(158,111,2); INSERT INTO gearToOgre VALUES(159,1,4); INSERT INTO gearToOgre VALUES(159,2,3); INSERT INTO gearToOgre VALUES(159,5,6); INSERT INTO gearToOgre VALUES(159,7,2); INSERT INTO gearToOgre VALUES(160,1,1); INSERT INTO gearToOgre VALUES(160,2,3); INSERT INTO gearToOgre VALUES(160,7,6); INSERT INTO gearToOgre VALUES(160,3,2); INSERT INTO gearToOgre VALUES(160,112,2); INSERT INTO gearToOgre VALUES(160,111,2); INSERT INTO gearToOgre VALUES(162,1,2); INSERT INTO gearToOgre VALUES(162,2,4); INSERT INTO gearToOgre VALUES(162,4,4); INSERT INTO gearToOgre VALUES(162,6,1); INSERT INTO gearToOgre VALUES(162,7,12); INSERT INTO gearToOgre VALUES(163,1,1); INSERT INTO gearToOgre VALUES(163,2,3); INSERT INTO gearToOgre VALUES(163,4,9); INSERT INTO gearToOgre VALUES(163,6,3); INSERT INTO gearToOgre VALUES(163,7,10); INSERT INTO gearToOgre VALUES(164,2,2); INSERT INTO gearToOgre VALUES(164,4,20); INSERT INTO gearToOgre VALUES(164,6,4); INSERT INTO gearToOgre VALUES(164,7,8); INSERT INTO gearToOgre VALUES(165,1,1); INSERT INTO gearToOgre VALUES(165,2,2); INSERT INTO gearToOgre VALUES(165,4,20); INSERT INTO gearToOgre VALUES(165,6,4); INSERT INTO gearToOgre VALUES(165,7,6); INSERT INTO gearToOgre VALUES(167,1,1); INSERT INTO gearToOgre VALUES(167,4,16); INSERT INTO gearToOgre VALUES(167,6,4); INSERT INTO gearToOgre VALUES(167,7,4); INSERT INTO gearToOgre VALUES(168,1,3); INSERT INTO gearToOgre VALUES(168,2,8); INSERT INTO gearToOgre VALUES(168,4,16); INSERT INTO gearToOgre VALUES(168,6,4); INSERT INTO gearToOgre VALUES(168,7,16); INSERT INTO gearToOgre VALUES(169,7,2); INSERT INTO gearToOgre VALUES(169,3,4); INSERT INTO gearToOgre VALUES(169,103,2); INSERT INTO gearToOgre VALUES(170,2,4); INSERT INTO gearToOgre VALUES(170,104,1); INSERT INTO gearToOgre VALUES(172,1,1); INSERT INTO gearToOgre VALUES(172,7,4); INSERT INTO gearToOgre VALUES(173,3,4); INSERT INTO gearToOgre VALUES(173,1,1); INSERT INTO gearToOgre VALUES(174,3,4); INSERT INTO gearToOgre VALUES(174,1,1); INSERT INTO gearToOgre VALUES(175,1,2); INSERT INTO gearToOgre VALUES(175,2,3); INSERT INTO gearToOgre VALUES(175,4,4); INSERT INTO gearToOgre VALUES(175,6,1); INSERT INTO gearToOgre VALUES(175,7,8); INSERT INTO gearToOgre VALUES(175,113,4); INSERT INTO gearToOgre VALUES(176,1,1); INSERT INTO gearToOgre VALUES(176,5,2); INSERT INTO gearToOgre VALUES(176,113,4); INSERT INTO gearToOgre VALUES(180,7,12); INSERT INTO gearToOgre VALUES(180,6,1); INSERT INTO gearToOgre VALUES(180,4,4); INSERT INTO gearToOgre VALUES(180,2,4); INSERT INTO gearToOgre VALUES(180,1,2); INSERT INTO gearToOgre VALUES(248,1,4); INSERT INTO gearToOgre VALUES(247,102,4); INSERT INTO gearToOgre VALUES(247,3,1); INSERT INTO gearToOgre VALUES(246,112,4); INSERT INTO gearToOgre VALUES(246,8,1); INSERT INTO gearToOgre VALUES(246,7,9); INSERT INTO gearToOgre VALUES(246,6,8); INSERT INTO gearToOgre VALUES(246,4,32); INSERT INTO gearToOgre VALUES(246,1,4); INSERT INTO gearToOgre VALUES(245,8,1); INSERT INTO gearToOgre VALUES(245,7,9); INSERT INTO gearToOgre VALUES(245,6,10); INSERT INTO gearToOgre VALUES(245,4,40); INSERT INTO gearToOgre VALUES(243,103,5); INSERT INTO gearToOgre VALUES(243,8,1); INSERT INTO gearToOgre VALUES(243,7,9); INSERT INTO gearToOgre VALUES(184,2,2); INSERT INTO gearToOgre VALUES(184,5,4); INSERT INTO gearToOgre VALUES(184,7,12); INSERT INTO gearToOgre VALUES(184,110,4); INSERT INTO gearToOgre VALUES(241,104,4); INSERT INTO gearToOgre VALUES(241,8,1); INSERT INTO gearToOgre VALUES(241,7,9); INSERT INTO gearToOgre VALUES(188,1,2); INSERT INTO gearToOgre VALUES(188,8,1); INSERT INTO gearToOgre VALUES(188,104,2); INSERT INTO gearToOgre VALUES(189,100,2); INSERT INTO gearToOgre VALUES(189,102,2); INSERT INTO gearToOgre VALUES(189,104,2); INSERT INTO gearToOgre VALUES(189,109,1); INSERT INTO gearToOgre VALUES(193,1,1); INSERT INTO gearToOgre VALUES(193,2,1); INSERT INTO gearToOgre VALUES(193,7,2); INSERT INTO gearToOgre VALUES(193,101,2); INSERT INTO gearToOgre VALUES(194,1,1); INSERT INTO gearToOgre VALUES(194,2,1); INSERT INTO gearToOgre VALUES(194,5,1); INSERT INTO gearToOgre VALUES(194,7,4); INSERT INTO gearToOgre VALUES(195,1,1); INSERT INTO gearToOgre VALUES(195,5,1); INSERT INTO gearToOgre VALUES(195,7,4); INSERT INTO gearToOgre VALUES(195,3,1); INSERT INTO gearToOgre VALUES(196,1,1); INSERT INTO gearToOgre VALUES(196,2,2); INSERT INTO gearToOgre VALUES(196,5,2); INSERT INTO gearToOgre VALUES(196,7,8); INSERT INTO gearToOgre VALUES(196,3,4); INSERT INTO gearToOgre VALUES(197,1,1); INSERT INTO gearToOgre VALUES(197,2,15); INSERT INTO gearToOgre VALUES(197,7,30); INSERT INTO gearToOgre VALUES(197,8,1); INSERT INTO gearToOgre VALUES(197,109,1); INSERT INTO gearToOgre VALUES(197,110,1); INSERT INTO gearToOgre VALUES(201,1,1); INSERT INTO gearToOgre VALUES(201,2,4); INSERT INTO gearToOgre VALUES(201,7,6); INSERT INTO gearToOgre VALUES(201,112,1); INSERT INTO gearToOgre VALUES(239,105,4); INSERT INTO gearToOgre VALUES(239,8,1); INSERT INTO gearToOgre VALUES(239,7,9); INSERT INTO gearToOgre VALUES(203,2,2); INSERT INTO gearToOgre VALUES(203,4,20); INSERT INTO gearToOgre VALUES(203,6,4); INSERT INTO gearToOgre VALUES(203,7,8); INSERT INTO gearToOgre VALUES(107,7,8); INSERT INTO gearToOgre VALUES(204,1,3); INSERT INTO gearToOgre VALUES(204,2,6); INSERT INTO gearToOgre VALUES(204,5,6); INSERT INTO gearToOgre VALUES(204,4,20); INSERT INTO gearToOgre VALUES(204,6,2); INSERT INTO gearToOgre VALUES(204,7,16); INSERT INTO gearToOgre VALUES(206,1,1); INSERT INTO gearToOgre VALUES(206,4,20); INSERT INTO gearToOgre VALUES(206,6,4); INSERT INTO gearToOgre VALUES(206,7,4); INSERT INTO gearToOgre VALUES(208,1,1); INSERT INTO gearToOgre VALUES(208,4,20); INSERT INTO gearToOgre VALUES(208,6,4); INSERT INTO gearToOgre VALUES(208,7,4); INSERT INTO gearToOgre VALUES(209,1,1); INSERT INTO gearToOgre VALUES(209,2,2); INSERT INTO gearToOgre VALUES(209,5,4); INSERT INTO gearToOgre VALUES(209,7,11); INSERT INTO gearToOgre VALUES(211,1,1); INSERT INTO gearToOgre VALUES(211,2,1); INSERT INTO gearToOgre VALUES(211,5,2); INSERT INTO gearToOgre VALUES(211,7,1); INSERT INTO gearToOgre VALUES(212,1,4); INSERT INTO gearToOgre VALUES(212,2,2); INSERT INTO gearToOgre VALUES(212,5,7); INSERT INTO gearToOgre VALUES(212,7,12); INSERT INTO gearToOgre VALUES(213,1,4); INSERT INTO gearToOgre VALUES(213,2,6); INSERT INTO gearToOgre VALUES(213,4,12); INSERT INTO gearToOgre VALUES(213,6,4); INSERT INTO gearToOgre VALUES(213,7,12); INSERT INTO gearToOgre VALUES(214,1,2); INSERT INTO gearToOgre VALUES(214,2,2); INSERT INTO gearToOgre VALUES(214,5,2); INSERT INTO gearToOgre VALUES(214,4,8); INSERT INTO gearToOgre VALUES(214,6,2); INSERT INTO gearToOgre VALUES(214,7,4); INSERT INTO gearToOgre VALUES(215,2,4); INSERT INTO gearToOgre VALUES(215,7,8); INSERT INTO gearToOgre VALUES(215,101,4); INSERT INTO gearToOgre VALUES(215,112,3); INSERT INTO gearToOgre VALUES(215,111,1); INSERT INTO gearToOgre VALUES(216,1,3); INSERT INTO gearToOgre VALUES(216,112,1); INSERT INTO gearToOgre VALUES(217,1,2); INSERT INTO gearToOgre VALUES(217,2,2); INSERT INTO gearToOgre VALUES(217,4,6); INSERT INTO gearToOgre VALUES(217,6,2); INSERT INTO gearToOgre VALUES(217,7,4); INSERT INTO gearToOgre VALUES(217,113,2); INSERT INTO gearToOgre VALUES(217,110,1); INSERT INTO gearToOgre VALUES(219,1,2); INSERT INTO gearToOgre VALUES(219,2,3); INSERT INTO gearToOgre VALUES(219,4,10); INSERT INTO gearToOgre VALUES(219,6,2); INSERT INTO gearToOgre VALUES(219,7,7); INSERT INTO gearToOgre VALUES(220,1,3); INSERT INTO gearToOgre VALUES(220,2,6); INSERT INTO gearToOgre VALUES(220,5,4); INSERT INTO gearToOgre VALUES(220,7,12); INSERT INTO gearToOgre VALUES(221,1,2); INSERT INTO gearToOgre VALUES(221,2,3); INSERT INTO gearToOgre VALUES(221,4,10); INSERT INTO gearToOgre VALUES(221,6,2); INSERT INTO gearToOgre VALUES(221,7,6); INSERT INTO gearToOgre VALUES(222,1,4); INSERT INTO gearToOgre VALUES(222,2,4); INSERT INTO gearToOgre VALUES(222,4,24); INSERT INTO gearToOgre VALUES(222,6,4); INSERT INTO gearToOgre VALUES(222,7,12); INSERT INTO gearToOgre VALUES(225,1,2); INSERT INTO gearToOgre VALUES(225,2,2); INSERT INTO gearToOgre VALUES(225,4,6); INSERT INTO gearToOgre VALUES(225,6,2); INSERT INTO gearToOgre VALUES(225,7,6); INSERT INTO gearToOgre VALUES(225,113,6); INSERT INTO gearToOgre VALUES(225,101,1); INSERT INTO gearToOgre VALUES(231,7,4); INSERT INTO gearToOgre VALUES(231,6,4); INSERT INTO gearToOgre VALUES(231,4,12); INSERT INTO gearToOgre VALUES(231,2,4); INSERT INTO gearToOgre VALUES(226,111,1); INSERT INTO gearToOgre VALUES(226,104,1); INSERT INTO gearToOgre VALUES(226,3,4); INSERT INTO gearToOgre VALUES(226,113,6); INSERT INTO gearToOgre VALUES(226,5,2); INSERT INTO gearToOgre VALUES(226,2,2); INSERT INTO gearToOgre VALUES(228,2,2); INSERT INTO gearToOgre VALUES(228,4,40); INSERT INTO gearToOgre VALUES(228,6,8); INSERT INTO gearToOgre VALUES(228,113,8); INSERT INTO gearToOgre VALUES(229,4,40); INSERT INTO gearToOgre VALUES(229,113,4); INSERT INTO gearToOgre VALUES(230,2,2); INSERT INTO gearToOgre VALUES(230,8,1); INSERT INTO gearToOgre VALUES(230,113,6); INSERT INTO gearToOgre VALUES(230,3,6); INSERT INTO gearToOgre VALUES(230,112,4); INSERT INTO gearToOgre VALUES(230,111,2); INSERT INTO gearToOgre VALUES(231,113,4); INSERT INTO gearToOgre VALUES(231,101,4); INSERT INTO gearToOgre VALUES(237,7,6); INSERT INTO gearToOgre VALUES(237,5,4); INSERT INTO gearToOgre VALUES(237,1,4); INSERT INTO gearToOgre VALUES(234,3,4); INSERT INTO gearToOgre VALUES(234,113,2); INSERT INTO gearToOgre VALUES(234,7,4); INSERT INTO gearToOgre VALUES(234,2,2); INSERT INTO gearToOgre VALUES(236,1,2); INSERT INTO gearToOgre VALUES(236,2,2); INSERT INTO gearToOgre VALUES(236,7,8); INSERT INTO gearToOgre VALUES(236,103,2); INSERT INTO gearToOgre VALUES(236,105,1); INSERT INTO gearToOgre VALUES(248,2,8); INSERT INTO gearToOgre VALUES(248,4,30); INSERT INTO gearToOgre VALUES(248,6,3); INSERT INTO gearToOgre VALUES(248,7,18); INSERT INTO gearToOgre VALUES(248,110,1); INSERT INTO gearToOgre VALUES(249,112,2); INSERT INTO gearToOgre VALUES(249,113,2); INSERT INTO gearToOgre VALUES(249,7,6); INSERT INTO gearToOgre VALUES(249,5,2); INSERT INTO gearToOgre VALUES(249,2,1); INSERT INTO gearToOgre VALUES(250,5,2); INSERT INTO gearToOgre VALUES(250,2,4); INSERT INTO gearToOgre VALUES(250,1,1); INSERT INTO gearToOgre VALUES(250,7,8); INSERT INTO gearToOgre VALUES(251,2,6); INSERT INTO gearToOgre VALUES(251,4,20); INSERT INTO gearToOgre VALUES(251,6,5); INSERT INTO gearToOgre VALUES(251,7,12); INSERT INTO gearToOgre VALUES(252,1,1); INSERT INTO gearToOgre VALUES(252,4,4); INSERT INTO gearToOgre VALUES(252,6,1); INSERT INTO gearToOgre VALUES(252,7,4); INSERT INTO gearToOgre VALUES(254,1,1); INSERT INTO gearToOgre VALUES(254,4,4); INSERT INTO gearToOgre VALUES(254,6,1); INSERT INTO gearToOgre VALUES(254,7,4); INSERT INTO gearToOgre VALUES(255,2,4); INSERT INTO gearToOgre VALUES(255,5,4); INSERT INTO gearToOgre VALUES(255,7,8); INSERT INTO gearToOgre VALUES(255,100,20); INSERT INTO gearToOgre VALUES(255,102,5); INSERT INTO gearToOgre VALUES(257,1,3); INSERT INTO gearToOgre VALUES(257,2,6); INSERT INTO gearToOgre VALUES(257,4,18); INSERT INTO gearToOgre VALUES(257,6,3); INSERT INTO gearToOgre VALUES(257,7,12); INSERT INTO gearToOgre VALUES(257,113,2); INSERT INTO gearToOgre VALUES(260,1,2); INSERT INTO gearToOgre VALUES(260,2,2); INSERT INTO gearToOgre VALUES(260,4,12); INSERT INTO gearToOgre VALUES(260,6,3); INSERT INTO gearToOgre VALUES(260,7,4); INSERT INTO gearToOgre VALUES(260,3,2); INSERT INTO gearToOgre VALUES(260,111,1); INSERT INTO gearToOgre VALUES(264,1,1); INSERT INTO gearToOgre VALUES(263,7,4); INSERT INTO gearToOgre VALUES(263,2,3); INSERT INTO gearToOgre VALUES(263,1,2); INSERT INTO gearToOgre VALUES(262,3,4); INSERT INTO gearToOgre VALUES(262,7,8); INSERT INTO gearToOgre VALUES(262,6,3); INSERT INTO gearToOgre VALUES(262,4,12); INSERT INTO gearToOgre VALUES(264,2,4); INSERT INTO gearToOgre VALUES(264,5,2); INSERT INTO gearToOgre VALUES(264,7,8); INSERT INTO gearToOgre VALUES(136,2,4); INSERT INTO gearToOgre VALUES(136,7,10); INSERT INTO gearToOgre VALUES(136,3,10); INSERT INTO gearToOgre VALUES(136,107,1); INSERT INTO gearToOgre VALUES(136,106,2); INSERT INTO gearToOgre VALUES(131,2,2); INSERT INTO gearToOgre VALUES(131,7,4); INSERT INTO gearToOgre VALUES(131,100,8); INSERT INTO gearToOgre VALUES(131,102,4); INSERT INTO gearToOgre VALUES(134,1,4); INSERT INTO gearToOgre VALUES(134,2,12); INSERT INTO gearToOgre VALUES(134,4,32); INSERT INTO gearToOgre VALUES(134,6,4); INSERT INTO gearToOgre VALUES(134,7,24); INSERT INTO gearToOgre VALUES(133,1,4); INSERT INTO gearToOgre VALUES(133,5,2); INSERT INTO gearToOgre VALUES(133,7,6); INSERT INTO gearToOgre VALUES(130,1,2); INSERT INTO gearToOgre VALUES(130,7,2); INSERT INTO gearToOgre VALUES(130,101,2); INSERT INTO gearToOgre VALUES(269,1,1); INSERT INTO gearToOgre VALUES(269,2,1); INSERT INTO gearToOgre VALUES(269,7,2); INSERT INTO gearToOgre VALUES(269,101,6); INSERT INTO gearToOgre VALUES(265,2,2); INSERT INTO gearToOgre VALUES(265,7,8); INSERT INTO gearToOgre VALUES(265,8,1); INSERT INTO gearToOgre VALUES(265,109,2); INSERT INTO gearToOgre VALUES(265,111,2); INSERT INTO gearToOgre VALUES(232,2,2); INSERT INTO gearToOgre VALUES(232,7,6); INSERT INTO gearToOgre VALUES(232,109,2); INSERT INTO gearToOgre VALUES(154,1,1); INSERT INTO gearToOgre VALUES(154,2,2); INSERT INTO gearToOgre VALUES(154,4,4); INSERT INTO gearToOgre VALUES(154,6,1); INSERT INTO gearToOgre VALUES(154,7,12); INSERT INTO gearToOgre VALUES(154,109,1); INSERT INTO gearToOgre VALUES(154,111,2); INSERT INTO gearToOgre VALUES(132,1,2); INSERT INTO gearToOgre VALUES(132,7,2); INSERT INTO gearToOgre VALUES(132,101,2); INSERT INTO gearToOgre VALUES(100,2,2); INSERT INTO gearToOgre VALUES(100,7,6); INSERT INTO gearToOgre VALUES(100,100,24); INSERT INTO gearToOgre VALUES(100,102,4); INSERT INTO gearToOgre VALUES(118,2,3); INSERT INTO gearToOgre VALUES(118,7,6); INSERT INTO gearToOgre VALUES(118,100,24); INSERT INTO gearToOgre VALUES(118,102,4); INSERT INTO gearToOgre VALUES(271,2,2); INSERT INTO gearToOgre VALUES(271,7,8); INSERT INTO gearToOgre VALUES(271,113,4); INSERT INTO gearToOgre VALUES(235,2,8); INSERT INTO gearToOgre VALUES(235,7,8); INSERT INTO gearToOgre VALUES(235,113,2); INSERT INTO gearToOgre VALUES(235,3,4); INSERT INTO gearToOgre VALUES(20,110,1); INSERT INTO gearToOgre VALUES(266,1,4); INSERT INTO gearToOgre VALUES(266,2,8); INSERT INTO gearToOgre VALUES(266,4,20); INSERT INTO gearToOgre VALUES(266,5,6); INSERT INTO gearToOgre VALUES(266,6,2); INSERT INTO gearToOgre VALUES(266,7,16); INSERT INTO gearToOgre VALUES(266,8,1); INSERT INTO gearToOgre VALUES(181,1,2); INSERT INTO gearToOgre VALUES(181,2,6); INSERT INTO gearToOgre VALUES(181,4,8); INSERT INTO gearToOgre VALUES(181,6,2); INSERT INTO gearToOgre VALUES(181,7,16); INSERT INTO gearToOgre VALUES(273,1,2); INSERT INTO gearToOgre VALUES(273,2,2); INSERT INTO gearToOgre VALUES(273,7,8); INSERT INTO gearToOgre VALUES(273,101,6); INSERT INTO gearToOgre VALUES(11,1,3); INSERT INTO gearToOgre VALUES(11,2,3); INSERT INTO gearToOgre VALUES(11,4,12); INSERT INTO gearToOgre VALUES(11,5,6); INSERT INTO gearToOgre VALUES(11,6,3); INSERT INTO gearToOgre VALUES(11,7,16); INSERT INTO gearToOgre VALUES(10,2,2); INSERT INTO gearToOgre VALUES(10,6,1); INSERT INTO gearToOgre VALUES(10,4,4); INSERT INTO gearToOgre VALUES(10,5,2); INSERT INTO gearToOgre VALUES(10,7,8); INSERT INTO gearToOgre VALUES(10,1,1); INSERT INTO gearToOgre VALUES(9,1,2); INSERT INTO gearToOgre VALUES(9,2,8); INSERT INTO gearToOgre VALUES(9,7,12); INSERT INTO gearToOgre VALUES(9,6,3); INSERT INTO gearToOgre VALUES(9,4,20); INSERT INTO gearToOgre VALUES(276,2,4); INSERT INTO gearToOgre VALUES(276,1,1); INSERT INTO gearToOgre VALUES(276,3,4); INSERT INTO gearToOgre VALUES(276,5,2); INSERT INTO gearToOgre VALUES(277,1,2); INSERT INTO gearToOgre VALUES(277,4,20); INSERT INTO gearToOgre VALUES(277,6,4); INSERT INTO gearToOgre VALUES(277,7,8); INSERT INTO gearToOgre VALUES(270,1,1); INSERT INTO gearToOgre VALUES(270,2,2); INSERT INTO gearToOgre VALUES(270,101,4); INSERT INTO gearToOgre VALUES(153,3,2); INSERT INTO gearToOgre VALUES(153,7,6); INSERT INTO gearToOgre VALUES(153,8,1); INSERT INTO gearToOgre VALUES(153,101,4); INSERT INTO gearToOgre VALUES(153,112,4); INSERT INTO gearToOgre VALUES(278,1,1); INSERT INTO gearToOgre VALUES(278,7,4); INSERT INTO gearToOgre VALUES(278,5,1); INSERT INTO gearToOgre VALUES(279,1,1); INSERT INTO gearToOgre VALUES(279,7,4); INSERT INTO gearToOgre VALUES(191,3,8); INSERT INTO gearToOgre VALUES(191,4,20); INSERT INTO gearToOgre VALUES(191,6,4); INSERT INTO gearToOgre VALUES(191,7,8); INSERT INTO gearToOgre VALUES(191,8,1); INSERT INTO gearToOgre VALUES(191,100,24); INSERT INTO gearToOgre VALUES(191,102,6); INSERT INTO gearToOgre VALUES(191,104,2); INSERT INTO gearToOgre VALUES(191,105,1); INSERT INTO gearToOgre VALUES(191,112,2); INSERT INTO gearToOgre VALUES(281,2,8); INSERT INTO gearToOgre VALUES(281,7,8); INSERT INTO gearToOgre VALUES(282,1,2); INSERT INTO gearToOgre VALUES(282,2,4); INSERT INTO gearToOgre VALUES(282,5,4); INSERT INTO gearToOgre VALUES(282,113,6); INSERT INTO gearToOgre VALUES(284,2,2); INSERT INTO gearToOgre VALUES(284,7,4); INSERT INTO gearToOgre VALUES(284,100,15); INSERT INTO gearToOgre VALUES(284,102,3); CREATE TABLE ogreIcons( -- 20181115: replaced(?) by the blob table. -- -- ogreIcons is intended for storing a list of the base names of the -- system's available ogre image files, for use in selection lists. -- Note that ogre.icon stores a (base) file name, not an ID from this -- table (there are no IDs in this table). icon text, UNIQUE(icon) ON CONFLICT IGNORE ); INSERT INTO ogreIcons VALUES('default-nolabel.png'); INSERT INTO ogreIcons VALUES('default.png'); INSERT INTO ogreIcons VALUES('Doppelsoldner-nolabel.png'); INSERT INTO ogreIcons VALUES('Doppelsoldner.png'); INSERT INTO ogreIcons VALUES('Fencer-nolabel.png'); INSERT INTO ogreIcons VALUES('Fencer.png'); INSERT INTO ogreIcons VALUES('Flower-nolabel.png'); INSERT INTO ogreIcons VALUES('Flower.png'); INSERT INTO ogreIcons VALUES('FreeLove-nolabel.png'); INSERT INTO ogreIcons VALUES('FreeLove.png'); INSERT INTO ogreIcons VALUES('Lancer-nolabel.png'); INSERT INTO ogreIcons VALUES('Lancer.png'); INSERT INTO ogreIcons VALUES('MarkIIIb-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkIIIb.png'); INSERT INTO ogreIcons VALUES('MarkIII-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkIII.png'); INSERT INTO ogreIcons VALUES('MarkIIIx-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkIIIx.png'); INSERT INTO ogreIcons VALUES('MarkII-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkII.png'); INSERT INTO ogreIcons VALUES('MarkI-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkI.png'); INSERT INTO ogreIcons VALUES('MarkIV-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkIV.png'); INSERT INTO ogreIcons VALUES('MarkVI-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkVI.png'); INSERT INTO ogreIcons VALUES('MarkV-nolabel.png'); INSERT INTO ogreIcons VALUES('MarkV.png'); INSERT INTO ogreIcons VALUES('Ninja-nolabel.png'); INSERT INTO ogreIcons VALUES('Ninja.png'); INSERT INTO ogreIcons VALUES('Spartan-nolabel.png'); INSERT INTO ogreIcons VALUES('Spartan.png'); CREATE TABLE blob ( -- file/resource name name text PRIMARY KEY NOT NULL, -- size of the body field, in bytes size integer NOT NULL, -- mtime (Unix epoch) mtime integer NOT NULL, -- mime type for the body content mimetype text NOT NULL, -- optional role to be used by the app(s) to filter -- specific types of blobs (e.g. 'counter'). role TEXT default NULL, -- Body/content of the blob. body blob NOT NULL ) WITHOUT ROWID; INSERT INTO blob VALUES('Doppelsoldner-nolabel.png',474,1248125098,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000c504c5445000000ff00ffffffffbdbdbd370869db0000000474524e53ffffff00402aa9f400000001624b474403110c4cf2000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000e04944415428cfbdd1310ac2301406e09f7409597a85f05c4a26c1b590ab85ba842cbd4270929cc2d141e855a45d03f1a556747410bb7dfdffbe3c52948f073fc3e10bdc61df98a9f71f498f17a63265d8bc222fa5994fedf24cfa02c871da6a3d408d7d621126786c03b280d6dd96cc1229aaa6622997a820212d83e7ab6804625b6b7b073817b0e24a20050dbbaec42067c458bf71ce0d66187cad5d3a21903a44ae65dca56c1145e41a0f013a486338814a299da14e91374889137ea14706513866e983ae5b5ffdd9f28dd0ae62a686cff2c156e49bad777828bffc59ffc4038400bb08b0c7536e00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Doppelsoldner.png',529,1248125098,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000c504c5445000000ff00ffffffffbdbdbd370869db0000000474524e53ffffff00402aa9f400000001624b474403110c4cf2000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000001174944415428cfadd2318ac3301005d08fd40813d0158cb631ae16d20ae66ac2db1837b9824815740a819b140bb98ab05a81324abc6cca0dacbba7f91e8fc7467db9f06f38fe0109f48bcdd8f9a562f1835bbd155079a0e42ab7b3cecf8aad803addf698058ca427b21897197b8322d0f7c35ed91482ef6443aed1775050c4e0fe9d1f05bc6eb14f0738b7e081ab81e9d0831e23318c1bc5a9dde39c9bc6699a5b2c0e42200cf01c2b484a6978e139c64d80016a1cb9822e84704177f63c41085ce183fec43066f92a6a5efa36f575be106fc47c346c46f2b3e6851aca37b51d1eeb1b9f24512c32e9a4db6b676dc9969cebca5857226bd35adb12d7ac3523d28e03928c55538be903253e3b30a28e9691e47321effe2177c1c6987012d547f100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Fencer-nolabel.png',495,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000ff0000ff00ff808080ffffffbdbdbd00000000000089d05e5d0000000674524e53ffffffffff00b3bfa4bf00000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000e74944415438cbed92516e83400c4447aa7d8272904870804131fffea0f7bf4ac766134ad5fc575527288479ec78ed0d3e5e08ffe015d8b7fade7e0021739f36c0788d2ab252fe3af9b586484491777e2bbe978b89f765bb82acfc58690b4eb087c400ca26fc029484b8e1ae3bfd4b54ca8819b54cd709802562be99eacb3f812abfcdb31c58f967949ec3aa0c8ba87b3c8264541bfad0c847947659a82eab3d8ca884e7b14079d1553aaaf770a85aa1a9980f1043dda37c74e7d1eb5b4d0d3c66651243534850121863cf7a629f8eb59e07a5dff0312fbde3cfa3cd4c1f0370e917fd45ff2cf804b92d3d28576da16100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Fencer.png',551,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000ff0000ff00ff808080ffffffbdbdbd00000000000089d05e5d0000000674524e53ffffffffff00b3bfa4bf00000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000011f4944415438cbed92418e83300c45bf34f609868354820318d5ecbd80fb5f65be9dd09451bbebecc62020ff91efd8098e37817ff00eec5b3eb717c029eed306885dad92ac467d9df49a83c43dc9b7fd4abea78ac9eecb760591febe9a2c186077863990b2412f804ef01bee7c9b3e5905059f91d3780f002ceef34d989ffa00ccfc35cf5420a90f2b8e5d328d2561f5388d286419bc4ccc4e2bae3251de926be856018d36817e5e59caaad6d0224b316132edc07b548dd451957bcdaf282ab0d62b6198b30b016310f4b6478eac76472a1e1bc56f68ef17ffd1c7d64684f60628e32f0e1c9bcca61c79658fb20d1d307d7d69e423477a025427355f05ba5a9343a18d0f50dea1d1c0f19c83131a00ad1423078f4282a85529bafac1ca5fc70f03122608271c4f2200000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Flower-nolabel.png',608,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000467414d410000b18f0bfc6105000000206348524d00007a26000080840000fa00000080e8000075300000ea6000003a98000017709cba513c0000000c504c5445bdbdbd000000800000ffffff2eb16e5b0000000174524e530040e6d86600000001624b474401ff022dde000000097048597300000048000000480046c96b3e0000000774494d4507d9071417183bbec73f17000000cd4944415428cfd58f310e833010046d858496862612ca57e8d252644515f189a0ab90bf9027e51388eae44f105159173b80708352672b8ff6bcb7a7d40fe93282d333862a82f32d8263b51790ee42a1f6a08be111278fdb53eb51eb95ca2b274992cd905f39afb26555de78c05af3d2e66a85d4b46d39f74e546d1ac67c913eb27bd39d972edd34d89ae634216607fece1dccd45a0774c14a2d0f6251f73e4f436a183202ef00b803d46378796824a887784704412293ff43645169300728d8854ca2b035a5efb682b7d3ff4b1fd1ed512db1e3c57600000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e1550000002574455874646174653a63726561746500323031382d31312d30365431323a35393a31342b30313a3030d2663b680000002574455874646174653a6d6f6469667900323030392d30372d32305432333a32343a35392b30323a3030da6c660f00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Flower.png',653,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000467414d410000b18f0bfc6105000000206348524d00007a26000080840000fa00000080e8000075300000ea6000003a98000017709cba513c0000000c504c5445bdbdbd000000800000ffffff2eb16e5b0000000174524e530040e6d86600000001624b474401ff022dde000000097048597300000048000000480046c96b3e0000000774494d4507d9071417183bbec73f17000000fa4944415428cf9590316ac4301045354462ab8002594202c657916fb0853faa8cebf436aa8caeb8c59a54c29788d94a2892edcd2a0413f2bbc7cc9f3f338cfd2191c39bcae03587f7530647b537a0d8856e0fe833877306873b707e38737e6ba2b293526e4ba0eca0aaad04dba1aa37781e2e35dda0f0e348ab4552e36d8ff522fe62aea333eb46345fa77668dc020f7e3266d6fdd2f718dc879d813941694d1b06b488f384f60dbc0b1ed10ea00726e836810d49d03ece8af5281d82538cdc3440096d4c04163352b27329b5704b9a31f91f7eeb5831414c42a8e51c262b26159739f0b52d41fda372f7f0dcf3b47924d582d409dfdffe9fbe00ffb1582f5da871d100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e1550000002574455874646174653a63726561746500323031382d31312d30365431323a35393a31342b30313a3030d2663b680000002574455874646174653a6d6f6469667900323030392d30372d32305432333a32343a35392b30323a3030da6c660f00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('FreeLove-nolabel.png',678,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003008000000007269a65b0000000467414d410000b18f0bfc6105000000206348524d00007a26000080840000fa00000080e8000075300000ea6000003a98000017709cba513c0000000274524e5300bdc343020900000002624b47440000aa8d2332000000097048597300000048000000480046c96b3e0000000774494d4507d9071417183bbec73f17000001294944415448c7ed95c18ec4200c439f57fdb2cd77677ecd732050a0ed612e2bad349cdac476e200ad92cfd6cf87f82fe10f09c17354799fc9a7a0f2492cf7408bdc102277ca09bf2344e556230376359db92802d8e7f35221b217c959dfc203b7b6743268a20223acc1d83c440693bc8ba393b19b8e26387a392b94ab63c70b4b1d694006596091d729096464db925123216c415c2af446d4e932b2708fec1572345e7332025beae98b07d4dd52ed20ec1a70ae8468260aaf72d1e6d406b55408ac591f8d8d03b9067b4ce2f91ac0b16dfdb519ea2d45395a0ee8188c8541365a4dff626e578793dd43076ac50d7edb8c76888e9a8765d9322514531880571dba032007a3e090275e66ba4e55285a6abdfad1f1f3912ed3a9546afbb8b4602ae7b0be7fa02fe1df10de1d4da29d849ac50200000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e1550000002574455874646174653a63726561746500323031382d31312d30365431323a35393a31342b30313a3030d2663b680000002574455874646174653a6d6f6469667900323030392d30372d32305432333a32343a35392b30323a3030da6c660f00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('FreeLove.png',753,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003008000000007269a65b0000000467414d410000b18f0bfc6105000000206348524d00007a26000080840000fa00000080e8000075300000ea6000003a98000017709cba513c0000000274524e5300bdc343020900000002624b47440000aa8d2332000000097048597300000048000000480046c96b3e0000000774494d4507d9071417183bbec73f17000001744944415448c7ed954b721c310c431f527db2f0dcf0d5e0857e2df54cc55ed8ab6831a5a6009220298dccf7d69f6fe2ff137e9150bcb7caaf4ffcce28bf73e6d3d02c2f08e593b2e0af08d5cf762113f6146d6f1e0192b5df22944710dffd4764e2f6941683e6541044341987867271739fced1629ca2ab399cb9ac085dd575e245a4810ca0802288f0b34a0205258914d4488844508f0823110dba8222322c6704cfc47b9d822091c6f143031a6ae9e920925e60ef846a223a5e5d45ab532bd416a188eefed16c1c28bdb0d7cdb93f2670b66d7c364123a5ea8ab6019d8589082841bbe8bf84976bc0f1d03080da7193df9ad186e8eaf588a244a13baa9b19808f3e74178027a3c3c10baf70bb4e3d50b5a3fdead7c0df47ba8bb62ceb785c9ad1f2ddac1fff07ba4697dbeb32b6785cf0c294dbdd9da3e1de68cfed12eef932f891928b7faf314b6ede28c6cf63d51a0dafef33a57b02474afe52465fd450ebe47c35aadf8b3e807661dc95e1dfe8f4cf133e01e499c7c5698cc4ef00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e1550000002574455874646174653a63726561746500323031382d31312d30365431323a35393a31342b30313a3030d2663b680000002574455874646174653a6d6f6469667900323030392d30372d32305432333a32343a35392b30323a3030da6c660f00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Lancer-nolabel.png',465,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000c504c5445000000ff00ffffffffbdbdbd370869db0000000474524e53ffffff00402aa9f400000001624b474403110c4cf2000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000d74944415428cfc591316ec4201045bfc6cd8866af804863d1ee01b81af236c8cd5e0139cd8a536c992292af62d92d1299c15b24758aa540bcf95f5f1f40fbb5f03ea87f94d027278455b6e305ebb1e1b2bee0a8c067e8109a9c89cf80b53d4b1edda91c03c1c774ef5073421cddd061676b7c620e0a1b99bc8cc8970e0cc4c5a043b5ccd394d16d7bb4eca3a7bb022192a129a96d8b044002c45687a7942999b2d82444e7ecbd2830a59407cc92a54129a2c8c06a37e7e65be5345bbdc2577a84b63bf7a1b04bdd56d31c14eab73ecdf5fadecffa07fc002400c8607702fc7500000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Lancer.png',465,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000c504c5445000000ff00ffffffffbdbdbd370869db0000000474524e53ffffff00402aa9f400000001624b474403110c4cf2000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000d74944415428cfc591316ec4201045bfc6cd8866af804863d1ee01b81af236c8cd5e0139cd8a536c992292af62d92d1299c15b24758aa540bcf95f5f1f40fbb5f03ea87f94d027278455b6e305ebb1e1b2bee0a8c067e8109a9c89cf80b53d4b1edda91c03c1c774ef5073421cddd061676b7c620e0a1b99bc8cc8970e0cc4c5a043b5ccd394d16d7bb4eca3a7bb022192a129a96d8b044002c45687a7942999b2d82444e7ecbd2830a59407cc92a54129a2c8c06a37e7e65be5345bbdc2577a84b63bf7a1b04bdd56d31c14eab73ecdf5fadecffa07fc002400c8607702fc7500000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkI-nolabel.png',447,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000b84944415438cbed92c10dc33008457f8507483741220320b5fbcf54302649e370684f3dd4be583c3f302478160bbf055000bdb7022c05b82d280c14465d9c3f05540095760500e2d9405f33500b42186fc082a0be817606e830e37b2aa500f3f7484bcfb3f2c2229bb4ab0c92211d8145c3f04aed30641362c35326d0ec82cc93e805e33d43708349d60dc8583d95d0301ee103e302650d65f6cb766896cc5bc9e26445391ab623efcf352587e776bbfe7da621fec1d7e005b1b703e22120aaf000000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkI.png',502,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000ef4944415438cbcd93518ec3300844a78203746f82c41e006973ff33ed601b2769ea8ff4ab7664119e070c4eb02d06be0b6001e24717e0b9008f27160a2c14ebe47617c80284eb3b00885d1568e30a824eb8e104e884b409e82b4083e5df43857470bd8f52c56baf32b1fb14ed5283f8101d01bd5d9199f4d0640afa44862c10558550e7bd168cf30c412a4cfc77021fa38572198abfae07c606a91c61969b6928836529955c98d47ac1346d3f2e25d5bc54eb5ea06a35759a1ffe06c1f3f0c9af33d21327c0d84a63d30380a27995aa7276c057f62501572e27b045e6e87482b68bb79da9710c35819ec1fd026f817f28eaf4a7e0a2875d00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkII-nolabel.png',465,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000ca4944415438cbed934b0ec3300844a78203a43741e20248f5fdcfd40137e92766d14577455e183fcf805182d1047e05d080b86a03b6065c36340a348abeb87d0ba405ba06e14b1013c459a162aca16ba0b1a81180a99e40a8b8939c15307108ce358c2518c0a795c3898444df00dc5c045c93e0a8609e4602774bb23bf2b6e46d364689ed803952813a66775a802f935a74324f2bb6863a9fa709a412f707f0679415a749709be90c49c86196c2cab8e63582bd192618dcfb31bdbcb6b7cbfdcb979692f1c31fe70f1877514604c869c26de100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkII.png',522,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000001034944415438cbb592eb0dc3300884af8201da4d905800a9d97fa61e38cea38e2be5479115d97c7060622c13c3bf0026205e3a01cf09783c31c9c024635edcee029902bd06e197201a883143c55843af81c6458d004c7500a1e24e3266c0c421186b184bd0806f29871309899e00dc5c045c8d60ab609e4202774bd215192d19cdc698621df08ccc40b9d99d16e0cda41695cc538aada1fccd9b40eae0be02dfada4384d82773b3693841c66655809d7bc96606f860616ee7d9b5e86f576b93fbcb44ce937d7fd37302c62782547fb09a2dad17cd2516de653d900cb687af400a028af322b4a052be0917349c02f3f27c0366bd87a042d8a425d65007a06f72f780f7c00d0c2f4e5259880b100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIII-nolabel.png',478,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000d74944415438cbed93590e83300c44a7b20fd0dec4927b007f70ff3375ec10163591a0dfb5220179335e08609904ae81d009783c670063102fe8d88189635e5cee82b0e5269029d031081f826820be1d2ac61a3a061a1d1d4000a6da7736102aee28cb11f0edc1c421d0c0c9116a2cc100da347b2a871309899d00dc5c045ccdd201cc3c13091cc803eecd512da96663b458ef3a65e940e9b34e014e26b59849388d672ee4a7b1ee16e08513bd57e07b583d96c3cbdca3a8548d6cc74a199986b182c85bebe7506d4b6b3707d80eb5647af9c7f9839fc0070ac6fde1778a26ea00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIII.png',534,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000010f4944415438cb95936b8ec3300884670507d8bd09123d003f7cff33ed80edd45663a9a1911bfb63788404ed60f80e841ec0cfef09e01ec41ff45e8183e29c5c9e82b0f610c811e83d08bf05d1417c2a548c39f41e684cb480004c759e5c2054dc519215f0e9c1c421d0c0a60835a6a001bd9b7728871309896d006e2e025e5d3201cc3c03091cc801cfe2e82de9cdc228b15975baa502e59f790ab033a98b9184dd78c642be1ae3b400ffd8d16b007f9bd5b6145ee26945a5726439569e9161680344deda9c43952dbddc6ce01a6ab98d06239657b329ad7dfd45ed20724cc101711dfbeb4619b969ee750150d4a9521515a4ff1ab8656b09b872d9006bae47aa2be85e0c34f71f4077f0bcc187e01f0ae7ec31df03e44800000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIIIb-nolabel.png',481,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000da4944415438cbedd3610e82300c05e067da03e84d9ad4033481fb9fc9b79609215b02fe763f74eedb6b8700d6c9c035089dc0e339038c215ed0710293c4bcb9dc85b0f526c814740ce14388823883ae2a66edfb0491a0d1692fa5e104ed2b871ee1828c9c408420d0c001581604b018505753100bccdc9cca891d4a8989797ed03252b0b80b0fdb5260a4dde00da409cc1bb08bf553b304b75359aaadf3de3708c0599b2b8c518999408d2ad276c3e4bd81efc3f267263cc37da44af6605dc9a6d92d0f5d10797efdfe659297889aefcf6c6ed3cb2fce1f7e820f1cbcff7c9a38721700000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIIIb.png',545,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000011a4944415438cb9dd3016e83300c05d03fd907d86e62c93dc0979afb9f69df0e148688d42e9568c2c3764202c6a2e13da02fe0eb7b05b807fec0ef23b0885817b74f81313e045b82df03f316388157f0e11651ff17608373a723953305bedf39d5601a3ae4026602831327505a08a064c05ccd043e1191915275e294cac222fb22eb9009cf4cd3642b0a0aa90ddec04a1059a02ab1cf5a29f4b854a9eabef6be80402ab7ee284c2aec08cc3693d4d3087b6c90478b1e764476f0de5aad6b28af75d1aed6939ec09ebfbf5e99f51231fbc799edc7b60592a7a3395c6dbcfd45fd85b9cafe045c39b5f9e40bd4651d148e03086d668dd4afb2a06342cd42af4d405dbd013be887ea72030debf3525fa32a3d0757c001f8df023f845ff950eac8cd210ae100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIIIx-nolabel.png',478,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000d74944415438cbed93590e83300c44a7b20fd0dec4927b007f70ff3375ec10163591a0dfb5220179335e08609904ae81d009783c670063102fe8d88189635e5cee82b0e5269029d031081f826820be1d2ac61a3a061a1d1d4000a6da7736102aee28cb11f0edc1c421d0c0c9116a2cc100da347b2a871309899d00dc5c045ccdd201cc3c13091cc803eecd512da96663b458ef3a65e940e9b34e014e26b59849388d672ee4a7b1ee16e08513bd57e07b583d96c3cbdca3a8548d6cc74a199986b182c85bebe7506d4b6b3707d80eb5647af9c7f9839fc0070ac6fde1778a26ea00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIIIx.png',667,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000467414d410000b18f0bfc6105000000206348524d00007a26000080840000fa00000080e8000075300000ea6000003a98000017709cba513c0000000c504c5445bdbdbd000000800000ffffff2eb16e5b0000000174524e530040e6d86600000001624b474401ff022dde000000097048597300000048000000480046c96b3e0000000774494d4507d9071417183bbec73f17000001084944415428cf9dd14d6ac42014077005ed6c1dc86c0aa1575148e86a20813c5c8997687015e60a73a41ea29295cc251a6615ec3399b4420985be8dfe78f1ef4708f9a3a8ccf074cdd16478ee32f0662fe0b08b92ec61c8f196277f667384f8d66b203283fad1c9547c9b1797e9635b53f071ead5e3dcf43c8400db562f7618bd79c0de9ceef51ac7c31cb485f5e6d6b9de1a18528b4f66f616b4c73c0abd06ef2e11b003d01b8487f11d61632a0f113b3142aa18efb8c6b99b87138490508639653ae77038b865b732a4abd3e3720e56e5eff8fb0752d9005152a8054a08a9c8025e2b269a8ab4b510841f7927daae686b26118c0155088a9fd1aa6894926b27a14d1082fca3be00d42d59c859d7dee900000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e1550000002574455874646174653a63726561746500323031382d31312d30365431323a35393a31342b30313a3030d2663b680000002574455874646174653a6d6f6469667900323030392d30372d32305432333a32343a35392b30323a3030da6c660f00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIV-nolabel.png',482,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000db4944415438cbed93510ec2300c438d9c03c04d2285034462f73f134e36e840ab047c938fa9eb8bedb4dab04c0a9f81b409389d6700c7202fb06305268a7938bf05e9cb97805360c720a3804d40be2bac223cf138fc13e40ee48b95656ca06f7280cc20fab2f215900254376c00ad200099c9cb46782e700f0f512d7c37159d1efd10e32e23821ab65490a4cc56706311781400e8b60159a85d5456b55f87a96820e4ad1dc944a306437d1a5dab4975c379dd408cf27e6d45b4f8514dd919f26587765a0fbd82ecf9ed7965ec23625d8f6fb6dbece31fe70f7e0277ce7bfda36685e39600000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkIV.png',548,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000011d4944415438cb9d92d16dc6300884af8201da4d90e8002735fbcfd4032771fe2aae9afa21b2f3c11d60635b2cfc0dd017e0ed7d05700ff801bfcfc022636d6e4f01637b086c09fc1e300bf802f0678697451047f327e005f045ca993be8494e40a6a187c5576026608a864fa01d04203169f934e786888c14d5262e555958647fc4ece291692ab6b2a094121be0cb8a20b20060e13b9084c2452555ffab99b20652dafaa334d1acc2504fa3d710a968847dee20e78a3e764676f2b19a5a7b48d7dab4ddbae801d8f5fb3932eb1631f6f3cd76d8de2079799a9bfb65ba37eb37c0ba323ae5c33a7b977400e9ba36756502c31c8efeebca62dd78df7c011dd559819aeac02750cd3dd20a277650d91db9a10fc7f399c007d8fedde043f00d2ab0ebcb99161e2800000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkV-nolabel.png',481,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000da4944415438cbed93610a83300c85df480eb0dd24901d2030ef7fa6bda4d68a58d0fd5e8452f3e5e5c5aa5826816b2074021ecf19c0398817f45c8189626e2e7741d87213c814e872fa1ce1a72012703902168b596c120c41024a56345a693881f6ccce235c509203102110686007d816046033a01d18566798b93929b8dbb51213f3b610ea00eec2615385bcb4838f2481790188f5a9d982e5a4b4c93cdf7d82009cbecc50464a580ab4b05c24ab61f25e818fb0ba2d8597b84751290ff695324d33d4d00d44cdafdb9165b471b919df6c95e9e51fe70f7e025fe62bfeb2e2dc6e1000000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkV.png',547,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000011c4944415438cbad93016ac4300c04b7480f687f22d03d60a1f9ff9bba9293383d627a0755c0241eaf56726c6c8bc06b80be001f9f2b807bc02ff8bd020bc5dadcde058ced4d604be0db6d1fcc5bc0021a9e81165b044f09a6a080243b9aa99c29e0c7ccc5836968c9133013303871014a0b01281930360cbb33223252147abba4b2b0c83108fa0499a6624b857afc00df5604910d607154ad145a2e2a9b9ad7bf2f4020e5ab19c944055b81115183d56a843d769033a23f5b912d3ea2a9b587f25a9b9619bae801d8f5fbb96515a35cbdcc33dbcbf606c9cbd1dc5cb1bd7ca39ec068b3ef802b296b3801ebe0e8a4b0ee028782d0df64cd612b5f3a76506568df04d8bb7754d5404fb5de329c404bbd12f8f4fd0d3000ffece39fc00f6504ed0a7168233400000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkVI-nolabel.png',484,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000dd4944415438cbed935b0a83400c456fb95940bb9340ba804067ff6bea9de8a850076cbf1b4174ce9c3c7ca04d02d740da04dcee338073900fd8b98189312fce6f417afb0a58e314583b9b2333e6205b9e00c0735356a09dc608485911b6ca7006cdc6ca0052e8e16e1f358c08804a8603505a48a01441db413684120548b5e68754742abc5b82b683d082f2c8423f6c80579f4149a280ca8dae595b45bd738a15d0b390a0b29a90a282656009ef27f6dd729f2b883dbc6ecb8892471465d5a8093aeac5349efb0ab2fa1fef81154bbbbad8bfd9da66977f9c3ff809bc010baffcfd4a46709300000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('MarkVI.png',547,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff00ffffffffbdbdbd000000000000000000e3ea88850000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000011c4944415438cb9593016ec4300804b78207b43f41e21e8054feffa62ed84e525d2c5d4874493c5e606d1f7213f80c846ec0d7f70ee01ec40ff45e818d625f5c9e82b07c0434650b34ef7c44f81e44c60d002c0ec9049ca9e20e4a26c25119262eaa6b64014ac4dc4cdf6aa8c00161325c00d38202a184504f1009672287085bb34b2a316158a908f504ce01e6a10a75e902bfe58149bc01cbadaea5a7925a71216bc0b5a08065e95048095b8111563f52b3a97d4de067587fb6c25bbca2a9748d7650a88ad19ed904d1fdaf7d908ed12e5fce33dbd3a6c188cbd14c65e4c7ffa8ffa0f69b77b04eb42f5e7a00e6edb3d3657500287a54a9aa1d079f03f093d60a94c9a217c09e7b494b8605f84427c8b112fa0674eccf02cf0d3e047f6d3deb256bf8e11600000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Ninja-nolabel.png',362,1248200984,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b4000000017352474200aece1ce900000018504c5445ff00ff000000515151ffffffbdbdbd000000000000000000ec34296d0000000174524e530040e6d86600000001624b47440088051d48000000097048597300000b1300000b1301009a9c180000000774494d4507d90715121d2cfe14eb1b000000be4944415438cbed53410ec3200c83be00930f94fc20caffffb69030dab26ea71d6b2135d8b1d3546a4a0f30ab5c2e42b92d7bdf4df55b3802be0a257d6401288b90fd10d12af41bc281abd4834a6a3d6e995e36950d250bf665c1060769bbf00ca81fa0f289dfbc59dc61618730729c36cfd9a046056dce69699d22118cc43a0d460991d3564b9d1348146110b60f33841cd944aaa0cad61133e26dd44595caf41e61d6488f67038f0dcd3ae21d95793f2dc7ccb1244f9e573cffd8bff002a68f1bfe292b38260000000049454e44ae426082'); INSERT INTO blob VALUES('Ninja.png',514,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000515151ff00ffffffffbdbdbd000000000000000000c877aeaa0000000574524e53ffffffff00fbb60e5300000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000fb4944415438cbe592e1adc3200c840fd90360a98358620147cafe33d5d8a401aa4aaddecf475002fe7c070ee0fcd0f07fc03d325ea67c2ec3296f1d7d016eaf8f8037e089007803169d8876d0674805c66432e2b376bb587d2af0687a804df1d80aac8846ad2e6b08d0a20345267044b286c2cd6e307c22ec9a177041f350865df9b840ed2152c5702c031cf0901245d8c77a81ea590d2950f11f3380a537516ba0229e916be46e5ac0a645e8da954bd33dbf1522095c3aeca31591516014272259a444bc03d9db9faea8f9c31607cf79432fc01d70029e0060c6fe8aa3e7e9c2c1e0c0105a60026707fd65b9d41bc8cf3be8976a01bf17f80b78024056eb583c46d0fc00000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Spartan-nolabel.png',448,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff0000ff00ffffffffbdbdbd000000000000ac5acd030000000674524e53ffffffffff00b3bfa4bf00000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000b84944415438cbed92410ec25008442766388037f0282ce89e85bdff551ce8afbf89756b8c719a9096c7c0ffa458df087ff04190ab9d03cb1307b026ec15e4f5668c13409496c40158f571205ce16213e40a972140c59b1f5ab1f20a1e14b4094209b87b38eab11ddc196a038f06b2da00ec52510f545e372a901a5b06304851c1766093576055cbbb0c1053de9fed8836ef6aca9ea1beeca135acceec03649f7f5f1e5bdb71f5f2dcf656362e989936976cd2b7fd573f071eb0624673415334e100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('Spartan.png',448,1248125099,'image/png','counter',X'89504e470d0a1a0a0000000d4948445200000030000000300403000000a52ce4b400000018504c5445000000800000ff0000ff00ffffffffbdbdbd000000000000ac5acd030000000674524e53ffffffffff00b3bfa4bf00000001624b474407166188eb000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c57000000b84944415438cbed92410ec25008442766388037f0282ce89e85bdff551ce8afbf89756b8c719a9096c7c0ffa458df087ff04190ab9d03cb1307b026ec15e4f5668c13409496c40158f571205ce16213e40a972140c59b1f5ab1f20a1e14b4094209b87b38eab11ddc196a038f06b2da00ec52510f545e372a901a5b06304851c1766093576055cbbb0c1053de9fed8836ef6aca9ea1beeca135acceec03649f7f5f1e5bdb71f5f2dcf656362e989936976cd2b7fd573f071eb0624673415334e100000025744558746372656174652d6461746500323030392d30372d32305432333a32323a34322b30323a30300bb9e15500000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); INSERT INTO blob VALUES('default-nolabel.png',254,1248130315,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c1114000000017352474200aece1ce90000000c504c5445ff00ff000000bdbdbd00000043accbae0000000174524e530040e6d86600000001624b47440088051d48000000097048597300000b1300000b1301009a9c180000000774494d4507d90714163337c0c3e4620000005e4944415428cfddceb10dc0200c0440bba04f81f7211b18c9bfff2a0944465684cb34f98a93f52f883e8fa668199832941492026182115a055a6bc0b17e07583fbd31e28372bf4d03d02274f5477c187e1260037b831d98b0675ee907b90076cf1e2f82be8e9d0000000049454e44ae426082'); INSERT INTO blob VALUES('default.png',375,1248201003,'image/png','counter',X'89504e470d0a1a0a0000000d49484452000000300000003002030000002a6c11140000000c504c5445000000ff00ffbdbdbd0000004f8b2ba40000000374524e53ffff00d7ca0d4100000001624b474403110c4cf2000000097048597300000048000000480046c96b3e0000000976704167000000300000003000ceee8c570000007e4944415428cfb5d0310ac3300c05d08fa7a253844c41a714197d0a9149f89475ac383121a294524d7e7cfe1f8c321cfe020ac111ac44d01012026dc261682d8782d67540a60e20bd1687613f3912a9ef4403c0237ad23a70a8832a047840bac33ad0907c9ebefa7812513e601be7b99c98442f2c57523b79e2cfd3bfe00d3d063b94e1ff63f300000025744558746372656174652d6461746500323030392d30372d32315432303a32393a31362b30323a30305c54cd8a00000025744558746d6f646966792d6461746500323030382d30332d31365430323a33323a34322b30313a30304580a1250000000049454e44ae426082'); DELETE FROM sqlite_sequence where name in('ogre','gear'); INSERT INTO sqlite_sequence VALUES('ogre',284); INSERT INTO sqlite_sequence VALUES('gear',113); CREATE VIEW v_overview AS SELECT -- Overview of Ogre o.id as id, o.isOfficial as isOfficial, o.name as name, o.mp as mp, (o.tump * o.mp) as 'Treads', o.ciscos as ciscos, (o.ciscos / 10.0) as 'Cisco Armor Value', (o.ciscos * 0.6) as 'Approx SJG VP' FROM ogre o order by -o.isOfficial, o.ciscos, o.name ; CREATE TABLE ttr_ogre_ciscos ( -- Insert an Ogre's ID into ttr_ogre_ciscos to trigger a -- calculation/update of ogre.ciscos for that record. oid integer NOT NULL, FOREIGN KEY(oid) REFERENCES ogre(id) ON UPDATE CASCADE ON DELETE CASCADE, UNIQUE(oid) ON CONFLICT REPLACE -- Hmmmm. This FK constraint is not being honored, even with pragma foreign_keys=on: -- insert into ttr_ogre_ciscos (oid) values(999); ); -- CREATE TRIGGER tr_ogre_delete -- Not needed since the addition of FOREIGN KEY constraints. -- BEFORE DELETE ON ogre -- BEGIN -- -- Delete all of an Ogre's gear when the Ogre is deleted... -- DELETE FROM gearToOgre WHERE oid=OLD.id; -- END; CREATE TRIGGER tr_ogre_ciscos AFTER INSERT ON ttr_ogre_ciscos BEGIN -- Calculate current ciscos/VPs for an Ogre whose ID was -- just inserted into ttr_ogre_ciscos, update the ogre -- table, then remove the entry from ttr_ogre_ciscos... UPDATE ogre SET ciscos=( with g_ciscos(c) as ( -- count the gear ciscos for this ogre... select go.c*ge.ciscos from gear ge, gearToOgre go where go.gid=ge.id and go.oid=NEW.oid ) SELECT round( 5.357 * (ifnull((select sum(c) from g_ciscos),0) + (2*(o.tump*o.mp))) / (10 - o.mp) + ifnull(o.ciscosFudge,0), 2 ) FROM ogre AS o WHERE o.id=NEW.oid ) WHERE id=NEW.oid; DELETE FROM ttr_ogre_ciscos where oid=NEW.oid; END; COMMIT; PRAGMA foreign_keys=ON; select 'cleaning up...'; BEGIN; -- Contemplating... -- delete from ogre where isOfficial is 0; -- delete from gear where isOfficial is 0; COMMIT; vacuum; select 'done.';