aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/MuteListStore.migrations
blob: 5bde63edd8f11a07ee9a130431da8342df0d5db5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
:VERSION 1

BEGIN;

CREATE TABLE `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`)
);

COMMIT;