This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| access:internet_key_model [2011/02/01 23:16] mjallison | access:internet_key_model [2012/10/10 16:20] (current) | ||
|---|---|---|---|
| Line 19: | Line 19: | ||
| Key codes are: | Key codes are: | ||
| - | * T - Timed | ||
| * P - Permanent | * P - Permanent | ||
| + | * S - Software | ||
| + | * O - One time | ||
| * R - Rental | * R - Rental | ||
| - | * D - Demo | + | * T - Training | 
| Product feature codes are 4 character tuples for each program/feature. Examples might include something like: | Product feature codes are 4 character tuples for each program/feature. Examples might include something like: | ||
| Line 44: | Line 45: | ||
| Log types are: | Log types are: | ||
| + | * 'C' - License creation | ||
| * 'I' - License checkin | * 'I' - License checkin | ||
| * 'O' - License checkout | * 'O' - License checkout | ||
| Line 50: | Line 52: | ||
| * 'R' - Rental activation | * 'R' - Rental activation | ||
| * 'D' - Demo activation | * 'D' - Demo activation | ||
| + | |||
| + | ===== License Key Timers ===== | ||
| + | Variant of Timed Key | ||
| + | | **Key Type** |Start time|Expire time|Expire Updates|Timed expire|Max checkout duration|Note| | ||
| + | |Timed Key |Set@Key create|create+35d|N/A|Set by AGTEK|Customer settable| | ||
| + | |Permanent Key |Set@Key create|Never|N/A|Set by AGTEK|Customer settable| | ||
| + | |Training Key |Set@Key create|create+10 days|AGTEK manual op|N/A|Customer settable|Allows all users="*"| | ||
| + | |Rental Key |Set@Key create|create+1 year|AGTEK manual op|N/A|Customer settable|Called out for billing| | ||
| + | |||
| + | Strange keys | ||
| + | | **Key Type** |Start time|Expire time|Expire Updates|Timed expire|Max checkout duration|Note| | ||
| + | |Software Key |Set@Key create|create+1yr|now+1 year on renew|Set by AGTEK|N/A|requires periodic renewal()+secret sauce collected and checked on client to server, NEVER allow checkin| | ||
| + | |One Time Key |Set@Key create|Never|N/A|N/A|Forever|NEVER allow checking or renew| | ||
| ====== Data Base Tables ====== | ====== Data Base Tables ====== | ||
| Line 61: | Line 76: | ||
| | maxcheckout| int(32)  | NO |  | NULL | | Unix delta time for maximum checkout by user |CUST| | | maxcheckout| int(32)  | NO |  | NULL | | Unix delta time for maximum checkout by user |CUST| | ||
| | starttime | int(32)  | NO |  | NULL | | Unix time of key activation |AUTO| | | starttime | int(32)  | NO |  | NULL | | Unix time of key activation |AUTO| | ||
| - | | duration  | int(32)  | NO |  | NULL | | Delta Unix time for duration |AUTO| | + | | expiretime| int(32)  | NO |  | NULL | | Unix time for key expire, -1 == never; rental = duration + starttime|AGTEK| | 
| - | | expire  | int(32)  | NO |  | NULL | | Unix time for key expire, -1 == never; rental = duration + starttime|AGTEK| | + | |
| | products  | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 |AGTEK| | | products  | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 |AGTEK| | ||
| - | | tempexpire  | int(32)  | NO |  | NULL | | Expire time for all temporary products |AGTEK| | + | | timedproducts | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 |AGTEK| | 
| - | | tempproducts | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 |AGTEK| | + | | timedexpire  | int(32)  | NO |  | NULL | | Expire time for all temporary products |AGTEK| | 
| + | | checkedout  | tinyint(1) | NO | | NULL | | 1 if checked out, 0 if available |AUTO| | ||
| + | | expired  | tinyint(1)  | NO |  | NULL | | 1 if expired, 0 if available |AUTO| | ||
| **Operations** | **Operations** | ||