summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorTimothy Pearson <kb9vqf@pearsoncomputing.net>2013-01-24 12:05:29 -0600
committerTimothy Pearson <kb9vqf@pearsoncomputing.net>2013-01-24 12:05:29 -0600
commit61dfcc04f73e45082f51945a7b98b7838da56da8 (patch)
tree31ba95662c5972ef74abc64e4404e7e20e2f498e /database
parent941d8c3b969eae32b0945987f1d849930736f5bb (diff)
downloadulab-61dfcc04f73e45082f51945a7b98b7838da56da8.tar.gz
ulab-61dfcc04f73e45082f51945a7b98b7838da56da8.zip
User management console now functional
Diffstat (limited to 'database')
-rw-r--r--database/mysql/remotelab.sql7
1 files changed, 4 insertions, 3 deletions
diff --git a/database/mysql/remotelab.sql b/database/mysql/remotelab.sql
index ce3e8fe..107a6d2 100644
--- a/database/mysql/remotelab.sql
+++ b/database/mysql/remotelab.sql
@@ -2,7 +2,8 @@
SQLyog Community Edition- MySQL GUI v8.2
MySQL - 5.5.22-0ubuntu1 : Database - remotelab
*********************************************************************
-*/
+*/
+
/*!40101 SET NAMES utf8 */;
@@ -39,8 +40,8 @@ DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
`pk` bigint(20) NOT NULL AUTO_INCREMENT,
`station` bigint(20) NOT NULL,
- `username` text NOT NULL,
- `userrealm` text,
+ `groupname` text NOT NULL,
+ `realm` text,
`restrictions` text,
PRIMARY KEY (`pk`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;