 --
 
 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);
 
 
 --

    string_agg(DISTINCT (fittingtags.tagname)::text, ' '::text) AS taglist
   FROM fittingtags
  GROUP BY fittingtags.fittinghash;


--



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

