diff options
Diffstat (limited to 'create/mysql/schema.sql')
| -rw-r--r-- | create/mysql/schema.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 59f20d16..02253238 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -1,4 +1,26 @@ # +# Table structure for table 'services' +# + +CREATE TABLE services ( + serviceid int(4) NOT NULL auto_increment, + name varchar(128) DEFAULT '' NOT NULL, + triggerid int(4), + PRIMARY KEY (serviceid) +); + +# +# Table structure for table 'services_links' +# + +CREATE TABLE services_links ( + serviceupid int(4) DEFAULT '0' NOT NULL, + servicedownid int(4) DEFAULT '0' NOT NULL, + KEY (serviceupid), + KEY (servicedownid) +); + +# # Table structure for table 'graphs_items' # |
