1470
Comment:
|
2042
|
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