DROP TABLE IF EXISTS org;
CREATE TABLE org (
  id 	int NOT NULL,
  name 	varchar(255) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
  id 	int NOT NULL,
  name 	varchar(255) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=InnoDB;

DROP TABLE IF EXISTS orgstruct;
CREATE TABLE orgstruct (
  org_id		int NOT NULL,
  employee_id 	int NOT NULL,
  subord_id 	int NOT NULL,
  PRIMARY KEY	(org_id, employee_id, subord_id),
  INDEX (org_id),
  INDEX (employee_id),
  INDEX (subord_id),
  FOREIGN KEY (org_id) REFERENCES org (id),
  FOREIGN KEY (employee_id) REFERENCES employee (id),
  FOREIGN KEY (subord_id) REFERENCES employee (id)
) TYPE=InnoDB;