[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.13,1.14 setup.inc.php,1.35,1.36 tables_current.inc.php,1.60,1.61

[Sigurd Nes <address@hidden>]

Update of /cvsroot/phpgroupware/property/setup
In directory subversions:/tmp/cvs-serv11709/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.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** default_records.inc.php     12 Apr 2003 17:55:03 -0000      1.13
--- default_records.inc.php     20 Apr 2003 22:24:30 -0000      1.14
***************
*** 41,44 ****
--- 41,68 ----
  
  #
+ # `fm_wo_request_status`
+ #
+ 
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('request', 'Request')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('canceled', 'Canceled')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('closed', 'avsluttet')");
+ 
+ #
+ # `fm_drawing_status`
+ #
+ 
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('sketch', 'Sketch')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('production', 'Production')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('asbuilt', 'As built')");
+ 
+ #
+ # `fm_drawing_category`
+ #
+ 
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('1', 'Plane')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('2', 'Cross section')");
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_wo_wrkorders_status 
(id, descr) VALUES ('3', 'Facade')");
+ 
+ #
  # `fm_equipment_status`
  #
***************
*** 97,101 ****
  $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('Statuslog', '1', 'Statuslog')");
  $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('workorder', '1000', 'workorder')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('workorder', '1000', 'request')");
  
  ?>
--- 121,125 ----
  $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('Statuslog', '1', 'Statuslog')");
  $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('workorder', '1000', 'workorder')");
! $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_idgenerator (name, 
value, descr) VALUES ('request', '1000', 'request')");
  
  ?>

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/setup.inc.php,v
retrieving revision 1.35
retrieving revision 1.36
diff -C2 -r1.35 -r1.36
*** setup.inc.php       12 Apr 2003 17:55:03 -0000      1.35
--- setup.inc.php       20 Apr 2003 22:24:30 -0000      1.36
***************
*** 97,101 ****
                'fm_property_type_attrib_class',
                'fm_building_part',
!               'span_tegning',
                'fm_wo_accounts',
                'fm_wo_dim_d',
--- 97,104 ----
                'fm_property_type_attrib_class',
                'fm_building_part',
!               'fm_drawing',
!               'fm_drawing_status',
!               'fm_drawing_category',
!               'fm_drawing_history',
                'fm_wo_accounts',
                'fm_wo_dim_d',

Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/property/setup/tables_current.inc.php,v
retrieving revision 1.60
retrieving revision 1.61
diff -C2 -r1.60 -r1.61
*** tables_current.inc.php      12 Apr 2003 17:55:03 -0000      1.60
--- tables_current.inc.php      20 Apr 2003 22:24:30 -0000      1.61
***************
*** 529,546 ****
                        'uc' => array()
                ),
!               'span_tegning' => array(
                        '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)
                        ),
!                       'pk' => array(),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
                'fm_wo_accounts' => array(
                        'fd' => array(
--- 529,561 ----
                        'uc' => array()
                ),
!               'fm_drawing' => array(
                        'fd' => array(
!                               'drawing_name' => array('type' => 
'varchar','precision' => '50','nullable' => False),
!                               'location_code' => array('type' => 
'varchar','precision' => '20','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),
!                               'address' => array('type' => 
'varchar','precision' => '50','nullable' => False),
!                               'owner' => array('type' => 'int','precision' => 
'4','nullable' => True),
!                               'access' => array('type' => 
'varchar','precision' => '7','nullable' => True)
                        ),
!                       'pk' => array('drawing_name'),
                        'fk' => array(),
                        'ix' => array(),
                        'uc' => array()
                ),
+ 
+               'fm_drawing_status' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'varchar', 'precision' 
=> 20,'nullable' => False),
+                               'descr' => array('type' => 'varchar', 
'precision' => 255,'nullable' => False)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+ 
                'fm_wo_accounts' => array(
                        'fd' => array(
***************
*** 609,612 ****
--- 624,638 ----
                ),
  
+               'fm_drawing_category' => array(
+                       'fd' => array(
+                               'id' => array('type' => 'int','precision' => 
'4','nullable' => False),
+                               'descr' => array('type' => 
'varchar','precision' => '50','nullable' => True)
+                       ),
+                       'pk' => array('id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+ 
                'fm_wo_wrkorders_status' => array(
                        'fd' => array(
***************
*** 1297,1300 ****
--- 1323,1342 ----
  
                'fm_tts_history' => array(
+                       'fd' => array(
+                               'history_id'        => array('type' => 'auto',  
    'precision' => 4,  'nullable' => False),
+                               'history_record_id' => array('type' => 'int',   
    'precision' => 4,  'nullable' => False),
+                               'history_appname'   => array('type' => 
'varchar',   'precision' => 64, 'nullable' => False),
+                               'history_owner'     => array('type' => 'int',   
    'precision' => 4,  'nullable' => False),
+                               'history_status'    => array('type' => 'char',  
    'precision' => 2,  'nullable' => False),
+                               'history_new_value' => array('type' => 'text',  
    'nullable' => False),
+                               'history_timestamp' => array('type' => 
'timestamp', 'nullable' => False, 'default' => 'current_timestamp')
+                       ),
+                       'pk' => array('history_id'),
+                       'fk' => array(),
+                       'ix' => array(),
+                       'uc' => array()
+               ),
+ 
+               'fm_drawing_history' => array(
                        'fd' => array(
                                'history_id'        => array('type' => 'auto',  
    'precision' => 4,  'nullable' => False),