Revision 384
Added by Aaron Marcuse-Kubitza almost 13 years ago
| mappings/schemas/vegbien_empty.sql | ||
|---|---|---|
| 1 | 1 |
TRUNCATE address CASCADE; |
| 2 | 2 |
TRUNCATE aux_role CASCADE; |
| 3 | 3 |
TRUNCATE classcontributor CASCADE; |
| 4 |
TRUNCATE collection CASCADE; |
|
| 4 | 5 |
TRUNCATE collectiveobservation CASCADE; |
| 5 | 6 |
TRUNCATE commclass CASCADE; |
| 6 | 7 |
TRUNCATE commconcept CASCADE; |
| mappings/schemas/vegbien.sql | ||
|---|---|---|
| 132 | 132 |
ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id; |
| 133 | 133 |
|
| 134 | 134 |
|
| 135 |
SET default_with_oids = false; |
|
| 136 |
|
|
| 135 | 137 |
-- |
| 138 |
-- Name: collection; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 139 |
-- |
|
| 140 |
|
|
| 141 |
CREATE TABLE collection ( |
|
| 142 |
collection_id integer NOT NULL, |
|
| 143 |
individualplant_id integer NOT NULL |
|
| 144 |
); |
|
| 145 |
|
|
| 146 |
|
|
| 147 |
-- |
|
| 148 |
-- Name: collection_collection_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 149 |
-- |
|
| 150 |
|
|
| 151 |
CREATE SEQUENCE collection_collection_id_seq |
|
| 152 |
START WITH 1 |
|
| 153 |
INCREMENT BY 1 |
|
| 154 |
NO MINVALUE |
|
| 155 |
NO MAXVALUE |
|
| 156 |
CACHE 1; |
|
| 157 |
|
|
| 158 |
|
|
| 159 |
-- |
|
| 160 |
-- Name: collection_collection_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 161 |
-- |
|
| 162 |
|
|
| 163 |
ALTER SEQUENCE collection_collection_id_seq OWNED BY collection.collection_id; |
|
| 164 |
|
|
| 165 |
|
|
| 166 |
SET default_with_oids = true; |
|
| 167 |
|
|
| 168 |
-- |
|
| 136 | 169 |
-- Name: collectiveobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 137 | 170 |
-- |
| 138 | 171 |
|
| ... | ... | |
| 3500 | 3533 |
|
| 3501 | 3534 |
|
| 3502 | 3535 |
-- |
| 3536 |
-- Name: collection_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 3537 |
-- |
|
| 3538 |
|
|
| 3539 |
ALTER TABLE collection ALTER COLUMN collection_id SET DEFAULT nextval('collection_collection_id_seq'::regclass);
|
|
| 3540 |
|
|
| 3541 |
|
|
| 3542 |
-- |
|
| 3503 | 3543 |
-- Name: collectiveobservation_id; Type: DEFAULT; Schema: public; Owner: - |
| 3504 | 3544 |
-- |
| 3505 | 3545 |
|
| ... | ... | |
| 4042 | 4082 |
|
| 4043 | 4083 |
|
| 4044 | 4084 |
-- |
| 4085 |
-- Name: collection_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4086 |
-- |
|
| 4087 |
|
|
| 4088 |
ALTER TABLE ONLY collection |
|
| 4089 |
ADD CONSTRAINT collection_pkey PRIMARY KEY (collection_id); |
|
| 4090 |
|
|
| 4091 |
|
|
| 4092 |
-- |
|
| 4045 | 4093 |
-- Name: commclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4046 | 4094 |
-- |
| 4047 | 4095 |
|
| ... | ... | |
| 5833 | 5881 |
|
| 5834 | 5882 |
|
| 5835 | 5883 |
-- |
| 5884 |
-- Name: collection_individualplant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5885 |
-- |
|
| 5886 |
|
|
| 5887 |
ALTER TABLE ONLY collection |
|
| 5888 |
ADD CONSTRAINT collection_individualplant_id_fkey FOREIGN KEY (individualplant_id) REFERENCES individualplant(individualplant_id); |
|
| 5889 |
|
|
| 5890 |
|
|
| 5891 |
-- |
|
| 5836 | 5892 |
-- Name: r1address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5837 | 5893 |
-- |
| 5838 | 5894 |
|
Also available in: Unified diff
vegbien.sql: Added collection table