usertechlist

CREATE TABLE `sitedb`.`usertechlist` ( user_id BIGINT(20) NOT NULL, tech_id BIGINT(20) NOT NULL, PRIMARY KEY (user_id, tech_id), FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (tech_id) REFERENCES technologylist(id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;