License manager PSQL subscription_order Table creation script
This script has all the commands to add subscription_order table for license Manaeger.
# Login to Postgres client
# On your terminal, execute the below command.
helm -n ef-external status ef-postgresql
# It will return some steps to connect to postgresql client.
# Execute the command returned after text "To get the password for "postgres" run:". It should be starting with keyword "export".
# After this, execute the next command returned after text "To get the password for "sa" run:". It should be starting with keyword "export".
# After this, execute the next command returned after text "To connect to your database run the following command:". It would be in 3 lines so copy all of it and paste it to execute it.
# After this, you should see terminal with pre word as "licenseManager=>". If not then you can try pressing enter to see this.
# Here, you can execute this command to create subscription_order table
CREATE TABLE public.subscription_order (
subscription_id INT NOT NULL,
order_id INT NOT NULL,
PRIMARY KEY (subscription_id, order_id)
);
# After executing this command, you can verify the Table is created using the command "\dt;" (without quotes). It will list all databases.
# At the end you can execute "\q" to quit from the client.