     string_agg(DISTINCT (fittingtags.tagname)::text, ' '::text) AS taglist
    FROM fittingtags
   GROUP BY fittingtags.fittinghash;
+
+
+--
+-- Name: fittingbeacons; Type: TABLE; Schema: osmium; Owner: -; Tablespace: 
+--
+
+CREATE TABLE fittingbeacons (
+    fittinghash character(40) NOT NULL,
+    presetid integer NOT NULL,
+    typeid integer NOT NULL
+);
 
 
 --



--
-- Name: fittingchargepresets_fittinghash_presetid_name_unique; Type: CONSTRAINT; Schema: osmium; Owner: -; Tablespace: 
--




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

ALTER TABLE ONLY fittingbeacons
    ADD CONSTRAINT fittingbeacons_fittinghash_presetid_fkey FOREIGN KEY (fittinghash, presetid) REFERENCES fittingpresets(fittinghash, presetid);


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

ALTER TABLE ONLY fittingbeacons
    ADD CONSTRAINT fittingbeacons_typeid_fkey FOREIGN KEY (typeid) REFERENCES eve.invtypes(typeid);


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

