From 2597a3406c10de6898f1a66e469c3656aa294f43 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Fri, 16 Apr 2010 17:43:15 -0700
Subject: Bug fix: UserAccounts in SQLite was missing the primary key
 constraint.

---
 OpenSim/Data/SQLite/Resources/001_UserAccount.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/SQLite/Resources/001_UserAccount.sql')

diff --git a/OpenSim/Data/SQLite/Resources/001_UserAccount.sql b/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
index f9bf24c..c38d9a7 100644
--- a/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
+++ b/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
@@ -2,7 +2,7 @@
 
 -- useraccounts table
 CREATE TABLE UserAccounts (
-    PrincipalID CHAR(36) NOT NULL,
+    PrincipalID CHAR(36)  primary key,
     ScopeID CHAR(36) NOT NULL,
     FirstName VARCHAR(64) NOT NULL,
     LastName VARCHAR(64) NOT NULL,
-- 
cgit v1.1

