Project

General

Profile

« Previous | Next » 

Revision 1055

vegbien.sql: Added locationevent.datasource_id

View differences:

vegbien.my.sql
1066 1066
CREATE TABLE locationevent (
1067 1067
    locationevent_id int(11) NOT NULL,
1068 1068
    parent_id int(11),
1069
    datasource_id int(11),
1069 1070
    location_id int(11),
1070 1071
    project_id int(11),
1071 1072
    authoreventcode text,
......
4814 4815

  
4815 4816

  
4816 4817
--
4818
-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4819
--
4820

  
4821
CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);
4822

  
4823

  
4824
--
4817 4825
-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4818 4826
--
4819 4827

  
......
6019 6027

  
6020 6028

  
6021 6029
--
6030
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
6031
--
6032

  
6033

  
6034

  
6035

  
6036
--
6022 6037
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
6023 6038
--
6024 6039

  

Also available in: Unified diff