User Tools
id_licencemanagement_dev
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
id_licencemanagement_dev [2018/09/29 12:04] 178.12.176.34 |
id_licencemanagement_dev [2021/06/14 21:30] (current) 77.20.150.10 |
||
|---|---|---|---|
| Line 97: | Line 97: | ||
| **Lizenzprozess Ablauf** | **Lizenzprozess Ablauf** | ||
| - | Hardware ID (HWID) | + | DIE Hardware ID (HWID) HWID wird pro Produkt gespeichert in "rlenit.ky" |
| - | HWID in "rlenit.ky" | + | |
| - | -> Software + Lizenzschlüssel Verkaufen/Vetreiben = Erfüllt (E) und teilweise (D) | + | |
| + | -> Software + Lizenzschlüssel Verkaufen/Vertreiben = Erfüllt (E) und teilweise (D) | ||
| Line 115: | Line 115: | ||
| ---- | ---- | ||
| + | **Lizenzprozess Ablauf Schema innerhalb des MPV Codes** | ||
| - | **Datenbankschema "VSELicenseDB" :** | ||
| - | {{:img_20180409_193455.jpg?nolink|}} | + | {{:licenceprocessscheme.png?1100|}} |
| - | ---- | ||
| - | **MySQL Datenbank Scripte:** | ||
| - | **- Anlegen der Datenbank (10.4.2018):** | + | {{ :licenceprocessscheme.pdf |}} |
| + | ---- | ||
| - | SHOW DATABASES; | + | **Datenbankschema "VSELicenseDB" :** |
| + | {{:img_20180409_193455.jpg?nolink|}} | ||
| - | CREATE DATABASE IF NOT EXISTS `VSELicenseDB`; | + | ---- |
| - | + | ||
| - | USE `VSELicenseDB`; | + | |
| - | + | ||
| - | + | ||
| - | CREATE TABLE IF NOT EXISTS `ValidProductKeys` ( | + | |
| - | `id` BIGINT(11) unsigned NOT NULL auto_increment, | + | |
| - | `allowedProductKeys` CHAR(30) , | + | |
| - | `allowedTimePeriod` BIGINT(11) unsigned NOT NULL default '2' , | + | |
| - | `numberofallowedClients` BIGINT(11) unsigned NOT NULL default '2' , | + | |
| - | `numberofusedClients` BIGINT(11) unsigned NOT NULL default '0' , | + | |
| - | `allowedProductKeys` CHAR(30), | + | |
| - | `Product` CHAR(200) NOT NULL, | + | |
| - | `Status` BIGINT(11) unsigned NOT NULL default '1', | + | |
| - | `TimeofFirstActivation` TIMESTAMP default NULL, | + | |
| - | PRIMARY KEY (`id`) | + | |
| - | ); | + | |
| - | + | ||
| - | + | ||
| - | CREATE TABLE IF NOT EXISTS `EvidenceofValidProductKeys` ( | + | |
| - | `id` BIGINT(11) unsigned NOT NULL auto_increment, | + | |
| - | `EvidenceofallowedProductKeys` CHAR(30) , | + | |
| - | `EvidenceofallowedTimePeriod` BIGINT(11) default '2' , | + | |
| - | PRIMARY KEY (`id`) | + | |
| - | ); | + | |
| - | + | ||
| - | + | ||
| - | CREATE TABLE IF NOT EXISTS `Productkeysbeingused` ( | + | |
| - | `id` BIGINT(20) unsigned NOT NULL auto_increment, | + | |
| - | `ProductKeyinuse` CHAR(30), | + | |
| - | `TimeofFirstActivation` TIMESTAMP, | + | |
| - | `TimeofLastActivation` TIMESTAMP, | + | |
| - | `numberofactivations` BIGINT(20), | + | |
| - | `HardwareCode` CHAR(100) default '0', | + | |
| - | `IP` CHAR(30) default '0', | + | |
| - | `SendMessage` BIGINT(20) default '0', | + | |
| - | PRIMARY KEY (`id`) | + | |
| - | ); | + | |
| - | + | ||
| - | + | ||
| - | CREATE TABLE IF NOT EXISTS `Messages` ( | + | |
| - | `id_message` int(20) unsigned NOT NULL auto_increment, | + | |
| - | `message_de` TEXT, | + | |
| - | `message_en` TEXT, | + | |
| - | `message_es` TEXT, | + | |
| - | `message_ru` TEXT, | + | |
| - | `message_he` TEXT, | + | |
| - | PRIMARY KEY (`id_message`) | + | |
| - | ); | + | |
| - | + | ||
| - | + | ||
| - | SHOW TABLES; | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | {{:licenceprocessscheme.png?900|}} | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | {{ :licenceprocessscheme.pdf |}} | + | |
id_licencemanagement_dev.1538215447.txt.gz · Last modified: 2018/09/29 12:04 by 178.12.176.34
Page Tools
