• Home
• org.openwms
• org.openwms.common.service
• 1.7.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

rg.openwms.common.service.1.7.0.source-code.import-DEMO.sql Maven / Gradle / Ivy

-- Accounts
insert into com_account (c_pk,c_pid,c_identifier,c_name,c_default,c_ol,c_created) values (1000,'1000','D','Default',true,0,now());
insert into com_account (c_pk,c_pid,c_identifier,c_name,c_default,c_ol,c_created) values (1001,'1001','A1','Cost Center FIN',false,0,now());

-- LocationTypes
insert into com_location_type (c_pk,c_pid,c_type,c_description,c_height,c_length,c_width,c_ol,c_created,c_updated) values (0,326981811784,'FG','Flat Good Location',20,30,50,0,now(),now());
insert into com_location_type (c_pk,c_pid,c_type,c_description,c_height,c_length,c_width,c_ol,c_created,c_updated) values (1,404376159041,'PG','Pallet Good Location',250,120,120,1,now(),now());

-- LocationGroups
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10000,'ZILE','AVAILABLE','AVAILABLE',80,null,'Company Zile.ch','1','INFEED_AND_OUTFEED',10000,412130127821);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10001,'FLATGOOD_AREA','AVAILABLE','AVAILABLE',80,10000,'Flat Goods in common','1','INFEED_AND_OUTFEED',10001,623275915496);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10002,'FGAUTOMATIC','AVAILABLE','AVAILABLE',80,10001,'Flat Goods automated area','1','INFEED_AND_OUTFEED',10002,709819670512);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10003,'FGRECEIVING','AVAILABLE','AVAILABLE',80,10002,'Receiving area','1','INFEED_AND_OUTFEED',10003,400335177633);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10004,'FGCONV','AVAILABLE','AVAILABLE',80,10002,'Flat goods conveyor system','1','INFEED_AND_OUTFEED',10004,811754978035);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10005,'FGSTOCK','AVAILABLE','AVAILABLE',80,10002,'Highbay area for flat goods','1','INFEED_AND_OUTFEED',10005,212290962584);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10006,'FGAISLE1','AVAILABLE','AVAILABLE',80,10005,'Aisle 1 of the flat goods highbay','1','INFEED_AND_OUTFEED',10006,53242834266);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10007,'FGAISLE1LIFT','AVAILABLE','AVAILABLE',80,10006,'Lift position of craine 1 in the flat goods highbay','1','INFEED_AND_OUTFEED',10007,688238147532);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10008,'FGAISLE1LEFT','AVAILABLE','AVAILABLE',80,10006,'Highbay flat good locations on the left side in aisle 1','1','INFEED_AND_OUTFEED',10008,154549927614);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10009,'FGAISLE1RIGHT','AVAILABLE','AVAILABLE',80,10006,'Highbay flat good locations on the right side in aisle 1','1','INFEED_AND_OUTFEED',10009,108758840458);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10010,'FGAISLE2','AVAILABLE','AVAILABLE',80,10005,'Aisle 2 of the flat goods highbay','1','INFEED_AND_OUTFEED',10010,101671979671);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10011,'FGAISLE2LIFT','AVAILABLE','AVAILABLE',80,10010,'Lift position of craine 2 in the flat goods highbay','1','INFEED_AND_OUTFEED',10011,730288310794);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10012,'FGAISLE2LEFT','AVAILABLE','AVAILABLE',80,10010,'Highbay flat good locations on the left side in aisle 2','1','INFEED_AND_OUTFEED',10012,379640903941);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10013,'FGAISLE2RIGHT','AVAILABLE','AVAILABLE',80,10010,'Highbay flat good locations on the right side in aisle 2','1','INFEED_AND_OUTFEED',10013,209483120518);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10014,'FGSHIPPING','AVAILABLE','AVAILABLE',80,10002,'Flat Goods Shipping area','1','INFEED_AND_OUTFEED',10014,585607846471);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10015,'FGSHIPPING1','AVAILABLE','AVAILABLE',80,10014,'Flat Goods Commissioning area 1','1','INFEED_AND_OUTFEED',10015,881973001220);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10016,'FGWORKPLACE1','AVAILABLE','AVAILABLE',80,10015,'Commissioning workplace 1','1','INFEED_AND_OUTFEED',10016,18642707784);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10017,'FGWORKPLACE2','AVAILABLE','AVAILABLE',80,10015,'Commissioning workplace 2','1','INFEED_AND_OUTFEED',10017,925145263549);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10018,'FGWORKPLACE3','AVAILABLE','AVAILABLE',80,10015,'Commissioning workplace 3','1','INFEED_AND_OUTFEED',10018,346661868774);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10019,'FGSHIPPING2','AVAILABLE','AVAILABLE',80,10014,'Flat Goods Commissioning area 2','1','INFEED_AND_OUTFEED',10019,753422186594);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10020,'FGWORKPLACE4','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 5','1','INFEED_AND_OUTFEED',10020,258953718288);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10021,'FGWORKPLACE5','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 6','1','INFEED_AND_OUTFEED',10021,424924693864);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10022,'FGWORKPLACE6','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 7','1','INFEED_AND_OUTFEED',10022,909419439040);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10023,'FGWORKPLACE7','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 8','1','INFEED_AND_OUTFEED',10023,687300567810);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10024,'FGWORKPLACE8','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 9','1','INFEED_AND_OUTFEED',10024,860334844801);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10025,'FGWORKPLACE9','AVAILABLE','AVAILABLE',80,10019,'Commissioning workplace 10','1','INFEED_AND_OUTFEED',10025,224868263942);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10026,'FGMANUAL','AVAILABLE','AVAILABLE',80,10001,'Flat Goods manual area','1','INFEED_AND_OUTFEED',10026,264924505336);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10027,'FGCANBAN','AVAILABLE','AVAILABLE',80,10001,'Flat Goods canban storage','1','INFEED_AND_OUTFEED',10027,281343921750);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10028,'IPOINT','AVAILABLE','AVAILABLE',80,10000,'I-Point group','1','INFEED_AND_OUTFEED',10028,166982377557);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10029,'IPOINT1','AVAILABLE','AVAILABLE',80,10028,'I-Point 1','1','INFEED_AND_OUTFEED',10029,782120388022);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10030,'IPOINT2','AVAILABLE','AVAILABLE',80,10028,'I-Point 2','1','INFEED_AND_OUTFEED',10030,24417670340);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10031,'PALLET_AREA','AVAILABLE','AVAILABLE',80,10000,'Pallet area','1','INFEED_AND_OUTFEED',10031,878177817968);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10032,'PPICKING','AVAILABLE','AVAILABLE',80,10031,'Pallet picking area','1','INFEED_AND_OUTFEED',10032,306784420810);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10033,'PHIGHBAY','AVAILABLE','AVAILABLE',80,10031,'Pallet highbay','1','INFEED_AND_OUTFEED',10033,43608343999);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10034,'PAISLE1','AVAILABLE','AVAILABLE',80,10033,'Aisle 1 of the pallet highbay','1','INFEED_AND_OUTFEED',10034,500576747031);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10035,'PAISLE1LIFT','AVAILABLE','AVAILABLE',80,10034,'Lift position of craine 1 in the pallet highbay','1','INFEED_AND_OUTFEED',10035,483875811636);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10036,'PAISLE1LEFT','AVAILABLE','AVAILABLE',80,10034,'Highbay pallet locations on the left side in aisle 1','1','INFEED_AND_OUTFEED',10036,443011357014);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10037,'PAISLE1RIGHT','AVAILABLE','AVAILABLE',80,10034,'Highbay pallet locations on the right side in aisle 1','1','INFEED_AND_OUTFEED',10037,332530824417);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10038,'PAISLE2','AVAILABLE','AVAILABLE',80,10033,'Aisle 2 of the pallet highbay','1','INFEED_AND_OUTFEED',10038,999057994469);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10039,'PAISLE2LIFT','AVAILABLE','AVAILABLE',80,10038,'Lift position of craine 2 in the pallet highbay','1','INFEED_AND_OUTFEED',10039,995126472754);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10040,'PAISLE2LEFT','AVAILABLE','AVAILABLE',80,10038,'Highbay pallet locations on the left side in aisle 2','1','INFEED_AND_OUTFEED',10040,48562833846);
insert into com_location_group (c_pk,c_name,c_group_state_in,c_group_state_out,c_max_fill_level,c_parent,c_description,c_group_counting_active,c_op_mode,c_ol,c_pid) values (10041,'PAISLE2RIGHT','AVAILABLE','AVAILABLE',80,10038,'Highbay pallet locations on the right side in aisle 2','1','INFEED_AND_OUTFEED',10041,673781181265);

-- Locations
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1000,'FGIN','CONV','0001','0000','0000','Flatgood conveyor system'           ,'conveyor,flat',1,1,false,10004,0, '0','181160457949',true,true,true,true,'PLC_0001',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1001,'FGIN','CONV','0002','0000','0000','Flatgood conveyor loop'             ,'conveyor,flat',1,1,false,10014,0, '1','164200710058',true,true,true,true,'PLC_0002',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1002,'FGIN','CONV','IN__','0001','0000','Flatgood inbound position'          ,'conveyor,flat',1,1,false,10003,0, '2','917262708951',true,true,true,true,'PLC_0003',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1003,'FGIN','CONV','OUT_','0001','0000','Flatgood outbound position'         ,'conveyor,flat',1,1,false,10004,0, '3','919183566441',true,true,true,true,'PLC_0004',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1004,'FGIN','ERR_','0001','0000','0000','Flatgood error position'            ,'flat',1,1,false,10002,0, '4','599656474784',true,true,true,true,'PLC_0005',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1005,'FGIN','CONV','STCK','0001','IN__','Flatgood aisle 1 infeed'            ,'conveyor,flat',1,1,false,10005,0, '5','266569815226',true,true,true,true,'PLC_0006',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1006,'FGIN','CONV','STCK','0001','OUT_','Flatgood aisle 1 outfeed'           ,'conveyor,flat',1,1,false,10005,0, '6','657531231826',true,true,true,true,'PLC_0007',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1007,'FGIN','CONV','STCK','0002','IN__','Flatgood aisle 2 infeed'            ,'conveyor,flat',1,1,false,10005,0, '7','628639035538',true,true,true,true,'PLC_0008',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1008,'FGIN','CONV','STCK','0002','OUT_','Flatgood aisle 2 outfeed'           ,'conveyor ,flat',1,1,false,10005,0, '8','758665040613',true,true,true,true,'PLC_0009',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1009,'FGIN','0001','0000','0000','0000','Flatgood aisle 1'                   ,'flat',1,1,false,10006,0, '9','537361305039',true,true,true,true,'PLC_0010',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1010,'FGIN','0002','0000','0000','0000','Flatgood aisle 2'                   ,'flat',1,1,false,10010,0,'10','801445454453',true,true,true,true,'PLC_0011',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1011,'FGIN','0001','LIFT','0000','0000','Flatgood aisle 1 lift'              ,'flat',1,1,false,10007,0,'11','798136030917',true,true,true,true,'PLC_0012',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1012,'FGIN','0001','LEFT','0000','0000','Flatgood aisle 1 left rack'         ,'flat',1,1,false,10008,0,'12','896384899357',true,true,true,true,'PLC_0013',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1013,'FGIN','0001','RGHT','0000','0000','Flatgood aisle 1 right rack'        ,'flat',1,1,false,10009,0,'13','111988110139',true,true,true,true,'PLC_0014',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1014,'FGIN','0002','LIFT','0000','0000','Flatgood aisle 2 lift'              ,'flat',1,1,false,10011,0,'14','852306856430',true,true,true,true,'PLC_0015',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1015,'FGIN','0002','LEFT','0000','0000','Flatgood aisle 2 left rack'         ,'flat',1,1,false,10012,0,'15','477193820405',true,true,true,true,'PLC_0016',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1016,'FGIN','0002','RGHT','0000','0000','Flatgood aisle 2 right rack'        ,'flat',1,1,false,10013,0,'16','367699098275',true,true,true,true,'PLC_0017',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1017,'FGIN','PICK','WORK','0001','0000','Picking place 1'                    ,'flat',1,1,false,10016,0,'17','819666829504',true,true,true,true,'PLC_0018',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1018,'FGIN','PICK','WORK','0002','0000','Picking place 2'                    ,'flat',1,1,false,10017,0,'18','234175848538',true,true,true,true,'PLC_0019',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1019,'FGIN','PICK','WORK','0003','0000','Picking place 3'                    ,'flat',1,1,false,10018,0,'19','716281042988',true,true,true,true,'PLC_0020',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1020,'FGIN','PICK','WORK','0004','0000','Picking place 4'                    ,'flat',1,1,false,10020,0,'20','918615490790',true,true,true,true,'PLC_0021',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1021,'FGIN','PICK','WORK','0005','0000','Picking place 5'                    ,'flat',1,1,false,10021,0,'21','722685883984',true,true,true,true,'PLC_0022',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1022,'FGIN','PICK','WORK','0006','0000','Picking place 6'                    ,'flat',1,1,false,10022,0,'22','262863398986',true,true,true,true,'PLC_0023',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1023,'FGIN','PICK','WORK','0007','0000','Picking place 7'                    ,'flat',1,1,false,10023,0,'23','984186159596',true,true,true,true,'PLC_0024',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1024,'FGIN','PICK','WORK','0008','0000','Picking place 8'                    ,'flat',1,1,false,10024,0,'24','258022307027',true,true,true,true,'PLC_0025',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1025,'FGIN','PICK','WORK','0009','0000','Picking place 9'                    ,'flat',1,1,false,10025,0,'25','542937844858',true,true,true,true,'PLC_0026',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1026,'KANB','0000','0000','0000','0000','Kanban area'                        ,'kanban',1,1,false,10027,0,'26','991930755563',true,true,true,true,'PLC_0027',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1027,'MANU','0000','0000','0000','0000','Manual area'                        ,'manual',1,1,false,10026,0,'27','408042025047',true,true,true,true,'PLC_0028',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1028,'INIT','0000','0000','0000','0000','Virtual location for initialization','generic',1,1,false,10000,0,'28','171919359409',true,true,true,true,'PLC_0029',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1029,'EXT_','0000','0000','0000','0000','Virtual location for lost and found','extern',1,1,false,10000,0,'29','113646454019',true,true,true,true,'PLC_0030',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1030,'FGIN','IPNT','0001','0000','0000','I-Point 1'                          ,'flat, ipoint',1,1,false,10029,0,'30','439649733836',true,true,true,true,'PLC_0031',true,now());
insert into com_location (c_pk,c_area,c_aisle,c_x,c_y,c_z,c_description,c_labels,c_location_type,c_no_max_transport_units,c_counting_active,c_location_group,c_plc_state,c_ol,c_pid,c_considered_in_allocation,c_incoming_active,c_outgoing_active,c_lg_counting_active,c_plc_code,c_direct_booking_allowed,c_created) values (1031,'FGIN','IPNT','0002','0000','0000','I-Point 2'                          ,'flat , ipoint',1,1,false,10030,0,'31','227916500906',true,true,true,true,'PLC_0032',true,now());

-- TransportUnitTypes
insert into com_transport_unit_type (c_pk,c_pid,c_type,c_description,c_height,c_length,c_width,c_weight_tare,c_weight_max,c_ol,c_created,c_updated) values (1000,'1000','PALLET','Euro pallet',102,120,80,25,-1,1,now(),now());

-- TransportUnit
insert into com_transport_unit (c_pk,c_pid,c_barcode,c_state,c_actual_location,c_transport_unit_type,c_actual_location_date,c_ol,c_created) values (1000,1,'00000000000000004711','AVAILABLE',1029,1000,now(),1,now());

-- Rules
INSERT INTO com_type_placing_rule(c_pk, c_created, c_ol, c_privilege_level, c_allowed_location_type, c_tut_id) VALUES (1, now(), 0, 0, 1, 1000);