PostgreSQL to MySQL

Hello,

Bellow is PostgreSQL table.

-- Table: document
CREATE TABLE document (
    id int  NOT NULL,
    description varchar(1024)  NOT NULL,
    location varchar(1024)  NOT NULL,
    patient_id int  NOT NULL,
    CONSTRAINT document_pk PRIMARY KEY (id)
);

-- Reference: document_patient (table: document)
ALTER TABLE document ADD CONSTRAINT document_patient
    FOREIGN KEY (patient_id)
    REFERENCES patient (id)
    NOT DEFERRABLE
    INITIALLY IMMEDIATE
;

Code (markup):

How...

PostgreSQL to MySQL

from Databases https://ift.tt/2LAEphf
via IFTTT