CRT_FUN|comp_testfun|
()
RETURNS VARCHAR(20)
DETERMINISTIC
BEGIN
  DECLARE abc VARCHAR(20);  
  SET abc ='222';
  RETURN(abc);
END

**

CRT_TBL|comp_purchase_document|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`ref_id` INT(11) NULL DEFAULT NULL,
	`document_name` VARCHAR(500) NULL DEFAULT NULL,
	`abc` VARCHAR(500) NULL DEFAULT NULL,
	`cr_date` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
	`cr_usr` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
**
CRT_TBL|comp_abc|`id` INT(11) NOT NULL AUTO_INCREMENT,
	`doc_id` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `FK_comp_abc_comp_purchase_document` (`doc_id`) USING BTREE,
	CONSTRAINT `FK_comp_abc_comp_purchase_document` FOREIGN KEY (`doc_id`) REFERENCES `comp_purchase_document` (`id`) ON UPDATE RESTRICT ON DELETE NO ACTION
**
