From 2fa5694ec9857f208b6fe4d0890fd2ab8ac1b8bf Mon Sep 17 00:00:00 2001 From: StrawberryFride Date: Wed, 24 Feb 2010 16:42:39 +0000 Subject: MSSQL Additions for Presence Refactor branch. Most functionality tested and works, some outstanding issues around login location and border crossings on y axis. Signed-off-by: Melanie --- OpenSim/Data/MSSQL/Resources/001_Avatar.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 OpenSim/Data/MSSQL/Resources/001_Avatar.sql (limited to 'OpenSim/Data/MSSQL/Resources/001_Avatar.sql') diff --git a/OpenSim/Data/MSSQL/Resources/001_Avatar.sql b/OpenSim/Data/MSSQL/Resources/001_Avatar.sql new file mode 100644 index 0000000..48f4c00 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/001_Avatar.sql @@ -0,0 +1,15 @@ +BEGIN TRANSACTION + +CREATE TABLE [Avatars] ( +[PrincipalID] uniqueidentifier NOT NULL, +[Name] varchar(32) NOT NULL, +[Value] varchar(255) NOT NULL DEFAULT '', +PRIMARY KEY CLUSTERED +( + [PrincipalID] ASC, [Name] ASC +)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] +) ON [PRIMARY] + + + +COMMIT \ No newline at end of file -- cgit v1.1