r2666 - introduced LDAPCache table (ticket:193)
[racktables] / install / init-structure.sql
index 4c776c9da636f2a61871132afed5f8d7dde1ef8a..410d473264fa77925ddeda8b8feb35c45b2cb2f7 100644 (file)
@@ -147,6 +147,17 @@ CREATE TABLE `IPv4VS` (
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM;
 
+CREATE TABLE `LDAPCache` (
+  `presented_username` char(64) NOT NULL,
+  `successful_hash` char(40) NOT NULL,
+  `first_success` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `last_retry` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `displayed_name` char(128) default NULL,
+  `memberof` text,
+  UNIQUE KEY `presented_username` (`presented_username`),
+  KEY `scanidx` (`presented_username`,`successful_hash`)
+) ENGINE=InnoDB;
+
 CREATE TABLE `Link` (
   `porta` int(10) unsigned NOT NULL,
   `portb` int(10) unsigned NOT NULL,