Differences between revisions 10 and 12 (spanning 2 versions)
Revision 10 as of 2002-06-06 08:24:44
Size: 1470
Editor: user-uini6a1
Comment:
Revision 12 as of 2002-06-08 09:42:40
Size: 2042
Editor: DonPark
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
 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.  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. added URLs and password to User. (8Jun) -- DonPark
Line 7: Line 7:
  * String username (Key)
  * String first_name
  * String last_name
  * varchar GUID (32,Key)
  * date created
  * date modified
  * varchar username (64)
  * varchar first_name (64)
  * varchar last_name (64)
  * varchar password (64)
Line 13: Line 17:
  * Type URL, homepage
  * Type URL, faceimage
Line 15: Line 21:
  * varchar notes (5k)
Line 17: Line 24:
  * String id (Key)
  * Type: GPS, gps_loc
  * Type:
Antenna, antenna_type
  * Type: Direction antenna_pointing_direction
  * varchar GUID (32,Key)
  * date created
  * date modified
  * varchar name (128
)
  * Type Antenna, antenna_type
  * Type Direction antenna_pointing_direction
Line 22: Line 31:
  * Type: Address, Antenna
  * Type: Affiliated group [n]
  * Type: User, Owner [n]
  * Type: User, Maintainer [n]
  * 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
Line 32: Line 47:
 * Network
  * GUID varchar(32,Key)
  * date created
  * date modified
  * name varchar(128)

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. added URLs and password to User. (8Jun) -- DonPark

Databases

  • User
    • varchar GUID (32,Key)
    • date created
    • date modified
    • varchar username (64)
    • varchar first_name (64)
    • varchar last_name (64)
    • varchar password (64)
    • 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]

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