@PHONTOX

CREATE TABLE "TABSEL3" 
(
  "CODIGO"	 VARCHAR(9) NOT NULL,
  "DESCRI"	 VARCHAR(40),
  "MARCA"	 VARCHAR(2),
  "DATADM"	 VARCHAR(12),
  "DATDEM"	 VARCHAR(12),
 PRIMARY KEY ("CODIGO")
);

@EXECSQL

CREATE TABLE "TABCLA" 
(
  "CODEMP"	 VARCHAR(4) NOT NULL,
  "CODCAD"	 VARCHAR(8) NOT NULL,
  "NOMFUN"	 VARCHAR(40),
  "NIVEL1"	 VARCHAR(6),
  "NIVEL2"	 VARCHAR(6),
  "NIVEL3"	 VARCHAR(6),
  "NIVEL4"	 VARCHAR(6),
  "CODSIN"	 VARCHAR(6),
  "CODGRU"	 VARCHAR(6),
  "FUNCAO"	 VARCHAR(10),
 PRIMARY KEY ("CODEMP", "CODCAD")
);

@EXECSQL

