Encrypt

    Notes

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

    Example

    1. COLUMNS(
    3. (NAME=order_id, CIPHER =order_cipher,TYPE(NAME='MD5'))
    4. ), QUERY_WITH_CIPHER_COLUMN=true),
    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'))
    10. ALTER ENCRYPT RULE t_encrypt (
    11. COLUMNS(
    12. (NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),
    13. (NAME=order_id,CIPHER=order_cipher,TYPE(NAME='MD5'))
    14. ), QUERY_WITH_CIPHER_COLUMN=TRUE);
    16. DROP ENCRYPT RULE t_encrypt,t_encrypt_2;