access:internet_key_model
Differences
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/01/27 22:54] 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 ====== | ||
| **License Table** | **License Table** | ||
| - | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** | | + | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** |**mod access**| |
| - | | handle | int(32) | NO | PRI | NULL | auto_increment | Universal ID for key | | + | | handle | int(32) | NO | PRI | NULL | auto_increment | Universal ID for key |AUTO| |
| - | | type | char(1) | NO | | NULL | | {'T', 'P', 'R', 'D'} | | + | | type | char(1) | NO | | NULL | | {'T', 'P', 'R', 'D'} |AGTEK| |
| - | | custid | int(16) | NO | | NULL | | ID of customer | | + | | custid | int(16) | NO | | NULL | | ID of customer |AGTEK| |
| - | | numusers | int(16) | NO | | NULL | | Number of allowed users | | + | | numusers | int(16) | NO | | NULL | | Number of allowed users |AGTEK| |
| - | | maxcheckout| int(32) | NO | | NULL | | Unix delta time for maximum checkout by user | | + | | maxcheckout| int(32) | NO | | NULL | | Unix delta time for maximum checkout by user |CUST| |
| - | | starttime | int(32) | NO | | NULL | | Unix time of key activation | | + | | starttime | int(32) | NO | | NULL | | Unix time of key activation |AUTO| |
| - | | duration | int(32) | NO | | NULL | | Delta Unix time for duration | | + | | 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; renatal = duration + starttime | | + | | 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 | | + | | timedproducts | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 |AGTEK| |
| - | | tempexpire | int(32) | NO | | NULL | | Expire time for all temporary products | | + | | timedexpire | int(32) | NO | | NULL | | Expire time for all temporary products |AGTEK| |
| - | | tempproducts | varchar(255) | YES | | NULL | | Quad code, comma sep, up to 50 | | + | | 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** | ||
| Line 76: | Line 92: | ||
| **License Users** | **License Users** | ||
| - | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** | | + | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** |**mod access**| |
| - | | handle | int(16) | NO | PRI | NULL | auto_increment | Universal ID for this association | | + | | handle | int(16) | NO | PRI | NULL | auto_increment | Universal ID for this association |AUTO| |
| - | | keyid | int(32) | YES | | NULL | | ID of key to associate | | + | | keyid | int(32) | YES | | NULL | | ID of key to associate |AUTO (driven by admin request)| |
| - | | userid | int(16) | YES | | NULL | | ID of user to associate | | + | | userid | int(16) | YES | | NULL | | ID of user to associate |AUTO (driven by admin request)| |
| * Get list of all users on specific key | * Get list of all users on specific key | ||
| Line 86: | Line 102: | ||
| **License Log** | **License Log** | ||
| - | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** | | + | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** |**mod access**| |
| - | | handle | int(32) | NO | PRI | NULL | auto_increment | Universal ID for this log entry | | + | | handle | int(32) | NO | PRI | NULL | auto_increment | Universal ID for this log entry |AUTO| |
| - | | time | int(32) | NO | | NULL | | Unix time of the log | | + | | time | int(32) | NO | | NULL | | Unix time of the log |AUTO| |
| - | | keyid | int(32) | YES | | NULL | | KeyID assoc with this log. | | + | | keyid | int(32) | YES | | NULL | | KeyID assoc with this log. |AUTO| |
| - | | type | char(1) | NO | | NULL | | Entry type (see below) | | + | | type | char(1) | NO | | NULL | | Entry type (see below) |AUTO| |
| - | | userid | int(16) | NO | | NULL | | UserID performing op | | + | | userid | int(16) | NO | | NULL | | UserID performing op |AUTO| |
| - | | comment | varchar(512) | YES | | NULL | | Free form text | | + | | comment | varchar(512) | YES | | NULL | | Free form text |AUTO| |
| * List all events | * List all events | ||
| Line 104: | Line 120: | ||
| **MOTD** (announcements) | **MOTD** (announcements) | ||
| - | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** | | + | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** |**mod access**| |
| - | | handle | int(32) | NO | PRI | NULL | auto_increment | Unique id of announcement | | + | | handle | int(32) | NO | PRI | NULL | auto_increment | Unique id of announcement |AUTO| |
| - | | products | varchar(255) | YES | | NULL | | Product codes affected, null == all products | | + | | products | varchar(255) | YES | | NULL | | Product codes affected, null == all products |AUTO| |
| - | | expire | int(32) | NO | | NULL | | When this message is no longer active | | + | | expire | int(32) | NO | | NULL | | When this message is no longer active |AUTO| |
| - | | message | varchar(1024) | YES | | NULL | | Text of message | | + | | message | varchar(1024) | YES | | NULL | | Text of message |AUTO| |
| **Alterations to Customer** | **Alterations to Customer** | ||
| - | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** | | + | | **Field** | **Type** | **Null** | **Key** | **Default** | **Extra** | **Comment** |**mod access**| |
| - | | hasccess | tinyint(4) | NO | | 0 | | Indicates if users belonging to this customer can use AGTEK Access | | + | | hasccess | tinyint(4) | NO | | 0 | | Indicates if users belonging to this customer can use AGTEK Access |AGTEK| |
| - | | haslicense | tinyint(4) | NO | | 0 | | Indicates if users belonging to this customer can use AGTEK License Server | | + | | haslicense | tinyint(4) | NO | | 0 | | Indicates if users belonging to this customer can use AGTEK License Server |AGTEK| |
access/internet_key_model.1296168847.txt.gz · Last modified: 2012/10/10 16:20 (external edit)
Page Tools
