diff options
| author | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2013-03-15 02:10:40 -0500 |
|---|---|---|
| committer | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2013-03-15 02:10:40 -0500 |
| commit | 128d497c25bf40e1fd136a7e980125e01cc2beed (patch) | |
| tree | 04e42b5ffab65fd2ff98812c46e507fcf8312667 /database/mysql/remotelab.sql | |
| parent | 400d0abcff5986c764f4a25bec29c2af57286ee1 (diff) | |
| download | ulab-128d497c25bf40e1fd136a7e980125e01cc2beed.tar.gz ulab-128d497c25bf40e1fd136a7e980125e01cc2beed.zip | |
Add method to mark ulab servers as online or offline
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 */;
|