 
 
 --
+-- Name: fittingbeacons_pkey; Type: CONSTRAINT; Schema: osmium; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY fittingbeacons
+    ADD CONSTRAINT fittingbeacons_pkey PRIMARY KEY (fittinghash, presetid, typeid);
+
+
+--
 -- Name: fittingchargepresets_fittinghash_presetid_name_unique; Type: CONSTRAINT; Schema: osmium; Owner: -; Tablespace: 
 --
 



--
-- Name: fittingchargepresets_descriptioncontentid_fkey; Type: FK CONSTRAINT; Schema: osmium; Owner: -
--


            'booster'::text AS category,
            (invboosters.boosterness)::text AS subcategory,
            NULL::text AS other
           FROM invboosters
        UNION
         SELECT invbeacons.typeid,
            'beacon'::text AS category,
            NULL::text AS subcategory,
            NULL::text AS other
           FROM invbeacons) t
     JOIN eve.invtypes it ON ((it.typeid = t.typeid)))
     JOIN eve.invgroups ig ON ((it.groupid = ig.groupid)))
     LEFT JOIN eve.invmarketgroups img ON ((img.marketgroupid = it.marketgroupid)))
