[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.8
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.8 |
Date: |
Sun, 23 May 2004 12:38:39 -0000 |
Update of /property/setup
Modified Files:
Branch:
tables.xml
date: 2004/05/01 20:00:30; author: sigurdne; state: Exp; lines: +16 -16
Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.7 property/setup/tables.xml:1.1.1.8
--- property/setup/tables.xml:1.1.1.7 Sat May 1 08:24:46 2004
+++ property/setup/tables.xml Sat May 1 20:00:30 2004
@@ -22,7 +22,7 @@
<field name="split" type="I"></field>
<field name="remark" type="C" size="50"></field>
<field name="Spredning" type="I"></field>
- <index
name="i_location_code_gab_location"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_gab_location"><col>location_code</col></index>
</table>
@@ -45,7 +45,7 @@
<field name="entry_date" type="I"></field>
<field name="user_id" type="I"></field>
<field name="remark" type="C" size="255"></field>
- <index
name="i_location_code_meter"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_meter"><col>location_code</col></index>
</table>
<table name="fm_meter_category">
@@ -59,7 +59,7 @@
<desc>Table desc</desc>
<field name="id" type="I"><NOTNULL/><KEY/></field>
<field name="descr" type="C" size="50"><NOTNULL/></field>
- <index name="i_id_streetaddress"><col>id</col><UNIQUE/></index>
+ <index name="i_id_streetaddress"><col>id</col></index>
</table>
@@ -300,7 +300,7 @@
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
<field name="access" type="C" size="7"></field>
- <index
name="i_location_code_drawing"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_drawing"><col>location_code</col></index>
</table>
<table name="fm_drawing_status">
@@ -566,7 +566,7 @@
<field name="c_residential_environment" type="I"></field>
<field name="authorities_demands" type="I"></field>
<field name="score" type="I"></field>
- <index
name="i_location_code_request"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_request"><col>location_code</col></index>
</table>
@@ -635,7 +635,7 @@
<field name="entry_date" type="I"></field>
<field name="finnish_date" type="I"></field>
<field name="finnish_date2" type="I"></field>
- <index
name="i_location_code_tts_tickets"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_tts_tickets"><col>location_code</col></index>
</table>
@@ -888,7 +888,7 @@
<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="i_location_code_project"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_project"><col>location_code</col></index>
</table>
@@ -927,7 +927,7 @@
<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="i_location_code_investment"><col>location_code</col><col>entity_id</col><UNIQUE/></index>
+ <index
name="i_location_code_investment"><col>location_code</col><col>entity_id</col></index>
</table>
@@ -980,7 +980,7 @@
<field name="category" type="I"></field>
<field name="user_id" type="I"></field>
<field name="access" type="C" size="7"></field>
- <index
name="i_location_code_document"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_document"><col>location_code</col></index>
</table>
@@ -1201,7 +1201,7 @@
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="i_location_code_entity_1_1"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_1_1"><col>location_code</col></index>
</table>
@@ -1228,7 +1228,7 @@
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="i_location_code_entity_1_2"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_1_2"><col>location_code</col></index>
</table>
@@ -1255,7 +1255,7 @@
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="i_location_code_entity_2_1"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_2_1"><col>location_code</col></index>
</table>
@@ -1282,7 +1282,7 @@
<field name="attribute3" type="I"></field>
<field name="attribute4" type="X"></field>
<field name="attribute5" type="I"></field>
- <index
name="i_location_code_entity_2_2"><col>location_code</col><UNIQUE/></index>
+ <index
name="i_location_code_entity_2_2"><col>location_code</col></index>
</table>
<table name="fm_vfs">
@@ -1292,7 +1292,7 @@
<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="modified" type="timestamp"
default="'1970-01-01'"></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>
@@ -1517,9 +1517,9 @@
<query>INSERT INTO fm_location3_category (id, descr) VALUES
(99, 'not active')</query>
<query>INSERT INTO fm_location4_category (id, descr) VALUES (1,
'SOMETHING')</query>
- <query>INSERT INTO fm_location4_category (id, descr) VALUES
(99, 'not active')</query>
+ <query>INSERT INTO fm_location4_category (id, descr) VALUES
(99, 'not active')</query>-->
- <query>INSERT INTO fm_entity (id, name, descr, location_form,
documentation) VALUES (1, 'Equipment', 'equipment', 1, 1)</query>-->
+ <query>INSERT INTO fm_entity (id, name, descr, location_form,
documentation) VALUES (1, 'Equipment', 'equipment', 1, 1)</query>
<!-- <query>INSERT INTO fm_entity (id, name, descr, location_form,
documentation, lookup_entity) VALUES (2, 'Report', 'report', 1, NULL,
'a:1:{i:0;s:1:"1";}')</query>-->
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.8,
nomail <=