Revision 12172
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 10 | 10 |
SET client_min_messages = warning; |
| 11 | 11 |
|
| 12 | 12 |
-- |
| 13 |
-- Name: public_validation_plots; Type: SCHEMA; Schema: -; Owner: - |
|
| 13 |
-- Name: public_validations_plots; Type: SCHEMA; Schema: -; Owner: -
|
|
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE SCHEMA public_validation_plots; |
|
| 16 |
CREATE SCHEMA public_validations_plots;
|
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
-- |
| 20 |
-- Name: SCHEMA public_validation_plots; Type: COMMENT; Schema: -; Owner: - |
|
| 20 |
-- Name: SCHEMA public_validations_plots; Type: COMMENT; Schema: -; Owner: -
|
|
| 21 | 21 |
-- |
| 22 | 22 |
|
| 23 |
COMMENT ON SCHEMA public_validation_plots IS 'aggregating validations queries for plots'; |
|
| 23 |
COMMENT ON SCHEMA public_validations_plots IS 'aggregating validations queries for plots';
|
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 | 26 |
-- |
| 27 |
-- Name: public_validation_specimens; Type: SCHEMA; Schema: -; Owner: - |
|
| 27 |
-- Name: public_validations_specimens; Type: SCHEMA; Schema: -; Owner: -
|
|
| 28 | 28 |
-- |
| 29 | 29 |
|
| 30 |
CREATE SCHEMA public_validation_specimens; |
|
| 30 |
CREATE SCHEMA public_validations_specimens;
|
|
| 31 | 31 |
|
| 32 | 32 |
|
| 33 | 33 |
-- |
| 34 |
-- Name: SCHEMA public_validation_specimens; Type: COMMENT; Schema: -; Owner: - |
|
| 34 |
-- Name: SCHEMA public_validations_specimens; Type: COMMENT; Schema: -; Owner: -
|
|
| 35 | 35 |
-- |
| 36 | 36 |
|
| 37 |
COMMENT ON SCHEMA public_validation_specimens IS 'aggregating validations queries for specimens'; |
|
| 37 |
COMMENT ON SCHEMA public_validations_specimens IS 'aggregating validations queries for specimens';
|
|
| 38 | 38 |
|
| 39 | 39 |
|
| 40 | 40 |
-- |
| 41 |
-- Name: public_validation_traits; Type: SCHEMA; Schema: -; Owner: - |
|
| 41 |
-- Name: public_validations_traits; Type: SCHEMA; Schema: -; Owner: -
|
|
| 42 | 42 |
-- |
| 43 | 43 |
|
| 44 |
CREATE SCHEMA public_validation_traits; |
|
| 44 |
CREATE SCHEMA public_validations_traits;
|
|
| 45 | 45 |
|
| 46 | 46 |
|
| 47 | 47 |
-- |
| 48 |
-- Name: SCHEMA public_validation_traits; Type: COMMENT; Schema: -; Owner: - |
|
| 48 |
-- Name: SCHEMA public_validations_traits; Type: COMMENT; Schema: -; Owner: -
|
|
| 49 | 49 |
-- |
| 50 | 50 |
|
| 51 |
COMMENT ON SCHEMA public_validation_traits IS 'aggregating validations queries for traits'; |
|
| 51 |
COMMENT ON SCHEMA public_validations_traits IS 'aggregating validations queries for traits';
|
|
| 52 | 52 |
|
| 53 | 53 |
|
| 54 | 54 |
SET search_path = public, pg_catalog; |
| ... | ... | |
| 5179 | 5179 |
ALTER SEQUENCE voucher_voucher_id_seq OWNED BY voucher.voucher_id; |
| 5180 | 5180 |
|
| 5181 | 5181 |
|
| 5182 |
SET search_path = public_validation_plots, pg_catalog; |
|
| 5182 |
SET search_path = public_validations_plots, pg_catalog;
|
|
| 5183 | 5183 |
|
| 5184 | 5184 |
-- |
| 5185 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5185 |
-- Name: _01_count_of_projects; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5186 | 5186 |
-- |
| 5187 | 5187 |
|
| 5188 | 5188 |
CREATE VIEW _01_count_of_projects AS |
| ... | ... | |
| 5193 | 5193 |
|
| 5194 | 5194 |
|
| 5195 | 5195 |
-- |
| 5196 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5196 |
-- Name: _02_list_of_project_names; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5197 | 5197 |
-- |
| 5198 | 5198 |
|
| 5199 | 5199 |
CREATE VIEW _02_list_of_project_names AS |
| ... | ... | |
| 5204 | 5204 |
|
| 5205 | 5205 |
|
| 5206 | 5206 |
-- |
| 5207 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5207 |
-- Name: _03_count_of_all_plots_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5208 | 5208 |
-- |
| 5209 | 5209 |
|
| 5210 | 5210 |
CREATE VIEW _03_count_of_all_plots_in_this_source AS |
| ... | ... | |
| 5217 | 5217 |
|
| 5218 | 5218 |
|
| 5219 | 5219 |
-- |
| 5220 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5220 |
-- Name: _04_count_of_plots_in_each_project_in_this_source; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5221 | 5221 |
-- |
| 5222 | 5222 |
|
| 5223 | 5223 |
CREATE VIEW _04_count_of_plots_in_each_project_in_this_source AS |
| ... | ... | |
| 5232 | 5232 |
|
| 5233 | 5233 |
|
| 5234 | 5234 |
-- |
| 5235 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5235 |
-- Name: _05_list_of_plot_codes_by_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5236 | 5236 |
-- |
| 5237 | 5237 |
|
| 5238 | 5238 |
CREATE VIEW _05_list_of_plot_codes_by_project AS |
| ... | ... | |
| 5246 | 5246 |
|
| 5247 | 5247 |
|
| 5248 | 5248 |
-- |
| 5249 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5249 |
-- Name: _06_list_of_plots_with_stem_measurements; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5250 | 5250 |
-- |
| 5251 | 5251 |
|
| 5252 | 5252 |
CREATE VIEW _06_list_of_plots_with_stem_measurements AS |
| ... | ... | |
| 5265 | 5265 |
|
| 5266 | 5266 |
|
| 5267 | 5267 |
-- |
| 5268 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5268 |
-- Name: _10_count_of_individuals_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5269 | 5269 |
-- |
| 5270 | 5270 |
|
| 5271 | 5271 |
CREATE VIEW _10_count_of_individuals_per_plot_in_each_project AS |
| ... | ... | |
| 5285 | 5285 |
|
| 5286 | 5286 |
|
| 5287 | 5287 |
-- |
| 5288 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5288 |
-- Name: VIEW _10_count_of_individuals_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5289 | 5289 |
-- |
| 5290 | 5290 |
|
| 5291 | 5291 |
COMMENT ON VIEW _10_count_of_individuals_per_plot_in_each_project IS 'Method: count taxonObservations |
| ... | ... | |
| 5295 | 5295 |
|
| 5296 | 5296 |
|
| 5297 | 5297 |
-- |
| 5298 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5298 |
-- Name: _11_count_of_stems_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5299 | 5299 |
-- |
| 5300 | 5300 |
|
| 5301 | 5301 |
CREATE VIEW _11_count_of_stems_per_plot_in_each_project AS |
| ... | ... | |
| 5317 | 5317 |
|
| 5318 | 5318 |
|
| 5319 | 5319 |
-- |
| 5320 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5320 |
-- Name: VIEW _11_count_of_stems_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5321 | 5321 |
-- |
| 5322 | 5322 |
|
| 5323 | 5323 |
COMMENT ON VIEW _11_count_of_stems_per_plot_in_each_project IS 'Method: count records in stemobservation table |
| ... | ... | |
| 5325 | 5325 |
|
| 5326 | 5326 |
|
| 5327 | 5327 |
-- |
| 5328 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5328 |
-- Name: _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5329 | 5329 |
-- |
| 5330 | 5330 |
|
| 5331 | 5331 |
CREATE VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project AS |
| ... | ... | |
| 5346 | 5346 |
|
| 5347 | 5347 |
|
| 5348 | 5348 |
-- |
| 5349 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5349 |
-- Name: VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5350 | 5350 |
-- |
| 5351 | 5351 |
|
| 5352 | 5352 |
COMMENT ON VIEW _12_count_of_verbatim_taxa_per_plot_in_each_project IS 'Check: join to source db by all columns, returns same number of rows |
| ... | ... | |
| 5356 | 5356 |
|
| 5357 | 5357 |
|
| 5358 | 5358 |
-- |
| 5359 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5359 |
-- Name: _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5360 | 5360 |
-- |
| 5361 | 5361 |
|
| 5362 | 5362 |
CREATE VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project AS |
| ... | ... | |
| 5376 | 5376 |
|
| 5377 | 5377 |
|
| 5378 | 5378 |
-- |
| 5379 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5379 |
-- Name: VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5380 | 5380 |
-- |
| 5381 | 5381 |
|
| 5382 | 5382 |
COMMENT ON VIEW _13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project IS 'Note: Must perform equivalent concatenation of taxonomic field in source db. |
| ... | ... | |
| 5384 | 5384 |
|
| 5385 | 5385 |
|
| 5386 | 5386 |
-- |
| 5387 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5387 |
-- Name: _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5388 | 5388 |
-- |
| 5389 | 5389 |
|
| 5390 | 5390 |
CREATE VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project AS |
| ... | ... | |
| 5407 | 5407 |
|
| 5408 | 5408 |
|
| 5409 | 5409 |
-- |
| 5410 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5410 |
-- Name: VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5411 | 5411 |
-- |
| 5412 | 5412 |
|
| 5413 | 5413 |
COMMENT ON VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project IS 'Note: Must do equivalent concatenation of taxonomic field in source db. |
| ... | ... | |
| 5415 | 5415 |
|
| 5416 | 5416 |
|
| 5417 | 5417 |
-- |
| 5418 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5418 |
-- Name: _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5419 | 5419 |
-- |
| 5420 | 5420 |
|
| 5421 | 5421 |
CREATE VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project AS |
| ... | ... | |
| 5439 | 5439 |
|
| 5440 | 5440 |
|
| 5441 | 5441 |
-- |
| 5442 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5442 |
-- Name: VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5443 | 5443 |
-- |
| 5444 | 5444 |
|
| 5445 | 5445 |
COMMENT ON VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project IS 'Applies to: aggregate-cover plots only |
| ... | ... | |
| 5450 | 5450 |
|
| 5451 | 5451 |
|
| 5452 | 5452 |
-- |
| 5453 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5453 |
-- Name: _17_count_of_subplots_per_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5454 | 5454 |
-- |
| 5455 | 5455 |
|
| 5456 | 5456 |
CREATE VIEW _17_count_of_subplots_per_plot_for_each_project AS |
| ... | ... | |
| 5468 | 5468 |
|
| 5469 | 5469 |
|
| 5470 | 5470 |
-- |
| 5471 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validation_plots; Owner: - |
|
| 5471 |
-- Name: _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: VIEW; Schema: public_validations_plots; Owner: -
|
|
| 5472 | 5472 |
-- |
| 5473 | 5473 |
|
| 5474 | 5474 |
CREATE VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project AS |
| ... | ... | |
| 5485 | 5485 |
|
| 5486 | 5486 |
|
| 5487 | 5487 |
-- |
| 5488 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validation_plots; Owner: - |
|
| 5488 |
-- Name: VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project; Type: COMMENT; Schema: public_validations_plots; Owner: -
|
|
| 5489 | 5489 |
-- |
| 5490 | 5490 |
|
| 5491 | 5491 |
COMMENT ON VIEW _18_list_of_subplots_codes_for_each_plot_for_each_project IS 'DOESN''T YET WORK PROPERLY |
| 5492 | 5492 |
'; |
| 5493 | 5493 |
|
| 5494 | 5494 |
|
| 5495 |
SET search_path = public_validation_traits, pg_catalog; |
|
| 5495 |
SET search_path = public_validations_traits, pg_catalog;
|
|
| 5496 | 5496 |
|
| 5497 | 5497 |
-- |
| 5498 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5498 |
-- Name: _01_count_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5499 | 5499 |
-- |
| 5500 | 5500 |
|
| 5501 | 5501 |
CREATE VIEW _01_count_records AS |
| ... | ... | |
| 5506 | 5506 |
|
| 5507 | 5507 |
|
| 5508 | 5508 |
-- |
| 5509 |
-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5509 |
-- Name: _02_count_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5510 | 5510 |
-- |
| 5511 | 5511 |
|
| 5512 | 5512 |
CREATE VIEW _02_count_trait_names AS |
| ... | ... | |
| 5517 | 5517 |
|
| 5518 | 5518 |
|
| 5519 | 5519 |
-- |
| 5520 |
-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5520 |
-- Name: _03_list_trait_names; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5521 | 5521 |
-- |
| 5522 | 5522 |
|
| 5523 | 5523 |
CREATE VIEW _03_list_trait_names AS |
| ... | ... | |
| 5529 | 5529 |
|
| 5530 | 5530 |
|
| 5531 | 5531 |
-- |
| 5532 |
-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5532 |
-- Name: _04_count_records_per_trait; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5533 | 5533 |
-- |
| 5534 | 5534 |
|
| 5535 | 5535 |
CREATE VIEW _04_count_records_per_trait AS |
| ... | ... | |
| 5543 | 5543 |
|
| 5544 | 5544 |
|
| 5545 | 5545 |
-- |
| 5546 |
-- Name: _05_count_taxa; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5546 |
-- Name: _05_count_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5547 | 5547 |
-- |
| 5548 | 5548 |
|
| 5549 | 5549 |
CREATE VIEW _05_count_taxa AS |
| ... | ... | |
| 5553 | 5553 |
|
| 5554 | 5554 |
|
| 5555 | 5555 |
-- |
| 5556 |
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: - |
|
| 5556 |
-- Name: VIEW _05_count_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 5557 | 5557 |
-- |
| 5558 | 5558 |
|
| 5559 | 5559 |
COMMENT ON VIEW _05_count_taxa IS 'Note: No morphospecies in trait table, therefore count taxon + authority only |
| ... | ... | |
| 5561 | 5561 |
|
| 5562 | 5562 |
|
| 5563 | 5563 |
-- |
| 5564 |
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5564 |
-- Name: _06_list_taxa; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5565 | 5565 |
-- |
| 5566 | 5566 |
|
| 5567 | 5567 |
CREATE VIEW _06_list_taxa AS |
| ... | ... | |
| 5572 | 5572 |
|
| 5573 | 5573 |
|
| 5574 | 5574 |
-- |
| 5575 |
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validation_traits; Owner: - |
|
| 5575 |
-- Name: VIEW _06_list_taxa; Type: COMMENT; Schema: public_validations_traits; Owner: -
|
|
| 5576 | 5576 |
-- |
| 5577 | 5577 |
|
| 5578 | 5578 |
COMMENT ON VIEW _06_list_taxa IS 'Note 1: No morphospecies in trait table, use taxon + authority |
| ... | ... | |
| 5581 | 5581 |
|
| 5582 | 5582 |
|
| 5583 | 5583 |
-- |
| 5584 |
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5584 |
-- Name: _07_trait_value_and_units_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5585 | 5585 |
-- |
| 5586 | 5586 |
|
| 5587 | 5587 |
CREATE VIEW _07_trait_value_and_units_for_first_5000_records AS |
| ... | ... | |
| 5596 | 5596 |
|
| 5597 | 5597 |
|
| 5598 | 5598 |
-- |
| 5599 |
-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validation_traits; Owner: - |
|
| 5599 |
-- Name: _08_taxon_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations_traits; Owner: -
|
|
| 5600 | 5600 |
-- |
| 5601 | 5601 |
|
| 5602 | 5602 |
CREATE VIEW _08_taxon_trait_and_value_for_first_5000_records AS |
| ... | ... | |
| 11362 | 11362 |
|
| 11363 | 11363 |
|
| 11364 | 11364 |
-- |
| 11365 |
-- Name: public_validation_plots; Type: ACL; Schema: -; Owner: - |
|
| 11365 |
-- Name: public_validations_plots; Type: ACL; Schema: -; Owner: -
|
|
| 11366 | 11366 |
-- |
| 11367 | 11367 |
|
| 11368 |
REVOKE ALL ON SCHEMA public_validation_plots FROM PUBLIC; |
|
| 11369 |
REVOKE ALL ON SCHEMA public_validation_plots FROM bien; |
|
| 11370 |
GRANT ALL ON SCHEMA public_validation_plots TO bien; |
|
| 11371 |
GRANT USAGE ON SCHEMA public_validation_plots TO bien_read; |
|
| 11372 |
GRANT USAGE ON SCHEMA public_validation_plots TO public_; |
|
| 11368 |
REVOKE ALL ON SCHEMA public_validations_plots FROM PUBLIC;
|
|
| 11369 |
REVOKE ALL ON SCHEMA public_validations_plots FROM bien;
|
|
| 11370 |
GRANT ALL ON SCHEMA public_validations_plots TO bien;
|
|
| 11371 |
GRANT USAGE ON SCHEMA public_validations_plots TO bien_read;
|
|
| 11372 |
GRANT USAGE ON SCHEMA public_validations_plots TO public_;
|
|
| 11373 | 11373 |
|
| 11374 | 11374 |
|
| 11375 | 11375 |
-- |
| 11376 |
-- Name: public_validation_specimens; Type: ACL; Schema: -; Owner: - |
|
| 11376 |
-- Name: public_validations_specimens; Type: ACL; Schema: -; Owner: -
|
|
| 11377 | 11377 |
-- |
| 11378 | 11378 |
|
| 11379 |
REVOKE ALL ON SCHEMA public_validation_specimens FROM PUBLIC; |
|
| 11380 |
REVOKE ALL ON SCHEMA public_validation_specimens FROM bien; |
|
| 11381 |
GRANT ALL ON SCHEMA public_validation_specimens TO bien; |
|
| 11382 |
GRANT USAGE ON SCHEMA public_validation_specimens TO bien_read; |
|
| 11383 |
GRANT USAGE ON SCHEMA public_validation_specimens TO public_; |
|
| 11379 |
REVOKE ALL ON SCHEMA public_validations_specimens FROM PUBLIC;
|
|
| 11380 |
REVOKE ALL ON SCHEMA public_validations_specimens FROM bien;
|
|
| 11381 |
GRANT ALL ON SCHEMA public_validations_specimens TO bien;
|
|
| 11382 |
GRANT USAGE ON SCHEMA public_validations_specimens TO bien_read;
|
|
| 11383 |
GRANT USAGE ON SCHEMA public_validations_specimens TO public_;
|
|
| 11384 | 11384 |
|
| 11385 | 11385 |
|
| 11386 | 11386 |
-- |
| 11387 |
-- Name: public_validation_traits; Type: ACL; Schema: -; Owner: - |
|
| 11387 |
-- Name: public_validations_traits; Type: ACL; Schema: -; Owner: -
|
|
| 11388 | 11388 |
-- |
| 11389 | 11389 |
|
| 11390 |
REVOKE ALL ON SCHEMA public_validation_traits FROM PUBLIC; |
|
| 11391 |
REVOKE ALL ON SCHEMA public_validation_traits FROM bien; |
|
| 11392 |
GRANT ALL ON SCHEMA public_validation_traits TO bien; |
|
| 11393 |
GRANT USAGE ON SCHEMA public_validation_traits TO bien_read; |
|
| 11394 |
GRANT USAGE ON SCHEMA public_validation_traits TO public_; |
|
| 11390 |
REVOKE ALL ON SCHEMA public_validations_traits FROM PUBLIC;
|
|
| 11391 |
REVOKE ALL ON SCHEMA public_validations_traits FROM bien;
|
|
| 11392 |
GRANT ALL ON SCHEMA public_validations_traits TO bien;
|
|
| 11393 |
GRANT USAGE ON SCHEMA public_validations_traits TO bien_read;
|
|
| 11394 |
GRANT USAGE ON SCHEMA public_validations_traits TO public_;
|
|
| 11395 | 11395 |
|
| 11396 | 11396 |
|
| 11397 | 11397 |
-- |
Also available in: Unified diff
schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*