diff options
Diffstat (limited to 'database/mysql/remotelab.sql')
-rw-r--r-- | database/mysql/remotelab.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/database/mysql/remotelab.sql b/database/mysql/remotelab.sql index e93173d..9bafda7 100644 --- a/database/mysql/remotelab.sql +++ b/database/mysql/remotelab.sql @@ -103,6 +103,17 @@ CREATE TABLE `statistics` ( PRIMARY KEY (`pk`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+/*Table structure for table `status` */
+
+DROP TABLE IF EXISTS `status`;
+
+CREATE TABLE `status` (
+ `pk` bigint(20) NOT NULL AUTO_INCREMENT,
+ `hostname` text NOT NULL,
+ `online` tinyint(4) NOT NULL,
+ PRIMARY KEY (`pk`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|