OpenSim/Data/MySQL/Resources/001_UserAccount.sql


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

BEGIN;

CREATE TABLE `UserAccounts` (
    `PrincipalID` CHAR(36) NOT NULL,
    `ScopeID` CHAR(36) NOT NULL,
    `FirstName` VARCHAR(64) NOT NULL,
    `LastName` VARCHAR(64) NOT NULL,
    `Email` VARCHAR(64),
    `ServiceURLs` TEXT,
    `Created` DATETIME
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

COMMIT;