[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.7
|
From: |
nomail |
|
Subject: |
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.7 |
|
Date: |
Sun, 23 May 2004 03:23:12 -0000 |
Update of /property/setup
Modified Files:
Branch:
tables.xml
date: 2004/05/01 08:24:46; author: sigurdne; state: Exp; lines: +100 -4
Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.6 property/setup/tables.xml:1.1.1.7
--- property/setup/tables.xml:1.1.1.6 Thu Apr 29 12:50:40 2004
+++ property/setup/tables.xml Sat May 1 08:24:46 2004
@@ -1285,6 +1285,102 @@
<index
name="i_location_code_entity_2_2"><col>location_code</col><UNIQUE/></index>
</table>
+ <table name="fm_vfs">
+ <desc>Table desc</desc>
+ <field name="file_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="owner_id" type="I"><NOTNULL/></field>
+ <field name="createdby_id" type="I"></field>
+ <field name="modifiedby_id" type="I"></field>
+ <field name="created" type="timestamp"
default="'1970-01-01'"><NOTNULL/></field>
+ <field name="modified" type="timestamp"></field>
+ <field name="size" type="I"></field>
+ <field name="mime_type" type="C" size="150"></field>
+ <field name="deleteable" type="C" size="1" default="Y"></field>
+ <field name="comment" type="X"></field>
+ <field name="app" type="C" size="25"></field>
+ <field name="directory" type="X"></field>
+ <field name="name" type="X"><NOTNULL/></field>
+ <field name="link_directory" type="X"></field>
+ <field name="link_name" type="X"></field>
+ <field name="version" type="C" size="30"
default="0.0.0.0"><NOTNULL/></field>
+ <field name="content" type="X"></field>
+ </table>
+
+ <table name="fm_config">
+ <desc>Table desc</desc>
+ <field name="config_app" type="C" size="50"></field>
+ <field name="config_name" type="C"
size="255"><NOTNULL/><KEY/></field>
+ <field name="config_value" type="X"><NOTNULL/></field>
+ </table>
+
+
+
+ <table name="fm_addressbook">
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="lid" type= "C" size="32"></field>
+ <field name="tid" type="C" size="1"></field>
+ <field name="owner" type="I"></field>
+ <field name="access" type= "C" size="7"></field>
+ <field name="cat_id" type= "C" size="32"></field>
+ <field name="fn" type= "C" size="64"></field>
+ <field name="n_family" type= "C" size="64"></field>
+ <field name="n_given" type= "C" size="64"></field>
+ <field name="n_middle" type= "C" size="64"></field>
+ <field name="n_prefix" type= "C" size="64"></field>
+ <field name="n_suffix" type= "C" size="64"></field>
+ <field name="sound" type= "C" size="64"></field>
+ <field name="bday" type= "C" size="32"></field>
+ <field name="note" type="X"></field>
+ <field name="tz" type= "C" size="8"></field>
+ <field name="geo" type= "C" size="32"></field>
+ <field name="url" type= "C" size="128"></field>
+ <field name="pubkey" type="X"></field>
+ <field name="org_name" type= "C" size="64"></field>
+ <field name="org_unit" type= "C" size="64"></field>
+ <field name="title" type= "C" size="64"></field>
+ <field name="adr_one_street" type= "C" size="64"></field>
+ <field name="adr_one_locality" type= "C" size="64"></field>
+ <field name="adr_one_region" type= "C" size="64"></field>
+ <field name="adr_one_postalcode" type= "C" size="64"></field>
+ <field name="adr_one_countryname" type= "C" size="64"></field>
+ <field name="adr_one_type" type= "C" size="32"></field>
+ <field name="label" type="X"></field>
+ <field name="adr_two_street" type= "C" size="64"></field>
+ <field name="adr_two_locality" type= "C" size="64"></field>
+ <field name="adr_two_region" type= "C" size="64"></field>
+ <field name="adr_two_postalcode" type= "C" size="64"></field>
+ <field name="adr_two_countryname" type= "C" size="64"></field>
+ <field name="adr_two_type" type= "C" size="32"></field>
+ <field name="tel_work" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_home" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_voice" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_fax" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_msg" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_cell" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_pager" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_bbs" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_modem" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_car" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_isdn" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_video" type= "C" size="40" default = "+1 (000)
000-0000"><NOTNULL/></field>
+ <field name="tel_prefer" type= "C" size="32"></field>
+ <field name="email" type= "C" size="64"></field>
+ <field name="email_type" type= "C" size="32" default =
"INTERNET"><NOTNULL/></field>
+ <field name="email_home" type= "C" size="64"></field>
+ <field name="email_home_type" type= "C" size="32" default =
"INTERNET"><NOTNULL/></field>
+ <field name="last_mod" type="I"><NOTNULL/></field>
+ </table>
+
+ <table name="fm_addressbook_extra">
+ <field name="contact_id" type="I"></field>
+ <field name="contact_owner" type="I"></field>
+ <field name="contact_name" type= "C" size="255"></field>
+ <field name="contact_value" type="X"></field>
+ </table>
+
+
+
+
<sql>
<query>INSERT INTO fm_workorder_category (id, descr) VALUES (1,
'Preventive')</query>
<query>INSERT INTO fm_workorder_category (id, descr) VALUES (2,
'Ad Hoc')</query>
@@ -1305,9 +1401,9 @@
<query>INSERT INTO fm_location2 ( location_code , loc1 , loc2 ,
loc2_name , entry_date , category, status, user_id , remark )VALUES ('5000-01',
'5000', '01', 'Location name', NULL , '1','1', '6', 'remark')</query>
- <query>INSERT INTO fm_branch (id, num, descr) VALUES (1, 'rør',
'rørlegger')</query>
+ <query>INSERT INTO fm_branch (id, num, descr) VALUES (1, 'ror',
'rorlegger')</query>
<query>INSERT INTO fm_branch (id, num, descr) VALUES (2,
'maler', 'maler')</query>
- <query>INSERT INTO fm_branch (id, num, descr) VALUES (3,
'tomrer', 'Tømrer')</query>
+ <query>INSERT INTO fm_branch (id, num, descr) VALUES (3,
'tomrer', 'Tomrer')</query>
<query>INSERT INTO fm_branch (id, num, descr) VALUES (4,
'renhold', 'Renhold')</query>
<query>INSERT INTO fm_workorder_status (id, descr) VALUES
('active', 'Active')</query>
@@ -1371,8 +1467,8 @@
<query>INSERT INTO fm_acl_location (id, descr, allow_grant)
VALUES ('.entity.2.1', 'Report type 1', 1)</query>
<query>INSERT INTO fm_acl_location (id, descr, allow_grant)
VALUES ('.entity.2.2', 'Report type 2', 1)</query>
- <query>INSERT INTO fm_ns3420 (id, tekst1, enhet) VALUES ('D00',
'RIGGING, KLARGJØRING', 'RS')</query>
- <query>INSERT INTO fm_ns3420 (id, tekst1, enhet,tekst2) VALUES
('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFØRSEL- OG FORSYNINGSANLEGG')</query>
+ <query>INSERT INTO fm_ns3420 (id, tekst1, enhet) VALUES ('D00',
'RIGGING, KLARGJoRING', 'RS')</query>
+ <query>INSERT INTO fm_ns3420 (id, tekst1, enhet,tekst2) VALUES
('D20', 'RIGGING, ANLEGGSTOMT', 'RS','TILFoRSEL- OG FORSYNINGSANLEGG')</query>
<query>INSERT INTO fm_idgenerator (name, value, descr) VALUES
('Bilagsnummer', '2003100000', 'Bilagsnummer')</query>
<query>INSERT INTO fm_idgenerator (name, value, descr) VALUES
('Ecobatchid', '1', 'Ecobatchid')</query>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.7,
nomail <=