diff options
| author | Robert | 2017-06-02 16:01:57 +0200 |
|---|---|---|
| committer | Robert | 2017-06-02 16:01:57 +0200 |
| commit | b4193e4a246684974ecc4c40a230a07d921c737f (patch) | |
| tree | 7bcf6abba3f6848bcc9f82b5a55cc14c78787db8 /install/template-stif-boiv.sql | |
| parent | 4e791b7c834c65ee968580e0e0281eb97a7c89eb (diff) | |
| download | chouette-core-b4193e4a246684974ecc4c40a230a07d921c737f.tar.bz2 | |
Merge branch 'master' of github.com:af83/stif-boiv
Diffstat (limited to 'install/template-stif-boiv.sql')
| -rw-r--r-- | install/template-stif-boiv.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/install/template-stif-boiv.sql b/install/template-stif-boiv.sql new file mode 100644 index 000000000..4d4a19afe --- /dev/null +++ b/install/template-stif-boiv.sql @@ -0,0 +1,11 @@ +set ON_ERROR_STOP=on; + +CREATE SCHEMA shared_extensions; +GRANT ALL ON SCHEMA shared_extensions TO PUBLIC; +CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA shared_extensions; +CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA shared_extensions; + +UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_stif_boiv'; + +VACUUM FULL FREEZE; + |