sys_optionset.sql 714 B

123456789101112
  1. CREATE TABLE `sys_optionset` (
  2. `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  3. `name` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  4. `code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  5. `value` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  6. `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  7. `create_time` datetime(0) NOT NULL,
  8. `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  9. `last_update_time` bigint(20) NOT NULL,
  10. `del_flag` int(11) NOT NULL,
  11. PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;