diff options
| author | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-23 07:34:27 +0000 |
|---|---|---|
| committer | osmiy <osmiy@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-10-23 07:34:27 +0000 |
| commit | 28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89 (patch) | |
| tree | 8281ccd48964ee0dd11c5ea689091fa3cef706fb /create/schema/schema.sql | |
| parent | 495799b2aa61aab23d74d7faa110a0cd09d59bf0 (diff) | |
| download | zabbix-28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89.tar.gz zabbix-28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89.tar.xz zabbix-28a09ed13e41ddbe5e30d63e92a1f5fb3395ef89.zip | |
- developed group permission system (Eugene)
git-svn-id: svn://svn.zabbix.com/trunk@3371 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/schema.sql')
| -rw-r--r-- | create/schema/schema.sql | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/create/schema/schema.sql b/create/schema/schema.sql index 49abce50..050ddace 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -147,8 +147,8 @@ CREATE TABLE sysmaps_elements ( sysmapid {bigint} DEFAULT '0' NOT NULL, elementid {bigint} DEFAULT '0' NOT NULL, elementtype {integer} DEFAULT '0' NOT NULL, - icon {varchar}(32) DEFAULT 'Server' NOT NULL, - icon_on {varchar}(32) DEFAULT 'Server' NOT NULL, + iconid_off {bigint} DEFAULT '0' NOT NULL, + iconid_on {bigint} DEFAULT '0' NOT NULL, label {varchar}(128) DEFAULT '' NOT NULL, label_location {integer} DEFAULT NULL, x {integer} DEFAULT '0' NOT NULL, @@ -162,7 +162,7 @@ CREATE TABLE sysmaps ( name {varchar}(128) DEFAULT '' NOT NULL, width {integer} DEFAULT '0' NOT NULL, height {integer} DEFAULT '0' NOT NULL, - background {varchar}(64) DEFAULT '' NOT NULL, + backgroundid {bigint} DEFAULT '0' NOT NULL, label_type {integer} DEFAULT '0' NOT NULL, label_location {integer} DEFAULT '0' NOT NULL, PRIMARY KEY (sysmapid) @@ -285,7 +285,7 @@ CREATE INDEX history_1 ON history (itemid, clock); CREATE TABLE history_sync ( id {serial}, - nodeid {integer} DEFAULT '0' NOT NULL, + nodeid {bigint} DEFAULT '0' NOT NULL, itemid {bigint} DEFAULT '0' NOT NULL, clock {integer} DEFAULT '0' NOT NULL, value {double}(16,4) DEFAULT '0.0000' NOT NULL, @@ -383,7 +383,7 @@ CREATE TABLE items ( lastlogsize {integer} DEFAULT '0' NOT NULL, logtimefmt {varchar}(64) DEFAULT '' NOT NULL, - templateid {integer} DEFAULT '0' NOT NULL, + templateid {bigint} DEFAULT '0' NOT NULL, valuemapid {bigint} DEFAULT '0' NOT NULL, delay_flex {varchar}(255) DEFAULT '' NOT NULL, @@ -459,6 +459,7 @@ CREATE TABLE users ( autologout {integer} DEFAULT '900' NOT NULL, lang {varchar}(5) DEFAULT 'en_gb' NOT NULL, refresh {integer} DEFAULT '30' NOT NULL, + type {integer} DEFAULT '0' NOT NULL, PRIMARY KEY (userid) ) {create_table_opt}; @@ -486,14 +487,14 @@ CREATE TABLE sessions ( CREATE TABLE rights ( rightid {bigint} DEFAULT '0' NOT NULL, - userid {bigint} DEFAULT '0' NOT NULL, - name {char}(255) DEFAULT '' NOT NULL, - permission {char}(1) DEFAULT '' NOT NULL, + groupid {bigint} DEFAULT '0' NOT NULL, + type {integer} DEFAULT '0' NOT NULL, + permission {integer} DEFAULT '0' NOT NULL, id {bigint}, PRIMARY KEY (rightid) ) {create_table_opt}; -CREATE INDEX rights_1 ON rights (userid); +CREATE INDEX rights_1 ON rights (groupid); CREATE TABLE service_alarms ( servicealarmid {bigint} DEFAULT '0' NOT NULL, |