Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.