[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: etemplate/setup setup.inc.php,1.9,1.10 tables_cu
From: |
Ralf Becker <address@hidden> |
Subject: |
[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 |
Date: |
Mon, 17 Mar 2003 19:47:11 -0500 |
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'];
+ }
?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [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> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: etemplate/inc class.schema_proc_pgsql.inc.php,1.1,1.2
- Next by Date:
[Phpgroupware-cvs] CVS: preferences/setup phpgw_de.lang,1.6.2.5,1.6.2.6 phpgw_en.lang,1.7.2.5,1.7.2.6
- Previous by thread:
[Phpgroupware-cvs] CVS: etemplate/inc class.schema_proc_pgsql.inc.php,1.1,1.2
- Next by thread:
[Phpgroupware-cvs] CVS: preferences/setup phpgw_de.lang,1.6.2.5,1.6.2.6 phpgw_en.lang,1.7.2.5,1.7.2.6
- Index(es):