summaryrefslogtreecommitdiffstats
path: root/create/schema
diff options
context:
space:
mode:
authorartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-06-20 08:42:25 +0000
committerartem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2008-06-20 08:42:25 +0000
commit3f8cf5f0da75fa8312c173e9e2c1e1e843811091 (patch)
tree1cb9f4841cb20bc2fd65a696181e70cbdf2cfb88 /create/schema
parent2804bdc7c298f114802a93d7c3312370c8602ba0 (diff)
downloadzabbix-3f8cf5f0da75fa8312c173e9e2c1e1e843811091.tar.gz
zabbix-3f8cf5f0da75fa8312c173e9e2c1e1e843811091.tar.xz
zabbix-3f8cf5f0da75fa8312c173e9e2c1e1e843811091.zip
- [DEV-137] changes in users profile system (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5782 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema')
-rw-r--r--create/schema/schema.sql14
1 files changed, 8 insertions, 6 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index 8b9c4fef..7c2629f8 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -582,12 +582,14 @@ FIELD |passwd |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
TABLE|profiles|profileid|ZBX_SYNC
FIELD |profileid |t_id |'0' |NOT NULL |0
FIELD |userid |t_id |'0' |NOT NULL |ZBX_SYNC
-FIELD |idx |t_varchar(64) |'' |NOT NULL |ZBX_SYNC
-FIELD |value |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
-FIELD |value2 |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
-FIELD |source |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
-FIELD |valuetype |t_integer |0 |NOT NULL |ZBX_SYNC
-INDEX |1 |idx
+FIELD |idx |t_varchar(96) |'' |NOT NULL |ZBX_SYNC
+FIELD |idx2 |t_id |'0' |NOT NULL |ZBX_SYNC
+FIELD |value_id |t_id |'0' |NOT NULL |ZBX_SYNC
+FIELD |value_int |t_integer |'0' |NOT NULL |ZBX_SYNC
+FIELD |value_str |t_varchar(255) |'' |NOT NULL |ZBX_SYNC
+FIELD |source |t_varchar(96) |'' |NOT NULL |ZBX_SYNC
+FIELD |type |t_integer |'0' |NOT NULL |ZBX_SYNC
+INDEX |1 |userid,idx,idx2
TABLE|rights|rightid|ZBX_SYNC
FIELD |rightid |t_id |'0' |NOT NULL |0