F18

sifv dbf:

AADD(aDBf,{ 'oznaka'              , 'C' ,   4 ,  0 })
AADD(aDBf,{ 'idsif'               , 'C' ,  15 ,  0 })
AADD(aDBf,{ 'naz'                 , 'C' ,  50 ,  0 })

sql

CREATE TABLE fmk.sifk
(
  id character(8),
  match_code character(10),
  sort character(2),
  naz character(25),
  oznaka character(4),
  veza character(1),
  f_unique character(1),
  izvor character(15),
  uslov character(200),
  duzina numeric(2,0),
  f_decimal numeric(1,0),
  tip character(1),
  kvalid character(100),
  kwhen character(100),
  ubrowsu character(1),
  edkolona numeric(2,0),
  k1 character(1),
  k2 character(2),
  k3 character(3),
  k4 character(4)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE fmk.sifk
  OWNER TO admin;
GRANT ALL ON TABLE fmk.sifk TO admin;
GRANT ALL ON TABLE fmk.sifk TO xtrole;

sql:

-- DROP TABLE fmk.sifv;

CREATE TABLE fmk.sifv
(
  id character(8),
  idsif character(15),
  naz character(200),
  oznaka character(4)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE fmk.sifv
  OWNER TO admin;
GRANT ALL ON TABLE fmk.sifv TO admin;
GRANT ALL ON TABLE fmk.sifv TO xtrole;

ovdje

i ovdje