Revision 6512
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 724 | 724 |
`elevationInMeters` double precision, |
| 725 | 725 |
`plotArea_ha` double precision, |
| 726 | 726 |
`samplingProtocol` varchar(255), |
| 727 |
`dateCollected` date NOT NULL,
|
|
| 727 |
`dateCollected` date, |
|
| 728 | 728 |
`higherPlantGroup` varchar(255), |
| 729 | 729 |
family varchar(255), |
| 730 | 730 |
genus varchar(255), |
| ... | ... | |
| 765 | 765 |
`elevationInMeters` double precision, |
| 766 | 766 |
`plotArea_ha` double precision, |
| 767 | 767 |
`samplingProtocol` varchar(255), |
| 768 |
`dateCollected` date NOT NULL,
|
|
| 768 |
`dateCollected` date, |
|
| 769 | 769 |
`higherPlantGroup` varchar(255), |
| 770 | 770 |
family varchar(255), |
| 771 | 771 |
genus varchar(255), |
| ... | ... | |
| 4956 | 4956 |
|
| 4957 | 4957 |
|
| 4958 | 4958 |
-- |
| 4959 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4959 |
-- Name: analytical_aggregate_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4960 | 4960 |
-- |
| 4961 | 4961 |
|
| 4962 |
CREATE INDEX `analytical_aggregate_by_institutionCode` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`);
|
|
| 4962 |
CREATE INDEX `analytical_aggregate_institutionCode_plotName_dateCollected_idx` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`);
|
|
| 4963 | 4963 |
|
| 4964 | 4964 |
|
| 4965 | 4965 |
-- |
| 4966 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4966 |
-- Name: analytical_stem_institutionCode_plotName_dateCollected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4967 | 4967 |
-- |
| 4968 | 4968 |
|
| 4969 |
CREATE INDEX `analytical_stem_by_institutionCode` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`);
|
|
| 4969 |
CREATE INDEX `analytical_stem_institutionCode_plotName_dateCollected_idx` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`);
|
|
| 4970 | 4970 |
|
| 4971 | 4971 |
|
| 4972 | 4972 |
-- |
| ... | ... | |
| 6557 | 6557 |
|
| 6558 | 6558 |
|
| 6559 | 6559 |
-- |
| 6560 |
-- Name: analytical_stem; Type: ACL; Schema: public; Owner: - |
|
| 6561 |
-- |
|
| 6562 |
|
|
| 6563 |
|
|
| 6564 |
|
|
| 6565 |
|
|
| 6566 |
|
|
| 6567 |
|
|
| 6568 |
|
|
| 6569 |
-- |
|
| 6570 | 6560 |
-- Name: analytical_aggregate_view; Type: ACL; Schema: public; Owner: - |
| 6571 | 6561 |
-- |
| 6572 | 6562 |
|
| schemas/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