Added support for user-based authentication, resulting changes: Implemented auth...

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

diff --git a/doc/sql-data/structure.sql b/doc/sql-data/structure.sql
index d077eda7d5968b1ee8f98455c55c442b55c1ee29..b4555a12c2f500610d9cc19d1229d0ff4d9c4b18 100644 (file)
--- a/doc/sql-data/structure.sql
+++ b/doc/sql-data/structure.sql
@@ -1040,12 +1040,17 @@ CREATE TABLE IF NOT EXISTS `apikeys` (
 -- Table structure for table `authorizations`
 --
 
+DROP TABLE IF EXISTS `authorizations`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
 CREATE TABLE IF NOT EXISTS `authorizations` (
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   `authid` varchar(255) NOT NULL,
+  `type` varchar(16) NOT NULL,
   `access_level` int(11) NOT NULL,
   PRIMARY KEY  (`authid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
 
 --
 -- Table structure for table `number_pool`