Differences between revisions 7 and 8
Revision 7 as of 2002-06-04 20:24:50
Size: 947
Editor: DonPark
Comment:
Revision 8 as of 2002-06-04 20:25:29
Size: 942
Editor: DonPark
Comment:
Deletions are marked like this. Additions are marked like this.
Line 22: Line 22:
  *
Line 24: Line 23:
* GPS Loc  * GPS Loc

Databases

  • User
    • String username (Key)
    • String first_name
    • String last_name
    • String wireless_community_id (off the back of your wifi id card :)

    • Type ICQ, icq_id
    • Type Jabber, jabber_id
    • Type Address, mailing
    • Type Login, last_login
  • Node
    • String id (Key)
    • Type: GPS, gps_loc
    • Type: Antenna, antenna_type
    • Type: Direction antenna_pointing_direction
    • int power_output
    • Type: Address, Antenna
    • Type: Affiliated group [n]
    • Type: User, Owner [n]
    • Type: User, Maintainer [n]
  • GPS Loc
    • float lat
    • float long
    • float altitude

System for getting at the data

  • XML-RPC interface
  • xmlrpc.personaltelco.net:3322
  • inserts
  • updates
  • queries
    • Q: <nodequery sql="select * where name=\"PCHS\" " />

    • A: <node> <name>PCHS</name> </node> ...

Implementation

  • PHP page talking to a MySQL server


[CategoryDocumentation]

CommunityDatabase (last edited 2012-03-11 02:06:36 by RussellSenior)