emptyother

{
	"definitions": {},
	"$schema": "http://json-schema.org/draft-07/schema#",
	"$id": "http://onlyhuman.dk/json-schema/.mocharc.json",
	"type": "object",
	"title": "The Root Schema",
	"properties": {
		"diff": {
			"$id": "#/properties/diff",
			"type": "boolean",

emptyother

# MySQL: convert BINARY(16) to GUID (Microsoft-style UUID)
# 0x11223344556677889900AABBCCDDEEFF → '44332211-6655-8877-9900-AABBCCDDEEFF'
# usage: CREATE TABLE example(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, guid BINARY(16) NOT NULL UNIQUE);
#        SELECT id, uuid_from_bin(guid) FROM example;

CREATE FUNCTION uuid_from_bin(b BINARY(16))
  RETURNS char(36) CHARSET utf8
  DETERMINISTIC
BEGIN
  DECLARE h CHAR(32);

emptyother

# MySQL: convert GUID (Microsoft-style UUID) to BINARY(16)
# '11223344-5566-7788-9900-AABBCCDDEEFF' → 0x44332211665588779900AABBCCDDEEFF
# usage: CREATE TABLE example(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, guid BINARY(16) NOT NULL UNIQUE);
#        INSERT INTO example(guid) VALUES (uuid_to_bin(UUID()));

CREATE FUNCTION uuid_to_bin(s CHAR(36))
  RETURNS binary(16)
  DETERMINISTIC
RETURN UNHEX(CONCAT(
  SUBSTRING(s,7,2),SUBSTRING(s,5,2),SUBSTRING(s,3,2),SUBSTRING(s,1,2),

emptyother

[Metadata]
Name=Date, Time, and System
Author=emptyother
Information=https://github.com/emptyother/Rainmeter-Skin
Version=2.0.0
License=ISC

[Rainmeter]
Update=1000
DynamicWindowSize=1