[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.12,1.13
From: |
Sigurd Nes <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.12,1.13 tables_update.inc.php,1.11,1.12 setup.inc.php,1.9,1.10 |
Date: |
Mon, 30 Sep 2002 12:28:02 -0400 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv7802/setup
Modified Files:
tables_current.inc.php tables_update.inc.php setup.inc.php
Log Message:
no message
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** tables_current.inc.php 21 Sep 2002 14:56:10 -0000 1.12
--- tables_current.inc.php 30 Sep 2002 16:28:00 -0000 1.13
***************
*** 1040,1058 ****
'uc' => array()
),
! 'fm_property_value' => array(
! 'fd' => array(
! 'objekt_id' => array('type' =>
'char','precision' => 4,'default' => 0,'nullable' => False),
! 'bygg_id' => array('type' => 'char','precision'
=> 2,'nullable' => False),
! 'index_count' => array('type' => 'int',
'precision' => 4,'nullable' => False),
! 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
! 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'default' => 0,'nullable' => True),
! 'value' => array('type' =>
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => True),
! 'date' => array('type' => 'timestamp',
'nullable' => True,'default' => 'current_timestamp')
! ),
! 'pk' => array('objekt_id','bygg_id','index_count' ),
! 'fk' => array(),
! 'ix' => array(),
! 'uc' => array()
! ),
'fm_request_priority_key' => array(
'fd' => array(
--- 1040,1044 ----
'uc' => array()
),
!
'fm_request_priority_key' => array(
'fd' => array(
***************
*** 1118,1121 ****
--- 1104,1153 ----
),
'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_event_receipt' => array(
+ 'fd' => array(
+ 'cal_id' => array('type' => 'int','precision'
=> 4,'nullable' => False),
+ 'year_month_date' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'datetime_done' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'datetime_reject' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True)
+ ),
+ 'pk' => array('cal_id','year_month_date'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_investment' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
4,'nullable' => False),
+ 'location_code' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'objekt_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'cost_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'descr' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'type' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
+ 'bygg_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'equipment_id' => array('type' => 'int',
'precision' => 4,'nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_investment_value', array(
+ 'fd' => array(
+ 'entity_id' => array('type' =>
'varchar','precision' => 20,'nullable' => False),
+ 'invest_id' => array('type' =>
'int','precision' => 4,'nullable' => False),
+ 'index_count' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'default' => 0,'nullable' => True),
+ 'initial_value' => array('type' =>
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => True),
+ 'value' => array('type' =>
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => True),
+ 'date' => array('type' => 'timestamp',
'nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array('entity_id','invest_id','index_count' ),
'fk' => array(),
'ix' => array(),
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_update.inc.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** tables_update.inc.php 21 Sep 2002 14:56:10 -0000 1.11
--- tables_update.inc.php 30 Sep 2002 16:28:00 -0000 1.12
***************
*** 307,310 ****
--- 307,377 ----
}
+ $test[] = '0.1.1.009';
+ function property_upgrade0_1_1_009()
+ {
+ global $setup_info, $phpgw_setup;
+
+ $phpgw_setup->oProc->DropTable('fm_property_value');
+
+ $phpgw_setup->oProc->CreateTable(
+ 'fm_investment', array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
4,'nullable' => False),
+ 'location_code' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'objekt_id' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'cost_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'descr' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'type' => array('type' => 'int', 'precision' =>
4,'nullable' => False),
+ 'bygg_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False),
+ 'equipment_id' => array('type' => 'int',
'precision' => 4,'nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+
+ )
+ );
+ $phpgw_setup->oProc->CreateTable(
+ 'fm_investment_value', array(
+ 'fd' => array(
+ 'entity_id' => array('type' =>
'varchar','precision' => 20,'nullable' => False),
+ 'invest_id' => array('type' =>
'int','precision' => 4,'nullable' => False),
+ 'index_count' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'default' => 0,'nullable' => True),
+ 'initial_value' => array('type' =>
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => True),
+ 'value' => array('type' =>
'decimal','precision' => 20,'scale' => 2,'default' => 0,'nullable' => True),
+ 'date' => array('type' => 'timestamp',
'nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array('entity_id','invest_id','index_count' ),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+
+ )
+ );
+
+ $phpgw_setup->oProc->CreateTable(
+ 'fm_event_receipt', array(
+ 'fd' => array(
+ 'cal_id' => array('type' => 'int','precision'
=> 4,'nullable' => False),
+ 'year_month_date' => array('type' => 'int',
'precision' => 4,'nullable' => False),
+ 'datetime_done' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'datetime_reject' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True)
+ ),
+ 'pk' => array('cal_id','year_month_date'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
+
+
+ $setup_info['property']['currentver'] = '0.1.1.010';
+ return $setup_info['property']['currentver'];
+ }
+
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** setup.inc.php 18 Sep 2002 19:54:15 -0000 1.9
--- setup.inc.php 30 Sep 2002 16:28:00 -0000 1.10
***************
*** 10,14 ****
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
! $setup_info['property']['version'] = '0.1.1.009';
$setup_info['property']['app_order'] = 14;
$setup_info['property']['enable'] = 1;
--- 10,14 ----
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
! $setup_info['property']['version'] = '0.1.1.010';
$setup_info['property']['app_order'] = 14;
$setup_info['property']['enable'] = 1;
***************
*** 59,63 ****
'fm_wo_project',
'fm_wo_projectbranch',
- 'fm_property_value',
'phpgw_fm_tts_tickets',
'phpgw_fm_tts_views',
--- 59,62 ----
***************
*** 71,75 ****
't_ecologg',
't_ecomva',
! 'fm_admin'
);
--- 70,77 ----
't_ecologg',
't_ecomva',
! 'fm_admin',
! 'fm_investment',
! 'fm_investment_value',
! 'fm_event_receipt'
);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup tables_current.inc.php,1.12,1.13 tables_update.inc.php,1.11,1.12 setup.inc.php,1.9,1.10,
Sigurd Nes <address@hidden> <=