[Sommaire] [Imprimer]

   1  <?php
   2    /**************************************************************************\
   3    * eGroupWare                                                               *
   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 13503 2004-01-27 00:31:58Z reinerj $ */
  13  
  14      $phpgw_baseline = array(
  15          "webcal_entry" => array(
  16              "fd" => array(
  17                  "cal_id" => array("type" => "auto", "nullable" => false),
  18                  "cal_group_id" => array("type" => "int", "precision" => 4),
  19                  "cal_create_by" => array("type" => "varchar", "precision" => 25, "nullable" => false),
  20                  "cal_date" => array("type" => "int", "precision" => 4, "nullable" => false, "default" => "0"),
  21                  "cal_time" => array("type" => "int", "precision" => 4),
  22                  "cal_mod_date" => array("type" => "int", "precision" => 4),
  23                  "cal_mod_time" => array("type" => "int", "precision" => 4),
  24                  "cal_duration" => array("type" => "int", "precision" => 4, "nullable" => false, "default" => "0"),
  25                  "cal_priority" => array("type" => "int", "precision" => 4, "default" => "2"),
  26                  "cal_type" => array("type" => "varchar", "precision" => 10),
  27                  "cal_access" => array("type" => "char", "precision" => 10),
  28                  "cal_name" => array("type" => "varchar", "precision" => 80, "nullable" => false),
  29                  "cal_description" => array("type" => "text")
  30              ),
  31              "pk" => array("cal_id"),
  32              "fk" => array(),
  33              "ix" => array(),
  34              "uc" => array()
  35          ),
  36          "webcal_entry_repeats" => array(
  37              "fd" => array(
  38                  "cal_id" => array("type" => "int", "precision" => 4, "nullable" => false, "default" => "0"),
  39                  "cal_type" => array("type" => "varchar", "precision" => 20, "nullable" => false, "default" => "daily"),
  40                  "cal_end" => array("type" => "int", "precision" => 4),
  41                  "cal_frequency" => array("type" => "int", "precision" => 4, "default" => "1"),
  42                  "cal_days" => array("type" => "char", "precision" => 7)
  43              ),
  44              "pk" => array(),
  45              "fk" => array(),
  46              "ix" => array(),
  47              "uc" => array()
  48          ),
  49          "webcal_entry_user" => array(
  50              "fd" => array(
  51                  "cal_id" => array("type" => "int", "precision" => 4, "nullable" => false, "default" => "0"),
  52                  "cal_login" => array("type" => "varchar", "precision" => 25, "nullable" => false),
  53                  "cal_status" => array("type" => "char", "precision" => 1, "default" => "A")
  54              ),
  55              "pk" => array("cal_id", "cal_login"),
  56              "fk" => array(),
  57              "ix" => array(),
  58              "uc" => array()
  59          ),
  60          "webcal_entry_groups" => array(
  61              "fd" => array(
  62                  "cal_id" => array("type" => "int", "precision" => 4),
  63                  "groups" => array("type" => "varchar", "precision" => 255)
  64              ),
  65              "pk" => array(),
  66              "fk" => array(),
  67              "ix" => array(),
  68              "uc" => array()
  69          )
  70      );
  71  ?>