diff options
| author | Vladislavs Sokurenko <vladislavs.sokurenko@zabbix.com> | 2021-11-22 12:28:20 +0300 |
|---|---|---|
| committer | Vladislavs Sokurenko <vladislavs.sokurenko@zabbix.com> | 2021-11-22 12:28:20 +0300 |
| commit | 882f0efe3fbdd4bc81d55702c897b8687285b18d (patch) | |
| tree | c067a9a2e53acf43dbe11c42f7c381355f3c7d27 /create | |
| parent | 59cfb62d05a9e9f76ea0badb1bd070bc66189abf (diff) | |
....I..... [ZBXNEXT-6999] updated schema and upgrade patch for schema
Diffstat (limited to 'create')
| -rw-r--r-- | create/src/schema.tmpl | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/create/src/schema.tmpl b/create/src/schema.tmpl index 02e6a07abac..56f9fd0a1e4 100644 --- a/create/src/schema.tmpl +++ b/create/src/schema.tmpl @@ -1902,10 +1902,16 @@ FIELD |period |t_integer |'0' |NOT NULL |0 FIELD |timezone |t_varchar(50) |'UTC' |NOT NULL |ZBX_NODATA UNIQUE |1 |name -TABLE|sla_time|sla_timeid|ZBX_DATA -FIELD |sla_timeid |t_id | |NOT NULL |0 +TABLE|sla_schedule|sla_scheduleid|ZBX_DATA +FIELD |sla_scheduleid |t_id | |NOT NULL |0 +FIELD |slaid |t_id | |NOT NULL |0 |1|sla|slaid +FIELD |from |t_integer |'0' |NOT NULL |0 +FIELD |to |t_integer |'0' |NOT NULL |0 +INDEX |1 |slaid + +TABLE|sla_downtime|sla_downtimeid|ZBX_DATA +FIELD |sla_downtimeid |t_id | |NOT NULL |0 FIELD |slaid |t_id | |NOT NULL |0 |1|sla|slaid -FIELD |type |t_integer |'0' |NOT NULL |0 FIELD |from |t_integer |'0' |NOT NULL |0 FIELD |to |t_integer |'0' |NOT NULL |0 FIELD |name |t_varchar(255) |'' |NOT NULL |0 @@ -1923,6 +1929,6 @@ TABLE|dbversion|dbversionid| FIELD |dbversionid |t_id | |NOT NULL |0 FIELD |mandatory |t_integer |'0' |NOT NULL | FIELD |optional |t_integer |'0' |NOT NULL | -ROW |1 |5050124 |5050124 +ROW |1 |5050127 |5050127 |