[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_baseline.inc.php 14872 2004-04-12 13:02:09Z ralfbecker $ */
  13  
  14  
  15      $phpgw_baseline = array(
  16          'phpgw_wiki_links' => array(
  17              'fd' => array(
  18                  'page' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  19                  'link' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  20                  'count' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
  21              ),
  22              'pk' => array('page','link'),
  23              'fk' => array(),
  24              'ix' => array(),
  25              'uc' => array()
  26          ),
  27          'phpgw_wiki_pages' => array(
  28              'fd' => array(
  29                  'title' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  30                  'version' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '1'),
  31                  'time' => array('type' => 'int','precision' => '4','nullable' => True),
  32                  'supercede' => array('type' => 'int','precision' => '4','nullable' => True),
  33                  'mutable' => array('type' => 'char','precision' => '3','nullable' => False,'default' => 'on'),
  34                  'username' => array('type' => 'varchar','precision' => '80','nullable' => True),
  35                  'author' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  36                  'comment' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  37                  'body' => array('type' => 'text','nullable' => True)
  38              ),
  39              'pk' => array('title','version'),
  40              'fk' => array(),
  41              'ix' => array(),
  42              'uc' => array()
  43          ),
  44          'phpgw_wiki_rate' => array(
  45              'fd' => array(
  46                  'ip' => array('type' => 'char','precision' => '20','nullable' => False,'default' => ''),
  47                  'time' => array('type' => 'int','precision' => '4','nullable' => True),
  48                  'viewLimit' => array('type' => 'int','precision' => '2','nullable' => True),
  49                  'searchLimit' => array('type' => 'int','precision' => '2','nullable' => True),
  50                  'editLimit' => array('type' => 'int','precision' => '2','nullable' => True)
  51              ),
  52              'pk' => array('ip'),
  53              'fk' => array(),
  54              'ix' => array(),
  55              'uc' => array()
  56          ),
  57          'phpgw_wiki_interwiki' => array(
  58              'fd' => array(
  59                  'prefix' => array('type' => 'varchar','precision' => '80','nullable' => false,'default' => ''),
  60                  'where_defined' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  61                  'url' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  62              ),
  63              'pk' => array('prefix'),
  64              'fk' => array(),
  65              'ix' => array(),
  66              'uc' => array()
  67          ),
  68          'phpgw_wiki_sisterwiki' => array(
  69              'fd' => array(
  70                  'prefix' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  71                  'where_defined' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  72                  'url' => array('type' => 'varchar','precision' => '255','nullable' => False,'default' => '')
  73              ),
  74              'pk' => array('prefix'),
  75              'fk' => array(),
  76              'ix' => array(),
  77              'uc' => array()
  78          ),
  79          'phpgw_wiki_remote_pages' => array(
  80              'fd' => array(
  81                  'page' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => ''),
  82                  'site' => array('type' => 'varchar','precision' => '80','nullable' => False,'default' => '')
  83              ),
  84              'pk' => array('page','site'),
  85              'fk' => array(),
  86              'ix' => array(),
  87              'uc' => array()
  88          )
  89      );