[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup setup.inc.php, 1.8 default_records.inc
|
From: |
sigurdne |
|
Subject: |
[Phpgroupware-cvs] property/setup setup.inc.php, 1.8 default_records.inc.php, 1.6 tables_current.inc.php, 1.18 tables_update.inc.php, 1.3 |
|
Date: |
Thu, 24 Feb 2005 14:36:36 -0000 |
Update of property/setup
Modified Files:
Branch: MAIN
setup.inc.php lines: +24 -17
default_records.inc.php lines: +27 -18
tables_current.inc.php lines: +80 -65
tables_update.inc.php lines: +25 -14
Log Message:
no message
====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.7 property/setup/setup.inc.php:1.8
--- property/setup/setup.inc.php:1.7 Fri Oct 22 13:59:42 2004
+++ property/setup/setup.inc.php Fri Jan 14 08:50:50 2005
@@ -1,20 +1,26 @@
<?php
-
/**************************************************************************\
- * phpGroupWare - property
*
- * http://www.phpgroupware.org
*
- *
*
- * Facilities Management
*
- * Written by Sigurd Nes [sigurdne at online.no]
*
- *
------------------------------------------------------------------------ *
- * Copyright 2000 - 2003 Free Software Foundation, Inc
*
- * This program is part of the GNU project, see http://www.gnu.org/
*
- *
------------------------------------------------------------------------ *
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by the
*
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
- /* $Id$ */
+ /**
+ * phpGroupWare - property
+ * address@hidden http://www.phpgroupware.org}
+ *
+ * Property: a Facilities Management System.
+ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
+ * This program is part of the GNU project, see address@hidden
http://www.gnu.org/}
+ *
+ * This program is free software; you can redistribute it and/or modify
it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * To contact the author write to address@hidden mailto:address@hidden
Sigurd Nes}
+ *
+ * This is the setup information
+ * @author Sigurd Nes
+ * @package property
+ * @subpackage setup
+ * @version $Id$
+ */
$setup_info['property']['name'] = 'property';
$setup_info['property']['version'] = '0.9.15.001';
@@ -189,7 +195,8 @@
'fm_s_agreement_choice',
'fm_s_agreement_detail',
'fm_s_agreement_pricing',
- 'fm_async_method'
+ 'fm_async_method',
+ 'fm_cron_log'
);
/* The hooks this app includes, needed for hooks registration */
====================================================
Index: property/setup/default_records.inc.php
diff -u property/setup/default_records.inc.php:1.5
property/setup/default_records.inc.php:1.6
--- property/setup/default_records.inc.php:1.5 Fri Aug 6 20:16:49 2004
+++ property/setup/default_records.inc.php Fri Jan 14 08:50:50 2005
@@ -1,22 +1,30 @@
<?php
-
/**************************************************************************\
- * phpGroupWare - property
*
- * http://www.phpgroupware.org
*
- *
*
- * Facilities Management
*
- * Written by Sigurd Nes [sigurdne at online.no]
*
- *
------------------------------------------------------------------------ *
- * Copyright 2000 - 2003 Free Software Foundation, Inc
*
- * This program is part of the GNU project, see http://www.gnu.org/
*
- *
------------------------------------------------------------------------ *
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by the
*
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
-
- /* $Id$ */
-
+ /**
+ * phpGroupWare - property
+ * address@hidden http://www.phpgroupware.org}
+ *
+ * Property: a Facilities Management System.
+ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
+ * This program is part of the GNU project, see address@hidden
http://www.gnu.org/}
+ *
+ * This program is free software; you can redistribute it and/or modify
it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * To contact the author write to address@hidden mailto:address@hidden
Sigurd Nes}
+ * @author Sigurd Nes
+ * @package property
+ * @subpackage setup
+ * @version $Id$
+ */
+
+
+ /**
+ * Description
+ * @package property
+ */
#
#fm_workorder_category
#
@@ -204,6 +212,7 @@
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr,
allow_grant) VALUES ('.entity.2.1', 'Report type 1', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr,
allow_grant) VALUES ('.entity.2.2', 'Report type 2', 1)");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr)
VALUES ('.s_agreement', 'Service agreement')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr)
VALUES ('.b_account', 'Budget account')");
#
====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.17
property/setup/tables_current.inc.php:1.18
--- property/setup/tables_current.inc.php:1.17 Sat Oct 23 22:11:00 2004
+++ property/setup/tables_current.inc.php Fri Jan 14 08:50:50 2005
@@ -1,28 +1,27 @@
<?php
-
/**************************************************************************\
- * phpGroupWare - property
*
- * http://www.phpgroupware.org
*
- *
*
- * Facilities Management
*
- * Written by Sigurd Nes [sigurdne at online.no]
*
- *
------------------------------------------------------------------------ *
- * Copyright 2000 - 2003 Free Software Foundation, Inc
*
- * This program is part of the GNU project, see http://www.gnu.org/
*
- *
------------------------------------------------------------------------ *
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by the
*
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
-
- /**************************************************************************\
- * This file should be generated for you by setup. It should not need to be *
- * edited by hand. *
- \**************************************************************************/
+ /**
+ * phpGroupWare - property
+ * address@hidden http://www.phpgroupware.org}
+ *
+ * Property: a Facilities Management System.
+ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
+ * This program is part of the GNU project, see address@hidden
http://www.gnu.org/}
+ *
+ * This program is free software; you can redistribute it and/or modify
it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * To contact the author write to address@hidden mailto:address@hidden
Sigurd Nes}
+ *
+ * This is the current set of tables for the app property
+ * @author Sigurd Nes
+ * @package property
+ * @subpackage setup
+ * @version $Id$
+ */
- /* $Id$ */
-
- /* table array for property */
$phpgw_baseline = array(
'fm_part_of_town' => array(
'fd' => array(
@@ -47,7 +46,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'split' => array('type' => 'int','precision' =>
'2','nullable' => True),
'remark' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'owner' => array('type' =>
'varchar','precision' => '5','nullable' => True),
@@ -72,7 +71,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True)
@@ -95,7 +94,7 @@
'fm_streetaddress' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False)
+ 'descr' => array('type' =>
'varchar','precision' => '150','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
@@ -105,6 +104,7 @@
'fm_tenant' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'first_name' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'last_name' => array('type' =>
'varchar','precision' => '30','nullable' => True),
@@ -166,7 +166,7 @@
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'org_name' => array('type' =>
'varchar','precision' => '100','nullable' => True),
'email' => array('type' =>
'varchar','precision' => '64','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'klasse' => array('type' =>
'varchar','precision' => '10','nullable' => True),
@@ -454,7 +454,7 @@
),
'fm_drawing' => array(
'fd' => array(
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'title' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'drawing_name' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
@@ -466,7 +466,7 @@
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => False),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
@@ -541,7 +541,7 @@
'act_vendor_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'addition' => array('type' => 'int','precision'
=> '4','nullable' => True),
'rig_addition' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'account_id' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'key_fetch' => array('type' =>
'int','precision' => '4','nullable' => True),
'key_deliver' => array('type' =>
'int','precision' => '4','nullable' => True),
'integration' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -694,7 +694,7 @@
'w_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'total_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'date' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'index_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True)
),
'pk' =>
array('activity_id','agreement_id','index_count'),
@@ -836,7 +836,7 @@
'owner' => array('type' => 'int','precision' =>
'4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -942,7 +942,7 @@
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -957,7 +957,7 @@
'fm_tts_views' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'account_id' => array('type' =>
'varchar','precision' => '40','nullable' => True),
+ 'account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'time' => array('type' => 'int','precision' =>
'4','nullable' => False)
),
'pk' => array(),
@@ -990,8 +990,8 @@
'fd' => array(
'bilagsnr' => array('type' => 'int','precision'
=> '4','nullable' => False),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
- 'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
@@ -999,11 +999,11 @@
'saksbehandlerid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'budsjettansvarligid' => array('type' =>
'varchar','precision' => '12','nullable' => False),
'utbetalingid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
- 'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'saksigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'overftid' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
+ 'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'saksigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'overftid' => array('type' =>
'timestamp','nullable' => True)
),
'pk' => array('bilagsnr'),
'ix' => array(),
@@ -1021,12 +1021,12 @@
'kostra_id' => array('type' =>
'varchar','precision' => '8','nullable' => True),
'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
- 'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
- 'regtid' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'regtid' => array('type' =>
'timestamp','nullable' => False),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
@@ -1039,10 +1039,10 @@
'saksbehandlerid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'budsjettansvarligid' => array('type' =>
'varchar','precision' => '12','nullable' => False),
'utbetalingid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
- 'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'saksigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
- 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
+ 'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'saksigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True),
'merknad' => array('type' => 'text','nullable'
=> True),
'splitt' => array('type' => 'int','precision'
=> '2','nullable' => True),
'kreditnota' => array('type' =>
'int','precision' => '2','nullable' => True),
@@ -1064,12 +1064,12 @@
'kostra_id' => array('type' =>
'varchar','precision' => '8','nullable' => True),
'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
- 'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
- 'regtid' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'regtid' => array('type' =>
'timestamp','nullable' => False),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
@@ -1085,7 +1085,7 @@
'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True),
'saksigndato' => array('type' =>
'timestamp','nullable' => True),
'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
- 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
+ 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True),
'overftid' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'ordrebelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
'merknad' => array('type' => 'text','nullable'
=> True),
@@ -1243,7 +1243,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'key_fetch' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1295,7 +1295,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'writeoff_year' => array('type' =>
'int','precision' => '4','nullable' => True)
),
@@ -1313,7 +1313,7 @@
'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')
+ 'index_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
),
'pk' => array('entity_id','invest_id','index_count'),
'fk' => array(),
@@ -1352,7 +1352,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => True),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1490,7 +1490,8 @@
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'abid' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'contact_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True),
@@ -1605,7 +1606,8 @@
'tracking' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_level' => array('type' =>
'int','precision' => '4','nullable' => True),
'fileupload' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'loc_link' => array('type' => 'int','precision'
=> '4','nullable' => True)
+ 'loc_link' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'start_project' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('entity_id','id'),
'fk' => array(),
@@ -1662,7 +1664,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1691,7 +1693,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1720,7 +1722,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1749,7 +1751,7 @@
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
- 'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'address' => array('type' =>
'varchar','precision' => '150','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
@@ -1819,7 +1821,7 @@
'termination_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
- 'account_id' => array('type' => 'int',
'precision' => 4,'nullable' => True)
+ 'account_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
@@ -1881,7 +1883,7 @@
'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
'location_code' => array('type' => 'varchar',
'precision' => 30,'nullable' => True),
- 'address' => array('type' => 'varchar',
'precision' => 100,'nullable' => True),
+ 'address' => array('type' => 'varchar',
'precision' => 150,'nullable' => True),
'p_num' => array('type' => 'varchar',
'precision' => 15,'nullable' => True),
'p_entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
'p_cat_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
@@ -1908,7 +1910,7 @@
'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'nullable' => True),
'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
- 'date' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
+ 'index_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True)
),
@@ -1928,5 +1930,18 @@
'fk' => array(),
'ix' => array(),
'uc' => array()
+ ),
+ 'fm_cron_log' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
+ 'cron' => array('type' => 'int','precision' =>
'2','nullable' => True),
+ 'cron_date' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'process' => array('type' =>
'varchar','precision' => '255','nullable' => False),
+ 'message' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
)
);
====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.2
property/setup/tables_update.inc.php:1.3
--- property/setup/tables_update.inc.php:1.2 Wed Jun 2 18:42:33 2004
+++ property/setup/tables_update.inc.php Fri Jan 14 08:50:50 2005
@@ -1,22 +1,33 @@
<?php
-
/**************************************************************************\
- * phpGroupWare - Setup
*
- * http://www.phpgroupware.org
*
- * --------------------------------------------
*
- * This program is free software; you can redistribute it and/or modify
it *
- * under the terms of the GNU General Public License as published by
the *
- * Free Software Foundation; either version 2 of the License, or (at
your *
- * option) any later version.
*
-
\**************************************************************************/
- /* $Id$ */
+ /**
+ * phpGroupWare - property
+ * address@hidden http://www.phpgroupware.org}
+ *
+ * Property: a Facilities Management System.
+ *
+ * Copyright 2000 - 2003 Free Software Foundation, Inc
+ * This program is part of the GNU project, see address@hidden
http://www.gnu.org/}
+ *
+ * This program is free software; you can redistribute it and/or modify
it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * To contact the author write to address@hidden mailto:address@hidden
Sigurd Nes}
+ * @author Sigurd Nes
+ * @package property
+ * @subpackage setup
+ * @version $Id$
+ */
+
+ /**
+ * Update property version from 0.9.15.001 to 0.9.15.002
+ */
- /* Include older phpGroupWare update support */
$test[] = '0.9.15.001';
function property_upgrade0_9_15_001()
{
-
$GLOBALS['phpgw_setup']->oProc->RenameColumn('fm_entity_1_1','attribute7','attribute8');
-
$GLOBALS['setup_info']['property']['currentver'] = '0.9.15.002';
- return $GLOBALS['setup_info']['projects']['currentver'];
+ return $GLOBALS['setup_info']['property']['currentver'];
}
?>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup setup.inc.php, 1.8 default_records.inc.php, 1.6 tables_current.inc.php, 1.18 tables_update.inc.php, 1.3,
sigurdne <=
- Prev by Date:
[Phpgroupware-cvs] bookkeeping/setup setup.inc.php,1.17
- Next by Date:
[Phpgroupware-cvs] property/tutorials/property property.pkg, 1.2 prizebook_index.png, 1.2 property.pkg.ini, 1.2 project_structure.png, 1.2 update.apache.php.pkg, 1.2 tts_use.png, 1.2 prizebook.png, 1.2 lookup_vendor.png, 1.2 location_conf.gif, 1.2 admin_access.png, 1.2 architecture.pkg, 1.2
- Previous by thread:
[Phpgroupware-cvs] bookkeeping/setup setup.inc.php,1.17
- Next by thread:
[Phpgroupware-cvs] property/tutorials/property property.pkg, 1.2 prizebook_index.png, 1.2 property.pkg.ini, 1.2 project_structure.png, 1.2 update.apache.php.pkg, 1.2 tts_use.png, 1.2 prizebook.png, 1.2 lookup_vendor.png, 1.2 location_conf.gif, 1.2 admin_access.png, 1.2 architecture.pkg, 1.2
- Index(es):