Revision 37
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbank.sql | ||
|---|---|---|
| 1 |
DROP DATABASE IF EXISTS vegbank; |
|
| 2 | 1 |
-- |
| 3 | 2 |
-- PostgreSQL database dump |
| 4 | 3 |
-- |
| ... | ... | |
| 11 | 10 |
SET escape_string_warning = off; |
| 12 | 11 |
|
| 13 | 12 |
-- |
| 14 |
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: vegbank
|
|
| 13 |
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: postgres
|
|
| 15 | 14 |
-- |
| 16 | 15 |
|
| 17 |
CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8'; |
|
| 16 |
CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
|
|
| 18 | 17 |
|
| 19 | 18 |
|
| 20 |
ALTER DATABASE vegbank OWNER TO vegbank;
|
|
| 19 |
ALTER DATABASE vegbank OWNER TO postgres;
|
|
| 21 | 20 |
|
| 22 | 21 |
\connect vegbank |
| 23 | 22 |
|
| ... | ... | |
| 7239 | 7238 |
|
| 7240 | 7239 |
|
| 7241 | 7240 |
-- |
| 7242 |
-- Name: public; Type: ACL; Schema: -; Owner: vegbank
|
|
| 7241 |
-- Name: public; Type: ACL; Schema: -; Owner: postgres
|
|
| 7243 | 7242 |
-- |
| 7244 | 7243 |
|
| 7245 | 7244 |
REVOKE ALL ON SCHEMA public FROM PUBLIC; |
| 7246 |
REVOKE ALL ON SCHEMA public FROM vegbank;
|
|
| 7247 |
GRANT ALL ON SCHEMA public TO vegbank;
|
|
| 7245 |
REVOKE ALL ON SCHEMA public FROM postgres;
|
|
| 7246 |
GRANT ALL ON SCHEMA public TO postgres;
|
|
| 7248 | 7247 |
GRANT ALL ON SCHEMA public TO PUBLIC; |
| 7249 | 7248 |
|
| 7250 | 7249 |
|
Also available in: Unified diff
xml2db: Improved empty_db to use TRUNCATE instead of DROP DATABASE. Added xml2vegbank to automatically set db env vars.