create table redshift

gistfile1.txt

CREATE TABLE mydata 
(
  lastname    VARCHAR(30) NOT NULL,
  firstname   VARCHAR(30) NOT NULL,
  gender      CHAR(1) NOT NULL,
  state       VARCHAR(30) NOT NULL,
  age         SMALLINT NOT NULL,
  month       SMALLINT NOT NULL,
  day         SMALLINT NOT NULL,
  hour        SMALLINT NOT NULL,
  minutes     SMALLINT NOT NULL,
  items       SMALLINT NOT NULL,
  basket      INTEGER NOT NULL
);