[tr,ins]<project>SELECT project_id, project_name FROM project ORDER BY project_id
[tr,ins]<screen>SELECT screen_id, project_id, screen_name FROM screen ORDER BY screen_id
[tr,ins]<designboard>SELECT designboard_id, railtype_id, railstatus_id, screen_id, designboard_inverce, designboard_address, designboard_addres2, designboard_bloknr1, designboard_bloknr2, designboard_top, designboard_left, designboard_changed FROM designboard ORDER BY designboard_id
[tr,ins]<block>SELECT block_id, blocktype_id, project_id, block_number, block_name FROM block ORDER BY block_id
[tr,ins]<turnoutstreet>SELECT turnoutstreet_id, block_id, turnoutstreetstatus_id, turnoutstreet_number, turnoutstreet_name, turnoutstreet_changed FROM turnoutstreet ORDER BY turnoutstreet_id
[tr,ins]<blocklinking>SELECT blocklinking_id, turnoutstreet_id, pastturnoutstreet, nextturnoutstreet, designboard_id, railstatus_id FROM blocklinking ORDER BY blocklinking_id
[tr,ins]<feedback>SELECT feedback_id, turnoutstreet_id, feedbacktype_id, feedbackstatus_id, feedback_address, feedback_function, feedback_changed FROM feedback ORDER BY feedback_id
[tr,ins]<decoder>SELECT decoder_id, decodertype_id, project_id, decoder_address, decoder_virtual FROM decoder ORDER BY decoder_id
[tr,ins]<function>SELECT function_id, function_address, function_virtualaddress, function_name, function_changed, function_activefn, function_activefx, function_function, function_Funcfx, function_name01, function_name02, function_name03, function_name04, function_name05, function_name06, function_name07, function_name08, function_name09, function_name10, function_name11, function_name12, function_name13, function_name14, function_name15, function_name16 FROM function ORDER BY function_id
[tr,ins]<locomotive>SELECT locomotive_id, locomotive_address, locomotive_virtualaddress, function_id, locomotive_changed, locomotive_forward, locomotive_speedcurrent, locomotive_speedmin, locomotive_speedmax, locomotive_speedreal, locomotive_name, locomotive_bitmap, locomotive_memo FROM locomotive ORDER BY locomotive_id
[tr,ins]<trainstructure>SELECT trainstructure_id, trainstructure_name FROM trainstructure ORDER BY trainstructure_id
[tr,ins]<wagon>SELECT wagon_id, project_id, trainstructure_id, wagontype_id, wagon_name, wagon_bitmap, wagon_memo FROM wagon ORDER BY wagon_id
[tr,ins]<train>SELECT train_id, locomotive_id, trainstructure_id, train_changed, train_currentblock, train_destinationblock, train_starttime, train_stoptime FROM train ORDER BY train_id
[tr,ins]<ibstatus>SELECT ibstatus_id, project_id, ibprotocol_id, ibbaudrate_id, ibstatus_version, ibstatus_firmware, ibstatus_status, ibstatus_server, ibstatus_svrstat, ibstatus_changed FROM ibstatus ORDER BY ibstatus_id
[tr,ins]<ibcommand>SELECT ibcommand_id, project_id, ibcommand_command, ibcommand_value, ibcommand_status, ibcommand_priority FROM ibcommand ORDER BY ibcommand_id