CREATE TABLE NATION (
   N_NATIONKEY    int(10),
   N_NAME         char(25),
   N_REGIONKEY    int(10),
   N_COMMENT      varchar(152),
      PRIMARY KEY (N_NATIONKEY)
TYPE=INNODB;

CREATE TABLE SUPPLIER (
   S_SUPPKEY   int(10),
   S_NAME      char(25),
   S_ADDRESS   varchar(40),
   S_NATIONKEY int(10),
   S_PHONE     char(15),
   S_ACCTBAL   dec(10,2),
   S_COMMENT   varchar(101),
      PRIMARY KEY (S_SUPPKEY),
      INDEX S_NATIONKEY_INDX (S_NATIONKEY),
      FOREIGN KEY (S_NATIONKEY) REFERENCES NATION(N_NATIONKEY) ON DELETE NO ACTION)
TYPE=INNODB;

CREATE TABLE PARTSUPP (
   PS_PARTKEY     int(10),
   PS_SUPPKEY     int(10),
   PS_AVAILQTY    int(10),
   PS_SUPPLYCOST  dec(10,2),
   PS_COMMENT     varchar(199),
      PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY),
      INDEX PS_SUPPKEY_INDX (PS_SUPPKEY),
      FOREIGN KEY (PS_SUPPKEY) REFERENCES SUPPLIER(S_SUPPKEY) ON DELETE NO ACTION)
TYPE=INNODB;