[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.6 phpgw_no.la
From: |
sigurdne |
Subject: |
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.6 phpgw_no.lang, 1.5 tables_current.inc.php, 1.25 setup.inc.php, 1.13 default_records.inc.php, 1.10 |
Date: |
Thu, 14 Apr 2005 16:49:00 +0200 |
Update of property/setup
Modified Files:
Branch: MAIN
tables_update.inc.php lines: +54 -1
phpgw_no.lang lines: +3 -1
tables_current.inc.php lines: +34 -6
setup.inc.php lines: +5 -3
default_records.inc.php lines: +2 -1
Log Message:
no message
====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.5
property/setup/tables_update.inc.php:1.6
--- property/setup/tables_update.inc.php:1.5 Tue Mar 15 08:47:19 2005
+++ property/setup/tables_update.inc.php Thu Apr 14 14:49:01 2005
@@ -115,4 +115,57 @@
return $GLOBALS['setup_info']['property']['currentver'];
}
+ /**
+ * Update property version from 0.9.17.502 to 0.9.17.503
+ */
+
+ $test[] = '0.9.17.502';
+ function property_upgrade0_9_17_502()
+ {
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('fm_acl_location','id',array('type'
=> 'varchar','precision' => '20','nullable' => False));
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
fm_acl_location (id, descr) VALUES ('.tenant_claim', 'Tenant claim')");
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable(
+ 'fm_tenant_claim_category', array(
+ 'fd' => array(
+ 'id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
fm_tenant_claim_category (id, descr) VALUES (1, 'Type 1')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
fm_tenant_claim_category (id, descr) VALUES (2, 'Type 2')");
+
+ $GLOBALS['phpgw_setup']->oProc->CreateTable(
+ 'fm_tenant_claim', array(
+ 'fd' => array(
+ 'id' => array('type' =>
'auto','precision' => '4','nullable' => False),
+ 'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'amount' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
+ 'b_account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'status' => array('type' =>
'varchar','precision' => '8','nullable' => True),
+ 'remark' => array('type' =>
'text','nullable' => True),
+ 'user_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
+
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_workorder','claim_issued',array('type'
=> 'int','precision' => 2,'nullable' => True));
+
+ $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.503';
+ return $GLOBALS['setup_info']['property']['currentver'];
+ }
+
?>
====================================================
Index: property/setup/phpgw_no.lang
diff -u property/setup/phpgw_no.lang:1.4 property/setup/phpgw_no.lang:1.5
--- property/setup/phpgw_no.lang:1.4 Mon Mar 7 09:54:58 2005
+++ property/setup/phpgw_no.lang Thu Apr 14 14:49:01 2005
@@ -869,7 +869,7 @@
Street name property no Gatenavn
street number property no gate nr
Street number property no GateNr
-Subject property no Subjekt
+Subject property no Overskrift
Subject changed property no Emne er endret
Submit the search string property no Send søkestrengen
Sum property no Sum
@@ -882,7 +882,9 @@
template %1 is added property no mal %1 er lagt til
Template ID property no Mal ID
Tenant property no Leieboer
+Tenant claim is not issued for project in voucher %1 property no
Krav mot leietaker er ikke registert for prosjekt i bilag %1
Tenant phone property no Leieboer tlf
+termination date property no oppsigelse dato
Text property no Tekst
That Vendor ID is not valid ! property no Denne leverandør ID er
ikke gyldig
The address to which this order will be sendt property no
Adressen ordren vil bli sendt til
====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.24
property/setup/tables_current.inc.php:1.25
--- property/setup/tables_current.inc.php:1.24 Tue Mar 15 08:47:19 2005
+++ property/setup/tables_current.inc.php Thu Apr 14 14:49:01 2005
@@ -511,8 +511,9 @@
'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),
- 'charge_tenant' => array('type' =>
'int','precision' => '2','nullable' => True)
- ),
+ 'charge_tenant' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'claim_issued' => array('type' =>
'int','precision' => '2','nullable' => True)
+ ),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
@@ -1203,8 +1204,7 @@
'key_fetch' => array('type' =>
'int','precision' => '4','nullable' => True),
'key_deliver' => array('type' =>
'int','precision' => '4','nullable' => True),
'other_branch' => array('type' =>
'varchar','precision' => '255','nullable' => True),
- 'key_responsible' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'charge_tenant' => array('type' =>
'int','precision' => '2','nullable' => True)
+ 'key_responsible' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
@@ -1329,7 +1329,7 @@
),
'fm_acl_location' => array(
'fd' => array(
- 'id' => array('type' => 'varchar','precision'
=> '12','nullable' => False),
+ 'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'allow_grant' => array('type' =>
'int','precision' => '4','nullable' => True)
),
@@ -1913,5 +1913,33 @@
'fk' => array(),
'ix' => array(),
'uc' => array()
+ ),
+ 'fm_tenant_claim' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
+ 'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'amount' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
+ 'b_account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'status' => array('type' =>
'varchar','precision' => '8','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_tenant_claim_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
)
);
====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.12 property/setup/setup.inc.php:1.13
--- property/setup/setup.inc.php:1.12 Tue Mar 15 08:47:19 2005
+++ property/setup/setup.inc.php Thu Apr 14 14:49:01 2005
@@ -24,7 +24,7 @@
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
- $setup_info['property']['version'] = '0.9.17.502';
+ $setup_info['property']['version'] = '0.9.17.503';
$setup_info['property']['app_order'] = 8;
$setup_info['property']['enable'] = 1;
@@ -192,7 +192,9 @@
'fm_s_agreement_pricing',
'fm_async_method',
'fm_cron_log',
- 'fm_origin'
+ 'fm_origin',
+ 'fm_tenant_claim',
+ 'fm_tenant_claim_category'
);
/* 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.9
property/setup/default_records.inc.php:1.10
--- property/setup/default_records.inc.php:1.9 Sat Jan 29 18:40:26 2005
+++ property/setup/default_records.inc.php Thu Apr 14 14:49:01 2005
@@ -215,6 +215,7 @@
$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')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_acl_location (id, descr)
VALUES ('.tenant_claim', 'Tenant claim')");
#
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.6 phpgw_no.lang, 1.5 tables_current.inc.php, 1.25 setup.inc.php, 1.13 default_records.inc.php, 1.10,
sigurdne <=
- Prev by Date:
[Phpgroupware-cvs] property/templates/base location.xsl, 1.2 project.xsl, 1.3 invoice.xsl, 1.2 tenant_claim.xsl, 1.1
- Next by Date:
[Phpgroupware-cvs] property/inc class.uiinvoice.inc.php, 1.14 class.uiproject.inc.php, 1.14 class.menu.inc.php, 1.10 class.uitenant_claim.inc.php, 1.2 class.soinvoice.inc.php, 1.11 class.uiworkorder.inc.php, 1.6 class.soworkorder.inc.php, 1.5 class.soproject.inc.php, 1.18 class.botenant_claim.inc.php, 1.2 class.sotenant_claim.inc.php, 1.2 class.boproject.inc.php, 1.9
- Previous by thread:
[Phpgroupware-cvs] property/templates/base location.xsl, 1.2 project.xsl, 1.3 invoice.xsl, 1.2 tenant_claim.xsl, 1.1
- Next by thread:
[Phpgroupware-cvs] property/inc class.uiinvoice.inc.php, 1.14 class.uiproject.inc.php, 1.14 class.menu.inc.php, 1.10 class.uitenant_claim.inc.php, 1.2 class.soinvoice.inc.php, 1.11 class.uiworkorder.inc.php, 1.6 class.soworkorder.inc.php, 1.5 class.soproject.inc.php, 1.18 class.botenant_claim.inc.php, 1.2 class.sotenant_claim.inc.php, 1.2 class.boproject.inc.php, 1.9
- Index(es):