diff options
Diffstat (limited to 'create')
| -rw-r--r-- | create/schema/schema.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 4b96b753..9877974a 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -21,6 +21,17 @@ -- Do not use spaces -- +TABLE|slideshows|slideshowid|ZBX_SYNC +FIELD |slideshowid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |name |t_varchar(255) |'' |NOT NULL |ZBX_SYNC +FIELD |delay |t_integer |'0' |NOT NULL |ZBX_SYNC + +TABLE|slides|slideid|ZBX_SYNC +FIELD |slideid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |slideshowid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |delay |t_integer |'0' |NOT NULL |ZBX_SYNC +INDEX |slides_1 |slideshowid + TABLE|drules|druleid|ZBX_SYNC FIELD |druleid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |name |t_varchar(255) |'' |NOT NULL |ZBX_SYNC |