diff options
author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-06-20 08:42:25 +0000 |
---|---|---|
committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-06-20 08:42:25 +0000 |
commit | 3f8cf5f0da75fa8312c173e9e2c1e1e843811091 (patch) | |
tree | 1cb9f4841cb20bc2fd65a696181e70cbdf2cfb88 /create/schema | |
parent | 2804bdc7c298f114802a93d7c3312370c8602ba0 (diff) | |
download | zabbix-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.sql | 14 |
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 |