From be64ff0e7e45df0fcf594951d5297e1bee95339e Mon Sep 17 00:00:00 2001 From: Timothy Pearson Date: Fri, 25 Jan 2013 20:59:09 -0600 Subject: Add known services to database file --- database/mysql/remotelab.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'database') diff --git a/database/mysql/remotelab.sql b/database/mysql/remotelab.sql index 107a6d2..b310810 100644 --- a/database/mysql/remotelab.sql +++ b/database/mysql/remotelab.sql @@ -73,6 +73,10 @@ CREATE TABLE `servicetypes` ( PRIMARY KEY (`serviceid`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; +/*Data for the table `servicetypes` */ + +insert into `servicetypes`(`serviceid`,`name`,`description`,`client_library`,`version`,`single_instance`) values (1,'Remote FPGA','Remote FPGA access','libremotelab_fpgaviewer',1,1),(2,'Spectrum Analyzer','GPIB spectrum analyzer access','libremotelab_commanalyzer',1,1),(3,'FPGA Programmer','Remote FPGA programming','libremotelab_fpgaprogrammer',1,1),(4,'Oscilloscope','GPIB oscilloscope access','libremotelab_scope',1,1),(5,'Sensor Monitor','Sensor monitor access','libremotelab_sensormonitor',1,1),(6,'Administration Console','View and control active sessions','libremotelab_adminconsole',1,1),(7,'User Management Console','Manage user permissions','libremotelab_adminusermgmt',1,1); + /*Table structure for table `stations` */ DROP TABLE IF EXISTS `stations`; -- cgit v1.2.1