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_AuthStore.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 OpenSim/Data/MSSQL/Resources/001_AuthStore.sql (limited to 'OpenSim/Data/MSSQL/Resources/001_AuthStore.sql') diff --git a/OpenSim/Data/MSSQL/Resources/001_AuthStore.sql b/OpenSim/Data/MSSQL/Resources/001_AuthStore.sql new file mode 100644 index 0000000..c70a193 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/001_AuthStore.sql @@ -0,0 +1,17 @@ +BEGIN TRANSACTION + +CREATE TABLE [auth] ( + [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000', + [passwordHash] [varchar](32) NOT NULL, + [passwordSalt] [varchar](32) NOT NULL, + [webLoginKey] [varchar](255) NOT NULL, + [accountType] VARCHAR(32) NOT NULL DEFAULT 'UserAccount', +) ON [PRIMARY] + +CREATE TABLE [tokens] ( + [uuid] [uniqueidentifier] NOT NULL default '00000000-0000-0000-0000-000000000000', + [token] [varchar](255) NOT NULL, + [validity] [datetime] NOT NULL ) + ON [PRIMARY] + +COMMIT \ No newline at end of file -- cgit v1.1