[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    /* $Id: tables_current.inc.php 20295 2006-02-15 12:31:25Z  $ */
  13  
  14  
  15      $phpgw_baseline = array(
  16          'egw_wiki_links' => array(
  17              'fd' => array(
  18                  'wiki_id' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'),
  19                  'wiki_name' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  20                  'wiki_lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''),
  21                  'wiki_link' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  22                  'wiki_count' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
  23              ),
  24              'pk' => array('wiki_id','wiki_name','wiki_lang','wiki_link'),
  25              'fk' => array(),
  26              'ix' => array(),
  27              'uc' => array()
  28          ),
  29          'egw_wiki_pages' => array(
  30              'fd' => array(
  31                  'wiki_id' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'),
  32                  'wiki_name' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  33                  'wiki_lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''),
  34                  'wiki_version' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '1'),
  35                  'wiki_time' => array('type' => 'int','precision' => '4'),
  36                  'wiki_supercede' => array('type' => 'int','precision' => '4'),
  37                  'wiki_readable' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  38                  'wiki_writable' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  39                  'wiki_username' => array('type' => 'varchar','precision' => '80'),
  40                  'wiki_hostname' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  41                  'wiki_comment' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  42                  'wiki_title' => array('type' => 'varchar','precision' => '80'),
  43                  'wiki_body' => array('type' => 'text')
  44              ),
  45              'pk' => array('wiki_id','wiki_name','wiki_lang','wiki_version'),
  46              'fk' => array(),
  47              'ix' => array('wiki_title',array('wiki_body','options' => array(
  48                  'mysql' => 'FULLTEXT',
  49                  'mssql' => False,
  50                  'pgsql' => False,
  51                  'maxdb' => False,
  52                  'sapdb' => False))),
  53              'uc' => array()
  54          ),
  55          'egw_wiki_rate' => array(
  56              'fd' => array(
  57                  'wiki_rate_ip' => array('type' => 'char','precision' => '20','nullable' => False,'default' => ''),
  58                  'wiki_rate_time' => array('type' => 'int','precision' => '4'),
  59                  'wiki_rate_viewLimit' => array('type' => 'int','precision' => '2'),
  60                  'wiki_rate_searchLimit' => array('type' => 'int','precision' => '2'),
  61                  'wiki_rate_editLimit' => array('type' => 'int','precision' => '2')
  62              ),
  63              'pk' => array('wiki_rate_ip'),
  64              'fk' => array(),
  65              'ix' => array(),
  66              'uc' => array()
  67          ),
  68          'egw_wiki_interwiki' => array(
  69              'fd' => array(
  70                  'wiki_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  71                  'interwiki_prefix' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  72                  'wiki_name' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  73                  'wiki_lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''),
  74                  'interwiki_url' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  75              ),
  76              'pk' => array('wiki_id','interwiki_prefix'),
  77              'fk' => array(),
  78              'ix' => array(),
  79              'uc' => array()
  80          ),
  81          'egw_wiki_sisterwiki' => array(
  82              'fd' => array(
  83                  'wiki_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  84                  'sisterwiki_prefix' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  85                  'wiki_name' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  86                  'wiki_lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''),
  87                  'sisterwiki_url' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  88              ),
  89              'pk' => array('wiki_id','sisterwiki_prefix'),
  90              'fk' => array(),
  91              'ix' => array(),
  92              'uc' => array()
  93          ),
  94          'egw_wiki_remote_pages' => array(
  95              'fd' => array(
  96                  'wiki_remote_page' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  97                  'wiki_remote_site' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => '')
  98              ),
  99              'pk' => array('wiki_remote_page','wiki_remote_site'),
 100              'fk' => array(),
 101              'ix' => array(),
 102              'uc' => array()
 103          )
 104      );