Datenbankänderungen von Version STS-2023.3 → STS-2023.4 (Stand 11/2023)
ARTICLE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
HASUDI |
TINYINT(1) |
NULL |
|
YES |
None |
|
ARTICLEBUNDLE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
ARTICLEITEM: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
new |
UDI |
VARCHAR(250) |
NULL |
|
YES |
None |
|
ARTICLEVARIANT: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
ASSORTMENTHEAD: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
AUTOMATICALLY |
TINYINT(1) |
0 |
|
YES |
None |
|
new |
CREATEORDERWISHESINSTEADORDER |
TINYINT(1) |
0 |
|
YES |
None |
|
CARE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(20) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
COMPARATIVEFITTING: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
COMPLAINT: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
CUSTOMERDETAIL: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
DISCOUNTVALUEPERCENT |
DECIMAL(12,2) |
NULL |
|
YES |
None |
|
LTS-2022.4 |
DOMINANTEYE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
DOMINANTEYE |
VARCHAR(50) |
|
|
NO |
None |
|
LTS-2022.4 |
DOMINANTHAND |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
DOMINANTHAND |
VARCHAR(50) |
|
|
NO |
None |
|
new |
INDIVIDUALDISCOUNTID |
CHAR(32) |
NULL |
|
YES |
None |
|
CUSTOMERFLATRATE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
DELIVERY: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
PROVIDER |
VARCHAR(5) |
NULL |
|
YES |
None |
|
new |
RETOURENUMBER |
VARCHAR(50) |
NULL |
|
YES |
None |
|
new |
SHIPPINGSTATUS |
VARCHAR(30) |
NULL |
|
YES |
None |
|
DELIVERYPOSITION: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
new |
UDI |
VARCHAR(250) |
NULL |
|
YES |
None |
|
GLASSESCONFIGURATION: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
HICOSTCOVERAGE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
AMOUNTCOSTCOVERAGE |
DECIMAL(12,2) |
NULL |
|
YES |
None |
|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
INVOICEPOSITION: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
AMOUNTCOSTCOVERAGE1 |
DECIMAL(12,2) |
NULL |
|
YES |
None |
|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
new |
UDI |
VARCHAR(250) |
NULL |
|
YES |
None |
|
OAUTHTOKEN: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
REFERENCEID |
CHAR(32) |
None |
|
NO |
None |
|
new |
REFERENCETYPE |
VARCHAR(50) |
'service_configuration' |
|
YES |
None |
|
removed |
SERVICECONFIGURATIONID |
CHAR(32) |
None |
COL_INDEXED |
NO |
None |
|
OAUTHTOKEN: Indexes/Constraints
Type
| Index Name
| Columns
|
---|
removed in LTS-2023.4 |
FK_OAUTHTOKEN_SERVICECONFIGURATION |
SERVICECONFIGURATIONID |
OAUTHTOKEN: Foreign Keys
Type
| Constraint Name
| Parent Table (Columns)
|
---|
removed in LTS-2023.4 |
FK_OAUTHTOKEN_SERVICECONFIGURATION |
SERVICECONFIGURATION (SERVICECONFIGURATIONID) |
ORDERPOSITION: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|
PICKUPORDER: (new)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
BRANCHID |
CHAR(32) |
NULL |
|
YES |
None |
|
new |
CHAINID |
CHAR(32) |
None |
|
NO |
None |
|
new |
FREEOFCHARGE |
TINYINT(1) |
NULL |
|
YES |
None |
|
new |
ID |
CHAR(32) |
None |
COL_IN_PK |
NO |
None |
|
new |
MODIFIED |
DATETIME |
None |
|
NO |
None |
|
new |
ORDERID |
VARCHAR(50) |
NULL |
|
YES |
None |
|
new |
ORDERSTATE |
VARCHAR(10) |
NULL |
|
YES |
None |
|
new |
PICKUPDATE |
DATE |
None |
|
NO |
None |
|
new |
PICKUPTYPE |
VARCHAR(20) |
NULL |
|
YES |
None |
|
new |
PROVIDER |
VARCHAR(5) |
NULL |
|
YES |
None |
|
new |
STAFFID |
CHAR(32) |
NULL |
COL_INDEXED |
YES |
None |
|
new |
TOADDRESSID |
CHAR(32) |
NULL |
COL_INDEXED |
YES |
None |
|
PICKUPORDER: Indexes/Constraints
Type
| Index Name
| Columns
|
---|
new in LTS-2023.4 |
PRIMARY |
ID |
new in LTS-2023.4 |
FK_PICKUPORDER_ADDRESS |
TOADDRESSID |
new in LTS-2023.4 |
FK_PICKUPORDER_STAFF |
STAFFID |
PICKUPORDER: Foreign Keys
Type
| Constraint Name
| Parent Table (Columns)
|
---|
new in LTS-2023.4 |
FK_PICKUPORDER_ADDRESS |
ADDRESS (TOADDRESSID) |
new in LTS-2023.4 |
FK_PICKUPORDER_STAFF |
STAFF (STAFFID) |
PRINCIPALBRANCHROLE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
EXTENDEDLOGIN |
TINYINT(1) |
0 |
|
NO |
None |
|
TPONLINECONFIGURATION: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
CSSLOCATIONTERMINO |
TEXT |
NULL |
|
YES |
None |
|
TPRESOURCE: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
new |
GOAUTH |
TINYINT(1) |
0 |
|
NO |
None |
|
TREATMENTHEAD: (changed)
Type
| Column
| ColumnType
| COLUMN_DEFAULT
| COLUMN_KEY
| IS_NULLABLE
| check_clause
| comment
|
---|
LTS-2022.4 |
SIDE |
VARCHAR(50) |
|
|
YES |
None |
|
LTS-2023.4 |
SIDE |
VARCHAR(50) |
|
|
NO |
None |
|