CREATE TABLE `purifier` (
    `pid` int(8) NOT NULL auto_increment,

    `code` varchar(255) NOT NULL default '',
    `name` varchar(255) NOT NULL default '',
    `abstract` TEXT default NULL,
    `content` TEXT default NULL,
    `manufacturer` int(8) NOT NULL,
    `cleaning_method` varchar(255) default NULL,
    `max_room_size` varchar(255) default NULL,
    `cadr` varchar(255) default NULL,
    `uv_details` varchar(255) default NULL,

    `gas_filter` varchar(255) default NULL,
    `gas_price` varchar(255) default NULL,
    `gas_filter_life` varchar(255) default NULL,

    `particle_filter` varchar(255) default NULL,
    `particle_price` varchar(255) default NULL,
    `particle_filter_eff` varchar(255) default NULL,
    `particle_filter_life` varchar(255) default NULL,

    `pre_filter` varchar(255) default NULL,
    `pre_price` varchar(255) default NULL,
    `pre_filter_life` varchar(255) default NULL,

    `other_filter` varchar(255) default NULL,
    `ease_filter_change` varchar(255) default NULL,
    `filter_change_info` varchar(255) default NULL,
    `filter_change_notification` smallint(1) default NULL,

    `dimensions` varchar(255) default NULL,
    `weight_in` varchar(255) default NULL,
    `decibels` varchar(255) default NULL,
    `speeds` varchar(255) default NULL,
    `mobility` varchar(255) default NULL,
    `materials` varchar(255) default NULL,
    `grounded` smallint(1) default NULL,
    `color_options` varchar(255) default NULL,
    `energy_consumption` varchar(255) default NULL,
    `cfm` varchar(255) default NULL,

    `control_type` varchar(255) default NULL,
    `control_options` varchar(255) default NULL,

    `warranty` varchar(255) default NULL,
    `award` varchar(255) default NULL,
    `annual_cost` float default NULL,
    `annual_5year_cost` float default NULL,
    `price` float default NULL,
    
    `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
    `visible` smallint(1) NOT NULL default '1',
     PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE `purifier_manufacturer` (
    `mid` int(8) NOT NULL auto_increment,
    `name` varchar(255) NOT NULL default '',
    `telephone` varchar(255) default NULL,
    `website` varchar(255) default NULL,
    `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
    `visible` smallint(1) NOT NULL default '1',
     PRIMARY KEY  (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
