@PHONTOD
CREATE TABLE "PHTRLP"
(
  "IDEGRU"	 VARCHAR(2) NOT NULL,
  "CODIGO"	 VARCHAR(6) NOT NULL,
  "SEQUEN"	 VARCHAR(4) NOT NULL,
  "DESCRI"	 VARCHAR(80),
  "GRUSEL"	 VARCHAR(5),
  "CODKEY1"	 VARCHAR(4),
  "CODKEY2"	 VARCHAR(4),
  "CODKEY3"	 VARCHAR(4),
  "CODKEY4"	 VARCHAR(4),
  "TOTKEY1"	 VARCHAR(2),
  "TOTKEY2"	 VARCHAR(2),
  "TOTKEY3"	 VARCHAR(2),
  "TOTKEY4"	 VARCHAR(2),
  "QUEKEY1"	 VARCHAR(2),
  "QUEKEY2"	 VARCHAR(2),
  "QUEKEY3"	 VARCHAR(2),
  "QUEKEY4"	 VARCHAR(2),
  "GERATI"	 VARCHAR(2),
  "GERDEM"	 VARCHAR(2),
  "OPCADC1"	 VARCHAR(2),
  "OPCADC2"	 VARCHAR(2),
  "OPCADC3"	 VARCHAR(2),
  "OPCADC4"	 VARCHAR(2),
  "OPCADC5"	 VARCHAR(2),
  "OPCADC6"	 VARCHAR(2),
  "OPCADC7"	 VARCHAR(2),
  "OPCADC8"	 VARCHAR(2),
  "OPCADC9"	 VARCHAR(2),
  "PARADC1"	 VARCHAR(10),
  "PARADC2"	 VARCHAR(10),
  "PARADC3"	 VARCHAR(10),
  "PARADC4"	 VARCHAR(10),
  "PARADC5"	 VARCHAR(10),
  "PARADC6"	 VARCHAR(10),
  "PARADC7"	 VARCHAR(10),
  "PARADC8"	 VARCHAR(10),
  "PARADC9"	 VARCHAR(10),
  "FUNCAO"	 VARCHAR(10),
 PRIMARY KEY ("IDEGRU", "CODIGO", "SEQUEN")
);
@EXECSQL

CREATE TABLE "PHTSEL" 
(
  "GRUSEL"	 VARCHAR(5) NOT NULL,
  "DESGRU"	 VARCHAR(60),
  "SELEMP"	 VARCHAR(150),
  "SELCAD"	 VARCHAR(150),
  "SELDEP"	 VARCHAR(100),
  "SELSET"	 VARCHAR(100),
  "SELSEC"	 VARCHAR(100),
  "SELCCU"	 VARCHAR(100),
  "SELGRU"	 VARCHAR(100),
  "SELSIN"	 VARCHAR(100),
 PRIMARY KEY ("GRUSEL")
);

@EXECSQL


