Revision 6512
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.sql | ||
---|---|---|
910 | 910 |
|
911 | 911 |
ALTER TABLE analytical_aggregate ALTER COLUMN "institutionCode" SET NOT NULL; |
912 | 912 |
ALTER TABLE analytical_aggregate ALTER COLUMN "plotName" SET NOT NULL; |
913 |
ALTER TABLE analytical_aggregate ALTER COLUMN "dateCollected" SET NOT NULL; |
|
914 | 913 |
|
915 | 914 |
CREATE INDEX ON analytical_aggregate ("institutionCode", "plotName", "dateCollected" ); |
916 | 915 |
$$; |
... | ... | |
928 | 927 |
|
929 | 928 |
ALTER TABLE analytical_stem ALTER COLUMN "institutionCode" SET NOT NULL; |
930 | 929 |
ALTER TABLE analytical_stem ALTER COLUMN "plotName" SET NOT NULL; |
931 |
ALTER TABLE analytical_stem ALTER COLUMN "dateCollected" SET NOT NULL; |
|
932 | 930 |
|
933 | 931 |
CREATE INDEX ON analytical_stem ("institutionCode", "plotName", "dateCollected" ); |
934 | 932 |
$$; |
... | ... | |
1470 | 1468 |
"elevationInMeters" double precision, |
1471 | 1469 |
"plotArea_ha" double precision, |
1472 | 1470 |
"samplingProtocol" text, |
1473 |
"dateCollected" date NOT NULL,
|
|
1471 |
"dateCollected" date, |
|
1474 | 1472 |
"higherPlantGroup" higher_plant_group, |
1475 | 1473 |
family text, |
1476 | 1474 |
genus text, |
... | ... | |
1511 | 1509 |
"elevationInMeters" double precision, |
1512 | 1510 |
"plotArea_ha" double precision, |
1513 | 1511 |
"samplingProtocol" text, |
1514 |
"dateCollected" date NOT NULL,
|
|
1512 |
"dateCollected" date, |
|
1515 | 1513 |
"higherPlantGroup" higher_plant_group, |
1516 | 1514 |
family text, |
1517 | 1515 |
genus text, |
... | ... | |
6033 | 6031 |
|
6034 | 6032 |
|
6035 | 6033 |
-- |
6036 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
6034 |
-- Name: analytical_aggregate_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
6037 | 6035 |
-- |
6038 | 6036 |
|
6039 |
CREATE INDEX "analytical_aggregate_by_institutionCode" ON analytical_aggregate USING btree ("institutionCode", "plotName", "dateCollected");
|
|
6037 |
CREATE INDEX "analytical_aggregate_institutionCode_plotName_dateCollected_idx" ON analytical_aggregate USING btree ("institutionCode", "plotName", "dateCollected");
|
|
6040 | 6038 |
|
6041 | 6039 |
|
6042 | 6040 |
-- |
6043 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
6041 |
-- Name: analytical_stem_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
6044 | 6042 |
-- |
6045 | 6043 |
|
6046 |
CREATE INDEX "analytical_stem_by_institutionCode" ON analytical_stem USING btree ("institutionCode", "plotName", "dateCollected");
|
|
6044 |
CREATE INDEX "analytical_stem_institutionCode_plotName_dateCollected_idx" ON analytical_stem USING btree ("institutionCode", "plotName", "dateCollected");
|
|
6047 | 6045 |
|
6048 | 6046 |
|
6049 | 6047 |
-- |
... | ... | |
7680 | 7678 |
|
7681 | 7679 |
|
7682 | 7680 |
-- |
7683 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
7684 |
-- |
|
7685 |
|
|
7686 |
REVOKE ALL ON TABLE analytical_stem FROM PUBLIC; |
|
7687 |
REVOKE ALL ON TABLE analytical_stem FROM bien; |
|
7688 |
GRANT ALL ON TABLE analytical_stem TO bien; |
|
7689 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
|
7690 |
|
|
7691 |
|
|
7692 |
-- |
|
7693 | 7681 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
7694 | 7682 |
-- |
7695 | 7683 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Removed NOT NULL constraint on dateCollected