virgo47

-- 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

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

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"