[Sommaire] [Imprimer]

   1  <?php
   2      /**************************************************************************\
   3      * eGroupWare SiteMgr - Web Content Management                              *
   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_current.inc.php 20295 2006-02-15 12:31:25Z  $ */
  13  
  14      $phpgw_baseline = array(
  15          'egw_sitemgr_pages' => array(
  16              'fd' => array(
  17                  'page_id' => array('type' => 'auto','nullable' => False),
  18                  'cat_id' => array('type' => 'int','precision' => '4'),
  19                  'sort_order' => array('type' => 'int','precision' => '4'),
  20                  'hide_page' => array('type' => 'int','precision' => '4'),
  21                  'name' => array('type' => 'varchar','precision' => '100'),
  22                  'state' => array('type' => 'int','precision' => '2')
  23              ),
  24              'pk' => array('page_id'),
  25              'fk' => array(),
  26              'ix' => array('cat_id',array('state','cat_id','sort_order'),array('name','cat_id')),
  27              'uc' => array()
  28          ),
  29          'egw_sitemgr_pages_lang' => array(
  30              'fd' => array(
  31                  'page_id' => array('type' => 'int','precision' => '4','nullable' => False),
  32                  'lang' => array('type' => 'varchar','precision' => '5','nullable' => False),
  33                  'title' => array('type' => 'varchar','precision' => '255'),
  34                  'subtitle' => array('type' => 'varchar','precision' => '255')
  35              ),
  36              'pk' => array('page_id','lang'),
  37              'fk' => array(),
  38              'ix' => array(),
  39              'uc' => array()
  40          ),
  41          'egw_sitemgr_categories_state' => array(
  42              'fd' => array(
  43                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False),
  44                  'state' => array('type' => 'int','precision' => '2'),
  45                  'index_page_id' => array('type' => 'int','precision' => '4','default' => '0')
  46              ),
  47              'pk' => array('cat_id'),
  48              'fk' => array(),
  49              'ix' => array(array('cat_id','state')),
  50              'uc' => array()
  51          ),
  52          'egw_sitemgr_categories_lang' => array(
  53              'fd' => array(
  54                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False),
  55                  'lang' => array('type' => 'varchar','precision' => '5','nullable' => False),
  56                  'name' => array('type' => 'varchar','precision' => '100'),
  57                  'description' => array('type' => 'varchar','precision' => '255')
  58              ),
  59              'pk' => array('cat_id','lang'),
  60              'fk' => array(),
  61              'ix' => array(),
  62              'uc' => array()
  63          ),
  64          'egw_sitemgr_modules' => array(
  65              'fd' => array(
  66                  'module_id' => array('type' => 'auto','precision' => '4','nullable' => False),
  67                  'module_name' => array('type' => 'varchar','precision' => '25'),
  68                  'description' => array('type' => 'varchar','precision' => '255')
  69              ),
  70              'pk' => array('module_id'),
  71              'fk' => array(),
  72              'ix' => array(),
  73              'uc' => array()
  74          ),
  75          'egw_sitemgr_blocks' => array(
  76              'fd' => array(
  77                  'block_id' => array('type' => 'auto','nullable' => False),
  78                  'area' => array('type' => 'varchar','precision' => '50'),
  79                  'cat_id' => array('type' => 'int','precision' => '4'),
  80                  'page_id' => array('type' => 'int','precision' => '4'),
  81                  'module_id' => array('type' => 'int','precision' => '4','nullable' => False),
  82                  'sort_order' => array('type' => 'int','precision' => '4'),
  83                  'viewable' => array('type' => 'int','precision' => '4')
  84              ),
  85              'pk' => array('block_id'),
  86              'fk' => array(),
  87              'ix' => array(),
  88              'uc' => array()
  89          ),
  90          'egw_sitemgr_blocks_lang' => array(
  91              'fd' => array(
  92                  'block_id' => array('type' => 'int','precision' => '4','nullable' => False),
  93                  'lang' => array('type' => 'varchar','precision' => '5','nullable' => False),
  94                  'title' => array('type' => 'varchar','precision' => '255')
  95              ),
  96              'pk' => array('block_id','lang'),
  97              'fk' => array(),
  98              'ix' => array(),
  99              'uc' => array()
 100          ),
 101          'egw_sitemgr_content' => array(
 102              'fd' => array(
 103                  'version_id' => array('type' => 'auto','nullable' => False),
 104                  'block_id' => array('type' => 'int','precision' => '4','nullable' => False),
 105                  'arguments' => array('type' => 'text'),
 106                  'state' => array('type' => 'int','precision' => '2')
 107              ),
 108              'pk' => array('version_id'),
 109              'fk' => array(),
 110              'ix' => array(),
 111              'uc' => array()
 112          ),
 113          'egw_sitemgr_content_lang' => array(
 114              'fd' => array(
 115                  'version_id' => array('type' => 'int','precision' => '4','nullable' => False),
 116                  'lang' => array('type' => 'varchar','precision' => '5','nullable' => False),
 117                  'arguments_lang' => array('type' => 'text')
 118              ),
 119              'pk' => array('version_id','lang'),
 120              'fk' => array(),
 121              'ix' => array(),
 122              'uc' => array()
 123          ),
 124          'egw_sitemgr_active_modules' => array(
 125              'fd' => array(
 126                  'area' => array('type' => 'varchar','precision' => '50','nullable' => False),
 127                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False),
 128                  'module_id' => array('type' => 'int','precision' => '4','nullable' => False)
 129              ),
 130              'pk' => array('area','cat_id','module_id'),
 131              'fk' => array(),
 132              'ix' => array(),
 133              'uc' => array()
 134          ),
 135          'egw_sitemgr_properties' => array(
 136              'fd' => array(
 137                  'area' => array('type' => 'varchar','precision' => '50','nullable' => False),
 138                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False),
 139                  'module_id' => array('type' => 'int','precision' => '4','nullable' => False),
 140                  'properties' => array('type' => 'text')
 141              ),
 142              'pk' => array('area','cat_id','module_id'),
 143              'fk' => array(),
 144              'ix' => array(),
 145              'uc' => array()
 146          ),
 147          'egw_sitemgr_sites' => array(
 148              'fd' => array(
 149                  'site_id' => array('type' => 'int','precision' => '4','nullable' => False),
 150                  'site_name' => array('type' => 'varchar','precision' => '255'),
 151                  'site_url' => array('type' => 'varchar','precision' => '255'),
 152                  'site_dir' => array('type' => 'varchar','precision' => '255'),
 153                  'themesel' => array('type' => 'varchar','precision' => '50'),
 154                  'site_languages' => array('type' => 'varchar','precision' => '50'),
 155                  'home_page_id' => array('type' => 'int','precision' => '4'),
 156                  'anonymous_user' => array('type' => 'varchar','precision' => '50'),
 157                  'anonymous_passwd' => array('type' => 'varchar','precision' => '50'),
 158                  'upload_dir' => array('type' => 'varchar','precision' => '255'),
 159                  'upload_url' => array('type' => 'varchar','precision' => '255')
 160              ),
 161              'pk' => array('site_id'),
 162              'fk' => array(),
 163              'ix' => array('site_url'),
 164              'uc' => array()
 165          ),
 166          'egw_sitemgr_notifications' => array(
 167              'fd' => array(
 168                  'notification_id' => array('type' => 'auto','nullable' => False),
 169                  'site_id' => array('type' => 'int','precision' => '4','nullable' => False),
 170                  'site_language' => array('type' => 'varchar','precision' => '3','nullable' => False,'default' => 'all'),
 171                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 172                  'email' => array('type' => 'varchar','precision' => '255','nullable' => False)
 173              ),
 174              'pk' => array('notification_id'),
 175              'fk' => array('site_id' => 'egw_sitemgr_sites'),
 176              'ix' => array('email'),
 177              'uc' => array()
 178          ),
 179          'egw_sitemgr_notify_messages' => array(
 180              'fd' => array(
 181                  'message_id' => array('type' => 'auto','nullable' => False),
 182                  'site_id' => array('type' => 'int','precision' => '4','nullable' => False),
 183                  'language' => array('type' => 'varchar','precision' => '3'),
 184                  'message' => array('type' => 'text','nullable' => False),
 185                  'subject' => array('type' => 'text','nullable' => False)
 186              ),
 187              'pk' => array('message_id'),
 188              'fk' => array('site_id' => 'egw_sitemgr_sites'),
 189              'ix' => array(),
 190              'uc' => array(array('site_id','language'))
 191          )
 192      );