[Fmsystem-commits] [8285] API: notifier

[Sigurd Nes]

Revision: 8285
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8285
Author:   sigurdne
Date:     2011-12-13 14:19:10 +0000 (Tue, 13 Dec 2011)
Log Message:
-----------
API: notifier

Modified Paths:
--------------
    trunk/phpgwapi/setup/setup.inc.php
    trunk/phpgwapi/setup/tables_current.inc.php
    trunk/phpgwapi/setup/tables_update.inc.php

Modified: trunk/phpgwapi/setup/setup.inc.php
===================================================================
--- trunk/phpgwapi/setup/setup.inc.php  2011-12-13 14:18:32 UTC (rev 8284)
+++ trunk/phpgwapi/setup/setup.inc.php  2011-12-13 14:19:10 UTC (rev 8285)
@@ -12,7 +12,7 @@
        // Basic information about this app
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
-       $setup_info['phpgwapi']['version']   = '0.9.17.536';
+       $setup_info['phpgwapi']['version']   = '0.9.17.537';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.31';
        $setup_info['phpgwapi']['versions']['system'] = '1.0';
        $setup_info['phpgwapi']['enable']    = 3;
@@ -66,7 +66,8 @@
                'phpgw_config2_section',
                'phpgw_config2_attrib',
                'phpgw_config2_choice',
-               'phpgw_config2_value'
+               'phpgw_config2_value',
+               'phpgw_notification'
        );
 
        $setup_info['phpgwapi']['hooks'] = array

Modified: trunk/phpgwapi/setup/tables_current.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_current.inc.php 2011-12-13 14:18:32 UTC (rev 
8284)
+++ trunk/phpgwapi/setup/tables_current.inc.php 2011-12-13 14:19:10 UTC (rev 
8285)
@@ -698,5 +698,21 @@
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
+               ),
+               'phpgw_notification' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'auto','precision' => 
4,'nullable' => False),
+                               'location_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                               'location_item_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                               'contact_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                               'is_active' => array('type' => 'int', 
'precision' => 2,'nullable' => true),
+                               'notification_method' => array('type' => 
'varchar', 'precision' => 20,'nullable' => true),
+                               'user_id' => array('type' => 'int','precision' 
=> 4,'nullable' => False),
+                               'entry_date' => array('type' => 
'int','precision' => 4,'nullable' => False)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array('phpgw_contact' => array('contact_id' => 
'contact_id')),
+                       'ix' => array(),
+                       'uc' => array()
                )
        );

Modified: trunk/phpgwapi/setup/tables_update.inc.php
===================================================================
--- trunk/phpgwapi/setup/tables_update.inc.php  2011-12-13 14:18:32 UTC (rev 
8284)
+++ trunk/phpgwapi/setup/tables_update.inc.php  2011-12-13 14:19:10 UTC (rev 
8285)
@@ -2990,3 +2990,39 @@
                        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
                }
        }
+
+       $test[] = '0.9.17.536';
+       /**
+       * Add custom attibute type that allows call to function of choice
+       *
+       * @return string the new version number
+       */
+
+       function phpgwapi_upgrade0_9_17_536()
+       {
+
+               $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
+               
$GLOBALS['phpgw_setup']->oProc->CreateTable('phpgw_notification', array(
+                               'fd' => array(
+                                       'id' => array('type' => 
'auto','precision' => 4,'nullable' => False),
+                                       'location_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                                       'location_item_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                                       'contact_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                                       'is_active' => array('type' => 'int', 
'precision' => 2,'nullable' => true),
+                                       'notification_method' => array('type' 
=> 'varchar', 'precision' => 20,'nullable' => true),
+                                       'user_id' => array('type' => 
'int','precision' => 4,'nullable' => False),
+                                       'entry_date' => array('type' => 
'int','precision' => 4,'nullable' => False)
+                               ),
+                               'pk' => array('id'),
+                               'fk' => array('phpgw_contact' => 
array('contact_id' => 'contact_id')),
+                               'ix' => array(),
+                               'uc' => array()
+                       )
+               );
+
+               if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
+               {
+                       $GLOBALS['setup_info']['phpgwapi']['currentver'] = 
'0.9.17.537';
+                       return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+               }
+       }