From 128d497c25bf40e1fd136a7e980125e01cc2beed Mon Sep 17 00:00:00 2001 From: Timothy Pearson Date: Fri, 15 Mar 2013 02:10:40 -0500 Subject: Add method to mark ulab servers as online or offline --- database/mysql/remotelab.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'database') 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 */; -- cgit v1.2.3