Revision 12042
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.sql | ||
|---|---|---|
| 9 | 9 |
SET check_function_bodies = false; |
| 10 | 10 |
SET client_min_messages = warning; |
| 11 | 11 |
|
| 12 |
-- |
|
| 13 |
-- Name: validation; Type: SCHEMA; Schema: -; Owner: - |
|
| 14 |
-- |
|
| 15 |
|
|
| 16 |
CREATE SCHEMA validation; |
|
| 17 |
|
|
| 18 |
|
|
| 19 |
-- |
|
| 20 |
-- Name: SCHEMA validation; Type: COMMENT; Schema: -; Owner: - |
|
| 21 |
-- |
|
| 22 |
|
|
| 23 |
COMMENT ON SCHEMA validation IS 'queries used in the aggregating validations'; |
|
| 24 |
|
|
| 25 |
|
|
| 12 | 26 |
SET search_path = public, pg_catalog; |
| 13 | 27 |
|
| 14 | 28 |
-- |
| ... | ... | |
| 10805 | 10819 |
|
| 10806 | 10820 |
|
| 10807 | 10821 |
-- |
| 10822 |
-- Name: validation; Type: ACL; Schema: -; Owner: - |
|
| 10823 |
-- |
|
| 10824 |
|
|
| 10825 |
REVOKE ALL ON SCHEMA validation FROM PUBLIC; |
|
| 10826 |
REVOKE ALL ON SCHEMA validation FROM bien; |
|
| 10827 |
GRANT ALL ON SCHEMA validation TO bien; |
|
| 10828 |
GRANT USAGE ON SCHEMA validation TO bien_read; |
|
| 10829 |
GRANT USAGE ON SCHEMA validation TO public_; |
|
| 10830 |
|
|
| 10831 |
|
|
| 10832 |
-- |
|
| 10808 | 10833 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
| 10809 | 10834 |
-- |
| 10810 | 10835 |
|
Also available in: Unified diff
schemas/vegbien.sql: added validation schema, which contains queries used in the aggregating validations. schemas/Makefile: include schemas that depend on `public` (eg. `validation`) so they are restored along with it.