-
Notifications
You must be signed in to change notification settings - Fork 0
/
karani.sqbpro
13 lines (13 loc) · 2.82 KB
/
karani.sqbpro
1
2
3
4
5
6
7
8
9
10
11
12
13
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="/Users/kaushik/Desktop/CS/narada/karani.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="1850"/><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,5:mainPOSTS"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="LOCATIONS" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="113"/><column index="2" value="290"/><column index="3" value="300"/><column index="4" value="104"/><column index="5" value="114"/><column index="6" value="53"/><column index="7" value="79"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="POSTS" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort><column index="3" mode="1"/></sort><column_widths><column index="1" value="76"/><column index="2" value="63"/><column index="3" value="50"/><column index="4" value="47"/><column index="5" value="62"/><column index="6" value="73"/><column index="7" value="40"/><column index="8" value="29"/></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_"><sort/><column_widths><column index="1" value="82"/><column index="2" value="117"/><column index="3" value="160"/><column index="4" value="300"/><column index="5" value="224"/><column index="6" value="85"/><column index="7" value="91"/></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">CREATE TABLE "POSTS" (
"post_id" TEXT NOT NULL,
"timestamp" TEXT NOT NULL,
"location" TEXT,
"user_id" TEXT NOT NULL,
"like_count" INTEGER NOT NULL,
"caption_text" TEXT NOT NULL,
"media" TEXT NOT NULL,
"title" INTEGER,
FOREIGN KEY("location") REFERENCES "LOCATIONS"("id"),
FOREIGN KEY("user_id") REFERENCES "USER"("id"),
PRIMARY KEY("post_id")
)</sql><current_tab id="0"/></tab_sql></sqlb_project>