Boat database notes:

[omar]

Boat Database Notes:

file: regatta.db
format: sqlite3 database
table: boats
fields:
* idBoat INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
table index - used to locate boats
* boatname VARCHAR(30) NOT NULL
* PWmd5 VARCHAR(50) NULL - Hash used for owner authentication
(boat owner passwords are not saved to the file, for privacy)
value = md5( salt+lowercase(Boatname)+password )
Salt and password are case sensitive. Boatname is not.
Salt is set on the Regatta Runner control panel.
- regatta.db default Salt = 'salt'
Note: if the Salt field is wrong, authentication system will fail
and users will not be allowed to access the boats remotely.

* PosTime TIMESTAMP NULL - Time of last point
* Latitude FLOAT NULL - last lat
* Longitude FLOAT NULL - last lon
* BoatSpeed FLOAT NULL
* WindSpeed FLOAT NULL
* WindAngle INTEGER NULL
* WindDir INTEGER NULL
* Course INTEGER NULL
* Classif INTEGER NULL
* SailNumber INTEGER NULL
* BoatList TEXT NULL - boat watchlist - List of boatnames in text format.
* phpUsername VARCHAR(30) UNIQUE NULL - optional username for interaction with phpBB3
* CanSetPosition BOOLEAN NULL - if true, owner can change boat position (tele transport)
* IsMovedBoat BOOLEAN NULL - if true, Regatta Runner moves this boat