Editing the database.

[theclanbaymis]

how can i edit the database?

i need help

Unhandled Rejection at: Promise Promise {
Error: relation "accounts" does not exist
at Object.generic (/game/swordbattle.io-main/node_modules/postgres/lib/types.js:200:5)
at Object.ErrorResponse (/game/swordbattle.io-main/node_modules/postgres/lib/backend.js:124:33)
at TLSSocket.data (/game/swordbattle.io-main/node_modules/postgres/lib/connection.js:167:25)
at TLSSocket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at TLSSocket.Readable.push (node:internal/streams/readable:228:10)
at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '42P01',
file: 'errors.go',
line: '161',
routine: 'NewUndefinedRelationError'
}

[codergautam]

Hi, did you set up the database with all the tables correctly?

You can find instructions here:
https://iogames.forum/t/integrating-database-to-swordbattle-v1-code/13458

[theclanbaymis]

ty, one quetion more.
how add this database in cockroachlabs.cloud?

[codergautam]

You can do that by creating and account and there is an option to make a database.

[theclanbaymis]

You can do that by creating and account and there is an option to make a database.

yes i make a database, but how add this

CREATE TABLE public.accounts (
  skins jsonb NULL,
  password text NOT NULL,
  secret text NOT NULL,
  email text NULL,
  username text NOT NULL,
  created_at timestamp without time zone NOT NULL DEFAULT now(),
  id serial NOT NULL,
  lastusernamechange timestamp(6) without time zone NULL
);
ALTER TABLE
  public.accounts
ADD
  CONSTRAINT accounts_pkey PRIMARY KEY (id)

[codergautam]

You can connect to the database any way you like, it could be using terminal or a GUI client. I use Beekeeper Studio
Then you run those query which creates the tables which is required for swordbattle.

Closing because this is getting out of scope of this project.