[Sommaire] [Imprimer]

   1  <?php
   2    /**************************************************************************\
   3    * eGroupWare                                                               *
   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    /* $Id: tables_baseline.inc.php 16306 2004-08-09 12:40:51Z reinerj $ */
  13  
  14      $phpgw_baseline = array(
  15          'config' => array(
  16              'fd' => array(
  17                  'config_name' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false),
  18                  'config_value' => array('type' => 'varchar', 'precision' => 100)
  19              ),
  20              'pk' => array(),
  21              'fk' => array(),
  22              'ix' => array(),
  23              'uc' => array('config_name')
  24          ),
  25          'applications' => array(
  26              'fd' => array(
  27                  'app_name' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false),
  28                  'app_title' => array('type' => 'varchar', 'precision' => 50),
  29                  'app_enabled' => array('type' => 'int', 'precision' => 4),
  30                  'app_order' => array('type' => 'int', 'precision' => 4),
  31                  'app_tables' => array('type' => 'varchar', 'precision' => 255),
  32                  'app_version' => array('type' => 'varchar', 'precision' => 20, 'nullable' => false, 'default' => '0.0')
  33              ),
  34              'pk' => array(),
  35              'fk' => array(),
  36              'ix' => array(),
  37              'uc' => array('app_name')
  38          ),
  39          'accounts' => array(
  40              'fd' => array(
  41                  'account_id' => array('type' => 'auto', 'nullable' => false),
  42                  'account_lid' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false),
  43                  'account_pwd' => array('type' => 'varchar', 'precision' => 32, 'nullable' => false),
  44                  'account_firstname' => array('type' => 'varchar', 'precision' => 50),
  45                  'account_lastname' => array('type' => 'varchar', 'precision' => 50),
  46                  'account_permissions' => array('type' => 'text'),
  47                  'account_groups' => array('type' => 'varchar', 'precision' => 30),
  48                  'account_lastlogin' => array('type' => 'int', 'precision' => 4),
  49                  'account_lastloginfrom' => array('type' => 'varchar', 'precision' => 255),
  50                  'account_lastpwd_change' => array('type' => 'int', 'precision' => 4),
  51                  'account_status' => array('type' => 'char', 'precision' => 1, 'nullable' => false, 'default' => 'A')
  52              ),
  53              'pk' => array('account_id'),
  54              'fk' => array(),
  55              'ix' => array(),
  56              'uc' => array('account_lid')
  57          ),
  58          'groups' => array(
  59              'fd' => array(
  60                  'group_id' => array('type' => 'auto', 'nullable' => false),
  61                  'group_name' => array('type' => 'varchar', 'precision' => 255),
  62                  'group_apps' => array('type' => 'varchar', 'precision' => 255)
  63              ),
  64              'pk' => array('group_id'),
  65              'fk' => array(),
  66              'ix' => array(),
  67              'uc' => array()
  68          ),
  69          'preferences' => array(
  70              'fd' => array(
  71                  'preference_owner' => array('type' => 'varchar', 'precision' => 20, 'nullable' => false),
  72                  'preference_name' => array('type' => 'varchar', 'precision' => 50, 'nullable' => false),
  73                  'preference_value' => array('type' => 'varchar', 'precision' => 50),
  74                  'preference_appname' => array('type' => 'varchar', 'precision' => 50)
  75              ),
  76              'pk' => array('preference_owner', 'preference_name'),
  77              'fk' => array(),
  78              'ix' => array(),
  79              'uc' => array()
  80          ),
  81          'sessions' => array(
  82              'fd' => array(
  83                  'session_id' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false),
  84                  'session_lid' => array('type' => 'varchar', 'precision' => 20),
  85                  'session_pwd' => array('type' => 'varchar', 'precision' => 255),
  86                  'session_ip' => array('type' => 'varchar', 'precision' => 255),
  87                  'session_logintime' => array('type' => 'varchar', 'precision' => 4),
  88                  'session_dla' => array('type' => 'varchar', 'precision' => 4)
  89              ),
  90              'pk' => array(),
  91              'fk' => array(),
  92              'ix' => array(),
  93              'uc' => array('session_id')
  94          ),
  95          'app_sessions' => array(
  96              'fd' => array(
  97                  'sessionid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false),
  98                  'loginid' => array('type' => 'varchar', 'precision' => 20),
  99                  'app' => array('type' => 'varchar', 'precision' => 20),
 100                  'content' => array('type' => 'text')
 101              ),
 102              'pk' => array(),
 103              'fk' => array(),
 104              'ix' => array(),
 105              'uc' => array()
 106          ),
 107          'access_log' => array(
 108              'fd' => array(
 109                  'sessionid' => array('type' => 'varchar', 'precision' => 30),
 110                  'loginid' => array('type' => 'varchar', 'precision' => 30),
 111                  'ip' => array('type' => 'varchar', 'precision' => 30),
 112                  'li' => array('type' => 'int', 'precision' => 4),
 113                  'lo' => array('type' => 'int', 'precision' => 4)
 114              ),
 115              'pk' => array(),
 116              'fk' => array(),
 117              'ix' => array(),
 118              'uc' => array()
 119          ),
 120          'profiles' => array(
 121              'fd' => array(
 122                  'con' => array('type' => 'auto', 'nullable' => false),
 123                  'owner' => array('type' => 'varchar', 'precision' => 20),
 124                  'title' => array('type' => 'varchar', 'precision' => 255),
 125                  'phone_number' => array('type' => 'varchar', 'precision' => 255),
 126                  'comments' => array('type' => 'text'),
 127                  'picture_format' => array('type' => 'varchar', 'precision' => 255),
 128                  'picture' => array('type' => 'blob')
 129              ),
 130              'pk' => array('con'),
 131              'fk' => array(),
 132              'ix' => array(),
 133              'uc' => array()
 134          ),
 135          'lang' => array(
 136              'fd' => array(
 137                  'message_id' => array('type' => 'varchar', 'precision' => 150, 'nullable' => false, 'default' => ''),
 138                  'app_name' => array('type' => 'varchar', 'precision' => 100, 'nullable' => false, 'default' => 'common'),
 139                  'lang' => array('type' => 'varchar', 'precision' => 5, 'nullable' => false, 'default' => ''),
 140                  'content' => array('type' => 'text')
 141              ),
 142              'pk' => array('message_id', 'app_name', 'lang'),
 143              'fk' => array(),
 144              'ix' => array(),
 145              'uc' => array()
 146          ),
 147          'addressbook' => array(
 148              'fd' => array(
 149                  'ab_id' => array('type' => 'auto', 'nullable' => false),
 150                  'ab_owner' => array('type' => 'varchar', 'precision' => 25),
 151                  'ab_access' => array('type' => 'varchar', 'precision' => 10),
 152                  'ab_firstname' => array('type' => 'varchar', 'precision' => 255),
 153                  'ab_lastname' => array('type' => 'varchar', 'precision' => 255),
 154                  'ab_email' => array('type' => 'varchar', 'precision' => 255),
 155                  'ab_hphone' => array('type' => 'varchar', 'precision' => 255),
 156                  'ab_wphone' => array('type' => 'varchar', 'precision' => 255),
 157                  'ab_fax' => array('type' => 'varchar', 'precision' => 255),
 158                  'ab_pager' => array('type' => 'varchar', 'precision' => 255),
 159                  'ab_mphone' => array('type' => 'varchar', 'precision' => 255),
 160                  'ab_ophone' => array('type' => 'varchar', 'precision' => 255),
 161                  'ab_street' => array('type' => 'varchar', 'precision' => 255),
 162                  'ab_city' => array('type' => 'varchar', 'precision' => 255),
 163                  'ab_state' => array('type' => 'varchar', 'precision' => 255),
 164                  'ab_zip' => array('type' => 'varchar', 'precision' => 255),
 165                  'ab_bday' => array('type' => 'varchar', 'precision' => 255),
 166                  'ab_notes' => array('type' => 'text'),
 167                  'ab_company' => array('type' => 'varchar', 'precision' => 255)
 168              ),
 169              'pk' => array('ab_id'),
 170              'fk' => array(),
 171              'ix' => array(),
 172              'uc' => array()
 173          )
 174      );
 175  ?>