Update svn properties.

author: Jeff Ames 2009-01-24 08:18:41 +0000
committer: Jeff Ames 2009-01-24 08:18:41 +0000
commit: 676b7c107358fa29e5716e68f65b39da586aa99a (patch)
tree: 366fd52db79cd2f35ebe3b8342dc26db810e14e7 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
parent: * minor: remove mono compiler warning (diff)
download: opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.zip
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.gz
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.bz2
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.xz
1 files changed, 104 insertions, 104 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
index 437b2a9..b3c7ef1 100644
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
@@ -1,104 +1,104 @@
-CREATE TABLE UserAgents (
+CREATE TABLE UserAgents (
-  ProfileID VARCHAR(36) NOT NULL,
+  ProfileID VARCHAR(36) NOT NULL,
-  AgentIP VARCHAR(24) DEFAULT NULL,
+  AgentIP VARCHAR(24) DEFAULT NULL,
-  AgentPort INT DEFAULT NULL,
+  AgentPort INT DEFAULT NULL,
-  AgentOnline BOOLEAN DEFAULT NULL,
+  AgentOnline BOOLEAN DEFAULT NULL,
-  SessionID VARCHAR(36) DEFAULT NULL,
+  SessionID VARCHAR(36) DEFAULT NULL,
-  SecureSessionID VARCHAR(36) DEFAULT NULL,
+  SecureSessionID VARCHAR(36) DEFAULT NULL,
-  InitialRegion VARCHAR(255) DEFAULT NULL,
+  InitialRegion VARCHAR(255) DEFAULT NULL,
-  Region VARCHAR(255) DEFAULT NULL,
+  Region VARCHAR(255) DEFAULT NULL,
-  LoginTime INT DEFAULT NULL,
+  LoginTime INT DEFAULT NULL,
-  LogoutTime INT DEFAULT NULL,
+  LogoutTime INT DEFAULT NULL,
-  Handle BIGINT DEFAULT NULL,
+  Handle BIGINT DEFAULT NULL,
-  PositionX DOUBLE PRECISION DEFAULT NULL,
+  PositionX DOUBLE PRECISION DEFAULT NULL,
-  PositionY DOUBLE PRECISION DEFAULT NULL,
+  PositionY DOUBLE PRECISION DEFAULT NULL,
-  PositionZ DOUBLE PRECISION DEFAULT NULL,
+  PositionZ DOUBLE PRECISION DEFAULT NULL,
-  LookAtX DOUBLE PRECISION DEFAULT NULL,
+  LookAtX DOUBLE PRECISION DEFAULT NULL,
-  LookAtY DOUBLE PRECISION DEFAULT NULL,
+  LookAtY DOUBLE PRECISION DEFAULT NULL,
-  LookAtZ DOUBLE PRECISION DEFAULT NULL,  
+  LookAtZ DOUBLE PRECISION DEFAULT NULL,  
-  PRIMARY KEY (ProfileID)
+  PRIMARY KEY (ProfileID)
-);
+);
-CREATE TABLE UserProfiles (
+CREATE TABLE UserProfiles (
-  ID VARCHAR(36) NOT NULL,
+  ID VARCHAR(36) NOT NULL,
-  WebLoginKey VARCHAR(36) DEFAULT NULL,
+  WebLoginKey VARCHAR(36) DEFAULT NULL,
-  FirstName VARCHAR(32) DEFAULT NULL,
+  FirstName VARCHAR(32) DEFAULT NULL,
-  SurName VARCHAR(32) DEFAULT NULL,
+  SurName VARCHAR(32) DEFAULT NULL,
-  Email VARCHAR(250) DEFAULT NULL,
+  Email VARCHAR(250) DEFAULT NULL,
-  PasswordHash VARCHAR(32) DEFAULT NULL,
+  PasswordHash VARCHAR(32) DEFAULT NULL,
-  PasswordSalt VARCHAR(32) DEFAULT NULL,
+  PasswordSalt VARCHAR(32) DEFAULT NULL,
-  HomeRegionID VARCHAR(36) DEFAULT NULL,
+  HomeRegionID VARCHAR(36) DEFAULT NULL,
-  HomeRegionX INT DEFAULT NULL,
+  HomeRegionX INT DEFAULT NULL,
-  HomeRegionY INT DEFAULT NULL,
+  HomeRegionY INT DEFAULT NULL,
-  HomeLocationX DOUBLE PRECISION DEFAULT NULL,
+  HomeLocationX DOUBLE PRECISION DEFAULT NULL,
-  HomeLocationY DOUBLE PRECISION DEFAULT NULL,
+  HomeLocationY DOUBLE PRECISION DEFAULT NULL,
-  HomeLocationZ DOUBLE PRECISION DEFAULT NULL,
+  HomeLocationZ DOUBLE PRECISION DEFAULT NULL,
-  HomeLookAtX DOUBLE PRECISION DEFAULT NULL,
+  HomeLookAtX DOUBLE PRECISION DEFAULT NULL,
-  HomeLookAtY DOUBLE PRECISION DEFAULT NULL,
+  HomeLookAtY DOUBLE PRECISION DEFAULT NULL,
-  HomeLookAtZ DOUBLE PRECISION DEFAULT NULL,
+  HomeLookAtZ DOUBLE PRECISION DEFAULT NULL,
-  Created INT DEFAULT NULL,
+  Created INT DEFAULT NULL,
-  LastLogin INT DEFAULT NULL,
+  LastLogin INT DEFAULT NULL,
-  UserInventoryURI VARCHAR(255) DEFAULT NULL,
+  UserInventoryURI VARCHAR(255) DEFAULT NULL,
-  UserAssetURI VARCHAR(255) DEFAULT NULL,
+  UserAssetURI VARCHAR(255) DEFAULT NULL,
-  Image VARCHAR(36) DEFAULT NULL,
+  Image VARCHAR(36) DEFAULT NULL,
-  FirstLifeImage VARCHAR(36) DEFAULT NULL,
+  FirstLifeImage VARCHAR(36) DEFAULT NULL,
-  AboutText TEXT DEFAULT NULL,
+  AboutText TEXT DEFAULT NULL,
-  FirstLifeAboutText TEXT DEFAULT NULL,
+  FirstLifeAboutText TEXT DEFAULT NULL,
-  CanDoMask INT DEFAULT NULL,
+  CanDoMask INT DEFAULT NULL,
-  WantDoMask INT DEFAULT NULL,
+  WantDoMask INT DEFAULT NULL,
-  UserFlags INT DEFAULT NULL,
+  UserFlags INT DEFAULT NULL,
-  GodLevel INT DEFAULT NULL,  
+  GodLevel INT DEFAULT NULL,  
-  CustomType VARCHAR(32) DEFAULT NULL,
+  CustomType VARCHAR(32) DEFAULT NULL,
-  Partner VARCHAR(36) DEFAULT NULL,
+  Partner VARCHAR(36) DEFAULT NULL,
-  RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
+  RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
-  PRIMARY KEY (ID)
+  PRIMARY KEY (ID)
-);
+);
-CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
+CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
-CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
+CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
-CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
+CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
-CREATE TABLE UserAppearances (
+CREATE TABLE UserAppearances (
-  Owner VARCHAR(36) NOT NULL,
+  Owner VARCHAR(36) NOT NULL,
-  BodyItem VARCHAR(36) DEFAULT NULL,
+  BodyItem VARCHAR(36) DEFAULT NULL,
-  BodyAsset VARCHAR(36) DEFAULT NULL,
+  BodyAsset VARCHAR(36) DEFAULT NULL,
-  SkinItem VARCHAR(36) DEFAULT NULL,
+  SkinItem VARCHAR(36) DEFAULT NULL,
-  SkinAsset VARCHAR(36) DEFAULT NULL,
+  SkinAsset VARCHAR(36) DEFAULT NULL,
-  HairItem VARCHAR(36) DEFAULT NULL,
+  HairItem VARCHAR(36) DEFAULT NULL,
-  HairAsset VARCHAR(36) DEFAULT NULL,
+  HairAsset VARCHAR(36) DEFAULT NULL,
-  EyesItem VARCHAR(36) DEFAULT NULL,
+  EyesItem VARCHAR(36) DEFAULT NULL,
-  EyesAsset VARCHAR(36) DEFAULT NULL,
+  EyesAsset VARCHAR(36) DEFAULT NULL,
-  ShirtItem VARCHAR(36) DEFAULT NULL,
+  ShirtItem VARCHAR(36) DEFAULT NULL,
-  ShirtAsset VARCHAR(36) DEFAULT NULL,
+  ShirtAsset VARCHAR(36) DEFAULT NULL,
-  PantsItem VARCHAR(36) DEFAULT NULL,
+  PantsItem VARCHAR(36) DEFAULT NULL,
-  PantsAsset VARCHAR(36) DEFAULT NULL,
+  PantsAsset VARCHAR(36) DEFAULT NULL,
-  ShoesItem VARCHAR(36) DEFAULT NULL,
+  ShoesItem VARCHAR(36) DEFAULT NULL,
-  ShoesAsset VARCHAR(36) DEFAULT NULL,
+  ShoesAsset VARCHAR(36) DEFAULT NULL,
-  SocksItem VARCHAR(36) DEFAULT NULL,
+  SocksItem VARCHAR(36) DEFAULT NULL,
-  SocksAsset VARCHAR(36) DEFAULT NULL,
+  SocksAsset VARCHAR(36) DEFAULT NULL,
-  JacketItem VARCHAR(36) DEFAULT NULL,
+  JacketItem VARCHAR(36) DEFAULT NULL,
-  JacketAsset VARCHAR(36) DEFAULT NULL,
+  JacketAsset VARCHAR(36) DEFAULT NULL,
-  GlovesItem VARCHAR(36) DEFAULT NULL,
+  GlovesItem VARCHAR(36) DEFAULT NULL,
-  GlovesAsset VARCHAR(36) DEFAULT NULL,
+  GlovesAsset VARCHAR(36) DEFAULT NULL,
-  UnderShirtItem VARCHAR(36) DEFAULT NULL,
+  UnderShirtItem VARCHAR(36) DEFAULT NULL,
-  UnderShirtAsset VARCHAR(36) DEFAULT NULL,
+  UnderShirtAsset VARCHAR(36) DEFAULT NULL,
-  UnderPantsItem VARCHAR(36) DEFAULT NULL,
+  UnderPantsItem VARCHAR(36) DEFAULT NULL,
-  UnderPantsAsset VARCHAR(36) DEFAULT NULL,
+  UnderPantsAsset VARCHAR(36) DEFAULT NULL,
-  SkirtItem VARCHAR(36) DEFAULT NULL,
+  SkirtItem VARCHAR(36) DEFAULT NULL,
-  SkirtAsset VARCHAR(36) DEFAULT NULL,
+  SkirtAsset VARCHAR(36) DEFAULT NULL,
-  Texture BYTEA,
+  Texture BYTEA,
-  VisualParams BYTEA,
+  VisualParams BYTEA,
-  Serial INT DEFAULT NULL,
+  Serial INT DEFAULT NULL,
-  AvatarHeight FLOAT DEFAULT NULL,    
+  AvatarHeight FLOAT DEFAULT NULL,    
-  PRIMARY KEY (Owner)
+  PRIMARY KEY (Owner)
-);
+);
-CREATE TABLE UserFriends (
+CREATE TABLE UserFriends (
-  UserFriendID VARCHAR(36) NOT NULL,
+  UserFriendID VARCHAR(36) NOT NULL,
-  OwnerID VARCHAR(36) DEFAULT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
-  FriendID VARCHAR(36) DEFAULT NULL,
+  FriendID VARCHAR(36) DEFAULT NULL,
-  FriendPermissions INT DEFAULT NULL,
+  FriendPermissions INT DEFAULT NULL,
-  PRIMARY KEY (UserFriendID)  
+  PRIMARY KEY (UserFriendID)  
-);
+);
-CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);  
+CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);
author	Jeff Ames	2009-01-24 08:18:41 +0000
committer	Jeff Ames	2009-01-24 08:18:41 +0000
commit	676b7c107358fa29e5716e68f65b39da586aa99a (patch)
tree	366fd52db79cd2f35ebe3b8342dc26db810e14e7 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
parent	* minor: remove mono compiler warning (diff)
download	opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.zip opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.gz opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.bz2 opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.xz

diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql index 437b2a9..b3c7ef1 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_UserStore.sql
@@ -1,104 +1,104 @@
1	CREATE TABLE UserAgents (	1	CREATE TABLE UserAgents (
2	ProfileID VARCHAR(36) NOT NULL,	2	ProfileID VARCHAR(36) NOT NULL,
3	AgentIP VARCHAR(24) DEFAULT NULL,	3	AgentIP VARCHAR(24) DEFAULT NULL,
4	AgentPort INT DEFAULT NULL,	4	AgentPort INT DEFAULT NULL,
5	AgentOnline BOOLEAN DEFAULT NULL,	5	AgentOnline BOOLEAN DEFAULT NULL,
6	SessionID VARCHAR(36) DEFAULT NULL,	6	SessionID VARCHAR(36) DEFAULT NULL,
7	SecureSessionID VARCHAR(36) DEFAULT NULL,	7	SecureSessionID VARCHAR(36) DEFAULT NULL,
8	InitialRegion VARCHAR(255) DEFAULT NULL,	8	InitialRegion VARCHAR(255) DEFAULT NULL,
9	Region VARCHAR(255) DEFAULT NULL,	9	Region VARCHAR(255) DEFAULT NULL,
10	LoginTime INT DEFAULT NULL,	10	LoginTime INT DEFAULT NULL,
11	LogoutTime INT DEFAULT NULL,	11	LogoutTime INT DEFAULT NULL,
12	Handle BIGINT DEFAULT NULL,	12	Handle BIGINT DEFAULT NULL,
13	PositionX DOUBLE PRECISION DEFAULT NULL,	13	PositionX DOUBLE PRECISION DEFAULT NULL,
14	PositionY DOUBLE PRECISION DEFAULT NULL,	14	PositionY DOUBLE PRECISION DEFAULT NULL,
15	PositionZ DOUBLE PRECISION DEFAULT NULL,	15	PositionZ DOUBLE PRECISION DEFAULT NULL,
16	LookAtX DOUBLE PRECISION DEFAULT NULL,	16	LookAtX DOUBLE PRECISION DEFAULT NULL,
17	LookAtY DOUBLE PRECISION DEFAULT NULL,	17	LookAtY DOUBLE PRECISION DEFAULT NULL,
18	LookAtZ DOUBLE PRECISION DEFAULT NULL,	18	LookAtZ DOUBLE PRECISION DEFAULT NULL,
19	PRIMARY KEY (ProfileID)	19	PRIMARY KEY (ProfileID)
20	);	20	);
21		21
22	CREATE TABLE UserProfiles (	22	CREATE TABLE UserProfiles (
23	ID VARCHAR(36) NOT NULL,	23	ID VARCHAR(36) NOT NULL,
24	WebLoginKey VARCHAR(36) DEFAULT NULL,	24	WebLoginKey VARCHAR(36) DEFAULT NULL,
25	FirstName VARCHAR(32) DEFAULT NULL,	25	FirstName VARCHAR(32) DEFAULT NULL,
26	SurName VARCHAR(32) DEFAULT NULL,	26	SurName VARCHAR(32) DEFAULT NULL,
27	Email VARCHAR(250) DEFAULT NULL,	27	Email VARCHAR(250) DEFAULT NULL,
28	PasswordHash VARCHAR(32) DEFAULT NULL,	28	PasswordHash VARCHAR(32) DEFAULT NULL,
29	PasswordSalt VARCHAR(32) DEFAULT NULL,	29	PasswordSalt VARCHAR(32) DEFAULT NULL,
30	HomeRegionID VARCHAR(36) DEFAULT NULL,	30	HomeRegionID VARCHAR(36) DEFAULT NULL,
31	HomeRegionX INT DEFAULT NULL,	31	HomeRegionX INT DEFAULT NULL,
32	HomeRegionY INT DEFAULT NULL,	32	HomeRegionY INT DEFAULT NULL,
33	HomeLocationX DOUBLE PRECISION DEFAULT NULL,	33	HomeLocationX DOUBLE PRECISION DEFAULT NULL,
34	HomeLocationY DOUBLE PRECISION DEFAULT NULL,	34	HomeLocationY DOUBLE PRECISION DEFAULT NULL,
35	HomeLocationZ DOUBLE PRECISION DEFAULT NULL,	35	HomeLocationZ DOUBLE PRECISION DEFAULT NULL,
36	HomeLookAtX DOUBLE PRECISION DEFAULT NULL,	36	HomeLookAtX DOUBLE PRECISION DEFAULT NULL,
37	HomeLookAtY DOUBLE PRECISION DEFAULT NULL,	37	HomeLookAtY DOUBLE PRECISION DEFAULT NULL,
38	HomeLookAtZ DOUBLE PRECISION DEFAULT NULL,	38	HomeLookAtZ DOUBLE PRECISION DEFAULT NULL,
39	Created INT DEFAULT NULL,	39	Created INT DEFAULT NULL,
40	LastLogin INT DEFAULT NULL,	40	LastLogin INT DEFAULT NULL,
41	UserInventoryURI VARCHAR(255) DEFAULT NULL,	41	UserInventoryURI VARCHAR(255) DEFAULT NULL,
42	UserAssetURI VARCHAR(255) DEFAULT NULL,	42	UserAssetURI VARCHAR(255) DEFAULT NULL,
43	Image VARCHAR(36) DEFAULT NULL,	43	Image VARCHAR(36) DEFAULT NULL,
44	FirstLifeImage VARCHAR(36) DEFAULT NULL,	44	FirstLifeImage VARCHAR(36) DEFAULT NULL,
45	AboutText TEXT DEFAULT NULL,	45	AboutText TEXT DEFAULT NULL,
46	FirstLifeAboutText TEXT DEFAULT NULL,	46	FirstLifeAboutText TEXT DEFAULT NULL,
47	CanDoMask INT DEFAULT NULL,	47	CanDoMask INT DEFAULT NULL,
48	WantDoMask INT DEFAULT NULL,	48	WantDoMask INT DEFAULT NULL,
49	UserFlags INT DEFAULT NULL,	49	UserFlags INT DEFAULT NULL,
50	GodLevel INT DEFAULT NULL,	50	GodLevel INT DEFAULT NULL,
51	CustomType VARCHAR(32) DEFAULT NULL,	51	CustomType VARCHAR(32) DEFAULT NULL,
52	Partner VARCHAR(36) DEFAULT NULL,	52	Partner VARCHAR(36) DEFAULT NULL,
53	RootInventoryFolderID VARCHAR(36) DEFAULT NULL,	53	RootInventoryFolderID VARCHAR(36) DEFAULT NULL,
54	PRIMARY KEY (ID)	54	PRIMARY KEY (ID)
55	);	55	);
56		56
57	CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);	57	CREATE INDEX UserSurnameIndex ON UserProfiles (SurName);
58	CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);	58	CREATE INDEX UserFirstNameIndex ON UserProfiles (FirstName);
59	CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);	59	CREATE UNIQUE INDEX UserFullNameIndex ON UserProfiles (SurName,FirstName);
60		60
61	CREATE TABLE UserAppearances (	61	CREATE TABLE UserAppearances (
62	Owner VARCHAR(36) NOT NULL,	62	Owner VARCHAR(36) NOT NULL,
63	BodyItem VARCHAR(36) DEFAULT NULL,	63	BodyItem VARCHAR(36) DEFAULT NULL,
64	BodyAsset VARCHAR(36) DEFAULT NULL,	64	BodyAsset VARCHAR(36) DEFAULT NULL,
65	SkinItem VARCHAR(36) DEFAULT NULL,	65	SkinItem VARCHAR(36) DEFAULT NULL,
66	SkinAsset VARCHAR(36) DEFAULT NULL,	66	SkinAsset VARCHAR(36) DEFAULT NULL,
67	HairItem VARCHAR(36) DEFAULT NULL,	67	HairItem VARCHAR(36) DEFAULT NULL,
68	HairAsset VARCHAR(36) DEFAULT NULL,	68	HairAsset VARCHAR(36) DEFAULT NULL,
69	EyesItem VARCHAR(36) DEFAULT NULL,	69	EyesItem VARCHAR(36) DEFAULT NULL,
70	EyesAsset VARCHAR(36) DEFAULT NULL,	70	EyesAsset VARCHAR(36) DEFAULT NULL,
71	ShirtItem VARCHAR(36) DEFAULT NULL,	71	ShirtItem VARCHAR(36) DEFAULT NULL,
72	ShirtAsset VARCHAR(36) DEFAULT NULL,	72	ShirtAsset VARCHAR(36) DEFAULT NULL,
73	PantsItem VARCHAR(36) DEFAULT NULL,	73	PantsItem VARCHAR(36) DEFAULT NULL,
74	PantsAsset VARCHAR(36) DEFAULT NULL,	74	PantsAsset VARCHAR(36) DEFAULT NULL,
75	ShoesItem VARCHAR(36) DEFAULT NULL,	75	ShoesItem VARCHAR(36) DEFAULT NULL,
76	ShoesAsset VARCHAR(36) DEFAULT NULL,	76	ShoesAsset VARCHAR(36) DEFAULT NULL,
77	SocksItem VARCHAR(36) DEFAULT NULL,	77	SocksItem VARCHAR(36) DEFAULT NULL,
78	SocksAsset VARCHAR(36) DEFAULT NULL,	78	SocksAsset VARCHAR(36) DEFAULT NULL,
79	JacketItem VARCHAR(36) DEFAULT NULL,	79	JacketItem VARCHAR(36) DEFAULT NULL,
80	JacketAsset VARCHAR(36) DEFAULT NULL,	80	JacketAsset VARCHAR(36) DEFAULT NULL,
81	GlovesItem VARCHAR(36) DEFAULT NULL,	81	GlovesItem VARCHAR(36) DEFAULT NULL,
82	GlovesAsset VARCHAR(36) DEFAULT NULL,	82	GlovesAsset VARCHAR(36) DEFAULT NULL,
83	UnderShirtItem VARCHAR(36) DEFAULT NULL,	83	UnderShirtItem VARCHAR(36) DEFAULT NULL,
84	UnderShirtAsset VARCHAR(36) DEFAULT NULL,	84	UnderShirtAsset VARCHAR(36) DEFAULT NULL,
85	UnderPantsItem VARCHAR(36) DEFAULT NULL,	85	UnderPantsItem VARCHAR(36) DEFAULT NULL,
86	UnderPantsAsset VARCHAR(36) DEFAULT NULL,	86	UnderPantsAsset VARCHAR(36) DEFAULT NULL,
87	SkirtItem VARCHAR(36) DEFAULT NULL,	87	SkirtItem VARCHAR(36) DEFAULT NULL,
88	SkirtAsset VARCHAR(36) DEFAULT NULL,	88	SkirtAsset VARCHAR(36) DEFAULT NULL,
89	Texture BYTEA,	89	Texture BYTEA,
90	VisualParams BYTEA,	90	VisualParams BYTEA,
91	Serial INT DEFAULT NULL,	91	Serial INT DEFAULT NULL,
92	AvatarHeight FLOAT DEFAULT NULL,	92	AvatarHeight FLOAT DEFAULT NULL,
93	PRIMARY KEY (Owner)	93	PRIMARY KEY (Owner)
94	);	94	);
95		95
96	CREATE TABLE UserFriends (	96	CREATE TABLE UserFriends (
97	UserFriendID VARCHAR(36) NOT NULL,	97	UserFriendID VARCHAR(36) NOT NULL,
98	OwnerID VARCHAR(36) DEFAULT NULL,	98	OwnerID VARCHAR(36) DEFAULT NULL,
99	FriendID VARCHAR(36) DEFAULT NULL,	99	FriendID VARCHAR(36) DEFAULT NULL,
100	FriendPermissions INT DEFAULT NULL,	100	FriendPermissions INT DEFAULT NULL,
101	PRIMARY KEY (UserFriendID)	101	PRIMARY KEY (UserFriendID)
102	);	102	);
103		103
104	CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);	104	CREATE UNIQUE INDEX UserFriendsOwnerIdFriendIdIndex ON UserFriends (OwnerID,FriendID);