[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 16302 2004-08-09 12:12:00Z reinerj $ */
  13  
  14  
  15      $phpgw_baseline = array(
  16          'phpgw_kb_faq' => array(
  17              'fd' => array(
  18                  'faq_id' => array('type' => 'auto','nullable' => False),
  19                  'title' => array('type' => 'text','nullable' => False),
  20                  'text' => array('type' => 'text','nullable' => False),
  21                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  22                  'published' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'),
  23                  'keywords' => array('type' => 'text','nullable' => False),
  24                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  25                  'views' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  26                  'modified' => array('type' => 'int','precision' => '4','nullable' => True),
  27                  'is_faq' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '1'),
  28                  'url' => array('type' => 'varchar','precision' => '128','nullable' => False),
  29                  'votes' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  30                  'total' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
  31              ),
  32              'pk' => array('faq_id'),
  33              'fk' => array(),
  34              'ix' => array(
  35                  array('title','options'=>array('mysql'=>255)),
  36                  array('text','options'=>array('mysql'=>'FULLTEXT')),
  37                  'cat_id',
  38                  'published',
  39                  array('keywords','options'=>array('mysql'=>255)),
  40                  'is_faq'),
  41              'uc' => array()
  42          ),
  43          'phpgw_kb_comment' => array(
  44              'fd' => array(
  45                  'comment_id' => array('type' => 'auto','nullable' => False),
  46                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  47                  'comment' => array('type' => 'text','nullable' => False),
  48                  'entered' => array('type' => 'int','precision' => '4','nullable' => True,'default' => '0'),
  49                  'faq_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
  50              ),
  51              'pk' => array('comment_id'),
  52              'fk' => array(),
  53              'ix' => array('faq_id'),
  54              'uc' => array()
  55          ),
  56          'phpgw_kb_questions' => array(
  57              'fd' => array(
  58                  'question_id' => array('type' => 'auto','nullable' => False),
  59                  'question' => array('type' => 'text','nullable' => False),
  60                  'pending' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '1')
  61              ),
  62              'pk' => array('question_id'),
  63              'fk' => array(),
  64              'ix' => array('pending'),
  65              'uc' => array()
  66          )
  67      );