All pastes #494929 Raw Edit

Someone

public text v1 · immutable
·published 2007-05-18 14:10 UTC
rendered paste body
CREATE 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