@PHOLHAD

CREATE TABLE "PHCPSE" 
(
  "CODEMP"	 VARCHAR(4) NOT NULL,
  "CODCAD"	 VARCHAR(10) NOT NULL,
  "ANOMES"	 VARCHAR(8) NOT NULL,
  "CODOPE"	 VARCHAR(4) NOT NULL,
  "VTOTAL"	 VARCHAR(10),
  "CDEP01"	 VARCHAR(6),
  "VDEP01"	 VARCHAR(10),
  "CDEP02"	 VARCHAR(6),
  "VDEP02"	 VARCHAR(10),
  "CDEP03"	 VARCHAR(6),
  "VDEP03"	 VARCHAR(10),
  "CDEP04"	 VARCHAR(6),
  "VDEP04"	 VARCHAR(10),
  "CDEP05"	 VARCHAR(6),
  "VDEP05"	 VARCHAR(10),
  "CDEP06"	 VARCHAR(6),
  "VDEP06"	 VARCHAR(10),
  "CDEP07"	 VARCHAR(6),
  "VDEP07"	 VARCHAR(10),
  "CDEP08"	 VARCHAR(6),
  "VDEP08"	 VARCHAR(10),
  "CDEP09"	 VARCHAR(6),
  "VDEP09"	 VARCHAR(10),
  "CDEP10"	 VARCHAR(6),
  "VDEP10"	 VARCHAR(10),
  "CDEP11"	 VARCHAR(6),
  "VDEP11"	 VARCHAR(10),
  "CDEP12"	 VARCHAR(6),
  "VDEP12"	 VARCHAR(10),
 PRIMARY KEY ("CODEMP", "CODCAD", "ANOMES", "CODOPE")
);
@EXECSQL

CREATE TABLE "PHMPSE" 
(
  "CODEMP"	 VARCHAR(4) NOT NULL,
  "CODCAD"	 VARCHAR(10) NOT NULL,
  "ANOMES"	 VARCHAR(8) NOT NULL,
  "CODFOL"	 VARCHAR(2) NOT NULL,
  "CODOPE"	 VARCHAR(4) NOT NULL,
  "VTOTAL"	 VARCHAR(10),
  "CDEP01"	 VARCHAR(6),
  "VDEP01"	 VARCHAR(10),
  "CDEP02"	 VARCHAR(6),
  "VDEP02"	 VARCHAR(10),
  "CDEP03"	 VARCHAR(6),
  "VDEP03"	 VARCHAR(10),
  "CDEP04"	 VARCHAR(6),
  "VDEP04"	 VARCHAR(10),
  "CDEP05"	 VARCHAR(6),
  "VDEP05"	 VARCHAR(10),
  "CDEP06"	 VARCHAR(6),
  "VDEP06"	 VARCHAR(10),
  "CDEP07"	 VARCHAR(6),
  "VDEP07"	 VARCHAR(10),
  "CDEP08"	 VARCHAR(6),
  "VDEP08"	 VARCHAR(10),
  "CDEP09"	 VARCHAR(6),
  "VDEP09"	 VARCHAR(10),
  "CDEP10"	 VARCHAR(6),
  "VDEP10"	 VARCHAR(10),
  "CDEP11"	 VARCHAR(6),
  "VDEP11"	 VARCHAR(10),
  "CDEP12"	 VARCHAR(6),
  "VDEP12"	 VARCHAR(10),
 PRIMARY KEY ("CODEMP", "CODCAD", "ANOMES", "CODFOL","CODOPE")
);
@EXECSQL

