diff options
| author | Diva Canto | 2010-04-16 17:43:15 -0700 |
|---|---|---|
| committer | Diva Canto | 2010-04-16 17:43:15 -0700 |
| commit | 2597a3406c10de6898f1a66e469c3656aa294f43 (patch) | |
| tree | 2b47a7562cdf9ee50c9148056354d8414c251fc7 /OpenSim/Data/SQLite/Resources/001_UserAccount.sql | |
| parent | Expose Delete at IUserAccountData interface. It was there already. No changes... (diff) | |
| download | opensim-SC-2597a3406c10de6898f1a66e469c3656aa294f43.zip opensim-SC-2597a3406c10de6898f1a66e469c3656aa294f43.tar.gz opensim-SC-2597a3406c10de6898f1a66e469c3656aa294f43.tar.bz2 opensim-SC-2597a3406c10de6898f1a66e469c3656aa294f43.tar.xz | |
Bug fix: UserAccounts in SQLite was missing the primary key constraint.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/001_UserAccount.sql')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/001_UserAccount.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 @@ | |||
| 2 | 2 | ||
| 3 | -- useraccounts table | 3 | -- useraccounts table |
| 4 | CREATE TABLE UserAccounts ( | 4 | CREATE TABLE UserAccounts ( |
| 5 | PrincipalID CHAR(36) NOT NULL, | 5 | PrincipalID CHAR(36) primary key, |
| 6 | ScopeID CHAR(36) NOT NULL, | 6 | ScopeID CHAR(36) NOT NULL, |
| 7 | FirstName VARCHAR(64) NOT NULL, | 7 | FirstName VARCHAR(64) NOT NULL, |
| 8 | LastName VARCHAR(64) NOT NULL, | 8 | LastName VARCHAR(64) NOT NULL, |