kelude / canrd-patent · Files

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

ALTER SCHEMA `patent`  DEFAULT COLLATE utf8mb4_general_ci ;

CREATE TABLE IF NOT EXISTS `patent`.`casement` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NULL DEFAULT NULL,
  `caseSn` VARCHAR(32) NOT NULL,
  `case_type` VARCHAR(32) NOT NULL COMMENT 'å‘明类型：INVE' /* comment truncated */ /*TION_TYPE
实用新型：PRACTICAL_NEW
外观设计：APPEARENCE_DESIGN
å‘明+新型：INVENTION_NEW*/,
  `service_type` VARCHAR(32) NOT NULL COMMENT '标准æœåŠ¡ï¼šSTANDE' /* comment truncated */ /*D_SERVICE
æ‹…ä¿æŽˆæƒï¼šAUTHORITY_GUARANTEE*/,
  `paid_type` VARCHAR(32) NOT NULL COMMENT '缴纳ï' /* comment truncated */ /*šPAID
ä¸ç¼´çº³ï¼šNO_PAID*/,
  `reduce_type` VARCHAR(32) NULL DEFAULT NULL,
  `expense` BIGINT(20) NOT NULL,
  `formula` VARCHAR(128) NULL DEFAULT NULL COMMENT '计算公å¼',
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4;

ALTER TABLE `patent`.`test` 
COLLATE = utf8mb4_general_ci ;

ALTER TABLE `patent`.`mybatis_test` 
COLLATE = utf8mb4_general_ci ;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;