|
Revision 479, 1.2 kB
(checked in by insultant, 8 months ago)
|
--
|
| Line | |
|---|
| 1 |
#!/bin/sh |
|---|
| 2 |
echo "\connect wifidog;" |
|---|
| 3 |
echo "BEGIN;" |
|---|
| 4 |
|
|---|
| 5 |
pg_dump -a -D --username=wifidog -t token_status |
|---|
| 6 |
pg_dump -a -D --username=wifidog -t venue_types |
|---|
| 7 |
pg_dump -a -D --username=wifidog -t node_deployment_status |
|---|
| 8 |
pg_dump -a -D --username=wifidog -t content_available_display_areas |
|---|
| 9 |
pg_dump -a -D --username=wifidog -t content_available_display_pages |
|---|
| 10 |
pg_dump -a -D --username=wifidog -t stakeholder_types |
|---|
| 11 |
|
|---|
| 12 |
echo "INSERT INTO networks (network_id, network_authenticator_class, network_authenticator_params) VALUES ('default-network', 'AuthenticatorLocalUser', '\'default-network\'');"; |
|---|
| 13 |
echo "INSERT INTO nodes (network_id, node_id, gw_id, name) VALUES ('default-network', 'default', 'default', 'My first node');" |
|---|
| 14 |
echo "INSERT INTO virtual_hosts (virtual_host_id, hostname, default_network) VALUES ('DEFAULT_VHOST', 'localhost', 'default-network');"; |
|---|
| 15 |
echo "INSERT INTO server (server_id, default_virtual_host) VALUES ('SERVER_ID', 'DEFAULT_VHOST');"; |
|---|
| 16 |
echo "INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_OWNER', 'Server');"; |
|---|
| 17 |
echo "INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_OWNER', 'Network');"; |
|---|
| 18 |
|
|---|
| 19 |
pg_dump -a -D --username=wifidog -t schema_info |
|---|
| 20 |
pg_dump -a -D --username=wifidog -t locales |
|---|
| 21 |
|
|---|
| 22 |
echo "COMMIT;" |
|---|
