DROP Table member;

CREATE TABLE member (
  m_ID varchar(12) NOT NULL default '0',
  m_userID varchar(48) NOT NULL default '',
  m_password varchar(24) NOT NULL default '',
  m_type char(1) NOT NULL default '',
  m_name varchar(100) default NULL,
  m_organization varchar(100) default NULL,
  m_phone varchar(24) default NULL,
  m_fax varchar(24) default NULL,
  m_email varchar(100) default NULL,
  m_address varchar(100) default NULL,
  m_postalCode varchar(12) default NULL,
  m_country varchar(48) default NULL,
  m_newsletter int(1) default '0',
  m_howToKnow varchar(100) default NULL,
  m_howToKnowOthers varchar(100) default NULL,
  m_date date default NULL,
  m_status int(1) default '0',
  PRIMARY KEY  (m_ID),
  KEY m_userID (m_userID)
) TYPE=MyISAM;

--
-- Dumping data for table `member`
--

INSERT INTO member VALUES ('201002000000','isolution','mike','A','Mike Cha','IMT-Digital','604-676-1727','604-221-7792','mail@imt-digital.com','','','Canada','0','','','0000-00-00',0);