[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.19
|
From: |
nomail |
|
Subject: |
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.19 |
|
Date: |
Sun, 30 May 2004 01:24:32 +0200 |
Update of /property/setup
Modified Files:
Branch:
tables.xml
date: 2004/05/29 23:24:32; author: sigurdne; state: Exp; lines: +111 -16
Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.18 property/setup/tables.xml:1.1.1.19
--- property/setup/tables.xml:1.1.1.18 Tue May 18 17:53:21 2004
+++ property/setup/tables.xml Sat May 29 23:24:32 2004
@@ -71,15 +71,6 @@
<field name="last_name" type="C" size="30"></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>
- <field name="status_drift" type="C" size="2"></field>
- <field name="KontraktTilDato" type="C" size="50"></field>
- <field name="Fornyelseskode" type="I"></field>
- <field name="Undernivaa" type="I"></field>
- <field name="Fornyelseskommentar" type="C" size="150"></field>
- <field name="AntallNklUtlevert" type="I"></field>
- <field name="AntallNklInnlevert" type="I"></field>
</table>
@@ -124,6 +115,58 @@
<field name="value" type="X"><NOTNULL/></field>
</table>
+ <table name="fm_vendor">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="entry_date" type="I"></field>
+ <field name="first_name" type="C" size="30"></field>
+ <field name="last_name" type="C" size="30"></field>
+ <field name="contact_phone" type="C" size="20"></field>
+ <field name="category" type="I"></field>
+ </table>
+
+
+ <table name="fm_vendor_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="C" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_vendor_status">
+ <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="C" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_vendor_attribute">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></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="C" size="100"><NOTNULL/></field>
+ <field name="size" type="I"></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="C" size="20"></field>
+ <field name="nullable" type="C" size="5" default="True"></field>
+ </table>
+
+
+ <table name="fm_vendor_choice">
+ <desc>Table desc</desc>
+ <field name="attrib_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="value" type="X"><NOTNULL/></field>
+ </table>
+
<table name="fm_district">
@@ -444,7 +487,7 @@
<field name="vendor_id" type="I"><NOTNULL/><KEY/></field>
<field name="index_count" type="I"><NOTNULL/><KEY/></field>
<field name="current_index" type="I"></field>
- <field name="this_index" type="N" size="20.2"
default="0.00"></field>
+ <field name="this_index" type="N" size="20.4"
default="0.0000"></field>
<field name="m_cost" type="N" size="20.2"
default="0.00"></field>
<field name="w_cost" type="N" size="20.2"
default="0.00"></field>
<field name="total_cost" type="N" size="20.2"
default="0.00"></field>
@@ -1107,7 +1150,7 @@
<table name="fm_owner">
<desc>Table desc</desc>
- <field name="owner_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="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="C" size="50"><NOTNULL/></field>
<field name="category" type="I"><NOTNULL/></field>
@@ -1115,14 +1158,37 @@
<field name="entry_date" type="I"></field>
</table>
-
-
<table name="fm_owner_category">
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
<field name="descr" type="C" size="255"><NOTNULL/></field>
</table>
+ <table name="fm_owner_attribute">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></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="C" size="100"><NOTNULL/></field>
+ <field name="size" type="I"></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="C" size="20"></field>
+ <field name="nullable" type="C" size="5" default="True"></field>
+ </table>
+
+
+ <table name="fm_owner_choice">
+ <desc>Table desc</desc>
+ <field name="attrib_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="value" type="X"><NOTNULL/></field>
+ </table>
<table name="fm_cache">
<desc>Table desc</desc>
@@ -1405,8 +1471,21 @@
<field name="contact_value" type="X"></field>
</table>
+ <table name="fm_custom">
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type= "C" size="100"><NOTNULL/></field>
+ <field name="sql" type="X"><NOTNULL/></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ </table>
-
+ <table name="fm_custom_cols">
+ <field name="custom_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type= "C" size="100"><NOTNULL/></field>
+ <field name="descr" type= "C" size="100"><NOTNULL/></field>
+ <field name="sorting" type="I"><NOTNULL/></field>
+ </table>
<sql>
<query>INSERT INTO fm_workorder_category (id, descr) VALUES (1,
'Preventive')</query>
@@ -1422,7 +1501,7 @@
<query>INSERT INTO fm_owner_category (id, descr) VALUES ('1',
'Owner category 1')</query>
- <query>INSERT INTO fm_owner (owner_id, abid, org_name,
category) VALUES (1, 1, 'demo-owner 1',1)</query>
+ <query>INSERT INTO fm_owner (id, abid, org_name, category)
VALUES (1, 1, 'demo-owner 1',1)</query>
<query>INSERT INTO fm_location1 ( location_code , loc1 ,
loc1_name , part_of_town_id , entry_date , category ,status, user_id , owner_id
, remark )VALUES ('5000', '5000', 'Location name', '1', NULL , '1','1', '6',
'1', 'remark')</query>
@@ -1480,6 +1559,9 @@
<query>INSERT INTO fm_acl_location (id, descr, allow_grant)
VALUES ('.', 'Top', 1)</query>
<query>INSERT INTO fm_acl_location (id, descr) VALUES
('.tenant', 'Tenant')</query>
+ <query>INSERT INTO fm_acl_location (id, descr) VALUES
('.owner', 'Owner')</query>
+ <query>INSERT INTO fm_acl_location (id, descr) VALUES
('.vendor', 'Vendor')</query>
+ <query>INSERT INTO fm_acl_location (id, descr) VALUES
('.custom', 'Custom queries')</query>
<query>INSERT INTO fm_acl_location (id, descr) VALUES
('.location', 'Location')</query>
<query>INSERT INTO fm_acl_location (id, descr, allow_grant)
VALUES ('.project', 'Demand -> Workorder', 1)</query>
<query>INSERT INTO fm_acl_location (id, descr, allow_grant)
VALUES ('.ticket', 'Helpdesk', 1)</query>
@@ -1506,7 +1588,7 @@
<query>INSERT INTO fm_location_config (location_type,
column_name, input_text, lookup_form, f_key, ref_to_category, query_value,
reference_table, reference_id, datatype, precision_, scale, default_value,
nullable) VALUES (4, 'tenant_id', NULL, 1, 1, NULL, 0, 'fm_tenant', 'id',
'int', 4, NULL, NULL, 'True')</query>
<query>INSERT INTO fm_location_config (location_type,
column_name, input_text, lookup_form, f_key, ref_to_category, query_value,
reference_table, reference_id, datatype, precision_, scale, default_value,
nullable) VALUES (4, 'street_id', NULL, 1, 1, NULL, 1, 'fm_streetaddress',
'id', 'int', 4, NULL, NULL, 'True')</query>
- <query>INSERT INTO fm_location_config (location_type,
column_name, input_text, lookup_form, f_key, ref_to_category, query_value,
reference_table, reference_id, datatype, precision_, scale, default_value,
nullable) VALUES (1, 'owner_id', NULL, NULL, 1, 1, NULL, 'fm_owner',
'owner_id', 'int', 4, NULL, NULL, 'True')</query>
+ <query>INSERT INTO fm_location_config (location_type,
column_name, input_text, lookup_form, f_key, ref_to_category, query_value,
reference_table, reference_id, datatype, precision_, scale, default_value,
nullable) VALUES (1, 'owner_id', NULL, NULL, 1, 1, NULL, 'fm_owner', 'id',
'int', 4, NULL, NULL, 'True')</query>
<query>INSERT INTO fm_location_config (location_type,
column_name, input_text, lookup_form, f_key, ref_to_category, query_value,
reference_table, reference_id, datatype, precision_, scale, default_value,
nullable) VALUES (1, 'part_of_town_id', NULL, NULL, 1, NULL, NULL,
'fm_part_of_town', 'part_of_town_id', 'int', 0, NULL, NULL, 'True')</query>
<query>INSERT INTO fm_location_type (id, name, descr) VALUES
(1, 'property', 'Property')</query>
@@ -1518,6 +1600,10 @@
<query>INSERT INTO fm_tenant_category (id, descr) VALUES (2,
'female')</query>
<query>INSERT INTO fm_tenant_category (id, descr) VALUES (3,
'organization')</query>
+ <query>INSERT INTO fm_tenant_attribute (id, list,
location_form, lookup_form, column_name, input_text, statustext, size,
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (1,
NULL, NULL, NULL, 'first_name', 'First name', 'First name', NULL, 'V', 1, 50,
NULL, NULL, 'True')</query>
+ <query>INSERT INTO fm_tenant_attribute (id, list,
location_form, lookup_form, column_name, input_text, statustext, size,
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (2,
NULL, NULL, NULL, 'last_name', 'Last name', 'Last name', NULL, 'V', 2, 50,
NULL, NULL, 'True')</query>
+ <query>INSERT INTO fm_tenant_attribute (id, list,
location_form, lookup_form, column_name, input_text, statustext, size,
datatype, attrib_sort, precision_, scale, default_value, nullable) VALUES (3,
NULL, NULL, NULL, 'contact_phone', 'contact phone', 'contact phone', NULL, 'V',
3, 20, NULL, NULL, 'True')</query>
+
<query>INSERT INTO fm_ecoart (id, name) VALUES (1,
'faktura')</query>
<query>INSERT INTO fm_ecoart (id, name) VALUES (2,
'kreditnota')</query>
@@ -1623,5 +1709,14 @@
<query>INSERT INTO fm_location_choice ( type_id, attrib_id, id,
value) VALUES (3, 1, 2, 'Not Active')</query>
<query>INSERT INTO fm_location_choice ( type_id, attrib_id, id,
value) VALUES (4, 1, 1, 'OK')</query>
<query>INSERT INTO fm_location_choice ( type_id, attrib_id, id,
value) VALUES (4, 1, 2, 'Not Active')</query>
+
+ <query>INSERT INTO fm_custom (id, name, sql) VALUES (1, 'test
query', 'select * from phpgw_accounts')</query>
+
+ <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr,
sorting) VALUES (1, 1, 'account_id', 'ID', 1)</query>
+ <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr,
sorting) VALUES (1, 2, 'account_lid', 'Lid', 2)</query>
+ <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr,
sorting) VALUES (1, 3, 'account_firstname', 'First Name', 3)</query>
+ <query>INSERT INTO fm_custom_cols (custom_id, id, name, descr,
sorting) VALUES (1, 4, 'account_lastname', 'Last Name', 4)</query>
+
+
</sql>
</schema>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.19,
nomail <=