`individual` int(16) unsigned default NULL,
`date` date default NULL,
`notes` text,
- `interview_type` enum('hti','ppi') NOT NULL DEFAULT 'hti',
+ `type` enum('H','P') NOT NULL DEFAULT 'H',
PRIMARY KEY (`interview`)
) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
`companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `tc_companionship` INT( 16 ) UNSIGNED NOT NULL ,
`district` INT( 16 ) UNSIGNED NULL DEFAULT NULL
) ENGINE = MYISAM ;