Added general framework for API-key authentication. From this point, the API requires...

[hermes] / doc / sql-data / structure.sql

diff --git a/doc/sql-data/structure.sql b/doc/sql-data/structure.sql
index e2ee817d5c5bf0a36bc731de284f1dbc69b4dcbe..d077eda7d5968b1ee8f98455c55c442b55c1ee29 100644 (file)
--- a/doc/sql-data/structure.sql
+++ b/doc/sql-data/structure.sql
@@ -1023,6 +1023,30 @@ CREATE DATABASE /*!32312 IF NOT EXISTS*/ `provision` /*!40100 DEFAULT CHARACTER
 
 USE `provision`;
 
+--
+-- Table structure for table `apikeys`
+--
+
+CREATE TABLE IF NOT EXISTS `apikeys` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `host` varchar(64) NOT NULL,
+  `apikey` varchar(128) NOT NULL,
+  PRIMARY KEY  (`apikey`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `authorizations`
+--
+
+CREATE TABLE IF NOT EXISTS `authorizations` (
+  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `authid` varchar(255) NOT NULL,
+  `access_level` int(11) NOT NULL,
+  PRIMARY KEY  (`authid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
 --
 -- Table structure for table `number_pool`
 --