[icinga-checkins] icinga.org: icingaweb2/feature/localization-form-6073: Add new `section` column to icingaweb_user_preference table

git at icinga.org git at icinga.org
Wed Nov 12 13:37:16 CET 2014


Module: icingaweb2
Branch: feature/localization-form-6073
Commit: 7b2318e73947690ca4917fe835937313e74c70a0
URL:    https://git.icinga.org/?p=icingaweb2.git;a=commit;h=7b2318e73947690ca4917fe835937313e74c70a0

Author: Alexander Fuhr <alexander.fuhr at netways.de>
Date:   Wed Nov 12 10:49:46 2014 +0100

Add new `section` column to icingaweb_user_preference table

---

 etc/schema/mysql.schema.sql |    3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/etc/schema/mysql.schema.sql b/etc/schema/mysql.schema.sql
index 7867796..74d2665 100644
--- a/etc/schema/mysql.schema.sql
+++ b/etc/schema/mysql.schema.sql
@@ -27,9 +27,10 @@ CREATE TABLE `icingaweb_user`(
 
 CREATE TABLE `icingaweb_user_preference`(
   `username` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+  `section`  varchar(64) COLLATE utf8_unicode_ci NOT NULL,
   `name`     varchar(64) COLLATE utf8_unicode_ci NOT NULL,
   `value`    varchar(255) NOT NULL,
   `ctime`    timestamp NULL DEFAULT NULL,
   `mtime`    timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
-  PRIMARY KEY (`username`,`name`)
+  PRIMARY KEY (`username`,`section`,`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



More information about the icinga-checkins mailing list