Database creation instructions

[krs0]

Would like to create a db without crawling.

Is there a script/manual on how to create it?

[krs0]

I've managed to get a little further by manually creating the dbs, based on what I could infer from code.
A backup with db schema would help a lot, because mostly was guesswork.

Here for siiir table for example:

-- Table: public.siiir

-- DROP TABLE IF EXISTS public.siiir;

CREATE TABLE IF NOT EXISTS public.siiir
(
cod_siiir_unitate character varying(10) COLLATE pg_catalog."default" NOT NULL,
denumire_lunga_unitate text COLLATE pg_catalog."default",
judet_pj character varying(2) COLLATE pg_catalog."default",
stare_liceal character varying(50) COLLATE pg_catalog."default",
tip_unitate character varying(100) COLLATE pg_catalog."default",
data_infiintare date,
data_desfiintare date,
adresa text COLLATE pg_catalog."default",
telefon character varying(20) COLLATE pg_catalog."default",
email character varying(100) COLLATE pg_catalog."default",
website character varying(200) COLLATE pg_catalog."default",
an character varying(10) COLLATE pg_catalog."default",
localitate_pj text COLLATE pg_catalog."default",
cod_siruta_pj character varying(10) COLLATE pg_catalog."default",
mediu_loc_pj text COLLATE pg_catalog."default",
cod_siiir_pj character varying(10) COLLATE pg_catalog."default",
denumire_pj text COLLATE pg_catalog."default",
localitate_unitate text COLLATE pg_catalog."default",
cod_siruta_unitate character varying(15) COLLATE pg_catalog."default",
mediu_loc_unitate character varying(20) COLLATE pg_catalog."default",
cod_sirues character varying(255) COLLATE pg_catalog."default",
denumire_scurta_unitate character varying(255) COLLATE pg_catalog."default",
statut_unitate character varying(255) COLLATE pg_catalog."default",
cod_fiscal character varying(50) COLLATE pg_catalog."default",
mod_functionare character varying(100) COLLATE pg_catalog."default",
forma_finantare character varying(100) COLLATE pg_catalog."default",
forma_proprietate character varying(100) COLLATE pg_catalog."default",
strada character varying(255) COLLATE pg_catalog."default",
numar character varying(50) COLLATE pg_catalog."default",
cod_postal character varying(20) COLLATE pg_catalog."default",
fax character varying(50) COLLATE pg_catalog."default",
CONSTRAINT siiir_pkey PRIMARY KEY (cod_siiir_unitate)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.siiir
OWNER to postgres;