diff options
Diffstat (limited to 'create')
-rw-r--r-- | create/mysql/schema.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 9b82811b..989c50d6 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -5,8 +5,10 @@ CREATE TABLE services ( serviceid int(4) NOT NULL auto_increment, name varchar(128) DEFAULT '' NOT NULL, + status int(1) DEFAULT '0' NOT NULL, triggerid int(4), - PRIMARY KEY (serviceid) + PRIMARY KEY (serviceid), + KEY (triggerid) ); # @@ -18,7 +20,8 @@ CREATE TABLE services_links ( servicedownid int(4) DEFAULT '0' NOT NULL, soft int(1) DEFAULT '0' NOT NULL, KEY (serviceupid), - KEY (servicedownid) + KEY (servicedownid), + UNIQUE (serviceupid,servicedownid) ); # |