[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          'phpgw_kb_articles' => array(
  17              'fd' => array(
  18                  'art_id' => array('type' => 'auto','nullable' => False),
  19                  'q_id' => array('type' => 'int','precision' => '8','nullable' => False),
  20                  'title' => array('type' => 'varchar','precision' => '255','nullable' => False),
  21                  'topic' => array('type' => 'varchar','precision' => '255','nullable' => False),
  22                  'text' => array('type' => 'text','nullable' => False),
  23                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  24                  'published' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'),
  25                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  26                  'views' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  27                  'created' => array('type' => 'int','precision' => '4'),
  28                  'modified' => array('type' => 'int','precision' => '4'),
  29                  'modified_user_id' => array('type' => 'int','precision' => '4','nullable' => False),
  30                  'votes_1' => array('type' => 'int','precision' => '4','nullable' => False),
  31                  'votes_2' => array('type' => 'int','precision' => '4','nullable' => False),
  32                  'votes_3' => array('type' => 'int','precision' => '4','nullable' => False),
  33                  'votes_4' => array('type' => 'int','precision' => '4','nullable' => False),
  34                  'votes_5' => array('type' => 'int','precision' => '4','nullable' => False)
  35              ),
  36              'pk' => array('art_id'),
  37              'fk' => array(),
  38              'ix' => array(),
  39              'uc' => array()
  40          ),
  41          'phpgw_kb_comment' => array(
  42              'fd' => array(
  43                  'comment_id' => array('type' => 'auto','nullable' => False),
  44                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False),
  45                  'comment' => array('type' => 'text','nullable' => False),
  46                  'entered' => array('type' => 'int','precision' => '4','nullable' => True),
  47                  'art_id' => array('type' => 'int','precision' => '4','nullable' => False),
  48                  'published' => array('type' => 'int','precision' => '2','nullable' => False)
  49              ),
  50              'pk' => array('comment_id'),
  51              'fk' => array(),
  52              'ix' => array('art_id'),
  53              'uc' => array()
  54          ),
  55          'phpgw_kb_questions' => array(
  56              'fd' => array(
  57                  'question_id' => array('type' => 'auto','nullable' => False),
  58                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False),
  59                  'summary' => array('type' => 'text','nullable' => False),
  60                  'details' => array('type' => 'text','nullable' => False),
  61                  'cat_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  62                  'creation' => array('type' => 'int','precision' => '4','nullable' => True),
  63                  'published' => array('type' => 'int','precision' => '2','nullable' => False)
  64              ),
  65              'pk' => array('question_id'),
  66              'fk' => array(),
  67              'ix' => array(),
  68              'uc' => array()
  69          ),
  70          'phpgw_kb_ratings' => array(
  71              'fd' => array(
  72                  'user_id' => array('type' => 'int','precision' => '4','nullable' => False),
  73                  'art_id' => array('type' => 'int','precision' => '4','nullable' => False)
  74              ),
  75              'pk' => array('user_id','art_id'),
  76              'fk' => array(),
  77              'ix' => array(),
  78              'uc' => array()
  79          ),
  80          'phpgw_kb_related_art' => array(
  81              'fd' => array(
  82                  'art_id' => array('type' => 'int','precision' => '4','nullable' => False),
  83                  'related_art_id' => array('type' => 'int','precision' => '4','nullable' => False)
  84              ),
  85              'pk' => array('art_id','related_art_id'),
  86              'fk' => array(),
  87              'ix' => array(),
  88              'uc' => array()
  89          ),
  90          'phpgw_kb_search' => array(
  91              'fd' => array(
  92                  'keyword' => array('type' => 'varchar','precision' => '30','nullable' => False),
  93                  'art_id' => array('type' => 'int','precision' => '4','nullable' => False),
  94                  'score' => array('type' => 'int','precision' => '8','nullable' => False)
  95              ),
  96              'pk' => array('keyword','art_id'),
  97              'fk' => array(),
  98              'ix' => array(),
  99              'uc' => array()
 100          ),
 101          'phpgw_kb_files' => array(
 102              'fd' => array(
 103                  'art_id' => array('type' => 'int','precision' => '4'),
 104                  'art_file' => array('type' => 'varchar','precision' => '255'),
 105                  'art_file_comments' => array('type' => 'varchar','precision' => '255'),
 106              ),
 107              'pk' => array('art_id','art_file'),
 108              'fk' => array(),
 109              'ix' => array(),
 110              'uc' => array()
 111          ),
 112          'phpgw_kb_urls' => array(
 113              'fd' => array(
 114                  'art_id' => array('type' => 'int','precision' => '4'),
 115                  'art_url' => array('type' => 'varchar','precision' => '255'),
 116                  'art_url_title' => array('type' => 'varchar','precision' => '255')
 117              ),
 118              'pk' => array('art_id','art_url'),
 119              'fk' => array(),
 120              'ix' => array(),
 121              'uc' => array()
 122          )
 123      );