CREATE ENCRYPT RULE

    • PLAIN specifies the plain column, CIPHER specifies the cipher column
    • encryptAlgorithmType specifies the encryption algorithm type, please refer to Encryption Algorithm
    • 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(
    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'))

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