...
CREATE TABLE IF NOT EXISTS `measures` (
`measure_id` int(11) NOT NULL AUTO_INCREMENT,
`author_id` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`name_friendly` texttext DEFAULT NULL,
`name_official` texttext DEFAULT NULL,
`name_internal` texttext DEFAULT NULL,
`description_friendly` texttext DEFAULT NULL,
`description_long` texttext DEFAULT NULL,
`author_measure_id` texttext DEFAULT NULL,
`author_measure_specs` texttext DEFAULT NULL,
`rationale_long` texttext DEFAULT NULL,
`rationale_friendly` texttext DEFAULT NULL,
`evidence` enum('more_is_better','less_is_better','no_evidence','no_difference','within_range_is_better') NOT NULL DEFAULT 'more_is_better',
`measure_type` enum('process','outcome','access','experience','utilization','structure','population') DEFAULT NULL,
`default_unit` enum('percent','per 1000','per 100000','cases','ratio','days','hours','patients','dollars','na','minutes','people','square miles','years','households','per 100','per 10000','micrograms') DEFAULT 'percent',
`measure_incept_date` date NOT NULL DEFAULT '0000-00-00',
`measure_expiry_date` date NOT NULL DEFAULT '0000-00-00',
`nqf_endorsed` enum('0','1') NOT NULL DEFAULT '0',
`nqf_endorsed_date` date NOT NULL DEFAULT '0000-00-00',
`numerator_definition` texttext DEFAULT NULL,
`denominator_definition` texttext DEFAULT NULL,
`minimum_sample` int(11) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`measure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17109 ;
...