CREATE TABLE `t_acs_test` (
  `f_primary_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `f_doc_id` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `f_accessor_id` char(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `f_accessor_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `f_accessor_type` tinyint(4) NOT NULL,
  `f_type` tinyint(4) NOT NULL,
  `f_perm_value` int(11) NOT NULL DEFAULT 1,
  `f_end_time` bigint(20) DEFAULT -1,
  `f_modify_time` bigint(20) NOT NULL DEFAULT 0,
  `f_create_time` bigint(20) NOT NULL,
  PRIMARY KEY (`f_primary_id`),
  KEY `t_perm_f_doc_id_index` (`f_doc_id`(120)),
  KEY `t_perm_f_accessor_id_index` (`f_accessor_id`),
  KEY `t_perm_f_accessor_type_index` (`f_accessor_type`),
  KEY `t_perm_f_type_index` (`f_type`),
  KEY `t_perm_f_end_time_index` (`f_end_time`) USING BTREE
) ENGINE=InnoDB
