[icinga-checkins] icinga.org: icinga-web/next: Oracle: add new unique index on nsm_user_preferences to oracle.sql #3870

git at icinga.org git at icinga.org
Mon Mar 18 14:26:26 CET 2013


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

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Sun Mar 17 21:13:59 2013 +0100

Oracle: add new unique index on nsm_user_preferences to oracle.sql #3870
Refs #3870 #3868

---

 etc/schema/oracle.sql |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/etc/schema/oracle.sql b/etc/schema/oracle.sql
index 34e5f45..32ccc49 100644
--- a/etc/schema/oracle.sql
+++ b/etc/schema/oracle.sql
@@ -20,7 +20,7 @@
 -- check for errors in create_icingaweb_objects.log
 --
 -- initial version: 2012-03-07 Thomas Dreßler
--- current version: 2012-05-10 Thomas Dreßler
+-- current version: 2013-03-17 Thomas Dreßler
 -- -- --------------------------------------------------------
 */
 set sqlprompt "&&_USER@&&_CONNECT_IDENTIFIER SQL>"
@@ -267,6 +267,8 @@ CREATE TABLE nsm_user_preference
   tablespace &DATATBS;
 alter table nsm_user_preference add constraint nsm_user_pref_pk PRIMARY KEY  (upref_id)
 	using index tablespace &IXTBS;
+alter table nsm_user_preference add constraint nsm_user_pref_userid_key_uq UNIQUE (upref_user_id, upref_key)
+  using index tablespace &IXTBS; 
   
   --use index organized table because all data is within index
 CREATE TABLE nsm_user_role





More information about the icinga-checkins mailing list