OpenSim/Data/SQLite/Resources/MuteListStore.migrations


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

:VERSION 1

BEGIN TRANSACTION;

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 (AgentID, MuteID, MuteName),
  PRIMARY KEY(AgentID)
);

COMMIT;