[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.3
|
From: |
nomail |
|
Subject: |
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.3 |
|
Date: |
Sun, 23 May 2004 03:39:47 -0000 |
Update of /property/setup
Modified Files:
Branch:
tables.xml
date: 2004/04/28 07:29:17; author: sigurdne; state: Exp; lines: +329 -331
Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.2 property/setup/tables.xml:1.1.1.3
--- property/setup/tables.xml:1.1.1.2 Wed Apr 28 06:21:20 2004
+++ property/setup/tables.xml Wed Apr 28 07:29:17 2004
@@ -3,26 +3,26 @@
<table name="fm_part_of_town">
<desc>Table desc</desc>
<field name="part_of_town_id" type="I"><descr>A unique ID
assigned to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="name" type="V" size="20"></field>
+ <field name="name" type="C" size="20"></field>
<field name="district_id" type="I"></field>
</table>
<table name="fm_gab_location">
<desc>Table desc</desc>
- <field name="location_code" type="V"
size="16"><NOTNULL/><KEY/></field>
- <field name="gab_id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="location_code" type="C"
size="16"><NOTNULL/><KEY/></field>
+ <field name="gab_id" type="C" size="20"><NOTNULL/><KEY/></field>
<field name="user_id" type="I"></field>
<field name="entry_date" type="I"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="100"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="100"></field>
<field name="split" type="I"></field>
- <field name="remark" type="V" size="50"></field>
+ <field name="remark" type="C" size="50"></field>
<field name="Spredning" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_gab_location"><col>location_code</col><UNIQUE/></index>
</table>
@@ -30,36 +30,36 @@
<table name="fm_meter">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="num" type="V" size="20"><NOTNULL/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="num" type="C" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="category" type="I"><NOTNULL/></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V"
size="20"><NOTNULL/><KEY/></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="20"><NOTNULL/><KEY/></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
- <field name="remark" type="V" size="255"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <field name="remark" type="C" size="255"></field>
+ <index
name="i_location_code_meter"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_meter_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_streetaddress">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"><NOTNULL/></field>
- <index name="id"><col>id</col><UNIQUE/></index>
+ <field name="descr" type="C" size="50"><NOTNULL/></field>
+ <index name="i_id_streetaddress"><col>id</col><UNIQUE/></index>
</table>
@@ -68,7 +68,7 @@
<field name="tenant_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="first_name" type="C" size="30"></field>
<field name="last_name" type="C" size="30"></field>
- <field name="contact_phone" type="V" size="20"></field>
+ <field name="contact_phone" type="C" size="20"></field>
<field name="category" type="I"></field>
<field name="Flytte_ID" type="I"></field>
<field name="status_eco" type="C" size="2"></field>
@@ -85,7 +85,7 @@
<table name="fm_tenant_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
@@ -93,7 +93,7 @@
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
<field name="type" type="C" size="1"><NOTNULL/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
@@ -101,15 +101,15 @@
<table name="fm_district">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="20"></field>
+ <field name="descr" type="C" size="20"></field>
</table>
<table name="fm_standard_unit">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
@@ -117,16 +117,16 @@
<table name="fm_location_type">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"></field>
- <field name="descr" type="V" size="50"></field>
- <field name="prefix" type="V" size="8"></field>
+ <field name="name" type="C" size="20"></field>
+ <field name="descr" type="C" size="50"></field>
+ <field name="prefix" type="C" size="8"></field>
</table>
<table name="fm_location1">
<desc>Table desc</desc>
- <field name="location_code" type="V"
size="16"><NOTNULL/></field>
- <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc1_name" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="16"><NOTNULL/></field>
+ <field name="loc1" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc1_name" type="C" size="50"></field>
<field name="part_of_town_id" type="I"></field>
<field name="entry_date" type="I"></field>
<field name="category" type="I"></field>
@@ -134,106 +134,106 @@
<field name="owner_id" type="I"></field>
<field name="status" type="I"></field>
<field name="remark" type="X"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_location1"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_location1_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_location2">
<desc>Table desc</desc>
- <field name="location_code" type="V"
size="50"><NOTNULL/></field>
- <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc2_name" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2_name" type="C" size="50"></field>
<field name="entry_date" type="I"></field>
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
<field name="remark" type="X"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_location2"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_location2_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
- <index name="id"><col>id</col><UNIQUE/></index>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
+ <index
name="i_id_location2_category"><col>id</col><UNIQUE/></index>
</table>
<table name="fm_location3">
<desc>Table desc</desc>
- <field name="location_code" type="V"
size="50"><NOTNULL/></field>
- <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc3" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc3_name" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3_name" type="C" size="50"></field>
<field name="entry_date" type="I"></field>
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
<field name="remark" type="X"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_location3"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_location3_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_location4">
<desc>Table desc</desc>
- <field name="location_code" type="V"
size="50"><NOTNULL/></field>
- <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc3" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc4" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="loc4_name" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc4" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc4_name" type="C" size="50"></field>
<field name="entry_date" type="I"></field>
<field name="category" type="I"></field>
<field name="street_id" type="I"></field>
- <field name="street_number" type="V" size="10"></field>
+ <field name="street_number" type="C" size="10"></field>
<field name="user_id" type="I"></field>
<field name="tenant_id" type="I"></field>
<field name="status" type="I"></field>
<field name="remark" type="X"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_location4"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_location4_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_location_config">
<desc>Table desc</desc>
- <field name="column_name" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="column_name" type="C"
size="20"><NOTNULL/><KEY/></field>
<field name="location_type" type="I"><NOTNULL/></field>
- <field name="input_text" type="V" size="20"></field>
+ <field name="input_text" type="C" size="20"></field>
<field name="lookup_form" type="I"></field>
<field name="f_key" type="I"></field>
<field name="ref_to_category" type="I"></field>
<field name="query_value" type="I"></field>
- <field name="reference_table" type="V" size="30"></field>
- <field name="reference_id" type="V" size="15"></field>
- <field name="datatype" type="V" size="10"></field>
+ <field name="reference_table" type="C" size="30"></field>
+ <field name="reference_id" type="C" size="15"></field>
+ <field name="datatype" type="C" size="10"></field>
<field name="precision_" type="I"></field>
<field name="scale" type="I"></field>
- <field name="default_value" type="V" size="20"></field>
- <field name="nullable" type="V" size="5" default="True"></field>
+ <field name="default_value" type="C" size="20"></field>
+ <field name="nullable" type="C" size="5" default="True"></field>
</table>
@@ -241,19 +241,19 @@
<desc>Table desc</desc>
<field name="type_id" type="I"><NOTNULL/><KEY/></field>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="column_name" type="V" size="20"><NOTNULL/></field>
- <field name="input_text" type="V" size="20"><NOTNULL/></field>
+ <field name="column_name" type="C" size="20"><NOTNULL/></field>
+ <field name="input_text" type="C" size="20"><NOTNULL/></field>
<field name="list" type="I"></field>
<field name="location_form" type="I"></field>
<field name="lookup_form" type="I"></field>
- <field name="statustext" type="V" size="100"><NOTNULL/></field>
+ <field name="statustext" type="C" size="100"><NOTNULL/></field>
<field name="size" type="I"></field>
- <field name="datatype" type="V" size="10"></field>
+ <field name="datatype" type="C" size="10"></field>
<field name="attrib_sort" type="I"></field>
<field name="precision_" type="I"></field>
<field name="scale" type="I"></field>
- <field name="default_value" type="V" size="20"></field>
- <field name="nullable" type="V" size="5" default="True"></field>
+ <field name="default_value" type="C" size="20"></field>
+ <field name="nullable" type="C" size="5" default="True"></field>
</table>
@@ -268,69 +268,69 @@
<table name="fm_building_part">
<desc>Table desc</desc>
- <field name="id" type="V" size="4"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="id" type="C" size="4"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="50"></field>
</table>
<table name="fm_drawing">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="title" type="V" size="50"></field>
- <field name="drawing_name" type="V" size="50"><NOTNULL/></field>
- <field name="descr" type="V" size="255"></field>
- <field name="version" type="V" size="10"></field>
+ <field name="title" type="C" size="50"></field>
+ <field name="drawing_name" type="C" size="50"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"></field>
+ <field name="version" type="C" size="10"></field>
<field name="drawing_date" type="I"></field>
<field name="entry_date" type="I"></field>
- <field name="status" type="V" size="10"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="status" type="C" size="10"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V"
size="20"><NOTNULL/></field>
- <field name="address" type="V" size="50"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="floor_id" type="V" size="8"><NOTNULL/></field>
+ <field name="location_code" type="C"
size="20"><NOTNULL/></field>
+ <field name="address" type="C" size="50"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="floor_id" type="C" size="8"><NOTNULL/></field>
<field name="coordinator" type="I"></field>
<field name="vendor_id" type="I"></field>
<field name="branch_id" type="I"></field>
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
- <field name="access" type="V" size="7"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <field name="access" type="C" size="7"></field>
+ <index
name="i_location_code_drawing"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_drawing_status">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_b_account">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="grouping" type="V" size="4"><NOTNULL/></field>
- <field name="descr" type="V" size="25"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="grouping" type="C" size="4"><NOTNULL/></field>
+ <field name="descr" type="C" size="25"><NOTNULL/></field>
</table>
<table name="fm_dim_d">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="25"><NOTNULL/></field>
+ <field name="descr" type="C" size="25"><NOTNULL/></field>
</table>
<table name="fm_workorder">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="num" type="V" size="20"><NOTNULL/></field>
+ <field name="num" type="C" size="20"><NOTNULL/></field>
<field name="project_id" type="I"><NOTNULL/></field>
<field name="user_id" type="I"><NOTNULL/></field>
- <field name="access" type="V" size="7"></field>
+ <field name="access" type="C" size="7"></field>
<field name="category" type="I"><NOTNULL/></field>
<field name="chapter_id" type="I"></field>
<field name="entry_date" type="I"><NOTNULL/></field>
@@ -338,9 +338,9 @@
<field name="end_date" type="I"><NOTNULL/></field>
<field name="coordinator" type="I"><NOTNULL/></field>
<field name="vendor_id" type="I"></field>
- <field name="status" type="V" size="20"
default="active"><NOTNULL/></field>
+ <field name="status" type="C" size="20"
default="active"><NOTNULL/></field>
<field name="descr" type="X"></field>
- <field name="title" type="V" size="255"><NOTNULL/></field>
+ <field name="title" type="C" size="255"><NOTNULL/></field>
<field name="budget" type="N" size="20.2"
default="0.00"></field>
<field name="calculation" type="N" size="20.2"
default="0.00"></field>
<field name="deviation" type="N" size="20.2"></field>
@@ -359,32 +359,32 @@
<table name="fm_workorder_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="descr" type="C" size="50"></field>
</table>
<table name="fm_drawing_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="descr" type="C" size="50"></field>
</table>
<table name="fm_workorder_status">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_activities">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="num" type="V" size="25"><NOTNULL/></field>
+ <field name="num" type="C" size="25"><NOTNULL/></field>
<field name="base_descr" type="X"></field>
- <field name="unit" type="V" size="4"></field>
- <field name="ns3420" type="V" size="15"></field>
- <field name="remarkreq" type="V" size="5" default="N"></field>
+ <field name="unit" type="C" size="4"></field>
+ <field name="ns3420" type="C" size="15"></field>
+ <field name="remarkreq" type="C" size="5" default="N"></field>
<field name="minperae" type="I" default="0"></field>
<field name="billperae" type="N" size="20.2"
default="0.00"></field>
<field name="dim_d" type="I"></field>
@@ -397,16 +397,16 @@
<table name="fm_agreement">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="num" type="V" size="25"><NOTNULL/></field>
- <field name="descr" type="V" size="50"><NOTNULL/></field>
- <field name="status" type="V" size="15"><NOTNULL/></field>
+ <field name="num" type="C" size="25"><NOTNULL/></field>
+ <field name="descr" type="C" size="50"><NOTNULL/></field>
+ <field name="status" type="C" size="15"><NOTNULL/></field>
</table>
<table name="fm_agreement_status">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
@@ -427,8 +427,8 @@
<table name="fm_branch">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="num" type="V" size="20"><NOTNULL/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="num" type="C" size="20"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
@@ -439,18 +439,18 @@
<field name="owner" type="I"><NOTNULL/></field>
<field name="workorder_id" type="I"><NOTNULL/></field>
<field name="activity_id" type="I"></field>
- <field name="activity_num" type="V" size="15"></field>
+ <field name="activity_num" type="C" size="15"></field>
<field name="grouping_id" type="I"></field>
- <field name="grouping_descr" type="V" size="50"></field>
+ <field name="grouping_descr" type="C" size="50"></field>
<field name="entry_date" type="I"><NOTNULL/></field>
- <field name="hours_descr" type="V" size="255"></field>
+ <field name="hours_descr" type="C" size="255"></field>
<field name="remark" type="X"></field>
<field name="billperae" type="N" size="20.2"
default="0.00"></field>
<field name="vendor_id" type="I"></field>
- <field name="unit" type="V" size="6"></field>
- <field name="ns3420_id" type="V" size="20"></field>
+ <field name="unit" type="C" size="6"></field>
+ <field name="ns3420_id" type="C" size="20"></field>
<field name="tolerance" type="I"></field>
- <field name="building_part" type="V" size="4"></field>
+ <field name="building_part" type="C" size="4"></field>
<field name="quantity" type="N" size="20.2"></field>
<field name="cost" type="N" size="20.2"></field>
<field name="dim_d" type="I"></field>
@@ -471,8 +471,8 @@
<table name="fm_template">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="name" type="V" size="50"></field>
- <field name="descr" type="V" size="255"></field>
+ <field name="name" type="C" size="50"></field>
+ <field name="descr" type="C" size="255"></field>
<field name="owner" type="I"></field>
<field name="chapter_id" type="I"></field>
<field name="entry_date" type="I"></field>
@@ -487,17 +487,17 @@
<field name="owner" type="I"><NOTNULL/></field>
<field name="workorder_id" type="I"><NOTNULL/></field>
<field name="activity_id" type="I"></field>
- <field name="activity_num" type="V" size="15"></field>
+ <field name="activity_num" type="C" size="15"></field>
<field name="grouping_id" type="I"></field>
- <field name="grouping_descr" type="V" size="50"></field>
- <field name="hours_descr" type="V" size="255"></field>
+ <field name="grouping_descr" type="C" size="50"></field>
+ <field name="hours_descr" type="C" size="255"></field>
<field name="remark" type="X"></field>
<field name="billperae" type="N" size="20.2"
default="0.00"></field>
<field name="vendor_id" type="I"></field>
- <field name="unit" type="V" size="6"></field>
- <field name="ns3420_id" type="V" size="20"></field>
+ <field name="unit" type="C" size="6"></field>
+ <field name="ns3420_id" type="C" size="20"></field>
<field name="tolerance" type="I"></field>
- <field name="building_part" type="V" size="4"></field>
+ <field name="building_part" type="C" size="4"></field>
<field name="quantity" type="N" size="20.2"></field>
<field name="cost" type="N" size="20.2"></field>
<field name="dim_d" type="I"></field>
@@ -507,42 +507,42 @@
<table name="fm_key_loc">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="num" type="V" size="20"><NOTNULL/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="num" type="C" size="20"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_chapter">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/></field>
- <field name="descr" type="V" size="50"><NOTNULL/></field>
- <index name="id"><col>id</col><UNIQUE/></index>
+ <field name="descr" type="C" size="50"><NOTNULL/></field>
+ <index name="i_id_chapter"><col>id</col><UNIQUE/></index>
</table>
<table name="fm_request">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="title" type="V" size="20"></field>
+ <field name="title" type="C" size="20"></field>
<field name="project_id" type="I"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="descr" type="C" size="50"></field>
<field name="category" type="I"></field>
<field name="owner" type="I"></field>
- <field name="access" type="V" size="7"></field>
- <field name="floor" type="V" size="6"></field>
- <field name="address" type="V" size="100"></field>
+ <field name="access" type="C" size="7"></field>
+ <field name="floor" type="C" size="6"></field>
+ <field name="address" type="C" size="100"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="20"></field>
+ <field name="contact_phone" type="C" size="20"></field>
<field name="entry_date" type="I"></field>
<field name="budget" type="I"></field>
- <field name="status" type="V" size="10"></field>
+ <field name="status" type="C" size="10"></field>
<field name="branch_id" type="I"></field>
<field name="coordinator" type="I"></field>
<field name="d_safety" type="I"></field>
@@ -565,26 +565,26 @@
<field name="c_residential_environment" type="I"></field>
<field name="authorities_demands" type="I"></field>
<field name="score" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_request"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_request_status">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_request_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="descr" type="C" size="50"></field>
</table>
<table name="fm_request_origin">
<desc>Table desc</desc>
- <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin" type="C" size="10"><NOTNULL/><KEY/></field>
<field name="origin_id" type="I"><NOTNULL/><KEY/></field>
<field name="request_id" type="I"><NOTNULL/><KEY/></field>
<field name="entry_date" type="I"></field>
@@ -593,16 +593,16 @@
<table name="fm_ns3420">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="tekst1" type="V" size="50"></field>
- <field name="enhet" type="V" size="6"></field>
- <field name="tekst2" type="V" size="50"></field>
- <field name="tekst3" type="V" size="50"></field>
- <field name="tekst4" type="V" size="50"></field>
- <field name="tekst5" type="V" size="50"></field>
- <field name="tekst6" type="V" size="50"></field>
- <field name="parent" type="V" size="20"></field>
- <field name="type" type="V" size="20"></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="tekst1" type="C" size="50"></field>
+ <field name="enhet" type="C" size="6"></field>
+ <field name="tekst2" type="C" size="50"></field>
+ <field name="tekst3" type="C" size="50"></field>
+ <field name="tekst4" type="C" size="50"></field>
+ <field name="tekst5" type="C" size="50"></field>
+ <field name="tekst6" type="C" size="50"></field>
+ <field name="parent" type="C" size="20"></field>
+ <field name="type" type="C" size="20"></field>
</table>
@@ -613,35 +613,35 @@
<field name="priority" type="I"><NOTNULL/></field>
<field name="user_id" type="I"></field>
<field name="assignedto" type="I"></field>
- <field name="subject" type="V" size="255"></field>
+ <field name="subject" type="C" size="255"></field>
<field name="cat_id" type="I"></field>
<field name="billable_hours" type="N" size="8.2"></field>
<field name="billable_rate" type="N" size="8.2"></field>
<field name="status" type="C" size="1"><NOTNULL/></field>
<field name="details" type="X"><NOTNULL/></field>
- <field name="location_code" type="V" size="50"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="location_code" type="C" size="50"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="floor" type="V" size="6"></field>
- <field name="address" type="V" size="100"></field>
- <field name="contact_phone" type="V" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="floor" type="C" size="6"></field>
+ <field name="address" type="C" size="100"></field>
+ <field name="contact_phone" type="C" size="20"></field>
<field name="tenant_id" type="I"></field>
<field name="entry_date" type="I"></field>
<field name="finnish_date" type="I"></field>
<field name="finnish_date2" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_tts_tickets"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_tts_views">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/></field>
- <field name="account_id" type="V" size="40"></field>
+ <field name="account_id" type="C" size="40"></field>
<field name="time" type="I"><NOTNULL/></field>
</table>
@@ -649,19 +649,17 @@
<table name="fm_tts_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_ecoart">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
-
-
<table name="fm_ecoavvik">
<desc>Table desc</desc>
<field name="bilagsnr" type="I"><NOTNULL/><KEY/></field>
@@ -670,11 +668,11 @@
<field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
<field name="artid" type="I"><NOTNULL/></field>
<field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
- <field name="spvend_code" type="V" size="12"></field>
- <field name="oppsynsmannid" type="V" size="12"></field>
- <field name="saksbehandlerid" type="V" size="12"></field>
- <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
- <field name="utbetalingid" type="V" size="12"></field>
+ <field name="spvend_code" type="C" size="12"></field>
+ <field name="oppsynsmannid" type="C" size="12"></field>
+ <field name="saksbehandlerid" type="C" size="12"></field>
+ <field name="budsjettansvarligid" type="C"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="C" size="12"></field>
<field name="oppsynsigndato" type="timestamp"></field>
<field name="saksigndato" type="timestamp"></field>
<field name="budsjettsigndato" type="timestamp"></field>
@@ -688,7 +686,7 @@
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/><KEY/></field>
<field name="bilagsnr" type="I"><NOTNULL/></field>
- <field name="kidnr" type="V" size="30"></field>
+ <field name="kidnr" type="C" size="30"></field>
<field name="typeid" type="I"><NOTNULL/></field>
<field name="kildeid" type="I"><NOTNULL/></field>
<field name="pmwrkord_code" type="I"></field>
@@ -696,21 +694,21 @@
<field name="fakturadato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
<field name="periode" type="I"></field>
<field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
- <field name="fakturanr" type="V" size="15"><NOTNULL/></field>
- <field name="spbudact_code" type="V" size="30"></field>
+ <field name="fakturanr" type="C" size="15"><NOTNULL/></field>
+ <field name="spbudact_code" type="C" size="30"></field>
<field name="regtid" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
<field name="artid" type="I"><NOTNULL/></field>
<field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
- <field name="spvend_code" type="V" size="12"></field>
- <field name="dima" type="V" size="20"></field>
- <field name="loc1" type="V" size="10"></field>
+ <field name="spvend_code" type="C" size="12"></field>
+ <field name="dima" type="C" size="20"></field>
+ <field name="loc1" type="C" size="10"></field>
<field name="dimb" type="I"></field>
<field name="mvakode" type="I"></field>
- <field name="dimd" type="V" size="5"></field>
- <field name="oppsynsmannid" type="V" size="12"></field>
- <field name="saksbehandlerid" type="V" size="12"></field>
- <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
- <field name="utbetalingid" type="V" size="12"></field>
+ <field name="dimd" type="C" size="5"></field>
+ <field name="oppsynsmannid" type="C" size="12"></field>
+ <field name="saksbehandlerid" type="C" size="12"></field>
+ <field name="budsjettansvarligid" type="C"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="C" size="12"></field>
<field name="oppsynsigndato" type="timestamp"></field>
<field name="saksigndato" type="timestamp"></field>
<field name="budsjettsigndato" type="timestamp"></field>
@@ -725,7 +723,7 @@
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
<field name="bilagsnr" type="I"><NOTNULL/></field>
- <field name="kidnr" type="V" size="30"></field>
+ <field name="kidnr" type="C" size="30"></field>
<field name="typeid" type="I"><NOTNULL/></field>
<field name="kildeid" type="I"><NOTNULL/></field>
<field name="pmwrkord_code" type="I"></field>
@@ -733,21 +731,21 @@
<field name="fakturadato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
<field name="periode" type="I"></field>
<field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
- <field name="fakturanr" type="V" size="15"><NOTNULL/></field>
- <field name="spbudact_code" type="V" size="30"></field>
+ <field name="fakturanr" type="C" size="15"><NOTNULL/></field>
+ <field name="spbudact_code" type="C" size="30"></field>
<field name="regtid" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
<field name="artid" type="I"><NOTNULL/></field>
<field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
- <field name="spvend_code" type="V" size="12"></field>
- <field name="dima" type="V" size="20"></field>
- <field name="loc1" type="V" size="10"></field>
+ <field name="spvend_code" type="C" size="12"></field>
+ <field name="dima" type="C" size="20"></field>
+ <field name="loc1" type="C" size="10"></field>
<field name="dimb" type="I"></field>
<field name="mvakode" type="I"></field>
- <field name="dimd" type="V" size="5"></field>
- <field name="oppsynsmannid" type="V" size="12"></field>
- <field name="saksbehandlerid" type="V" size="12"></field>
- <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
- <field name="utbetalingid" type="V" size="12"></field>
+ <field name="dimd" type="C" size="5"></field>
+ <field name="oppsynsmannid" type="C" size="12"></field>
+ <field name="saksbehandlerid" type="C" size="12"></field>
+ <field name="budsjettansvarligid" type="C"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="C" size="12"></field>
<field name="oppsynsigndato" type="timestamp"></field>
<field name="saksigndato" type="timestamp"></field>
<field name="budsjettsigndato" type="timestamp"></field>
@@ -756,7 +754,7 @@
<field name="ordrebelop" type="N" size="20.2"
default="0"><NOTNULL/></field>
<field name="merknad" type="X"></field>
<field name="splitt" type="I"></field>
- <field name="filnavn" type="V" size="255"><NOTNULL/></field>
+ <field name="filnavn" type="C" size="255"><NOTNULL/></field>
<field name="kreditnota" type="I"></field>
</table>
@@ -765,7 +763,7 @@
<table name="fm_ecobilagkilde">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
@@ -774,7 +772,7 @@
<table name="fm_ecobilagtype">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
@@ -783,7 +781,7 @@
<table name="fm_ecodimb">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
@@ -791,8 +789,8 @@
<table name="fm_ecodimd">
<desc>Table desc</desc>
- <field name="id" type="V" size="5"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="id" type="C" size="5"><NOTNULL/><KEY/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
@@ -801,7 +799,7 @@
<table name="fm_ecomva">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
<field name="description" type="X"></field>
</table>
@@ -811,7 +809,7 @@
<field name="batchid" type="I"><NOTNULL/></field>
<field name="ecobilagid" type="I"></field>
<field name="status" type="I"></field>
- <field name="melding" type="V" size="255"></field>
+ <field name="melding" type="C" size="255"></field>
<field name="tid" type="timestamp"></field>
</table>
@@ -819,8 +817,8 @@
<table name="fm_ecouser">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="lid" type="V" size="25"><NOTNULL/></field>
- <field name="initials" type="V" size="6"></field>
+ <field name="lid" type="C" size="25"><NOTNULL/></field>
+ <field name="initials" type="C" size="6"></field>
</table>
@@ -831,7 +829,7 @@
<field name="grantor" type="I"></field>
<field name="grantor_type" type="C" size="1"></field>
<field name="acl_account" type="I"
default="0"><NOTNULL/></field>
- <field name="acl_location" type="V"
size="255"><NOTNULL/></field>
+ <field name="acl_location" type="C"
size="255"><NOTNULL/></field>
<field name="acl_rights" type="I"></field>
<field name="acl_type" type="I" default="0"><NOTNULL/></field>
<field name="acl_data " type="X"></field>
@@ -861,41 +859,41 @@
<table name="fm_project">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="255"><NOTNULL/></field>
+ <field name="name" type="C" size="255"><NOTNULL/></field>
<field name="user_id" type="I"><NOTNULL/></field>
- <field name="access" type="V" size="7"></field>
+ <field name="access" type="C" size="7"></field>
<field name="category" type="I"><NOTNULL/></field>
<field name="entry_date" type="I"><NOTNULL/></field>
<field name="start_date" type="I"><NOTNULL/></field>
<field name="end_date" type="I"><NOTNULL/></field>
<field name="coordinator" type="I"><NOTNULL/></field>
- <field name="status" type="V" size="20"
default="active"><NOTNULL/></field>
+ <field name="status" type="C" size="20"
default="active"><NOTNULL/></field>
<field name="descr" type="X"></field>
<field name="budget" type="N" size="20.2"
default="0.00"></field>
<field name="reserve" type="N" size="20.2"
default="0.00"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="100"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="100"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="20"></field>
+ <field name="contact_phone" type="C" size="20"></field>
<field name="key_fetch" type="I"></field>
<field name="key_deliver" type="I"></field>
- <field name="other_branch" type="V" size="255"></field>
+ <field name="other_branch" type="C" size="255"></field>
<field name="key_responsible" type="I"></field>
<field name="charge_tenant" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_project"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_project_origin">
<desc>Table desc</desc>
- <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin" type="C" size="10"><NOTNULL/><KEY/></field>
<field name="origin_id" type="I"><NOTNULL/><KEY/></field>
<field name="project_id" type="I"><NOTNULL/><KEY/></field>
<field name="entry_date" type="I"></field>
@@ -914,27 +912,27 @@
<table name="fm_investment">
<desc>Table desc</desc>
- <field name="entity_id" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="entity_id" type="C"
size="20"><NOTNULL/><KEY/></field>
<field name="invest_id" type="I"><NOTNULL/><KEY/></field>
- <field name="entity_type" type="V" size="20"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="entity_type" type="C" size="20"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
- <field name="descr" type="V" size="255"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
+ <field name="descr" type="C" size="255"></field>
<field name="writeoff_year" type="I"></field>
- <index
name="location_code"><col>location_code</col><col>entity_id</col><UNIQUE/></index>
+ <index
name="i_location_code_investment"><col>location_code</col><col>entity_id</col><UNIQUE/></index>
</table>
<table name="fm_investment_value">
<desc>Table desc</desc>
- <field name="entity_id" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="entity_id" type="C"
size="20"><NOTNULL/><KEY/></field>
<field name="invest_id" type="I"><NOTNULL/><KEY/></field>
<field name="index_count" type="I"><NOTNULL/><KEY/></field>
<field name="current_index" type="I"></field>
@@ -947,62 +945,62 @@
<table name="fm_idgenerator">
<desc>Table desc</desc>
- <field name="name" type="V" size="30"><NOTNULL/><KEY/></field>
+ <field name="name" type="C" size="30"><NOTNULL/><KEY/></field>
<field name="value" type="I"><NOTNULL/></field>
<field name="increment" type="I"></field>
<field name="maxvalue" type="I"></field>
- <field name="descr" type="V" size="30"></field>
+ <field name="descr" type="C" size="30"></field>
</table>
<table name="fm_document">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="title" type="V" size="50"></field>
- <field name="document_name" type="V" size="50"></field>
+ <field name="title" type="C" size="50"></field>
+ <field name="document_name" type="C" size="50"></field>
<field name="link" type="X"></field>
- <field name="descr" type="V" size="255"></field>
- <field name="version" type="V" size="10"></field>
+ <field name="descr" type="C" size="255"></field>
+ <field name="version" type="C" size="10"></field>
<field name="document_date" type="I"></field>
<field name="entry_date" type="I"></field>
- <field name="status" type="V" size="10"></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="status" type="C" size="10"></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V"
size="20"><NOTNULL/></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C"
size="20"><NOTNULL/></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="coordinator" type="I"></field>
<field name="vendor_id" type="I"></field>
<field name="branch_id" type="I"></field>
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
- <field name="access" type="V" size="7"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <field name="access" type="C" size="7"></field>
+ <index
name="i_location_code_document"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_document_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="descr" type="C" size="50"></field>
</table>
<table name="fm_document_status">
<desc>Table desc</desc>
- <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="id" type="C" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_acl_location">
<desc>Table desc</desc>
- <field name="id" type="V" size="12"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="50"><NOTNULL/></field>
+ <field name="id" type="C" size="12"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="50"><NOTNULL/></field>
<field name="allow_grant" type="I"></field>
</table>
@@ -1011,7 +1009,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1023,7 +1021,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1035,7 +1033,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1047,7 +1045,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1059,7 +1057,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1071,7 +1069,7 @@
<desc>Table desc</desc>
<field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="history_record_id" type="I"><NOTNULL/></field>
- <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_appname" type="C"
size="64"><NOTNULL/></field>
<field name="history_owner" type="I"><NOTNULL/></field>
<field name="history_status" type="C"
size="2"><NOTNULL/></field>
<field name="history_new_value" type="X"><NOTNULL/></field>
@@ -1083,9 +1081,9 @@
<desc>Table desc</desc>
<field name="owner_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
<field name="abid" type="I"><NOTNULL/></field>
- <field name="org_name" type="V" size="50"><NOTNULL/></field>
+ <field name="org_name" type="C" size="50"><NOTNULL/></field>
<field name="category" type="I"><NOTNULL/></field>
- <field name="remark" type="V" size="255"></field>
+ <field name="remark" type="C" size="255"></field>
<field name="entry_date" type="I"></field>
</table>
@@ -1094,13 +1092,13 @@
<table name="fm_owner_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
<table name="fm_cache">
<desc>Table desc</desc>
- <field name="name" type="V" size="50"><NOTNULL/><KEY/></field>
+ <field name="name" type="C" size="50"><NOTNULL/><KEY/></field>
<field name="value" type="X"></field>
</table>
@@ -1108,8 +1106,8 @@
<table name="fm_entity">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"><NOTNULL/></field>
- <field name="descr" type="V" size="50"></field>
+ <field name="name" type="C" size="20"><NOTNULL/></field>
+ <field name="descr" type="C" size="50"></field>
<field name="location_form" type="I"></field>
<field name="documentation" type="I"></field>
<field name="lookup_entity" type="X"></field>
@@ -1121,17 +1119,17 @@
<field name="entity_id" type="I"><NOTNULL/><KEY/></field>
<field name="cat_id" type="I"><NOTNULL/><KEY/></field>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="column_name" type="V" size="20"><NOTNULL/></field>
- <field name="input_text" type="V" size="50"><NOTNULL/></field>
- <field name="statustext" type="V" size="150"><NOTNULL/></field>
- <field name="datatype" type="V" size="2"><NOTNULL/></field>
+ <field name="column_name" type="C" size="20"><NOTNULL/></field>
+ <field name="input_text" type="C" size="50"><NOTNULL/></field>
+ <field name="statustext" type="C" size="150"><NOTNULL/></field>
+ <field name="datatype" type="C" size="2"><NOTNULL/></field>
<field name="list" type="I"></field>
<field name="attrib_sort" type="I"></field>
<field name="size" type="I"></field>
<field name="precision_" type="I"></field>
<field name="scale" type="I"></field>
- <field name="default_value" type="V" size="20"></field>
- <field name="nullable" type="V" size="5"></field>
+ <field name="default_value" type="C" size="20"></field>
+ <field name="nullable" type="C" size="5"></field>
</table>
@@ -1139,9 +1137,9 @@
<desc>Table desc</desc>
<field name="entity_id" type="I"><NOTNULL/><KEY/></field>
<field name="id" type="I"><NOTNULL/><KEY/></field>
- <field name="name" type="V" size="20"></field>
- <field name="descr" type="V" size="50"></field>
- <field name="prefix" type="V" size="50"></field>
+ <field name="name" type="C" size="20"></field>
+ <field name="descr" type="C" size="50"></field>
+ <field name="prefix" type="C" size="50"></field>
<field name="lookup_tenant" type="I"></field>
<field name="tracking" type="I"></field>
<field name="location_level" type="I"></field>
@@ -1163,14 +1161,14 @@
<table name="fm_entity_lookup">
<desc>Table desc</desc>
<field name="entity_id" type="I"><NOTNULL/><KEY/></field>
- <field name="location" type="V"
size="15"><NOTNULL/><KEY/></field>
- <field name="type" type="V" size="15"><NOTNULL/><KEY/></field>
+ <field name="location" type="C"
size="15"><NOTNULL/><KEY/></field>
+ <field name="type" type="C" size="15"><NOTNULL/><KEY/></field>
</table>
<table name="fm_entity_origin">
<desc>Table desc</desc>
- <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin" type="C" size="10"><NOTNULL/><KEY/></field>
<field name="origin_id" type="I"><NOTNULL/><KEY/></field>
<field name="entity_id" type="I"><NOTNULL/><KEY/></field>
<field name="cat_id" type="I"><NOTNULL/><KEY/></field>
@@ -1182,107 +1180,107 @@
<table name="fm_entity_1_1">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="num" type="V" size="16"><NOTNULL/></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="num" type="C" size="16"><NOTNULL/></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="30"></field>
+ <field name="contact_phone" type="C" size="30"></field>
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
- <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute1" type="C" size="12"></field>
<field name="attribute2" type="timestamp"></field>
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_1_1"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_entity_1_2">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="num" type="V" size="16"><NOTNULL/></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="num" type="C" size="16"><NOTNULL/></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="30"></field>
+ <field name="contact_phone" type="C" size="30"></field>
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
- <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute1" type="C" size="12"></field>
<field name="attribute2" type="timestamp"></field>
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_1_2"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_entity_2_1">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="num" type="V" size="16"><NOTNULL/></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="num" type="C" size="16"><NOTNULL/></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="30"></field>
+ <field name="contact_phone" type="C" size="30"></field>
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
- <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute1" type="C" size="12"></field>
<field name="attribute2" type="timestamp"></field>
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_2_1"><col>location_code</col><UNIQUE/></index>
</table>
<table name="fm_entity_2_2">
<desc>Table desc</desc>
<field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
- <field name="num" type="V" size="16"><NOTNULL/></field>
- <field name="p_num" type="V" size="15"></field>
+ <field name="num" type="C" size="16"><NOTNULL/></field>
+ <field name="p_num" type="C" size="15"></field>
<field name="p_entity_id" type="I"></field>
<field name="p_cat_id" type="I"></field>
- <field name="location_code" type="V" size="20"></field>
- <field name="loc1" type="V" size="4"></field>
- <field name="loc2" type="V" size="4"></field>
- <field name="loc3" type="V" size="4"></field>
- <field name="loc4" type="V" size="4"></field>
- <field name="address" type="V" size="50"></field>
+ <field name="location_code" type="C" size="20"></field>
+ <field name="loc1" type="C" size="4"></field>
+ <field name="loc2" type="C" size="4"></field>
+ <field name="loc3" type="C" size="4"></field>
+ <field name="loc4" type="C" size="4"></field>
+ <field name="address" type="C" size="50"></field>
<field name="tenant_id" type="I"></field>
- <field name="contact_phone" type="V" size="30"></field>
+ <field name="contact_phone" type="C" size="30"></field>
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
<field name="status" type="I"></field>
- <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute1" type="C" size="12"></field>
<field name="attribute2" type="timestamp"></field>
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_2_2"><col>location_code</col><UNIQUE/></index>
</table>
</schema>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.3,
nomail <=