[Phpgroupware-cvs] CVS: etemplate/setup setup.inc.php,1.9,1.10 tables_current.inc.php,1.2,1.3 tables_update.inc.php,1.1,1.2

[Ralf Becker <address@hidden>]

Update of /cvsroot/phpgroupware/etemplate/setup
In directory subversions:/tmp/cvs-serv23517

Modified Files:
        setup.inc.php tables_current.inc.php tables_update.inc.php 
Log Message:
changed all char-column to varchar, as pgSql fills the char's up with space

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/etemplate/setup/setup.inc.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** setup.inc.php       24 Nov 2002 21:26:31 -0000      1.9
--- setup.inc.php       18 Mar 2003 00:47:04 -0000      1.10
***************
*** 15,19 ****
        $setup_info['etemplate']['name']      = 'etemplate';
        $setup_info['etemplate']['title']     = 'eTemplates';
!       $setup_info['etemplate']['version']   = '0.9.15.001';
        $setup_info['etemplate']['app_order'] = 8;      // just behind the 
developers-tools
        $setup_info['etemplate']['tables']    = array('phpgw_etemplate');
--- 15,19 ----
        $setup_info['etemplate']['name']      = 'etemplate';
        $setup_info['etemplate']['title']     = 'eTemplates';
!       $setup_info['etemplate']['version']   = '0.9.15.002';
        $setup_info['etemplate']['app_order'] = 8;      // just behind the 
developers-tools
        $setup_info['etemplate']['tables']    = array('phpgw_etemplate');

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/etemplate/setup/tables_current.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** tables_current.inc.php      29 Sep 2002 13:01:40 -0000      1.2
--- tables_current.inc.php      18 Mar 2003 00:47:05 -0000      1.3
***************
*** 16,28 ****
                'phpgw_etemplate' => array(
                        'fd' => array(
!                               'et_name' => array('type' => 'char','precision' 
=> '80','nullable' => False),
!                               'et_template' => array('type' => 
'char','precision' => '20','default' => '','nullable' => False),
!                               'et_lang' => array('type' => 'char','precision' 
=> '5','default' => '','nullable' => False),
!                               'et_group' => array('type' => 'int','precision' 
=> '4','default' => '0','nullable' => False),
!                               'et_version' => array('type' => 
'char','precision' => '20','default' => '','nullable' => False),
                                'et_data' => array('type' => 'text','nullable' 
=> True),
!                               'et_size' => array('type' => 'char','precision' 
=> '128','nullable' => True),
                                'et_style' => array('type' => 'text','nullable' 
=> True),
!                               'et_modified' => array('type' => 
'int','precision' => '4','default' => '0','nullable' => False)
                        ),
                        'pk' => 
array('et_name','et_template','et_lang','et_group','et_version'),
--- 16,28 ----
                'phpgw_etemplate' => array(
                        'fd' => array(
!                               'et_name' => array('type' => 
'varchar','precision' => '80','nullable' => False),
!                               'et_template' => array('type' => 
'varchar','precision' => '20','nullable' => False,'default' => ''),
!                               'et_lang' => array('type' => 
'varchar','precision' => '5','nullable' => False,'default' => ''),
!                               'et_group' => array('type' => 'int','precision' 
=> '4','nullable' => False,'default' => '0'),
!                               'et_version' => array('type' => 
'varchar','precision' => '20','nullable' => False,'default' => ''),
                                'et_data' => array('type' => 'text','nullable' 
=> True),
!                               'et_size' => array('type' => 
'varchar','precision' => '128','nullable' => True),
                                'et_style' => array('type' => 'text','nullable' 
=> True),
!                               'et_modified' => array('type' => 
'int','precision' => '4','nullable' => False,'default' => '0')
                        ),
                        'pk' => 
array('et_name','et_template','et_lang','et_group','et_version'),

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/etemplate/setup/tables_update.inc.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** tables_update.inc.php       29 Sep 2002 13:01:40 -0000      1.1
--- tables_update.inc.php       18 Mar 2003 00:47:05 -0000      1.2
***************
*** 39,41 ****
--- 39,79 ----
                return $GLOBALS['setup_info']['etemplate']['currentver'];
        }
+ 
+ 
+       $test[] = '0.9.15.001';
+       function etemplate_upgrade0_9_15_001()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_etemplate','et_name',array(
+                       'type' => 'varchar',
+                       'precision' => '80',
+                       'nullable' => False
+               ));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_etemplate','et_template',array(
+                       'type' => 'varchar',
+                       'precision' => '20',
+                       'nullable' => False,
+                       'default' => ''
+               ));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_etemplate','et_lang',array(
+                       'type' => 'varchar',
+                       'precision' => '5',
+                       'nullable' => False,
+                       'default' => ''
+               ));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_etemplate','et_version',array(
+                       'type' => 'varchar',
+                       'precision' => '20',
+                       'nullable' => False,
+                       'default' => ''
+               ));
+               
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_etemplate','et_size',array(
+                       'type' => 'varchar',
+                       'precision' => '128',
+                       'nullable' => True
+               ));
+ 
+ 
+               $GLOBALS['setup_info']['etemplate']['currentver'] = 
'0.9.15.002';
+               return $GLOBALS['setup_info']['etemplate']['currentver'];
+       }
  ?>