[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.4

[nomail]

Update of /property/setup
Modified Files:
        Branch: 
          tables.xml

date: 2004/04/28 08:00:39;  author: sigurdne;  state: Exp;  lines: +217 -0

Log Message:
added default values
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.3 property/setup/tables.xml:1.1.1.4
--- property/setup/tables.xml:1.1.1.3   Wed Apr 28 07:29:17 2004
+++ property/setup/tables.xml   Wed Apr 28 08:00:39 2004
@@ -1283,4 +1283,221 @@
                <field name="attribute5" type="I"></field>
                <index 
name="i_location_code_entity_2_2"><col>location_code</col><UNIQUE/></index>
        </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>
+
+               <query>INSERT INTO fm_meter_category (id, descr) VALUES ('1', 
'Power meter')</query>
+
+               <query>INSERT INTO fm_district (id, descr) VALUES ('1', 
'District 1')</query>
+               <query>INSERT INTO fm_district (id, descr) VALUES ('2', 
'District 2')</query>
+               <query>INSERT INTO fm_district (id, descr) VALUES ('3', 
'District 3')</query>
+
+               <query>INSERT INTO fm_part_of_town (part_of_town_id, name, 
district_id) VALUES ('1', 'Part of town 1','1')</query>
+
+               <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_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>
+
+               <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 (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 (4, 
'renhold', 'Renhold')</query>
+
+               <query>INSERT INTO fm_workorder_status (id, descr) VALUES 
('active', 'Active')</query>
+               <query>INSERT INTO fm_workorder_status (id, descr) VALUES 
('ordered', 'Ordered')</query>
+               <query>INSERT INTO fm_workorder_status (id, descr) VALUES 
('request', 'Request')</query>
+               <query>INSERT INTO fm_workorder_status (id, descr) VALUES 
('closed', 'Closed')</query>
+
+               <query>INSERT INTO fm_request_status (id, descr) VALUES 
('request', 'Request')</query>
+               <query>INSERT INTO fm_request_status (id, descr) VALUES 
('canceled', 'Canceled')</query>
+               <query>INSERT INTO fm_request_status (id, descr) VALUES 
('closed', 'avsluttet')</query>
+
+               <query>INSERT INTO fm_request_priority_key (id, safety, 
aesthetics, indoor_climate, consequential_damage, user_gratification, 
residential_environment, authorities_demands) VALUES (0, 12, 3, 4, 5, 6, 2, 
50)</query>
+
+               <query>INSERT INTO fm_drawing_status (id, descr) VALUES 
('sketch', 'Sketch')</query>
+               <query>INSERT INTO fm_drawing_status (id, descr) VALUES 
('production', 'Production')</query>
+               <query>INSERT INTO fm_drawing_status (id, descr) VALUES 
('asbuilt', 'As built')</query>
+
+               <query>INSERT INTO fm_drawing_category (id, descr) VALUES ('1', 
'Plane')</query>
+               <query>INSERT INTO fm_drawing_category (id, descr) VALUES ('2', 
'Cross section')</query>
+               <query>INSERT INTO fm_drawing_category (id, descr) VALUES ('3', 
'Facade')</query>
+
+               <query>INSERT INTO fm_document_category (id, descr) VALUES 
('1', 'Picture')</query>
+               <query>INSERT INTO fm_document_category (id, descr) VALUES 
('2', 'Report')</query>
+               <query>INSERT INTO fm_document_category (id, descr) VALUES 
('3', 'Instruction')</query>
+
+               <query>INSERT INTO fm_tts_category (id, descr) VALUES ('1', 
'damage')</query>
+               <query>INSERT INTO fm_tts_category (id, descr) VALUES ('2', 
'user request')</query>
+               <query>INSERT INTO fm_tts_category (id, descr) VALUES ('3', 
'warranty')</query>
+
+               <query>INSERT INTO fm_document_status (id, descr) VALUES 
('draft', 'Draft')</query>
+               <query>INSERT INTO fm_document_status (id, descr) VALUES 
('final', 'Final')</query>
+               <query>INSERT INTO fm_document_status (id, descr) VALUES 
('obsolete', 'obsolete')</query>
+
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('m', 
'Meter')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('m2', 
'Square meters')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('m3', 
'Cubic meters')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('km', 
'Kilometre')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('Stk', 
'Stk')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('kg', 
'Kilogram')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('tonn', 
'Tonn')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('h', 
'Hours')</query>
+               <query>INSERT INTO fm_standard_unit (id, descr) VALUES ('RS', 
'Round Sum')</query>
+
+               <query>INSERT INTO fm_agreement_status (id, descr) VALUES 
('closed', 'Closed')</query>
+               <query>INSERT INTO fm_agreement_status (id, descr) VALUES 
('active', 'Active agreement')</query>
+               <query>INSERT INTO fm_agreement_status (id, descr) VALUES 
('planning', 'Planning')</query>
+
+               <query>INSERT INTO fm_acl_location (id, descr, allow_grant) 
VALUES ('.', 'Top', 1)</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>
+               <query>INSERT INTO fm_acl_location (id, descr) VALUES 
('.pricebook', 'Pricebook')</query>
+               <query>INSERT INTO fm_acl_location (id, descr) VALUES 
('.invoice', 'Invoice')</query>
+               <query>INSERT INTO fm_acl_location (id, descr) VALUES 
('.document', 'Documents')</query>
+               <query>INSERT INTO fm_acl_location (id, descr) VALUES 
('.drawing', 'Drawing')</query>
+               <query>INSERT INTO fm_acl_location (id, descr) VALUES 
('.meter', 'Meter')</query>
+               <query>INSERT INTO fm_acl_location (id, descr, allow_grant) 
VALUES ('.entity.1', 'Equipment', 1)</query>
+               <query>INSERT INTO fm_acl_location (id, descr, allow_grant) 
VALUES ('.entity.1.1', 'Elevator', 1)</query>
+               <query>INSERT INTO fm_acl_location (id, descr, allow_grant) 
VALUES ('.entity.1.2', 'Fire alarm central', 1)</query>
+               <query>INSERT INTO fm_acl_location (id, descr, allow_grant) 
VALUES ('.entity.2', 'Report', 1)</query>
+               <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_idgenerator (name, value, descr) VALUES 
('Bilagsnummer', '2003100000', 'Bilagsnummer')</query>
+               <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('Ecobatchid', '1', 'Ecobatchid')</query>
+               <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('project', '1000', 'project')</query>
+               <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('Statuslog', '1', 'Statuslog')</query>
+               <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('workorder', '1000', 'workorder')</query>
+               <query>INSERT INTO fm_idgenerator (name, value, descr) VALUES 
('request', '1000', 'request')</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, 'tenant_id', NULL, 1, 1, NULL, 0, 'fm_tenant', 
'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, '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>
+               <query>INSERT INTO fm_location_type (id, name, descr) VALUES 
(2, 'building', 'Building')</query>
+               <query>INSERT INTO fm_location_type (id, name, descr) VALUES 
(3, 'entrance', 'Entrance')</query>
+               <query>INSERT INTO fm_location_type (id, name, descr) VALUES 
(4, 'apartment', 'Apartment')</query>
+
+               <query>INSERT INTO fm_tenant_category (id, descr) VALUES (1, 
'male')</query>
+               <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_ecoart (id, name, description) VALUES (1, 
'faktura', NULL)</query>
+               <query>INSERT INTO fm_ecoart (id, name, description) VALUES (2, 
'kreditnota', NULL)</query>
+
+               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (1, 'Drift, vedlikehold', NULL)</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (2, 'Prosjekt, Kontrakt', NULL)</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (3, 'Prosjekt, Tillegg', NULL)</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (4, 'Prosjekt, LP-stign', NULL)</query>
+               <query>INSERT INTO fm_ecobilagtype (id, name, description) 
VALUES (5, 'Adminstrasjon', NULL)</query>
+
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (2, 
'Mva 2', NULL)</query>
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (1, 
'Mva 1', NULL)</query>
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (0, 
'ingen', NULL)</query>
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (3, 
'Mva 3', NULL)</query>
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (4, 
'Mva 4', NULL)</query>
+               <query>INSERT INTO fm_ecomva (id, name, description) VALUES (5, 
'Mva 5', 'Renhold')</query>
+
+               <query>INSERT INTO fm_location1_category (id, descr) VALUES (1, 
'SOMETHING')</query>
+               <query>INSERT INTO fm_location1_category (id, descr) VALUES 
(99, 'not active')</query>
+
+               <query>INSERT INTO fm_location2_category (id, descr) VALUES (1, 
'SOMETHING')</query>
+               <query>INSERT INTO fm_location2_category (id, descr) VALUES 
(99, 'not active')</query>
+
+               <query>INSERT INTO fm_location3_category (id, descr) VALUES (1, 
'SOMETHING')</query>
+               <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_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>-->
+
+               <query>INSERT INTO fm_entity_category (entity_id, id, name, 
descr, prefix, lookup_tenant, tracking, location_level) VALUES (1, 1, 
'Elevator', 'Elevator', 'E', NULL, NULL, 3)</query>
+               <query>INSERT INTO fm_entity_category (entity_id, id, name, 
descr, prefix, lookup_tenant, tracking, location_level) VALUES (1, 2, 'Fire 
alarm central', 'Fire alarm central', 'F', NULL, NULL, 3)</query>
+               <query>INSERT INTO fm_entity_category (entity_id, id, name, 
descr, prefix, lookup_tenant, tracking, location_level) VALUES (2, 1, 'Report 
type 1', 'Report type 1', 'RA', 1, 1, 4)</query>
+               <query>INSERT INTO fm_entity_category (entity_id, id, name, 
descr, prefix, lookup_tenant, tracking, location_level) VALUES (2, 2, 'Report 
type 2', 'Report type 2', 'RB', 1, 1, 4)</query>
+
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 2, 'attribute1', 
'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 3, 'attribute2', 
'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 4, 'attribute3', 
'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 5, 'attribute4', 
'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 1, 6, 'attribute5', 
'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 2, 'attribute1', 
'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 3, 'attribute2', 
'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 4, 'attribute3', 
'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 5, 'attribute4', 
'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (1, 2, 6, 'attribute5', 
'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 2, 'attribute1', 
'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 3, 'attribute2', 
'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 4, 'attribute3', 
'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 5, 'attribute4', 
'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 1, 6, 'attribute5', 
'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 1, 'status', 
'Status', 'Status', 'LB', NULL, 1, NULL, NULL, NULL, NULL, 'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 2, 'attribute1', 
'Attribute 1', 'Attribute 1 statustext', 'V', NULL, 2, NULL, 12, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 3, 'attribute2', 
'Attribute 2', 'Attribute 2 status text', 'D', NULL, 3, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 4, 'attribute3', 
'Attribute 3', 'Attribute 3 status text', 'R', NULL, 4, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 5, 'attribute4', 
'Attribute 4', 'Attribute 4 statustext', 'CH', NULL, 5, NULL, NULL, NULL, NULL, 
'True')</query>
+               <query>INSERT INTO fm_entity_attribute (entity_id, cat_id, id, 
column_name, input_text, statustext, datatype, list, attrib_sort, size, 
precision_, scale, default_value, nullable) VALUES (2, 2, 6, 'attribute5', 
'Attribute 5', 'Attribute 5 statustext', 'AB', NULL, 6, NULL, NULL, NULL, NULL, 
'True')</query>
+
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 1, 1, 'status 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 1, 2, 'status 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 4, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 4, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 5, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 1, 5, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 1, 1, 'status 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 1, 2, 'status 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 4, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 4, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 5, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (1, 2, 5, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 1, 1, 'status 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 1, 2, 'status 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 4, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 4, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 5, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 1, 5, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 1, 1, 'status 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 1, 2, 'status 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 4, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 4, 2, 'choice 2')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 5, 1, 'choice 1')</query>
+               <query>INSERT INTO fm_entity_choice (entity_id, cat_id, 
attrib_id, id, value) VALUES (2, 2, 5, 2, 'choice 2')</query>
+
+               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (1, 'project', 'lookup')</query>
+               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (1, 'ticket', 'lookup')</query>
+               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (2, 'request', 'start')</query>
+               <query>INSERT INTO fm_entity_lookup (entity_id, location, type) 
VALUES (2, 'ticket', 'start')</query>
+
+               <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')</query>
+               <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')</query>
+               <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')</query>
+               <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')</query>
+
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (1, 1, 1, 'OK')</query>
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (1, 1, 2, 'Not Active')</query>
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (2, 1, 1, 'OK')</query>
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (2, 1, 2, 'Not Active')</query>
+               <query>INSERT INTO fm_location_choice ( type_id, attrib_id, id, 
value) VALUES (3, 1, 1, 'OK')</query>
+               <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>
+       </sql>  
 </schema>