Revision 1153
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 585 | 585 |
|
| 586 | 586 |
|
| 587 | 587 |
|
| 588 |
|
|
| 589 |
|
|
| 590 | 588 |
-- |
| 591 |
-- Name: growthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 592 |
-- |
|
| 593 |
|
|
| 594 |
CREATE TABLE growthform ( |
|
| 595 |
growthform_id int(11) NOT NULL, |
|
| 596 |
name text NOT NULL |
|
| 597 |
); |
|
| 598 |
|
|
| 599 |
|
|
| 600 |
-- |
|
| 601 |
-- Name: COLUMN growthform.name; Type: COMMENT; Schema: public; Owner: - |
|
| 602 |
-- |
|
| 603 |
|
|
| 604 |
|
|
| 605 |
|
|
| 606 |
|
|
| 607 |
-- |
|
| 608 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 609 |
-- |
|
| 610 |
|
|
| 611 |
|
|
| 612 |
|
|
| 613 |
|
|
| 614 |
-- |
|
| 615 |
-- Name: growthform_growthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 616 |
-- |
|
| 617 |
|
|
| 618 |
|
|
| 619 |
|
|
| 620 |
|
|
| 621 |
|
|
| 622 |
|
|
| 623 |
-- |
|
| 624 | 589 |
-- Name: location; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 625 | 590 |
-- |
| 626 | 591 |
|
| ... | ... | |
| 1118 | 1083 |
|
| 1119 | 1084 |
|
| 1120 | 1085 |
-- |
| 1121 |
-- Name: methodgrowthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1122 |
-- |
|
| 1123 |
|
|
| 1124 |
CREATE TABLE methodgrowthform ( |
|
| 1125 |
methodgrowthform_id int(11) NOT NULL, |
|
| 1126 |
method_id int(11) NOT NULL, |
|
| 1127 |
growthform_id int(11) NOT NULL, |
|
| 1128 |
included int(1) NOT NULL, |
|
| 1129 |
submethod_id int(11) |
|
| 1130 |
); |
|
| 1131 |
|
|
| 1132 |
|
|
| 1133 |
-- |
|
| 1134 |
-- Name: COLUMN methodgrowthform.included; Type: COMMENT; Schema: public; Owner: - |
|
| 1135 |
-- |
|
| 1136 |
|
|
| 1137 |
|
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
-- |
|
| 1141 |
-- Name: COLUMN methodgrowthform.submethod_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1142 |
-- |
|
| 1143 |
|
|
| 1144 |
|
|
| 1145 |
|
|
| 1146 |
|
|
| 1147 |
-- |
|
| 1148 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1149 |
-- |
|
| 1150 |
|
|
| 1151 |
|
|
| 1152 |
|
|
| 1153 |
|
|
| 1154 |
-- |
|
| 1155 |
-- Name: methodgrowthform_methodgrowthform_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1156 |
-- |
|
| 1157 |
|
|
| 1158 |
|
|
| 1159 |
|
|
| 1160 |
|
|
| 1161 |
-- |
|
| 1162 | 1086 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1163 | 1087 |
-- |
| 1164 | 1088 |
|
| ... | ... | |
| 2539 | 2463 |
|
| 2540 | 2464 |
|
| 2541 | 2465 |
-- |
| 2542 |
-- Name: growthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2543 |
-- |
|
| 2544 |
|
|
| 2545 |
|
|
| 2546 |
|
|
| 2547 |
|
|
| 2548 |
-- |
|
| 2549 | 2466 |
-- Name: location_id; Type: DEFAULT; Schema: public; Owner: - |
| 2550 | 2467 |
-- |
| 2551 | 2468 |
|
| ... | ... | |
| 2588 | 2505 |
|
| 2589 | 2506 |
|
| 2590 | 2507 |
-- |
| 2591 |
-- Name: methodgrowthform_id; Type: DEFAULT; Schema: public; Owner: - |
|
| 2592 |
-- |
|
| 2593 |
|
|
| 2594 |
|
|
| 2595 |
|
|
| 2596 |
|
|
| 2597 |
-- |
|
| 2598 | 2508 |
-- Name: methodtaxonclass_id; Type: DEFAULT; Schema: public; Owner: - |
| 2599 | 2509 |
-- |
| 2600 | 2510 |
|
| ... | ... | |
| 3052 | 2962 |
|
| 3053 | 2963 |
|
| 3054 | 2964 |
-- |
| 3055 |
-- Name: growthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3056 |
-- |
|
| 3057 |
|
|
| 3058 |
ALTER TABLE growthform |
|
| 3059 |
ADD CONSTRAINT growthform_pkey PRIMARY KEY (growthform_id); |
|
| 3060 |
|
|
| 3061 |
|
|
| 3062 |
-- |
|
| 3063 |
-- Name: growthform_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3064 |
-- |
|
| 3065 |
|
|
| 3066 |
ALTER TABLE growthform |
|
| 3067 |
ADD CONSTRAINT growthform_unique UNIQUE (name); |
|
| 3068 |
|
|
| 3069 |
|
|
| 3070 |
-- |
|
| 3071 | 2965 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3072 | 2966 |
-- |
| 3073 | 2967 |
|
| ... | ... | |
| 3164 | 3058 |
|
| 3165 | 3059 |
|
| 3166 | 3060 |
-- |
| 3167 |
-- Name: methodgrowthform_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3168 |
-- |
|
| 3169 |
|
|
| 3170 |
ALTER TABLE methodgrowthform |
|
| 3171 |
ADD CONSTRAINT methodgrowthform_pkey PRIMARY KEY (methodgrowthform_id); |
|
| 3172 |
|
|
| 3173 |
|
|
| 3174 |
-- |
|
| 3175 | 3061 |
-- Name: methodtaxonclass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3176 | 3062 |
-- |
| 3177 | 3063 |
|
| ... | ... | |
| 4008 | 3894 |
|
| 4009 | 3895 |
|
| 4010 | 3896 |
-- |
| 4011 |
-- Name: fki_methodgrowthform_growthform_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4012 |
-- |
|
| 4013 |
|
|
| 4014 |
CREATE INDEX fki_methodgrowthform_growthform_id ON methodgrowthform (growthform_id); |
|
| 4015 |
|
|
| 4016 |
|
|
| 4017 |
-- |
|
| 4018 |
-- Name: fki_methodgrowthform_growthformmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4019 |
-- |
|
| 4020 |
|
|
| 4021 |
CREATE INDEX fki_methodgrowthform_growthformmethod_id ON methodgrowthform (submethod_id); |
|
| 4022 |
|
|
| 4023 |
|
|
| 4024 |
-- |
|
| 4025 |
-- Name: fki_methodgrowthform_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4026 |
-- |
|
| 4027 |
|
|
| 4028 |
CREATE INDEX fki_methodgrowthform_method_id ON methodgrowthform (method_id); |
|
| 4029 |
|
|
| 4030 |
|
|
| 4031 |
-- |
|
| 4032 | 3897 |
-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4033 | 3898 |
-- |
| 4034 | 3899 |
|
| ... | ... | |
| 5226 | 5091 |
|
| 5227 | 5092 |
|
| 5228 | 5093 |
-- |
| 5229 |
-- Name: methodgrowthform_growthform_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5230 |
-- |
|
| 5231 |
|
|
| 5232 |
ALTER TABLE methodgrowthform |
|
| 5233 |
ADD CONSTRAINT methodgrowthform_growthform_id FOREIGN KEY (growthform_id) REFERENCES growthform(growthform_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5234 |
|
|
| 5235 |
|
|
| 5236 |
-- |
|
| 5237 |
-- Name: methodgrowthform_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5238 |
-- |
|
| 5239 |
|
|
| 5240 |
ALTER TABLE methodgrowthform |
|
| 5241 |
ADD CONSTRAINT methodgrowthform_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5242 |
|
|
| 5243 |
|
|
| 5244 |
-- |
|
| 5245 |
-- Name: methodgrowthform_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5246 |
-- |
|
| 5247 |
|
|
| 5248 |
ALTER TABLE methodgrowthform |
|
| 5249 |
ADD CONSTRAINT methodgrowthform_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL; |
|
| 5250 |
|
|
| 5251 |
|
|
| 5252 |
-- |
|
| 5253 | 5094 |
-- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5254 | 5095 |
-- |
| 5255 | 5096 |
|
Also available in: Unified diff
vegbien.sql: Removed methodgrowthform and growthform, since growthforms can be accommodated by plantconcept in a similar way as higher-order taxonomic ranks