MuteListStore.migrations 450 B

12345678910111213141516
  1. :VERSION 1
  2. BEGIN;
  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 KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`),
  11. KEY `AgentID` (`AgentID`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  13. COMMIT;