Breadcrumbs

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.