create table graphod (
      symbol varchar(10),
      day date,
      open float(11,5) unsigned,
      high float(11,5) unsigned,
      low float(11,5) unsigned,
      close float(11,5) unsigned,
      volume int(10) unsigned,
      adjclose float(11,5) unsigned
      );

create table data_table (
      symbol varchar(10) PRIMARY KEY NOT NULL,
      name varchar(80),
      location varchar(25)
      );

alter table graphod add primary key (symbol, day);