ZJ4iq55P

1-- Table mydb.table1_has_user -- 
2-----------------------------------------------------
3 CREATE TABLE IF NOT EXISTS mydb.table1_has_user
4      ( table1_id INT NOT NULL,
5        user_user id INT NOT NULL,
6        PRIMARY KEY (table1_id, user_user id),
7        INDEX fk_table1_has_user_user1_idx (user_user id ASC) VISIBLE,
8        INDEX fk_table1_has_user_table1_idx (table1_id ASC) VISIBLE,
9        CONSTRAINT fk_table1_has_user_table1 FOREIGN KEY (table1_id)
10            REFERENCES mydb.table1 (id) ON DELETE NO ACTION ON UPDATE NO ACTION,
11        CONSTRAINT fk_table1_has_user_user1 FOREIGN KEY (user_user id) 
12            REFERENCES mydb.user (user id) ON DELETE NO ACTION ON UPDATE NO ACTION
13     ) ENGINE = InnoDB
14
15SQL script execution finished: statements: 7 succeeded, 1 failed
16
17Fetching back view definitions in final form.
18Nothing to fetch