CREATE ENCRYPT RULE

    • encryptAlgorithmType specifies the encryption algorithm type, please refer to
    • Duplicate tableName will not be created
    • queryWithCipherColumn support uppercase or lowercase true or false

    Create a encrypt rule

    1. CREATE ENCRYPT RULE t_encrypt (
    2. COLUMNS(
    3. (NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
    5. t_encrypt_2 (
    6. COLUMNS(
    7. (NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
    8. (NAME=order_id, CIPHER=order_cipher,TYPE(NAME='MD5'))
    9. ), QUERY_WITH_CIPHER_COLUMN=FALSE);

    CREATE, ENCRYPT, , COLUMNS, NAME, CIPHER, PLAIN, QUERY_WITH_CIPHER_COLUMN, TYPE, TRUE, FALSE