#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 Migración SQL,
projectforge-business/src/main/resources/flyway/migrate/common/V7.0.0.8__7.0.0.8-RELEASE.sql
27 líneas · 22 código · 0 comentarios · 5 en blanco
Propósito: Migración de base de datos Flyway: V7.0.0.8__7.0.0.8-RELEASE.sql. V7.0.0.8__7.0.0.8-RELEASE.sql es parte de la aplicación de gestión de proyectos de código abierto ProjectForge.
Fuente (primeras 100 líneas)
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);
Historial Git
32719f5af Implementado comentario de vacaciones.
3b1b65eea VacationDO: is_half_day_begin/end, descripción. Renombrando sesión...
32719f5af
Implementado comentario de vacaciones.
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, descripción. Renombrando sesión...
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);