rsanchez
2017-04-10 8d99c88af55041ff06e6b9372b6b1f66220bed38
securis/src/main/resources/db/schema.sql
....@@ -73,6 +73,13 @@
7373 username VARCHAR(45) NOT NULL,
7474 organization_id INT NOT NULL,
7575 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
+
7683
7784 drop table IF EXISTS pack;
7885 CREATE TABLE IF NOT EXISTS pack (