[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/setup setup.inc.php,1.20,1.21 tables_cu
From: |
Sigurd Nes <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: property/setup setup.inc.php,1.20,1.21 tables_current.inc.php,1.34,1.35 |
Date: |
Tue, 18 Feb 2003 15:38:25 -0500 |
Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv4026/setup
Modified Files:
setup.inc.php tables_current.inc.php
Log Message:
no message
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -r1.20 -r1.21
*** setup.inc.php 15 Feb 2003 19:51:40 -0000 1.20
--- setup.inc.php 18 Feb 2003 20:38:20 -0000 1.21
***************
*** 33,45 ****
$setup_info['property']['tables'] = array(
'boei_bydel',
! 'boei_bygg',
'boei_formaal',
! 'boei_gabnr',
! 'boei_gateadresse',
! 'boei_leieobjekt',
! 'boei_leietaker',
! 'boei_objekt',
! 'boei_omraade',
! 'boei_seksjon',
'fm_equipment',
'fm_equipment_status',
--- 33,45 ----
$setup_info['property']['tables'] = array(
'boei_bydel',
! 'fm_building',
'boei_formaal',
! 'fm_gabnr',
! 'fm_streetaddress',
! 'fm_apartment',
! 'fm_tenant',
! 'fm_property',
! 'fm_district',
! 'fm_entrance',
'fm_equipment',
'fm_equipment_status',
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -r1.34 -r1.35
*** tables_current.inc.php 18 Feb 2003 09:13:57 -0000 1.34
--- tables_current.inc.php 18 Feb 2003 20:38:20 -0000 1.35
***************
*** 23,27 ****
'bydel_id' => array('type' => 'int','precision'
=> '2','nullable' => False),
'bydel' => array('type' => 'char','precision'
=> '20','nullable' => True),
! 'omraade_id' => array('type' =>
'int','precision' => '2','nullable' => True),
'BD_Adresse' => array('type' =>
'char','precision' => '50','nullable' => True),
'BD_Adresse1' => array('type' =>
'char','precision' => '50','nullable' => True),
--- 23,27 ----
'bydel_id' => array('type' => 'int','precision'
=> '2','nullable' => False),
'bydel' => array('type' => 'char','precision'
=> '20','nullable' => True),
! 'district_id' => array('type' =>
'int','precision' => '2','nullable' => True),
'BD_Adresse' => array('type' =>
'char','precision' => '50','nullable' => True),
'BD_Adresse1' => array('type' =>
'char','precision' => '50','nullable' => True),
***************
*** 37,47 ****
'uc' => array()
),
! 'boei_bygg' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'bygg_id' => array('type' => 'char','precision'
=> '2','nullable' => False),
! 'byggnavn' => array('type' =>
'varchar','precision' => '50','nullable' => True),
! 'generelladresse' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'Driftstatus' => array('type' =>
'int','precision' => '2','nullable' => True),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => True),
--- 37,47 ----
'uc' => array()
),
! 'fm_building' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'building_id' => array('type' =>
'char','precision' => '2','nullable' => False),
! 'building_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
! 'general_address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'Driftstatus' => array('type' =>
'int','precision' => '2','nullable' => True),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => True),
***************
*** 60,64 ****
'KjellerAreal' => array('type' =>
'int','precision' => '2','nullable' => True),
'TakAreal' => array('type' => 'int','precision'
=> '2','nullable' => True),
! 'Antalletasjer' => array('type' =>
'int','precision' => '2','nullable' => True),
'ArkitektTegninger' => array('type' =>
'int','precision' => '2','nullable' => True),
'Byggtegninger' => array('type' =>
'int','precision' => '2','nullable' => True),
--- 60,64 ----
'KjellerAreal' => array('type' =>
'int','precision' => '2','nullable' => True),
'TakAreal' => array('type' => 'int','precision'
=> '2','nullable' => True),
! 'Antallfloorr' => array('type' =>
'int','precision' => '2','nullable' => True),
'ArkitektTegninger' => array('type' =>
'int','precision' => '2','nullable' => True),
'Byggtegninger' => array('type' =>
'int','precision' => '2','nullable' => True),
***************
*** 78,90 ****
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('objekt_id','bygg_id'),
! 'fk' => array('objekt_id' => 'boei_objekt.objekt_id'),
'ix' => array(),
'uc' => array()
),
! 'boei_formaal' => array(
'fd' => array(
! 'formaal_id' => array('type' =>
'int','precision' => '2','nullable' => False),
! 'navnpaaformaal' => array('type' =>
'char','precision' => '15','nullable' => True),
'AntallGiroVedMasseproduksjon' => array('type'
=> 'int','precision' => '2','nullable' => True),
'AntallGiroVedInnflytting' => array('type' =>
'int','precision' => '2','nullable' => True),
--- 78,90 ----
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('property_id','building_id'),
! 'fk' => array('property_id' =>
'fm_property.property_id'),
'ix' => array(),
'uc' => array()
),
! 'fm_apartment_category' => array(
'fd' => array(
! 'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
! 'descr' => array('type' => 'char','precision'
=> '15','nullable' => True),
'AntallGiroVedMasseproduksjon' => array('type'
=> 'int','precision' => '2','nullable' => True),
'AntallGiroVedInnflytting' => array('type' =>
'int','precision' => '2','nullable' => True),
***************
*** 102,111 ****
'uc' => array()
),
! 'boei_gabnr' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'bygg_id' => array('type' => 'char','precision'
=> '2','nullable' => False),
! 'seksjons_id' => array('type' =>
'char','precision' => '2','nullable' => False),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'Felles_BBE' => array('type' =>
'int','precision' => '4','nullable' => True),
--- 102,111 ----
'uc' => array()
),
! 'fm_gabnr' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'building_id' => array('type' =>
'char','precision' => '2','nullable' => False),
! 'entrance_id' => array('type' =>
'char','precision' => '2','nullable' => False),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'Felles_BBE' => array('type' =>
'int','precision' => '4','nullable' => True),
***************
*** 113,144 ****
'Spredning' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' =>
array('objekt_id','bygg_id','seksjons_id','gabnr'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_gateadresse' => array(
'fd' => array(
! 'gateadresse_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'gatenavn' => array('type' =>
'char','precision' => '50','nullable' => True)
),
! 'pk' => array('gateadresse_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_leieobjekt' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'leie_id' => array('type' => 'char','precision'
=> '3','nullable' => False),
'Flyttenr' => array('type' =>
'char','precision' => '2','nullable' => True),
'Leieobjekttype_ID' => array('type' =>
'char','precision' => '1','nullable' => True),
! 'bygg_id' => array('type' => 'char','precision'
=> '2','nullable' => True),
! 'seksjons_id' => array('type' =>
'char','precision' => '2','nullable' => True),
'Kategori_ID' => array('type' =>
'char','precision' => '2','nullable' => True),
! 'gateadresse_id' => array('type' =>
'int','precision' => '4','nullable' => True),
! 'gatenr' => array('type' =>
'varchar','precision' => '10','nullable' => True),
! 'etasje' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'AntallRom' => array('type' =>
'int','precision' => '2','nullable' => True),
'Boareal' => array('type' => 'int','precision'
=> '4','nullable' => True),
--- 113,144 ----
'Spredning' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' =>
array('property_id','building_id','entrance_id','gabnr'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_streetaddress' => array(
'fd' => array(
! 'street_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'street_name' => array('type' =>
'char','precision' => '50','nullable' => True)
),
! 'pk' => array('street_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_apartment' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'apartment_id' => array('type' =>
'char','precision' => '3','nullable' => False),
'Flyttenr' => array('type' =>
'char','precision' => '2','nullable' => True),
'Leieobjekttype_ID' => array('type' =>
'char','precision' => '1','nullable' => True),
! 'building_id' => array('type' =>
'char','precision' => '2','nullable' => True),
! 'entrance_id' => array('type' =>
'char','precision' => '2','nullable' => True),
'Kategori_ID' => array('type' =>
'char','precision' => '2','nullable' => True),
! 'street_id' => array('type' =>
'int','precision' => '4','nullable' => True),
! 'street_number' => array('type' =>
'varchar','precision' => '10','nullable' => True),
! 'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'AntallRom' => array('type' =>
'int','precision' => '2','nullable' => True),
'Boareal' => array('type' => 'int','precision'
=> '4','nullable' => True),
***************
*** 154,158 ****
'AvhendetDato' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'Husleiesaken' => array('type' =>
'int','precision' => '2','nullable' => True),
! 'leietaker_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'Husleie' => array('type' => 'int','precision'
=> '4','nullable' => True),
'StromBrensel' => array('type' =>
'int','precision' => '4','nullable' => True),
--- 154,158 ----
'AvhendetDato' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'Husleiesaken' => array('type' =>
'int','precision' => '2','nullable' => True),
! 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'Husleie' => array('type' => 'int','precision'
=> '4','nullable' => True),
'StromBrensel' => array('type' =>
'int','precision' => '4','nullable' => True),
***************
*** 166,170 ****
'Seksjonsnr' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'Beregnet_BOA' => array('type' =>
'int','precision' => '2','nullable' => True),
! 'etasje_beskrivelse' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'ReturNklFraOppsynsmann' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'Kategori' => array('type' =>
'char','precision' => '2','nullable' => True),
--- 166,170 ----
'Seksjonsnr' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'Beregnet_BOA' => array('type' =>
'int','precision' => '2','nullable' => True),
! 'floor_beskrivelse' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'ReturNklFraOppsynsmann' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'Kategori' => array('type' =>
'char','precision' => '2','nullable' => True),
***************
*** 187,200 ****
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('objekt_id','leie_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_leietaker' => array(
'fd' => array(
! 'leietaker_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'fornavn' => array('type' => 'char','precision'
=> '30','nullable' => True),
! 'etternavn' => array('type' =>
'char','precision' => '30','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'Kjonn_Juridisk' => array('type' =>
'int','precision' => '2','nullable' => True),
--- 187,200 ----
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('property_id','apartment_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_tenant' => array(
'fd' => array(
! 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => False),
! 'first_name' => array('type' =>
'char','precision' => '30','nullable' => True),
! 'last_name' => array('type' =>
'char','precision' => '30','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'Kjonn_Juridisk' => array('type' =>
'int','precision' => '2','nullable' => True),
***************
*** 209,223 ****
'AntallNklInnlevert' => array('type' =>
'int','precision' => '2','nullable' => True)
),
! 'pk' => array('leietaker_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_objekt' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
'navn' => array('type' => 'varchar','precision'
=> '50','nullable' => True),
! 'generelladresse' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'bydel_id' => array('type' => 'int','precision'
=> '2','nullable' => True),
'Postnr_ID' => array('type' =>
'varchar','precision' => '4','nullable' => True),
--- 209,223 ----
'AntallNklInnlevert' => array('type' =>
'int','precision' => '2','nullable' => True)
),
! 'pk' => array('tenant_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_property' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
'navn' => array('type' => 'varchar','precision'
=> '50','nullable' => True),
! 'general_address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'bydel_id' => array('type' => 'int','precision'
=> '2','nullable' => True),
'Postnr_ID' => array('type' =>
'varchar','precision' => '4','nullable' => True),
***************
*** 235,261 ****
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('objekt_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_omraade' => array(
'fd' => array(
! 'omraade_id' => array('type' =>
'int','precision' => '2','nullable' => False),
! 'Omraade' => array('type' => 'char','precision'
=> '20','nullable' => True)
),
! 'pk' => array('omraade_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'boei_seksjon' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'bygg_id' => array('type' => 'char','precision'
=> '2','nullable' => False),
! 'seksjons_id' => array('type' =>
'char','precision' => '2','nullable' => False),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => True),
! 'beskrivelse' => array('type' =>
'varchar','precision' => '35','nullable' => True),
'Totalt_Fellesareal' => array('type' =>
'int','precision' => '2','nullable' => True),
'tid' => array('type' => 'char','precision' =>
'1','nullable' => True),
--- 235,261 ----
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('property_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_district' => array(
'fd' => array(
! 'district_id' => array('type' =>
'int','precision' => '2','nullable' => False),
! 'district' => array('type' =>
'char','precision' => '20','nullable' => True)
),
! 'pk' => array('district_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
! 'fm_entrance' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => True),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'building_id' => array('type' =>
'char','precision' => '2','nullable' => False),
! 'entrance_id' => array('type' =>
'char','precision' => '2','nullable' => False),
'gabnr' => array('type' =>
'varchar','precision' => '20','nullable' => True),
! 'description' => array('type' =>
'varchar','precision' => '35','nullable' => True),
'Totalt_Fellesareal' => array('type' =>
'int','precision' => '2','nullable' => True),
'tid' => array('type' => 'char','precision' =>
'1','nullable' => True),
***************
*** 267,272 ****
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' => array('objekt_id','bygg_id','seksjons_id'),
! 'fk' => array('objekt_id' =>
'boei_bygg.objekt_id','bygg_id' => 'boei_bygg.bygg_id'),
'ix' => array(),
'uc' => array()
--- 267,272 ----
'property_type_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
! 'pk' =>
array('property_id','building_id','entrance_id'),
! 'fk' => array('property_id' =>
'fm_building.property_id','building_id' => 'fm_building.building_id'),
'ix' => array(),
'uc' => array()
***************
*** 506,513 ****
'fd' => array(
'fullt_filnavn' => array('type' =>
'varchar','precision' => '255','nullable' => False),
! 'objekt_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'bygg_id' => array('type' =>
'varchar','precision' => '2','nullable' => False),
! 'seksjons_id' => array('type' =>
'varchar','precision' => '2','nullable' => False),
! 'etasje_id' => array('type' =>
'varchar','precision' => '8','nullable' => False),
'tegningsfil' => array('type' =>
'varchar','precision' => '23','nullable' => True)
),
--- 506,513 ----
'fd' => array(
'fullt_filnavn' => array('type' =>
'varchar','precision' => '255','nullable' => False),
! 'property_id' => array('type' =>
'varchar','precision' => '4','nullable' => False),
! 'building_id' => array('type' =>
'varchar','precision' => '2','nullable' => False),
! 'entrance_id' => array('type' =>
'varchar','precision' => '2','nullable' => False),
! 'floor_id' => array('type' =>
'varchar','precision' => '8','nullable' => False),
'tegningsfil' => array('type' =>
'varchar','precision' => '23','nullable' => True)
),
***************
*** 563,573 ****
'equipment_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
'equipment_type' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'objekt_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'bygg_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'seksjons_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'etasje' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'leie_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
--- 563,573 ----
'equipment_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
'equipment_type' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'property_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'building_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'entrance_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'floor' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'apartment_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
***************
*** 755,765 ****
'access' => array('type' => 'varchar',
'precision' => 7,'nullable' => True),
'location_code' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'objekt_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'bygg_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'seksjons_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'etasje' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'leie_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
--- 755,765 ----
'access' => array('type' => 'varchar',
'precision' => 7,'nullable' => True),
'location_code' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'property_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'building_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'entrance_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'floor' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'apartment_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
***************
*** 952,956 ****
'id' => array('type' => 'int',
'precision' => 4, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 952,956 ----
'id' => array('type' => 'int',
'precision' => 4, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1047,1051 ****
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 1047,1051 ----
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1059,1063 ****
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 1059,1063 ----
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1071,1075 ****
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 1071,1075 ----
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1083,1087 ****
'id' => array('type' => 'varchar', 'precision'
=> 5,'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 1083,1087 ----
'id' => array('type' => 'varchar', 'precision'
=> 5,'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1095,1099 ****
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'beskrivelse' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
--- 1095,1099 ----
'id' => array('type' => 'int',
'precision' => 2, 'nullable' => False),
'navn' => array('type' => 'varchar',
'precision' => 20, 'nullable' => False),
! 'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
***************
*** 1184,1194 ****
'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
'location_code' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'objekt_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'bygg_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'seksjons_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'etasje' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'leie_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
--- 1184,1194 ----
'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True,'default' => '0.00'),
'location_code' => array('type' => 'varchar',
'precision' => 20,'nullable' => True),
! 'property_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
'property_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'building_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
'building_name' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
! 'entrance_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'floor' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'apartment_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'street' => array('type' => 'varchar',
'precision' => 50,'nullable' => True),
'tenant_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
***************
*** 1273,1281 ****
'location_code' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
'equipment_id' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
! 'objekt_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
! 'bygg_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'seksjons_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'etasje_id' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'leie_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'title' => array('type' =>
'varchar','precision' => 100,'nullable' => True),
'link_name' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
--- 1273,1281 ----
'location_code' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
'equipment_id' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
! 'property_id' => array('type' => 'varchar',
'precision' => 4,'nullable' => True),
! 'building_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'entrance_id' => array('type' => 'char',
'precision' => 2,'nullable' => True),
! 'floor_id' => array('type' => 'varchar',
'precision' => 6,'nullable' => True),
! 'apartment_id' => array('type' => 'char',
'precision' => 3,'nullable' => True),
'title' => array('type' =>
'varchar','precision' => 100,'nullable' => True),
'link_name' => array('type' =>
'varchar','precision' => 50,'nullable' => True),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: property/setup setup.inc.php,1.20,1.21 tables_current.inc.php,1.34,1.35,
Sigurd Nes <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: property/inc class.soadmin.inc.php,1.1,1.2 class.sobuilding.inc.php,1.4,1.5 class.socommon.inc.php,1.9,1.10 class.soequipment.inc.php,1.6,1.7class.soinvestment.inc.php,1.5,1.6 class.soinvoice.inc.php,1.12,1.13 class.solookup.inc.php,1.7,1.8 class.soproperty.inc.php,1.4,1.5 class.sotts.inc.php,1.6,1.7 class.soXport.inc.php,1.13,1.14 class.uibuilding.inc.php,1.7,1.8 class.uiequipment.inc.php,1.6,1.7 class.uilookup.inc.php,1.7,1.8 class.uiproperty.inc.php,1.8,1.9
- Next by Date:
[Phpgroupware-cvs] CVS: property/setup phpgw_en.lang,1.1.1.1.2.3,1.1.1.1.2.4 phpgw_fr.lang,1.1.2.3,1.1.2.4
- Previous by thread:
[Phpgroupware-cvs] CVS: property/inc class.soadmin.inc.php,1.1,1.2 class.sobuilding.inc.php,1.4,1.5 class.socommon.inc.php,1.9,1.10 class.soequipment.inc.php,1.6,1.7class.soinvestment.inc.php,1.5,1.6 class.soinvoice.inc.php,1.12,1.13 class.solookup.inc.php,1.7,1.8 class.soproperty.inc.php,1.4,1.5 class.sotts.inc.php,1.6,1.7 class.soXport.inc.php,1.13,1.14 class.uibuilding.inc.php,1.7,1.8 class.uiequipment.inc.php,1.6,1.7 class.uilookup.inc.php,1.7,1.8 class.uiproperty.inc.php,1.8,1.9
- Next by thread:
[Phpgroupware-cvs] CVS: property/setup phpgw_en.lang,1.1.1.1.2.3,1.1.1.1.2.4 phpgw_fr.lang,1.1.2.3,1.1.2.4
- Index(es):