diff options
| author | Andris Zeila <andris.zeila@zabbix.com> | 2021-10-11 15:43:36 +0300 |
|---|---|---|
| committer | Andris Zeila <andris.zeila@zabbix.com> | 2021-10-11 15:43:36 +0300 |
| commit | 57d9f1d72c2a0b9a67038b534cd7a7cd70187c44 (patch) | |
| tree | a1ac49a26ee0f6932be76f7b34f8326d2040f557 /create | |
| parent | 4ed99ac36cf95b56998d66c8f0674da2441d8f81 (diff) | |
....I..... [ZBXNEXT-6923] fixed/updated database patch
Diffstat (limited to 'create')
| -rw-r--r-- | create/src/schema.tmpl | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/create/src/schema.tmpl b/create/src/schema.tmpl index e038b689768..f311f24752e 100644 --- a/create/src/schema.tmpl +++ b/create/src/schema.tmpl @@ -1111,6 +1111,7 @@ FIELD |resourceid |t_id | |NULL |0 FIELD |resourcename |t_varchar(255) |'' |NOT NULL |0 FIELD |recordsetid |t_cuid | |NOT NULL |0 FIELD |details |t_longtext |'' |NOT NULL |0 +FIELD |resource_cuid |t_cuid | |NULL |0 INDEX |1 |userid,clock INDEX |2 |clock INDEX |3 |resourcetype,resourceid @@ -1896,10 +1897,11 @@ FIELD |address |t_varchar(255) |'' |NOT NULL |0 FIELD |port |t_integer |'10051'|NOT NULL |0 FIELD |lastaccess |t_integer |'0' |NOT NULL |0 FIELD |status |t_integer |'0' |NOT NULL |0 -UNIQ |1 |name +FIELD |sessionid |t_cuid |'' |NOT NULL |0 +UNIQUE |1 |name INDEX |2 |status,lastaccess TABLE|dbversion|| FIELD |mandatory |t_integer |'0' |NOT NULL | FIELD |optional |t_integer |'0' |NOT NULL | -ROW |5050073 |5050073 +ROW |5050074 |5050074 |