[Sommaire] [Imprimer]

   1  <?php
   2    /**************************************************************************\
   3    * eGroupWare - Setup                                                       *
   4    * http://www.egroupware.org                                                *
   5    * --------------------------------------------                             *
   6    *  This program is free software; you can redistribute it and/or modify it *
   7    *  under the terms of the GNU General Public License as published by the   *
   8    *  Free Software Foundation; either version 2 of the License, or (at your  *
   9    *  option) any later version.                                              *
  10    \**************************************************************************/
  11  
  12      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('bday','Birthday','birthday','','Y',1)");
  13      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('email','E-Mail','email','','Y',2)");
  14      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('n_given','First Name','first_name','','Y',3)");
  15      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('n_family','Last Name','last_name','','Y',4)");
  16      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('adr_one_street','Address','address','','Y',5)");
  17      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('adr_one_locality','City','city','','Y',6)");
  18      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('adr_one_region','State','state','','Y',7)");
  19      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('adr_one_postalcode','ZIP/Postal','zip','','Y',8)");
  20      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('adr_one_countryname','Country','country','','Y',9)");
  21      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('tel_work','Phone','phone','','N',10)");
  22      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('gender','Gender','gender','','N',11)");
  23      
  24      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('challenge_question_1','Challenge1','challenge1','','N',100)");
  25      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('challenge_question_2','Challenge2','challenge2','','N',100)");
  26      $oProc->query ("INSERT INTO egw_reg_fields (field_name, field_text, field_type, field_values, field_required, field_order) VALUES ('challenge_question_3','Challenge3','challenge3','','N',100)");
  27  
  28      $oProc->query ("DELETE FROM {$GLOBALS['egw_setup']->config_table} WHERE config_app='registration'");
  29      $oProc->query ("INSERT INTO {$GLOBALS['egw_setup']->config_table} (config_app, config_name, config_value) VALUES ('registration','display_tos','True')");
  30      $oProc->query ("INSERT INTO {$GLOBALS['egw_setup']->config_table} (config_app, config_name, config_value) VALUES ('registration','activate_account','email')");
  31      $oProc->query ("INSERT INTO {$GLOBALS['egw_setup']->config_table} (config_app, config_name, config_value) VALUES ('registration','username_is','choice')");
  32      $oProc->query ("INSERT INTO {$GLOBALS['egw_setup']->config_table} (config_app, config_name, config_value) VALUES ('registration','password_is','choice')");
  33      $oProc->query ("INSERT INTO {$GLOBALS['egw_setup']->config_table} (config_app, config_name, config_value) VALUES ('registration','use_challenge','True')");
  34      $oProc->query ("ALTER TABLE {$GLOBALS['egw_setup']->accounts_table} ADD COLUMN account_challenge varchar(100)") ;
  35      $oProc->query ("ALTER TABLE {$GLOBALS['egw_setup']->accounts_table} ADD COLUMN account_response varchar(100)") ;
  36  ?>