Actualizar, Eliminar llaves primarias de una tabla y sus tablas hijas

Revision: 34910

at October 30, 2010 04:11 by JohnnyGamba

Initial Code

CREATE TABLE Bugs (

    reported_by BIGINT UNSIGNED NOT NULL,
    status VARCHAR(20) NOT NULL DEFAULT 'NEW' ,

    FOREIGN KEY (reported_by) REFERENCES Accounts(account_id)
      ON UPDATE CASCADE
      ON DELETE RESTRICT,

    FOREIGN KEY (status) REFERENCES BugStatus(status)
      ON UPDATE CASCADE
      ON DELETE SET DEFAULT
);

Initial URL

Initial Description

Initial Title

Actualizar, Eliminar llaves primarias  de una tabla y sus tablas hijas

Initial Tags

sql

Initial Language

SQL

Choose a language for easy browsing: