[icinga-checkins] icinga.org: icinga-web/next: user_created doesn' t have a default value | MySQL-server v5.6

git at icinga.org git at icinga.org
Thu Apr 11 17:38:08 CEST 2013


Module: icinga-web
Branch: next
Commit: debf72380da873429d63456a4795e93e0dfc1192
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=debf72380da873429d63456a4795e93e0dfc1192

Author: Marius Hein <marius.hein at netways.de>
Date:   Thu Apr 11 17:35:52 2013 +0200

user_created doesn't have a default value | MySQL-server v5.6

Add NOW() to mysql schema.

fixes #3698

---

 etc/schema/mysql.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/etc/schema/mysql.sql b/etc/schema/mysql.sql
index 221d673..6b7a2c4 100644
--- a/etc/schema/mysql.sql
+++ b/etc/schema/mysql.sql
@@ -41,7 +41,7 @@ ALTER TABLE nsm_user_role ADD CONSTRAINT nsm_user_role_usro_role_id_nsm_role_rol
 
 /*          Initial data import              */
  
-INSERT INTO nsm_user (user_id,user_account,user_name,user_firstname,user_lastname,user_password,user_salt,user_authsrc,user_email,user_disabled) VALUES ('1','0','root','Enoch','Root','42bc5093863dce8c150387a5bb7e3061cf3ea67d2cf1779671e1b0f435e953a1','0c099ae4627b144f3a7eaa763ba43b10fd5d1caa8738a98f11bb973bebc52ccd','internal','root at localhost.local','0');
+INSERT INTO nsm_user (user_id,user_account,user_name,user_firstname,user_lastname,user_password,user_salt,user_authsrc,user_email,user_disabled,user_modified,user_created) VALUES ('1','0','root','Enoch','Root','42bc5093863dce8c150387a5bb7e3061cf3ea67d2cf1779671e1b0f435e953a1','0c099ae4627b144f3a7eaa763ba43b10fd5d1caa8738a98f11bb973bebc52ccd','internal','root at localhost.local','0', NOW(), NOW());
 INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.8.3', NOW(), NOW());
 INSERT INTO nsm_target (target_id,target_name,target_description,target_class,target_type) VALUES ('1','IcingaHostgroup','Limit data access to specific hostgroups','IcingaDataHostgroupPrincipalTarget','icinga');
 INSERT INTO nsm_target (target_id,target_name,target_description,target_class,target_type) VALUES ('2','IcingaServicegroup','Limit data access to specific servicegroups','IcingaDataServicegroupPrincipalTarget','icinga');





More information about the icinga-checkins mailing list