database.db.sqbpro

<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="D:/gil/demo/UOB smart project demo/database.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="3"/></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="2036"/><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><current_table name="4,4:maindata"/><default_encoding codec=""/><browse_table_settings/></tab_browse><tab_sql><sql name="SQL 1">-- SELECT data.capture_time,data.image_path,results.label,data.frame_id from data join results ON data.frame_id=results.frame_id ORDER by data.frame_id desc LIMIT 100; 
-- SELECT frame_id,label from results WHERE results.frame_id in (SELECT frame_id from data ORDER by data.frame_id DESC limit 3);
DELETE from data;</sql><current_tab id="0"/></tab_sql></sqlb_project>