Skip to content

Support Foreign Key ON UPDATE CASCADE  #985

@dprutean

Description

@dprutean

Two more statements to check ( ON UPDATE [RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT})

ALTER TABLE texto
ADD CONSTRAINT texto_autor_id_foreign FOREIGN KEY (autor_id) REFERENCES users (id) ON UPDATE CASCADE,
ADD CONSTRAINT texto_tipotexto_id_foreign FOREIGN KEY (tipotexto_id) REFERENCES tipotexto (id) ON UPDATE CASCADE

Encountered unexpected token: "UPDATE" "UPDATE"
at line 2, column 97.

ALTER TABLE texto_fichero
ADD CONSTRAINT texto_fichero_fichero_id_foreign FOREIGN KEY (fichero_id) REFERENCES fichero (id) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT texto_fichero_texto_id_foreign FOREIGN KEY (texto_id) REFERENCES texto (id) ON DELETE CASCADE ON UPDATE CASCADE

Encountered unexpected token: "ON" "ON"
at line 2, column 126.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions