[icinga-checkins] icinga.org: icinga-web/r1.8: Update initial schemas for MySQL and PgSQL ( refs #3868)

git at icinga.org git at icinga.org
Mon Mar 25 15:54:56 CET 2013


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

Author: Markus Frosch <markus at lazyfrosch.de>
Date:   Mon Mar 25 15:15:16 2013 +0100

Update initial schemas for MySQL and PgSQL (refs #3868)

---

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

diff --git a/etc/schema/mysql.sql b/etc/schema/mysql.sql
index 8076414..c4ddb8d 100644
--- a/etc/schema/mysql.sql
+++ b/etc/schema/mysql.sql
@@ -42,7 +42,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_db_version VALUES ('1','icinga-web/v1.8.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');
 INSERT INTO nsm_target (target_id,target_name,target_description,target_class,target_type) VALUES ('3','IcingaHostCustomVariablePair','Limit data access to specific custom variables','IcingaDataHostCustomVariablePrincipalTarget','icinga');
diff --git a/etc/schema/pgsql.sql b/etc/schema/pgsql.sql
index 4f5cc4b..9242d41 100644
--- a/etc/schema/pgsql.sql
+++ b/etc/schema/pgsql.sql
@@ -653,7 +653,7 @@ COPY cronk_principal_cronk (cpc_principal_id, cpc_cronk_id) FROM stdin;
 --
 
 COPY nsm_db_version (id, version, modified, created) FROM stdin;
-1	icinga-web/v1.8.0	2012-10-11 11:13:07	2012-10-11 11:13:07
+1	icinga-web/v1.8.3	2013-03-25 00:00:00	2013-03-23 00:00:00
 \.
 
 
@@ -974,7 +974,7 @@ CREATE INDEX upref_search_key_idx ON nsm_user_preference USING btree (upref_key)
 -- Name: upref_user_key_unique_idx; Type: INDEX; Schema: public; Owner: icinga_web; Tablespace: 
 --
 
-CREATE INDEX upref_user_key_unique_idx ON nsm_user_preference USING btree (upref_user_id, upref_key);
+CREATE UNIQUE INDEX upref_user_key_unique_idx ON nsm_user_preference USING btree (upref_user_id, upref_key);
 
 
 --





More information about the icinga-checkins mailing list