summaryrefslogtreecommitdiffstats
path: root/create/mysql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create/mysql/schema.sql')
-rw-r--r--create/mysql/schema.sql22
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'
#