[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_current.inc.php 21980 2006-06-28 12:24:53Z nelius_weiss $
  13      // $Source$
  14  
  15      $phpgw_baseline = array(
  16          'egw_config' => array(
  17              'fd' => array(
  18                  'config_app' => array('type' => 'varchar','precision' => '50','nullable' => False),
  19                  'config_name' => array('type' => 'varchar','precision' => '255','nullable' => False),
  20                  'config_value' => array('type' => 'text')
  21              ),
  22              'pk' => array('config_app','config_name'),
  23              'fk' => array(),
  24              'ix' => array(),
  25              'uc' => array()
  26          ),
  27          'egw_applications' => array(
  28              'fd' => array(
  29                  'app_id' => array('type' => 'auto','precision' => '4','nullable' => False),
  30                  'app_name' => array('type' => 'varchar','precision' => '25','nullable' => False),
  31                  'app_enabled' => array('type' => 'int','precision' => '4','nullable' => False),
  32                  'app_order' => array('type' => 'int','precision' => '4','nullable' => False),
  33                  'app_tables' => array('type' => 'text','nullable' => False),
  34                  'app_version' => array('type' => 'varchar','precision' => '20','nullable' => False,'default' => '0.0')
  35              ),
  36              'pk' => array('app_id'),
  37              'fk' => array(),
  38              'ix' => array(array('app_enabled','app_order')),
  39              'uc' => array('app_name')
  40          ),
  41          'egw_acl' => array(
  42              'fd' => array(
  43                  'acl_appname' => array('type' => 'varchar','precision' => '50','nullable' => False),
  44                  'acl_location' => array('type' => 'varchar','precision' => '255','nullable' => False),
  45                  'acl_account' => array('type' => 'int','precision' => '4','nullable' => False),
  46                  'acl_rights' => array('type' => 'int','precision' => '4')
  47              ),
  48              'pk' => array('acl_appname','acl_location','acl_account'),
  49              'fk' => array(),
  50              'ix' => array('acl_account',array('acl_location','acl_account'),array('acl_appname','acl_account')),
  51              'uc' => array()
  52          ),
  53          'egw_accounts' => array(
  54              'fd' => array(
  55                  'account_id' => array('type' => 'auto','nullable' => False),
  56                  'account_lid' => array('type' => 'varchar','precision' => '64','nullable' => False),
  57                  'account_pwd' => array('type' => 'varchar','precision' => '100','nullable' => False),
  58                  'account_firstname' => array('type' => 'varchar','precision' => '50'),
  59                  'account_lastname' => array('type' => 'varchar','precision' => '50'),
  60                  'account_lastlogin' => array('type' => 'int','precision' => '4'),
  61                  'account_lastloginfrom' => array('type' => 'varchar','precision' => '255'),
  62                  'account_lastpwd_change' => array('type' => 'int','precision' => '4'),
  63                  'account_status' => array('type' => 'char','precision' => '1','nullable' => False,'default' => 'A'),
  64                  'account_expires' => array('type' => 'int','precision' => '4'),
  65                  'account_type' => array('type' => 'char','precision' => '1'),
  66                  'person_id' => array('type' => 'int','precision' => '4'),
  67                  'account_primary_group' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
  68                  'account_email' => array('type' => 'varchar','precision' => '100')
  69              ),
  70              'pk' => array('account_id'),
  71              'fk' => array(),
  72              'ix' => array(),
  73              'uc' => array('account_lid')
  74          ),
  75          'egw_preferences' => array(
  76              'fd' => array(
  77                  'preference_owner' => array('type' => 'int','precision' => '4','nullable' => False),
  78                  'preference_app' => array('type' => 'varchar','precision' => '25','nullable' => False),
  79                  'preference_value' => array('type' => 'text','nullable' => False)
  80              ),
  81              'pk' => array('preference_owner','preference_app'),
  82              'fk' => array(),
  83              'ix' => array(),
  84              'uc' => array()
  85          ),
  86          'egw_sessions' => array(
  87              'fd' => array(
  88                  'session_id' => array('type' => 'varchar','precision' => '128','nullable' => False),
  89                  'session_lid' => array('type' => 'varchar','precision' => '128'),
  90                  'session_ip' => array('type' => 'varchar','precision' => '40'),
  91                  'session_logintime' => array('type' => 'int','precision' => '8'),
  92                  'session_dla' => array('type' => 'int','precision' => '8'),
  93                  'session_action' => array('type' => 'varchar','precision' => '255'),
  94                  'session_flags' => array('type' => 'char','precision' => '2')
  95              ),
  96              'pk' => array('session_id'),
  97              'fk' => array(),
  98              'ix' => array(array('session_flags','session_dla')),
  99              'uc' => array()
 100          ),
 101          'egw_app_sessions' => array(
 102              'fd' => array(
 103                  'sessionid' => array('type' => 'varchar','precision' => '128','nullable' => False),
 104                  'loginid' => array('type' => 'int','precision' => '4','nullable' => False),
 105                  'app' => array('type' => 'varchar','precision' => '25','nullable' => False),
 106                  'location' => array('type' => 'varchar','precision' => '128','nullable' => False),
 107                  'content' => array('type' => 'longtext'),
 108                  'session_dla' => array('type' => 'int','precision' => '8')
 109              ),
 110              'pk' => array('sessionid','loginid','app','location'),
 111              'fk' => array(),
 112              'ix' => array(),
 113              'uc' => array()
 114          ),
 115          'egw_access_log' => array(
 116              'fd' => array(
 117                  'sessionid' => array('type' => 'char','precision' => '128','nullable' => False),
 118                  'loginid' => array('type' => 'varchar','precision' => '64','nullable' => False),
 119                  'ip' => array('type' => 'varchar','precision' => '40','nullable' => False),
 120                  'li' => array('type' => 'int','precision' => '4','nullable' => False),
 121                  'lo' => array('type' => 'int','precision' => '4','default' => '0'),
 122                  'account_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
 123              ),
 124              'pk' => array(),
 125              'fk' => array(),
 126              'ix' => array(),
 127              'uc' => array()
 128          ),
 129          'egw_hooks' => array(
 130              'fd' => array(
 131                  'hook_id' => array('type' => 'auto','nullable' => False),
 132                  'hook_appname' => array('type' => 'varchar','precision' => '255'),
 133                  'hook_location' => array('type' => 'varchar','precision' => '255'),
 134                  'hook_filename' => array('type' => 'varchar','precision' => '255')
 135              ),
 136              'pk' => array('hook_id'),
 137              'ix' => array(),
 138              'fk' => array(),
 139              'uc' => array()
 140          ),
 141          'egw_languages' => array(
 142              'fd' => array(
 143                  'lang_id' => array('type' => 'varchar','precision' => '5','nullable' => False),
 144                  'lang_name' => array('type' => 'varchar','precision' => '50','nullable' => False)
 145              ),
 146              'pk' => array('lang_id'),
 147              'fk' => array(),
 148              'ix' => array(),
 149              'uc' => array()
 150          ),
 151          'egw_lang' => array(
 152              'fd' => array(
 153                  'lang' => array('type' => 'varchar','precision' => '5','nullable' => False,'default' => ''),
 154                  'app_name' => array('type' => 'varchar','precision' => '32','nullable' => False,'default' => 'common'),
 155                  'message_id' => array('type' => 'varchar','precision' => '128','nullable' => False,'default' => ''),
 156                  'content' => array('type' => 'text')
 157              ),
 158              'pk' => array('lang','app_name','message_id'),
 159              'fk' => array(),
 160              'ix' => array(),
 161              'uc' => array()
 162          ),
 163          'egw_nextid' => array(
 164              'fd' => array(
 165                  'id' => array('type' => 'int','precision' => '4','nullable' => True),
 166                  'appname' => array('type' => 'varchar','precision' => '25','nullable' => False)
 167              ),
 168              'pk' => array('appname'),
 169              'fk' => array(),
 170              'ix' => array(),
 171              'uc' => array()
 172          ),
 173          'egw_categories' => array(
 174              'fd' => array(
 175                  'cat_id' => array('type' => 'auto','precision' => '4','nullable' => False),
 176                  'cat_main' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 177                  'cat_parent' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 178                  'cat_level' => array('type' => 'int','precision' => '2','nullable' => False,'default' => '0'),
 179                  'cat_owner' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0'),
 180                  'cat_access' => array('type' => 'varchar','precision' => '7'),
 181                  'cat_appname' => array('type' => 'varchar','precision' => '50','nullable' => False),
 182                  'cat_name' => array('type' => 'varchar','precision' => '150','nullable' => False),
 183                  'cat_description' => array('type' => 'varchar','precision' => '255','nullable' => False),
 184                  'cat_data' => array('type' => 'text'),
 185                  'last_mod' => array('type' => 'int','precision' => '8','nullable' => False)
 186              ),
 187              'pk' => array('cat_id'),
 188              'fk' => array(),
 189              'ix' => array(array('cat_appname','cat_owner','cat_parent','cat_level')),
 190              'uc' => array()
 191          ),
 192          'egw_addressbook' => array(
 193              'fd' => array(
 194                  'id' => array('type' => 'auto','nullable' => False),
 195                  'lid' => array('type' => 'varchar','precision' => '32'),
 196                  'tid' => array('type' => 'char','precision' => '1'),
 197                  'owner' => array('type' => 'int','precision' => '8'),
 198                  'access' => array('type' => 'varchar','precision' => '7'),
 199                  'cat_id' => array('type' => 'varchar','precision' => '32'),
 200                  'fn' => array('type' => 'varchar','precision' => '64'),
 201                  'n_family' => array('type' => 'varchar','precision' => '64'),
 202                  'n_given' => array('type' => 'varchar','precision' => '64'),
 203                  'n_middle' => array('type' => 'varchar','precision' => '64'),
 204                  'n_prefix' => array('type' => 'varchar','precision' => '64'),
 205                  'n_suffix' => array('type' => 'varchar','precision' => '64'),
 206                  'sound' => array('type' => 'varchar','precision' => '64'),
 207                  'bday' => array('type' => 'varchar','precision' => '32'),
 208                  'note' => array('type' => 'text'),
 209                  'tz' => array('type' => 'varchar','precision' => '8'),
 210                  'geo' => array('type' => 'varchar','precision' => '32'),
 211                  'url' => array('type' => 'varchar','precision' => '128'),
 212                  'pubkey' => array('type' => 'text'),
 213                  'org_name' => array('type' => 'varchar','precision' => '64'),
 214                  'org_unit' => array('type' => 'varchar','precision' => '64'),
 215                  'title' => array('type' => 'varchar','precision' => '64'),
 216                  'adr_one_street' => array('type' => 'varchar','precision' => '64'),
 217                  'adr_one_locality' => array('type' => 'varchar','precision' => '64'),
 218                  'adr_one_region' => array('type' => 'varchar','precision' => '64'),
 219                  'adr_one_postalcode' => array('type' => 'varchar','precision' => '64'),
 220                  'adr_one_countryname' => array('type' => 'varchar','precision' => '64'),
 221                  'adr_one_type' => array('type' => 'varchar','precision' => '32'),
 222                  'label' => array('type' => 'text'),
 223                  'adr_two_street' => array('type' => 'varchar','precision' => '64'),
 224                  'adr_two_locality' => array('type' => 'varchar','precision' => '64'),
 225                  'adr_two_region' => array('type' => 'varchar','precision' => '64'),
 226                  'adr_two_postalcode' => array('type' => 'varchar','precision' => '64'),
 227                  'adr_two_countryname' => array('type' => 'varchar','precision' => '64'),
 228                  'adr_two_type' => array('type' => 'varchar','precision' => '32'),
 229                  'tel_work' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 230                  'tel_home' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 231                  'tel_voice' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 232                  'tel_fax' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 233                  'tel_msg' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 234                  'tel_cell' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 235                  'tel_pager' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 236                  'tel_bbs' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 237                  'tel_modem' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 238                  'tel_car' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 239                  'tel_isdn' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 240                  'tel_video' => array('type' => 'varchar','precision' => '40','nullable' => False,'default' => '+1 (000) 000-0000'),
 241                  'tel_prefer' => array('type' => 'varchar','precision' => '32'),
 242                  'email' => array('type' => 'varchar','precision' => '64'),
 243                  'email_type' => array('type' => 'varchar','precision' => '32','default' => 'INTERNET'),
 244                  'email_home' => array('type' => 'varchar','precision' => '64'),
 245                  'email_home_type' => array('type' => 'varchar','precision' => '32','default' => 'INTERNET'),
 246                  'last_mod' => array('type' => 'int','precision' => '8','nullable' => False)
 247              ),
 248              'pk' => array('id'),
 249              'fk' => array(),
 250              'ix' => array(array('tid','owner','access','n_family','n_given','email'),array('tid','cat_id','owner','access','n_family','n_given','email')),
 251              'uc' => array()
 252          ),
 253          'egw_addressbook_extra' => array(
 254              'fd' => array(
 255                  'contact_id' => array('type' => 'int','precision' => '4','nullable' => False),
 256                  'contact_owner' => array('type' => 'int','precision' => '8'),
 257                  'contact_name' => array('type' => 'varchar','precision' => '255','nullable' => False),
 258                  'contact_value' => array('type' => 'text')
 259              ),
 260              'pk' => array('contact_id','contact_name'),
 261              'fk' => array(),
 262              'ix' => array(),
 263              'uc' => array()
 264          ),
 265          'egw_log' => array(
 266              'fd' => array(
 267                  'log_id' => array('type' => 'auto','precision' => '4','nullable' => False),
 268                  'log_date' => array('type' => 'timestamp','nullable' => False),
 269                  'log_user' => array('type' => 'int','precision' => '4','nullable' => False),
 270                  'log_app' => array('type' => 'varchar','precision' => '50','nullable' => False),
 271                  'log_severity' => array('type' => 'char','precision' => '1','nullable' => False)
 272              ),
 273              'pk' => array('log_id'),
 274              'fk' => array(),
 275              'ix' => array(),
 276              'uc' => array()
 277          ),
 278          'egw_log_msg' => array(
 279              'fd' => array(
 280                  'log_msg_log_id' => array('type' => 'int','precision' => '4','nullable' => False),
 281                  'log_msg_seq_no' => array('type' => 'int','precision' => '4','nullable' => False),
 282                  'log_msg_date' => array('type' => 'timestamp','nullable' => False),
 283                  'log_msg_tx_fid' => array('type' => 'varchar','precision' => '4','nullable' => True),
 284                  'log_msg_tx_id' => array('type' => 'varchar','precision' => '4','nullable' => True),
 285                  'log_msg_severity' => array('type' => 'char','precision' => '1','nullable' => False),
 286                  'log_msg_code' => array('type' => 'varchar','precision' => '30','nullable' => False),
 287                  'log_msg_msg' => array('type' => 'text','nullable' => False),
 288                  'log_msg_parms' => array('type' => 'text','nullable' => False),
 289                  'log_msg_file' => array('type' => 'varchar','precision' => '255','nullable' => False),
 290                  'log_msg_line' => array('type' => 'int','precision' => '4','nullable' => False)
 291              ),
 292              'pk' => array('log_msg_log_id','log_msg_seq_no'),
 293              'fk' => array(),
 294              'ix' => array(),
 295              'uc' => array()
 296          ),
 297          'egw_interserv' => array(
 298              'fd' => array(
 299                  'server_id' => array('type' => 'auto','nullable' => False),
 300                  'server_name' => array('type' => 'varchar','precision' => '64','nullable' => True),
 301                  'server_host' => array('type' => 'varchar','precision' => '255','nullable' => True),
 302                  'server_url' => array('type' => 'varchar','precision' => '255','nullable' => True),
 303                  'trust_level' => array('type' => 'int','precision' => '4'),
 304                  'trust_rel' => array('type' => 'int','precision' => '4'),
 305                  'username' => array('type' => 'varchar','precision' => '64','nullable' => True),
 306                  'password' => array('type' => 'varchar','precision' => '255','nullable' => True),
 307                  'admin_name' => array('type' => 'varchar','precision' => '255','nullable' => True),
 308                  'admin_email' => array('type' => 'varchar','precision' => '255','nullable' => True),
 309                  'server_mode' => array('type' => 'varchar','precision' => '16','nullable' => False,'default' => 'xmlrpc'),
 310                  'server_security' => array('type' => 'varchar','precision' => '16','nullable' => True)
 311              ),
 312              'pk' => array('server_id'),
 313              'fk' => array(),
 314              'ix' => array(),
 315              'uc' => array()
 316          ),
 317          'egw_vfs' => array(
 318              'fd' => array(
 319                  'vfs_file_id' => array('type' => 'auto','nullable' => False),
 320                  'vfs_owner_id' => array('type' => 'int','precision' => '4','nullable' => False),
 321                  'vfs_createdby_id' => array('type' => 'int','precision' => '4'),
 322                  'vfs_modifiedby_id' => array('type' => 'int','precision' => '4'),
 323                  'vfs_created' => array('type' => 'date','nullable' => False,'default' => '1970-01-01'),
 324                  'vfs_modified' => array('type' => 'date'),
 325                  'vfs_size' => array('type' => 'int','precision' => '4'),
 326                  'vfs_mime_type' => array('type' => 'varchar','precision' => '64'),
 327                  'vfs_deleteable' => array('type' => 'char','precision' => '1','default' => 'Y'),
 328                  'vfs_comment' => array('type' => 'varchar','precision' => '255'),
 329                  'vfs_app' => array('type' => 'varchar','precision' => '25'),
 330                  'vfs_directory' => array('type' => 'varchar','precision' => '233'),
 331                  'vfs_name' => array('type' => 'varchar','precision' => '100','nullable' => False),
 332                  'vfs_link_directory' => array('type' => 'varchar','precision' => '255'),
 333                  'vfs_link_name' => array('type' => 'varchar','precision' => '128'),
 334                  'vfs_version' => array('type' => 'varchar','precision' => '30','nullable' => False,'default' => '0.0.0.0'),
 335                  'vfs_content' => array('type' => 'text')
 336              ),
 337              'pk' => array('vfs_file_id'),
 338              'fk' => array(),
 339              'ix' => array(array('vfs_directory','vfs_name')),
 340              'uc' => array()
 341          ),
 342          'egw_history_log' => array(
 343              'fd' => array(
 344                  'history_id' => array('type' => 'auto','precision' => '4','nullable' => False),
 345                  'history_record_id' => array('type' => 'int','precision' => '4','nullable' => False),
 346                  'history_appname' => array('type' => 'varchar','precision' => '64','nullable' => False),
 347                  'history_owner' => array('type' => 'int','precision' => '4','nullable' => False),
 348                  'history_status' => array('type' => 'char','precision' => '2','nullable' => False),
 349                  'history_new_value' => array('type' => 'text','nullable' => False),
 350                  'history_timestamp' => array('type' => 'timestamp','nullable' => False,'default' => 'current_timestamp'),
 351                  'history_old_value' => array('type' => 'text','nullable' => False)
 352              ),
 353              'pk' => array('history_id'),
 354              'fk' => array(),
 355              'ix' => array(array('history_appname','history_record_id','history_status','history_timestamp')),
 356              'uc' => array()
 357          ),
 358          'egw_async' => array(
 359              'fd' => array(
 360                  'async_id' => array('type' => 'varchar','precision' => '255','nullable' => False),
 361                  'async_next' => array('type' => 'int','precision' => '4','nullable' => False),
 362                  'async_times' => array('type' => 'varchar','precision' => '255','nullable' => False),
 363                  'async_method' => array('type' => 'varchar','precision' => '80','nullable' => False),
 364                  'async_data' => array('type' => 'text','nullable' => False),
 365                  'async_account_id' => array('type' => 'int','precision' => '4','nullable' => False,'default' => '0')
 366              ),
 367              'pk' => array('async_id'),
 368              'fk' => array(),
 369              'ix' => array(),
 370              'uc' => array()
 371          ),
 372          'egw_api_content_history' => array(
 373              'fd' => array(
 374                  'sync_appname' => array('type' => 'varchar','precision' => '60','nullable' => False),
 375                  'sync_contentid' => array('type' => 'varchar','precision' => '60','nullable' => False),
 376                  'sync_added' => array('type' => 'timestamp'),
 377                  'sync_modified' => array('type' => 'timestamp'),
 378                  'sync_deleted' => array('type' => 'timestamp'),
 379                  'sync_id' => array('type' => 'auto','nullable' => False),
 380                  'sync_guid' => array('type' => 'varchar','precision' => '120','nullable' => False),
 381                  'sync_changedby' => array('type' => 'int','precision' => '4','nullable' => False)
 382              ),
 383              'pk' => array('sync_id'),
 384              'fk' => array(),
 385              'ix' => array('sync_added','sync_modified','sync_deleted','sync_guid','sync_changedby',array('sync_appname','sync_contentid')),
 386              'uc' => array()
 387          ),
 388          'phpgw_vfs2_mimetypes' => array(
 389              'fd' => array(
 390                  'mime_id' => array('type' => 'auto','nullable' => False),
 391                  'extension' => array('type' => 'varchar','precision' => '10','nullable' => False),
 392                  'mime' => array('type' => 'varchar','precision' => '50','nullable' => False),
 393                  'mime_magic' => array('type' => 'varchar','precision' => '255','nullable' => True),
 394                  'friendly' => array('type' => 'varchar','precision' => '50','nullable' => False),
 395                  'image' => array('type' => 'blob'),
 396                  'proper_id' => array('type' => 'varchar','precision' => '4')
 397              ),
 398              'pk' => array('mime_id'),
 399              'fk' => array(),
 400              'ix' => array(),
 401              'uc' => array()
 402          ),
 403          'phpgw_vfs2_files' => array(
 404              'fd' => array(
 405                  'file_id' => array('type' => 'auto','nullable' => False),
 406                  'mime_id' => array('type' => 'int','precision' => '4'),
 407                  'owner_id' => array('type' => 'int','precision' => '4','nullable' => False),
 408                  'createdby_id' => array('type' => 'int','precision' => '4'),
 409                  'modifiedby_id' => array('type' => 'int','precision' => '4'),
 410                  'created' => array('type' => 'timestamp','nullable' => False,'default' => '1970-01-01 00:00:00'),
 411                  'modified' => array('type' => 'timestamp'),
 412                  'size' => array('type' => 'int','precision' => '8'),
 413                  'deleteable' => array('type' => 'char','precision' => '1','default' => 'Y'),
 414                  'comment' => array('type' => 'varchar','precision' => '255'),
 415                  'app' => array('type' => 'varchar','precision' => '25'),
 416                  'directory' => array('type' => 'varchar','precision' => '255'),
 417                  'name' => array('type' => 'varchar','precision' => '64','nullable' => False),
 418                  'link_directory' => array('type' => 'varchar','precision' => '255'),
 419                  'link_name' => array('type' => 'varchar','precision' => '128'),
 420                  'version' => array('type' => 'varchar','precision' => '30','nullable' => False,'default' => '0.0.0.0'),
 421                  'content' => array('type' => 'longtext'),
 422                  'is_backup' => array('type' => 'varchar','precision' => '1','nullable' => False,'default' => 'N'),
 423                  'shared' => array('type' => 'varchar','precision' => '1','nullable' => False,'default' => 'N'),
 424                  'proper_id' => array('type' => 'varchar','precision' => '45')
 425              ),
 426              'pk' => array('file_id'),
 427              'fk' => array(),
 428              'ix' => array(array('directory','name')),
 429              'uc' => array()
 430          ),
 431          'phpgw_vfs2_customfields' => array(
 432              'fd' => array(
 433                  'customfield_id' => array('type' => 'auto','nullable' => False),
 434                  'customfield_name' => array('type' => 'varchar','precision' => '60','nullable' => False),
 435                  'customfield_description' => array('type' => 'varchar','precision' => '255','nullable' => True),
 436                  'customfield_type' => array('type' => 'varchar','precision' => '20','nullable' => False),
 437                  'customfield_precision' => array('type' => 'int','precision' => '4','nullable' => True),
 438                  'customfield_active' => array('type' => 'varchar','precision' => '1','nullable' => False,'default' => 'N')
 439              ),
 440              'pk' => array('customfield_id'),
 441              'fk' => array(),
 442              'ix' => array(),
 443              'uc' => array()
 444          ),
 445          'phpgw_vfs2_quota' => array(
 446              'fd' => array(
 447                  'account_id' => array('type' => 'int','precision' => '4','nullable' => False),
 448                  'quota' => array('type' => 'int','precision' => '4','nullable' => False)
 449              ),
 450              'pk' => array('account_id'),
 451              'fk' => array('account_id' => array('egw_accounts' => 'account_id')),
 452              'ix' => array(),
 453              'uc' => array()
 454          ),
 455          'phpgw_vfs2_shares' => array(
 456              'fd' => array(
 457                  'account_id' => array('type' => 'int','precision' => '4','nullable' => False),
 458                  'file_id' => array('type' => 'int','precision' => '4','nullable' => False),
 459                  'acl_rights' => array('type' => 'int','precision' => '4','nullable' => False)
 460              ),
 461              'pk' => array('account_id','file_id'),
 462              'fk' => array('account_id' => array('egw_accounts' => 'account_id'),'file_id' => array('phpgw_vfs2_files' => 'file_id')),
 463              'ix' => array(),
 464              'uc' => array()
 465          ),
 466          'phpgw_vfs2_versioning' => array(
 467              'fd' => array(
 468                  'version_id' => array('type' => 'auto','nullable' => False),
 469                  'file_id' => array('type' => 'int','precision' => '4','nullable' => False),
 470                  'operation' => array('type' => 'int','precision' => '4','nullable' => False),
 471                  'modifiedby_id' => array('type' => 'int','precision' => '4','nullable' => False),
 472                  'modified' => array('type' => 'timestamp','nullable' => False),
 473                  'version' => array('type' => 'varchar','precision' => '30','nullable' => False),
 474                  'comment' => array('type' => 'varchar','precision' => '255','nullable' => True),
 475                  'backup_file_id' => array('type' => 'int','precision' => '4','nullable' => True),
 476                  'backup_content' => array('type' => 'longtext','nullable' => True),
 477                  'src' => array('type' => 'varchar','precision' => '255','nullable' => True),
 478                  'dest' => array('type' => 'varchar','precision' => '255','nullable' => True)
 479              ),
 480              'pk' => array('version_id'),
 481              'fk' => array('file_id' => array('phpgw_vfs2_files' => 'file_id')),
 482              'ix' => array(),
 483              'uc' => array()
 484          ),
 485          'phpgw_vfs2_customfields_data' => array(
 486              'fd' => array(
 487                  'file_id' => array('type' => 'int','precision' => '4','nullable' => False),
 488                  'customfield_id' => array('type' => 'int','precision' => '4','nullable' => False),
 489                  'data' => array('type' => 'longtext','nullable' => True)
 490              ),
 491              'pk' => array('file_id','customfield_id'),
 492              'fk' => array('file_id' => array('phpgw_vfs2_files' => 'file_id'),'customfield_id' => array('phpgw_vfs2_customfields' => 'customfield_id')),
 493              'ix' => array(),
 494              'uc' => array()
 495          ),
 496          'phpgw_vfs2_prefixes' => array(
 497              'fd' => array(
 498                  'prefix_id' => array('type' => 'auto','nullable' => False),
 499                  'prefix' => array('type' => 'varchar','precision' => '8','nullable' => False),
 500                  'owner_id' => array('type' => 'int','precision' => '4','nullable' => False),
 501                  'prefix_description' => array('type' => 'varchar','precision' => '30','nullable' => True),
 502                  'prefix_type' => array('type' => 'varchar','precision' => '1','nullable' => False,'default' => 'p')
 503              ),
 504              'pk' => array('prefix_id'),
 505              'fk' => array(),
 506              'ix' => array(),
 507              'uc' => array()
 508          ),
 509          'egw_contentmap' => array(
 510              'fd' => array(
 511                  'map_id' => array('type' => 'varchar','precision' => '128','nullable' => False),
 512                  'map_guid' => array('type' => 'varchar','precision' => '100','nullable' => False),
 513                  'map_locuid' => array('type' => 'varchar','precision' => '100','nullable' => False),
 514                  'map_timestamp' => array('type' => 'timestamp','nullable' => False),
 515                  'map_expired' => array('type' => 'bool','nullable' => False)
 516              ),
 517              'pk' => array('map_id','map_guid','map_locuid'),
 518              'fk' => array(),
 519              'ix' => array('map_expired',array('map_id','map_locuid')),
 520              'uc' => array()
 521          ),
 522          'egw_syncmldevinfo' => array(
 523              'fd' => array(
 524                  'dev_id' => array('type' => 'varchar','precision' => '255','nullable' => False),
 525                  'dev_dtdversion' => array('type' => 'varchar','precision' => '10','nullable' => False),
 526                  'dev_numberofchanges' => array('type' => 'bool','nullable' => False),
 527                  'dev_largeobjs' => array('type' => 'bool','nullable' => False),
 528                  'dev_swversion' => array('type' => 'varchar','precision' => '100','nullable' => False),
 529                  'dev_oem' => array('type' => 'varchar','precision' => '100','nullable' => False),
 530                  'dev_model' => array('type' => 'varchar','precision' => '100','nullable' => False),
 531                  'dev_manufacturer' => array('type' => 'varchar','precision' => '100','nullable' => False),
 532                  'dev_devicetype' => array('type' => 'varchar','precision' => '100','nullable' => False),
 533                  'dev_deviceid' => array('type' => 'varchar','precision' => '100','nullable' => False),
 534                  'dev_datastore' => array('type' => 'text','nullable' => False)
 535              ),
 536              'pk' => array('dev_id'),
 537              'fk' => array(),
 538              'ix' => array(),
 539              'uc' => array()
 540          ),
 541          'egw_syncmlsummary' => array(
 542              'fd' => array(
 543                  'dev_id' => array('type' => 'varchar','precision' => '255','nullable' => False),
 544                  'sync_path' => array('type' => 'varchar','precision' => '100','nullable' => False),
 545                  'sync_serverts' => array('type' => 'varchar','precision' => '20','nullable' => False),
 546                  'sync_clientts' => array('type' => 'varchar','precision' => '20','nullable' => False)
 547              ),
 548              'pk' => array(array('dev_id','sync_path')),
 549              'fk' => array(),
 550              'ix' => array(),
 551              'uc' => array()
 552          ),
 553          'egw_links' => array(
 554              'fd' => array(
 555                  'link_id' => array('type' => 'auto','nullable' => False),
 556                  'link_app1' => array('type' => 'varchar','precision' => '25','nullable' => False),
 557                  'link_id1' => array('type' => 'varchar','precision' => '50','nullable' => False),
 558                  'link_app2' => array('type' => 'varchar','precision' => '25','nullable' => False),
 559                  'link_id2' => array('type' => 'varchar','precision' => '50','nullable' => False),
 560                  'link_remark' => array('type' => 'varchar','precision' => '100'),
 561                  'link_lastmod' => array('type' => 'int','precision' => '4','nullable' => False),
 562                  'link_owner' => array('type' => 'int','precision' => '4','nullable' => False)
 563              ),
 564              'pk' => array('link_id'),
 565              'fk' => array(),
 566              'ix' => array(array('link_app1','link_id1','link_lastmod'),array('link_app2','link_id2','link_lastmod')),
 567              'uc' => array()
 568          )
 569      );