<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">The users table on OSGrid currently contains a number of fields, many used, some unused. The proposed opensimwebinterface is currently version 0.23 and adds 8 fields. I need to know if the group feels adding these 8 fields is appropriate. I would hate for OSGrid to end up with a database incompatible with the direction of our software.<br><br>The eight fields defined in an 'update_users.sql' are :<br><br>realname1<br>realname2<br>address1<br>zip1<br>city1<br>country1<br>emailaddress<br>active<br><br>The fields currently in the users table
are:<br><br>UUID<br>username<br>lastname<br>passwordHash<br>passwordSalt<br>homeRegion<br>homeLocationX<br>homeLocationY<br>homeLocationZ<br>homeLookAtX<br>homeLookAtY<br>homeLookAtZ<br>created<br>lastLogin<br>userInventoryURI<br>userAssetURI<br>profileCanDoMask<br>profileWantDoMask<br>profileAboutText<br>profileFirstText<br>profileImage<br>profileFirstImage<br><br>My opinion on all this is several fold. <br><br>Fold 1: I dont see any need for realname, address, zip, city, country stuff. In fact, zip is not used in any country but one.<br><br>Fold 2: I want to encourage this related project, but dont want to let OSGrid evolve in a direction that takes away from test results and benefit to OpenSim.<br><br>Fold 3: Having an emailaddress lets us contact a user. Currently this is in a Mambo table, so this is probably Ok. But perhaps OpenSim should add it officially in svn.<br><br>Fold 4: There are 4 other tables with names like wi_admin, wi_adminsetting,
wi_sitemanager, wi_lastnames, wi_country. I assume no one objects if I add these to the 'osgridredux' database.<br><br>Fold 5: I am a noob at SQL stuff, so I am really looking for a little guidance here to make sure OSGrid continues to benefit us all.<br><br>Charles<br></div></div></body></html>