Stable version
2.0.0.5906
Latest version
2.0.0.5906
Bleeding Edge version
2.0.0.5907

Users

NameDescriptionUser NameApp VersionGit HashUninstall Switch
Q-LAND\Don2.0.0.5907e4987c8a06a93cd599d971bb2a061816f2a3e6d40uninstallreset
CRAIG-MAIN\Craig2.0.0.5907e4987c8a06a93cd599d971bb2a061816f2a3e6d40uninstallreset
INTERFOR\craig.silver2.0.0.5907e4987c8a06a93cd599d971bb2a061816f2a3e6d40uninstallreset
LAPTOP-T86575KS\kevmc2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
CARM-M900-MAIN\Carm2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
CRAIG-MOBILE\Craig2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
CRAIG-T470S\Craig2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
JOY-PC\Joy22.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
SPLOTCH-RS\Craig2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
MSI\hpn2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
RAY-T460\Ray2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
INTERFOR\Matt.Dilworth2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
SPLOTCH-CE\Craig2.0.0.59064cc1b95378455e159a81b78eb6b97d32877b9a2b0uninstallreset
WIN-HOME\Craig2.0.0.5897517bcd4013b123d0c51c18aa299a5be6fc8aa76d0uninstallreset
CRAIG-SPLOTCH\Craig2.0.0.5897517bcd4013b123d0c51c18aa299a5be6fc8aa76d0uninstallreset
WIN-HOME2\Craig2.0.0.589500712f8cebdaf4751f8f19f933b270590a8e031f0uninstallreset
Total: 16


-- 1. Rename the original table
ALTER TABLE TokenSequences RENAME TO TokenSequences_old;

-- 2. Recreate the table with the new UNIQUE constraint
CREATE TABLE TokenSequences (
    ID INTEGER PRIMARY KEY,
    Value TEXT NOT NULL,
    TypeID INTEGER NOT NULL,
    CmdID INTEGER NOT NULL,
    IsCustomUserValue INTEGER NOT NULL,
    CONSTRAINT Value_TypeID_CmdID_Unique UNIQUE (Value, TypeID, CmdID)
);

-- 3. Copy the data from the old table
INSERT INTO TokenSequences (ID, Value, TypeID, CmdID, IsCustomUserValue)
SELECT ID, Value, TypeID, CmdID, IsCustomUserValue
FROM TokenSequences_old;

-- 4. Drop the old table
DROP TABLE TokenSequences_old;

-- 5. Re-create the index
create index TokenSequences_Idx_CmdID on TokenSequences(CmdID);