CREATE TABLE `Member` (
  `loginName`  VARCHAR(20) NOT NULL,
  `password`   CHAR(255)   NOT NULL,
  `createDate` DATE        NOT NULL,
  `lastName`   VARCHAR(50),
  `firstName`  VARCHAR(40),
  `street`     VARCHAR(50),
  `city`       VARCHAR(50),
  `state`      CHAR(2),
  `zip`        CHAR(10),
  `email`      VARCHAR(50),
  `phone`      CHAR(15),
  `fax`        CHAR(15),
  PRIMARY KEY  (`loginName`)
)  ;