-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfinancial_tracker.sqbpro
More file actions
3 lines (3 loc) · 4.14 KB
/
Copy pathfinancial_tracker.sqbpro
File metadata and controls
3 lines (3 loc) · 4.14 KB
1
2
3
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="financial_tracker.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="0"/></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="1734"/><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="spend" custom_title="0" dock_id="2" table="4,5:mainspend"/><table title="spend" custom_title="0" dock_id="1" table="4,5:mainspend"/><table title="user" custom_title="0" dock_id="9" table="4,4:mainuser"/><table title="category" custom_title="0" dock_id="7" table="4,8:maincategory"/><table title="category" custom_title="0" dock_id="8" table="4,8:maincategory"/><dock_state state="000000ff00000000fd000000010000000200000536000003acfc0100000001fc00000000000005360000010100fffffffa000000000100000005fb000000160064006f0063006b00420072006f00770073006500310100000000ffffffff0000010100fffffffb000000160064006f0063006b00420072006f00770073006500320100000000ffffffff0000010100fffffffb000000160064006f0063006b00420072006f00770073006500370100000000ffffffff0000010100fffffffb000000160064006f0063006b00420072006f00770073006500380100000000ffffffff0000010100fffffffb000000160064006f0063006b00420072006f00770073006500390100000000ffffffff0000010100ffffff000005360000000000000004000000040000000800000008fc00000000"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="category" 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="21"/><column index="2" value="109"/><column index="3" value="50"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="spend" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="21"/><column index="2" value="58"/><column index="3" value="57"/><column index="4" value="82"/></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="44"/><column index="2" value="32"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="transaction" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="21"/><column index="2" value="82"/><column index="3" value="68"/><column index="4" value="37"/><column index="5" value="58"/><column index="6" value="38"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="user" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort><column index="4" mode="0"/></sort><column_widths><column index="1" value="21"/><column index="2" value="156"/><column index="3" value="65"/><column index="4" value="71"/><column index="5" value="181"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table></browse_table_settings></tab_browse><tab_sql><sql name="SQL 1">ALTER TABLE income ADD COLUMN date DATETIME DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE spend ADD COLUMN date DATETIME DEFAULT CURRENT_TIMESTAMP;</sql><sql name="SQL 2"></sql><sql name="SQL 3"></sql><sql name="SQL 4">ALTER TABLE income ADD COLUMN date DATETIME;
ALTER TABLE spend ADD COLUMN date DATETIME;</sql><current_tab id="3"/></tab_sql></sqlb_project>