5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3
5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3

License manager PSQL subscription_order Table creation script

This script has all the commands to add subscription_order table for license Manaeger.

SQL
# 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.