-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathLocationTrackerDB.sqbpro
11 lines (6 loc) · 3.87 KB
/
LocationTrackerDB.sqbpro
1
2
3
4
5
6
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="C:/Users/joao-/LocationTrackerDB/LocationTrackerDB.db" readonly="0" foreign_keys="1" case_sensitive_like="0" temp_store="0" wal_autocheckpoint="1000" synchronous="2"/><attached/><window><main_tabs open="structure browser pragmas query" current="1"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="1865"/><column_width id="4" width="0"/><expanded_item id="0" parent="1"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><table title="SyncLogs" custom_title="0" dock_id="3" table="4,8:mainSyncLogs"/><table title="Locations" custom_title="0" dock_id="4" table="4,9:mainLocations"/><dock_state state="000000ff00000000fd0000000100000002000003910000024ffc0100000002fc00000000000002380000000000fffffffa000000000100000002fb000000160064006f0063006b00420072006f00770073006500310100000000ffffffff0000000000000000fb000000160064006f0063006b00420072006f00770073006500320100000000ffffffff0000000000000000fc0000000000000391000001f200fffffffa000000010100000002fb000000160064006f0063006b00420072006f00770073006500330100000000ffffffff0000012400fffffffb000000160064006f0063006b00420072006f00770073006500340100000000ffffffff000001f200ffffff0000026f0000000000000004000000040000000800000008fc00000000"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="Devices" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort><column index="0" mode="0"/></sort><column_widths><column index="1" value="62"/><column index="2" value="65"/><column index="3" value="70"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="Locations" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort><column index="1" mode="0"/></sort><column_widths><column index="1" value="70"/><column index="2" value="63"/><column index="3" value="52"/><column index="4" value="61"/><column index="5" value="118"/><column index="6" value="75"/><column index="7" value="75"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="SyncLogs" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="51"/><column index="2" value="63"/><column index="3" value="159"/><column index="4" value="63"/><column index="5" value="130"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="sqlite_sequence" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="79"/><column index="2" value="35"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter><filter value="1"/></global_filter></table></browse_table_settings></tab_browse><tab_sql><sql name="scripts.sql" filename="C:/Users/joao-/LocationTrackerDB/scripts.sql">-- Reference to file "C:/Users/joao-/LocationTrackerDB/scripts.sql" (not supported by this version) --</sql><sql name="SQL 2">INSERT INTO Devices (hostname, ip_address) VALUES ('Device1', '192.168.1.1');
INSERT INTO Locations (id_device, latitude, longitude, datetime_captured, ping_status, saved_local)
VALUES (1, -23.561684, -46.625378, '2024-12-25 10:00:00', 'success', 0);
INSERT INTO SyncLogs (id_device, datetime_synced, status, num_records_synced)
VALUES (1, '2024-12-25 11:00:00', 'success', 10);
</sql><current_tab id="1"/></tab_sql></sqlb_project>