数据加密

    • 指定明文数据列，CIPHER 指定密文数据列
    • encryptAlgorithmType 指定加密算法类型，请参考 加密算法
    • 重复的 tableName 将无法被创建
    • queryWithCipherColumn 支持大写或小写的 true 或 false

    示例

    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;