CREATE TABLE games (
    id      INTEGER PRIMARY KEY NOT NULL,
    name    TEXT NOT NULL,
    name_id TEXT NOT NULL,
    api_access_options  INTEGER NOT NULL,
    autocomplete        BOOLEAN NOT NULL AS (api_access_options & 1) -- 1 = Allow third party api access
);

INSERT INTO games (id,name,name_id,api_access_options) VALUES (2,'Sinespace','sinespace',3),
 (5,'0 A.D.','0ad',3),
 (6,'ECO','eco',3),
 (11,'Mondrian - Plastic Reality','mondrian',3),
 (34,'Aground','aground',3),
 (51,'OpenXcom','openxcom',3),
 (63,'Foundation','foundation',3),
 (77,'Meeple Station','meeplestation',3),
 (102,'Hard Times','hardtimes',3),
 (106,'Space Station Designer','spacestationdesigner',3),
 (135,'Avis Rapida','avisrapida',3),
 (139,'Trains & Things','trainsandthings',3),
 (152,'Totally Accurate Battle Simulator','tabs',3),
 (164,'Playcraft','playcraft',3),
 (166,'Ghost And Sword','ghostandsword',3),
 (169,'MORDHAU','mordhau',3),
 (187,'Holodance','holodance',3),
 (202,'Descenders','descenders',3),
 (214,'Hypnospace Outlaw','hypnospace',3),
 (224,'Tyler Presents: Mischief Night','mischiefnight',3),
 (227,'Bridge! 3','bridge3',3),
 (231,'Tabletop Playground','tabletopplayground',3),
 (242,'9 Nations','9nations',3),
 (243,'Doodle Derby','doodlederby',3),
 (251,'Contractors VR','contractors',3),
 (254,'Insurgency: Sandstorm','insurgencysandstorm',3),
 (263,'OpenMB','openmb',3),
 (264,'Space Engineers','spaceengineers',1),
 (295,'Dashpanel','dashpanel',3),
 (296,'DUSK','dusk',3),
 (304,'Fun with Ragdolls: The Game','funwithragdolls',2),
 (306,'SnowRunner','snowrunner',3),
 (323,'SCP: Recontainment','recontainment',3),
 (324,'Mount & Blade II: Bannerlord','bannerlord',3),
 (333,'SWORDS of GARGANTUA','swordsofgargantua',3),
 (364,'Nuclear War Simulator','nuclearwarsimulator',3),
 (382,'Songs of the Eons','sote',3),
 (385,'The Snowboard Game','tsg',3),
 (508,'Cortex Command Community Project','cccp',3),
 (563,'Artron','artron',3),
 (594,'VERTEX','vertex',3),
 (629,'Skater XL','skaterxl',3),
 (634,'Old World','oldworld',3),
 (685,'Neanderfall','neanderfall',3),
 (715,'WDC','wdc',3),
 (721,'Vinyl Reality','vinylreality',3),
 (789,'Bit Jail','bit',2),
 (802,'Fdwall','fdwall',3),
 (885,'Gunroyale','gunroyale',3),
 (943,'Quantum Engineering','qe',3),
 (971,'Jet3D','jet3d',2),
 (1141,'World of Padman','worldofpadman',3),
 (1199,'Songs of Syx','songsofsyx',3),
 (1312,'Ice Temple','icetemple',3),
 (1331,'Golden Creation','goldencreation',3),
 (1393,'Desperados III','desperados',3),
 (1554,'VR Simulation','vrsim',3),
 (1582,'Sketchbots','sketchbots',3),
 (1608,'Distant Kingdoms','dk',3),
 (1650,'Bunny Dance','bunnydance',3),
 (1673,'Our Republic','ourrepublic',3),
 (1692,'Actor Tycoon 2','actortycoon2',3),
 (1707,'SMX: Supermoto Vs. Motocross','smx',3),
 (1895,'Dream''s Reach: Village of the Gods','dreamsreach',2),
 (1947,'On a Roll','onaroll',3),
 (1986,'Words of Power','wop',3),
 (2068,'Astonishing Basketball 22','abk21',3),
 (2310,'No Plan B','noplanb',3),
 (2340,'Battle Talent','battletalent',3),
 (2453,'Solasta: Crown of the Magister','solasta',3),
 (2454,'OpenNox','nox',3),
 (2475,'Deep Rock Galactic','drg',1),
 (2482,'Go on Forever','gof',2),
 (2487,'The Architect: Paris','tap',3),
 (2514,'C&C: Generals Mod Launcher','genlauncher',3),
 (2558,'UAlbion','albion',3),
 (2578,'BMX Streets: PIPE','pipe',3),
 (2585,'APICO','apico',2),
 (2599,'Humankind','humankind',3),
 (2649,'Songs of Conquest','soc',3),
 (2668,'Super Dungeon Maker','superdungeonmaker',3),
 (2691,'Fireworks Mania','fireworksmania',3),
 (2712,'Assistants App','assistants',3),
 (2717,'Bus Simulator 21','bus21',3),
 (2748,'SelfDefender','na1634743852',3),
 (2763,'Shanaq','shanaq',3),
 (2773,'Colonization','colonization',3),
 (2795,'Parkitect','parkitect',3),
 (2800,'SYNTHETIK 2','synthetik2',3),
 (2804,'Be The Owner','bto',3),
 (2816,'Amberial Dreams','amberial',3),
 (2824,'Astonishing Baseball','ab',3),
 (2869,'Melvor Idle','melvoridle',3),
 (2872,'Floppa and Pelmeni','floppa',3),
 (2886,'MegaGlest','megaglest',3),
 (2887,'Pyroworks','pyroworks',3),
 (2976,'True Skate Mobile','trueskate',3),
 (2978,'shapez','shapez',3),
 (3013,'OutBreak','outbreak',3),
 (3020,'Besiege (PC)','besiege',3);

CREATE INDEX games_name ON games (name COLLATE NOCASE);
CREATE INDEX games_name_id ON games (name_id COLLATE NOCASE);