CREATE TABLE `Influence` (
    `Influence_ID`  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `SetupName` TEXT NOT NULL,
    `Assessment` TEXT,
    `Parameter` TEXT,
    `Zone`  TEXT,
    `Target`    NUMERIC,
    `PA` NUMERIC
);

CREATE TABLE `InfluenceStructures` (
    `InfluenceStructure_ID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `StructureType` TEXT NOT NULL,
    `Assessment`    TEXT NOT NULL,
    `Parameter`     TEXT,
    `Zone`          TEXT NOT NULL,
    `Target`        TEXT,
    `PA`            NUMERIC
);

INSERT INTO Influence (SetupName, Assessment, Parameter, Zone, Target, PA)
                                   SELECT "NOmbreQueQuiero",Assessment, Parameter, Zone, 5555, PA
                                   FROM InfluenceStructures
                                   WHERE StructureType="multiNoFail" AND Target="V"