openstack
/
openstack-ansible-os_monasca
Code Issues Proposed changes

Update monasca mysql schema 

Recent changes added two new columns to the monasca-api database.
This change updates the database creation script accordingly.

Change-Id: I877a0b285dd796847119572d31d2931882bf51eb
This commit is contained in:
Flávio Ramalho 2018-01-24 12:13:28 +01:00
parent 2451c632e8
commit ae31159705
1 changed files with 2 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

2
templates/mon_mysql.sql.j2
View File

@ -47,6 +47,8 @@ CREATE TABLE `alarm` (
`state` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`lifecycle_state` varchar(50) DEFAULT NULL,
`link` varchar(512) DEFAULT NULL,
`inhibited` tinyint(1) NOT NULL DEFAULT '0',
`silenced` tinyint(1) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`state_updated_at` datetime,
`updated_at` datetime NOT NULL,