#1482: V7.4.1.1__7.4.1.1-RELEASE-USER_PASSWORDS_TABLE.sql

7254f2f152594d071e86ea71d2fef9069bd0276b
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.4.1.1__7.4.1.1-RELEASE-USER_PASSWORDS_TABLE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.4.1.1__7.4.1.1-RELEASE-USER_PASSWORDS_TABLE.sql
new file mode 100644
index 000000000..e6135f080
--- /dev/null
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.4.1.1__7.4.1.1-RELEASE-USER_PASSWORDS_TABLE.sql
@@ -0,0 +1,25 @@
+-- Les champs de mot de passe seront déplacés de la table T_PF_USER vers T_PF_USER_PASSWORD.
+
+CREATE TABLE T_PF_USER_PASSWORD
+(
+    pk                                     INTEGER                      NOT NULL,
+    deleted                                BOOLEAN                      NOT NULL,
+    created                                TIMESTAMP WITHOUT TIME ZONE,
+    last_update                            TIMESTAMP WITHOUT TIME ZONE,
+    user_id                                INTEGER                      NOT NULL,
+    password_hash                          CHARACTER VARYING(255),
+    password_salt                          CHARACTER VARYING(40)
+);
+
+ALTER TABLE T_PF_USER_PASSWORD
+    ADD CONSTRAINT t_pf_user_password_pkey PRIMARY KEY (pk);
+
+CREATE INDEX idx_fk_t_pf_user_password_user_id
+    ON t_pf_user (pk);
+
+ALTER TABLE T_PF_USER_PASSWORD
+    ADD CONSTRAINT idx_fk_t_user_password_user_fk FOREIGN KEY (user_id) REFERENCES t_pf_user (pk);
+
+-- Ajout de la contrainte de clé étrangère manquante :
+ALTER TABLE T_PF_USER_AUTHENTICATIONS
+    ADD CONSTRAINT idx_fk_t_user_authentications_user_fk FOREIGN KEY (user_id) REFERENCES t_pf_user (pk);