ANGEL Prim Drop Schema

From SLIS Second Life Wiki

Adding a Database table in ANGEL

Go to: Administrator Console>Tools>SQL Query Manager and copy/paste this query code to create the new table which will hold the avatar data: 

CREATE TABLE AVATARS (
  [USER_ID] NVARCHAR (100) NOT NULL,
  [AVATAR_UUID] NVARCHAR (50) NULL,
  [AVATAR_FNAME] NVARCHAR (50) NULL,
  [AVATAR_LNAME] NVARCHAR (50) NULL,
  [AVATAR_PHOTO] NVARCHAR (255) NULL,
  [REVISED] DATETIME NULL
)
Toolbox
LANGUAGES