MCP Starter for Puch AI

SQLite format 3

@ 
.� �p � � �w) � �Y�S�V/
qindexix_runitem_run_idrunitemCREATE INDEX ix_runitem_run_id ON runitem (run_id)\3
yindexix_runitem_platformrunitemCREATE INDEX ix_runitem_platform ON runitem (platform)�% 
�!tablerunitemrunitemCREATE TABLE runitem ( id INTEGER NOT NULL, run_id INTEGER NOT NULL, platform VARCHAR NOT NULL, raw_answer VARCHAR NOT NULL, mentions_json VARCHAR NOT NULL, citations_json VARCHAR NOT NULL, sentiment_json VARCHAR NOT NULL, first_position_brand VARCHAR, stats_json VARCHAR NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), FOREIGN KEY(run_id) REFERENCES run (id) )U-
mindexix_aggregate_dayaggregate CREATE INDEX ix_aggregate_day ON aggregate (day)k;
� indexix_aggregate_user_phoneaggregateCREATE INDEX ix_aggregate_user_phone ON aggregate (user_phone)e 7
�
indexix_aggregate_query_idaggregateCREATE INDEX ix_aggregate_query_id ON aggregate (query_id)�" 
�tableaggregateaggregate CREATE TABLE aggregate ( id INTEGER NOT NULL, user_phone VARCHAR NOT NULL, query_id INTEGER NOT NULL, day VARCHAR NOT NULL, sov_json VARCHAR NOT NULL, sentiment_json VARCHAR NOT NULL, citations_json VARCHAR NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), FOREIGN KEY(user_phone) REFERENCES user (phone), FOREIGN KEY(query_id) REFERENCES trackedquery (id) )L+
iindexix_run_query_idrun CREATE INDEX ix_run_query_id ON run (query_id)R/
qindexix_run_user_phonerunCREATE INDEX ix_run_user_phone ON run (user_phone)�<
�_tablerunrunCREATE TABLE run ( id INTEGER NOT NULL, user_phone VARCHAR NOT NULL, query_id INTEGER NOT NULL, run_at DATETIME NOT NULL, platforms_summary_json VARCHAR NOT NULL, PRIMARY KEY (id), FOREIGN KEY(user_phone) REFERENCES user (phone), FOREIGN KEY(query_id) REFERENCES trackedquery (id) )wA%
�indexix_trackedquery_user_phonetrackedqueryCREATE INDEX ix_trackedquery_user_phone ON trackedquery (user_phone)wA%
�indexix_trackedquery_query_texttrackedqueryCREATE INDEX ix_trackedquery_query_text ON trackedquery (query_text)�!%%
�tabletrackedquerytrackedqueryCREATE TABLE trackedquery ( id INTEGER NOT NULL, user_phone VARCHAR NOT NULL, query_text VARCHAR NOT NULL, competitors_json VARCHAR NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id), FOREIGN KEY(user_phone) REFERENCES user (phone) )N'
oindexix_user_phoneuserCREATE UNIQUE INDEX ix_user_phone ON user (phone)�

�}tableuseruserCREATE TABLE user ( id INTEGER NOT NULL, phone VARCHAR NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) )