jkobus
/ MySQL functions to convert between binary and string uuids
Created Dec 8, 2017
— forked from IcyMidnight/MySQL functions to convert between binary and string uuids
MySQL functions to convert between binary and string uuids
View MySQL functions to convert between binary and string uuids
| DELIMITER | | |
| CREATE FUNCTION uuid_from_bin(b BINARY(16)) | |
| RETURNS CHAR(36) DETERMINISTIC | |
| BEGIN | |
| DECLARE hex CHAR(32); | |
| SET hex = HEX(b); | |
| RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12)); | |
| END | |
| | |
View php-tools
| #!/bin/bash | |
| #Oryginal source: https://gist.githubusercontent.com/agarzon/ecb0b92d4c8e1bbde126534c76721a58/raw/install-php-tools.sh | |
| BIN_PATH=/usr/local/bin/ | |
| #COMPOSER | |
| sudo curl -LsS https://getcomposer.org/composer.phar -o ${BIN_PATH}composer | |
| sudo chmod a+x ${BIN_PATH}composer |