Revision 1055
Added by Aaron Marcuse-Kubitza almost 13 years ago
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
vegbien.sql: Added locationevent.datasource_id