aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/MuteListStore.migrations
blob: 164dc514ad085a37b5875e8d77c46de4bd49d526 (plain)
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;