2t9ADe18

1CREATE TABLE IF NOT EXISTS `company_group` (
2  `cg_id` int(11) NOT NULL AUTO_INCREMENT,
3  `cg_title` varchar(255) NOT NULL,
4  `cg_description` text NOT NULL,
5  PRIMARY KEY (`cg_id`)
6) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
7
8
9CREATE TABLE IF NOT EXISTS `company_group_company_ref` (
10  `cgcr_id` int(11) NOT NULL AUTO_INCREMENT,
11  `cgcr_company_group_id` int(11) NOT NULL,
12  `cgrc_company_id` int(11) NOT NULL,
13  PRIMARY KEY (`cgcr_id`),
14  KEY `cgcr_company_group_id` (`cgcr_company_group_id`),
15  KEY `cgrc_company_id` (`cgrc_company_id`),
16   CONSTRAINT `fk_cgcr_company_group_id`
17    FOREIGN KEY (`cgcr_company_group_id`)
18    REFERENCES `company_group` (`cg_id`)
19    ON DELETE CASCADE,
20  CONSTRAINT `fk_cgrc_company_id`
21    FOREIGN KEY (`cgrc_company_id`)
22    REFERENCES `company` (`comp_id`)
23    ON DELETE CASCADE
24) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;