diff options
| author | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2013-01-25 20:59:09 -0600 |
|---|---|---|
| committer | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2013-01-25 20:59:09 -0600 |
| commit | be64ff0e7e45df0fcf594951d5297e1bee95339e (patch) | |
| tree | a4ba1f045e0a5686fd09f98d9b74f2404ad14dff /database | |
| parent | c8b59ecab5c226aaa059d5acaff6633b93ec51d9 (diff) | |
| download | ulab-be64ff0e7e45df0fcf594951d5297e1bee95339e.tar.gz ulab-be64ff0e7e45df0fcf594951d5297e1bee95339e.zip | |
Add known services to database file
Diffstat (limited to 'database')
| -rw-r--r-- | database/mysql/remotelab.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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`;
|