rendered paste bodyCREATE TABLE `categories` (
`categoryId` int(11) NOT NULL auto_increment,
`categoryType` enum('Sector','Profession','Specialty','Practice Area') default NULL,
`categoryTitle` varchar(100) default NULL,
PRIMARY KEY (`categoryId`),
UNIQUE KEY `categoryTitle` (`categoryTitle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
CREATE TABLE `group_categories` (
`care_bundle_id` int(11) NOT NULL,
`categoryId` int(11) NOT NULL,
KEY `categoryId` (`categoryId`),
KEY `care_bundle_id` (`care_bundle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1