SQL result

Host: localhost
Database: opensim
Generation Time: Mar 09, 2013 at 07:45 AM
Generated by: phpMyAdmin 3.3.2deb1ubuntu1 / MySQL 5.1.67-0ubuntu0.10.04.1


SQL query: SHOW FULL COLUMNS FROM UserAccounts;
Rows: 10
Field 	Type 	Collation 	Null 	Key 	Default 	Extra 	Privileges 	Comment
PrincipalID 	char(36) 	utf8_general_ci 	NO 	PRI 	NULL 	  	select,insert,update,references 	 
ScopeID 	char(36) 	utf8_general_ci 	NO 	  	NULL 	  	select,insert,update,references 	 
FirstName 	varchar(64) 	utf8_general_ci 	NO 	MUL 	NULL 	  	select,insert,update,references 	 
LastName 	varchar(64) 	utf8_general_ci 	NO 	MUL 	NULL 	  	select,insert,update,references 	 
Email 	varchar(64) 	utf8_general_ci 	YES 	MUL 	NULL 	  	select,insert,update,references 	 
ServiceURLs 	text 	utf8_general_ci 	YES 	  	NULL 	  	select,insert,update,references 	 
Created 	int(11) 	NULL 	YES 	  	NULL 	  	select,insert,update,references 	 
UserLevel 	int(11) 	NULL 	NO 	  	0 	  	select,insert,update,references 	 
UserFlags 	int(11) 	NULL 	NO 	  	0 	  	select,insert,update,references 	 
UserTitle 	varchar(64) 	utf8_general_ci 	NO 	  	  	  	select,insert,update,references 
_____________________________________________________________________________________________________________________
SQL query: SHOW FULL COLUMNS FROM GridUser;
Rows: 10
Field 	Type 	Collation 	Null 	Key 	Default 	Extra 	Privileges 	Comment
UserID 	varchar(255) 	latin1_swedish_ci 	NO 	PRI 	NULL 	  	select,insert,update,references 	 
HomeRegionID 	char(36) 	latin1_swedish_ci 	NO 	  	00000000-0000-0000-0000-000000000000 	  	select,insert,update,references 	 
HomePosition 	char(64) 	latin1_swedish_ci 	NO 	  	<0,0,0> 	  	select,insert,update,references 	 
HomeLookAt 	char(64) 	latin1_swedish_ci 	NO 	  	<0,0,0> 	  	select,insert,update,references 	 
LastRegionID 	char(36) 	latin1_swedish_ci 	NO 	  	00000000-0000-0000-0000-000000000000 	  	select,insert,update,references 	 
LastPosition 	char(64) 	latin1_swedish_ci 	NO 	  	<0,0,0> 	  	select,insert,update,references 	 
LastLookAt 	char(64) 	latin1_swedish_ci 	NO 	  	<0,0,0> 	  	select,insert,update,references 	 
Online 	char(5) 	latin1_swedish_ci 	NO 	  	false 	  	select,insert,update,references 	 
Login 	char(16) 	latin1_swedish_ci 	NO 	  	0 	  	select,insert,update,references 	 
Logout 	char(16) 	latin1_swedish_ci 	NO 	  	0 	  	select,insert,update,references 	 
---------------------------------------------------------------------------
SQL query: SHOW FULL COLUMNS FROM Presence;
Rows: 5
Field 	Type 	Collation 	Null 	Key 	Default 	Extra 	Privileges 	Comment
UserID 	varchar(255) 	utf8_general_ci 	NO 	MUL 	NULL 	  	select,insert,update,references 	 
RegionID 	char(36) 	utf8_general_ci 	NO 	  	00000000-0000-0000-0000-000000000000 	  	select,insert,update,references 	 
SessionID 	char(36) 	utf8_general_ci 	NO 	PRI 	00000000-0000-0000-0000-000000000000 	  	select,insert,update,references 	 
SecureSessionID 	char(36) 	utf8_general_ci 	NO 	  	00000000-0000-0000-0000-000000000000 	  	select,insert,update,references 	 
LastSeen 	timestamp 	NULL 	NO 	  	CURRENT_TIMESTAMP 	on update CURRENT_TIMESTAMP 	select,insert,update,references