text: SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for linkis_udf_manager
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf_manager`;
  CREATE TABLE `linkis_udf_manager` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(20) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  
  
  -- ----------------------------
  -- Table structure for linkis_udf_shared_group
  -- An entry would be added when a user share a function to other user group
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf_shared_group`;
  CREATE TABLE `linkis_udf_shared_group` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `udf_id` bigint(20) NOT NULL,
    `shared_group` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  -- ----------------------------
  -- Table structure for linkis_udf_shared_user
  -- An entry would be added when a user share a function to another user
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf_shared_user`;
  CREATE TABLE `linkis_udf_shared_user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `udf_id` bigint(20) NOT NULL,
    `user_name` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  
  
  -- ----------------------------
  -- Table structure for linkis_udf_tree
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf_tree`;
  CREATE TABLE `linkis_udf_tree` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `parent` bigint(20) NOT NULL,
    `name` varchar(100) DEFAULT NULL COMMENT 'Category name of the function. IT would be displayed in the front-end',
    `user_name` varchar(50) NOT NULL,
    `description` varchar(255) DEFAULT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `category` varchar(50) DEFAULT NULL COMMENT 'Used to distinguish between udf and function',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  
  
  -- ----------------------------
  -- Table structure for linkis_udf_user_load_info
  -- Used to store the function a user selects in the front-end
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf_user_load_info`;
  CREATE TABLE `linkis_udf_user_load_info` (
    `udf_id` int(11) NOT NULL,
    `user_name` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  -- ----------------------------
  -- Table structure for linkis_udf
  -- ----------------------------
  DROP TABLE IF EXISTS `linkis_udf`;
  CREATE TABLE `linkis_udf` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `create_user` varchar(50) NOT NULL,
    `udf_name` varchar(255) NOT NULL,
    `udf_type` int(11) DEFAULT '0',
    `path` varchar(255) DEFAULT NULL COMMENT 'Path of the referenced function',
    `register_format` varchar(255) DEFAULT NULL,
    `use_format` varchar(255) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `is_expire` bit(1) DEFAULT NULL,
    `is_shared` bit(1) DEFAULT NULL,
    `tree_id` bigint(20) NOT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  