OpenSim/Data/MySQL/Resources/MuteListStore.migrations


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

:VERSION 1

BEGIN;

CREATE TABLE IF NOT EXISTS `MuteList` (
  `AgentID` char(36) NOT NULL,
  `MuteID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `MuteName` varchar(64) NOT NULL DEFAULT '',
  `MuteType` int(11) NOT NULL DEFAULT '1',
  `MuteFlags` int(11) NOT NULL DEFAULT '0',
  `Stamp` int(11) NOT NULL,
  UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`,`MuteName`),
  KEY `AgentID` (`AgentID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

COMMIT;