mods/ldap/atutor.ldap.mod.struct.sql

   1 -- MySQL dump 10.10
   2 --
   3 -- Host: localhost    Database: atutor
   4 -- ------------------------------------------------------
   5 -- Server version       5.0.26
   6
   7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10 /*!40101 SET NAMES utf8 */;
  11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12 /*!40103 SET TIME_ZONE='+00:00' */;
  13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17
  18 --
  19 -- Table structure for table `AT_admin_log`
  20 --
  21
  22 --
  23 -- Table structure for table `AT_auth_cookie`
  24 --
  25
  26 DROP TABLE IF EXISTS `AT_auth_cookie`;
  27 CREATE TABLE `AT_auth_cookie` (
  28   `aid` int(11) NOT NULL auto_increment,
  29   `hash` varchar(255) NOT NULL,
  30   `ttl` int(11) NOT NULL,
  31   PRIMARY KEY  (`aid`)
  32 ) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;
  33
  34 --
  35 -- Table structure for table `AT_config_ldap`
  36 --
  37
  38 DROP TABLE IF EXISTS `AT_config_ldap`;
  39 CREATE TABLE `AT_config_ldap` (
  40   `name` varchar(30) NOT NULL,
  41   `value` varchar(255) NOT NULL
  42 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  43
  44 --
  45 -- Dump data for table `AT_config_ldap`
  46 --
  47
  48 LOCK TABLES `AT_config_ldap` WRITE;
  49 INSERT INTO `AT_config_ldap` VALUES ('ldap_name',''),('ldap_port','389'),('ldap_base_tree',''),('ldap_attr_login',''),('ldap_attr_password','__unused_ldap_field__'),('ldap_attr_mail',''),('ldap_attr_last_name',''),('ldap_attr_first_name',''),('ldap_attr_second_name',''),('ldap_attr_dob',''),('ldap_attr_gender',''),('ldap_attr_address',''),('ldap_attr_postal',''),('ldap_attr_city',''),('ldap_attr_province',''),('ldap_attr_country',''),('ldap_attr_phone',''),('ldap_attr_website','');
  50 UNLOCK TABLES;
  51
  52
  53
  54 --
  55 -- Table structure for table `AT_ldap_log`
  56 --
  57
  58 DROP TABLE IF EXISTS `AT_ldap_log`;
  59 CREATE TABLE `AT_ldap_log` (
  60   `member_id` mediumint(9) NOT NULL,
  61   `create_date` datetime NOT NULL
  62 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  63
  64
  65 --
  66 -- Dump data for table `AT_language_text`
  67 --
  68
  69 LOCK TABLES `AT_language_text` WRITE;
  70 /*!40000 ALTER TABLE `AT_language_text` DISABLE KEYS */;
  71 INSERT INTO `AT_language_text` VALUES
  72 ('en','_template','ldap_name','LDAP Server name','2007-04-27 00:00:00','atutor_ldap_mod'),
  73 ('en','_template','ldap_port','LDAP Server port','2007-04-27 00:00:00','atutor_ldap_mod'),
  74 ('en','_template','ldap_base_tree','LDAP Server tree <br/><small> Base of LDAP tree where stored users entries</small>','2007-04-27 00:00:00','atutor_ldap_mod'),
  75 ('en','_template','ldap_attr','LDAP Server fields <br/> <small> You must specify name of LDAP attributes which associated to ATutor members DB fields </small>','2007-04-27 00:00:00','atutor_ldap_mod'),
  76 ('en','_template','ldap_attr_address','Address','2007-04-27 00:00:00','atutor_ldap_mod'),
  77 ('en','_template','ldap_attr_city','City','2007-04-27 00:00:00','atutor_ldap_mod'),
  78 ('en','_template','ldap_attr_country','Country','2007-04-27 00:00:00','atutor_ldap_mod'),
  79 ('en','_template','ldap_attr_dob','DOB (Date Of Birth)','2007-04-27 00:00:00','atutor_ldap_mod'),
  80 ('en','_template','ldap_attr_first_name','Fisrt name','2007-04-27 00:00:00','atutor_ldap_mod'),
  81 ('en','_template','ldap_attr_gender','Gender','2007-04-27 00:00:00','atutor_ldap_mod'),
  82 ('en','_template','ldap_attr_last_name','Last name','2007-04-27 00:00:00','atutor_ldap_mod'),
  83 ('en','_template','ldap_attr_login','Login ','2007-04-27 00:00:00','atutor_ldap_mod'),
  84 ('en','_template','ldap_attr_mail','E-mail','2007-04-27 00:00:00','atutor_ldap_mod'),
  85 ('en','_template','ldap_attr_phone','Phone','2007-04-27 00:00:00','atutor_ldap_mod'),
  86 ('en','_template','ldap_attr_postal','Postal','2007-04-27 00:00:00','atutor_ldap_mod'),
  87 ('en','_template','ldap_attr_province','Province','2007-04-27 00:00:00','atutor_ldap_mod'),
  88 ('en','_template','ldap_attr_second_name','Second name','2007-04-27 00:00:00','atutor_ldap_mod'),
  89 ('en','_template','ldap_attr_website','Website','2007-04-27 00:00:00','atutor_ldap_mod'),
  90 ('en','_template','config_ldap','LDAP Authentication','2007-04-27 00:00:00','atutor_ldap_mod'),
  91 ('en','_template','ldap_auth_log','LDAP Auth Log','2007-04-27 00:00:00','atutor_ldap_mod');
  92 ('uk','_template','ldap_name','Імя LDAP-сервера','2007-04-27 00:00:00','atutor_ldap_mod'),
  93 ('uk','_template','ldap_port','Порт LDAP-сервера','2007-04-27 00:00:00','atutor_ldap_mod'),
  94 ('uk','_template','ldap_base_tree','Дерево LDAP-каталога<br/><small> Ви повинні вказати дерево LDAP-каталога, де зберігаються записи </small>','2007-04-27 00:00:00','atutor_ldap_mod'),
  95 ('uk','_template','ldap_attr','Атрибути LDAP-запису <br/> <small> Ви повинні вказати атрибути запису в LDAP-каталозі, що відповідають полям в таблиці members БД ATutor</small>','2007-04-27 00:00:00','atutor_ldap_mod'),
  96 ('uk','_template','ldap_attr_address','Адреса','2007-04-27 00:00:00','atutor_ldap_mod'),
  97 ('uk','_template','ldap_attr_city','Місто','2007-04-27 00:00:00','atutor_ldap_mod'),
  98 ('uk','_template','ldap_attr_country','Країна','2007-04-27 00:00:00','atutor_ldap_mod'),
  99 ('uk','_template','ldap_attr_dob','Дата народження','2007-04-27 00:00:00','atutor_ldap_mod'),
 100 ('uk','_template','ldap_attr_first_name','Імя','2007-04-27 00:00:00','atutor_ldap_mod'),
 101 ('uk','_template','ldap_attr_gender','Стать','2007-04-27 00:00:00','atutor_ldap_mod'),
 102 ('uk','_template','ldap_attr_last_name','Прізвище','2007-04-27 00:00:00','atutor_ldap_mod'),
 103 ('uk','_template','ldap_attr_login','Імя для входу','2007-04-27 00:00:00','atutor_ldap_mod'),
 104 ('uk','_template','ldap_attr_mail','Адреса електронної пошти','2007-04-27 00:00:00','atutor_ldap_mod'),
 105 ('uk','_template','ldap_attr_phone','Номер телефону','2007-04-27 00:00:00','atutor_ldap_mod'),
 106 ('uk','_template','ldap_attr_postal','Поштовий індекс','2007-04-27 00:00:00','atutor_ldap_mod'),
 107 ('uk','_template','ldap_attr_province','Область','2007-04-27 00:00:00','atutor_ldap_mod'),
 108 ('uk','_template','ldap_attr_second_name','По батькові','2007-04-27 00:00:00','atutor_ldap_mod'),
 109 ('uk','_template','ldap_attr_website','Сайт','2007-04-27 00:00:00','atutor_ldap_mod'),
 110 ('uk','_template','config_ldap','LDAP-Автентифікація','2007-04-27 00:00:00','atutor_ldap_mod'),
 111 ('uk','_template','ldap_auth_log','Лог LDAP-Автентифікації','2007-04-27 00:00:00','atutor_ldap_mod');
 112
 113 /*!40000 ALTER TABLE `AT_language_text` ENABLE KEYS */;
 114 UNLOCK TABLES;
 115