raven
4046f56191
- removed: session-service - updated: moved health check out of consul registration - updated: get service info to pull the service from the default namespace for the service account - updated: the rest of the services to be able to handle the new database tables
23 lines
681 B
SQL
23 lines
681 B
SQL
create table characters
|
|
(
|
|
id serial
|
|
primary key,
|
|
user_id integer not null
|
|
references users
|
|
on delete cascade,
|
|
is_active boolean default true,
|
|
name varchar(50) not null,
|
|
money bigint default 0,
|
|
inventory jsonb default '[]'::jsonb,
|
|
stats jsonb default '{}'::jsonb,
|
|
skills jsonb default '[]'::jsonb,
|
|
looks jsonb default '{}'::jsonb,
|
|
position jsonb default '{}'::jsonb,
|
|
created_at timestamp default CURRENT_TIMESTAMP,
|
|
updated_at timestamp default CURRENT_TIMESTAMP,
|
|
deleted_at timestamp
|
|
);
|
|
|
|
alter table characters
|
|
owner to osirose;
|