Richard "Virgo" Richter virgo47

virgo47 / midpoint-repo-enum.sql

Created August 19, 2021 15:28

	-- Describes m_object.objectClassType
	CREATE TABLE m_objtype (
	id INT PRIMARY KEY,
	name VARCHAR(64),
	table_name VARCHAR(64)
	);

	-- Based on RObjectType
	INSERT INTO m_objtype VALUES (0, 'CONNECTOR', 'm_connector');
	INSERT INTO m_objtype VALUES (1, 'CONNECTOR_HOST', 'm_connector_host');

virgo47 / oracle-test1.sql

Last active November 10, 2020 21:03

Oracle experiment table with nullable validfrom/to dates and randomly generated data

	CREATE TABLE x_nitest (
	oid VARCHAR2(36 CHAR) NOT NULL,
	validFrom TIMESTAMP,
	validTo TIMESTAMP,

	PRIMARY KEY (oid)
	);
	CREATE INDEX x_nitest_from ON x_nitest(validFrom);
	CREATE INDEX x_nitest_to ON x_nitest(validTo);

virgo47 / WindowsSetup1.bat

Last active August 3, 2023 07:30

Getting up and ready with Windows much faster

	REM First run this in administrator cmd manually:
	REM @powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))"

	REM Then this in newly opened admin cmd:
	choco config set cacheLocation "c:\ProgramData\Chocolatey\tmp-cache"
	choco feature enable -n allowEmptyChecksums
	cinst -y classic-shell
	cinst -y firefox
	cinst -y notepad2
	cinst -y notepadreplacer -installarguments "/notepad=C:\Progra~1\Notepad2\Notepad2.exe /verysilent"