Compare commits
4 Commits
pkg/dev/ri
...
71bbc42786
Author | SHA1 | Date | |
---|---|---|---|
71bbc42786 | |||
a69d0f7386 | |||
93db38dc7f | |||
2ce388eaf9 |
@ -97,9 +97,9 @@ CREATE TABLE Applicationservice (
|
|||||||
ApplicationserviceName VARCHAR(255) NOT NULL,
|
ApplicationserviceName VARCHAR(255) NOT NULL,
|
||||||
ApplicationserviceDescription VARCHAR(255) NOT NULL,
|
ApplicationserviceDescription VARCHAR(255) NOT NULL,
|
||||||
ApplicationserviceReleaseId INTEGER NOT NULL,
|
ApplicationserviceReleaseId INTEGER NOT NULL,
|
||||||
ApplicationserviceLVIS VARCHAR(255) NOT NULL,
|
--ApplicationserviceLVIS VARCHAR(255) NOT NULL,
|
||||||
ApplicationserviceLVIP VARCHAR(255) NOT NULL,
|
--ApplicationserviceLVIP VARCHAR(255) NOT NULL,
|
||||||
ApplicationserviceLVMP VARCHAR(255) NOT NULL,
|
--ApplicationserviceLVMP VARCHAR(255) NOT NULL,
|
||||||
OS JSON,
|
OS JSON,
|
||||||
UNIQUE (ApplicationserviceName, ApplicationserviceReleaseId)
|
UNIQUE (ApplicationserviceName, ApplicationserviceReleaseId)
|
||||||
);
|
);
|
||||||
|
@ -2,6 +2,8 @@
|
|||||||
|
|
||||||
set -e
|
set -e
|
||||||
|
|
||||||
|
systemctl start postgresql.service
|
||||||
|
|
||||||
psql -Upostgres -c "grant all on all tables in schema public to risotto" risotto
|
psql -Upostgres -c "grant all on all tables in schema public to risotto" risotto
|
||||||
psql -Upostgres -c "grant all on all sequences in schema public to risotto" risotto
|
psql -Upostgres -c "grant all on all sequences in schema public to risotto" risotto
|
||||||
psql -Upostgres -c "grant all on all functions in schema public to risotto" risotto
|
psql -Upostgres -c "grant all on all functions in schema public to risotto" risotto
|
||||||
@ -9,4 +11,6 @@ psql -Upostgres -c "grant all on all tables in schema public to tiramisu" tirami
|
|||||||
psql -Upostgres -c "grant all on all sequences in schema public to tiramisu" tiramisu
|
psql -Upostgres -c "grant all on all sequences in schema public to tiramisu" tiramisu
|
||||||
psql -Upostgres -c "grant all on all functions in schema public to tiramisu" tiramisu
|
psql -Upostgres -c "grant all on all functions in schema public to tiramisu" tiramisu
|
||||||
|
|
||||||
|
systemctl stop postgresql.service
|
||||||
|
|
||||||
exit 0
|
exit 0
|
Reference in New Issue
Block a user