
--
-- Table structure for table `members`
--
CREATE TABLE members (
  id integer(6) NOT NULL auto_increment,
  passwd varchar(32) default NULL,
  include_name enum('Y','N') default 'N',
  include_home_address enum('Y','N') default 'N',
  include_clinic_address enum('Y','N') default 'N',
  include_contact_number enum('Y','N') default 'N',
  include_email enum('Y','N') default 'N',
  include_website enum('Y','N') default 'N',
  firstname varchar(20) default NULL,
  secondname varchar(20) default NULL,
  surname varchar(20) default NULL,
  email varchar(60) default NULL,
  qualifications text,
  cpd enum('Y','N') default 'N',  
  cpd_text text,
  cpd_hours int(4) default NULL,
  criminal_record text,
  english text,
  health text,
  description text,
  comply enum('Y','N') default 'N',
  advert_standards enum('Y','N') default 'N',
  data_protection enum('Y','N') default 'N',
  agree enum('Y','N') default 'N',
  join_date date default NULL,
  expiry_date date default NULL,
  mandate enum('Y','N') default 'N',
  approved enum('Y','N') default 'N',
  member_no int(4) default NULL,
  PRIMARY KEY (id))
  ENGINE=MyISAM;
--
-- Table structure for table `addresses`
--
 CREATE TABLE addresses (
  id integer(6) NOT NULL auto_increment,
  member_id integer(6) NOT NULL,
  address_type enum('home','clinic1','clinic2','clinic3') default NULL,
  clinic_name varchar(25) default NULL,
  address varchar(30) default NULL,
  town varchar(20) default NULL,
  city varchar(20) default NULL,
  borough varchar(15) default NULL,
  county varchar(20) default NULL,
  postcode varchar(10) default NULL,
  country varchar(20) default NULL,
  phone varchar(15) default NULL,
  website varchar(20) default NULL,
  PRIMARY KEY (id))
  ENGINE=MyISAM;
 --
-- Table structure for table `addresses`
--
 CREATE TABLE certificates (
  id integer(6) NOT NULL auto_increment,
  member_id integer(6) NOT NULL,
  certificate_type enum('training1','training2','training3','cpd1','cpd2','cpd3','insurance','firstaid','licence','disposal') default NULL,
  file_location varchar(30) default NULL,
  PRIMARY KEY (id))
  ENGINE=MyISAM;
--
-- Table structure for table `therapies`
--
CREATE TABLE therapies (
  id integer(6) NOT NULL auto_increment,
  member_id integer(6) NOT NULL,
  therapy varchar(3) NOT NULL,
  PRIMARY KEY (id),
  KEY (member_id))
  ENGINE=MyISAM;
