TaskView is a self-hosted project and task management platform focused on clarity, ownership, and control. TaskView is built for teams that want a transparent, self-hosted alternative to SaaS task managers.
TypeScript graphviewkanban-boardnodejsproductivityproject-managementself-hostedtasktask-managementtask-managertodoapp
create schema if not exists app;
create table if not exists app.version
(
id serial,
version varchar,
prev_version varchar
);
insert into app.version(id, version, prev_version)
select 1, '0.0.0', '0.0.0'
where not EXISTS(select id from app.version where id = 1);
--Trigger for adding owner for component
create or replace function app.trigger_set_previous_version()
returns trigger as
$date_complete$
begin
new.prev_version = old.version;
return new;
end;
$date_complete$
language plpgsql;
drop trigger if exists trigger_set_previous_version on app.version;
create trigger trigger_set_previous_version
before insert
on app.version
for each row
execute procedure app.trigger_set_previous_version();