Porlam Nicla GrapeApple0
🍵
GrapeApple0
/ rollback-1697420555911-deleteCreatedAt.sql
Last active
July 15, 2024 10:58
— forked from u1-liquid/rollback-1697420555911-deleteCreatedAt.sql
Rollback https://github.com/misskey-dev/misskey/blob/6bd78770de06bd3694127da17ccd051f05057329/packages/backend/migration/1697420555911-deleteCreatedAt.js / origin of base36 decode sql: https://gist.github.com/david-sanabria/0d3ff67eb56d2750502aed4186d6a4a7
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION base36_decode(encoded_text text) | |
| RETURNS bigint AS $$ | |
| declare | |
| k_base constant integer := 36; | |
| k_alphabet constant text := '0123456789abcdefghijklmnopqrstuvwxyz'; | |
| v_encoded_arr text[]; | |
| v_return_result bigint := 0; | |
| v_interim bigint; | |
| v_index integer; | |
| v_token text; |