Changes between Version 30 and Version 31 of OrgGrid


Ignore:
Timestamp:
Jul 15, 2008, 3:22:28 PM (16 years ago)
Author:
teleyinex
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • OrgGrid

    v30 v31  
    105105== Implementation ==
    106106
    107 The tool has the following tables:
     107OGM has two main components: the server and the BOINC client. The tool employs the Account Manager protocol for all the communications.
     108
     109== Data Base Structure ==
     110The following sub-sections presents the DB tables.
    108111=== users ===
    109  * id INTEGER, KEY
     112 * id VARCHAR, KEY
    110113 * password STRING
    111  * rolid INTEGER, FKINDEX
    112  * departmenid INTEGER, FKINDEX
    113 
    114 === roles ===
    115  * id INTEGER, KEY
    116  * name VARCHAR
     114 * role INTEGER
     115 * department VARCHAR
    117116
    118117=== pools ===
    119118 * id INTEGER, KEY
    120  * name VARCHAR
    121  * organization ID
     119 * name STRING
     120 * department STRING
    122121 * prefs This field copes with all the BOINC preferences for one computer
    123 
    124 === organization ===
    125  * id INTEGER, KEY
    126  * name VARCHAR
    127  * location STRING
    128122
    129123=== host ===
    … …  
    132126 * features This field copes with all the PC features (RAM, CPU, HD, etc.)
    133127
    134 
    135128=== projects ===
    136129 * id INTEGER, KEY
    137  * name VARCHAR
     130 * name STRING
    138131 * url STRING
    139  * signature string
     132 * signature STRING
    140133 * share FLOAT (between 0.0 and 1.0)