#1470: V7.0.0.8__7.0.0.8-RELEASE.sql
projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql Migration SQL, projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql 27 lignes · 22 code · 0 commentaires · 5 vides
Objectif : Migration de base de données Flyway : V7.0.0.8__7.0.0.8-RELEASE.sql. V7.0.0.8__7.0.0.8-RELEASE.sql fait partie de l'application open-source de gestion de projet ProjectForge.
Source (100 premières lignes)
ALTER TABLE t_employee_vacation ADD COLUMN comment CHARACTER VARYING(4000);
ALTER TABLE t_employee_vacation ADD COLUMN is_half_day_end BOOLEAN;
CREATE TABLE t_employee_leave_account_entry (
pk INTEGER NOT NULL,
deleted BOOLEAN NOT NULL,
created TIMESTAMP WITHOUT TIME ZONE,
last_update TIMESTAMP WITHOUT TIME ZONE,
tenant_id INTEGER,
employee_id INTEGER NOT NULL,
date DATE NOT NULL,
accounting_balance BOOLEAN,
amount NUMERIC(5, 2),
description CHARACTER VARYING(4000)
);
ALTER TABLE t_employee_leave_account_entry
ADD CONSTRAINT t_employee_leave_account_entry_pkey PRIMARY KEY (pk);
CREATE INDEX idx_fk_t_leave_account_entry_employee_id
ON t_employee_leave_account_entry (pk);
ALTER TABLE t_employee_leave_account_entry
ADD CONSTRAINT t_employee_leave_account_entry_tenant_fk FOREIGN KEY (tenant_id) REFERENCES t_tenant (pk);
ALTER TABLE t_employee_leave_account_entry
ADD CONSTRAINT t_employee_leave_account_entry_employee_fk FOREIGN KEY (employee_id) REFERENCES t_fibu_employee (pk);
Historique Git
32719f5af Vacation.comment implémenté.
3b1b65eea VacationDO : is_half_day_begin/end, description. Renommage de session...
32719f5af
Vacation.comment implémenté.32719f5afcfbe9adc8717d3ba4742424ec9e21c6
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
index acf757575..62038bb70 100644
--- a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
@@ -1,4 +1,4 @@
-ALTER TABLE t_employee_vacation ADD COLUMN desciption CHARACTER VARYING(4000);
+ALTER TABLE t_employee_vacation ADD COLUMN comment CHARACTER VARYING(4000);
ALTER TABLE t_employee_vacation ADD COLUMN is_half_day_end BOOLEAN;
CREATE TABLE t_employee_leave_account_entry (
3b1b65eea
VacationDO : is_half_day_begin/end, description. Renommage de session...3b1b65eea879fa5b91c46dbc950ab100c33a0982
diff --git a/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
new file mode 100644
index 000000000..acf757575
--- /dev/null
+++ b/projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
@@ -0,0 +1,27 @@
+ALTER TABLE t_employee_vacation ADD COLUMN desciption CHARACTER VARYING(4000);
+ALTER TABLE t_employee_vacation ADD COLUMN is_half_day_end BOOLEAN;
+
+CREATE TABLE t_employee_leave_account_entry (
+ pk INTEGER NOT NULL,
+ deleted BOOLEAN NOT NULL,
+ created TIMESTAMP WITHOUT TIME ZONE,
+ last_update TIMESTAMP WITHOUT TIME ZONE,
+ tenant_id INTEGER,
+ employee_id INTEGER NOT NULL,
+ date DATE NOT NULL,
+ accounting_balance BOOLEAN,
+ amount NUMERIC(5, 2),
+ description CHARACTER VARYING(4000)
+);
+
+ALTER TABLE t_employee_leave_account_entry
+ ADD CONSTRAINT t_employee_leave_account_entry_pkey PRIMARY KEY (pk);
+
+CREATE INDEX idx_fk_t_leave_account_entry_employee_id
+ ON t_employee_leave_account_entry (pk);
+
+ALTER TABLE t_employee_leave_account_entry
+ ADD CONSTRAINT t_employee_leave_account_entry_tenant_fk FOREIGN KEY (tenant_id) REFERENCES t_tenant (pk);
+
+ALTER TABLE t_employee_leave_account_entry
+ ADD CONSTRAINT t_employee_leave_account_entry_employee_fk FOREIGN KEY (employee_id) REFERENCES t_fibu_employee (pk);