[Phpgroupware-cvs] sync/setup/tables_update.inc.php, 1.4

[nomail]

Update of /sync/setup
Modified Files:
        Branch: 
          tables_update.inc.php

date: 2004/11/26 12:34:57;  author: fipsfuchs;  state: Exp;  lines: +28 -1

Log Message:
new version from internal CVS moved to original project
=====================================================================
Index: sync/setup/tables_update.inc.php
diff -u sync/setup/tables_update.inc.php:1.3 
sync/setup/tables_update.inc.php:1.4
--- sync/setup/tables_update.inc.php:1.3        Tue Feb 10 13:41:11 2004
+++ sync/setup/tables_update.inc.php    Fri Nov 26 12:34:57 2004
@@ -11,4 +11,31 @@
   * @version     $Id$
   */
        
+       $test[] = '0.9.16.001';
+       function sync_upgrade0_9_16_001() {
+               global $setup_info,$phpgw_setup;
+
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'phpgw_syncresolve', array(
+                               'fd' => array(
+                                       'resolveid' => array('type' => 
'auto','nullable' => False),
+                       'deviceidid' => array('type' => 'varchar','precision' 
=> '255','nullable' => False,'default' => ''),
+                               'reqsourceuri' => array('type' => 
'varchar','precision' => '255','nullable' => False, 'default' => ''),
+                               'resid' => array('type' => 
'varchar','precision' => '255','nullable' => False, 'default' => ''),
+                               'fkluid' => array('type' => 
'varchar','precision' => '255','nullable' => False, 'default' => ''),
+                               'fksourceuri' => array('type' => 
'varchar','precision' => '255','nullable' => False, 'default' => ''),
+                                       'tag' => array('type' => 
'varchar','precision' => '255','nullable' => False, 'default' => '')
+                               ),
+                               'pk' => array('resolveid'),
+                               // TODO add foreign-keys
+                               'fk' => array(''),
+                               // TODO add indices
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+
+               $setup_info['sync']['currentver'] = '0.9.16.002';
+               return $setup_info['sync']['currentver'];
+       }
 ?>