Datenbankänderungen von Version STS-2022.3 → LTS-2022.4 (Stand 10/2022)
ARTICLE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| removed | EXCLUDEFROMOFFER | TINYINT(1) |
CLIENTSETTING: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DESCRIPTION | VARCHAR(255) |
CUSTOMER: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | DONOTASKFORDATAUNTIL | DATE |
DEFAULTDISCOUNT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | VALIDONINVOICEBEFORESTARTDATE | TINYINT(1) |
GLASSESCARE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | MINDESTBOHRLOCHDICKE | DECIMAL(10,2) |
| new | VERSIONNR | INT(11) |
INDICATION: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (LTS-2021.4) | POSNRA | VARCHAR(250) |
| amparex (LTS-2022.4) | POSNRA | VARCHAR(200) |
| amparex (LTS-2021.4) | POSNRB | VARCHAR(250) |
| amparex (LTS-2022.4) | POSNRB | VARCHAR(200) |
| amparex (LTS-2021.4) | POSNRC | VARCHAR(250) |
| amparex (LTS-2022.4) | POSNRC | VARCHAR(200) |
| amparex (LTS-2021.4) | POSNRD | VARCHAR(250) |
| amparex (LTS-2022.4) | POSNRD | VARCHAR(200) |
LENSEASSESSMENT: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | BRANCHID | CHAR(32) |
| new | CHAINID | CHAR(32) |
| new | CREATED | DATETIME |
| new | ID | CHAR(32) |
| new | LENSEACTIONID | CHAR(32) |
| new | MEASUREMENTID | CHAR(32) |
| new | MODIFIED | DATETIME(3) |
| new | NOTICE | TEXT |
| new | OVERREFRACTIONCALCULATED | TINYINT(1) |
| new | STAFFID | CHAR(32) |
| new | TREATMENTHEADID | CHAR(32) |
LENSECHECKUP: (removed)
| Type | Column | ColumnType |
|---|---|---|
| removed | BRANCHID | CHAR(32) |
| removed | CHAINID | CHAR(32) |
| removed | CREATED | DATETIME |
| removed | ID | CHAR(32) |
| removed | LENSEACTIONID | CHAR(32) |
| removed | MEASUREMENTID | CHAR(32) |
| removed | MODIFIED | DATETIME(3) |
| removed | NOTICE | TEXT |
| removed | STAFFID | CHAR(32) |
REFRACTIONREPORT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | STABILISATIONLEFT | DECIMAL(10,2) |
| new | STABILISATIONRIGHT | DECIMAL(10,2) |
REFRESHTOKEN: (new)
| Type | Column | ColumnType |
|---|---|---|
| new | CREATED | DATETIME |
| new | EXPIRATIONDATE | DATETIME |
| new | ID | VARCHAR(36) |
| new | MODIFIED | DATETIME |
| new | TOKEN | VARCHAR(100) |
| new | USERID | VARCHAR(32) |
SALESPRICECALCULATIONLIST: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | ISUSED | TINYINT(1) |
SERVICECONTRACT: (changed)
| Type | Column | ColumnType |
|---|---|---|
| amparex (LTS-2021.4) | EXTERNALCONTRACTID | VARCHAR(100) |
| amparex (LTS-2022.4) | EXTERNALCONTRACTID | CHAR(32) |
| amparex (LTS-2021.4) | EXTERNALCUSTOMERID | VARCHAR(100) |
| amparex (LTS-2022.4) | EXTERNALCUSTOMERID | CHAR(32) |
STATISTIC: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | FROMDATE | VARCHAR(200) |
| new | TODATE | VARCHAR(200) |
TPVIEW: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | FIRSTDAYOFWEEK | INT(11) |
TREATMENTTEMPLATE: (changed)
| Type | Column | ColumnType |
|---|---|---|
| new | CANCELREASONTYPEID | CHAR(32) |
VERSIONHISTORY: (removed)
| Type | Column | ColumnType |
|---|---|---|
| removed | BRANCHID | CHAR(32) |
| removed | CHAINID | CHAR(32) |
| removed | DOWNGRADEABLE | TINYINT(1) |
| removed | DOWNGRADED | TINYINT(1) |
| removed | DURATIONJAVA | INT(11) |
| removed | DURATIONSQL | INT(11) |
| removed | ID | CHAR(32) |
| removed | MODIFIED | DATETIME(3) |
| removed | RESULT | TEXT |
| removed | STATUS | VARCHAR(50) |
| removed | UPDATESTARTED | DATETIME |
| removed | VERSIONNAME | VARCHAR(50) |