   `EDIT_MODE` varchar(1) NOT NULL DEFAULT 'N',
   `IS_DIALOG` varchar(1) NOT NULL DEFAULT 'N',
   `IS_WINDOW` varchar(1) NOT NULL DEFAULT 'N',
-  `DIALOG_W` int(4) NOT NULL DEFAULT '0',
-  `DIALOG_H` int(4) NOT NULL DEFAULT '0',
+  `DIALOG_W` int(4) NOT NULL DEFAULT 0,
+  `DIALOG_H` int(4) NOT NULL DEFAULT 0,
   `PROG_SYSTEM` varchar(10) NOT NULL,
   `ITEM_TYPE` varchar(10) NOT NULL,
   `ICON` varchar(20) NOT NULL,

  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_z_bsc_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_z_bsc_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)


LOCK TABLES `bb_formula` WRITE;
/*!40000 ALTER TABLE `bb_formula` DISABLE KEYS */;
INSERT INTO `bb_formula` VALUES ('3253a746-a50e-457f-bd38-9647e159e5dd','F888','F888 Example for R','R','N','D','','if(actual<1) {\n    ans <- 0\n} else if (actual>target) {\n    ans <- target\n} else ans <- ( sum( rnorm(100, mean=actual, sd=3) ) / (target*100)   ) * 100','is a sample for R language!','admin','2016-11-15 19:54:17','admin','2016-11-15 19:54:46'),('b58b87cc-e938-4538-9617-4656788492cb','F777','KPI trends change(%)','GROOVY','Y','C','ans','if ( (float)cv!=0.0 && (float)pv!=0.0 ) {\n    ans = ( cv ÷ pv - 1 ) × 100.0;\n    return;\n}\nif ( (float)cv==0.0 ) {\n    ans = pv * -1.0;   \n    return;\n}\nif ( (float)pv==0.0 ) {\n    ans = cv;\n    return;\n}\nans = 0.0;\n\n','for KPI peroid current/previous score change(%)','admin','2015-10-15 16:09:02','admin','2020-06-28 15:49:18'),('bfc7c7df-0e7a-448b-b666-a9a2f7a7f950','F999','F999 Example for jython','PYTHON','N','C','ans','import math;\nans = math.sqrt( actual ÷ target ) × 100','is a sample!','admin','2014-11-20 10:03:12','admin','2014-11-20 15:49:10'),('d382b6ab-fe55-4c93-8c8e-79896ed09f7a','F001','F001 percent of target','GROOVY','N','C','ans','import org.apache.commons.lang3.math.*;\nimport java.lang.*;\n\nif (actual > 0 && target > 0 ) {\n    ans = Math.max( actual ÷ target ,  0 ) × 100;\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nif (\n    (actual <= 0 && target < 0 && actual >= target)\n    ||\n    (actual <= 0 && target < 0 && actual < target)\n    ||\n    (actual > 0 && target < 0 )\n) {\n    ans = ((((target - actual) ÷ target) × 100) + 100);\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nif (actual < 0 && target > 0 ) {\n    ans = ((((actual - target) ÷ target) × 100) + 100);\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nif (actual == 0 && target > 0 ) {\n    ans = 0;\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nif (actual >= 0 && target == 0 ) {\n    ans = ((actual × 100) + 100);\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nif (actual < 0 && target == 0 ) {\n    ans = ((actual × 100) + 100);\n    ans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\n    return ans;\n}\nans = 0;\nans = NumberUtils.toFloat( String.valueOf(ans), 0.0f);\nreturn ans;','Calculating percent of target.','admin','2014-11-19 11:39:03','admin','2016-05-10 19:13:34'),('e2d2dc04-ed37-471b-ac73-7de51dfa4721','F002','F002 for return actual','BSH','N','D','','actual','for return actual !','admin','2014-11-19 11:45:13',NULL,NULL);
/*!40000 ALTER TABLE `bb_formula` ENABLE KEYS */;
UNLOCK TABLES;

