CREATE TABLE `tblcontractor_associations` (
	`id`				BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
	`name`			VARCHAR(200) NOT NULL,
	`logo`			VARCHAR(140) NOT NULL,
	`url`				VARCHAR(150) NULL DEFAULT NULL,
	`is_active`	TINYINT(1) DEFAULT 1,
	`added_on`  TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO `tbloptions_static` (`name`, `value`, `autoload`)
	VALUES ('is_contractor_association_enabled', '0', '1'),
	('contractor_associations', '', '1');
	
INSERT INTO `tbloptions` (`tenant_id`, `name`, `value`, `autoload`)
	SELECT `id`, 'is_contractor_association_enabled', '0', '1' 
		FROM `tbltenants`;
		
INSERT INTO `tbloptions` (`tenant_id`, `name`, `value`, `autoload`)
	SELECT `id`, 'contractor_associations', '', '1' 
		FROM `tbltenants`;		