 
 
 --
--- TOC entry 3784 (class 1259 OID 1091645)
--- Dependencies: 185 3806
--- Name: vehicle_track_frt_fid_idx; Type: INDEX; Schema: vdv; Owner: -
---
-
-CREATE INDEX vehicle_track_frt_fid_idx ON vehicle_track USING btree (frt_fid);
-
-
---
--- TOC entry 3785 (class 1259 OID 1091646)
--- Dependencies: 185 3806
--- Name: vehicle_track_notification_date; Type: INDEX; Schema: vdv; Owner: -
---
-
-CREATE INDEX vehicle_track_notification_date ON vehicle_track USING btree (notification_date);
-
-
---
 -- TOC entry 3790 (class 2606 OID 591829)
 -- Dependencies: 171 167 3746 3806
 -- Name: firmenkalender_tagesart_nr_fkey; Type: FK CONSTRAINT; Schema: vdv; Owner: -



--
-- TOC entry 3726 (class 2604 OID 1091635)
-- Dependencies: 185 184 185
-- Name: vt_id; Type: DEFAULT; Schema: vdv; Owner: -
--

ALTER TABLE ONLY vehicle_track ALTER COLUMN vt_id SET DEFAULT nextval('vehicle_track_vt_id_seq'::regclass);


--
-- TOC entry 3736 (class 2606 OID 591774)
-- Dependencies: 167 167 3806
-- Name: firmenkalender_pkey; Type: CONSTRAINT; Schema: vdv; Owner: -

    linien_code smallint,
    konzessionsinhaber_nr integer,
    auftraggeber_nr integer,
    fremdunternehmer_nr integer
);

SELECT AddGeometryColumn('vdv', 'rec_lid', 'the_geom', 25832, 'LINESTRING', 2); 

--
-- TOC entry 174 (class 1259 OID 591726)
