github.com/ztalab/ZACA@v0.0.1/database/mysql/migrations/006_alter_index.up.sql (about)

     1  ALTER TABLE `certificates` CHANGE `common_name` `common_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '';
     2  
     3  CREATE INDEX `common_name_idx` ON `certificates`(`common_name`) USING BTREE;
     4  
     5  CREATE INDEX `revoked_at_idx` ON `certificates`(`revoked_at`) USING BTREE;
     6  
     7  CREATE INDEX `expiry_idx` ON `certificates`(`expiry`) USING BTREE;
     8  
     9  CREATE INDEX `not_before_idx` ON `certificates`(`not_before`) USING BTREE;
    10  
    11  CREATE INDEX `ca_label_idx` ON `certificates`(`ca_label`) USING BTREE;
    12  
    13  CREATE INDEX `status_idx` ON `certificates`(`status`) USING BTREE;
    14  
    15  CREATE INDEX `unique_id_idx` ON `forbid`(`unique_id`) USING BTREE;
    16  
    17  CREATE INDEX `deleted_at_idx` ON `forbid`(`deleted_at`) USING BTREE;
    18  
    19  CREATE INDEX `name_idx` ON `self_keypair`(`name`) USING BTREE;