====== Systems - Database: creating a test DB system and connection to CzechIdM via REST ======
This tutorial will show you, how to create simple database table that you can then connect to CzechIdM via REST endpoint.

===== Create table  =====

Create new table in database of your CzechIdM.

<code sql>
CREATE TABLE system_users
(
  name character varying(255) NOT NULL,
  lastname character varying(255),
  firstname character varying(255),
  password character varying(255),
  email character varying(255),
  descrip character varying(255),
  status character varying,
  modified timestamp without time zone DEFAULT now(),
  CONSTRAINT pk_system_users PRIMARY KEY (name)
);
</code>

===== call REST API =====

Use rest below to create test system based on created table (use user with **app_admin** permissions)
<code sql>
POST:
http://localhost:8080/idm-backend/api/v1/systems/test/create-test-system
</code>