[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.p
|
From: |
sigurdne |
|
Subject: |
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12 |
|
Date: |
Wed, 11 May 2005 21:25:00 +0200 |
Update of property/setup
Modified Files:
Branch: MAIN
tables_update.inc.php lines: +186 -1
setup.inc.php lines: +2 -2
tables_current.inc.php lines: +6 -2
default_records.inc.php lines: +153 -33
Log Message:
no message
====================================================
Index: property/setup/tables_update.inc.php
diff -u property/setup/tables_update.inc.php:1.7
property/setup/tables_update.inc.php:1.8
--- property/setup/tables_update.inc.php:1.7 Fri May 6 08:40:27 2005
+++ property/setup/tables_update.inc.php Wed May 11 19:25:38 2005
@@ -169,4 +169,189 @@
return $GLOBALS['setup_info']['property']['currentver'];
}
+ /**
+ * Update property version from 0.9.17.503 to 0.9.17.504
+ */
+
+ $test[] = '0.9.17.503';
+ function property_upgrade0_9_17_503()
+ {
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_location_type','pk',array('type'
=> 'text','nullable' => True));
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_location_type','ix',array('type'
=> 'text','nullable' => True));
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_location_type','uc',array('type'
=> 'text','nullable' => True));
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('fm_location_attrib','custom',array('type'
=> 'int','precision' => 4,'nullable' => True));
+
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE
fm_location_attrib SET custom = 1");
+
+ $GLOBALS['phpgw_setup']->oProc->query("SELECT count(*) FROM
fm_location_type");
+ $GLOBALS['phpgw_setup']->oProc->next_record();
+ $locations = $GLOBALS['phpgw_setup']->oProc->f(0);
+
+
+ for ($location_type=1; $location_type<($locations+1);
$location_type++)
+ {
+ $GLOBALS['phpgw_setup']->oProc->query("SELECT max(id)
as id FROM fm_location_attrib WHERE type_id = $location_type");
+ $GLOBALS['phpgw_setup']->oProc->next_record();
+ $id = $GLOBALS['phpgw_setup']->oProc->f('id');
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'location_code';
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =4*$location_type;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'loc' .
$location_type . '_name';
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =50;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'entry_date';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'category';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'user_id';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'remark';
+ $default_attrib['type'][]='T';
+ $default_attrib['precision'][] = 'NULL';
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ for ($i=1; $i<$location_type+1; $i++)
+ {
+ $pk[$i-1]= 'loc' . $i;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'loc' . $i;
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+ }
+
+ if ($location_type==1)
+ {
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'mva';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='mva';
+ $default_attrib['statustext'][] ='mva';
+ $default_attrib['custom'][] = 1;
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'kostra_id';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='kostra_id';
+ $default_attrib['statustext'][] ='kostra_id';
+ $default_attrib['custom'][] = 1;
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]=
'part_of_town_id';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+
+ $default_attrib['id'][]= $id;
+ $default_attrib['column_name'][]= 'owner_id';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ $default_attrib['custom'][] ='NULL';
+ $id++;
+ }
+
+ if($location_type>1)
+ {
+ $fk_table='fm_location'. ($location_type-1);
+
+ for ($i=1; $i<$standard['id']; $i++)
+ {
+ $fk['loc' . $i] = $fk_table . '.loc' .
$i;
+ }
+ }
+
+ $ix = array('location_code');
+
+ $GLOBALS['phpgw_setup']->oProc->query("UPDATE
fm_location_type SET "
+ . "pk ='" . implode(',',$pk) . "',"
+ . "ix ='" . implode(',',$ix) . "' WHERE id =
$location_type");
+
+
+ for ($i=0;$i<count($default_attrib['id']);$i++)
+ {
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT
INTO fm_location_attrib
(type_id,id,column_name,datatype,precision_,input_text,statustext,nullable,custom)"
+ . " VALUES ( $location_type,'"
+ . $default_attrib['id'][$i] . "','"
+ . $default_attrib['column_name'][$i] .
"','"
+ . $default_attrib['type'][$i] . "',"
+ . $default_attrib['precision'][$i] .
",'"
+ . $default_attrib['input_text'][$i] .
"','"
+ . $default_attrib['statustext'][$i] .
"','"
+ . $default_attrib['nullable'][$i] . "',"
+ . $default_attrib['custom'][$i] . ")");
+ }
+
+ unset($pk);
+ unset($ix);
+ unset($default_attrib);
+ }
+
+ $GLOBALS['setup_info']['property']['currentver'] = '0.9.17.504';
+ return $GLOBALS['setup_info']['property']['currentver'];
+ }
+
+
?>
====================================================
Index: property/setup/setup.inc.php
diff -u property/setup/setup.inc.php:1.14 property/setup/setup.inc.php:1.15
--- property/setup/setup.inc.php:1.14 Fri May 6 08:40:27 2005
+++ property/setup/setup.inc.php Wed May 11 19:25:38 2005
@@ -25,7 +25,7 @@
$setup_info['property']['name'] = 'property';
$setup_info['property']['title'] = 'Property';
- $setup_info['property']['version'] = '0.9.17.503';
+ $setup_info['property']['version'] = '0.9.17.504';
$setup_info['property']['app_order'] = 8;
$setup_info['property']['enable'] = 1;
====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.27
property/setup/tables_current.inc.php:1.28
--- property/setup/tables_current.inc.php:1.27 Fri May 6 08:40:27 2005
+++ property/setup/tables_current.inc.php Wed May 11 19:25:38 2005
@@ -220,7 +220,10 @@
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
- 'prefix' => array('type' =>
'varchar','precision' => '8','nullable' => True)
+ 'prefix' => array('type' =>
'varchar','precision' => '8','nullable' => True),
+ 'pk' => array('type' => 'text','nullable' =>
True),
+ 'ix' => array('type' => 'text','nullable' =>
True),
+ 'uc' => array('type' => 'text','nullable' =>
True),
),
'pk' => array('id'),
'fk' => array(),
@@ -376,6 +379,7 @@
'fd' => array(
'type_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'custom' => array('type' => 'int','precision'
=> '4','nullable' => True),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
====================================================
Index: property/setup/default_records.inc.php
diff -u property/setup/default_records.inc.php:1.11
property/setup/default_records.inc.php:1.12
--- property/setup/default_records.inc.php:1.11 Fri May 6 08:40:27 2005
+++ property/setup/default_records.inc.php Wed May 11 19:25:38 2005
@@ -247,16 +247,6 @@
#
-# Dumping data for table fm_location_type
-#
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name,
descr) VALUES (1, 'property', 'Property')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name,
descr) VALUES (2, 'building', 'Building')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name,
descr) VALUES (3, 'entrance', 'Entrance')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id, name,
descr) VALUES (4, 'apartment', 'Apartment')");
-
-
-#
# Dumping data for table fm_tenant_category
#
@@ -423,28 +413,6 @@
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup
(entity_id, location, type) VALUES (2, 'request', 'start')");
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_entity_lookup
(entity_id, location, type) VALUES (2, 'ticket', 'start')");
-#
-# Dumping data for table fm_location_attrib
-#
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable) VALUES (1, 1, 'status',
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable) VALUES (2, 1, 'status',
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable) VALUES (3, 1, 'status',
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable) VALUES (4, 1, 'status',
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')");
-
-
-#
-# Dumping data for table fm_location_choice
-#
-
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (1, 1, 1, 'OK')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (1, 1, 2, 'Not Active')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (2, 1, 1, 'OK')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (2, 1, 2, 'Not Active')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (3, 1, 1, 'OK')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (3, 1, 2, 'Not Active')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (4, 1, 1, 'OK')");
-$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (4, 1, 2, 'Not Active')");
#
# Dumping data for table fm_custom
@@ -475,4 +443,156 @@
$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_vendor (id, org_name,
email, contact_phone, category) VALUES (1, 'Demo vendor', 'address@hidden',
'5555555', 1)");
+#
+# Dumping data for table fm_location_type
+#
+
+#$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
name, descr) VALUES (1, 'property', 'Property')");
+#$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
name, descr) VALUES (2, 'building', 'Building')");
+#$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
name, descr) VALUES (3, 'entrance', 'Entrance')");
+#$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type (id,
name, descr) VALUES (4, 'apartment', 'Apartment')");
+
+$location_naming[1]['name']='property';
+$location_naming[1]['descr']='Property';
+$location_naming[2]['name']='building';
+$location_naming[2]['descr']='Building';
+$location_naming[3]['name']='entrance';
+$location_naming[3]['descr']='Entrance';
+$location_naming[4]['name']='Apartment';
+$location_naming[4]['descr']='Apartment';
+
+for ($location_type=1; $location_type<5; $location_type++)
+{
+ $default_attrib['id'][]= 1;
+ $default_attrib['column_name'][]= 'location_code';
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =4*$location_type;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ $default_attrib['id'][]= 2;
+ $default_attrib['column_name'][]= 'loc' . $location_type . '_name';
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =50;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ $default_attrib['id'][]= 3;
+ $default_attrib['column_name'][]= 'entry_date';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='True';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ $default_attrib['id'][]= 4;
+ $default_attrib['column_name'][]= 'category';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ $default_attrib['id'][]= 5;
+ $default_attrib['column_name'][]= 'user_id';
+ $default_attrib['type'][]='I';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ $default_attrib['id'][]= 6;
+ $default_attrib['column_name'][]= 'remark';
+ $default_attrib['type'][]='T';
+ $default_attrib['precision'][] = 'NULL';
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+
+ for ($i=1; $i<$location_type+1; $i++)
+ {
+ $pk[$i-1]= 'loc' . $i;
+
+ $default_attrib['id'][]= $i+6;
+ $default_attrib['column_name'][]= 'loc' . $i;
+ $default_attrib['type'][]='V';
+ $default_attrib['precision'][] =4;
+ $default_attrib['nullable'][] ='False';
+ $default_attrib['input_text'][] ='dummy';
+ $default_attrib['statustext'][] ='dummy';
+ }
+
+ if($location_type>1)
+ {
+ $fk_table='fm_location'. ($location_type-1);
+
+ for ($i=1; $i<$standard['id']; $i++)
+ {
+ $fk['loc' . $i] = $fk_table . '.loc' . $i;
+ }
+ }
+
+ $ix = array('location_code');
+
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_type
(id,name,descr,pk,ix) "
+ . "VALUES ($location_type,'"
+ . $location_naming[$location_type]['name'] . "','"
+ . $location_naming[$location_type]['descr'] . "','"
+ . implode(',',$pk) . "','"
+ . implode(',',$ix) . "')");
+
+
+ for ($i=0;$i<count($default_attrib['id']);$i++)
+ {
+ $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO
fm_location_attrib
(type_id,id,column_name,datatype,precision_,input_text,statustext,nullable)"
+ . " VALUES ( $location_type,"
+ . $default_attrib['id'][$i] . ",'"
+ . $default_attrib['column_name'][$i] . "','"
+ . $default_attrib['type'][$i] . "',"
+ . $default_attrib['precision'][$i] . ",'"
+ . $default_attrib['input_text'][$i] . "','"
+ . $default_attrib['statustext'][$i] . "','"
+ . $default_attrib['nullable'][$i] . "')");
+ }
+
+ unset($pk);
+ unset($ix);
+ unset($default_attrib);
+}
+
+#
+# Dumping data for table fm_location_attrib
+#
+
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 8,
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (2, 9,
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (3, 10,
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (4, 11,
'status', 'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True',
1)");
+
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 9,
'remark', 'Remark', 'Remark', 'T', NULL, 2, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (2, 10,
'remark', 'Remark', 'Remark', 'T', NULL, 2, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (3, 11,
'remark', 'Remark', 'Remark', 'T', NULL, 2, NULL, NULL, NULL, NULL, 'True',
1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (4, 12,
'remark', 'Remark', 'Remark', 'T', NULL, 2, NULL, NULL, NULL, NULL, 'True',
1)");
+
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 10, 'mva',
'mva', 'Status', 'I', NULL, 3, NULL, 4, NULL, NULL, 'True', 1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 11,
'kostra_id', 'kostra_id', 'kostra_id', 'I', NULL, 4, NULL, 4, NULL, NULL,
'True', 1)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 12,
'part_of_town_id', 'dummy', 'dummy', 'I', NULL, 5, NULL, 4, NULL, NULL, 'True',
NULL)");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_attrib (
type_id, id, column_name, input_text, statustext, datatype, list, attrib_sort,
size, precision_, scale, default_value, nullable,custom) VALUES (1, 13,
'owner_id', 'dummy', 'dummy', 'I', NULL, 6, NULL, 4, NULL, NULL, 'True',
NULL)");
+
+#
+# Dumping data for table fm_location_choice
+#
+
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (1, 8, 1, 'OK')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (1, 8, 2, 'Not Active')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (2, 9, 1, 'OK')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (2, 9, 2, 'Not Active')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (3, 10, 1, 'OK')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (3, 10, 2, 'Not Active')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (4, 11, 1, 'OK')");
+$GLOBALS['phpgw_setup']->oProc->query("INSERT INTO fm_location_choice (
type_id, attrib_id, id, value) VALUES (4, 11, 2, 'Not Active')");
+
+
?>
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12,
sigurdne <=
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12, sigurdne, 2005/05/17
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12, sigurdne, 2005/05/17
- [Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12, sigurdne, 2005/05/17
- Prev by Date:
[Phpgroupware-cvs] nntp/inc class.nntp.inc.php, 1.9 class.mail.inc.php, 1.8
- Next by Date:
[Phpgroupware-cvs] phpgroupware/ipc_test_suite/sources/api class.vcard.inc.php, 1.1 class.ipc_manager.inc.php, 1.1 class.ipc_.inc.php, 1.1
- Previous by thread:
[Phpgroupware-cvs] calendar/help/FI calendar.php, 1.3 view.php, 1.3 add.php, 1.3 edit_delete.php, 1.3
- Next by thread:
[Phpgroupware-cvs] property/setup tables_update.inc.php, 1.8 setup.inc.php, 1.15 tables_current.inc.php, 1.28 default_records.inc.php, 1.12
- Index(es):