search

LubeAndTangerines / data-management-service

Microservice to store and transact data for Lube & Tangerines applications
1 stars 0 forks source link

Schema update for wishpiles and wishes #2

Open MarkusTarn opened 6 years ago

MarkusTarn commented 6 years ago

Schemas should be migrated automatically with running application!

public.landt_piles :

id serial primary key,
rid char(36) not null,
name varchar(50) not null,
description varchar(255),
link char(36) default null UNIQUE ,
created_ts   timestamp with time zone default now(),
modified_ts timestamp with time zone default now()

public.landt_wishes :

id serial primary key,
pile_id SERIAL,
rid char(36) not null,
wish varchar(255) not null,
amount int not null DEFAULT 1,
status varchar(30) not null default 'REQUESTED',
created_ts   timestamp with time zone default now(),
modified_ts timestamp with time zone default now()