数据库改为snake_case脚本

-- PostgreSQL existing database rename script.
-- 作用：把现有表名和字段名调整为 PostgreSQL 推荐的全小写 snake_case。
-- 执行前请先备份数据库；本脚本不修改 EF 迁移历史表。

DO $$
BEGIN
    -- data_Affixs: columns
    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'id') THEN
        ALTER TABLE public."data_Affixs" RENAME COLUMN "ID" TO "id";
    END IF;

    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'FileName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'file_name') THEN
        ALTER TABLE public."data_Affixs" RENAME COLUMN "FileName" TO "file_name";
    END IF;

    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'Size')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'size') THEN
        ALTER TABLE public."data_Affixs" RENAME COLUMN "Size" TO "size";
    END IF;

    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'Path')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'path') THEN
        ALTER TABLE public."data_Affixs" RENAME COLUMN "Path" TO "path";
    END IF;

    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Affixs' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_Affixs" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    -- data_ArchiveCategory: columns
    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'RowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "RowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'ParentRowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'parent_row_id') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "ParentRowID" TO "parent_row_id";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'CategoryNo')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'category_no') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "CategoryNo" TO "category_no";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'CategoryDescription')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'category_description') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "CategoryDescription" TO "category_description";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'ViewType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'view_type') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "ViewType" TO "view_type";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "Sort" TO "sort";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'ShowInHome')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'show_in_home') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "ShowInHome" TO "show_in_home";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'Icon')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'icon') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "Icon" TO "icon";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'update_time') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'UpdateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'update_user') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "UpdateUser" TO "update_user";
    END IF;

    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'UpdateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategory' AND column_name = 'update_user_name') THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME COLUMN "UpdateUserName" TO "update_user_name";
    END IF;

    -- data_ArchiveCategoryGroup: columns
    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'CategoryNo')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'category_no') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "CategoryNo" TO "category_no";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'RowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "RowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'ParentRowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'parent_row_id') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "ParentRowID" TO "parent_row_id";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'GroupCode')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'group_code') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "GroupCode" TO "group_code";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'GroupName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'group_name') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "GroupName" TO "group_name";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "Sort" TO "sort";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'GlobalSort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'global_sort') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "GlobalSort" TO "global_sort";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'update_time') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'UpdateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'update_user') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "UpdateUser" TO "update_user";
    END IF;

    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'UpdateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArchiveCategoryGroup' AND column_name = 'update_user_name') THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME COLUMN "UpdateUserName" TO "update_user_name";
    END IF;

    -- data_ArticleComments: columns
    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'Comment')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'comment') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "Comment" TO "comment";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'NickName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'nick_name') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "NickName" TO "nick_name";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'Email')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'email') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "Email" TO "email";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'status') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'CrateUserID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'crate_user_id') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "CrateUserID" TO "crate_user_id";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'IPAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleComments' AND column_name = 'ip_address') THEN
        ALTER TABLE public."data_ArticleComments" RENAME COLUMN "IPAddress" TO "ip_address";
    END IF;

    -- data_ArticleViews: columns
    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'RowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "RowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'ControllerName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'controller_name') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "ControllerName" TO "controller_name";
    END IF;

    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'description') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'IsFillHeight')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'is_fill_height') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "IsFillHeight" TO "is_fill_height";
    END IF;

    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'IsGroups')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'is_groups') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "IsGroups" TO "is_groups";
    END IF;

    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticleViews' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArticleViews" RENAME COLUMN "Sort" TO "sort";
    END IF;

    -- data_Articles: columns
    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'description') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'KeyWord')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'key_word') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "KeyWord" TO "key_word";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'FengMianURL')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'feng_mian_url') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "FengMianURL" TO "feng_mian_url";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'Category')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'category') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "Category" TO "category";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'ArticleTitle')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'article_title') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "ArticleTitle" TO "article_title";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'AriticleContent')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'ariticle_content') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "AriticleContent" TO "ariticle_content";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'Tags')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'tags') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "Tags" TO "tags";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'BaiDuSubmit')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'bai_du_submit') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "BaiDuSubmit" TO "bai_du_submit";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'update_time') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'UpdateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'update_user') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "UpdateUser" TO "update_user";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'UpdateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'update_user_name') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "UpdateUserName" TO "update_user_name";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'Version')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'version') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "Version" TO "version";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'IsPublic')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'is_public') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "IsPublic" TO "is_public";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'OriginURL')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'origin_url') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "OriginURL" TO "origin_url";
    END IF;

    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'ExpandAttribute')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Articles' AND column_name = 'expand_attribute') THEN
        ALTER TABLE public."data_Articles" RENAME COLUMN "ExpandAttribute" TO "expand_attribute";
    END IF;

    -- static_Articles_updates: columns
    IF to_regclass('public."static_Articles_updates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'Category')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'category') THEN
        ALTER TABLE public."static_Articles_updates" RENAME COLUMN "Category" TO "category";
    END IF;

    IF to_regclass('public."static_Articles_updates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'article_id') THEN
        ALTER TABLE public."static_Articles_updates" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."static_Articles_updates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'static_Articles_updates' AND column_name = 'update_time') THEN
        ALTER TABLE public."static_Articles_updates" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    -- data_ArticlesAttrGroup: columns
    IF to_regclass('public."data_ArticlesAttrGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesAttrGroup" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticlesAttrGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'GroupID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'group_id') THEN
        ALTER TABLE public."data_ArticlesAttrGroup" RENAME COLUMN "GroupID" TO "group_id";
    END IF;

    IF to_regclass('public."data_ArticlesAttrGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'ShortTitle')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'short_title') THEN
        ALTER TABLE public."data_ArticlesAttrGroup" RENAME COLUMN "ShortTitle" TO "short_title";
    END IF;

    IF to_regclass('public."data_ArticlesAttrGroup"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrGroup' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArticlesAttrGroup" RENAME COLUMN "Sort" TO "sort";
    END IF;

    -- data_ArticlesAttrProduct: columns
    IF to_regclass('public."data_ArticlesAttrProduct"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesAttrProduct" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticlesAttrProduct"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'GroupID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'group_id') THEN
        ALTER TABLE public."data_ArticlesAttrProduct" RENAME COLUMN "GroupID" TO "group_id";
    END IF;

    IF to_regclass('public."data_ArticlesAttrProduct"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'ProductImages')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrProduct' AND column_name = 'product_images') THEN
        ALTER TABLE public."data_ArticlesAttrProduct" RENAME COLUMN "ProductImages" TO "product_images";
    END IF;

    -- data_ArticlesAttrSort: columns
    IF to_regclass('public."data_ArticlesAttrSort"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesAttrSort" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticlesAttrSort"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'Category')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'category') THEN
        ALTER TABLE public."data_ArticlesAttrSort" RENAME COLUMN "Category" TO "category";
    END IF;

    IF to_regclass('public."data_ArticlesAttrSort"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'LinkTitle')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'link_title') THEN
        ALTER TABLE public."data_ArticlesAttrSort" RENAME COLUMN "LinkTitle" TO "link_title";
    END IF;

    IF to_regclass('public."data_ArticlesAttrSort"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesAttrSort' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArticlesAttrSort" RENAME COLUMN "Sort" TO "sort";
    END IF;

    -- data_ArticlesProtectContent: columns
    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'RowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME COLUMN "RowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'AriticleContent')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'ariticle_content') THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME COLUMN "AriticleContent" TO "ariticle_content";
    END IF;

    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'ProtectType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'protect_type') THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME COLUMN "ProtectType" TO "protect_type";
    END IF;

    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'Data')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesProtectContent' AND column_name = 'data') THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME COLUMN "Data" TO "data";
    END IF;

    -- data_ArticlesTags: columns
    IF to_regclass('public."data_ArticlesTags"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'Tag')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'tag') THEN
        ALTER TABLE public."data_ArticlesTags" RENAME COLUMN "Tag" TO "tag";
    END IF;

    IF to_regclass('public."data_ArticlesTags"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'Sort')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'sort') THEN
        ALTER TABLE public."data_ArticlesTags" RENAME COLUMN "Sort" TO "sort";
    END IF;

    IF to_regclass('public."data_ArticlesTags"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_ArticlesTags" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_ArticlesTags"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTags' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ArticlesTags" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    -- data_ArticlesTagsRelation: columns
    IF to_regclass('public."data_ArticlesTagsRelation"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTagsRelation' AND column_name = 'Tag')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTagsRelation' AND column_name = 'tag') THEN
        ALTER TABLE public."data_ArticlesTagsRelation" RENAME COLUMN "Tag" TO "tag";
    END IF;

    IF to_regclass('public."data_ArticlesTagsRelation"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTagsRelation' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesTagsRelation' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesTagsRelation" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    -- data_ArticlesURLPath: columns
    IF to_regclass('public."data_ArticlesURLPath"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesURLPath' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesURLPath' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ArticlesURLPath" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ArticlesURLPath"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesURLPath' AND column_name = 'URLPath')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ArticlesURLPath' AND column_name = 'url_path') THEN
        ALTER TABLE public."data_ArticlesURLPath" RENAME COLUMN "URLPath" TO "url_path";
    END IF;

    -- data_DynamicForm_ZData: columns
    IF to_regclass('public."data_DynamicForm_ZData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZData' AND column_name = 'dataID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZData' AND column_name = 'data_id') THEN
        ALTER TABLE public."data_DynamicForm_ZData" RENAME COLUMN "dataID" TO "data_id";
    END IF;

    IF to_regclass('public."data_DynamicForm_ZData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZData' AND column_name = 'createTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZData' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_DynamicForm_ZData" RENAME COLUMN "createTime" TO "create_time";
    END IF;

    -- data_DynamicForm_ZDataPValue: columns
    IF to_regclass('public."data_DynamicForm_ZDataPValue"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZDataPValue' AND column_name = 'dataID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_DynamicForm_ZDataPValue' AND column_name = 'data_id') THEN
        ALTER TABLE public."data_DynamicForm_ZDataPValue" RENAME COLUMN "dataID" TO "data_id";
    END IF;

    -- data_Images: columns
    IF to_regclass('public."data_Images"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images' AND column_name = 'rowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_Images" RENAME COLUMN "rowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_Images"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images' AND column_name = 'createTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_Images" RENAME COLUMN "createTime" TO "create_time";
    END IF;

    -- data_Images_Debug: columns
    IF to_regclass('public."data_Images_Debug"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images_Debug' AND column_name = 'rowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images_Debug' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_Images_Debug" RENAME COLUMN "rowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_Images_Debug"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images_Debug' AND column_name = 'createTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Images_Debug' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_Images_Debug" RENAME COLUMN "createTime" TO "create_time";
    END IF;

    -- data_Issues: columns
    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'id') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "ID" TO "id";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'Title')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'title') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "Title" TO "title";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'description') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'Content')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'content') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "Content" TO "content";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'LastUpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'last_update_time') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "LastUpdateTime" TO "last_update_time";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'IsPublic')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'is_public') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "IsPublic" TO "is_public";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'status') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'BaiDuSubmit')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Issues' AND column_name = 'bai_du_submit') THEN
        ALTER TABLE public."data_Issues" RENAME COLUMN "BaiDuSubmit" TO "bai_du_submit";
    END IF;

    -- data_IssuesProcess: columns
    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'ProcessID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'process_id') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "ProcessID" TO "process_id";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'IssueID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'issue_id') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "IssueID" TO "issue_id";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'create_user') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'LastUpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'last_update_time') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "LastUpdateTime" TO "last_update_time";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'QuoteID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'quote_id') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "QuoteID" TO "quote_id";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'description') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'Content')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'content') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "Content" TO "content";
    END IF;

    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_IssuesProcess' AND column_name = 'status') THEN
        ALTER TABLE public."data_IssuesProcess" RENAME COLUMN "Status" TO "status";
    END IF;

    -- data_LogUserLogin: columns
    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'IPAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'ip_address') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "IPAddress" TO "ip_address";
    END IF;

    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'Account')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'account') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "Account" TO "account";
    END IF;

    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'Password')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'password') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "Password" TO "password";
    END IF;

    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'LoginTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'login_time') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "LoginTime" TO "login_time";
    END IF;

    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'Path')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'path') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "Path" TO "path";
    END IF;

    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_LogUserLogin' AND column_name = 'status') THEN
        ALTER TABLE public."data_LogUserLogin" RENAME COLUMN "Status" TO "status";
    END IF;

    -- data_PageBuildComponents: columns
    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'Type')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'type') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "Type" TO "type";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'RowID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'row_id') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "RowID" TO "row_id";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'GroupName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'group_name') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "GroupName" TO "group_name";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'pluginName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'plugin_name') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "pluginName" TO "plugin_name";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'pluginDescription')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'plugin_description') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "pluginDescription" TO "plugin_description";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'pluginHtml')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'plugin_html') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "pluginHtml" TO "plugin_html";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'pluginBody')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'plugin_body') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "pluginBody" TO "plugin_body";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'jsString')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'js_string') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "jsString" TO "js_string";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'cssString')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'css_string') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "cssString" TO "css_string";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'isDynamicData')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'is_dynamic_data') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "isDynamicData" TO "is_dynamic_data";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'configParams')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'config_params') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "configParams" TO "config_params";
    END IF;

    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'IsServerLink')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents' AND column_name = 'is_server_link') THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME COLUMN "IsServerLink" TO "is_server_link";
    END IF;

    -- data_PageBuildComponents_Group: columns
    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'id') THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME COLUMN "ID" TO "id";
    END IF;

    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'Name')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'name') THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME COLUMN "Name" TO "name";
    END IF;

    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'description') THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'Content')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'content') THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME COLUMN "Content" TO "content";
    END IF;

    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'cssString')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PageBuildComponents_Group' AND column_name = 'css_string') THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME COLUMN "cssString" TO "css_string";
    END IF;

    -- data_PayOrder: columns
    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'OrderID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'order_id') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "OrderID" TO "order_id";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'UserID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'user_id') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "UserID" TO "user_id";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'OrderType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'order_type') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "OrderType" TO "order_type";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'Amount')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'amount') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "Amount" TO "amount";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'OrderDescription')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'order_description') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "OrderDescription" TO "order_description";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'ExpireTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'expire_time') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "ExpireTime" TO "expire_time";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'status') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'PayType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'pay_type') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "PayType" TO "pay_type";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'PayTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'pay_time') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "PayTime" TO "pay_time";
    END IF;

    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'Data')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_PayOrder' AND column_name = 'data') THEN
        ALTER TABLE public."data_PayOrder" RENAME COLUMN "Data" TO "data";
    END IF;

    -- data_ProtectContentBuyLog: columns
    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'UserID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'user_id') THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME COLUMN "UserID" TO "user_id";
    END IF;

    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'ArticleID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'article_id') THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME COLUMN "ArticleID" TO "article_id";
    END IF;

    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'ContentID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'content_id') THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME COLUMN "ContentID" TO "content_id";
    END IF;

    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'OrderID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'order_id') THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME COLUMN "OrderID" TO "order_id";
    END IF;

    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ProtectContentBuyLog' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    -- data_Templates: columns
    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'templateType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'template_type') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "templateType" TO "template_type";
    END IF;

    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'filePath')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'file_path') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "filePath" TO "file_path";
    END IF;

    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'Name')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'name') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "Name" TO "name";
    END IF;

    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'description') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'templateContent')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'template_content') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "templateContent" TO "template_content";
    END IF;

    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'templateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_Templates' AND column_name = 'template_time') THEN
        ALTER TABLE public."data_Templates" RENAME COLUMN "templateTime" TO "template_time";
    END IF;

    -- data_UserLoginStatus: columns
    IF to_regclass('public."data_UserLoginStatus"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'IPAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'ip_address') THEN
        ALTER TABLE public."data_UserLoginStatus" RENAME COLUMN "IPAddress" TO "ip_address";
    END IF;

    IF to_regclass('public."data_UserLoginStatus"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'LoginType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'login_type') THEN
        ALTER TABLE public."data_UserLoginStatus" RENAME COLUMN "LoginType" TO "login_type";
    END IF;

    IF to_regclass('public."data_UserLoginStatus"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'ErrorCount')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_UserLoginStatus' AND column_name = 'error_count') THEN
        ALTER TABLE public."data_UserLoginStatus" RENAME COLUMN "ErrorCount" TO "error_count";
    END IF;

    -- data_ValidateCode: columns
    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'ValidateCode')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'validate_code') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "ValidateCode" TO "validate_code";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'ValidateType')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'validate_type') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "ValidateType" TO "validate_type";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'DataValue')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'data_value') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "DataValue" TO "data_value";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'status') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'create_time') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'ExpiredTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'expired_time') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "ExpiredTime" TO "expired_time";
    END IF;

    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'ValidateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'data_ValidateCode' AND column_name = 'validate_time') THEN
        ALTER TABLE public."data_ValidateCode" RENAME COLUMN "ValidateTime" TO "validate_time";
    END IF;

    -- sys_ClientAuth: columns
    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'id') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "ID" TO "id";
    END IF;

    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'create_time') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'LastRequestTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'last_request_time') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "LastRequestTime" TO "last_request_time";
    END IF;

    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'Description')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'description') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "Description" TO "description";
    END IF;

    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'status') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'ExpireDate')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientAuth' AND column_name = 'expire_date') THEN
        ALTER TABLE public."sys_ClientAuth" RENAME COLUMN "ExpireDate" TO "expire_date";
    END IF;

    -- sys_ClientMachineCode: columns
    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'id') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "ID" TO "id";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'MachineCode')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'machine_code') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "MachineCode" TO "machine_code";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'ComputerName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'computer_name') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "ComputerName" TO "computer_name";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'CpuName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'cpu_name') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "CpuName" TO "cpu_name";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'CpuID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'cpu_id') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "CpuID" TO "cpu_id";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'MacAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'mac_address') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "MacAddress" TO "mac_address";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'MotherboardSN')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'motherboard_sn') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "MotherboardSN" TO "motherboard_sn";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'DiskID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'disk_id') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "DiskID" TO "disk_id";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'TotalPhysicalMemory')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'total_physical_memory') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "TotalPhysicalMemory" TO "total_physical_memory";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'IPAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'ip_address') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "IPAddress" TO "ip_address";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'status') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_ClientMachineCode' AND column_name = 'create_time') THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    -- sys_Log: columns
    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'LogID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'log_id') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "LogID" TO "log_id";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'Title')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'title') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "Title" TO "title";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'Message')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'message') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "Message" TO "message";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'UserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'user_name') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "UserName" TO "user_name";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'Url')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'url') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "Url" TO "url";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'ServerName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'server_name') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "ServerName" TO "server_name";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'BlogID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'blog_id') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "BlogID" TO "blog_id";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'StartDate')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'start_date') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "StartDate" TO "start_date";
    END IF;

    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'EndDate')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Log' AND column_name = 'end_date') THEN
        ALTER TABLE public."sys_Log" RENAME COLUMN "EndDate" TO "end_date";
    END IF;

    -- sys_SessionData: columns
    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'SessionID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'session_id') THEN
        ALTER TABLE public."sys_SessionData" RENAME COLUMN "SessionID" TO "session_id";
    END IF;

    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'UserInfo')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'user_info') THEN
        ALTER TABLE public."sys_SessionData" RENAME COLUMN "UserInfo" TO "user_info";
    END IF;

    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'ExpressTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'express_time') THEN
        ALTER TABLE public."sys_SessionData" RENAME COLUMN "ExpressTime" TO "express_time";
    END IF;

    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'status') THEN
        ALTER TABLE public."sys_SessionData" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'IPAddress')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_SessionData' AND column_name = 'ip_address') THEN
        ALTER TABLE public."sys_SessionData" RENAME COLUMN "IPAddress" TO "ip_address";
    END IF;

    -- sys_Setting: columns
    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'ConfigKey')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'config_key') THEN
        ALTER TABLE public."sys_Setting" RENAME COLUMN "ConfigKey" TO "config_key";
    END IF;

    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'ConfigContent')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'config_content') THEN
        ALTER TABLE public."sys_Setting" RENAME COLUMN "ConfigContent" TO "config_content";
    END IF;

    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'update_time') THEN
        ALTER TABLE public."sys_Setting" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'UpdateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'update_user') THEN
        ALTER TABLE public."sys_Setting" RENAME COLUMN "UpdateUser" TO "update_user";
    END IF;

    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'UpdateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_Setting' AND column_name = 'update_user_name') THEN
        ALTER TABLE public."sys_Setting" RENAME COLUMN "UpdateUserName" TO "update_user_name";
    END IF;

    -- sys_User: columns
    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'UserID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'user_id') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "UserID" TO "user_id";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Account')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'account') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Account" TO "account";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Pwd')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'pwd') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Pwd" TO "pwd";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Email')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'email') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Email" TO "email";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Phone')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'phone') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Phone" TO "phone";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'WX_ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'wx_id') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "WX_ID" TO "wx_id";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Ali_ID')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'ali_id') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Ali_ID" TO "ali_id";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'UserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'user_name') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "UserName" TO "user_name";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'RegisterTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'register_time') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "RegisterTime" TO "register_time";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'VIPLevel')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'vip_level') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "VIPLevel" TO "vip_level";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'Status')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'status') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "Status" TO "status";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'IsAdmin')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'is_admin') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "IsAdmin" TO "is_admin";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'CreateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'create_time') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "CreateTime" TO "create_time";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'CreateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'create_user') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "CreateUser" TO "create_user";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'CreateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'create_user_name') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "CreateUserName" TO "create_user_name";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'UpdateTime')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'update_time') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "UpdateTime" TO "update_time";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'UpdateUser')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'update_user') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "UpdateUser" TO "update_user";
    END IF;

    IF to_regclass('public."sys_User"') IS NOT NULL
       AND EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'UpdateUserName')
       AND NOT EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'sys_User' AND column_name = 'update_user_name') THEN
        ALTER TABLE public."sys_User" RENAME COLUMN "UpdateUserName" TO "update_user_name";
    END IF;

    -- OnlinePay_Ali_app_auth_token: table
    IF to_regclass('public."OnlinePay_Ali_app_auth_token"') IS NOT NULL
       AND to_regclass('public.online_pay_ali_app_auth_token') IS NULL THEN
        ALTER TABLE public."OnlinePay_Ali_app_auth_token" RENAME TO "online_pay_ali_app_auth_token";
    END IF;

    -- data_Affixs: table
    IF to_regclass('public."data_Affixs"') IS NOT NULL
       AND to_regclass('public.data_affixs') IS NULL THEN
        ALTER TABLE public."data_Affixs" RENAME TO "data_affixs";
    END IF;

    -- data_ArchiveCategory: table
    IF to_regclass('public."data_ArchiveCategory"') IS NOT NULL
       AND to_regclass('public.data_archive_category') IS NULL THEN
        ALTER TABLE public."data_ArchiveCategory" RENAME TO "data_archive_category";
    END IF;

    -- data_ArchiveCategoryGroup: table
    IF to_regclass('public."data_ArchiveCategoryGroup"') IS NOT NULL
       AND to_regclass('public.data_archive_category_group') IS NULL THEN
        ALTER TABLE public."data_ArchiveCategoryGroup" RENAME TO "data_archive_category_group";
    END IF;

    -- data_ArticleComments: table
    IF to_regclass('public."data_ArticleComments"') IS NOT NULL
       AND to_regclass('public.data_article_comments') IS NULL THEN
        ALTER TABLE public."data_ArticleComments" RENAME TO "data_article_comments";
    END IF;

    -- data_ArticleViews: table
    IF to_regclass('public."data_ArticleViews"') IS NOT NULL
       AND to_regclass('public.data_article_views') IS NULL THEN
        ALTER TABLE public."data_ArticleViews" RENAME TO "data_article_views";
    END IF;

    -- data_Articles: table
    IF to_regclass('public."data_Articles"') IS NOT NULL
       AND to_regclass('public.data_articles') IS NULL THEN
        ALTER TABLE public."data_Articles" RENAME TO "data_articles";
    END IF;

    -- static_Articles_updates: table
    IF to_regclass('public."static_Articles_updates"') IS NOT NULL
       AND to_regclass('public.static_articles_updates') IS NULL THEN
        ALTER TABLE public."static_Articles_updates" RENAME TO "static_articles_updates";
    END IF;

    -- static_Articles_updates_node: table
    IF to_regclass('public."static_Articles_updates_node"') IS NOT NULL
       AND to_regclass('public.static_articles_updates_node') IS NULL THEN
        ALTER TABLE public."static_Articles_updates_node" RENAME TO "static_articles_updates_node";
    END IF;

    -- data_ArticlesAttrGroup: table
    IF to_regclass('public."data_ArticlesAttrGroup"') IS NOT NULL
       AND to_regclass('public.data_articles_attr_group') IS NULL THEN
        ALTER TABLE public."data_ArticlesAttrGroup" RENAME TO "data_articles_attr_group";
    END IF;

    -- data_ArticlesAttrProduct: table
    IF to_regclass('public."data_ArticlesAttrProduct"') IS NOT NULL
       AND to_regclass('public.data_articles_attr_product') IS NULL THEN
        ALTER TABLE public."data_ArticlesAttrProduct" RENAME TO "data_articles_attr_product";
    END IF;

    -- data_ArticlesAttrSort: table
    IF to_regclass('public."data_ArticlesAttrSort"') IS NOT NULL
       AND to_regclass('public.data_articles_attr_sort') IS NULL THEN
        ALTER TABLE public."data_ArticlesAttrSort" RENAME TO "data_articles_attr_sort";
    END IF;

    -- data_ArticlesProtectContent: table
    IF to_regclass('public."data_ArticlesProtectContent"') IS NOT NULL
       AND to_regclass('public.data_articles_protect_content') IS NULL THEN
        ALTER TABLE public."data_ArticlesProtectContent" RENAME TO "data_articles_protect_content";
    END IF;

    -- data_ArticlesTags: table
    IF to_regclass('public."data_ArticlesTags"') IS NOT NULL
       AND to_regclass('public.data_articles_tags') IS NULL THEN
        ALTER TABLE public."data_ArticlesTags" RENAME TO "data_articles_tags";
    END IF;

    -- data_ArticlesTagsRelation: table
    IF to_regclass('public."data_ArticlesTagsRelation"') IS NOT NULL
       AND to_regclass('public.data_articles_tags_relation') IS NULL THEN
        ALTER TABLE public."data_ArticlesTagsRelation" RENAME TO "data_articles_tags_relation";
    END IF;

    -- data_ArticlesURLPath: table
    IF to_regclass('public."data_ArticlesURLPath"') IS NOT NULL
       AND to_regclass('public.data_articles_url_path') IS NULL THEN
        ALTER TABLE public."data_ArticlesURLPath" RENAME TO "data_articles_url_path";
    END IF;

    -- data_DynamicForm: table
    IF to_regclass('public."data_DynamicForm"') IS NOT NULL
       AND to_regclass('public.data_dynamic_form') IS NULL THEN
        ALTER TABLE public."data_DynamicForm" RENAME TO "data_dynamic_form";
    END IF;

    -- data_DynamicForm_Property: table
    IF to_regclass('public."data_DynamicForm_Property"') IS NOT NULL
       AND to_regclass('public.data_dynamic_form_property') IS NULL THEN
        ALTER TABLE public."data_DynamicForm_Property" RENAME TO "data_dynamic_form_property";
    END IF;

    -- data_DynamicForm_ZData: table
    IF to_regclass('public."data_DynamicForm_ZData"') IS NOT NULL
       AND to_regclass('public.data_dynamic_form_z_data') IS NULL THEN
        ALTER TABLE public."data_DynamicForm_ZData" RENAME TO "data_dynamic_form_z_data";
    END IF;

    -- data_DynamicForm_ZDataPValue: table
    IF to_regclass('public."data_DynamicForm_ZDataPValue"') IS NOT NULL
       AND to_regclass('public.data_dynamic_form_z_data_p_value') IS NULL THEN
        ALTER TABLE public."data_DynamicForm_ZDataPValue" RENAME TO "data_dynamic_form_z_data_p_value";
    END IF;

    -- data_Images: table
    IF to_regclass('public."data_Images"') IS NOT NULL
       AND to_regclass('public.data_images') IS NULL THEN
        ALTER TABLE public."data_Images" RENAME TO "data_images";
    END IF;

    -- data_Images_Debug: table
    IF to_regclass('public."data_Images_Debug"') IS NOT NULL
       AND to_regclass('public.data_images_debug') IS NULL THEN
        ALTER TABLE public."data_Images_Debug" RENAME TO "data_images_debug";
    END IF;

    -- data_Issues: table
    IF to_regclass('public."data_Issues"') IS NOT NULL
       AND to_regclass('public.data_issues') IS NULL THEN
        ALTER TABLE public."data_Issues" RENAME TO "data_issues";
    END IF;

    -- data_IssuesProcess: table
    IF to_regclass('public."data_IssuesProcess"') IS NOT NULL
       AND to_regclass('public.data_issues_process') IS NULL THEN
        ALTER TABLE public."data_IssuesProcess" RENAME TO "data_issues_process";
    END IF;

    -- data_LogUserLogin: table
    IF to_regclass('public."data_LogUserLogin"') IS NOT NULL
       AND to_regclass('public.data_log_user_login') IS NULL THEN
        ALTER TABLE public."data_LogUserLogin" RENAME TO "data_log_user_login";
    END IF;

    -- data_PageBuildComponents: table
    IF to_regclass('public."data_PageBuildComponents"') IS NOT NULL
       AND to_regclass('public.data_page_build_components') IS NULL THEN
        ALTER TABLE public."data_PageBuildComponents" RENAME TO "data_page_build_components";
    END IF;

    -- data_PageBuildComponents_Group: table
    IF to_regclass('public."data_PageBuildComponents_Group"') IS NOT NULL
       AND to_regclass('public.data_page_build_components_group') IS NULL THEN
        ALTER TABLE public."data_PageBuildComponents_Group" RENAME TO "data_page_build_components_group";
    END IF;

    -- data_PayOrder: table
    IF to_regclass('public."data_PayOrder"') IS NOT NULL
       AND to_regclass('public.data_pay_order') IS NULL THEN
        ALTER TABLE public."data_PayOrder" RENAME TO "data_pay_order";
    END IF;

    -- data_ProtectContentBuyLog: table
    IF to_regclass('public."data_ProtectContentBuyLog"') IS NOT NULL
       AND to_regclass('public.data_protect_content_buy_log') IS NULL THEN
        ALTER TABLE public."data_ProtectContentBuyLog" RENAME TO "data_protect_content_buy_log";
    END IF;

    -- data_Templates: table
    IF to_regclass('public."data_Templates"') IS NOT NULL
       AND to_regclass('public.data_templates') IS NULL THEN
        ALTER TABLE public."data_Templates" RENAME TO "data_templates";
    END IF;

    -- data_UserLoginStatus: table
    IF to_regclass('public."data_UserLoginStatus"') IS NOT NULL
       AND to_regclass('public.data_user_login_status') IS NULL THEN
        ALTER TABLE public."data_UserLoginStatus" RENAME TO "data_user_login_status";
    END IF;

    -- data_ValidateCode: table
    IF to_regclass('public."data_ValidateCode"') IS NOT NULL
       AND to_regclass('public.data_validate_code') IS NULL THEN
        ALTER TABLE public."data_ValidateCode" RENAME TO "data_validate_code";
    END IF;

    -- sys_ClientAuth: table
    IF to_regclass('public."sys_ClientAuth"') IS NOT NULL
       AND to_regclass('public.sys_client_auth') IS NULL THEN
        ALTER TABLE public."sys_ClientAuth" RENAME TO "sys_client_auth";
    END IF;

    -- sys_ClientMachineCode: table
    IF to_regclass('public."sys_ClientMachineCode"') IS NOT NULL
       AND to_regclass('public.sys_client_machine_code') IS NULL THEN
        ALTER TABLE public."sys_ClientMachineCode" RENAME TO "sys_client_machine_code";
    END IF;

    -- sys_Log: table
    IF to_regclass('public."sys_Log"') IS NOT NULL
       AND to_regclass('public.sys_log') IS NULL THEN
        ALTER TABLE public."sys_Log" RENAME TO "sys_log";
    END IF;

    -- sys_SessionData: table
    IF to_regclass('public."sys_SessionData"') IS NOT NULL
       AND to_regclass('public.sys_session_data') IS NULL THEN
        ALTER TABLE public."sys_SessionData" RENAME TO "sys_session_data";
    END IF;

    -- sys_Setting: table
    IF to_regclass('public."sys_Setting"') IS NOT NULL
       AND to_regclass('public.sys_setting') IS NULL THEN
        ALTER TABLE public."sys_Setting" RENAME TO "sys_setting";
    END IF;

    -- sys_User: table
    IF to_regclass('public."sys_User"') IS NOT NULL
       AND to_regclass('public.sys_user') IS NULL THEN
        ALTER TABLE public."sys_User" RENAME TO "sys_user";
    END IF;

END $$;

UPDATE data_templates
SET file_path = lower(replace(file_path, E'\\', '/'))