Revision 12042
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/Makefile | ||
|---|---|---|
| 90 | 90 |
pg_dump = env schema= ../bin/pg_dump_vegbien $(1) >$@ |
| 91 | 91 |
|
| 92 | 92 |
vegbien.sql: |
| 93 |
unset version dump_opts; $(call pg_dump,public) |
|
| 93 |
# include schemas that depend on `public` so they are restored along with it |
|
| 94 |
unset version dump_opts; $(call pg_dump,public --schema=validation) |
|
| 94 | 95 |
|
| 95 | 96 |
py_util.sql: |
| 96 | 97 |
env owners=1 $(call pg_dump,py_util) |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 9 | 9 |
|
| 10 | 10 |
|
| 11 | 11 |
|
| 12 |
-- |
|
| 13 |
-- Name: validation; Type: SCHEMA; Schema: -; Owner: - |
|
| 14 |
-- |
|
| 12 | 15 |
|
| 16 |
CREATE SCHEMA validation; |
|
| 13 | 17 |
|
| 18 |
|
|
| 14 | 19 |
-- |
| 20 |
-- Name: SCHEMA validation; Type: COMMENT; Schema: -; Owner: - |
|
| 21 |
-- |
|
| 22 |
|
|
| 23 |
|
|
| 24 |
|
|
| 25 |
|
|
| 26 |
|
|
| 27 |
|
|
| 28 |
-- |
|
| 15 | 29 |
-- Name: accesslevel; Type: TYPE; Schema: public; Owner: - |
| 16 | 30 |
-- |
| 17 | 31 |
|
| ... | ... | |
| 9067 | 9081 |
|
| 9068 | 9082 |
|
| 9069 | 9083 |
-- |
| 9084 |
-- Name: validation; Type: ACL; Schema: -; Owner: - |
|
| 9085 |
-- |
|
| 9086 |
|
|
| 9087 |
|
|
| 9088 |
|
|
| 9089 |
|
|
| 9090 |
|
|
| 9091 |
|
|
| 9092 |
|
|
| 9093 |
|
|
| 9094 |
-- |
|
| 9070 | 9095 |
-- Name: source; Type: ACL; Schema: public; Owner: - |
| 9071 | 9096 |
-- |
| 9072 | 9097 |
|
| trunk/schemas/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.