CREATE TABLE DETALLE_PLANILLA
( ID_PLANILLA INTEGER NOT NULL,
CODEMPLEADO INTEGER DEFAULT 0 NOT NULL,
IDENTIDAD VARCHAR(20) CHARACTER SET NONE COLLATE NONE,
PROMEDIO_SEMANA NUMERIC(12, 2) DEFAULT 0 NOT NULL,
HORAS_NOR NUMERIC(3, 2) DEFAULT 0 NOT NULL,
TOTAL_VALOR_NOR NUMERIC(12, 2) DEFAULT 0 NOT NULL,
HORAS_EXT1 NUMERIC(3, 2) DEFAULT 0 NOT NULL,
HORAS_EXT2 NUMERIC(3, 2) DEFAULT 0 NOT NULL,
HORAS_EXT3 NUMERIC(3, 2) DEFAULT 0 NOT NULL,
VALOR_EXT1 NUMERIC(12, 2) DEFAULT 0 NOT NULL,
VALOR_EXT2 NUMERIC(12, 2) DEFAULT 0 NOT NULL,
VALOR_EXT3 NUMERIC(12, 2) DEFAULT 0 NOT NULL,
TOTAL_VALOR_EXT NUMERIC(12, 2) DEFAULT 0 NOT NULL,
FERIADO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
AJUSTE NUMERIC(12, 2) DEFAULT 0 NOT NULL,
BONO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
SABADO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
DOMINGO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
BRUTO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
IHSS NUMERIC(12, 2) DEFAULT 0 NOT NULL,
ISR NUMERIC(12, 2) DEFAULT 0 NOT NULL,
TOTAL_DEDUC NUMERIC(12, 2) DEFAULT 0 NOT NULL,
PAGO_NETO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
PAGO_NETO_REDONDO NUMERIC(12, 2) DEFAULT 0 NOT NULL,
IDLINEA INTEGER NOT NULL, IHSS_EMP NUMERIC(12, 2) DEFAULT 0.0 NOT NULL,
ID_REG BIGINT DEFAULT 0 NOT NULL);
ALTER TABLE DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANILLA FOREIGN KEY (ID_PLANILLA) REFERENCES MAESTRO_PLANILLA(ID_PLANILLA) ON UPDATE CASCADE;
ALTER TABLE DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANILLA1 FOREIGN KEY (IDLINEA) REFERENCES LINEA(IDLINEA) ON UPDATE CASCADE; ALTER TABLE
DETALLE_PLANILLA ADD CONSTRAINT FK_DETALLE_PLANIL_EMPLEADOS FOREIGN KEY (CODEMPLEADO) REFERENCES EMPLEADOS(CODEMPLEADO) ON UPDATE CASCADE;
CREATE INDEX IDX_CODEMPLEADO ON DETALLE_PLANILLA(CODEMPLEADO);
CREATE INDEX IDX_IDENTIDAD ON DETALLE_PLANILLA(IDENTIDAD);