     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: 
--


--

ALTER SEQUENCE flags_flagid_seq OWNED BY flags.flagid;


--
-- Name: invbeacons; Type: VIEW; Schema: osmium; Owner: -
--

CREATE VIEW invbeacons AS
 SELECT invtypes.typeid,
    invtypes.typename
   FROM eve.invtypes
  WHERE (invtypes.groupid = 920);


--
