text: 
  CREATE TABLE table_b (
    b_id int NOT NULL AUTO_INCREMENT,
    b_value int NOT NULL,
    PRIMARY KEY(b_id),
    FOREIGN KEY (b_id) REFERENCES table_a (a_id) ON UPDATE CASCADE
  ) ENGINE=InnoDB;
  
  CREATE TABLE table_c2 (
    c_id int NOT NULL AUTO_INCREMENT,
    c_value int NOT NULL,
    PRIMARY KEY(c_id),
    UNIQUE KEY (c_value),
    FOREIGN KEY (c_id) REFERENCES table_a (a_id) ON UPDATE CASCADE
  ) ENGINE=InnoDB;
  
  
  
  CREATE TABLE table_a (
    a_id int NOT NULL AUTO_INCREMENT,
    a_value1 char(12) NOT NULL DEFAULT '',
    a_value2 int NOT NULL,
    PRIMARY KEY (a_id),
    KEY(a_value2)
  ) ENGINE=InnoDB;
  