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** |