• CommunityDatabase

DonPark and AdamShand are thinking about ways to create a SQL (or maybe LDAP or XML or something) schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that we're going to want to store in it (yes we know we're doomed to failure :-).

• Don, it occurred to me that it might be worth checking out the NoCatAuth SQL schema (etc/nocat.schema in the tarball), they had originally planned for it to be more then just the auth server. -- Adam. I looked it over. added bandwidth and date to Node. Created Network. -- DonPark

Databases

• User
  • varchar GUID (32,Key)
  • date created
  • date modified
  • String username
  • 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 URL, homepage
  • Type URL, faceimage
  • Type Address, mailing
  • Type Login, last_login
  • varchar notes (5k)
• Node
  • varchar GUID (32,Key)
  • date created
  • date modified
  • varchar name (128)
  • Type Antenna, antenna_type
  • Type Direction antenna_pointing_direction
  • int power_output
  • int kbits_second
  • Type Address, antenna_address
  • Type GPS, antenna_gps
  • Type Affiliated group [n]
  • Type User, Owner [n]
  • Type User, Administrator [n]
  • varchar notes (5k)
  • Type URL, description
  • Type URL, login_help
• GPS Loc
  • float lat
  • float long
  • float altitude
• Network
  • GUID varchar(32,Key)
  • date created
  • date modified
  • name varchar(128)

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]