securis/src/main/resources/db/schema.sql
.. .. @@ -73,6 +73,13 @@ 73 73 username VARCHAR(45) NOT NULL, 74 74 organization_id INT NOT NULL, 75 75 PRIMARY KEY (username, organization_id)); 76 +77 +drop table IF EXISTS user_application;78 +CREATE TABLE IF NOT EXISTS user_application (79 + username VARCHAR(45) NOT NULL,80 + application_id INT NOT NULL,81 + PRIMARY KEY (username, application_id));82 +76 83 77 84 drop table IF EXISTS pack; 78 85 CREATE TABLE IF NOT EXISTS pack (