MuteListStore.migrations 387 B

12345678910111213141516
  1. :VERSION 1
  2. BEGIN TRANSACTION;
  3. CREATE TABLE MuteList (
  4. AgentID char(36) NOT NULL,
  5. MuteID char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  6. MuteName varchar(64) NOT NULL DEFAULT '',
  7. MuteType int(11) NOT NULL DEFAULT '1',
  8. MuteFlags int(11) NOT NULL DEFAULT '0',
  9. Stamp int(11) NOT NULL,
  10. UNIQUE (AgentID, MuteID, MuteName),
  11. PRIMARY KEY(AgentID)
  12. );
  13. COMMIT;