phpgroupware-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.18,1.19


From: Sigurd Nes <address@hidden>
Subject: [Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.18,1.19 setup.inc.php,1.49,1.50 tables_current.inc.php,1.76,1.77
Date: Thu, 15 May 2003 05:08:05 -0400

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv28589/setup

Modified Files:
        default_records.inc.php setup.inc.php tables_current.inc.php 
Log Message:
no message

Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/default_records.inc.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -r1.18 -r1.19
*** default_records.inc.php     8 May 2003 13:56:29 -0000       1.18
--- default_records.inc.php     15 May 2003 09:08:02 -0000      1.19
***************
*** 10,18 ****
  
  #
! #`fm_wo_request_category`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_request_category 
(id, descr) VALUES (1, 'Klage fra leieboer')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_request_category 
(id, descr) VALUES (2, 'Bruker ønske')");
  
  #
--- 10,18 ----
  
  #
! #`fm_request_category`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_category (id, 
descr) VALUES (1, 'Klage fra leieboer')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_category (id, 
descr) VALUES (2, 'Bruker ønske')");
  
  #
***************
*** 23,50 ****
  
  #
! # `fm_wo_branch`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_branch (id, num, 
descr) VALUES (1, 'rør', 'rørlegger')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_branch (id, num, 
descr) VALUES (2, 'maler', 'maler')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_branch (id, num, 
descr) VALUES (3, 'tomrer', 'Tømrer')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_branch (id, num, 
descr) VALUES (4, 'renhold', 'Renhold')");
  
  #
! # `fm_wo_wrkorders_status`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('active', 'Aktiv')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('ordered', '')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('request', '')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('closed', 'avsluttet')");
  
  #
! # `fm_wo_request_status`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_request_status (id, 
descr) VALUES ('request', 'Request')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_request_status (id, 
descr) VALUES ('canceled', 'Canceled')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_request_status (id, 
descr) VALUES ('closed', 'avsluttet')");
  
  #
--- 23,50 ----
  
  #
! # `fm_branch`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (1, 'rør', 'rørlegger')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (2, 'maler', 'maler')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (3, 'tomrer', 'Tømrer')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_branch (id, num, descr) 
VALUES (4, 'renhold', 'Renhold')");
  
  #
! # `fm_workorder_status`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('active', 'Aktiv')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('ordered', '')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('request', '')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_workorder_status (id, 
descr) VALUES ('closed', 'avsluttet')");
  
  #
! # `fm_request_status`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('request', 'Request')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('canceled', 'Canceled')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_request_status (id, 
descr) VALUES ('closed', 'avsluttet')");
  
  #
***************
*** 73,82 ****
  
  #
! # `fm_ticket_category`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ticket_category (id, 
descr) VALUES ('1', 'damage')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ticket_category (id, 
descr) VALUES ('2', 'user request')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ticket_category (id, 
descr) VALUES ('3', 'warranty')");
  
  #
--- 73,82 ----
  
  #
! # `fm_tts_category`
  #
  
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, 
descr) VALUES ('1', 'damage')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, 
descr) VALUES ('2', 'user request')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_tts_category (id, 
descr) VALUES ('3', 'warranty')");
  
  #
***************
*** 122,130 ****
  
  #
! #  `fm_wo_agreement_status`
  #
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_agreement_status 
(id, descr) VALUES ('closed', 'Closed')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_agreement_status 
(id, descr) VALUES ('active', 'Active agreement')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_agreement_status 
(id, descr) VALUES ('planning', 'Planning')");
  
  #
--- 122,130 ----
  
  #
! #  `fm_agreement_status`
  #
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('closed', 'Closed')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('active', 'Active agreement')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_agreement_status (id, 
descr) VALUES ('planning', 'Planning')");
  
  #
***************
*** 140,147 ****
  
  #
! #  `fm_wo_ns3420`
  #
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_ns3420 (id, tekst1, 
enhet) VALUES ('D00', 'RIGGING, KLARGJØRING', 'RS')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_ns3420 (id, tekst1, 
enhet,tekst2) VALUES ('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFØRSEL- OG 
FORSYNINGSANLEGG')");
  
  #
--- 140,147 ----
  
  #
! #  `fm_ns3420`
  #
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ns3420 (id, tekst1, 
enhet) VALUES ('D00', 'RIGGING, KLARGJØRING', 'RS')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_ns3420 (id, tekst1, 
enhet,tekst2) VALUES ('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFØRSEL- OG 
FORSYNINGSANLEGG')");
  
  #

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.49
retrieving revision 1.50
diff -C2 -r1.49 -r1.50
*** setup.inc.php       13 May 2003 11:03:07 -0000      1.49
--- setup.inc.php       15 May 2003 09:08:02 -0000      1.50
***************
*** 103,135 ****
                'fm_drawing_category',
                'fm_drawing_history',
!               'fm_wo_accounts',
!               'fm_wo_dim_d',
!               'fm_wo_wrkorders',
!               'fm_wo_workorder_category',
!               'fm_wo_workorder_history',
!               'fm_wo_wrkorders_status',
!               'fm_wo_activities',
!               'fm_wo_agreement',
!               'fm_wo_agreement_status',
!               'fm_wo_activity_price_index',
!               'fm_wo_branch',
                'fm_wo_hours',
!               'fm_wo_key_loc',
!               'fm_wo_request',
!               'fm_wo_request_priority_key',
!               'fm_wo_request_status',
!               'fm_wo_request_category',
!               'fm_wo_request_history',
                'fm_request_origin',
!               'fm_wo_template',
!               'fm_wo_template_hours',
!               'fm_wo_chapter',
!               'fm_wo_ns3420',
!               'fm_wo_project',
!               'fm_wo_projectbranch',
!               'fm_wo_project_history',
                'fm_project_origin',
                'fm_tts_tickets',
!               'fm_ticket_category',
                'fm_tts_history',
                'fm_tts_views',
--- 103,135 ----
                'fm_drawing_category',
                'fm_drawing_history',
!               'fm_b_account',
!               'fm_dim_d',
!               'fm_workorder',
!               'fm_workorder_category',
!               'fm_workorder_history',
!               'fm_workorder_status',
!               'fm_activities',
!               'fm_agreement',
!               'fm_agreement_status',
!               'fm_activity_price_index',
!               'fm_branch',
                'fm_wo_hours',
!               'fm_key_loc',
!               'fm_request',
!               'fm_request_priority_key',
!               'fm_request_status',
!               'fm_request_category',
!               'fm_request_history',
                'fm_request_origin',
!               'fm_template',
!               'fm_template_hours',
!               'fm_chapter',
!               'fm_ns3420',
!               'fm_project',
!               'fm_projectbranch',
!               'fm_project_history',
                'fm_project_origin',
                'fm_tts_tickets',
!               'fm_tts_category',
                'fm_tts_history',
                'fm_tts_views',

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.76
retrieving revision 1.77
diff -C2 -r1.76 -r1.77
*** tables_current.inc.php      13 May 2003 11:03:07 -0000      1.76
--- tables_current.inc.php      15 May 2003 09:08:02 -0000      1.77
***************
*** 526,530 ****
                        'uc' => array()
                ),
!               'fm_wo_accounts' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 526,530 ----
                        'uc' => array()
                ),
!               'fm_b_account' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 536,540 ****
                        'uc' => array()
                ),
!               'fm_wo_dim_d' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 536,540 ----
                        'uc' => array()
                ),
!               'fm_dim_d' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 546,550 ****
                        'uc' => array()
                ),
!               'fm_wo_wrkorders' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 546,550 ----
                        'uc' => array()
                ),
!               'fm_workorder' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 578,582 ****
                        'uc' => array()
                ),
!               'fm_wo_workorder_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 578,582 ----
                        'uc' => array()
                ),
!               'fm_workorder_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 598,602 ****
                        'uc' => array()
                ),
!               'fm_wo_wrkorders_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
--- 598,602 ----
                        'uc' => array()
                ),
!               'fm_workorder_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
***************
*** 608,612 ****
                        'uc' => array()
                ),
!               'fm_wo_activities' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 608,612 ----
                        'uc' => array()
                ),
!               'fm_activities' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 628,632 ****
                        'uc' => array()
                ),
!               'fm_wo_agreement' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 628,632 ----
                        'uc' => array()
                ),
!               'fm_agreement' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 640,644 ****
                        'uc' => array()
                ),
!               'fm_wo_agreement_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
--- 640,644 ----
                        'uc' => array()
                ),
!               'fm_agreement_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
***************
*** 650,654 ****
                        'uc' => array()
                ),
!               'fm_wo_activity_price_index' => array(
                        'fd' => array(
                                'activity_id' => array('type' => 
'int','precision' => '4','nullable' => False),
--- 650,654 ----
                        'uc' => array()
                ),
!               'fm_activity_price_index' => array(
                        'fd' => array(
                                'activity_id' => array('type' => 
'int','precision' => '4','nullable' => False),
***************
*** 667,671 ****
                        'uc' => array()
                ),
!               'fm_wo_branch' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 667,671 ----
                        'uc' => array()
                ),
!               'fm_branch' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 706,710 ****
                        'uc' => array()
                ),
!               'fm_wo_template' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
--- 706,710 ----
                        'uc' => array()
                ),
!               'fm_template' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
***************
*** 720,724 ****
                        'uc' => array()
                ),
!               'fm_wo_template_hours' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
--- 720,724 ----
                        'uc' => array()
                ),
!               'fm_template_hours' => array(
                        'fd' => array(
                                'id' => array('type' => 'auto','precision' => 
'4','nullable' => False),
***************
*** 748,752 ****
                        'uc' => array()
                ),
!               'fm_wo_key_loc' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 748,752 ----
                        'uc' => array()
                ),
!               'fm_key_loc' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 759,763 ****
                        'uc' => array()
                ),
!               'fm_wo_chapter' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 759,763 ----
                        'uc' => array()
                ),
!               'fm_chapter' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 769,773 ****
                        'uc' => array()
                ),
!               'fm_wo_request' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 769,773 ----
                        'uc' => array()
                ),
!               'fm_request' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 815,819 ****
                        'uc' => array()
                ),
!               'fm_wo_request_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
--- 815,819 ----
                        'uc' => array()
                ),
!               'fm_request_status' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
***************
*** 825,829 ****
                        'uc' => array()
                ),
!               'fm_wo_request_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 825,829 ----
                        'uc' => array()
                ),
!               'fm_request_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 846,850 ****
                        'uc' => array()
                ),
!               'fm_wo_ns3420' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
--- 846,850 ----
                        'uc' => array()
                ),
!               'fm_ns3420' => array(
                        'fd' => array(
                                'id' => array('type' => 'varchar','precision' 
=> '20','nullable' => False),
***************
*** 898,902 ****
                        'uc' => array()
                ),
!               'fm_ticket_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 898,902 ----
                        'uc' => array()
                ),
!               'fm_tts_category' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 1107,1111 ****
                        'uc' => array()
                ),
!               'fm_wo_request_priority_key' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 1107,1111 ----
                        'uc' => array()
                ),
!               'fm_request_priority_key' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 1123,1127 ****
                        'uc' => array()
                ),
!               'fm_wo_projectbranch' => array(
                        'fd' => array(
                                'project_id' => array('type' => 
'int','precision' => '4','nullable' => False),
--- 1123,1127 ----
                        'uc' => array()
                ),
!               'fm_projectbranch' => array(
                        'fd' => array(
                                'project_id' => array('type' => 
'int','precision' => '4','nullable' => False),
***************
*** 1133,1137 ****
                        'uc' => array()
                ),
!               'fm_wo_project' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
--- 1133,1137 ----
                        'uc' => array()
                ),
!               'fm_project' => array(
                        'fd' => array(
                                'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
***************
*** 1289,1293 ****
                        'uc' => array()
                ),
!               'fm_wo_request_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),
--- 1289,1293 ----
                        'uc' => array()
                ),
!               'fm_request_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),
***************
*** 1304,1308 ****
                        'uc' => array()
                ),
!               'fm_wo_workorder_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),
--- 1304,1308 ----
                        'uc' => array()
                ),
!               'fm_workorder_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),
***************
*** 1319,1323 ****
                        'uc' => array()
                ),
!               'fm_wo_project_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),
--- 1319,1323 ----
                        'uc' => array()
                ),
!               'fm_project_history' => array(
                        'fd' => array(
                                'history_id' => array('type' => 
'auto','precision' => '4','nullable' => False),





reply via email to

[Prev in Thread] Current Thread [Next in Thread]