Revision 12147
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 | 12 |
-- |
| 13 |
-- Name: public_validation; Type: SCHEMA; Schema: -; Owner: - |
|
| 13 |
-- Name: public_validation_plots; Type: SCHEMA; Schema: -; Owner: -
|
|
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE SCHEMA public_validation; |
|
| 16 |
CREATE SCHEMA public_validation_plots;
|
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
-- |
| 20 |
-- Name: SCHEMA public_validation; Type: COMMENT; Schema: -; Owner: - |
|
| 20 |
-- Name: SCHEMA public_validation_plots; Type: COMMENT; Schema: -; Owner: -
|
|
| 21 | 21 |
-- |
| 22 | 22 |
|
| 23 | 23 |
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 |
-- |
|
| 27 |
-- Name: public_validation_specimens; Type: SCHEMA; Schema: -; Owner: - |
|
| 28 |
-- |
|
| 26 | 29 |
|
| 30 |
CREATE SCHEMA public_validation_specimens; |
|
| 27 | 31 |
|
| 32 |
|
|
| 28 | 33 |
-- |
| 34 |
-- Name: SCHEMA public_validation_specimens; Type: COMMENT; Schema: -; Owner: - |
|
| 35 |
-- |
|
| 36 |
|
|
| 37 |
|
|
| 38 |
|
|
| 39 |
|
|
| 40 |
-- |
|
| 41 |
-- Name: public_validation_traits; Type: SCHEMA; Schema: -; Owner: - |
|
| 42 |
-- |
|
| 43 |
|
|
| 44 |
CREATE SCHEMA public_validation_traits; |
|
| 45 |
|
|
| 46 |
|
|
| 47 |
-- |
|
| 48 |
-- Name: SCHEMA public_validation_traits; Type: COMMENT; Schema: -; Owner: - |
|
| 49 |
-- |
|
| 50 |
|
|
| 51 |
|
|
| 52 |
|
|
| 53 |
|
|
| 54 |
|
|
| 55 |
|
|
| 56 |
-- |
|
| 29 | 57 |
-- Name: accesslevel; Type: TYPE; Schema: public; Owner: - |
| 30 | 58 |
-- |
| 31 | 59 |
|
| ... | ... | |
| 9116 | 9144 |
|
| 9117 | 9145 |
|
| 9118 | 9146 |
-- |
| 9119 |
-- Name: public_validation; Type: ACL; Schema: -; Owner: - |
|
| 9147 |
-- Name: public_validation_plots; Type: ACL; Schema: -; Owner: -
|
|
| 9120 | 9148 |
-- |
| 9121 | 9149 |
|
| 9122 | 9150 |
|
| ... | ... | |
| 9127 | 9155 |
|
| 9128 | 9156 |
|
| 9129 | 9157 |
-- |
| 9158 |
-- Name: public_validation_specimens; Type: ACL; Schema: -; Owner: - |
|
| 9159 |
-- |
|
| 9160 |
|
|
| 9161 |
|
|
| 9162 |
|
|
| 9163 |
|
|
| 9164 |
|
|
| 9165 |
|
|
| 9166 |
|
|
| 9167 |
|
|
| 9168 |
-- |
|
| 9169 |
-- Name: public_validation_traits; Type: ACL; Schema: -; Owner: - |
|
| 9170 |
-- |
|
| 9171 |
|
|
| 9172 |
|
|
| 9173 |
|
|
| 9174 |
|
|
| 9175 |
|
|
| 9176 |
|
|
| 9177 |
|
|
| 9178 |
|
|
| 9179 |
-- |
|
| 9130 | 9180 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
| 9131 | 9181 |
-- |
| 9132 | 9182 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 10 | 10 |
SET client_min_messages = warning; |
| 11 | 11 |
|
| 12 | 12 |
-- |
| 13 |
-- Name: public_validation; Type: SCHEMA; Schema: -; Owner: - |
|
| 13 |
-- Name: public_validation_plots; Type: SCHEMA; Schema: -; Owner: -
|
|
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE SCHEMA public_validation; |
|
| 16 |
CREATE SCHEMA public_validation_plots;
|
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
-- |
| 20 |
-- Name: SCHEMA public_validation; Type: COMMENT; Schema: -; Owner: - |
|
| 20 |
-- Name: SCHEMA public_validation_plots; Type: COMMENT; Schema: -; Owner: -
|
|
| 21 | 21 |
-- |
| 22 | 22 |
|
| 23 |
COMMENT ON SCHEMA public_validation IS 'queries used in the aggregating validations';
|
|
| 23 |
COMMENT ON SCHEMA public_validation_plots IS 'aggregating validations queries for plots';
|
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 |
-- |
|
| 27 |
-- Name: public_validation_specimens; Type: SCHEMA; Schema: -; Owner: - |
|
| 28 |
-- |
|
| 29 |
|
|
| 30 |
CREATE SCHEMA public_validation_specimens; |
|
| 31 |
|
|
| 32 |
|
|
| 33 |
-- |
|
| 34 |
-- Name: SCHEMA public_validation_specimens; Type: COMMENT; Schema: -; Owner: - |
|
| 35 |
-- |
|
| 36 |
|
|
| 37 |
COMMENT ON SCHEMA public_validation_specimens IS 'aggregating validations queries for specimens'; |
|
| 38 |
|
|
| 39 |
|
|
| 40 |
-- |
|
| 41 |
-- Name: public_validation_traits; Type: SCHEMA; Schema: -; Owner: - |
|
| 42 |
-- |
|
| 43 |
|
|
| 44 |
CREATE SCHEMA public_validation_traits; |
|
| 45 |
|
|
| 46 |
|
|
| 47 |
-- |
|
| 48 |
-- Name: SCHEMA public_validation_traits; Type: COMMENT; Schema: -; Owner: - |
|
| 49 |
-- |
|
| 50 |
|
|
| 51 |
COMMENT ON SCHEMA public_validation_traits IS 'aggregating validations queries for traits'; |
|
| 52 |
|
|
| 53 |
|
|
| 26 | 54 |
SET search_path = public, pg_catalog; |
| 27 | 55 |
|
| 28 | 56 |
-- |
| ... | ... | |
| 10882 | 10910 |
|
| 10883 | 10911 |
|
| 10884 | 10912 |
-- |
| 10885 |
-- Name: public_validation; Type: ACL; Schema: -; Owner: - |
|
| 10913 |
-- Name: public_validation_plots; Type: ACL; Schema: -; Owner: -
|
|
| 10886 | 10914 |
-- |
| 10887 | 10915 |
|
| 10888 |
REVOKE ALL ON SCHEMA public_validation FROM PUBLIC; |
|
| 10889 |
REVOKE ALL ON SCHEMA public_validation FROM bien; |
|
| 10890 |
GRANT ALL ON SCHEMA public_validation TO bien; |
|
| 10891 |
GRANT USAGE ON SCHEMA public_validation TO bien_read; |
|
| 10892 |
GRANT USAGE ON SCHEMA public_validation TO public_; |
|
| 10916 |
REVOKE ALL ON SCHEMA public_validation_plots FROM PUBLIC;
|
|
| 10917 |
REVOKE ALL ON SCHEMA public_validation_plots FROM bien;
|
|
| 10918 |
GRANT ALL ON SCHEMA public_validation_plots TO bien;
|
|
| 10919 |
GRANT USAGE ON SCHEMA public_validation_plots TO bien_read;
|
|
| 10920 |
GRANT USAGE ON SCHEMA public_validation_plots TO public_;
|
|
| 10893 | 10921 |
|
| 10894 | 10922 |
|
| 10895 | 10923 |
-- |
| 10924 |
-- Name: public_validation_specimens; Type: ACL; Schema: -; Owner: - |
|
| 10925 |
-- |
|
| 10926 |
|
|
| 10927 |
REVOKE ALL ON SCHEMA public_validation_specimens FROM PUBLIC; |
|
| 10928 |
REVOKE ALL ON SCHEMA public_validation_specimens FROM bien; |
|
| 10929 |
GRANT ALL ON SCHEMA public_validation_specimens TO bien; |
|
| 10930 |
GRANT USAGE ON SCHEMA public_validation_specimens TO bien_read; |
|
| 10931 |
GRANT USAGE ON SCHEMA public_validation_specimens TO public_; |
|
| 10932 |
|
|
| 10933 |
|
|
| 10934 |
-- |
|
| 10935 |
-- Name: public_validation_traits; Type: ACL; Schema: -; Owner: - |
|
| 10936 |
-- |
|
| 10937 |
|
|
| 10938 |
REVOKE ALL ON SCHEMA public_validation_traits FROM PUBLIC; |
|
| 10939 |
REVOKE ALL ON SCHEMA public_validation_traits FROM bien; |
|
| 10940 |
GRANT ALL ON SCHEMA public_validation_traits TO bien; |
|
| 10941 |
GRANT USAGE ON SCHEMA public_validation_traits TO bien_read; |
|
| 10942 |
GRANT USAGE ON SCHEMA public_validation_traits TO public_; |
|
| 10943 |
|
|
| 10944 |
|
|
| 10945 |
-- |
|
| 10896 | 10946 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
| 10897 | 10947 |
-- |
| 10898 | 10948 |
|
Also available in: Unified diff
schemas/vegbien.sql: public_validation: split into separate subschemas for plots, specimens, traits