[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: property/setup default_records.inc.php,1.13,1.14
From: |
Sigurd Nes <address@hidden> |
Subject: |
[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 |
Date: |
Sun, 20 Apr 2003 18:24:33 -0400 |
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),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [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> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: phpgwapi/templates/default app_delete.xsl,1.6,1.7 filter_select.xsl,1.5,1.6search_field.xsl,1.5,1.6
- Next by Date:
[Phpgroupware-cvs] CVS: property/inc class.bodrawing.inc.php,NONE,1.1 class.sodrawing.inc.php,NONE,1.1 class.uidrawing.inc.php,NONE,1.1 class.bocommon.inc.php,1.34,1.35 class.historylog.inc.php,1.2,1.3 class.sorequest.inc.php,1.2,1.3 class.sostandard_2.inc.php,1.9,1.10 class.uiproject.inc.php,1.10,1.11 class.uirequest.inc.php,1.2,1.3 hook_admin.inc.php,1.23,1.24
- Previous by thread:
[Phpgroupware-cvs] CVS: phpgwapi/templates/default app_delete.xsl,1.6,1.7 filter_select.xsl,1.5,1.6search_field.xsl,1.5,1.6
- Next by thread:
[Phpgroupware-cvs] CVS: property/inc class.bodrawing.inc.php,NONE,1.1 class.sodrawing.inc.php,NONE,1.1 class.uidrawing.inc.php,NONE,1.1 class.bocommon.inc.php,1.34,1.35 class.historylog.inc.php,1.2,1.3 class.sorequest.inc.php,1.2,1.3 class.sostandard_2.inc.php,1.9,1.10 class.uiproject.inc.php,1.10,1.11 class.uirequest.inc.php,1.2,1.3 hook_admin.inc.php,1.23,1.24
- Index(es):