[Loadstone] point table

[Shawn Kirkpatrick]

Adding other fields to the table will be done at some point. I'd like to 
have a phone number field so there could be an option to call the number 
directly. I'd also like a comments field for additional information. This 
probably isn't going to happen for a while thoe since changing database 
tables will break compatability with the existing databases. I want to 
rewrite the entire database system at some point but that'll be a big job.
In the current system the maximum length of a point is 75 characters. If 
you're hitting that limit try using abreviations if you can. For bus stops 
you can use things like eb for east bound, wb for west bound, etc. Then if 
you're using talks 3 you can use the dictionary to make it say the full 
versions of these abreviations.
The id field is a 32 bit unsigned integer. The userid field is a 16 bit 
unsigned integer. The id field is basically a unix time stamp. This means if 
you're manually generating points you want to make sure the id doesn't start 
using values that could overlap with the present time.

On Fri, 3 Aug 2007, Dave Mielke wrote:

> [quoted lines by Mikolaj Rotnicki on 2007/08/03 at 23:55 +0200]
>
>> I believe it is max. 75 characters.
>
> Would it be possible to add a description field to a point which would only be
> displayed on request? That way one could add additional data which a user can
> optionally request. For xample, each bus stop in my city has a phone number
> which one can call to find out when the next bus for each route that uses that
> stop will come. This is very useful information to have in the map as a blind
> person can't read it off the sign, but adding that kind of information to the
> point name often causes it to become too long for the field.
>
> -- 
> Dave Mielke           | 2213 Fox Crescent | I believe that the Bible is the
> Phone: 1-613-726-0014 | Ottawa, Ontario   | Word of God. Please contact me
> EMail: dave at mielke.cc | Canada  K2A 1H7   | if you're concerned about Hell.
> http://FamilyRadio.com/                   | http://Mielke.cc/bible/
> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>