Add DMXIS Plugin

sqlite> .tables
FdChannelModes   FdChannels       FdFixtures       FdModeTriggers 
FdChannelRange   FdFixtureModes   FdManufacturers
sqlite> .schema *
CREATE TABLE IF NOT EXISTS "FdManufacturers"(
  "ManufacturerID" INTEGER PRIMARY KEY NOT NULL,
  "Name" VARCHAR(100)
);
CREATE TABLE IF NOT EXISTS "FdFixtures"(
--   When user creates a new fixture, they are emailed a password, which allows them to edit it later. Don't think we want to allow free write access to fixtures!
--   
--   The user can choose to keep a fixture private (for editing purposes, or to create a personal variant e.g. with custom gobos)
  "FixtureID" INTEGER PRIMARY KEY NOT NULL,
  "ManufacturerID" INTEGER NOT NULL,
  "Name" VARCHAR(100),
  "Description" TEXT,
  "PasswordToEdit" VARCHAR(20),
  "IsPublic" BOOL,
  CONSTRAINT "fk_Fixtures_Manufacturers1"
    FOREIGN KEY("ManufacturerID")
    REFERENCES "FdManufacturers"("ManufacturerID")
);
CREATE TABLE IF NOT EXISTS "FdFixtureModes" (
  FixtureModeID  integer PRIMARY KEY,
  FixtureID      integer,
  Name           varchar(45),
  PublicMode     bool, HasRgb boolean NOT NULL DEFAULT 0, HasPanTilt boolean NOT NULL DEFAULT 0,
  /* Foreign keys */
  FOREIGN KEY (FixtureID)
    REFERENCES "FdFixtures"(FixtureID)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
);
CREATE TABLE IF NOT EXISTS "FdModeTriggers" (
  ModeTriggerID   integer PRIMARY KEY NOT NULL,
  ChannelRangeID  integer NOT NULL,
  ChannelModeID   integer,
  /* Foreign keys */
  FOREIGN KEY (ChannelRangeID)
    REFERENCES "FdChannelRange"(ChannelRangeID)
    ON DELETE CASCADE
    ON UPDATE NO ACTION
);
CREATE TABLE IF NOT EXISTS "FdChannelRange" (
  ChannelRangeID  integer PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
  ChannelModeID   integer NOT NULL,
  IsDimmer        bool,
  IsBlackout      bool,
  IsContinuous    bool,
  MinVal          integer,
  MaxVal          integer,
  Label           varchar(45),
  ShortLabel      varchar(20),
  /* Foreign keys */
  FOREIGN KEY (ChannelModeID)
    REFERENCES "FdChannelModes"(ChannelModeID)
    ON DELETE CASCADE
    ON UPDATE NO ACTION
);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "FdChannelModes" (
  ChannelModeID  integer PRIMARY KEY NOT NULL,
  ChannelID      integer NOT NULL,
  /* Foreign keys */
  FOREIGN KEY (ChannelID)
    REFERENCES "FdChannels"(ChannelID)
    ON DELETE CASCADE
    ON UPDATE NO ACTION
);
CREATE TABLE FdChannels (
  ChannelID      integer PRIMARY KEY,
  FixtureModeID  integer,
  ChannelNumber  integer,
  Name           varchar(45),
  ShortName      varchar(20),
  DefaultValue   integer NOT NULL DEFAULT 0,
  Snap           integer NOT NULL DEFAULT 0,
  Category       integer NOT NULL DEFAULT 0,
  Subcategory    integer NOT NULL DEFAULT 0,
  Highlight      integer NOT NULL DEFAULT -1,
  /* Foreign keys */
  FOREIGN KEY (FixtureModeID)
    REFERENCES FdFixtureModes(FixtureModeID)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
);